ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

40,499 rows where state = "North Dakota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • North Dakota · 40,499 ✖
Link rowid date ▲ county state fips cases deaths
2501586 2501586 2022-05-13 Adams North Dakota 38001 598 10
2501587 2501587 2022-05-13 Barnes North Dakota 38003 3024 47
2501588 2501588 2022-05-13 Benson North Dakota 38005 1980 23
2501589 2501589 2022-05-13 Billings North Dakota 38007 145 1
2501590 2501590 2022-05-13 Bottineau North Dakota 38009 1598 26
2501591 2501591 2022-05-13 Bowman North Dakota 38011 828 9
2501592 2501592 2022-05-13 Burke North Dakota 38013 433 3
2501593 2501593 2022-05-13 Burleigh North Dakota 38015 35087 303
2501594 2501594 2022-05-13 Cass North Dakota 38017 59940 333
2501595 2501595 2022-05-13 Cavalier North Dakota 38019 822 7
2501596 2501596 2022-05-13 Dickey North Dakota 38021 1496 39
2501597 2501597 2022-05-13 Divide North Dakota 38023 459 4
2501598 2501598 2022-05-13 Dunn North Dakota 38025 1041 8
2501599 2501599 2022-05-13 Eddy North Dakota 38027 761 6
2501600 2501600 2022-05-13 Emmons North Dakota 38029 728 18
2501601 2501601 2022-05-13 Foster North Dakota 38031 992 23
2501602 2501602 2022-05-13 Golden Valley North Dakota 38033 476 4
2501603 2501603 2022-05-13 Grand Forks North Dakota 38035 22468 125
2501604 2501604 2022-05-13 Grant North Dakota 38037 451 11
2501605 2501605 2022-05-13 Griggs North Dakota 38039 583 2
2501606 2501606 2022-05-13 Hettinger North Dakota 38041 828 8
2501607 2501607 2022-05-13 Kidder North Dakota 38043 510 13
2501608 2501608 2022-05-13 LaMoure North Dakota 38045 1015 20
2501609 2501609 2022-05-13 Logan North Dakota 38047 435 12
2501610 2501610 2022-05-13 McHenry North Dakota 38049 1318 31
2501611 2501611 2022-05-13 McIntosh North Dakota 38051 688 9
2501612 2501612 2022-05-13 McKenzie North Dakota 38053 3272 25
2501613 2501613 2022-05-13 McLean North Dakota 38055 2737 49
2501614 2501614 2022-05-13 Mercer North Dakota 38057 2577 24
2501615 2501615 2022-05-13 Morton North Dakota 38059 11274 142
2501616 2501616 2022-05-13 Mountrail North Dakota 38061 3254 37
2501617 2501617 2022-05-13 Nelson North Dakota 38063 768 18
2501618 2501618 2022-05-13 Oliver North Dakota 38065 329 5
2501619 2501619 2022-05-13 Pembina North Dakota 38067 1996 16
2501620 2501620 2022-05-13 Pierce North Dakota 38069 1065 32
2501621 2501621 2022-05-13 Ramsey North Dakota 38071 3638 57
2501622 2501622 2022-05-13 Ransom North Dakota 38073 1515 28
2501623 2501623 2022-05-13 Renville North Dakota 38075 556 15
2501624 2501624 2022-05-13 Richland North Dakota 38077 4108 23
2501625 2501625 2022-05-13 Rolette North Dakota 38079 6121 43
2501626 2501626 2022-05-13 Sargent North Dakota 38081 1031 9
2501627 2501627 2022-05-13 Sheridan North Dakota 38083 299 7
2501628 2501628 2022-05-13 Sioux North Dakota 38085 1350 19
2501629 2501629 2022-05-13 Slope North Dakota 38087 63 0
2501630 2501630 2022-05-13 Stark North Dakota 38089 11683 86
2501631 2501631 2022-05-13 Steele North Dakota 38091 388 2
2501632 2501632 2022-05-13 Stutsman North Dakota 38093 7113 97
2501633 2501633 2022-05-13 Towner North Dakota 38095 641 12
2501634 2501634 2022-05-13 Traill North Dakota 38097 2205 26
2501635 2501635 2022-05-13 Unknown North Dakota   0 87
2501636 2501636 2022-05-13 Walsh North Dakota 38099 3374 34
2501637 2501637 2022-05-13 Ward North Dakota 38101 20887 251
2501638 2501638 2022-05-13 Wells North Dakota 38103 1018 12
2501639 2501639 2022-05-13 Williams North Dakota 38105 10496 68
2498328 2498328 2022-05-12 Adams North Dakota 38001 598 10
2498329 2498329 2022-05-12 Barnes North Dakota 38003 3012 47
2498330 2498330 2022-05-12 Benson North Dakota 38005 1976 23
2498331 2498331 2022-05-12 Billings North Dakota 38007 143 1
2498332 2498332 2022-05-12 Bottineau North Dakota 38009 1595 26
2498333 2498333 2022-05-12 Bowman North Dakota 38011 828 9
2498334 2498334 2022-05-12 Burke North Dakota 38013 433 3
2498335 2498335 2022-05-12 Burleigh North Dakota 38015 35021 303
2498336 2498336 2022-05-12 Cass North Dakota 38017 59650 333
2498337 2498337 2022-05-12 Cavalier North Dakota 38019 820 7
2498338 2498338 2022-05-12 Dickey North Dakota 38021 1492 39
2498339 2498339 2022-05-12 Divide North Dakota 38023 459 4
2498340 2498340 2022-05-12 Dunn North Dakota 38025 1040 8
2498341 2498341 2022-05-12 Eddy North Dakota 38027 760 6
2498342 2498342 2022-05-12 Emmons North Dakota 38029 728 18
2498343 2498343 2022-05-12 Foster North Dakota 38031 991 23
2498344 2498344 2022-05-12 Golden Valley North Dakota 38033 477 4
2498345 2498345 2022-05-12 Grand Forks North Dakota 38035 22365 125
2498346 2498346 2022-05-12 Grant North Dakota 38037 451 11
2498347 2498347 2022-05-12 Griggs North Dakota 38039 577 2
2498348 2498348 2022-05-12 Hettinger North Dakota 38041 828 8
2498349 2498349 2022-05-12 Kidder North Dakota 38043 508 13
2498350 2498350 2022-05-12 LaMoure North Dakota 38045 1012 20
2498351 2498351 2022-05-12 Logan North Dakota 38047 436 12
2498352 2498352 2022-05-12 McHenry North Dakota 38049 1313 31
2498353 2498353 2022-05-12 McIntosh North Dakota 38051 687 9
2498354 2498354 2022-05-12 McKenzie North Dakota 38053 3267 25
2498355 2498355 2022-05-12 McLean North Dakota 38055 2729 49
2498356 2498356 2022-05-12 Mercer North Dakota 38057 2573 24
2498357 2498357 2022-05-12 Morton North Dakota 38059 11255 142
2498358 2498358 2022-05-12 Mountrail North Dakota 38061 3251 37
2498359 2498359 2022-05-12 Nelson North Dakota 38063 765 18
2498360 2498360 2022-05-12 Oliver North Dakota 38065 329 5
2498361 2498361 2022-05-12 Pembina North Dakota 38067 1987 16
2498362 2498362 2022-05-12 Pierce North Dakota 38069 1062 32
2498363 2498363 2022-05-12 Ramsey North Dakota 38071 3628 57
2498364 2498364 2022-05-12 Ransom North Dakota 38073 1504 28
2498365 2498365 2022-05-12 Renville North Dakota 38075 554 15
2498366 2498366 2022-05-12 Richland North Dakota 38077 4100 23
2498367 2498367 2022-05-12 Rolette North Dakota 38079 6095 43
2498368 2498368 2022-05-12 Sargent North Dakota 38081 1024 9
2498369 2498369 2022-05-12 Sheridan North Dakota 38083 298 7
2498370 2498370 2022-05-12 Sioux North Dakota 38085 1348 19
2498371 2498371 2022-05-12 Slope North Dakota 38087 63 0
2498372 2498372 2022-05-12 Stark North Dakota 38089 11666 86
2498373 2498373 2022-05-12 Steele North Dakota 38091 385 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);