ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Lincoln" and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175836 | 2175836 | 2022-02-02 | Lincoln | Montana | 30053 | 4355 | 77 |
2172583 | 2172583 | 2022-02-01 | Lincoln | Montana | 30053 | 4335 | 77 |
2169330 | 2169330 | 2022-01-31 | Lincoln | Montana | 30053 | 4304 | 76 |
2166075 | 2166075 | 2022-01-30 | Lincoln | Montana | 30053 | 4245 | 75 |
2162820 | 2162820 | 2022-01-29 | Lincoln | Montana | 30053 | 4245 | 75 |
2159565 | 2159565 | 2022-01-28 | Lincoln | Montana | 30053 | 4245 | 75 |
2156311 | 2156311 | 2022-01-27 | Lincoln | Montana | 30053 | 4211 | 75 |
2153058 | 2153058 | 2022-01-26 | Lincoln | Montana | 30053 | 4171 | 75 |
2149806 | 2149806 | 2022-01-25 | Lincoln | Montana | 30053 | 4131 | 75 |
2146554 | 2146554 | 2022-01-24 | Lincoln | Montana | 30053 | 4090 | 75 |
2143299 | 2143299 | 2022-01-23 | Lincoln | Montana | 30053 | 4029 | 75 |
2140044 | 2140044 | 2022-01-22 | Lincoln | Montana | 30053 | 4029 | 75 |
2136788 | 2136788 | 2022-01-21 | Lincoln | Montana | 30053 | 4029 | 75 |
2133536 | 2133536 | 2022-01-20 | Lincoln | Montana | 30053 | 3999 | 75 |
2130283 | 2130283 | 2022-01-19 | Lincoln | Montana | 30053 | 3953 | 75 |
2127029 | 2127029 | 2022-01-18 | Lincoln | Montana | 30053 | 3906 | 75 |
2123777 | 2123777 | 2022-01-17 | Lincoln | Montana | 30053 | 3861 | 75 |
2120525 | 2120525 | 2022-01-16 | Lincoln | Montana | 30053 | 3861 | 75 |
2117273 | 2117273 | 2022-01-15 | Lincoln | Montana | 30053 | 3861 | 75 |
2114022 | 2114022 | 2022-01-14 | Lincoln | Montana | 30053 | 3861 | 75 |
2110770 | 2110770 | 2022-01-13 | Lincoln | Montana | 30053 | 3841 | 74 |
2107519 | 2107519 | 2022-01-12 | Lincoln | Montana | 30053 | 3826 | 74 |
2104268 | 2104268 | 2022-01-11 | Lincoln | Montana | 30053 | 3811 | 74 |
2101017 | 2101017 | 2022-01-10 | Lincoln | Montana | 30053 | 3773 | 74 |
2097766 | 2097766 | 2022-01-09 | Lincoln | Montana | 30053 | 3756 | 73 |
2094514 | 2094514 | 2022-01-08 | Lincoln | Montana | 30053 | 3756 | 73 |
2091262 | 2091262 | 2022-01-07 | Lincoln | Montana | 30053 | 3756 | 73 |
2088011 | 2088011 | 2022-01-06 | Lincoln | Montana | 30053 | 3747 | 73 |
2084759 | 2084759 | 2022-01-05 | Lincoln | Montana | 30053 | 3716 | 73 |
2081507 | 2081507 | 2022-01-04 | Lincoln | Montana | 30053 | 3695 | 73 |
2078255 | 2078255 | 2022-01-03 | Lincoln | Montana | 30053 | 3669 | 73 |
2075004 | 2075004 | 2022-01-02 | Lincoln | Montana | 30053 | 3659 | 73 |
2071753 | 2071753 | 2022-01-01 | Lincoln | Montana | 30053 | 3659 | 73 |
2068502 | 2068502 | 2021-12-31 | Lincoln | Montana | 30053 | 3659 | 73 |
2065251 | 2065251 | 2021-12-30 | Lincoln | Montana | 30053 | 3659 | 73 |
2062001 | 2062001 | 2021-12-29 | Lincoln | Montana | 30053 | 3646 | 73 |
2058752 | 2058752 | 2021-12-28 | Lincoln | Montana | 30053 | 3641 | 73 |
2055503 | 2055503 | 2021-12-27 | Lincoln | Montana | 30053 | 3630 | 73 |
2052253 | 2052253 | 2021-12-26 | Lincoln | Montana | 30053 | 3629 | 73 |
2049003 | 2049003 | 2021-12-25 | Lincoln | Montana | 30053 | 3629 | 73 |
2045753 | 2045753 | 2021-12-24 | Lincoln | Montana | 30053 | 3629 | 73 |
2042503 | 2042503 | 2021-12-23 | Lincoln | Montana | 30053 | 3629 | 73 |
2039254 | 2039254 | 2021-12-22 | Lincoln | Montana | 30053 | 3621 | 73 |
2036004 | 2036004 | 2021-12-21 | Lincoln | Montana | 30053 | 3623 | 73 |
2032754 | 2032754 | 2021-12-20 | Lincoln | Montana | 30053 | 3617 | 72 |
2029503 | 2029503 | 2021-12-19 | Lincoln | Montana | 30053 | 3608 | 72 |
2026252 | 2026252 | 2021-12-18 | Lincoln | Montana | 30053 | 3608 | 72 |
2023001 | 2023001 | 2021-12-17 | Lincoln | Montana | 30053 | 3608 | 72 |
2019750 | 2019750 | 2021-12-16 | Lincoln | Montana | 30053 | 3605 | 72 |
2016500 | 2016500 | 2021-12-15 | Lincoln | Montana | 30053 | 3595 | 72 |
2013249 | 2013249 | 2021-12-14 | Lincoln | Montana | 30053 | 3593 | 72 |
2009998 | 2009998 | 2021-12-13 | Lincoln | Montana | 30053 | 3590 | 68 |
2006747 | 2006747 | 2021-12-12 | Lincoln | Montana | 30053 | 3587 | 68 |
2003496 | 2003496 | 2021-12-11 | Lincoln | Montana | 30053 | 3587 | 68 |
2000246 | 2000246 | 2021-12-10 | Lincoln | Montana | 30053 | 3587 | 68 |
1996995 | 1996995 | 2021-12-09 | Lincoln | Montana | 30053 | 3584 | 68 |
1993744 | 1993744 | 2021-12-08 | Lincoln | Montana | 30053 | 3575 | 68 |
1990493 | 1990493 | 2021-12-07 | Lincoln | Montana | 30053 | 3574 | 68 |
1987243 | 1987243 | 2021-12-06 | Lincoln | Montana | 30053 | 3569 | 68 |
1983993 | 1983993 | 2021-12-05 | Lincoln | Montana | 30053 | 3564 | 68 |
1980743 | 1980743 | 2021-12-04 | Lincoln | Montana | 30053 | 3564 | 68 |
1977493 | 1977493 | 2021-12-03 | Lincoln | Montana | 30053 | 3564 | 68 |
1974243 | 1974243 | 2021-12-02 | Lincoln | Montana | 30053 | 3558 | 68 |
1970994 | 1970994 | 2021-12-01 | Lincoln | Montana | 30053 | 3555 | 68 |
1967744 | 1967744 | 2021-11-30 | Lincoln | Montana | 30053 | 3552 | 68 |
1964492 | 1964492 | 2021-11-29 | Lincoln | Montana | 30053 | 3545 | 68 |
1961241 | 1961241 | 2021-11-28 | Lincoln | Montana | 30053 | 3532 | 67 |
1957990 | 1957990 | 2021-11-27 | Lincoln | Montana | 30053 | 3532 | 67 |
1954739 | 1954739 | 2021-11-26 | Lincoln | Montana | 30053 | 3532 | 67 |
1951488 | 1951488 | 2021-11-25 | Lincoln | Montana | 30053 | 3520 | 67 |
1948237 | 1948237 | 2021-11-24 | Lincoln | Montana | 30053 | 3520 | 67 |
1944986 | 1944986 | 2021-11-23 | Lincoln | Montana | 30053 | 3506 | 66 |
1941735 | 1941735 | 2021-11-22 | Lincoln | Montana | 30053 | 3499 | 64 |
1938485 | 1938485 | 2021-11-21 | Lincoln | Montana | 30053 | 3489 | 60 |
1935235 | 1935235 | 2021-11-20 | Lincoln | Montana | 30053 | 3489 | 60 |
1931985 | 1931985 | 2021-11-19 | Lincoln | Montana | 30053 | 3489 | 60 |
1928734 | 1928734 | 2021-11-18 | Lincoln | Montana | 30053 | 3478 | 59 |
1925484 | 1925484 | 2021-11-17 | Lincoln | Montana | 30053 | 3466 | 59 |
1922235 | 1922235 | 2021-11-16 | Lincoln | Montana | 30053 | 3454 | 59 |
1918985 | 1918985 | 2021-11-15 | Lincoln | Montana | 30053 | 3439 | 58 |
1915735 | 1915735 | 2021-11-14 | Lincoln | Montana | 30053 | 3424 | 58 |
1912485 | 1912485 | 2021-11-13 | Lincoln | Montana | 30053 | 3424 | 58 |
1909235 | 1909235 | 2021-11-12 | Lincoln | Montana | 30053 | 3424 | 58 |
1905986 | 1905986 | 2021-11-11 | Lincoln | Montana | 30053 | 3409 | 58 |
1902737 | 1902737 | 2021-11-10 | Lincoln | Montana | 30053 | 3409 | 58 |
1899487 | 1899487 | 2021-11-09 | Lincoln | Montana | 30053 | 3407 | 58 |
1896237 | 1896237 | 2021-11-08 | Lincoln | Montana | 30053 | 3400 | 56 |
1892987 | 1892987 | 2021-11-07 | Lincoln | Montana | 30053 | 3391 | 56 |
1889737 | 1889737 | 2021-11-06 | Lincoln | Montana | 30053 | 3391 | 56 |
1886487 | 1886487 | 2021-11-05 | Lincoln | Montana | 30053 | 3391 | 56 |
1883238 | 1883238 | 2021-11-04 | Lincoln | Montana | 30053 | 3388 | 56 |
1879989 | 1879989 | 2021-11-03 | Lincoln | Montana | 30053 | 3379 | 56 |
1876740 | 1876740 | 2021-11-02 | Lincoln | Montana | 30053 | 3374 | 56 |
1873491 | 1873491 | 2021-11-01 | Lincoln | Montana | 30053 | 3365 | 56 |
1870242 | 1870242 | 2021-10-31 | Lincoln | Montana | 30053 | 3344 | 55 |
1866993 | 1866993 | 2021-10-30 | Lincoln | Montana | 30053 | 3344 | 55 |
1863744 | 1863744 | 2021-10-29 | Lincoln | Montana | 30053 | 3344 | 55 |
1860495 | 1860495 | 2021-10-28 | Lincoln | Montana | 30053 | 3337 | 55 |
1857246 | 1857246 | 2021-10-27 | Lincoln | Montana | 30053 | 3332 | 55 |
1853997 | 1853997 | 2021-10-26 | Lincoln | Montana | 30053 | 3318 | 55 |
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);