ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Green" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- …
state 1
- Wisconsin · 685 ✖
fips 1
- 55045 685
county 1
- Green · 685 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177374 | 2177374 | 2022-02-02 | Green | Wisconsin | 55045 | 8510 | 48 |
2174121 | 2174121 | 2022-02-01 | Green | Wisconsin | 55045 | 8469 | 48 |
2170869 | 2170869 | 2022-01-31 | Green | Wisconsin | 55045 | 8455 | 48 |
2167616 | 2167616 | 2022-01-30 | Green | Wisconsin | 55045 | 8354 | 48 |
2164361 | 2164361 | 2022-01-29 | Green | Wisconsin | 55045 | 8354 | 48 |
2161106 | 2161106 | 2022-01-28 | Green | Wisconsin | 55045 | 8354 | 48 |
2157850 | 2157850 | 2022-01-27 | Green | Wisconsin | 55045 | 8309 | 48 |
2154597 | 2154597 | 2022-01-26 | Green | Wisconsin | 55045 | 8243 | 48 |
2151344 | 2151344 | 2022-01-25 | Green | Wisconsin | 55045 | 8177 | 48 |
2148092 | 2148092 | 2022-01-24 | Green | Wisconsin | 55045 | 8130 | 48 |
2144840 | 2144840 | 2022-01-23 | Green | Wisconsin | 55045 | 7951 | 48 |
2141585 | 2141585 | 2022-01-22 | Green | Wisconsin | 55045 | 7951 | 48 |
2138329 | 2138329 | 2022-01-21 | Green | Wisconsin | 55045 | 7951 | 48 |
2135074 | 2135074 | 2022-01-20 | Green | Wisconsin | 55045 | 7840 | 48 |
2131822 | 2131822 | 2022-01-19 | Green | Wisconsin | 55045 | 7699 | 48 |
2128568 | 2128568 | 2022-01-18 | Green | Wisconsin | 55045 | 7598 | 48 |
2125315 | 2125315 | 2022-01-17 | Green | Wisconsin | 55045 | 7526 | 47 |
2122063 | 2122063 | 2022-01-16 | Green | Wisconsin | 55045 | 7261 | 46 |
2118811 | 2118811 | 2022-01-15 | Green | Wisconsin | 55045 | 7261 | 46 |
2115559 | 2115559 | 2022-01-14 | Green | Wisconsin | 55045 | 7261 | 46 |
2112307 | 2112307 | 2022-01-13 | Green | Wisconsin | 55045 | 7108 | 46 |
2109055 | 2109055 | 2022-01-12 | Green | Wisconsin | 55045 | 6988 | 46 |
2105804 | 2105804 | 2022-01-11 | Green | Wisconsin | 55045 | 6917 | 46 |
2102553 | 2102553 | 2022-01-10 | Green | Wisconsin | 55045 | 6839 | 46 |
2099302 | 2099302 | 2022-01-09 | Green | Wisconsin | 55045 | 6607 | 45 |
2096051 | 2096051 | 2022-01-08 | Green | Wisconsin | 55045 | 6607 | 45 |
2092799 | 2092799 | 2022-01-07 | Green | Wisconsin | 55045 | 6607 | 45 |
2089547 | 2089547 | 2022-01-06 | Green | Wisconsin | 55045 | 6545 | 45 |
2086296 | 2086296 | 2022-01-05 | Green | Wisconsin | 55045 | 6497 | 45 |
2083044 | 2083044 | 2022-01-04 | Green | Wisconsin | 55045 | 6435 | 45 |
2079792 | 2079792 | 2022-01-03 | Green | Wisconsin | 55045 | 6404 | 45 |
2076540 | 2076540 | 2022-01-02 | Green | Wisconsin | 55045 | 6299 | 45 |
2073289 | 2073289 | 2022-01-01 | Green | Wisconsin | 55045 | 6299 | 45 |
2070038 | 2070038 | 2021-12-31 | Green | Wisconsin | 55045 | 6299 | 45 |
2066787 | 2066787 | 2021-12-30 | Green | Wisconsin | 55045 | 6250 | 44 |
2063537 | 2063537 | 2021-12-29 | Green | Wisconsin | 55045 | 6203 | 44 |
2060287 | 2060287 | 2021-12-28 | Green | Wisconsin | 55045 | 6181 | 44 |
2057038 | 2057038 | 2021-12-27 | Green | Wisconsin | 55045 | 6167 | 43 |
2053789 | 2053789 | 2021-12-26 | Green | Wisconsin | 55045 | 6107 | 42 |
2050539 | 2050539 | 2021-12-25 | Green | Wisconsin | 55045 | 6107 | 42 |
2047289 | 2047289 | 2021-12-24 | Green | Wisconsin | 55045 | 6107 | 42 |
2044039 | 2044039 | 2021-12-23 | Green | Wisconsin | 55045 | 6086 | 42 |
2040790 | 2040790 | 2021-12-22 | Green | Wisconsin | 55045 | 6061 | 40 |
2037540 | 2037540 | 2021-12-21 | Green | Wisconsin | 55045 | 6028 | 40 |
2034290 | 2034290 | 2021-12-20 | Green | Wisconsin | 55045 | 5995 | 40 |
2031040 | 2031040 | 2021-12-19 | Green | Wisconsin | 55045 | 5924 | 40 |
2027789 | 2027789 | 2021-12-18 | Green | Wisconsin | 55045 | 5924 | 40 |
2024538 | 2024538 | 2021-12-17 | Green | Wisconsin | 55045 | 5924 | 40 |
2021287 | 2021287 | 2021-12-16 | Green | Wisconsin | 55045 | 5893 | 40 |
2018036 | 2018036 | 2021-12-15 | Green | Wisconsin | 55045 | 5856 | 40 |
2014786 | 2014786 | 2021-12-14 | Green | Wisconsin | 55045 | 5837 | 39 |
2011535 | 2011535 | 2021-12-13 | Green | Wisconsin | 55045 | 5817 | 39 |
2008284 | 2008284 | 2021-12-12 | Green | Wisconsin | 55045 | 5739 | 38 |
2005033 | 2005033 | 2021-12-11 | Green | Wisconsin | 55045 | 5739 | 38 |
2001782 | 2001782 | 2021-12-10 | Green | Wisconsin | 55045 | 5739 | 38 |
1998532 | 1998532 | 2021-12-09 | Green | Wisconsin | 55045 | 5696 | 38 |
1995281 | 1995281 | 2021-12-08 | Green | Wisconsin | 55045 | 5652 | 38 |
1992030 | 1992030 | 2021-12-07 | Green | Wisconsin | 55045 | 5537 | 38 |
1988779 | 1988779 | 2021-12-06 | Green | Wisconsin | 55045 | 5537 | 38 |
1985529 | 1985529 | 2021-12-05 | Green | Wisconsin | 55045 | 5537 | 38 |
1982279 | 1982279 | 2021-12-04 | Green | Wisconsin | 55045 | 5537 | 38 |
1979029 | 1979029 | 2021-12-03 | Green | Wisconsin | 55045 | 5537 | 38 |
1975779 | 1975779 | 2021-12-02 | Green | Wisconsin | 55045 | 5500 | 38 |
1972530 | 1972530 | 2021-12-01 | Green | Wisconsin | 55045 | 5465 | 37 |
1969280 | 1969280 | 2021-11-30 | Green | Wisconsin | 55045 | 5426 | 37 |
1966030 | 1966030 | 2021-11-29 | Green | Wisconsin | 55045 | 5407 | 37 |
1962778 | 1962778 | 2021-11-28 | Green | Wisconsin | 55045 | 5349 | 36 |
1959527 | 1959527 | 2021-11-27 | Green | Wisconsin | 55045 | 5349 | 36 |
1956276 | 1956276 | 2021-11-26 | Green | Wisconsin | 55045 | 5349 | 36 |
1953025 | 1953025 | 2021-11-25 | Green | Wisconsin | 55045 | 5314 | 36 |
1949774 | 1949774 | 2021-11-24 | Green | Wisconsin | 55045 | 5286 | 37 |
1946523 | 1946523 | 2021-11-23 | Green | Wisconsin | 55045 | 5253 | 35 |
1943272 | 1943272 | 2021-11-22 | Green | Wisconsin | 55045 | 5235 | 35 |
1940022 | 1940022 | 2021-11-21 | Green | Wisconsin | 55045 | 5167 | 35 |
1936772 | 1936772 | 2021-11-20 | Green | Wisconsin | 55045 | 5167 | 35 |
1933522 | 1933522 | 2021-11-19 | Green | Wisconsin | 55045 | 5167 | 35 |
1930270 | 1930270 | 2021-11-18 | Green | Wisconsin | 55045 | 5146 | 35 |
1927020 | 1927020 | 2021-11-17 | Green | Wisconsin | 55045 | 5090 | 35 |
1923770 | 1923770 | 2021-11-16 | Green | Wisconsin | 55045 | 5067 | 35 |
1920521 | 1920521 | 2021-11-15 | Green | Wisconsin | 55045 | 5044 | 35 |
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 |
1901023 | 1901023 | 2021-11-09 | Green | Wisconsin | 55045 | 4875 | 34 |
1897773 | 1897773 | 2021-11-08 | Green | Wisconsin | 55045 | 4858 | 34 |
1894523 | 1894523 | 2021-11-07 | Green | Wisconsin | 55045 | 4785 | 34 |
1891273 | 1891273 | 2021-11-06 | Green | Wisconsin | 55045 | 4785 | 34 |
1888023 | 1888023 | 2021-11-05 | Green | Wisconsin | 55045 | 4785 | 34 |
1884773 | 1884773 | 2021-11-04 | Green | Wisconsin | 55045 | 4757 | 34 |
1881524 | 1881524 | 2021-11-03 | Green | Wisconsin | 55045 | 4728 | 34 |
1878275 | 1878275 | 2021-11-02 | Green | Wisconsin | 55045 | 4712 | 33 |
1875026 | 1875026 | 2021-11-01 | Green | Wisconsin | 55045 | 4705 | 33 |
1871777 | 1871777 | 2021-10-31 | Green | Wisconsin | 55045 | 4657 | 33 |
1868528 | 1868528 | 2021-10-30 | Green | Wisconsin | 55045 | 4657 | 33 |
1865279 | 1865279 | 2021-10-29 | Green | Wisconsin | 55045 | 4657 | 33 |
1862030 | 1862030 | 2021-10-28 | Green | Wisconsin | 55045 | 4628 | 33 |
1858781 | 1858781 | 2021-10-27 | Green | Wisconsin | 55045 | 4618 | 31 |
1855532 | 1855532 | 2021-10-26 | Green | Wisconsin | 55045 | 4610 | 31 |
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);