ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,671 rows where deaths = 2 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Prairie 398
- Granite 309
- Garfield 270
- Golden Valley 250
- Fallon 222
- Flathead 112
- Liberty 112
- Cascade 109
- McCone 101
- Custer 84
- Richland 80
- Ravalli 64
- Sweet Grass 47
- Lincoln 43
- Fergus 42
- Stillwater 42
- Sanders 38
- Hill 37
- Meagher 31
- Musselshell 30
- Yellowstone 27
- Broadwater 22
- Lewis and Clark 22
- Madison 16
- Carter 15
- Mineral 13
- Rosebud 13
- Valley 13
- Blaine 12
- Sheridan 11
- …
state 1
- Montana · 2,671 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2214870 | 2214870 | 2022-02-14 | Liberty | Montana | 30051 | 377 | 2 |
2211618 | 2211618 | 2022-02-13 | Liberty | Montana | 30051 | 376 | 2 |
2208365 | 2208365 | 2022-02-12 | Liberty | Montana | 30051 | 376 | 2 |
2205112 | 2205112 | 2022-02-11 | Liberty | Montana | 30051 | 376 | 2 |
2201859 | 2201859 | 2022-02-10 | Liberty | Montana | 30051 | 375 | 2 |
2198605 | 2198605 | 2022-02-09 | Liberty | Montana | 30051 | 374 | 2 |
2195351 | 2195351 | 2022-02-08 | Liberty | Montana | 30051 | 372 | 2 |
2192097 | 2192097 | 2022-02-07 | Liberty | Montana | 30051 | 369 | 2 |
2188844 | 2188844 | 2022-02-06 | Liberty | Montana | 30051 | 366 | 2 |
2185591 | 2185591 | 2022-02-05 | Liberty | Montana | 30051 | 366 | 2 |
2182339 | 2182339 | 2022-02-04 | Liberty | Montana | 30051 | 366 | 2 |
2179087 | 2179087 | 2022-02-03 | Liberty | Montana | 30051 | 364 | 2 |
2175835 | 2175835 | 2022-02-02 | Liberty | Montana | 30051 | 363 | 2 |
2172582 | 2172582 | 2022-02-01 | Liberty | Montana | 30051 | 356 | 2 |
2169329 | 2169329 | 2022-01-31 | Liberty | Montana | 30051 | 356 | 2 |
2166074 | 2166074 | 2022-01-30 | Liberty | Montana | 30051 | 351 | 2 |
2162819 | 2162819 | 2022-01-29 | Liberty | Montana | 30051 | 351 | 2 |
2159564 | 2159564 | 2022-01-28 | Liberty | Montana | 30051 | 351 | 2 |
2156310 | 2156310 | 2022-01-27 | Liberty | Montana | 30051 | 348 | 2 |
2153057 | 2153057 | 2022-01-26 | Liberty | Montana | 30051 | 341 | 2 |
2149805 | 2149805 | 2022-01-25 | Liberty | Montana | 30051 | 334 | 2 |
2146553 | 2146553 | 2022-01-24 | Liberty | Montana | 30051 | 333 | 2 |
2143298 | 2143298 | 2022-01-23 | Liberty | Montana | 30051 | 326 | 2 |
2140043 | 2140043 | 2022-01-22 | Liberty | Montana | 30051 | 326 | 2 |
2136787 | 2136787 | 2022-01-21 | Liberty | Montana | 30051 | 326 | 2 |
2133535 | 2133535 | 2022-01-20 | Liberty | Montana | 30051 | 326 | 2 |
2130282 | 2130282 | 2022-01-19 | Liberty | Montana | 30051 | 322 | 2 |
2127028 | 2127028 | 2022-01-18 | Liberty | Montana | 30051 | 316 | 2 |
2123776 | 2123776 | 2022-01-17 | Liberty | Montana | 30051 | 303 | 2 |
2120524 | 2120524 | 2022-01-16 | Liberty | Montana | 30051 | 303 | 2 |
2117272 | 2117272 | 2022-01-15 | Liberty | Montana | 30051 | 303 | 2 |
2114021 | 2114021 | 2022-01-14 | Liberty | Montana | 30051 | 303 | 2 |
2110769 | 2110769 | 2022-01-13 | Liberty | Montana | 30051 | 296 | 2 |
2107518 | 2107518 | 2022-01-12 | Liberty | Montana | 30051 | 295 | 2 |
2104267 | 2104267 | 2022-01-11 | Liberty | Montana | 30051 | 277 | 2 |
2101016 | 2101016 | 2022-01-10 | Liberty | Montana | 30051 | 276 | 2 |
2097765 | 2097765 | 2022-01-09 | Liberty | Montana | 30051 | 276 | 2 |
2094513 | 2094513 | 2022-01-08 | Liberty | Montana | 30051 | 276 | 2 |
2091261 | 2091261 | 2022-01-07 | Liberty | Montana | 30051 | 276 | 2 |
2088010 | 2088010 | 2022-01-06 | Liberty | Montana | 30051 | 274 | 2 |
2084758 | 2084758 | 2022-01-05 | Liberty | Montana | 30051 | 269 | 2 |
2084772 | 2084772 | 2022-01-05 | Prairie | Montana | 30079 | 196 | 2 |
2081506 | 2081506 | 2022-01-04 | Liberty | Montana | 30051 | 269 | 2 |
2081520 | 2081520 | 2022-01-04 | Prairie | Montana | 30079 | 196 | 2 |
2078254 | 2078254 | 2022-01-03 | Liberty | Montana | 30051 | 269 | 2 |
2078268 | 2078268 | 2022-01-03 | Prairie | Montana | 30079 | 196 | 2 |
2075003 | 2075003 | 2022-01-02 | Liberty | Montana | 30051 | 268 | 2 |
2075017 | 2075017 | 2022-01-02 | Prairie | Montana | 30079 | 196 | 2 |
2071752 | 2071752 | 2022-01-01 | Liberty | Montana | 30051 | 268 | 2 |
2071766 | 2071766 | 2022-01-01 | Prairie | Montana | 30079 | 196 | 2 |
2068501 | 2068501 | 2021-12-31 | Liberty | Montana | 30051 | 268 | 2 |
2068515 | 2068515 | 2021-12-31 | Prairie | Montana | 30079 | 196 | 2 |
2065250 | 2065250 | 2021-12-30 | Liberty | Montana | 30051 | 268 | 2 |
2065264 | 2065264 | 2021-12-30 | Prairie | Montana | 30079 | 196 | 2 |
2062000 | 2062000 | 2021-12-29 | Liberty | Montana | 30051 | 268 | 2 |
2062014 | 2062014 | 2021-12-29 | Prairie | Montana | 30079 | 196 | 2 |
2058751 | 2058751 | 2021-12-28 | Liberty | Montana | 30051 | 268 | 2 |
2058765 | 2058765 | 2021-12-28 | Prairie | Montana | 30079 | 196 | 2 |
2055502 | 2055502 | 2021-12-27 | Liberty | Montana | 30051 | 268 | 2 |
2055516 | 2055516 | 2021-12-27 | Prairie | Montana | 30079 | 195 | 2 |
2052252 | 2052252 | 2021-12-26 | Liberty | Montana | 30051 | 268 | 2 |
2052266 | 2052266 | 2021-12-26 | Prairie | Montana | 30079 | 195 | 2 |
2049002 | 2049002 | 2021-12-25 | Liberty | Montana | 30051 | 268 | 2 |
2049016 | 2049016 | 2021-12-25 | Prairie | Montana | 30079 | 195 | 2 |
2045752 | 2045752 | 2021-12-24 | Liberty | Montana | 30051 | 268 | 2 |
2045766 | 2045766 | 2021-12-24 | Prairie | Montana | 30079 | 195 | 2 |
2042502 | 2042502 | 2021-12-23 | Liberty | Montana | 30051 | 268 | 2 |
2042516 | 2042516 | 2021-12-23 | Prairie | Montana | 30079 | 195 | 2 |
2039253 | 2039253 | 2021-12-22 | Liberty | Montana | 30051 | 268 | 2 |
2039267 | 2039267 | 2021-12-22 | Prairie | Montana | 30079 | 194 | 2 |
2036003 | 2036003 | 2021-12-21 | Liberty | Montana | 30051 | 268 | 2 |
2036017 | 2036017 | 2021-12-21 | Prairie | Montana | 30079 | 194 | 2 |
2032753 | 2032753 | 2021-12-20 | Liberty | Montana | 30051 | 268 | 2 |
2032767 | 2032767 | 2021-12-20 | Prairie | Montana | 30079 | 192 | 2 |
2029502 | 2029502 | 2021-12-19 | Liberty | Montana | 30051 | 268 | 2 |
2029516 | 2029516 | 2021-12-19 | Prairie | Montana | 30079 | 190 | 2 |
2026251 | 2026251 | 2021-12-18 | Liberty | Montana | 30051 | 268 | 2 |
2026265 | 2026265 | 2021-12-18 | Prairie | Montana | 30079 | 190 | 2 |
2023000 | 2023000 | 2021-12-17 | Liberty | Montana | 30051 | 268 | 2 |
2023014 | 2023014 | 2021-12-17 | Prairie | Montana | 30079 | 190 | 2 |
2019749 | 2019749 | 2021-12-16 | Liberty | Montana | 30051 | 268 | 2 |
2019763 | 2019763 | 2021-12-16 | Prairie | Montana | 30079 | 189 | 2 |
2016499 | 2016499 | 2021-12-15 | Liberty | Montana | 30051 | 268 | 2 |
2016513 | 2016513 | 2021-12-15 | Prairie | Montana | 30079 | 190 | 2 |
2013248 | 2013248 | 2021-12-14 | Liberty | Montana | 30051 | 268 | 2 |
2013262 | 2013262 | 2021-12-14 | Prairie | Montana | 30079 | 190 | 2 |
2009997 | 2009997 | 2021-12-13 | Liberty | Montana | 30051 | 267 | 2 |
2010011 | 2010011 | 2021-12-13 | Prairie | Montana | 30079 | 189 | 2 |
2006746 | 2006746 | 2021-12-12 | Liberty | Montana | 30051 | 267 | 2 |
2006760 | 2006760 | 2021-12-12 | Prairie | Montana | 30079 | 189 | 2 |
2003495 | 2003495 | 2021-12-11 | Liberty | Montana | 30051 | 267 | 2 |
2003509 | 2003509 | 2021-12-11 | Prairie | Montana | 30079 | 189 | 2 |
2000245 | 2000245 | 2021-12-10 | Liberty | Montana | 30051 | 267 | 2 |
2000259 | 2000259 | 2021-12-10 | Prairie | Montana | 30079 | 189 | 2 |
1996994 | 1996994 | 2021-12-09 | Liberty | Montana | 30051 | 267 | 2 |
1997008 | 1997008 | 2021-12-09 | Prairie | Montana | 30079 | 189 | 2 |
1993743 | 1993743 | 2021-12-08 | Liberty | Montana | 30051 | 268 | 2 |
1993757 | 1993757 | 2021-12-08 | Prairie | Montana | 30079 | 189 | 2 |
1990492 | 1990492 | 2021-12-07 | Liberty | Montana | 30051 | 268 | 2 |
1990506 | 1990506 | 2021-12-07 | Prairie | Montana | 30079 | 189 | 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);