ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where fips = 30003 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175811 | 2175811 | 2022-02-02 | Big Horn | Montana | 30003 | 4107 | 89 |
2172558 | 2172558 | 2022-02-01 | Big Horn | Montana | 30003 | 4090 | 89 |
2169305 | 2169305 | 2022-01-31 | Big Horn | Montana | 30003 | 4076 | 89 |
2166050 | 2166050 | 2022-01-30 | Big Horn | Montana | 30003 | 3997 | 87 |
2162795 | 2162795 | 2022-01-29 | Big Horn | Montana | 30003 | 3997 | 87 |
2159540 | 2159540 | 2022-01-28 | Big Horn | Montana | 30003 | 3997 | 87 |
2156286 | 2156286 | 2022-01-27 | Big Horn | Montana | 30003 | 3903 | 87 |
2153033 | 2153033 | 2022-01-26 | Big Horn | Montana | 30003 | 3891 | 87 |
2149781 | 2149781 | 2022-01-25 | Big Horn | Montana | 30003 | 3824 | 87 |
2146529 | 2146529 | 2022-01-24 | Big Horn | Montana | 30003 | 3735 | 87 |
2143274 | 2143274 | 2022-01-23 | Big Horn | Montana | 30003 | 3645 | 87 |
2140019 | 2140019 | 2022-01-22 | Big Horn | Montana | 30003 | 3645 | 87 |
2136763 | 2136763 | 2022-01-21 | Big Horn | Montana | 30003 | 3645 | 87 |
2133511 | 2133511 | 2022-01-20 | Big Horn | Montana | 30003 | 3609 | 87 |
2130258 | 2130258 | 2022-01-19 | Big Horn | Montana | 30003 | 3583 | 87 |
2127004 | 2127004 | 2022-01-18 | Big Horn | Montana | 30003 | 3534 | 87 |
2123752 | 2123752 | 2022-01-17 | Big Horn | Montana | 30003 | 3522 | 86 |
2120500 | 2120500 | 2022-01-16 | Big Horn | Montana | 30003 | 3522 | 86 |
2117248 | 2117248 | 2022-01-15 | Big Horn | Montana | 30003 | 3522 | 86 |
2113997 | 2113997 | 2022-01-14 | Big Horn | Montana | 30003 | 3522 | 86 |
2110745 | 2110745 | 2022-01-13 | Big Horn | Montana | 30003 | 3508 | 86 |
2107494 | 2107494 | 2022-01-12 | Big Horn | Montana | 30003 | 3503 | 86 |
2104243 | 2104243 | 2022-01-11 | Big Horn | Montana | 30003 | 3487 | 86 |
2100992 | 2100992 | 2022-01-10 | Big Horn | Montana | 30003 | 3483 | 86 |
2097741 | 2097741 | 2022-01-09 | Big Horn | Montana | 30003 | 3480 | 84 |
2094489 | 2094489 | 2022-01-08 | Big Horn | Montana | 30003 | 3480 | 84 |
2091237 | 2091237 | 2022-01-07 | Big Horn | Montana | 30003 | 3480 | 84 |
2087986 | 2087986 | 2022-01-06 | Big Horn | Montana | 30003 | 3478 | 84 |
2084734 | 2084734 | 2022-01-05 | Big Horn | Montana | 30003 | 3464 | 84 |
2081482 | 2081482 | 2022-01-04 | Big Horn | Montana | 30003 | 3461 | 84 |
2078230 | 2078230 | 2022-01-03 | Big Horn | Montana | 30003 | 3461 | 84 |
2074979 | 2074979 | 2022-01-02 | Big Horn | Montana | 30003 | 3460 | 84 |
2071728 | 2071728 | 2022-01-01 | Big Horn | Montana | 30003 | 3460 | 84 |
2068477 | 2068477 | 2021-12-31 | Big Horn | Montana | 30003 | 3460 | 84 |
2065226 | 2065226 | 2021-12-30 | Big Horn | Montana | 30003 | 3460 | 84 |
2061976 | 2061976 | 2021-12-29 | Big Horn | Montana | 30003 | 3460 | 84 |
2058727 | 2058727 | 2021-12-28 | Big Horn | Montana | 30003 | 3460 | 84 |
2055478 | 2055478 | 2021-12-27 | Big Horn | Montana | 30003 | 3455 | 84 |
2052228 | 2052228 | 2021-12-26 | Big Horn | Montana | 30003 | 3455 | 84 |
2048978 | 2048978 | 2021-12-25 | Big Horn | Montana | 30003 | 3455 | 84 |
2045728 | 2045728 | 2021-12-24 | Big Horn | Montana | 30003 | 3455 | 84 |
2042478 | 2042478 | 2021-12-23 | Big Horn | Montana | 30003 | 3455 | 84 |
2039229 | 2039229 | 2021-12-22 | Big Horn | Montana | 30003 | 3453 | 84 |
2035979 | 2035979 | 2021-12-21 | Big Horn | Montana | 30003 | 3453 | 84 |
2032729 | 2032729 | 2021-12-20 | Big Horn | Montana | 30003 | 3454 | 84 |
2029478 | 2029478 | 2021-12-19 | Big Horn | Montana | 30003 | 3450 | 84 |
2026227 | 2026227 | 2021-12-18 | Big Horn | Montana | 30003 | 3450 | 84 |
2022976 | 2022976 | 2021-12-17 | Big Horn | Montana | 30003 | 3450 | 84 |
2019725 | 2019725 | 2021-12-16 | Big Horn | Montana | 30003 | 3443 | 84 |
2016475 | 2016475 | 2021-12-15 | Big Horn | Montana | 30003 | 3443 | 84 |
2013224 | 2013224 | 2021-12-14 | Big Horn | Montana | 30003 | 3443 | 84 |
2009973 | 2009973 | 2021-12-13 | Big Horn | Montana | 30003 | 3443 | 84 |
2006722 | 2006722 | 2021-12-12 | Big Horn | Montana | 30003 | 3442 | 84 |
2003471 | 2003471 | 2021-12-11 | Big Horn | Montana | 30003 | 3442 | 84 |
2000221 | 2000221 | 2021-12-10 | Big Horn | Montana | 30003 | 3442 | 84 |
1996970 | 1996970 | 2021-12-09 | Big Horn | Montana | 30003 | 3441 | 84 |
1993719 | 1993719 | 2021-12-08 | Big Horn | Montana | 30003 | 3441 | 84 |
1990468 | 1990468 | 2021-12-07 | Big Horn | Montana | 30003 | 3441 | 84 |
1987218 | 1987218 | 2021-12-06 | Big Horn | Montana | 30003 | 3425 | 84 |
1983968 | 1983968 | 2021-12-05 | Big Horn | Montana | 30003 | 3423 | 83 |
1980718 | 1980718 | 2021-12-04 | Big Horn | Montana | 30003 | 3423 | 83 |
1977468 | 1977468 | 2021-12-03 | Big Horn | Montana | 30003 | 3423 | 83 |
1974218 | 1974218 | 2021-12-02 | Big Horn | Montana | 30003 | 3423 | 83 |
1970969 | 1970969 | 2021-12-01 | Big Horn | Montana | 30003 | 3423 | 83 |
1967719 | 1967719 | 2021-11-30 | Big Horn | Montana | 30003 | 3417 | 83 |
1964467 | 1964467 | 2021-11-29 | Big Horn | Montana | 30003 | 3416 | 83 |
1961216 | 1961216 | 2021-11-28 | Big Horn | Montana | 30003 | 3414 | 83 |
1957965 | 1957965 | 2021-11-27 | Big Horn | Montana | 30003 | 3414 | 83 |
1954714 | 1954714 | 2021-11-26 | Big Horn | Montana | 30003 | 3414 | 83 |
1951463 | 1951463 | 2021-11-25 | Big Horn | Montana | 30003 | 3403 | 83 |
1948212 | 1948212 | 2021-11-24 | Big Horn | Montana | 30003 | 3403 | 83 |
1944961 | 1944961 | 2021-11-23 | Big Horn | Montana | 30003 | 3402 | 83 |
1941710 | 1941710 | 2021-11-22 | Big Horn | Montana | 30003 | 3398 | 82 |
1938460 | 1938460 | 2021-11-21 | Big Horn | Montana | 30003 | 3398 | 82 |
1935210 | 1935210 | 2021-11-20 | Big Horn | Montana | 30003 | 3398 | 82 |
1931960 | 1931960 | 2021-11-19 | Big Horn | Montana | 30003 | 3398 | 82 |
1928709 | 1928709 | 2021-11-18 | Big Horn | Montana | 30003 | 3402 | 82 |
1925459 | 1925459 | 2021-11-17 | Big Horn | Montana | 30003 | 3316 | 82 |
1922210 | 1922210 | 2021-11-16 | Big Horn | Montana | 30003 | 3253 | 82 |
1918960 | 1918960 | 2021-11-15 | Big Horn | Montana | 30003 | 3231 | 82 |
1915710 | 1915710 | 2021-11-14 | Big Horn | Montana | 30003 | 3196 | 82 |
1912460 | 1912460 | 2021-11-13 | Big Horn | Montana | 30003 | 3196 | 82 |
1909210 | 1909210 | 2021-11-12 | Big Horn | Montana | 30003 | 3196 | 82 |
1905961 | 1905961 | 2021-11-11 | Big Horn | Montana | 30003 | 3127 | 82 |
1902712 | 1902712 | 2021-11-10 | Big Horn | Montana | 30003 | 3127 | 82 |
1899462 | 1899462 | 2021-11-09 | Big Horn | Montana | 30003 | 3096 | 82 |
1896212 | 1896212 | 2021-11-08 | Big Horn | Montana | 30003 | 3091 | 82 |
1892962 | 1892962 | 2021-11-07 | Big Horn | Montana | 30003 | 3091 | 82 |
1889712 | 1889712 | 2021-11-06 | Big Horn | Montana | 30003 | 3091 | 82 |
1886462 | 1886462 | 2021-11-05 | Big Horn | Montana | 30003 | 3091 | 82 |
1883213 | 1883213 | 2021-11-04 | Big Horn | Montana | 30003 | 3089 | 82 |
1879964 | 1879964 | 2021-11-03 | Big Horn | Montana | 30003 | 3083 | 82 |
1876715 | 1876715 | 2021-11-02 | Big Horn | Montana | 30003 | 3060 | 82 |
1873466 | 1873466 | 2021-11-01 | Big Horn | Montana | 30003 | 3039 | 82 |
1870217 | 1870217 | 2021-10-31 | Big Horn | Montana | 30003 | 3027 | 82 |
1866968 | 1866968 | 2021-10-30 | Big Horn | Montana | 30003 | 3027 | 82 |
1863719 | 1863719 | 2021-10-29 | Big Horn | Montana | 30003 | 3027 | 82 |
1860470 | 1860470 | 2021-10-28 | Big Horn | Montana | 30003 | 3024 | 82 |
1857221 | 1857221 | 2021-10-27 | Big Horn | Montana | 30003 | 3020 | 82 |
1853972 | 1853972 | 2021-10-26 | Big Horn | Montana | 30003 | 3016 | 82 |
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);