ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2021-10-28 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
1860469 | 1860469 | 2021-10-28 | Beaverhead | Montana | 30001 | 1473 | 17 |
1860470 | 1860470 | 2021-10-28 | Big Horn | Montana | 30003 | 3024 | 82 |
1860471 | 1860471 | 2021-10-28 | Blaine | Montana | 30005 | 1268 | 27 |
1860472 | 1860472 | 2021-10-28 | Broadwater | Montana | 30007 | 836 | 17 |
1860473 | 1860473 | 2021-10-28 | Carbon | Montana | 30009 | 1361 | 21 |
1860474 | 1860474 | 2021-10-28 | Carter | Montana | 30011 | 179 | 5 |
1860475 | 1860475 | 2021-10-28 | Cascade | Montana | 30013 | 15193 | 233 |
1860476 | 1860476 | 2021-10-28 | Chouteau | Montana | 30015 | 689 | 8 |
1860477 | 1860477 | 2021-10-28 | Custer | Montana | 30017 | 2158 | 34 |
1860478 | 1860478 | 2021-10-28 | Daniels | Montana | 30019 | 285 | 9 |
1860479 | 1860479 | 2021-10-28 | Dawson | Montana | 30021 | 1607 | 45 |
1860480 | 1860480 | 2021-10-28 | Deer Lodge | Montana | 30023 | 1588 | 24 |
1860481 | 1860481 | 2021-10-28 | Fallon | Montana | 30025 | 460 | 5 |
1860482 | 1860482 | 2021-10-28 | Fergus | Montana | 30027 | 1673 | 38 |
1860483 | 1860483 | 2021-10-28 | Flathead | Montana | 30029 | 19315 | 171 |
1860484 | 1860484 | 2021-10-28 | Gallatin | Montana | 30031 | 20625 | 84 |
1860485 | 1860485 | 2021-10-28 | Garfield | Montana | 30033 | 136 | 3 |
1860486 | 1860486 | 2021-10-28 | Glacier | Montana | 30035 | 2161 | 53 |
1860487 | 1860487 | 2021-10-28 | Golden Valley | Montana | 30037 | 96 | 3 |
1860488 | 1860488 | 2021-10-28 | Granite | Montana | 30039 | 391 | 3 |
1860489 | 1860489 | 2021-10-28 | Hill | Montana | 30041 | 3224 | 61 |
1860490 | 1860490 | 2021-10-28 | Jefferson | Montana | 30043 | 1708 | 11 |
1860491 | 1860491 | 2021-10-28 | Judith Basin | Montana | 30045 | 151 | 1 |
1860492 | 1860492 | 2021-10-28 | Lake | Montana | 30047 | 4129 | 65 |
1860493 | 1860493 | 2021-10-28 | Lewis and Clark | Montana | 30049 | 11049 | 111 |
1860494 | 1860494 | 2021-10-28 | Liberty | Montana | 30051 | 259 | 2 |
1860495 | 1860495 | 2021-10-28 | Lincoln | Montana | 30053 | 3337 | 55 |
1860496 | 1860496 | 2021-10-28 | Madison | Montana | 30057 | 1280 | 11 |
1860497 | 1860497 | 2021-10-28 | McCone | Montana | 30055 | 267 | 3 |
1860498 | 1860498 | 2021-10-28 | Meagher | Montana | 30059 | 252 | 8 |
1860499 | 1860499 | 2021-10-28 | Mineral | Montana | 30061 | 707 | 13 |
1860500 | 1860500 | 2021-10-28 | Missoula | Montana | 30063 | 16154 | 162 |
1860501 | 1860501 | 2021-10-28 | Musselshell | Montana | 30065 | 599 | 17 |
1860502 | 1860502 | 2021-10-28 | Park | Montana | 30067 | 2309 | 27 |
1860503 | 1860503 | 2021-10-28 | Petroleum | Montana | 30069 | 18 | 1 |
1860504 | 1860504 | 2021-10-28 | Phillips | Montana | 30071 | 797 | 23 |
1860505 | 1860505 | 2021-10-28 | Pondera | Montana | 30073 | 780 | 6 |
1860506 | 1860506 | 2021-10-28 | Powder River | Montana | 30075 | 274 | 9 |
1860507 | 1860507 | 2021-10-28 | Powell | Montana | 30077 | 1362 | 18 |
1860508 | 1860508 | 2021-10-28 | Prairie | Montana | 30079 | 160 | 2 |
1860509 | 1860509 | 2021-10-28 | Ravalli | Montana | 30081 | 5063 | 66 |
1860510 | 1860510 | 2021-10-28 | Richland | Montana | 30083 | 1750 | 21 |
1860511 | 1860511 | 2021-10-28 | Roosevelt | Montana | 30085 | 1989 | 59 |
1860512 | 1860512 | 2021-10-28 | Rosebud | Montana | 30087 | 1660 | 56 |
1860513 | 1860513 | 2021-10-28 | Sanders | Montana | 30089 | 1377 | 25 |
1860514 | 1860514 | 2021-10-28 | Sheridan | Montana | 30091 | 508 | 7 |
1860515 | 1860515 | 2021-10-28 | Silver Bow | Montana | 30093 | 5783 | 103 |
1860516 | 1860516 | 2021-10-28 | Stillwater | Montana | 30095 | 1147 | 26 |
1860517 | 1860517 | 2021-10-28 | Sweet Grass | Montana | 30097 | 557 | 8 |
1860518 | 1860518 | 2021-10-28 | Teton | Montana | 30099 | 847 | 12 |
1860519 | 1860519 | 2021-10-28 | Toole | Montana | 30101 | 966 | 15 |
1860520 | 1860520 | 2021-10-28 | Treasure | Montana | 30103 | 88 | 1 |
1860521 | 1860521 | 2021-10-28 | Valley | Montana | 30105 | 1254 | 25 |
1860522 | 1860522 | 2021-10-28 | Wheatland | Montana | 30107 | 260 | 12 |
1860523 | 1860523 | 2021-10-28 | Wibaux | Montana | 30109 | 166 | 7 |
1860524 | 1860524 | 2021-10-28 | Yellowstone | Montana | 30111 | 28515 | 398 |
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);