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 578
- 38015 572
- 38017 572
- 38059 571
- 38069 569
- 38071 569
- 38099 566
- 38025 565
- 38031 564
- 38089 564
- 38049 563
- 38051 563
- 38003 561
- 38023 561
- 38055 561
- 38061 561
- 38085 561
- 38035 559
- 38065 559
- 38037 558
- 38053 558
- 38105 558
- 38013 557
- 38027 555
- 38087 555
- 38029 553
- 38011 551
- 38093 550
- 38077 549
- 38081 548
- …
county >30
- Ward 578
- Burleigh 572
- Cass 572
- Morton 571
- Pierce 569
- Ramsey 569
- Walsh 566
- Dunn 565
- Foster 564
- Stark 564
- McHenry 563
- McIntosh 563
- Barnes 561
- Divide 561
- McLean 561
- Mountrail 561
- Sioux 561
- Grand Forks 559
- Oliver 559
- Grant 558
- McKenzie 558
- Williams 558
- Burke 557
- Eddy 555
- Slope 555
- Emmons 553
- Bowman 551
- Stutsman 550
- Richland 549
- Sargent 548
- …
state 1
- North Dakota · 28,835 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1799125 | 1799125 | 2021-10-09 | Adams | North Dakota | 38001 | 350 | 4 |
1799126 | 1799126 | 2021-10-09 | Barnes | North Dakota | 38003 | 1711 | 33 |
1799127 | 1799127 | 2021-10-09 | Benson | North Dakota | 38005 | 1247 | 20 |
1799128 | 1799128 | 2021-10-09 | Billings | North Dakota | 38007 | 86 | 0 |
1799129 | 1799129 | 2021-10-09 | Bottineau | North Dakota | 38009 | 920 | 20 |
1799130 | 1799130 | 2021-10-09 | Bowman | North Dakota | 38011 | 522 | 7 |
1799131 | 1799131 | 2021-10-09 | Burke | North Dakota | 38013 | 288 | 3 |
1799132 | 1799132 | 2021-10-09 | Burleigh | North Dakota | 38015 | 21047 | 221 |
1799133 | 1799133 | 2021-10-09 | Cass | North Dakota | 38017 | 30052 | 229 |
1799134 | 1799134 | 2021-10-09 | Cavalier | North Dakota | 38019 | 519 | 5 |
1799135 | 1799135 | 2021-10-09 | Dickey | North Dakota | 38021 | 930 | 33 |
1799136 | 1799136 | 2021-10-09 | Divide | North Dakota | 38023 | 254 | 2 |
1799137 | 1799137 | 2021-10-09 | Dunn | North Dakota | 38025 | 641 | 7 |
1799138 | 1799138 | 2021-10-09 | Eddy | North Dakota | 38027 | 506 | 6 |
1799139 | 1799139 | 2021-10-09 | Emmons | North Dakota | 38029 | 531 | 14 |
1799140 | 1799140 | 2021-10-09 | Foster | North Dakota | 38031 | 634 | 19 |
1799141 | 1799141 | 2021-10-09 | Golden Valley | North Dakota | 38033 | 319 | 4 |
1799142 | 1799142 | 2021-10-09 | Grand Forks | North Dakota | 38035 | 12400 | 82 |
1799143 | 1799143 | 2021-10-09 | Grant | North Dakota | 38037 | 293 | 7 |
1799144 | 1799144 | 2021-10-09 | Griggs | North Dakota | 38039 | 361 | 2 |
1799145 | 1799145 | 2021-10-09 | Hettinger | North Dakota | 38041 | 443 | 5 |
1799146 | 1799146 | 2021-10-09 | Kidder | North Dakota | 38043 | 341 | 10 |
1799147 | 1799147 | 2021-10-09 | LaMoure | North Dakota | 38045 | 642 | 17 |
1799148 | 1799148 | 2021-10-09 | Logan | North Dakota | 38047 | 313 | 10 |
1799149 | 1799149 | 2021-10-09 | McHenry | North Dakota | 38049 | 810 | 23 |
1799150 | 1799150 | 2021-10-09 | McIntosh | North Dakota | 38051 | 438 | 8 |
1799151 | 1799151 | 2021-10-09 | McKenzie | North Dakota | 38053 | 2169 | 17 |
1799152 | 1799152 | 2021-10-09 | McLean | North Dakota | 38055 | 1650 | 33 |
1799153 | 1799153 | 2021-10-09 | Mercer | North Dakota | 38057 | 1611 | 12 |
1799154 | 1799154 | 2021-10-09 | Morton | North Dakota | 38059 | 6929 | 105 |
1799155 | 1799155 | 2021-10-09 | Mountrail | North Dakota | 38061 | 1791 | 23 |
1799156 | 1799156 | 2021-10-09 | Nelson | North Dakota | 38063 | 533 | 16 |
1799157 | 1799157 | 2021-10-09 | Oliver | North Dakota | 38065 | 193 | 3 |
1799158 | 1799158 | 2021-10-09 | Pembina | North Dakota | 38067 | 1122 | 11 |
1799159 | 1799159 | 2021-10-09 | Pierce | North Dakota | 38069 | 731 | 27 |
1799160 | 1799160 | 2021-10-09 | Ramsey | North Dakota | 38071 | 2078 | 33 |
1799161 | 1799161 | 2021-10-09 | Ransom | North Dakota | 38073 | 896 | 18 |
1799162 | 1799162 | 2021-10-09 | Renville | North Dakota | 38075 | 357 | 14 |
1799163 | 1799163 | 2021-10-09 | Richland | North Dakota | 38077 | 2388 | 19 |
1799164 | 1799164 | 2021-10-09 | Rolette | North Dakota | 38079 | 2676 | 31 |
1799165 | 1799165 | 2021-10-09 | Sargent | North Dakota | 38081 | 577 | 7 |
1799166 | 1799166 | 2021-10-09 | Sheridan | North Dakota | 38083 | 144 | 3 |
1799167 | 1799167 | 2021-10-09 | Sioux | North Dakota | 38085 | 834 | 14 |
1799168 | 1799168 | 2021-10-09 | Slope | North Dakota | 38087 | 41 | 0 |
1799169 | 1799169 | 2021-10-09 | Stark | North Dakota | 38089 | 6985 | 59 |
1799170 | 1799170 | 2021-10-09 | Steele | North Dakota | 38091 | 239 | 2 |
1799171 | 1799171 | 2021-10-09 | Stutsman | North Dakota | 38093 | 4201 | 82 |
1799172 | 1799172 | 2021-10-09 | Towner | North Dakota | 38095 | 373 | 11 |
1799173 | 1799173 | 2021-10-09 | Traill | North Dakota | 38097 | 1228 | 18 |
1799174 | 1799174 | 2021-10-09 | Unknown | North Dakota | 34 | 34 | |
1799175 | 1799175 | 2021-10-09 | Walsh | North Dakota | 38099 | 2168 | 28 |
1799176 | 1799176 | 2021-10-09 | Ward | North Dakota | 38101 | 12245 | 210 |
1799177 | 1799177 | 2021-10-09 | Wells | North Dakota | 38103 | 545 | 9 |
1799178 | 1799178 | 2021-10-09 | Williams | North Dakota | 38105 | 6376 | 46 |
1795876 | 1795876 | 2021-10-08 | Adams | North Dakota | 38001 | 350 | 4 |
1795877 | 1795877 | 2021-10-08 | Barnes | North Dakota | 38003 | 1700 | 33 |
1795878 | 1795878 | 2021-10-08 | Benson | North Dakota | 38005 | 1246 | 20 |
1795879 | 1795879 | 2021-10-08 | Billings | North Dakota | 38007 | 85 | 0 |
1795880 | 1795880 | 2021-10-08 | Bottineau | North Dakota | 38009 | 916 | 20 |
1795881 | 1795881 | 2021-10-08 | Bowman | North Dakota | 38011 | 518 | 7 |
1795882 | 1795882 | 2021-10-08 | Burke | North Dakota | 38013 | 288 | 3 |
1795883 | 1795883 | 2021-10-08 | Burleigh | North Dakota | 38015 | 20968 | 220 |
1795884 | 1795884 | 2021-10-08 | Cass | North Dakota | 38017 | 29955 | 229 |
1795885 | 1795885 | 2021-10-08 | Cavalier | North Dakota | 38019 | 518 | 5 |
1795886 | 1795886 | 2021-10-08 | Dickey | North Dakota | 38021 | 921 | 33 |
1795887 | 1795887 | 2021-10-08 | Divide | North Dakota | 38023 | 254 | 2 |
1795888 | 1795888 | 2021-10-08 | Dunn | North Dakota | 38025 | 630 | 7 |
1795889 | 1795889 | 2021-10-08 | Eddy | North Dakota | 38027 | 505 | 6 |
1795890 | 1795890 | 2021-10-08 | Emmons | North Dakota | 38029 | 531 | 14 |
1795891 | 1795891 | 2021-10-08 | Foster | North Dakota | 38031 | 632 | 19 |
1795892 | 1795892 | 2021-10-08 | Golden Valley | North Dakota | 38033 | 318 | 4 |
1795893 | 1795893 | 2021-10-08 | Grand Forks | North Dakota | 38035 | 12369 | 82 |
1795894 | 1795894 | 2021-10-08 | Grant | North Dakota | 38037 | 289 | 7 |
1795895 | 1795895 | 2021-10-08 | Griggs | North Dakota | 38039 | 361 | 2 |
1795896 | 1795896 | 2021-10-08 | Hettinger | North Dakota | 38041 | 443 | 5 |
1795897 | 1795897 | 2021-10-08 | Kidder | North Dakota | 38043 | 338 | 10 |
1795898 | 1795898 | 2021-10-08 | LaMoure | North Dakota | 38045 | 639 | 17 |
1795899 | 1795899 | 2021-10-08 | Logan | North Dakota | 38047 | 313 | 10 |
1795900 | 1795900 | 2021-10-08 | McHenry | North Dakota | 38049 | 806 | 23 |
1795901 | 1795901 | 2021-10-08 | McIntosh | North Dakota | 38051 | 438 | 8 |
1795902 | 1795902 | 2021-10-08 | McKenzie | North Dakota | 38053 | 2159 | 17 |
1795903 | 1795903 | 2021-10-08 | McLean | North Dakota | 38055 | 1643 | 33 |
1795904 | 1795904 | 2021-10-08 | Mercer | North Dakota | 38057 | 1593 | 11 |
1795905 | 1795905 | 2021-10-08 | Morton | North Dakota | 38059 | 6899 | 104 |
1795906 | 1795906 | 2021-10-08 | Mountrail | North Dakota | 38061 | 1780 | 23 |
1795907 | 1795907 | 2021-10-08 | Nelson | North Dakota | 38063 | 533 | 16 |
1795908 | 1795908 | 2021-10-08 | Oliver | North Dakota | 38065 | 193 | 3 |
1795909 | 1795909 | 2021-10-08 | Pembina | North Dakota | 38067 | 1121 | 11 |
1795910 | 1795910 | 2021-10-08 | Pierce | North Dakota | 38069 | 731 | 27 |
1795911 | 1795911 | 2021-10-08 | Ramsey | North Dakota | 38071 | 2071 | 33 |
1795912 | 1795912 | 2021-10-08 | Ransom | North Dakota | 38073 | 894 | 18 |
1795913 | 1795913 | 2021-10-08 | Renville | North Dakota | 38075 | 356 | 14 |
1795914 | 1795914 | 2021-10-08 | Richland | North Dakota | 38077 | 2373 | 19 |
1795915 | 1795915 | 2021-10-08 | Rolette | North Dakota | 38079 | 2661 | 31 |
1795916 | 1795916 | 2021-10-08 | Sargent | North Dakota | 38081 | 577 | 7 |
1795917 | 1795917 | 2021-10-08 | Sheridan | North Dakota | 38083 | 145 | 3 |
1795918 | 1795918 | 2021-10-08 | Sioux | North Dakota | 38085 | 834 | 14 |
1795919 | 1795919 | 2021-10-08 | Slope | North Dakota | 38087 | 41 | 0 |
1795920 | 1795920 | 2021-10-08 | Stark | North Dakota | 38089 | 6923 | 55 |
1795921 | 1795921 | 2021-10-08 | Steele | North Dakota | 38091 | 238 | 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);