ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Brown" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112289 | 2112289 | 2022-01-13 | Brown | Wisconsin | 55009 | 66801 | 387 |
2109037 | 2109037 | 2022-01-12 | Brown | Wisconsin | 55009 | 65869 | 384 |
2105786 | 2105786 | 2022-01-11 | Brown | Wisconsin | 55009 | 65295 | 384 |
2102535 | 2102535 | 2022-01-10 | Brown | Wisconsin | 55009 | 64481 | 383 |
2099284 | 2099284 | 2022-01-09 | Brown | Wisconsin | 55009 | 63379 | 383 |
2096033 | 2096033 | 2022-01-08 | Brown | Wisconsin | 55009 | 63379 | 383 |
2092781 | 2092781 | 2022-01-07 | Brown | Wisconsin | 55009 | 63379 | 383 |
2089529 | 2089529 | 2022-01-06 | Brown | Wisconsin | 55009 | 62395 | 382 |
2086278 | 2086278 | 2022-01-05 | Brown | Wisconsin | 55009 | 61430 | 381 |
2083026 | 2083026 | 2022-01-04 | Brown | Wisconsin | 55009 | 60593 | 379 |
2079774 | 2079774 | 2022-01-03 | Brown | Wisconsin | 55009 | 59993 | 374 |
2076522 | 2076522 | 2022-01-02 | Brown | Wisconsin | 55009 | 59541 | 374 |
2073271 | 2073271 | 2022-01-01 | Brown | Wisconsin | 55009 | 59541 | 374 |
2070020 | 2070020 | 2021-12-31 | Brown | Wisconsin | 55009 | 59541 | 374 |
2066769 | 2066769 | 2021-12-30 | Brown | Wisconsin | 55009 | 59429 | 374 |
2063519 | 2063519 | 2021-12-29 | Brown | Wisconsin | 55009 | 58864 | 374 |
2060269 | 2060269 | 2021-12-28 | Brown | Wisconsin | 55009 | 58441 | 374 |
2057020 | 2057020 | 2021-12-27 | Brown | Wisconsin | 55009 | 57855 | 373 |
2053771 | 2053771 | 2021-12-26 | Brown | Wisconsin | 55009 | 57501 | 373 |
2050521 | 2050521 | 2021-12-25 | Brown | Wisconsin | 55009 | 57501 | 373 |
2047271 | 2047271 | 2021-12-24 | Brown | Wisconsin | 55009 | 57501 | 373 |
2044021 | 2044021 | 2021-12-23 | Brown | Wisconsin | 55009 | 57419 | 371 |
2040772 | 2040772 | 2021-12-22 | Brown | Wisconsin | 55009 | 57093 | 370 |
2037522 | 2037522 | 2021-12-21 | Brown | Wisconsin | 55009 | 56683 | 370 |
2034272 | 2034272 | 2021-12-20 | Brown | Wisconsin | 55009 | 56426 | 365 |
2031022 | 2031022 | 2021-12-19 | Brown | Wisconsin | 55009 | 56168 | 358 |
2027771 | 2027771 | 2021-12-18 | Brown | Wisconsin | 55009 | 56168 | 358 |
2024520 | 2024520 | 2021-12-17 | Brown | Wisconsin | 55009 | 56168 | 358 |
2021269 | 2021269 | 2021-12-16 | Brown | Wisconsin | 55009 | 55870 | 357 |
2018018 | 2018018 | 2021-12-15 | Brown | Wisconsin | 55009 | 55531 | 354 |
2014768 | 2014768 | 2021-12-14 | Brown | Wisconsin | 55009 | 55249 | 346 |
2011517 | 2011517 | 2021-12-13 | Brown | Wisconsin | 55009 | 54871 | 346 |
2008266 | 2008266 | 2021-12-12 | Brown | Wisconsin | 55009 | 54320 | 346 |
2005015 | 2005015 | 2021-12-11 | Brown | Wisconsin | 55009 | 54320 | 346 |
2001764 | 2001764 | 2021-12-10 | Brown | Wisconsin | 55009 | 54320 | 346 |
1998514 | 1998514 | 2021-12-09 | Brown | Wisconsin | 55009 | 53832 | 344 |
1995263 | 1995263 | 2021-12-08 | Brown | Wisconsin | 55009 | 53668 | 340 |
1992012 | 1992012 | 2021-12-07 | Brown | Wisconsin | 55009 | 52922 | 335 |
1988761 | 1988761 | 2021-12-06 | Brown | Wisconsin | 55009 | 52922 | 335 |
1985511 | 1985511 | 2021-12-05 | Brown | Wisconsin | 55009 | 52922 | 335 |
1982261 | 1982261 | 2021-12-04 | Brown | Wisconsin | 55009 | 52922 | 335 |
1979011 | 1979011 | 2021-12-03 | Brown | Wisconsin | 55009 | 52922 | 335 |
1975761 | 1975761 | 2021-12-02 | Brown | Wisconsin | 55009 | 52545 | 335 |
1972512 | 1972512 | 2021-12-01 | Brown | Wisconsin | 55009 | 52178 | 335 |
1969262 | 1969262 | 2021-11-30 | Brown | Wisconsin | 55009 | 51869 | 335 |
1966012 | 1966012 | 2021-11-29 | Brown | Wisconsin | 55009 | 51394 | 335 |
1962760 | 1962760 | 2021-11-28 | Brown | Wisconsin | 55009 | 51180 | 335 |
1959509 | 1959509 | 2021-11-27 | Brown | Wisconsin | 55009 | 51180 | 335 |
1956258 | 1956258 | 2021-11-26 | Brown | Wisconsin | 55009 | 51180 | 335 |
1953007 | 1953007 | 2021-11-25 | Brown | Wisconsin | 55009 | 51180 | 335 |
1949756 | 1949756 | 2021-11-24 | Brown | Wisconsin | 55009 | 50864 | 335 |
1946505 | 1946505 | 2021-11-23 | Brown | Wisconsin | 55009 | 50476 | 333 |
1943254 | 1943254 | 2021-11-22 | Brown | Wisconsin | 55009 | 50079 | 333 |
1940004 | 1940004 | 2021-11-21 | Brown | Wisconsin | 55009 | 49786 | 333 |
1936754 | 1936754 | 2021-11-20 | Brown | Wisconsin | 55009 | 49786 | 333 |
1933504 | 1933504 | 2021-11-19 | Brown | Wisconsin | 55009 | 49786 | 333 |
1930252 | 1930252 | 2021-11-18 | Brown | Wisconsin | 55009 | 49482 | 333 |
1927002 | 1927002 | 2021-11-17 | Brown | Wisconsin | 55009 | 49305 | 332 |
1923752 | 1923752 | 2021-11-16 | Brown | Wisconsin | 55009 | 49036 | 332 |
1920503 | 1920503 | 2021-11-15 | Brown | Wisconsin | 55009 | 48684 | 330 |
1917253 | 1917253 | 2021-11-14 | Brown | Wisconsin | 55009 | 48443 | 330 |
1914003 | 1914003 | 2021-11-13 | Brown | Wisconsin | 55009 | 48443 | 330 |
1910753 | 1910753 | 2021-11-12 | Brown | Wisconsin | 55009 | 48443 | 330 |
1907504 | 1907504 | 2021-11-11 | Brown | Wisconsin | 55009 | 48223 | 330 |
1904255 | 1904255 | 2021-11-10 | Brown | Wisconsin | 55009 | 48068 | 330 |
1901005 | 1901005 | 2021-11-09 | Brown | Wisconsin | 55009 | 47727 | 326 |
1897755 | 1897755 | 2021-11-08 | Brown | Wisconsin | 55009 | 47508 | 326 |
1894505 | 1894505 | 2021-11-07 | Brown | Wisconsin | 55009 | 47332 | 326 |
1891255 | 1891255 | 2021-11-06 | Brown | Wisconsin | 55009 | 47332 | 326 |
1888005 | 1888005 | 2021-11-05 | Brown | Wisconsin | 55009 | 47332 | 326 |
1884755 | 1884755 | 2021-11-04 | Brown | Wisconsin | 55009 | 47124 | 325 |
1881506 | 1881506 | 2021-11-03 | Brown | Wisconsin | 55009 | 46943 | 325 |
1878257 | 1878257 | 2021-11-02 | Brown | Wisconsin | 55009 | 46763 | 324 |
1875008 | 1875008 | 2021-11-01 | Brown | Wisconsin | 55009 | 46447 | 322 |
1871759 | 1871759 | 2021-10-31 | Brown | Wisconsin | 55009 | 46315 | 322 |
1868510 | 1868510 | 2021-10-30 | Brown | Wisconsin | 55009 | 46315 | 322 |
1865261 | 1865261 | 2021-10-29 | Brown | Wisconsin | 55009 | 46315 | 322 |
1862012 | 1862012 | 2021-10-28 | Brown | Wisconsin | 55009 | 46166 | 322 |
1858763 | 1858763 | 2021-10-27 | Brown | Wisconsin | 55009 | 46068 | 321 |
1855514 | 1855514 | 2021-10-26 | Brown | Wisconsin | 55009 | 45920 | 320 |
1852265 | 1852265 | 2021-10-25 | Brown | Wisconsin | 55009 | 45661 | 320 |
1849015 | 1849015 | 2021-10-24 | Brown | Wisconsin | 55009 | 45497 | 318 |
1845765 | 1845765 | 2021-10-23 | Brown | Wisconsin | 55009 | 45497 | 318 |
1842515 | 1842515 | 2021-10-22 | Brown | Wisconsin | 55009 | 45497 | 318 |
1839266 | 1839266 | 2021-10-21 | Brown | Wisconsin | 55009 | 45333 | 316 |
1836017 | 1836017 | 2021-10-20 | Brown | Wisconsin | 55009 | 45172 | 316 |
1832768 | 1832768 | 2021-10-19 | Brown | Wisconsin | 55009 | 44827 | 315 |
1829519 | 1829519 | 2021-10-18 | Brown | Wisconsin | 55009 | 44712 | 315 |
1826270 | 1826270 | 2021-10-17 | Brown | Wisconsin | 55009 | 44648 | 315 |
1823021 | 1823021 | 2021-10-16 | Brown | Wisconsin | 55009 | 44307 | 315 |
1819772 | 1819772 | 2021-10-15 | Brown | Wisconsin | 55009 | 44307 | 315 |
1816523 | 1816523 | 2021-10-14 | Brown | Wisconsin | 55009 | 44307 | 315 |
1813275 | 1813275 | 2021-10-13 | Brown | Wisconsin | 55009 | 44073 | 315 |
1810026 | 1810026 | 2021-10-12 | Brown | Wisconsin | 55009 | 43753 | 315 |
1806777 | 1806777 | 2021-10-11 | Brown | Wisconsin | 55009 | 43520 | 315 |
1803526 | 1803526 | 2021-10-10 | Brown | Wisconsin | 55009 | 43273 | 315 |
1800277 | 1800277 | 2021-10-09 | Brown | Wisconsin | 55009 | 43273 | 315 |
1797028 | 1797028 | 2021-10-08 | Brown | Wisconsin | 55009 | 43273 | 315 |
1793779 | 1793779 | 2021-10-07 | Brown | Wisconsin | 55009 | 42998 | 315 |
1790530 | 1790530 | 2021-10-06 | Brown | Wisconsin | 55009 | 42801 | 315 |
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);