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 189
- 38015 183
- 38017 183
- 38059 182
- 38069 180
- 38071 180
- 38099 177
- 38025 176
- 38031 175
- 38089 175
- 38049 174
- 38051 174
- 38003 172
- 38023 172
- 38055 172
- 38061 172
- 38085 172
- 38035 170
- 38065 170
- 38037 169
- 38053 169
- 38105 169
- 38013 168
- 38027 166
- 38087 166
- 38029 164
- 38011 162
- 38093 161
- 38077 160
- 38081 159
- …
county >30
- Ward 189
- Burleigh 183
- Cass 183
- Morton 182
- Pierce 180
- Ramsey 180
- Walsh 177
- Dunn 176
- Foster 175
- Stark 175
- McHenry 174
- McIntosh 174
- Barnes 172
- Divide 172
- McLean 172
- Mountrail 172
- Sioux 172
- Grand Forks 170
- Oliver 170
- Grant 169
- McKenzie 169
- Williams 169
- Burke 168
- Eddy 166
- Slope 166
- Emmons 164
- Bowman 162
- Stutsman 161
- Richland 160
- Sargent 159
- …
state 1
- North Dakota · 7,830 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536419 | 536419 | 2020-09-15 | Adams | North Dakota | 38001 | 13 | 0 |
536420 | 536420 | 2020-09-15 | Barnes | North Dakota | 38003 | 197 | 0 |
536421 | 536421 | 2020-09-15 | Benson | North Dakota | 38005 | 267 | 5 |
536422 | 536422 | 2020-09-15 | Billings | North Dakota | 38007 | 6 | 0 |
536423 | 536423 | 2020-09-15 | Bottineau | North Dakota | 38009 | 35 | 0 |
536424 | 536424 | 2020-09-15 | Bowman | North Dakota | 38011 | 26 | 0 |
536425 | 536425 | 2020-09-15 | Burke | North Dakota | 38013 | 26 | 1 |
536426 | 536426 | 2020-09-15 | Burleigh | North Dakota | 38015 | 2767 | 27 |
536427 | 536427 | 2020-09-15 | Cass | North Dakota | 38017 | 4328 | 77 |
536428 | 536428 | 2020-09-15 | Cavalier | North Dakota | 38019 | 39 | 0 |
536429 | 536429 | 2020-09-15 | Dickey | North Dakota | 38021 | 36 | 0 |
536430 | 536430 | 2020-09-15 | Divide | North Dakota | 38023 | 6 | 0 |
536431 | 536431 | 2020-09-15 | Dunn | North Dakota | 38025 | 59 | 1 |
536432 | 536432 | 2020-09-15 | Eddy | North Dakota | 38027 | 59 | 1 |
536433 | 536433 | 2020-09-15 | Emmons | North Dakota | 38029 | 55 | 1 |
536434 | 536434 | 2020-09-15 | Foster | North Dakota | 38031 | 51 | 0 |
536435 | 536435 | 2020-09-15 | Golden Valley | North Dakota | 38033 | 40 | 0 |
536436 | 536436 | 2020-09-15 | Grand Forks | North Dakota | 38035 | 1951 | 12 |
536437 | 536437 | 2020-09-15 | Grant | North Dakota | 38037 | 11 | 0 |
536438 | 536438 | 2020-09-15 | Griggs | North Dakota | 38039 | 44 | 1 |
536439 | 536439 | 2020-09-15 | Hettinger | North Dakota | 38041 | 46 | 0 |
536440 | 536440 | 2020-09-15 | Kidder | North Dakota | 38043 | 38 | 0 |
536441 | 536441 | 2020-09-15 | LaMoure | North Dakota | 38045 | 38 | 0 |
536442 | 536442 | 2020-09-15 | Logan | North Dakota | 38047 | 16 | 0 |
536443 | 536443 | 2020-09-15 | McHenry | North Dakota | 38049 | 55 | 1 |
536444 | 536444 | 2020-09-15 | McIntosh | North Dakota | 38051 | 48 | 3 |
536445 | 536445 | 2020-09-15 | McKenzie | North Dakota | 38053 | 148 | 2 |
536446 | 536446 | 2020-09-15 | McLean | North Dakota | 38055 | 204 | 2 |
536447 | 536447 | 2020-09-15 | Mercer | North Dakota | 38057 | 84 | 0 |
536448 | 536448 | 2020-09-15 | Morton | North Dakota | 38059 | 957 | 9 |
536449 | 536449 | 2020-09-15 | Mountrail | North Dakota | 38061 | 191 | 2 |
536450 | 536450 | 2020-09-15 | Nelson | North Dakota | 38063 | 37 | 0 |
536451 | 536451 | 2020-09-15 | Oliver | North Dakota | 38065 | 15 | 0 |
536452 | 536452 | 2020-09-15 | Pembina | North Dakota | 38067 | 43 | 0 |
536453 | 536453 | 2020-09-15 | Pierce | North Dakota | 38069 | 29 | 0 |
536454 | 536454 | 2020-09-15 | Ramsey | North Dakota | 38071 | 172 | 2 |
536455 | 536455 | 2020-09-15 | Ransom | North Dakota | 38073 | 58 | 0 |
536456 | 536456 | 2020-09-15 | Renville | North Dakota | 38075 | 21 | 0 |
536457 | 536457 | 2020-09-15 | Richland | North Dakota | 38077 | 178 | 1 |
536458 | 536458 | 2020-09-15 | Rolette | North Dakota | 38079 | 140 | 3 |
536459 | 536459 | 2020-09-15 | Sargent | North Dakota | 38081 | 32 | 0 |
536460 | 536460 | 2020-09-15 | Sheridan | North Dakota | 38083 | 9 | 0 |
536461 | 536461 | 2020-09-15 | Sioux | North Dakota | 38085 | 135 | 3 |
536462 | 536462 | 2020-09-15 | Slope | North Dakota | 38087 | 7 | 0 |
536463 | 536463 | 2020-09-15 | Stark | North Dakota | 38089 | 1120 | 6 |
536464 | 536464 | 2020-09-15 | Steele | North Dakota | 38091 | 26 | 0 |
536465 | 536465 | 2020-09-15 | Stutsman | North Dakota | 38093 | 465 | 3 |
536466 | 536466 | 2020-09-15 | Towner | North Dakota | 38095 | 11 | 0 |
536467 | 536467 | 2020-09-15 | Traill | North Dakota | 38097 | 83 | 0 |
536468 | 536468 | 2020-09-15 | Unknown | North Dakota | 3 | 3 | |
536469 | 536469 | 2020-09-15 | Walsh | North Dakota | 38099 | 162 | 1 |
536470 | 536470 | 2020-09-15 | Ward | North Dakota | 38101 | 756 | 3 |
536471 | 536471 | 2020-09-15 | Wells | North Dakota | 38103 | 33 | 0 |
536472 | 536472 | 2020-09-15 | Williams | North Dakota | 38105 | 691 | 5 |
533183 | 533183 | 2020-09-14 | Adams | North Dakota | 38001 | 14 | 0 |
533184 | 533184 | 2020-09-14 | Barnes | North Dakota | 38003 | 198 | 0 |
533185 | 533185 | 2020-09-14 | Benson | North Dakota | 38005 | 268 | 5 |
533186 | 533186 | 2020-09-14 | Billings | North Dakota | 38007 | 6 | 0 |
533187 | 533187 | 2020-09-14 | Bottineau | North Dakota | 38009 | 34 | 0 |
533188 | 533188 | 2020-09-14 | Bowman | North Dakota | 38011 | 26 | 0 |
533189 | 533189 | 2020-09-14 | Burke | North Dakota | 38013 | 25 | 1 |
533190 | 533190 | 2020-09-14 | Burleigh | North Dakota | 38015 | 2685 | 26 |
533191 | 533191 | 2020-09-14 | Cass | North Dakota | 38017 | 4294 | 77 |
533192 | 533192 | 2020-09-14 | Cavalier | North Dakota | 38019 | 37 | 0 |
533193 | 533193 | 2020-09-14 | Dickey | North Dakota | 38021 | 35 | 0 |
533194 | 533194 | 2020-09-14 | Divide | North Dakota | 38023 | 6 | 0 |
533195 | 533195 | 2020-09-14 | Dunn | North Dakota | 38025 | 60 | 1 |
533196 | 533196 | 2020-09-14 | Eddy | North Dakota | 38027 | 59 | 1 |
533197 | 533197 | 2020-09-14 | Emmons | North Dakota | 38029 | 52 | 1 |
533198 | 533198 | 2020-09-14 | Foster | North Dakota | 38031 | 52 | 0 |
533199 | 533199 | 2020-09-14 | Golden Valley | North Dakota | 38033 | 40 | 0 |
533200 | 533200 | 2020-09-14 | Grand Forks | North Dakota | 38035 | 1934 | 12 |
533201 | 533201 | 2020-09-14 | Grant | North Dakota | 38037 | 9 | 0 |
533202 | 533202 | 2020-09-14 | Griggs | North Dakota | 38039 | 44 | 1 |
533203 | 533203 | 2020-09-14 | Hettinger | North Dakota | 38041 | 46 | 0 |
533204 | 533204 | 2020-09-14 | Kidder | North Dakota | 38043 | 38 | 0 |
533205 | 533205 | 2020-09-14 | LaMoure | North Dakota | 38045 | 37 | 0 |
533206 | 533206 | 2020-09-14 | Logan | North Dakota | 38047 | 15 | 0 |
533207 | 533207 | 2020-09-14 | McHenry | North Dakota | 38049 | 55 | 1 |
533208 | 533208 | 2020-09-14 | McIntosh | North Dakota | 38051 | 50 | 3 |
533209 | 533209 | 2020-09-14 | McKenzie | North Dakota | 38053 | 147 | 2 |
533210 | 533210 | 2020-09-14 | McLean | North Dakota | 38055 | 201 | 2 |
533211 | 533211 | 2020-09-14 | Mercer | North Dakota | 38057 | 79 | 0 |
533212 | 533212 | 2020-09-14 | Morton | North Dakota | 38059 | 930 | 8 |
533213 | 533213 | 2020-09-14 | Mountrail | North Dakota | 38061 | 191 | 2 |
533214 | 533214 | 2020-09-14 | Nelson | North Dakota | 38063 | 36 | 0 |
533215 | 533215 | 2020-09-14 | Oliver | North Dakota | 38065 | 13 | 0 |
533216 | 533216 | 2020-09-14 | Pembina | North Dakota | 38067 | 43 | 0 |
533217 | 533217 | 2020-09-14 | Pierce | North Dakota | 38069 | 28 | 0 |
533218 | 533218 | 2020-09-14 | Ramsey | North Dakota | 38071 | 176 | 2 |
533219 | 533219 | 2020-09-14 | Ransom | North Dakota | 38073 | 58 | 0 |
533220 | 533220 | 2020-09-14 | Renville | North Dakota | 38075 | 19 | 0 |
533221 | 533221 | 2020-09-14 | Richland | North Dakota | 38077 | 176 | 1 |
533222 | 533222 | 2020-09-14 | Rolette | North Dakota | 38079 | 140 | 3 |
533223 | 533223 | 2020-09-14 | Sargent | North Dakota | 38081 | 30 | 0 |
533224 | 533224 | 2020-09-14 | Sheridan | North Dakota | 38083 | 9 | 0 |
533225 | 533225 | 2020-09-14 | Sioux | North Dakota | 38085 | 133 | 3 |
533226 | 533226 | 2020-09-14 | Slope | North Dakota | 38087 | 7 | 0 |
533227 | 533227 | 2020-09-14 | Stark | North Dakota | 38089 | 1115 | 6 |
533228 | 533228 | 2020-09-14 | Steele | North Dakota | 38091 | 25 | 0 |
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);