ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where date = "2021-11-09" and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Beaverhead 1
- Big Horn 1
- Blaine 1
- Broadwater 1
- Carbon 1
- Carter 1
- Cascade 1
- Chouteau 1
- Custer 1
- Daniels 1
- Dawson 1
- Deer Lodge 1
- Fallon 1
- Fergus 1
- Flathead 1
- Gallatin 1
- Garfield 1
- Glacier 1
- Golden Valley 1
- Granite 1
- Hill 1
- Jefferson 1
- Judith Basin 1
- Lake 1
- Lewis and Clark 1
- Liberty 1
- Lincoln 1
- Madison 1
- McCone 1
- Meagher 1
- …
state 1
- Montana · 56 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1899461 | 1899461 | 2021-11-09 | Beaverhead | Montana | 30001 | 1503 | 17 |
1899462 | 1899462 | 2021-11-09 | Big Horn | Montana | 30003 | 3096 | 82 |
1899463 | 1899463 | 2021-11-09 | Blaine | Montana | 30005 | 1343 | 27 |
1899464 | 1899464 | 2021-11-09 | Broadwater | Montana | 30007 | 882 | 17 |
1899465 | 1899465 | 2021-11-09 | Carbon | Montana | 30009 | 1433 | 21 |
1899466 | 1899466 | 2021-11-09 | Carter | Montana | 30011 | 201 | 5 |
1899467 | 1899467 | 2021-11-09 | Cascade | Montana | 30013 | 15900 | 249 |
1899468 | 1899468 | 2021-11-09 | Chouteau | Montana | 30015 | 742 | 8 |
1899469 | 1899469 | 2021-11-09 | Custer | Montana | 30017 | 2249 | 37 |
1899470 | 1899470 | 2021-11-09 | Daniels | Montana | 30019 | 291 | 9 |
1899471 | 1899471 | 2021-11-09 | Dawson | Montana | 30021 | 1714 | 47 |
1899472 | 1899472 | 2021-11-09 | Deer Lodge | Montana | 30023 | 1626 | 25 |
1899473 | 1899473 | 2021-11-09 | Fallon | Montana | 30025 | 480 | 6 |
1899474 | 1899474 | 2021-11-09 | Fergus | Montana | 30027 | 1778 | 43 |
1899475 | 1899475 | 2021-11-09 | Flathead | Montana | 30029 | 19998 | 180 |
1899476 | 1899476 | 2021-11-09 | Gallatin | Montana | 30031 | 21386 | 88 |
1899477 | 1899477 | 2021-11-09 | Garfield | Montana | 30033 | 148 | 3 |
1899478 | 1899478 | 2021-11-09 | Glacier | Montana | 30035 | 2288 | 55 |
1899479 | 1899479 | 2021-11-09 | Golden Valley | Montana | 30037 | 114 | 4 |
1899480 | 1899480 | 2021-11-09 | Granite | Montana | 30039 | 404 | 6 |
1899481 | 1899481 | 2021-11-09 | Hill | Montana | 30041 | 3309 | 64 |
1899482 | 1899482 | 2021-11-09 | Jefferson | Montana | 30043 | 1771 | 13 |
1899483 | 1899483 | 2021-11-09 | Judith Basin | Montana | 30045 | 158 | 1 |
1899484 | 1899484 | 2021-11-09 | Lake | Montana | 30047 | 4333 | 68 |
1899485 | 1899485 | 2021-11-09 | Lewis and Clark | Montana | 30049 | 11688 | 118 |
1899486 | 1899486 | 2021-11-09 | Liberty | Montana | 30051 | 263 | 2 |
1899487 | 1899487 | 2021-11-09 | Lincoln | Montana | 30053 | 3407 | 58 |
1899488 | 1899488 | 2021-11-09 | Madison | Montana | 30057 | 1333 | 13 |
1899489 | 1899489 | 2021-11-09 | McCone | Montana | 30055 | 279 | 3 |
1899490 | 1899490 | 2021-11-09 | Meagher | Montana | 30059 | 265 | 8 |
1899491 | 1899491 | 2021-11-09 | Mineral | Montana | 30061 | 722 | 13 |
1899492 | 1899492 | 2021-11-09 | Missoula | Montana | 30063 | 16779 | 165 |
1899493 | 1899493 | 2021-11-09 | Musselshell | Montana | 30065 | 660 | 18 |
1899494 | 1899494 | 2021-11-09 | Park | Montana | 30067 | 2550 | 29 |
1899495 | 1899495 | 2021-11-09 | Petroleum | Montana | 30069 | 19 | 1 |
1899496 | 1899496 | 2021-11-09 | Phillips | Montana | 30071 | 830 | 24 |
1899497 | 1899497 | 2021-11-09 | Pondera | Montana | 30073 | 791 | 6 |
1899498 | 1899498 | 2021-11-09 | Powder River | Montana | 30075 | 280 | 10 |
1899499 | 1899499 | 2021-11-09 | Powell | Montana | 30077 | 1404 | 21 |
1899500 | 1899500 | 2021-11-09 | Prairie | Montana | 30079 | 164 | 2 |
1899501 | 1899501 | 2021-11-09 | Ravalli | Montana | 30081 | 5203 | 67 |
1899502 | 1899502 | 2021-11-09 | Richland | Montana | 30083 | 1816 | 24 |
1899503 | 1899503 | 2021-11-09 | Roosevelt | Montana | 30085 | 2133 | 59 |
1899504 | 1899504 | 2021-11-09 | Rosebud | Montana | 30087 | 1686 | 56 |
1899505 | 1899505 | 2021-11-09 | Sanders | Montana | 30089 | 1454 | 25 |
1899506 | 1899506 | 2021-11-09 | Sheridan | Montana | 30091 | 520 | 8 |
1899507 | 1899507 | 2021-11-09 | Silver Bow | Montana | 30093 | 5969 | 104 |
1899508 | 1899508 | 2021-11-09 | Stillwater | Montana | 30095 | 1189 | 27 |
1899509 | 1899509 | 2021-11-09 | Sweet Grass | Montana | 30097 | 575 | 8 |
1899510 | 1899510 | 2021-11-09 | Teton | Montana | 30099 | 877 | 13 |
1899511 | 1899511 | 2021-11-09 | Toole | Montana | 30101 | 990 | 16 |
1899512 | 1899512 | 2021-11-09 | Treasure | Montana | 30103 | 95 | 1 |
1899513 | 1899513 | 2021-11-09 | Valley | Montana | 30105 | 1306 | 27 |
1899514 | 1899514 | 2021-11-09 | Wheatland | Montana | 30107 | 268 | 13 |
1899515 | 1899515 | 2021-11-09 | Wibaux | Montana | 30109 | 169 | 7 |
1899516 | 1899516 | 2021-11-09 | Yellowstone | Montana | 30111 | 29835 | 417 |
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);