ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where county = "Green" and deaths = 34 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1917271 | 1917271 | 2021-11-14 | Green | Wisconsin | 55045 | 4959 | 34 |
1914021 | 1914021 | 2021-11-13 | Green | Wisconsin | 55045 | 4959 | 34 |
1910771 | 1910771 | 2021-11-12 | Green | Wisconsin | 55045 | 4959 | 34 |
1907522 | 1907522 | 2021-11-11 | Green | Wisconsin | 55045 | 4943 | 34 |
1904273 | 1904273 | 2021-11-10 | Green | Wisconsin | 55045 | 4907 | 34 |
1898891 | 1898891 | 2021-11-09 | Green | Kentucky | 21087 | 2510 | 34 |
1901023 | 1901023 | 2021-11-09 | Green | Wisconsin | 55045 | 4875 | 34 |
1895641 | 1895641 | 2021-11-08 | Green | Kentucky | 21087 | 2499 | 34 |
1897773 | 1897773 | 2021-11-08 | Green | Wisconsin | 55045 | 4858 | 34 |
1892391 | 1892391 | 2021-11-07 | Green | Kentucky | 21087 | 2499 | 34 |
1894523 | 1894523 | 2021-11-07 | Green | Wisconsin | 55045 | 4785 | 34 |
1889141 | 1889141 | 2021-11-06 | Green | Kentucky | 21087 | 2499 | 34 |
1891273 | 1891273 | 2021-11-06 | Green | Wisconsin | 55045 | 4785 | 34 |
1885891 | 1885891 | 2021-11-05 | Green | Kentucky | 21087 | 2499 | 34 |
1888023 | 1888023 | 2021-11-05 | Green | Wisconsin | 55045 | 4785 | 34 |
1882642 | 1882642 | 2021-11-04 | Green | Kentucky | 21087 | 2493 | 34 |
1884773 | 1884773 | 2021-11-04 | Green | Wisconsin | 55045 | 4757 | 34 |
1879393 | 1879393 | 2021-11-03 | Green | Kentucky | 21087 | 2484 | 34 |
1881524 | 1881524 | 2021-11-03 | Green | Wisconsin | 55045 | 4728 | 34 |
1876144 | 1876144 | 2021-11-02 | Green | Kentucky | 21087 | 2479 | 34 |
1872895 | 1872895 | 2021-11-01 | Green | Kentucky | 21087 | 2479 | 34 |
1869646 | 1869646 | 2021-10-31 | Green | Kentucky | 21087 | 2476 | 34 |
1866397 | 1866397 | 2021-10-30 | Green | Kentucky | 21087 | 2476 | 34 |
1863148 | 1863148 | 2021-10-29 | Green | Kentucky | 21087 | 2471 | 34 |
1859899 | 1859899 | 2021-10-28 | Green | Kentucky | 21087 | 2471 | 34 |
1856650 | 1856650 | 2021-10-27 | Green | Kentucky | 21087 | 2461 | 34 |
1853401 | 1853401 | 2021-10-26 | Green | Kentucky | 21087 | 2461 | 34 |
1850152 | 1850152 | 2021-10-25 | Green | Kentucky | 21087 | 2452 | 34 |
1846902 | 1846902 | 2021-10-24 | Green | Kentucky | 21087 | 2450 | 34 |
1843652 | 1843652 | 2021-10-23 | Green | Kentucky | 21087 | 2450 | 34 |
1840402 | 1840402 | 2021-10-22 | Green | Kentucky | 21087 | 2446 | 34 |
1837153 | 1837153 | 2021-10-21 | Green | Kentucky | 21087 | 2446 | 34 |
1833904 | 1833904 | 2021-10-20 | Green | Kentucky | 21087 | 2438 | 34 |
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);