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 349
- 38015 343
- 38017 343
- 38059 342
- 38069 340
- 38071 340
- 38099 337
- 38025 336
- 38031 335
- 38089 335
- 38049 334
- 38051 334
- 38003 332
- 38023 332
- 38055 332
- 38061 332
- 38085 332
- 38035 330
- 38065 330
- 38037 329
- 38053 329
- 38105 329
- 38013 328
- 38027 326
- 38087 326
- 38029 324
- 38011 322
- 38093 321
- 38077 320
- 38081 319
- …
county >30
- Ward 349
- Burleigh 343
- Cass 343
- Morton 342
- Pierce 340
- Ramsey 340
- Walsh 337
- Dunn 336
- Foster 335
- Stark 335
- McHenry 334
- McIntosh 334
- Barnes 332
- Divide 332
- McLean 332
- Mountrail 332
- Sioux 332
- Grand Forks 330
- Oliver 330
- Grant 329
- McKenzie 329
- Williams 329
- Burke 328
- Eddy 326
- Slope 326
- Emmons 324
- Bowman 322
- Stutsman 321
- Richland 320
- Sargent 319
- …
state 1
- North Dakota · 16,469 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055510 | 1055510 | 2021-02-22 | Adams | North Dakota | 38001 | 265 | 3 |
1055511 | 1055511 | 2021-02-22 | Barnes | North Dakota | 38003 | 1284 | 31 |
1055512 | 1055512 | 2021-02-22 | Benson | North Dakota | 38005 | 1025 | 18 |
1055513 | 1055513 | 2021-02-22 | Billings | North Dakota | 38007 | 53 | 0 |
1055514 | 1055514 | 2021-02-22 | Bottineau | North Dakota | 38009 | 675 | 20 |
1055515 | 1055515 | 2021-02-22 | Bowman | North Dakota | 38011 | 379 | 4 |
1055516 | 1055516 | 2021-02-22 | Burke | North Dakota | 38013 | 222 | 1 |
1055517 | 1055517 | 2021-02-22 | Burleigh | North Dakota | 38015 | 14558 | 185 |
1055518 | 1055518 | 2021-02-22 | Cass | North Dakota | 38017 | 21276 | 195 |
1055519 | 1055519 | 2021-02-22 | Cavalier | North Dakota | 38019 | 415 | 5 |
1055520 | 1055520 | 2021-02-22 | Dickey | North Dakota | 38021 | 733 | 32 |
1055521 | 1055521 | 2021-02-22 | Divide | North Dakota | 38023 | 154 | 2 |
1055522 | 1055522 | 2021-02-22 | Dunn | North Dakota | 38025 | 365 | 7 |
1055523 | 1055523 | 2021-02-22 | Eddy | North Dakota | 38027 | 457 | 6 |
1055524 | 1055524 | 2021-02-22 | Emmons | North Dakota | 38029 | 406 | 12 |
1055525 | 1055525 | 2021-02-22 | Foster | North Dakota | 38031 | 555 | 19 |
1055526 | 1055526 | 2021-02-22 | Golden Valley | North Dakota | 38033 | 244 | 2 |
1055527 | 1055527 | 2021-02-22 | Grand Forks | North Dakota | 38035 | 9772 | 75 |
1055528 | 1055528 | 2021-02-22 | Grant | North Dakota | 38037 | 184 | 7 |
1055529 | 1055529 | 2021-02-22 | Griggs | North Dakota | 38039 | 305 | 2 |
1055530 | 1055530 | 2021-02-22 | Hettinger | North Dakota | 38041 | 309 | 4 |
1055531 | 1055531 | 2021-02-22 | Kidder | North Dakota | 38043 | 256 | 10 |
1055532 | 1055532 | 2021-02-22 | LaMoure | North Dakota | 38045 | 498 | 17 |
1055533 | 1055533 | 2021-02-22 | Logan | North Dakota | 38047 | 217 | 8 |
1055534 | 1055534 | 2021-02-22 | McHenry | North Dakota | 38049 | 582 | 21 |
1055535 | 1055535 | 2021-02-22 | McIntosh | North Dakota | 38051 | 320 | 7 |
1055536 | 1055536 | 2021-02-22 | McKenzie | North Dakota | 38053 | 1156 | 11 |
1055537 | 1055537 | 2021-02-22 | McLean | North Dakota | 38055 | 1205 | 31 |
1055538 | 1055538 | 2021-02-22 | Mercer | North Dakota | 38057 | 1069 | 9 |
1055539 | 1055539 | 2021-02-22 | Morton | North Dakota | 38059 | 4924 | 94 |
1055540 | 1055540 | 2021-02-22 | Mountrail | North Dakota | 38061 | 1265 | 17 |
1055541 | 1055541 | 2021-02-22 | Nelson | North Dakota | 38063 | 444 | 13 |
1055542 | 1055542 | 2021-02-22 | Oliver | North Dakota | 38065 | 150 | 2 |
1055543 | 1055543 | 2021-02-22 | Pembina | North Dakota | 38067 | 748 | 11 |
1055544 | 1055544 | 2021-02-22 | Pierce | North Dakota | 38069 | 519 | 24 |
1055545 | 1055545 | 2021-02-22 | Ramsey | North Dakota | 38071 | 1600 | 30 |
1055546 | 1055546 | 2021-02-22 | Ransom | North Dakota | 38073 | 611 | 16 |
1055547 | 1055547 | 2021-02-22 | Renville | North Dakota | 38075 | 304 | 13 |
1055548 | 1055548 | 2021-02-22 | Richland | North Dakota | 38077 | 1722 | 16 |
1055549 | 1055549 | 2021-02-22 | Rolette | North Dakota | 38079 | 2101 | 28 |
1055550 | 1055550 | 2021-02-22 | Sargent | North Dakota | 38081 | 425 | 6 |
1055551 | 1055551 | 2021-02-22 | Sheridan | North Dakota | 38083 | 103 | 2 |
1055552 | 1055552 | 2021-02-22 | Sioux | North Dakota | 38085 | 641 | 11 |
1055553 | 1055553 | 2021-02-22 | Slope | North Dakota | 38087 | 30 | 0 |
1055554 | 1055554 | 2021-02-22 | Stark | North Dakota | 38089 | 4340 | 49 |
1055555 | 1055555 | 2021-02-22 | Steele | North Dakota | 38091 | 171 | 2 |
1055556 | 1055556 | 2021-02-22 | Stutsman | North Dakota | 38093 | 3273 | 77 |
1055557 | 1055557 | 2021-02-22 | Towner | North Dakota | 38095 | 299 | 11 |
1055558 | 1055558 | 2021-02-22 | Traill | North Dakota | 38097 | 980 | 18 |
1055559 | 1055559 | 2021-02-22 | Unknown | North Dakota | 30 | 30 | |
1055560 | 1055560 | 2021-02-22 | Walsh | North Dakota | 38099 | 1745 | 24 |
1055561 | 1055561 | 2021-02-22 | Ward | North Dakota | 38101 | 9114 | 186 |
1055562 | 1055562 | 2021-02-22 | Wells | North Dakota | 38103 | 427 | 8 |
1055563 | 1055563 | 2021-02-22 | Williams | North Dakota | 38105 | 4437 | 36 |
1052264 | 1052264 | 2021-02-21 | Adams | North Dakota | 38001 | 265 | 3 |
1052265 | 1052265 | 2021-02-21 | Barnes | North Dakota | 38003 | 1284 | 31 |
1052266 | 1052266 | 2021-02-21 | Benson | North Dakota | 38005 | 1026 | 18 |
1052267 | 1052267 | 2021-02-21 | Billings | North Dakota | 38007 | 53 | 0 |
1052268 | 1052268 | 2021-02-21 | Bottineau | North Dakota | 38009 | 675 | 20 |
1052269 | 1052269 | 2021-02-21 | Bowman | North Dakota | 38011 | 379 | 4 |
1052270 | 1052270 | 2021-02-21 | Burke | North Dakota | 38013 | 222 | 1 |
1052271 | 1052271 | 2021-02-21 | Burleigh | North Dakota | 38015 | 14553 | 185 |
1052272 | 1052272 | 2021-02-21 | Cass | North Dakota | 38017 | 21271 | 195 |
1052273 | 1052273 | 2021-02-21 | Cavalier | North Dakota | 38019 | 415 | 5 |
1052274 | 1052274 | 2021-02-21 | Dickey | North Dakota | 38021 | 733 | 32 |
1052275 | 1052275 | 2021-02-21 | Divide | North Dakota | 38023 | 153 | 2 |
1052276 | 1052276 | 2021-02-21 | Dunn | North Dakota | 38025 | 365 | 7 |
1052277 | 1052277 | 2021-02-21 | Eddy | North Dakota | 38027 | 456 | 6 |
1052278 | 1052278 | 2021-02-21 | Emmons | North Dakota | 38029 | 406 | 12 |
1052279 | 1052279 | 2021-02-21 | Foster | North Dakota | 38031 | 555 | 19 |
1052280 | 1052280 | 2021-02-21 | Golden Valley | North Dakota | 38033 | 243 | 2 |
1052281 | 1052281 | 2021-02-21 | Grand Forks | North Dakota | 38035 | 9769 | 75 |
1052282 | 1052282 | 2021-02-21 | Grant | North Dakota | 38037 | 184 | 7 |
1052283 | 1052283 | 2021-02-21 | Griggs | North Dakota | 38039 | 305 | 2 |
1052284 | 1052284 | 2021-02-21 | Hettinger | North Dakota | 38041 | 309 | 4 |
1052285 | 1052285 | 2021-02-21 | Kidder | North Dakota | 38043 | 256 | 10 |
1052286 | 1052286 | 2021-02-21 | LaMoure | North Dakota | 38045 | 498 | 17 |
1052287 | 1052287 | 2021-02-21 | Logan | North Dakota | 38047 | 217 | 8 |
1052288 | 1052288 | 2021-02-21 | McHenry | North Dakota | 38049 | 581 | 21 |
1052289 | 1052289 | 2021-02-21 | McIntosh | North Dakota | 38051 | 320 | 7 |
1052290 | 1052290 | 2021-02-21 | McKenzie | North Dakota | 38053 | 1155 | 11 |
1052291 | 1052291 | 2021-02-21 | McLean | North Dakota | 38055 | 1205 | 31 |
1052292 | 1052292 | 2021-02-21 | Mercer | North Dakota | 38057 | 1069 | 9 |
1052293 | 1052293 | 2021-02-21 | Morton | North Dakota | 38059 | 4923 | 94 |
1052294 | 1052294 | 2021-02-21 | Mountrail | North Dakota | 38061 | 1264 | 17 |
1052295 | 1052295 | 2021-02-21 | Nelson | North Dakota | 38063 | 444 | 13 |
1052296 | 1052296 | 2021-02-21 | Oliver | North Dakota | 38065 | 150 | 2 |
1052297 | 1052297 | 2021-02-21 | Pembina | North Dakota | 38067 | 748 | 11 |
1052298 | 1052298 | 2021-02-21 | Pierce | North Dakota | 38069 | 519 | 24 |
1052299 | 1052299 | 2021-02-21 | Ramsey | North Dakota | 38071 | 1600 | 30 |
1052300 | 1052300 | 2021-02-21 | Ransom | North Dakota | 38073 | 611 | 16 |
1052301 | 1052301 | 2021-02-21 | Renville | North Dakota | 38075 | 304 | 13 |
1052302 | 1052302 | 2021-02-21 | Richland | North Dakota | 38077 | 1722 | 16 |
1052303 | 1052303 | 2021-02-21 | Rolette | North Dakota | 38079 | 2099 | 28 |
1052304 | 1052304 | 2021-02-21 | Sargent | North Dakota | 38081 | 424 | 6 |
1052305 | 1052305 | 2021-02-21 | Sheridan | North Dakota | 38083 | 103 | 2 |
1052306 | 1052306 | 2021-02-21 | Sioux | North Dakota | 38085 | 641 | 11 |
1052307 | 1052307 | 2021-02-21 | Slope | North Dakota | 38087 | 30 | 0 |
1052308 | 1052308 | 2021-02-21 | Stark | North Dakota | 38089 | 4337 | 49 |
1052309 | 1052309 | 2021-02-21 | Steele | North Dakota | 38091 | 171 | 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);