ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Hill" and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175830 | 2175830 | 2022-02-02 | Hill | Montana | 30041 | 4130 | 71 |
2172577 | 2172577 | 2022-02-01 | Hill | Montana | 30041 | 4124 | 71 |
2169324 | 2169324 | 2022-01-31 | Hill | Montana | 30041 | 4067 | 71 |
2166069 | 2166069 | 2022-01-30 | Hill | Montana | 30041 | 3995 | 71 |
2162814 | 2162814 | 2022-01-29 | Hill | Montana | 30041 | 3995 | 71 |
2159559 | 2159559 | 2022-01-28 | Hill | Montana | 30041 | 3995 | 71 |
2156305 | 2156305 | 2022-01-27 | Hill | Montana | 30041 | 3934 | 71 |
2153052 | 2153052 | 2022-01-26 | Hill | Montana | 30041 | 3895 | 71 |
2149800 | 2149800 | 2022-01-25 | Hill | Montana | 30041 | 3800 | 71 |
2146548 | 2146548 | 2022-01-24 | Hill | Montana | 30041 | 3764 | 71 |
2143293 | 2143293 | 2022-01-23 | Hill | Montana | 30041 | 3721 | 71 |
2140038 | 2140038 | 2022-01-22 | Hill | Montana | 30041 | 3721 | 71 |
2136782 | 2136782 | 2022-01-21 | Hill | Montana | 30041 | 3721 | 71 |
2133530 | 2133530 | 2022-01-20 | Hill | Montana | 30041 | 3659 | 71 |
2130277 | 2130277 | 2022-01-19 | Hill | Montana | 30041 | 3601 | 71 |
2127023 | 2127023 | 2022-01-18 | Hill | Montana | 30041 | 3585 | 71 |
2123771 | 2123771 | 2022-01-17 | Hill | Montana | 30041 | 3532 | 71 |
2120519 | 2120519 | 2022-01-16 | Hill | Montana | 30041 | 3532 | 71 |
2117267 | 2117267 | 2022-01-15 | Hill | Montana | 30041 | 3532 | 71 |
2114016 | 2114016 | 2022-01-14 | Hill | Montana | 30041 | 3532 | 71 |
2110764 | 2110764 | 2022-01-13 | Hill | Montana | 30041 | 3513 | 71 |
2107513 | 2107513 | 2022-01-12 | Hill | Montana | 30041 | 3502 | 71 |
2104262 | 2104262 | 2022-01-11 | Hill | Montana | 30041 | 3489 | 71 |
2101011 | 2101011 | 2022-01-10 | Hill | Montana | 30041 | 3479 | 71 |
2097760 | 2097760 | 2022-01-09 | Hill | Montana | 30041 | 3469 | 71 |
2094508 | 2094508 | 2022-01-08 | Hill | Montana | 30041 | 3469 | 71 |
2091256 | 2091256 | 2022-01-07 | Hill | Montana | 30041 | 3469 | 71 |
2088005 | 2088005 | 2022-01-06 | Hill | Montana | 30041 | 3459 | 71 |
2084753 | 2084753 | 2022-01-05 | Hill | Montana | 30041 | 3452 | 71 |
2081501 | 2081501 | 2022-01-04 | Hill | Montana | 30041 | 3450 | 71 |
2078249 | 2078249 | 2022-01-03 | Hill | Montana | 30041 | 3440 | 71 |
2074998 | 2074998 | 2022-01-02 | Hill | Montana | 30041 | 3437 | 71 |
2071747 | 2071747 | 2022-01-01 | Hill | Montana | 30041 | 3437 | 71 |
2068496 | 2068496 | 2021-12-31 | Hill | Montana | 30041 | 3437 | 71 |
2065245 | 2065245 | 2021-12-30 | Hill | Montana | 30041 | 3437 | 71 |
2061995 | 2061995 | 2021-12-29 | Hill | Montana | 30041 | 3433 | 71 |
2058746 | 2058746 | 2021-12-28 | Hill | Montana | 30041 | 3430 | 71 |
2055497 | 2055497 | 2021-12-27 | Hill | Montana | 30041 | 3430 | 71 |
2052247 | 2052247 | 2021-12-26 | Hill | Montana | 30041 | 3430 | 71 |
2048997 | 2048997 | 2021-12-25 | Hill | Montana | 30041 | 3430 | 71 |
2045747 | 2045747 | 2021-12-24 | Hill | Montana | 30041 | 3430 | 71 |
2042497 | 2042497 | 2021-12-23 | Hill | Montana | 30041 | 3430 | 71 |
2039248 | 2039248 | 2021-12-22 | Hill | Montana | 30041 | 3427 | 71 |
2035998 | 2035998 | 2021-12-21 | Hill | Montana | 30041 | 3428 | 71 |
2032748 | 2032748 | 2021-12-20 | Hill | Montana | 30041 | 3425 | 71 |
2029497 | 2029497 | 2021-12-19 | Hill | Montana | 30041 | 3421 | 71 |
2026246 | 2026246 | 2021-12-18 | Hill | Montana | 30041 | 3421 | 71 |
2022995 | 2022995 | 2021-12-17 | Hill | Montana | 30041 | 3421 | 71 |
2019744 | 2019744 | 2021-12-16 | Hill | Montana | 30041 | 3421 | 71 |
2016494 | 2016494 | 2021-12-15 | Hill | Montana | 30041 | 3421 | 71 |
2013243 | 2013243 | 2021-12-14 | Hill | Montana | 30041 | 3418 | 71 |
2009992 | 2009992 | 2021-12-13 | Hill | Montana | 30041 | 3417 | 71 |
2006741 | 2006741 | 2021-12-12 | Hill | Montana | 30041 | 3413 | 71 |
2003490 | 2003490 | 2021-12-11 | Hill | Montana | 30041 | 3413 | 71 |
2000240 | 2000240 | 2021-12-10 | Hill | Montana | 30041 | 3413 | 71 |
1996989 | 1996989 | 2021-12-09 | Hill | Montana | 30041 | 3409 | 71 |
1993738 | 1993738 | 2021-12-08 | Hill | Montana | 30041 | 3406 | 71 |
1990487 | 1990487 | 2021-12-07 | Hill | Montana | 30041 | 3404 | 71 |
1987237 | 1987237 | 2021-12-06 | Hill | Montana | 30041 | 3403 | 71 |
1983987 | 1983987 | 2021-12-05 | Hill | Montana | 30041 | 3391 | 71 |
1980737 | 1980737 | 2021-12-04 | Hill | Montana | 30041 | 3391 | 71 |
1977487 | 1977487 | 2021-12-03 | Hill | Montana | 30041 | 3391 | 71 |
1974237 | 1974237 | 2021-12-02 | Hill | Montana | 30041 | 3388 | 71 |
1970988 | 1970988 | 2021-12-01 | Hill | Montana | 30041 | 3388 | 71 |
1967738 | 1967738 | 2021-11-30 | Hill | Montana | 30041 | 3386 | 71 |
1964486 | 1964486 | 2021-11-29 | Hill | Montana | 30041 | 3386 | 71 |
1961235 | 1961235 | 2021-11-28 | Hill | Montana | 30041 | 3380 | 71 |
1957984 | 1957984 | 2021-11-27 | Hill | Montana | 30041 | 3380 | 71 |
1954733 | 1954733 | 2021-11-26 | Hill | Montana | 30041 | 3380 | 71 |
1951482 | 1951482 | 2021-11-25 | Hill | Montana | 30041 | 3378 | 69 |
1948231 | 1948231 | 2021-11-24 | Hill | Montana | 30041 | 3378 | 69 |
1944980 | 1944980 | 2021-11-23 | Hill | Montana | 30041 | 3376 | 69 |
1941729 | 1941729 | 2021-11-22 | Hill | Montana | 30041 | 3376 | 65 |
1938479 | 1938479 | 2021-11-21 | Hill | Montana | 30041 | 3365 | 65 |
1935229 | 1935229 | 2021-11-20 | Hill | Montana | 30041 | 3365 | 65 |
1931979 | 1931979 | 2021-11-19 | Hill | Montana | 30041 | 3365 | 65 |
1928728 | 1928728 | 2021-11-18 | Hill | Montana | 30041 | 3359 | 65 |
1925478 | 1925478 | 2021-11-17 | Hill | Montana | 30041 | 3358 | 65 |
1922229 | 1922229 | 2021-11-16 | Hill | Montana | 30041 | 3352 | 65 |
1918979 | 1918979 | 2021-11-15 | Hill | Montana | 30041 | 3346 | 65 |
1915729 | 1915729 | 2021-11-14 | Hill | Montana | 30041 | 3325 | 65 |
1912479 | 1912479 | 2021-11-13 | Hill | Montana | 30041 | 3325 | 65 |
1909229 | 1909229 | 2021-11-12 | Hill | Montana | 30041 | 3325 | 65 |
1905980 | 1905980 | 2021-11-11 | Hill | Montana | 30041 | 3314 | 65 |
1902731 | 1902731 | 2021-11-10 | Hill | Montana | 30041 | 3314 | 65 |
1899481 | 1899481 | 2021-11-09 | Hill | Montana | 30041 | 3309 | 64 |
1896231 | 1896231 | 2021-11-08 | Hill | Montana | 30041 | 3304 | 64 |
1892981 | 1892981 | 2021-11-07 | Hill | Montana | 30041 | 3289 | 64 |
1889731 | 1889731 | 2021-11-06 | Hill | Montana | 30041 | 3289 | 64 |
1886481 | 1886481 | 2021-11-05 | Hill | Montana | 30041 | 3289 | 64 |
1883232 | 1883232 | 2021-11-04 | Hill | Montana | 30041 | 3279 | 64 |
1879983 | 1879983 | 2021-11-03 | Hill | Montana | 30041 | 3265 | 64 |
1876734 | 1876734 | 2021-11-02 | Hill | Montana | 30041 | 3259 | 63 |
1873485 | 1873485 | 2021-11-01 | Hill | Montana | 30041 | 3251 | 63 |
1870236 | 1870236 | 2021-10-31 | Hill | Montana | 30041 | 3232 | 61 |
1866987 | 1866987 | 2021-10-30 | Hill | Montana | 30041 | 3232 | 61 |
1863738 | 1863738 | 2021-10-29 | Hill | Montana | 30041 | 3232 | 61 |
1860489 | 1860489 | 2021-10-28 | Hill | Montana | 30041 | 3224 | 61 |
1857240 | 1857240 | 2021-10-27 | Hill | Montana | 30041 | 3212 | 61 |
1853991 | 1853991 | 2021-10-26 | Hill | Montana | 30041 | 3199 | 60 |
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);