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 583
- 38015 576
- 38017 576
- 38059 575
- 38069 573
- 38071 573
- 38099 571
- 38025 569
- 38031 568
- 38089 568
- 38049 567
- 38051 567
- 38003 565
- 38023 565
- 38055 565
- 38061 565
- 38085 565
- 38035 563
- 38065 563
- 38105 563
- 38037 562
- 38053 562
- 38013 561
- 38027 559
- 38087 559
- 38029 557
- 38011 555
- 38093 555
- 38077 553
- 38081 552
- …
county >30
- Ward 583
- Burleigh 576
- Cass 576
- Morton 575
- Pierce 573
- Ramsey 573
- Walsh 571
- Dunn 569
- Foster 568
- Stark 568
- McHenry 567
- McIntosh 567
- Barnes 565
- Divide 565
- McLean 565
- Mountrail 565
- Sioux 565
- Grand Forks 563
- Oliver 563
- Williams 563
- Grant 562
- McKenzie 562
- Burke 561
- Eddy 559
- Slope 559
- Emmons 557
- Bowman 555
- Stutsman 555
- Richland 553
- Sargent 552
- …
state 1
- North Dakota · 29,059 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815417 | 1815417 | 2021-10-14 | Stutsman | North Dakota | 38093 | 4251 | 85 |
1815418 | 1815418 | 2021-10-14 | Towner | North Dakota | 38095 | 377 | 11 |
1815419 | 1815419 | 2021-10-14 | Traill | North Dakota | 38097 | 1236 | 19 |
1815420 | 1815420 | 2021-10-14 | Unknown | North Dakota | 34 | 34 | |
1815421 | 1815421 | 2021-10-14 | Walsh | North Dakota | 38099 | 2198 | 29 |
1815422 | 1815422 | 2021-10-14 | Ward | North Dakota | 38101 | 12472 | 212 |
1815423 | 1815423 | 2021-10-14 | Wells | North Dakota | 38103 | 556 | 9 |
1815424 | 1815424 | 2021-10-14 | Williams | North Dakota | 38105 | 6525 | 48 |
1812123 | 1812123 | 2021-10-13 | Adams | North Dakota | 38001 | 359 | 4 |
1812124 | 1812124 | 2021-10-13 | Barnes | North Dakota | 38003 | 1742 | 33 |
1812125 | 1812125 | 2021-10-13 | Benson | North Dakota | 38005 | 1255 | 20 |
1812126 | 1812126 | 2021-10-13 | Billings | North Dakota | 38007 | 88 | 0 |
1812127 | 1812127 | 2021-10-13 | Bottineau | North Dakota | 38009 | 934 | 20 |
1812128 | 1812128 | 2021-10-13 | Bowman | North Dakota | 38011 | 538 | 7 |
1812129 | 1812129 | 2021-10-13 | Burke | North Dakota | 38013 | 292 | 3 |
1812130 | 1812130 | 2021-10-13 | Burleigh | North Dakota | 38015 | 21325 | 223 |
1812131 | 1812131 | 2021-10-13 | Cass | North Dakota | 38017 | 30425 | 230 |
1812132 | 1812132 | 2021-10-13 | Cavalier | North Dakota | 38019 | 520 | 5 |
1812133 | 1812133 | 2021-10-13 | Dickey | North Dakota | 38021 | 945 | 33 |
1812134 | 1812134 | 2021-10-13 | Divide | North Dakota | 38023 | 255 | 2 |
1812135 | 1812135 | 2021-10-13 | Dunn | North Dakota | 38025 | 658 | 7 |
1812136 | 1812136 | 2021-10-13 | Eddy | North Dakota | 38027 | 509 | 6 |
1812137 | 1812137 | 2021-10-13 | Emmons | North Dakota | 38029 | 532 | 15 |
1812138 | 1812138 | 2021-10-13 | Foster | North Dakota | 38031 | 636 | 19 |
1812139 | 1812139 | 2021-10-13 | Golden Valley | North Dakota | 38033 | 328 | 4 |
1812140 | 1812140 | 2021-10-13 | Grand Forks | North Dakota | 38035 | 12518 | 82 |
1812141 | 1812141 | 2021-10-13 | Grant | North Dakota | 38037 | 302 | 7 |
1812142 | 1812142 | 2021-10-13 | Griggs | North Dakota | 38039 | 361 | 2 |
1812143 | 1812143 | 2021-10-13 | Hettinger | North Dakota | 38041 | 452 | 5 |
1812144 | 1812144 | 2021-10-13 | Kidder | North Dakota | 38043 | 347 | 10 |
1812145 | 1812145 | 2021-10-13 | LaMoure | North Dakota | 38045 | 649 | 17 |
1812146 | 1812146 | 2021-10-13 | Logan | North Dakota | 38047 | 315 | 10 |
1812147 | 1812147 | 2021-10-13 | McHenry | North Dakota | 38049 | 824 | 23 |
1812148 | 1812148 | 2021-10-13 | McIntosh | North Dakota | 38051 | 442 | 8 |
1812149 | 1812149 | 2021-10-13 | McKenzie | North Dakota | 38053 | 2202 | 20 |
1812150 | 1812150 | 2021-10-13 | McLean | North Dakota | 38055 | 1698 | 33 |
1812151 | 1812151 | 2021-10-13 | Mercer | North Dakota | 38057 | 1645 | 12 |
1812152 | 1812152 | 2021-10-13 | Morton | North Dakota | 38059 | 7046 | 105 |
1812153 | 1812153 | 2021-10-13 | Mountrail | North Dakota | 38061 | 1807 | 23 |
1812154 | 1812154 | 2021-10-13 | Nelson | North Dakota | 38063 | 533 | 16 |
1812155 | 1812155 | 2021-10-13 | Oliver | North Dakota | 38065 | 196 | 3 |
1812156 | 1812156 | 2021-10-13 | Pembina | North Dakota | 38067 | 1132 | 11 |
1812157 | 1812157 | 2021-10-13 | Pierce | North Dakota | 38069 | 735 | 27 |
1812158 | 1812158 | 2021-10-13 | Ramsey | North Dakota | 38071 | 2093 | 33 |
1812159 | 1812159 | 2021-10-13 | Ransom | North Dakota | 38073 | 907 | 18 |
1812160 | 1812160 | 2021-10-13 | Renville | North Dakota | 38075 | 362 | 14 |
1812161 | 1812161 | 2021-10-13 | Richland | North Dakota | 38077 | 2415 | 19 |
1812162 | 1812162 | 2021-10-13 | Rolette | North Dakota | 38079 | 2733 | 31 |
1812163 | 1812163 | 2021-10-13 | Sargent | North Dakota | 38081 | 579 | 7 |
1812164 | 1812164 | 2021-10-13 | Sheridan | North Dakota | 38083 | 146 | 3 |
1812165 | 1812165 | 2021-10-13 | Sioux | North Dakota | 38085 | 843 | 15 |
1812166 | 1812166 | 2021-10-13 | Slope | North Dakota | 38087 | 41 | 0 |
1812167 | 1812167 | 2021-10-13 | Stark | North Dakota | 38089 | 7163 | 60 |
1812168 | 1812168 | 2021-10-13 | Steele | North Dakota | 38091 | 244 | 2 |
1812169 | 1812169 | 2021-10-13 | Stutsman | North Dakota | 38093 | 4237 | 83 |
1812170 | 1812170 | 2021-10-13 | Towner | North Dakota | 38095 | 376 | 11 |
1812171 | 1812171 | 2021-10-13 | Traill | North Dakota | 38097 | 1233 | 19 |
1812172 | 1812172 | 2021-10-13 | Unknown | North Dakota | 34 | 34 | |
1812173 | 1812173 | 2021-10-13 | Walsh | North Dakota | 38099 | 2187 | 29 |
1812174 | 1812174 | 2021-10-13 | Ward | North Dakota | 38101 | 12420 | 212 |
1812175 | 1812175 | 2021-10-13 | Wells | North Dakota | 38103 | 554 | 9 |
1812176 | 1812176 | 2021-10-13 | Williams | North Dakota | 38105 | 6485 | 48 |
1808874 | 1808874 | 2021-10-12 | Adams | North Dakota | 38001 | 354 | 4 |
1808875 | 1808875 | 2021-10-12 | Barnes | North Dakota | 38003 | 1732 | 33 |
1808876 | 1808876 | 2021-10-12 | Benson | North Dakota | 38005 | 1252 | 20 |
1808877 | 1808877 | 2021-10-12 | Billings | North Dakota | 38007 | 88 | 0 |
1808878 | 1808878 | 2021-10-12 | Bottineau | North Dakota | 38009 | 931 | 20 |
1808879 | 1808879 | 2021-10-12 | Bowman | North Dakota | 38011 | 530 | 7 |
1808880 | 1808880 | 2021-10-12 | Burke | North Dakota | 38013 | 291 | 3 |
1808881 | 1808881 | 2021-10-12 | Burleigh | North Dakota | 38015 | 21233 | 222 |
1808882 | 1808882 | 2021-10-12 | Cass | North Dakota | 38017 | 30294 | 230 |
1808883 | 1808883 | 2021-10-12 | Cavalier | North Dakota | 38019 | 520 | 5 |
1808884 | 1808884 | 2021-10-12 | Dickey | North Dakota | 38021 | 938 | 33 |
1808885 | 1808885 | 2021-10-12 | Divide | North Dakota | 38023 | 255 | 2 |
1808886 | 1808886 | 2021-10-12 | Dunn | North Dakota | 38025 | 651 | 7 |
1808887 | 1808887 | 2021-10-12 | Eddy | North Dakota | 38027 | 509 | 6 |
1808888 | 1808888 | 2021-10-12 | Emmons | North Dakota | 38029 | 531 | 14 |
1808889 | 1808889 | 2021-10-12 | Foster | North Dakota | 38031 | 636 | 19 |
1808890 | 1808890 | 2021-10-12 | Golden Valley | North Dakota | 38033 | 326 | 4 |
1808891 | 1808891 | 2021-10-12 | Grand Forks | North Dakota | 38035 | 12478 | 82 |
1808892 | 1808892 | 2021-10-12 | Grant | North Dakota | 38037 | 298 | 7 |
1808893 | 1808893 | 2021-10-12 | Griggs | North Dakota | 38039 | 361 | 2 |
1808894 | 1808894 | 2021-10-12 | Hettinger | North Dakota | 38041 | 452 | 5 |
1808895 | 1808895 | 2021-10-12 | Kidder | North Dakota | 38043 | 347 | 10 |
1808896 | 1808896 | 2021-10-12 | LaMoure | North Dakota | 38045 | 645 | 17 |
1808897 | 1808897 | 2021-10-12 | Logan | North Dakota | 38047 | 315 | 10 |
1808898 | 1808898 | 2021-10-12 | McHenry | North Dakota | 38049 | 820 | 23 |
1808899 | 1808899 | 2021-10-12 | McIntosh | North Dakota | 38051 | 441 | 8 |
1808900 | 1808900 | 2021-10-12 | McKenzie | North Dakota | 38053 | 2193 | 20 |
1808901 | 1808901 | 2021-10-12 | McLean | North Dakota | 38055 | 1681 | 33 |
1808902 | 1808902 | 2021-10-12 | Mercer | North Dakota | 38057 | 1637 | 12 |
1808903 | 1808903 | 2021-10-12 | Morton | North Dakota | 38059 | 7015 | 105 |
1808904 | 1808904 | 2021-10-12 | Mountrail | North Dakota | 38061 | 1802 | 23 |
1808905 | 1808905 | 2021-10-12 | Nelson | North Dakota | 38063 | 533 | 16 |
1808906 | 1808906 | 2021-10-12 | Oliver | North Dakota | 38065 | 196 | 3 |
1808907 | 1808907 | 2021-10-12 | Pembina | North Dakota | 38067 | 1131 | 11 |
1808908 | 1808908 | 2021-10-12 | Pierce | North Dakota | 38069 | 733 | 27 |
1808909 | 1808909 | 2021-10-12 | Ramsey | North Dakota | 38071 | 2088 | 33 |
1808910 | 1808910 | 2021-10-12 | Ransom | North Dakota | 38073 | 902 | 18 |
1808911 | 1808911 | 2021-10-12 | Renville | North Dakota | 38075 | 358 | 14 |
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);