ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2021-09-24 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1750391 | 1750391 | 2021-09-24 | Adams | North Dakota | 38001 | 330 | 4 |
1750392 | 1750392 | 2021-09-24 | Barnes | North Dakota | 38003 | 1580 | 32 |
1750393 | 1750393 | 2021-09-24 | Benson | North Dakota | 38005 | 1216 | 20 |
1750394 | 1750394 | 2021-09-24 | Billings | North Dakota | 38007 | 67 | 0 |
1750395 | 1750395 | 2021-09-24 | Bottineau | North Dakota | 38009 | 859 | 20 |
1750396 | 1750396 | 2021-09-24 | Bowman | North Dakota | 38011 | 481 | 6 |
1750397 | 1750397 | 2021-09-24 | Burke | North Dakota | 38013 | 281 | 3 |
1750398 | 1750398 | 2021-09-24 | Burleigh | North Dakota | 38015 | 19271 | 212 |
1750399 | 1750399 | 2021-09-24 | Cass | North Dakota | 38017 | 28307 | 220 |
1750400 | 1750400 | 2021-09-24 | Cavalier | North Dakota | 38019 | 495 | 5 |
1750401 | 1750401 | 2021-09-24 | Dickey | North Dakota | 38021 | 881 | 33 |
1750402 | 1750402 | 2021-09-24 | Divide | North Dakota | 38023 | 240 | 2 |
1750403 | 1750403 | 2021-09-24 | Dunn | North Dakota | 38025 | 552 | 7 |
1750404 | 1750404 | 2021-09-24 | Eddy | North Dakota | 38027 | 489 | 6 |
1750405 | 1750405 | 2021-09-24 | Emmons | North Dakota | 38029 | 521 | 14 |
1750406 | 1750406 | 2021-09-24 | Foster | North Dakota | 38031 | 622 | 19 |
1750407 | 1750407 | 2021-09-24 | Golden Valley | North Dakota | 38033 | 300 | 4 |
1750408 | 1750408 | 2021-09-24 | Grand Forks | North Dakota | 38035 | 11905 | 80 |
1750409 | 1750409 | 2021-09-24 | Grant | North Dakota | 38037 | 261 | 7 |
1750410 | 1750410 | 2021-09-24 | Griggs | North Dakota | 38039 | 352 | 2 |
1750411 | 1750411 | 2021-09-24 | Hettinger | North Dakota | 38041 | 417 | 4 |
1750412 | 1750412 | 2021-09-24 | Kidder | North Dakota | 38043 | 321 | 10 |
1750413 | 1750413 | 2021-09-24 | LaMoure | North Dakota | 38045 | 616 | 17 |
1750414 | 1750414 | 2021-09-24 | Logan | North Dakota | 38047 | 302 | 10 |
1750415 | 1750415 | 2021-09-24 | McHenry | North Dakota | 38049 | 757 | 23 |
1750416 | 1750416 | 2021-09-24 | McIntosh | North Dakota | 38051 | 421 | 7 |
1750417 | 1750417 | 2021-09-24 | McKenzie | North Dakota | 38053 | 1978 | 17 |
1750418 | 1750418 | 2021-09-24 | McLean | North Dakota | 38055 | 1542 | 32 |
1750419 | 1750419 | 2021-09-24 | Mercer | North Dakota | 38057 | 1369 | 11 |
1750420 | 1750420 | 2021-09-24 | Morton | North Dakota | 38059 | 6302 | 104 |
1750421 | 1750421 | 2021-09-24 | Mountrail | North Dakota | 38061 | 1670 | 22 |
1750422 | 1750422 | 2021-09-24 | Nelson | North Dakota | 38063 | 524 | 16 |
1750423 | 1750423 | 2021-09-24 | Oliver | North Dakota | 38065 | 168 | 3 |
1750424 | 1750424 | 2021-09-24 | Pembina | North Dakota | 38067 | 1057 | 11 |
1750425 | 1750425 | 2021-09-24 | Pierce | North Dakota | 38069 | 686 | 26 |
1750426 | 1750426 | 2021-09-24 | Ramsey | North Dakota | 38071 | 1966 | 32 |
1750427 | 1750427 | 2021-09-24 | Ransom | North Dakota | 38073 | 829 | 18 |
1750428 | 1750428 | 2021-09-24 | Renville | North Dakota | 38075 | 354 | 14 |
1750429 | 1750429 | 2021-09-24 | Richland | North Dakota | 38077 | 2236 | 19 |
1750430 | 1750430 | 2021-09-24 | Rolette | North Dakota | 38079 | 2455 | 29 |
1750431 | 1750431 | 2021-09-24 | Sargent | North Dakota | 38081 | 557 | 7 |
1750432 | 1750432 | 2021-09-24 | Sheridan | North Dakota | 38083 | 133 | 2 |
1750433 | 1750433 | 2021-09-24 | Sioux | North Dakota | 38085 | 767 | 14 |
1750434 | 1750434 | 2021-09-24 | Slope | North Dakota | 38087 | 38 | 0 |
1750435 | 1750435 | 2021-09-24 | Stark | North Dakota | 38089 | 6292 | 52 |
1750436 | 1750436 | 2021-09-24 | Steele | North Dakota | 38091 | 221 | 2 |
1750437 | 1750437 | 2021-09-24 | Stutsman | North Dakota | 38093 | 3986 | 82 |
1750438 | 1750438 | 2021-09-24 | Towner | North Dakota | 38095 | 357 | 11 |
1750439 | 1750439 | 2021-09-24 | Traill | North Dakota | 38097 | 1170 | 18 |
1750440 | 1750440 | 2021-09-24 | Unknown | North Dakota | 34 | 34 | |
1750441 | 1750441 | 2021-09-24 | Walsh | North Dakota | 38099 | 2109 | 27 |
1750442 | 1750442 | 2021-09-24 | Ward | North Dakota | 38101 | 11510 | 209 |
1750443 | 1750443 | 2021-09-24 | Wells | North Dakota | 38103 | 501 | 9 |
1750444 | 1750444 | 2021-09-24 | Williams | North Dakota | 38105 | 5931 | 43 |
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);