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 2022-01-07 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 |
---|---|---|---|---|---|---|---|
2091236 | 2091236 | 2022-01-07 | Beaverhead | Montana | 30001 | 1647 | 23 |
2091237 | 2091237 | 2022-01-07 | Big Horn | Montana | 30003 | 3480 | 84 |
2091238 | 2091238 | 2022-01-07 | Blaine | Montana | 30005 | 1463 | 28 |
2091239 | 2091239 | 2022-01-07 | Broadwater | Montana | 30007 | 1029 | 17 |
2091240 | 2091240 | 2022-01-07 | Carbon | Montana | 30009 | 1659 | 23 |
2091241 | 2091241 | 2022-01-07 | Carter | Montana | 30011 | 217 | 5 |
2091242 | 2091242 | 2022-01-07 | Cascade | Montana | 30013 | 17397 | 283 |
2091243 | 2091243 | 2022-01-07 | Chouteau | Montana | 30015 | 806 | 9 |
2091244 | 2091244 | 2022-01-07 | Custer | Montana | 30017 | 2465 | 41 |
2091245 | 2091245 | 2022-01-07 | Daniels | Montana | 30019 | 313 | 9 |
2091246 | 2091246 | 2022-01-07 | Dawson | Montana | 30021 | 1913 | 52 |
2091247 | 2091247 | 2022-01-07 | Deer Lodge | Montana | 30023 | 1725 | 28 |
2091248 | 2091248 | 2022-01-07 | Fallon | Montana | 30025 | 571 | 10 |
2091249 | 2091249 | 2022-01-07 | Fergus | Montana | 30027 | 1958 | 52 |
2091250 | 2091250 | 2022-01-07 | Flathead | Montana | 30029 | 21873 | 225 |
2091251 | 2091251 | 2022-01-07 | Gallatin | Montana | 30031 | 25048 | 107 |
2091252 | 2091252 | 2022-01-07 | Garfield | Montana | 30033 | 175 | 3 |
2091253 | 2091253 | 2022-01-07 | Glacier | Montana | 30035 | 2563 | 63 |
2091254 | 2091254 | 2022-01-07 | Golden Valley | Montana | 30037 | 123 | 5 |
2091255 | 2091255 | 2022-01-07 | Granite | Montana | 30039 | 427 | 6 |
2091256 | 2091256 | 2022-01-07 | Hill | Montana | 30041 | 3469 | 71 |
2091257 | 2091257 | 2022-01-07 | Jefferson | Montana | 30043 | 1984 | 22 |
2091258 | 2091258 | 2022-01-07 | Judith Basin | Montana | 30045 | 170 | 1 |
2091259 | 2091259 | 2022-01-07 | Lake | Montana | 30047 | 4907 | 86 |
2091260 | 2091260 | 2022-01-07 | Lewis and Clark | Montana | 30049 | 13084 | 155 |
2091261 | 2091261 | 2022-01-07 | Liberty | Montana | 30051 | 276 | 2 |
2091262 | 2091262 | 2022-01-07 | Lincoln | Montana | 30053 | 3756 | 73 |
2091263 | 2091263 | 2022-01-07 | Madison | Montana | 30057 | 1484 | 20 |
2091264 | 2091264 | 2022-01-07 | McCone | Montana | 30055 | 319 | 8 |
2091265 | 2091265 | 2022-01-07 | Meagher | Montana | 30059 | 291 | 9 |
2091266 | 2091266 | 2022-01-07 | Mineral | Montana | 30061 | 772 | 14 |
2091267 | 2091267 | 2022-01-07 | Missoula | Montana | 30063 | 18985 | 192 |
2091268 | 2091268 | 2022-01-07 | Musselshell | Montana | 30065 | 779 | 26 |
2091269 | 2091269 | 2022-01-07 | Park | Montana | 30067 | 2907 | 32 |
2091270 | 2091270 | 2022-01-07 | Petroleum | Montana | 30069 | 28 | 1 |
2091271 | 2091271 | 2022-01-07 | Phillips | Montana | 30071 | 894 | 27 |
2091272 | 2091272 | 2022-01-07 | Pondera | Montana | 30073 | 864 | 6 |
2091273 | 2091273 | 2022-01-07 | Powder River | Montana | 30075 | 289 | 10 |
2091274 | 2091274 | 2022-01-07 | Powell | Montana | 30077 | 1493 | 26 |
2091275 | 2091275 | 2022-01-07 | Prairie | Montana | 30079 | 197 | 3 |
2091276 | 2091276 | 2022-01-07 | Ravalli | Montana | 30081 | 5649 | 129 |
2091277 | 2091277 | 2022-01-07 | Richland | Montana | 30083 | 2113 | 30 |
2091278 | 2091278 | 2022-01-07 | Roosevelt | Montana | 30085 | 2367 | 70 |
2091279 | 2091279 | 2022-01-07 | Rosebud | Montana | 30087 | 1793 | 58 |
2091280 | 2091280 | 2022-01-07 | Sanders | Montana | 30089 | 1674 | 40 |
2091281 | 2091281 | 2022-01-07 | Sheridan | Montana | 30091 | 567 | 10 |
2091282 | 2091282 | 2022-01-07 | Silver Bow | Montana | 30093 | 6504 | 118 |
2091283 | 2091283 | 2022-01-07 | Stillwater | Montana | 30095 | 1253 | 29 |
2091284 | 2091284 | 2022-01-07 | Sweet Grass | Montana | 30097 | 623 | 8 |
2091285 | 2091285 | 2022-01-07 | Teton | Montana | 30099 | 977 | 19 |
2091286 | 2091286 | 2022-01-07 | Toole | Montana | 30101 | 1028 | 21 |
2091287 | 2091287 | 2022-01-07 | Treasure | Montana | 30103 | 115 | 1 |
2091288 | 2091288 | 2022-01-07 | Valley | Montana | 30105 | 1422 | 32 |
2091289 | 2091289 | 2022-01-07 | Wheatland | Montana | 30107 | 279 | 13 |
2091290 | 2091290 | 2022-01-07 | Wibaux | Montana | 30109 | 179 | 8 |
2091291 | 2091291 | 2022-01-07 | Yellowstone | Montana | 30111 | 32849 | 475 |
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);