ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Waukesha" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112352 | 2112352 | 2022-01-13 | Waukesha | Wisconsin | 55133 | 83829 | 852 |
2109100 | 2109100 | 2022-01-12 | Waukesha | Wisconsin | 55133 | 83186 | 850 |
2105849 | 2105849 | 2022-01-11 | Waukesha | Wisconsin | 55133 | 82574 | 850 |
2102598 | 2102598 | 2022-01-10 | Waukesha | Wisconsin | 55133 | 82253 | 850 |
2099347 | 2099347 | 2022-01-09 | Waukesha | Wisconsin | 55133 | 79533 | 848 |
2096096 | 2096096 | 2022-01-08 | Waukesha | Wisconsin | 55133 | 79533 | 848 |
2092844 | 2092844 | 2022-01-07 | Waukesha | Wisconsin | 55133 | 79533 | 848 |
2089592 | 2089592 | 2022-01-06 | Waukesha | Wisconsin | 55133 | 78836 | 847 |
2086341 | 2086341 | 2022-01-05 | Waukesha | Wisconsin | 55133 | 78325 | 844 |
2083089 | 2083089 | 2022-01-04 | Waukesha | Wisconsin | 55133 | 77905 | 842 |
2079837 | 2079837 | 2022-01-03 | Waukesha | Wisconsin | 55133 | 77748 | 840 |
2076585 | 2076585 | 2022-01-02 | Waukesha | Wisconsin | 55133 | 77551 | 840 |
2073334 | 2073334 | 2022-01-01 | Waukesha | Wisconsin | 55133 | 77551 | 840 |
2070083 | 2070083 | 2021-12-31 | Waukesha | Wisconsin | 55133 | 77551 | 840 |
2066832 | 2066832 | 2021-12-30 | Waukesha | Wisconsin | 55133 | 77185 | 839 |
2063582 | 2063582 | 2021-12-29 | Waukesha | Wisconsin | 55133 | 76845 | 839 |
2060332 | 2060332 | 2021-12-28 | Waukesha | Wisconsin | 55133 | 76417 | 837 |
2057083 | 2057083 | 2021-12-27 | Waukesha | Wisconsin | 55133 | 76410 | 836 |
2053834 | 2053834 | 2021-12-26 | Waukesha | Wisconsin | 55133 | 76386 | 836 |
2050584 | 2050584 | 2021-12-25 | Waukesha | Wisconsin | 55133 | 76386 | 836 |
2047334 | 2047334 | 2021-12-24 | Waukesha | Wisconsin | 55133 | 76386 | 836 |
2044084 | 2044084 | 2021-12-23 | Waukesha | Wisconsin | 55133 | 76057 | 835 |
2040835 | 2040835 | 2021-12-22 | Waukesha | Wisconsin | 55133 | 75515 | 832 |
2037585 | 2037585 | 2021-12-21 | Waukesha | Wisconsin | 55133 | 75064 | 829 |
2034335 | 2034335 | 2021-12-20 | Waukesha | Wisconsin | 55133 | 74733 | 827 |
2031085 | 2031085 | 2021-12-19 | Waukesha | Wisconsin | 55133 | 74369 | 814 |
2027834 | 2027834 | 2021-12-18 | Waukesha | Wisconsin | 55133 | 74369 | 814 |
2024583 | 2024583 | 2021-12-17 | Waukesha | Wisconsin | 55133 | 74369 | 814 |
2021332 | 2021332 | 2021-12-16 | Waukesha | Wisconsin | 55133 | 74079 | 803 |
2018081 | 2018081 | 2021-12-15 | Waukesha | Wisconsin | 55133 | 73687 | 801 |
2014831 | 2014831 | 2021-12-14 | Waukesha | Wisconsin | 55133 | 73261 | 799 |
2011580 | 2011580 | 2021-12-13 | Waukesha | Wisconsin | 55133 | 72822 | 795 |
2008329 | 2008329 | 2021-12-12 | Waukesha | Wisconsin | 55133 | 72407 | 790 |
2005078 | 2005078 | 2021-12-11 | Waukesha | Wisconsin | 55133 | 72407 | 790 |
2001827 | 2001827 | 2021-12-10 | Waukesha | Wisconsin | 55133 | 72407 | 790 |
1998577 | 1998577 | 2021-12-09 | Waukesha | Wisconsin | 55133 | 72060 | 787 |
1995326 | 1995326 | 2021-12-08 | Waukesha | Wisconsin | 55133 | 71765 | 781 |
1992075 | 1992075 | 2021-12-07 | Waukesha | Wisconsin | 55133 | 70836 | 772 |
1988824 | 1988824 | 2021-12-06 | Waukesha | Wisconsin | 55133 | 70836 | 772 |
1985574 | 1985574 | 2021-12-05 | Waukesha | Wisconsin | 55133 | 70836 | 772 |
1982324 | 1982324 | 2021-12-04 | Waukesha | Wisconsin | 55133 | 70836 | 772 |
1979074 | 1979074 | 2021-12-03 | Waukesha | Wisconsin | 55133 | 70836 | 772 |
1975824 | 1975824 | 2021-12-02 | Waukesha | Wisconsin | 55133 | 70503 | 769 |
1972575 | 1972575 | 2021-12-01 | Waukesha | Wisconsin | 55133 | 70119 | 767 |
1969325 | 1969325 | 2021-11-30 | Waukesha | Wisconsin | 55133 | 69587 | 766 |
1966075 | 1966075 | 2021-11-29 | Waukesha | Wisconsin | 55133 | 69038 | 759 |
1962823 | 1962823 | 2021-11-28 | Waukesha | Wisconsin | 55133 | 69028 | 759 |
1959572 | 1959572 | 2021-11-27 | Waukesha | Wisconsin | 55133 | 69028 | 759 |
1956321 | 1956321 | 2021-11-26 | Waukesha | Wisconsin | 55133 | 69028 | 759 |
1953070 | 1953070 | 2021-11-25 | Waukesha | Wisconsin | 55133 | 69028 | 759 |
1949819 | 1949819 | 2021-11-24 | Waukesha | Wisconsin | 55133 | 68707 | 759 |
1946568 | 1946568 | 2021-11-23 | Waukesha | Wisconsin | 55133 | 68355 | 754 |
1943317 | 1943317 | 2021-11-22 | Waukesha | Wisconsin | 55133 | 67861 | 753 |
1940067 | 1940067 | 2021-11-21 | Waukesha | Wisconsin | 55133 | 67548 | 752 |
1936817 | 1936817 | 2021-11-20 | Waukesha | Wisconsin | 55133 | 67548 | 752 |
1933567 | 1933567 | 2021-11-19 | Waukesha | Wisconsin | 55133 | 67548 | 752 |
1930315 | 1930315 | 2021-11-18 | Waukesha | Wisconsin | 55133 | 67197 | 748 |
1927065 | 1927065 | 2021-11-17 | Waukesha | Wisconsin | 55133 | 66898 | 747 |
1923815 | 1923815 | 2021-11-16 | Waukesha | Wisconsin | 55133 | 66614 | 746 |
1920566 | 1920566 | 2021-11-15 | Waukesha | Wisconsin | 55133 | 66102 | 744 |
1917316 | 1917316 | 2021-11-14 | Waukesha | Wisconsin | 55133 | 65749 | 742 |
1914066 | 1914066 | 2021-11-13 | Waukesha | Wisconsin | 55133 | 65749 | 742 |
1910816 | 1910816 | 2021-11-12 | Waukesha | Wisconsin | 55133 | 65749 | 742 |
1907567 | 1907567 | 2021-11-11 | Waukesha | Wisconsin | 55133 | 65366 | 742 |
1904318 | 1904318 | 2021-11-10 | Waukesha | Wisconsin | 55133 | 65085 | 742 |
1901068 | 1901068 | 2021-11-09 | Waukesha | Wisconsin | 55133 | 64705 | 740 |
1897818 | 1897818 | 2021-11-08 | Waukesha | Wisconsin | 55133 | 64409 | 740 |
1894568 | 1894568 | 2021-11-07 | Waukesha | Wisconsin | 55133 | 64265 | 737 |
1891318 | 1891318 | 2021-11-06 | Waukesha | Wisconsin | 55133 | 64265 | 737 |
1888068 | 1888068 | 2021-11-05 | Waukesha | Wisconsin | 55133 | 64265 | 737 |
1884818 | 1884818 | 2021-11-04 | Waukesha | Wisconsin | 55133 | 64075 | 737 |
1881569 | 1881569 | 2021-11-03 | Waukesha | Wisconsin | 55133 | 63830 | 737 |
1878320 | 1878320 | 2021-11-02 | Waukesha | Wisconsin | 55133 | 63620 | 737 |
1875071 | 1875071 | 2021-11-01 | Waukesha | Wisconsin | 55133 | 63279 | 734 |
1871822 | 1871822 | 2021-10-31 | Waukesha | Wisconsin | 55133 | 63079 | 731 |
1868573 | 1868573 | 2021-10-30 | Waukesha | Wisconsin | 55133 | 63079 | 731 |
1865324 | 1865324 | 2021-10-29 | Waukesha | Wisconsin | 55133 | 63079 | 731 |
1862075 | 1862075 | 2021-10-28 | Waukesha | Wisconsin | 55133 | 62908 | 728 |
1858826 | 1858826 | 2021-10-27 | Waukesha | Wisconsin | 55133 | 62753 | 724 |
1855577 | 1855577 | 2021-10-26 | Waukesha | Wisconsin | 55133 | 62582 | 720 |
1852328 | 1852328 | 2021-10-25 | Waukesha | Wisconsin | 55133 | 62262 | 719 |
1849078 | 1849078 | 2021-10-24 | Waukesha | Wisconsin | 55133 | 62105 | 718 |
1845828 | 1845828 | 2021-10-23 | Waukesha | Wisconsin | 55133 | 62105 | 718 |
1842578 | 1842578 | 2021-10-22 | Waukesha | Wisconsin | 55133 | 62105 | 718 |
1839329 | 1839329 | 2021-10-21 | Waukesha | Wisconsin | 55133 | 61985 | 716 |
1836080 | 1836080 | 2021-10-20 | Waukesha | Wisconsin | 55133 | 61868 | 715 |
1832831 | 1832831 | 2021-10-19 | Waukesha | Wisconsin | 55133 | 61728 | 712 |
1829582 | 1829582 | 2021-10-18 | Waukesha | Wisconsin | 55133 | 61499 | 710 |
1826333 | 1826333 | 2021-10-17 | Waukesha | Wisconsin | 55133 | 61445 | 710 |
1823084 | 1823084 | 2021-10-16 | Waukesha | Wisconsin | 55133 | 61140 | 708 |
1819835 | 1819835 | 2021-10-15 | Waukesha | Wisconsin | 55133 | 61140 | 708 |
1816586 | 1816586 | 2021-10-14 | Waukesha | Wisconsin | 55133 | 61140 | 708 |
1813338 | 1813338 | 2021-10-13 | Waukesha | Wisconsin | 55133 | 60947 | 706 |
1810089 | 1810089 | 2021-10-12 | Waukesha | Wisconsin | 55133 | 60789 | 704 |
1806840 | 1806840 | 2021-10-11 | Waukesha | Wisconsin | 55133 | 60447 | 703 |
1803589 | 1803589 | 2021-10-10 | Waukesha | Wisconsin | 55133 | 60225 | 702 |
1800340 | 1800340 | 2021-10-09 | Waukesha | Wisconsin | 55133 | 60225 | 702 |
1797091 | 1797091 | 2021-10-08 | Waukesha | Wisconsin | 55133 | 60225 | 702 |
1793842 | 1793842 | 2021-10-07 | Waukesha | Wisconsin | 55133 | 60014 | 699 |
1790593 | 1790593 | 2021-10-06 | Waukesha | Wisconsin | 55133 | 59839 | 695 |
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);