ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 30081 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175850 | 2175850 | 2022-02-02 | Ravalli | Montana | 30081 | 6494 | 133 |
2172597 | 2172597 | 2022-02-01 | Ravalli | Montana | 30081 | 6465 | 133 |
2169344 | 2169344 | 2022-01-31 | Ravalli | Montana | 30081 | 6465 | 130 |
2166089 | 2166089 | 2022-01-30 | Ravalli | Montana | 30081 | 6423 | 130 |
2162834 | 2162834 | 2022-01-29 | Ravalli | Montana | 30081 | 6423 | 130 |
2159579 | 2159579 | 2022-01-28 | Ravalli | Montana | 30081 | 6423 | 130 |
2156325 | 2156325 | 2022-01-27 | Ravalli | Montana | 30081 | 6360 | 130 |
2153072 | 2153072 | 2022-01-26 | Ravalli | Montana | 30081 | 6320 | 130 |
2149820 | 2149820 | 2022-01-25 | Ravalli | Montana | 30081 | 6276 | 130 |
2146568 | 2146568 | 2022-01-24 | Ravalli | Montana | 30081 | 6230 | 130 |
2143313 | 2143313 | 2022-01-23 | Ravalli | Montana | 30081 | 6086 | 129 |
2140058 | 2140058 | 2022-01-22 | Ravalli | Montana | 30081 | 6086 | 129 |
2136802 | 2136802 | 2022-01-21 | Ravalli | Montana | 30081 | 6086 | 129 |
2133550 | 2133550 | 2022-01-20 | Ravalli | Montana | 30081 | 6048 | 129 |
2130297 | 2130297 | 2022-01-19 | Ravalli | Montana | 30081 | 5950 | 129 |
2127043 | 2127043 | 2022-01-18 | Ravalli | Montana | 30081 | 5872 | 129 |
2123791 | 2123791 | 2022-01-17 | Ravalli | Montana | 30081 | 5841 | 129 |
2120539 | 2120539 | 2022-01-16 | Ravalli | Montana | 30081 | 5841 | 129 |
2117287 | 2117287 | 2022-01-15 | Ravalli | Montana | 30081 | 5841 | 129 |
2114036 | 2114036 | 2022-01-14 | Ravalli | Montana | 30081 | 5841 | 129 |
2110784 | 2110784 | 2022-01-13 | Ravalli | Montana | 30081 | 5804 | 129 |
2107533 | 2107533 | 2022-01-12 | Ravalli | Montana | 30081 | 5770 | 129 |
2104282 | 2104282 | 2022-01-11 | Ravalli | Montana | 30081 | 5736 | 129 |
2101031 | 2101031 | 2022-01-10 | Ravalli | Montana | 30081 | 5687 | 129 |
2097780 | 2097780 | 2022-01-09 | Ravalli | Montana | 30081 | 5649 | 129 |
2094528 | 2094528 | 2022-01-08 | Ravalli | Montana | 30081 | 5649 | 129 |
2091276 | 2091276 | 2022-01-07 | Ravalli | Montana | 30081 | 5649 | 129 |
2088025 | 2088025 | 2022-01-06 | Ravalli | Montana | 30081 | 5619 | 129 |
2084773 | 2084773 | 2022-01-05 | Ravalli | Montana | 30081 | 5535 | 129 |
2081521 | 2081521 | 2022-01-04 | Ravalli | Montana | 30081 | 5534 | 129 |
2078269 | 2078269 | 2022-01-03 | Ravalli | Montana | 30081 | 5532 | 129 |
2075018 | 2075018 | 2022-01-02 | Ravalli | Montana | 30081 | 5518 | 128 |
2071767 | 2071767 | 2022-01-01 | Ravalli | Montana | 30081 | 5518 | 128 |
2068516 | 2068516 | 2021-12-31 | Ravalli | Montana | 30081 | 5518 | 128 |
2065265 | 2065265 | 2021-12-30 | Ravalli | Montana | 30081 | 5518 | 128 |
2062015 | 2062015 | 2021-12-29 | Ravalli | Montana | 30081 | 5503 | 128 |
2058766 | 2058766 | 2021-12-28 | Ravalli | Montana | 30081 | 5496 | 128 |
2055517 | 2055517 | 2021-12-27 | Ravalli | Montana | 30081 | 5479 | 128 |
2052267 | 2052267 | 2021-12-26 | Ravalli | Montana | 30081 | 5474 | 128 |
2049017 | 2049017 | 2021-12-25 | Ravalli | Montana | 30081 | 5474 | 128 |
2045767 | 2045767 | 2021-12-24 | Ravalli | Montana | 30081 | 5474 | 128 |
2042517 | 2042517 | 2021-12-23 | Ravalli | Montana | 30081 | 5474 | 128 |
2039268 | 2039268 | 2021-12-22 | Ravalli | Montana | 30081 | 5471 | 128 |
2036018 | 2036018 | 2021-12-21 | Ravalli | Montana | 30081 | 5467 | 128 |
2032768 | 2032768 | 2021-12-20 | Ravalli | Montana | 30081 | 5465 | 128 |
2029517 | 2029517 | 2021-12-19 | Ravalli | Montana | 30081 | 5460 | 128 |
2026266 | 2026266 | 2021-12-18 | Ravalli | Montana | 30081 | 5460 | 128 |
2023015 | 2023015 | 2021-12-17 | Ravalli | Montana | 30081 | 5460 | 128 |
2019764 | 2019764 | 2021-12-16 | Ravalli | Montana | 30081 | 5460 | 128 |
2016514 | 2016514 | 2021-12-15 | Ravalli | Montana | 30081 | 5459 | 128 |
2013263 | 2013263 | 2021-12-14 | Ravalli | Montana | 30081 | 5455 | 128 |
2010012 | 2010012 | 2021-12-13 | Ravalli | Montana | 30081 | 5450 | 118 |
2006761 | 2006761 | 2021-12-12 | Ravalli | Montana | 30081 | 5445 | 118 |
2003510 | 2003510 | 2021-12-11 | Ravalli | Montana | 30081 | 5445 | 118 |
2000260 | 2000260 | 2021-12-10 | Ravalli | Montana | 30081 | 5445 | 118 |
1997009 | 1997009 | 2021-12-09 | Ravalli | Montana | 30081 | 5450 | 118 |
1993758 | 1993758 | 2021-12-08 | Ravalli | Montana | 30081 | 5447 | 118 |
1990507 | 1990507 | 2021-12-07 | Ravalli | Montana | 30081 | 5443 | 118 |
1987257 | 1987257 | 2021-12-06 | Ravalli | Montana | 30081 | 5427 | 117 |
1984007 | 1984007 | 2021-12-05 | Ravalli | Montana | 30081 | 5419 | 117 |
1980757 | 1980757 | 2021-12-04 | Ravalli | Montana | 30081 | 5419 | 117 |
1977507 | 1977507 | 2021-12-03 | Ravalli | Montana | 30081 | 5419 | 117 |
1974257 | 1974257 | 2021-12-02 | Ravalli | Montana | 30081 | 5413 | 116 |
1971008 | 1971008 | 2021-12-01 | Ravalli | Montana | 30081 | 5404 | 116 |
1967758 | 1967758 | 2021-11-30 | Ravalli | Montana | 30081 | 5401 | 72 |
1964506 | 1964506 | 2021-11-29 | Ravalli | Montana | 30081 | 5392 | 72 |
1961255 | 1961255 | 2021-11-28 | Ravalli | Montana | 30081 | 5380 | 72 |
1958004 | 1958004 | 2021-11-27 | Ravalli | Montana | 30081 | 5380 | 72 |
1954753 | 1954753 | 2021-11-26 | Ravalli | Montana | 30081 | 5380 | 72 |
1951502 | 1951502 | 2021-11-25 | Ravalli | Montana | 30081 | 5373 | 72 |
1948251 | 1948251 | 2021-11-24 | Ravalli | Montana | 30081 | 5373 | 72 |
1945000 | 1945000 | 2021-11-23 | Ravalli | Montana | 30081 | 5372 | 72 |
1941749 | 1941749 | 2021-11-22 | Ravalli | Montana | 30081 | 5366 | 71 |
1938499 | 1938499 | 2021-11-21 | Ravalli | Montana | 30081 | 5354 | 71 |
1935249 | 1935249 | 2021-11-20 | Ravalli | Montana | 30081 | 5354 | 71 |
1931999 | 1931999 | 2021-11-19 | Ravalli | Montana | 30081 | 5354 | 71 |
1928748 | 1928748 | 2021-11-18 | Ravalli | Montana | 30081 | 5280 | 71 |
1925498 | 1925498 | 2021-11-17 | Ravalli | Montana | 30081 | 5272 | 70 |
1922249 | 1922249 | 2021-11-16 | Ravalli | Montana | 30081 | 5269 | 69 |
1918999 | 1918999 | 2021-11-15 | Ravalli | Montana | 30081 | 5257 | 68 |
1915749 | 1915749 | 2021-11-14 | Ravalli | Montana | 30081 | 5235 | 67 |
1912499 | 1912499 | 2021-11-13 | Ravalli | Montana | 30081 | 5235 | 67 |
1909249 | 1909249 | 2021-11-12 | Ravalli | Montana | 30081 | 5235 | 67 |
1906000 | 1906000 | 2021-11-11 | Ravalli | Montana | 30081 | 5215 | 67 |
1902751 | 1902751 | 2021-11-10 | Ravalli | Montana | 30081 | 5215 | 67 |
1899501 | 1899501 | 2021-11-09 | Ravalli | Montana | 30081 | 5203 | 67 |
1896251 | 1896251 | 2021-11-08 | Ravalli | Montana | 30081 | 5190 | 67 |
1893001 | 1893001 | 2021-11-07 | Ravalli | Montana | 30081 | 5145 | 66 |
1889751 | 1889751 | 2021-11-06 | Ravalli | Montana | 30081 | 5145 | 66 |
1886501 | 1886501 | 2021-11-05 | Ravalli | Montana | 30081 | 5145 | 66 |
1883252 | 1883252 | 2021-11-04 | Ravalli | Montana | 30081 | 5137 | 66 |
1880003 | 1880003 | 2021-11-03 | Ravalli | Montana | 30081 | 5117 | 66 |
1876754 | 1876754 | 2021-11-02 | Ravalli | Montana | 30081 | 5110 | 66 |
1873505 | 1873505 | 2021-11-01 | Ravalli | Montana | 30081 | 5105 | 66 |
1870256 | 1870256 | 2021-10-31 | Ravalli | Montana | 30081 | 5073 | 66 |
1867007 | 1867007 | 2021-10-30 | Ravalli | Montana | 30081 | 5073 | 66 |
1863758 | 1863758 | 2021-10-29 | Ravalli | Montana | 30081 | 5073 | 66 |
1860509 | 1860509 | 2021-10-28 | Ravalli | Montana | 30081 | 5063 | 66 |
1857260 | 1857260 | 2021-10-27 | Ravalli | Montana | 30081 | 5038 | 66 |
1854011 | 1854011 | 2021-10-26 | Ravalli | Montana | 30081 | 5015 | 65 |
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);