ny_times_us_counties
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 38101 553
- 38015 547
- 38017 547
- 38059 546
- 38069 544
- 38071 544
- 38099 541
- 38025 540
- 38031 539
- 38089 539
- 38049 538
- 38051 538
- 38003 536
- 38023 536
- 38055 536
- 38061 536
- 38085 536
- 38035 534
- 38065 534
- 38037 533
- 38053 533
- 38105 533
- 38013 532
- 38027 530
- 38087 530
- 38029 528
- 38011 526
- 38093 525
- 38077 524
- 38081 523
- …
county >30
- Ward 553
- Burleigh 547
- Cass 547
- Morton 546
- Pierce 544
- Ramsey 544
- Walsh 541
- Dunn 540
- Foster 539
- Stark 539
- McHenry 538
- McIntosh 538
- Barnes 536
- Divide 536
- McLean 536
- Mountrail 536
- Sioux 536
- Grand Forks 534
- Oliver 534
- Grant 533
- McKenzie 533
- Williams 533
- Burke 532
- Eddy 530
- Slope 530
- Emmons 528
- Bowman 526
- Stutsman 525
- Richland 524
- Sargent 523
- …
state 1
- North Dakota · 27,485 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717898 | 1717898 | 2021-09-14 | Adams | North Dakota | 38001 | 320 | 3 |
1717899 | 1717899 | 2021-09-14 | Barnes | North Dakota | 38003 | 1516 | 32 |
1717900 | 1717900 | 2021-09-14 | Benson | North Dakota | 38005 | 1183 | 20 |
1717901 | 1717901 | 2021-09-14 | Billings | North Dakota | 38007 | 59 | 0 |
1717902 | 1717902 | 2021-09-14 | Bottineau | North Dakota | 38009 | 790 | 20 |
1717903 | 1717903 | 2021-09-14 | Bowman | North Dakota | 38011 | 468 | 6 |
1717904 | 1717904 | 2021-09-14 | Burke | North Dakota | 38013 | 264 | 3 |
1717905 | 1717905 | 2021-09-14 | Burleigh | North Dakota | 38015 | 18152 | 208 |
1717906 | 1717906 | 2021-09-14 | Cass | North Dakota | 38017 | 27329 | 218 |
1717907 | 1717907 | 2021-09-14 | Cavalier | North Dakota | 38019 | 481 | 5 |
1717908 | 1717908 | 2021-09-14 | Dickey | North Dakota | 38021 | 855 | 33 |
1717909 | 1717909 | 2021-09-14 | Divide | North Dakota | 38023 | 222 | 2 |
1717910 | 1717910 | 2021-09-14 | Dunn | North Dakota | 38025 | 499 | 7 |
1717911 | 1717911 | 2021-09-14 | Eddy | North Dakota | 38027 | 488 | 6 |
1717912 | 1717912 | 2021-09-14 | Emmons | North Dakota | 38029 | 503 | 14 |
1717913 | 1717913 | 2021-09-14 | Foster | North Dakota | 38031 | 617 | 19 |
1717914 | 1717914 | 2021-09-14 | Golden Valley | North Dakota | 38033 | 295 | 4 |
1717915 | 1717915 | 2021-09-14 | Grand Forks | North Dakota | 38035 | 11561 | 80 |
1717916 | 1717916 | 2021-09-14 | Grant | North Dakota | 38037 | 248 | 7 |
1717917 | 1717917 | 2021-09-14 | Griggs | North Dakota | 38039 | 343 | 2 |
1717918 | 1717918 | 2021-09-14 | Hettinger | North Dakota | 38041 | 378 | 4 |
1717919 | 1717919 | 2021-09-14 | Kidder | North Dakota | 38043 | 304 | 10 |
1717920 | 1717920 | 2021-09-14 | LaMoure | North Dakota | 38045 | 579 | 17 |
1717921 | 1717921 | 2021-09-14 | Logan | North Dakota | 38047 | 286 | 10 |
1717922 | 1717922 | 2021-09-14 | McHenry | North Dakota | 38049 | 724 | 23 |
1717923 | 1717923 | 2021-09-14 | McIntosh | North Dakota | 38051 | 392 | 7 |
1717924 | 1717924 | 2021-09-14 | McKenzie | North Dakota | 38053 | 1871 | 15 |
1717925 | 1717925 | 2021-09-14 | McLean | North Dakota | 38055 | 1478 | 32 |
1717926 | 1717926 | 2021-09-14 | Mercer | North Dakota | 38057 | 1286 | 11 |
1717927 | 1717927 | 2021-09-14 | Morton | North Dakota | 38059 | 5961 | 102 |
1717928 | 1717928 | 2021-09-14 | Mountrail | North Dakota | 38061 | 1600 | 19 |
1717929 | 1717929 | 2021-09-14 | Nelson | North Dakota | 38063 | 513 | 16 |
1717930 | 1717930 | 2021-09-14 | Oliver | North Dakota | 38065 | 165 | 3 |
1717931 | 1717931 | 2021-09-14 | Pembina | North Dakota | 38067 | 954 | 11 |
1717932 | 1717932 | 2021-09-14 | Pierce | North Dakota | 38069 | 623 | 26 |
1717933 | 1717933 | 2021-09-14 | Ramsey | North Dakota | 38071 | 1876 | 31 |
1717934 | 1717934 | 2021-09-14 | Ransom | North Dakota | 38073 | 767 | 17 |
1717935 | 1717935 | 2021-09-14 | Renville | North Dakota | 38075 | 350 | 14 |
1717936 | 1717936 | 2021-09-14 | Richland | North Dakota | 38077 | 2197 | 19 |
1717937 | 1717937 | 2021-09-14 | Rolette | North Dakota | 38079 | 2344 | 28 |
1717938 | 1717938 | 2021-09-14 | Sargent | North Dakota | 38081 | 529 | 7 |
1717939 | 1717939 | 2021-09-14 | Sheridan | North Dakota | 38083 | 130 | 2 |
1717940 | 1717940 | 2021-09-14 | Sioux | North Dakota | 38085 | 730 | 14 |
1717941 | 1717941 | 2021-09-14 | Slope | North Dakota | 38087 | 32 | 0 |
1717942 | 1717942 | 2021-09-14 | Stark | North Dakota | 38089 | 5854 | 52 |
1717943 | 1717943 | 2021-09-14 | Steele | North Dakota | 38091 | 204 | 2 |
1717944 | 1717944 | 2021-09-14 | Stutsman | North Dakota | 38093 | 3865 | 82 |
1717945 | 1717945 | 2021-09-14 | Towner | North Dakota | 38095 | 348 | 11 |
1717946 | 1717946 | 2021-09-14 | Traill | North Dakota | 38097 | 1148 | 18 |
1717947 | 1717947 | 2021-09-14 | Unknown | North Dakota | 32 | 32 | |
1717948 | 1717948 | 2021-09-14 | Walsh | North Dakota | 38099 | 2067 | 27 |
1717949 | 1717949 | 2021-09-14 | Ward | North Dakota | 38101 | 11178 | 207 |
1717950 | 1717950 | 2021-09-14 | Wells | North Dakota | 38103 | 487 | 8 |
1717951 | 1717951 | 2021-09-14 | Williams | North Dakota | 38105 | 5691 | 42 |
1714650 | 1714650 | 2021-09-13 | Adams | North Dakota | 38001 | 319 | 3 |
1714651 | 1714651 | 2021-09-13 | Barnes | North Dakota | 38003 | 1509 | 32 |
1714652 | 1714652 | 2021-09-13 | Benson | North Dakota | 38005 | 1177 | 20 |
1714653 | 1714653 | 2021-09-13 | Billings | North Dakota | 38007 | 59 | 0 |
1714654 | 1714654 | 2021-09-13 | Bottineau | North Dakota | 38009 | 790 | 20 |
1714655 | 1714655 | 2021-09-13 | Bowman | North Dakota | 38011 | 468 | 5 |
1714656 | 1714656 | 2021-09-13 | Burke | North Dakota | 38013 | 264 | 3 |
1714657 | 1714657 | 2021-09-13 | Burleigh | North Dakota | 38015 | 18084 | 207 |
1714658 | 1714658 | 2021-09-13 | Cass | North Dakota | 38017 | 27255 | 218 |
1714659 | 1714659 | 2021-09-13 | Cavalier | North Dakota | 38019 | 479 | 5 |
1714660 | 1714660 | 2021-09-13 | Dickey | North Dakota | 38021 | 854 | 33 |
1714661 | 1714661 | 2021-09-13 | Divide | North Dakota | 38023 | 219 | 2 |
1714662 | 1714662 | 2021-09-13 | Dunn | North Dakota | 38025 | 496 | 7 |
1714663 | 1714663 | 2021-09-13 | Eddy | North Dakota | 38027 | 488 | 6 |
1714664 | 1714664 | 2021-09-13 | Emmons | North Dakota | 38029 | 503 | 14 |
1714665 | 1714665 | 2021-09-13 | Foster | North Dakota | 38031 | 617 | 19 |
1714666 | 1714666 | 2021-09-13 | Golden Valley | North Dakota | 38033 | 295 | 4 |
1714667 | 1714667 | 2021-09-13 | Grand Forks | North Dakota | 38035 | 11535 | 80 |
1714668 | 1714668 | 2021-09-13 | Grant | North Dakota | 38037 | 246 | 7 |
1714669 | 1714669 | 2021-09-13 | Griggs | North Dakota | 38039 | 342 | 2 |
1714670 | 1714670 | 2021-09-13 | Hettinger | North Dakota | 38041 | 376 | 4 |
1714671 | 1714671 | 2021-09-13 | Kidder | North Dakota | 38043 | 304 | 10 |
1714672 | 1714672 | 2021-09-13 | LaMoure | North Dakota | 38045 | 579 | 17 |
1714673 | 1714673 | 2021-09-13 | Logan | North Dakota | 38047 | 286 | 10 |
1714674 | 1714674 | 2021-09-13 | McHenry | North Dakota | 38049 | 721 | 23 |
1714675 | 1714675 | 2021-09-13 | McIntosh | North Dakota | 38051 | 391 | 7 |
1714676 | 1714676 | 2021-09-13 | McKenzie | North Dakota | 38053 | 1864 | 15 |
1714677 | 1714677 | 2021-09-13 | McLean | North Dakota | 38055 | 1472 | 32 |
1714678 | 1714678 | 2021-09-13 | Mercer | North Dakota | 38057 | 1284 | 11 |
1714679 | 1714679 | 2021-09-13 | Morton | North Dakota | 38059 | 5939 | 102 |
1714680 | 1714680 | 2021-09-13 | Mountrail | North Dakota | 38061 | 1595 | 19 |
1714681 | 1714681 | 2021-09-13 | Nelson | North Dakota | 38063 | 512 | 16 |
1714682 | 1714682 | 2021-09-13 | Oliver | North Dakota | 38065 | 165 | 3 |
1714683 | 1714683 | 2021-09-13 | Pembina | North Dakota | 38067 | 953 | 11 |
1714684 | 1714684 | 2021-09-13 | Pierce | North Dakota | 38069 | 621 | 26 |
1714685 | 1714685 | 2021-09-13 | Ramsey | North Dakota | 38071 | 1865 | 31 |
1714686 | 1714686 | 2021-09-13 | Ransom | North Dakota | 38073 | 759 | 17 |
1714687 | 1714687 | 2021-09-13 | Renville | North Dakota | 38075 | 350 | 14 |
1714688 | 1714688 | 2021-09-13 | Richland | North Dakota | 38077 | 2196 | 19 |
1714689 | 1714689 | 2021-09-13 | Rolette | North Dakota | 38079 | 2332 | 28 |
1714690 | 1714690 | 2021-09-13 | Sargent | North Dakota | 38081 | 528 | 7 |
1714691 | 1714691 | 2021-09-13 | Sheridan | North Dakota | 38083 | 130 | 2 |
1714692 | 1714692 | 2021-09-13 | Sioux | North Dakota | 38085 | 728 | 14 |
1714693 | 1714693 | 2021-09-13 | Slope | North Dakota | 38087 | 32 | 0 |
1714694 | 1714694 | 2021-09-13 | Stark | North Dakota | 38089 | 5819 | 52 |
1714695 | 1714695 | 2021-09-13 | Steele | North Dakota | 38091 | 204 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
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);