ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where county = "Granite", deaths = 6 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2192091 | 2192091 | 2022-02-07 | Granite | Montana | 30039 | 507 | 6 |
2188838 | 2188838 | 2022-02-06 | Granite | Montana | 30039 | 503 | 6 |
2185585 | 2185585 | 2022-02-05 | Granite | Montana | 30039 | 503 | 6 |
2182333 | 2182333 | 2022-02-04 | Granite | Montana | 30039 | 503 | 6 |
2179081 | 2179081 | 2022-02-03 | Granite | Montana | 30039 | 495 | 6 |
2175829 | 2175829 | 2022-02-02 | Granite | Montana | 30039 | 492 | 6 |
2172576 | 2172576 | 2022-02-01 | Granite | Montana | 30039 | 490 | 6 |
2169323 | 2169323 | 2022-01-31 | Granite | Montana | 30039 | 491 | 6 |
2166068 | 2166068 | 2022-01-30 | Granite | Montana | 30039 | 490 | 6 |
2162813 | 2162813 | 2022-01-29 | Granite | Montana | 30039 | 490 | 6 |
2159558 | 2159558 | 2022-01-28 | Granite | Montana | 30039 | 490 | 6 |
2156304 | 2156304 | 2022-01-27 | Granite | Montana | 30039 | 490 | 6 |
2153051 | 2153051 | 2022-01-26 | Granite | Montana | 30039 | 487 | 6 |
2149799 | 2149799 | 2022-01-25 | Granite | Montana | 30039 | 484 | 6 |
2146547 | 2146547 | 2022-01-24 | Granite | Montana | 30039 | 482 | 6 |
2143292 | 2143292 | 2022-01-23 | Granite | Montana | 30039 | 475 | 6 |
2140037 | 2140037 | 2022-01-22 | Granite | Montana | 30039 | 475 | 6 |
2136781 | 2136781 | 2022-01-21 | Granite | Montana | 30039 | 475 | 6 |
2133529 | 2133529 | 2022-01-20 | Granite | Montana | 30039 | 473 | 6 |
2130276 | 2130276 | 2022-01-19 | Granite | Montana | 30039 | 459 | 6 |
2127022 | 2127022 | 2022-01-18 | Granite | Montana | 30039 | 453 | 6 |
2123770 | 2123770 | 2022-01-17 | Granite | Montana | 30039 | 450 | 6 |
2120518 | 2120518 | 2022-01-16 | Granite | Montana | 30039 | 450 | 6 |
2117266 | 2117266 | 2022-01-15 | Granite | Montana | 30039 | 450 | 6 |
2114015 | 2114015 | 2022-01-14 | Granite | Montana | 30039 | 450 | 6 |
2110763 | 2110763 | 2022-01-13 | Granite | Montana | 30039 | 442 | 6 |
2107512 | 2107512 | 2022-01-12 | Granite | Montana | 30039 | 439 | 6 |
2104261 | 2104261 | 2022-01-11 | Granite | Montana | 30039 | 434 | 6 |
2101010 | 2101010 | 2022-01-10 | Granite | Montana | 30039 | 432 | 6 |
2097759 | 2097759 | 2022-01-09 | Granite | Montana | 30039 | 427 | 6 |
2094507 | 2094507 | 2022-01-08 | Granite | Montana | 30039 | 427 | 6 |
2091255 | 2091255 | 2022-01-07 | Granite | Montana | 30039 | 427 | 6 |
2088004 | 2088004 | 2022-01-06 | Granite | Montana | 30039 | 417 | 6 |
2084752 | 2084752 | 2022-01-05 | Granite | Montana | 30039 | 415 | 6 |
2081500 | 2081500 | 2022-01-04 | Granite | Montana | 30039 | 411 | 6 |
2078248 | 2078248 | 2022-01-03 | Granite | Montana | 30039 | 410 | 6 |
2074997 | 2074997 | 2022-01-02 | Granite | Montana | 30039 | 409 | 6 |
2071746 | 2071746 | 2022-01-01 | Granite | Montana | 30039 | 409 | 6 |
2068495 | 2068495 | 2021-12-31 | Granite | Montana | 30039 | 409 | 6 |
2065244 | 2065244 | 2021-12-30 | Granite | Montana | 30039 | 409 | 6 |
2061994 | 2061994 | 2021-12-29 | Granite | Montana | 30039 | 409 | 6 |
2058745 | 2058745 | 2021-12-28 | Granite | Montana | 30039 | 409 | 6 |
2055496 | 2055496 | 2021-12-27 | Granite | Montana | 30039 | 409 | 6 |
2052246 | 2052246 | 2021-12-26 | Granite | Montana | 30039 | 409 | 6 |
2048996 | 2048996 | 2021-12-25 | Granite | Montana | 30039 | 409 | 6 |
2045746 | 2045746 | 2021-12-24 | Granite | Montana | 30039 | 409 | 6 |
2042496 | 2042496 | 2021-12-23 | Granite | Montana | 30039 | 409 | 6 |
2039247 | 2039247 | 2021-12-22 | Granite | Montana | 30039 | 409 | 6 |
2035997 | 2035997 | 2021-12-21 | Granite | Montana | 30039 | 409 | 6 |
2032747 | 2032747 | 2021-12-20 | Granite | Montana | 30039 | 409 | 6 |
2029496 | 2029496 | 2021-12-19 | Granite | Montana | 30039 | 409 | 6 |
2026245 | 2026245 | 2021-12-18 | Granite | Montana | 30039 | 409 | 6 |
2022994 | 2022994 | 2021-12-17 | Granite | Montana | 30039 | 409 | 6 |
2019743 | 2019743 | 2021-12-16 | Granite | Montana | 30039 | 409 | 6 |
2016493 | 2016493 | 2021-12-15 | Granite | Montana | 30039 | 409 | 6 |
2013242 | 2013242 | 2021-12-14 | Granite | Montana | 30039 | 409 | 6 |
2009991 | 2009991 | 2021-12-13 | Granite | Montana | 30039 | 409 | 6 |
2006740 | 2006740 | 2021-12-12 | Granite | Montana | 30039 | 409 | 6 |
2003489 | 2003489 | 2021-12-11 | Granite | Montana | 30039 | 409 | 6 |
2000239 | 2000239 | 2021-12-10 | Granite | Montana | 30039 | 409 | 6 |
1996988 | 1996988 | 2021-12-09 | Granite | Montana | 30039 | 409 | 6 |
1993737 | 1993737 | 2021-12-08 | Granite | Montana | 30039 | 409 | 6 |
1990486 | 1990486 | 2021-12-07 | Granite | Montana | 30039 | 409 | 6 |
1987236 | 1987236 | 2021-12-06 | Granite | Montana | 30039 | 409 | 6 |
1983986 | 1983986 | 2021-12-05 | Granite | Montana | 30039 | 408 | 6 |
1980736 | 1980736 | 2021-12-04 | Granite | Montana | 30039 | 408 | 6 |
1977486 | 1977486 | 2021-12-03 | Granite | Montana | 30039 | 408 | 6 |
1974236 | 1974236 | 2021-12-02 | Granite | Montana | 30039 | 408 | 6 |
1970987 | 1970987 | 2021-12-01 | Granite | Montana | 30039 | 408 | 6 |
1967737 | 1967737 | 2021-11-30 | Granite | Montana | 30039 | 408 | 6 |
1964485 | 1964485 | 2021-11-29 | Granite | Montana | 30039 | 408 | 6 |
1961234 | 1961234 | 2021-11-28 | Granite | Montana | 30039 | 408 | 6 |
1957983 | 1957983 | 2021-11-27 | Granite | Montana | 30039 | 408 | 6 |
1954732 | 1954732 | 2021-11-26 | Granite | Montana | 30039 | 408 | 6 |
1951481 | 1951481 | 2021-11-25 | Granite | Montana | 30039 | 408 | 6 |
1948230 | 1948230 | 2021-11-24 | Granite | Montana | 30039 | 408 | 6 |
1944979 | 1944979 | 2021-11-23 | Granite | Montana | 30039 | 406 | 6 |
1941728 | 1941728 | 2021-11-22 | Granite | Montana | 30039 | 406 | 6 |
1938478 | 1938478 | 2021-11-21 | Granite | Montana | 30039 | 405 | 6 |
1935228 | 1935228 | 2021-11-20 | Granite | Montana | 30039 | 405 | 6 |
1931978 | 1931978 | 2021-11-19 | Granite | Montana | 30039 | 405 | 6 |
1928727 | 1928727 | 2021-11-18 | Granite | Montana | 30039 | 404 | 6 |
1925477 | 1925477 | 2021-11-17 | Granite | Montana | 30039 | 404 | 6 |
1922228 | 1922228 | 2021-11-16 | Granite | Montana | 30039 | 404 | 6 |
1918978 | 1918978 | 2021-11-15 | Granite | Montana | 30039 | 404 | 6 |
1915728 | 1915728 | 2021-11-14 | Granite | Montana | 30039 | 404 | 6 |
1912478 | 1912478 | 2021-11-13 | Granite | Montana | 30039 | 404 | 6 |
1909228 | 1909228 | 2021-11-12 | Granite | Montana | 30039 | 404 | 6 |
1905979 | 1905979 | 2021-11-11 | Granite | Montana | 30039 | 404 | 6 |
1902730 | 1902730 | 2021-11-10 | Granite | Montana | 30039 | 404 | 6 |
1899480 | 1899480 | 2021-11-09 | Granite | Montana | 30039 | 404 | 6 |
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);