ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Hall" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110839 | 2110839 | 2022-01-13 | Hall | Nebraska | 31079 | 12358 | 120 |
2107588 | 2107588 | 2022-01-12 | Hall | Nebraska | 31079 | 12213 | 120 |
2104337 | 2104337 | 2022-01-11 | Hall | Nebraska | 31079 | 12087 | 120 |
2101086 | 2101086 | 2022-01-10 | Hall | Nebraska | 31079 | 11984 | 120 |
2097835 | 2097835 | 2022-01-09 | Hall | Nebraska | 31079 | 11837 | 120 |
2094583 | 2094583 | 2022-01-08 | Hall | Nebraska | 31079 | 11837 | 120 |
2091331 | 2091331 | 2022-01-07 | Hall | Nebraska | 31079 | 11837 | 120 |
2088080 | 2088080 | 2022-01-06 | Hall | Nebraska | 31079 | 11777 | 120 |
2084828 | 2084828 | 2022-01-05 | Hall | Nebraska | 31079 | 11711 | 120 |
2081576 | 2081576 | 2022-01-04 | Hall | Nebraska | 31079 | 11610 | 120 |
2078324 | 2078324 | 2022-01-03 | Hall | Nebraska | 31079 | 11538 | 120 |
2075073 | 2075073 | 2022-01-02 | Hall | Nebraska | 31079 | 11453 | 120 |
2071822 | 2071822 | 2022-01-01 | Hall | Nebraska | 31079 | 11453 | 120 |
2068571 | 2068571 | 2021-12-31 | Hall | Nebraska | 31079 | 11453 | 120 |
2065320 | 2065320 | 2021-12-30 | Hall | Nebraska | 31079 | 11453 | 120 |
2062070 | 2062070 | 2021-12-29 | Hall | Nebraska | 31079 | 11387 | 120 |
2058821 | 2058821 | 2021-12-28 | Hall | Nebraska | 31079 | 11350 | 120 |
2055572 | 2055572 | 2021-12-27 | Hall | Nebraska | 31079 | 11295 | 120 |
2052322 | 2052322 | 2021-12-26 | Hall | Nebraska | 31079 | 11295 | 120 |
2049072 | 2049072 | 2021-12-25 | Hall | Nebraska | 31079 | 11295 | 120 |
2045822 | 2045822 | 2021-12-24 | Hall | Nebraska | 31079 | 11295 | 120 |
2042572 | 2042572 | 2021-12-23 | Hall | Nebraska | 31079 | 11295 | 120 |
2039323 | 2039323 | 2021-12-22 | Hall | Nebraska | 31079 | 11281 | 120 |
2036073 | 2036073 | 2021-12-21 | Hall | Nebraska | 31079 | 11252 | 120 |
2032823 | 2032823 | 2021-12-20 | Hall | Nebraska | 31079 | 11207 | 120 |
2029572 | 2029572 | 2021-12-19 | Hall | Nebraska | 31079 | 11189 | 120 |
2026321 | 2026321 | 2021-12-18 | Hall | Nebraska | 31079 | 11189 | 120 |
2023070 | 2023070 | 2021-12-17 | Hall | Nebraska | 31079 | 11189 | 120 |
2019819 | 2019819 | 2021-12-16 | Hall | Nebraska | 31079 | 11167 | 120 |
2016569 | 2016569 | 2021-12-15 | Hall | Nebraska | 31079 | 11137 | 120 |
2013318 | 2013318 | 2021-12-14 | Hall | Nebraska | 31079 | 11102 | 120 |
2010067 | 2010067 | 2021-12-13 | Hall | Nebraska | 31079 | 11074 | 120 |
2006816 | 2006816 | 2021-12-12 | Hall | Nebraska | 31079 | 11036 | 120 |
2003565 | 2003565 | 2021-12-11 | Hall | Nebraska | 31079 | 11036 | 120 |
2000315 | 2000315 | 2021-12-10 | Hall | Nebraska | 31079 | 11036 | 120 |
1997064 | 1997064 | 2021-12-09 | Hall | Nebraska | 31079 | 11010 | 120 |
1993813 | 1993813 | 2021-12-08 | Hall | Nebraska | 31079 | 10982 | 120 |
1990562 | 1990562 | 2021-12-07 | Hall | Nebraska | 31079 | 10942 | 120 |
1987312 | 1987312 | 2021-12-06 | Hall | Nebraska | 31079 | 10904 | 120 |
1984062 | 1984062 | 2021-12-05 | Hall | Nebraska | 31079 | 10848 | 120 |
1980812 | 1980812 | 2021-12-04 | Hall | Nebraska | 31079 | 10848 | 120 |
1977562 | 1977562 | 2021-12-03 | Hall | Nebraska | 31079 | 10848 | 120 |
1974312 | 1974312 | 2021-12-02 | Hall | Nebraska | 31079 | 10772 | 120 |
1971063 | 1971063 | 2021-12-01 | Hall | Nebraska | 31079 | 10740 | 120 |
1967813 | 1967813 | 2021-11-30 | Hall | Nebraska | 31079 | 10685 | 120 |
1964561 | 1964561 | 2021-11-29 | Hall | Nebraska | 31079 | 10664 | 120 |
1961310 | 1961310 | 2021-11-28 | Hall | Nebraska | 31079 | 10574 | 120 |
1958059 | 1958059 | 2021-11-27 | Hall | Nebraska | 31079 | 10574 | 120 |
1954808 | 1954808 | 2021-11-26 | Hall | Nebraska | 31079 | 10574 | 120 |
1951557 | 1951557 | 2021-11-25 | Hall | Nebraska | 31079 | 10574 | 120 |
1948306 | 1948306 | 2021-11-24 | Hall | Nebraska | 31079 | 10574 | 120 |
1945055 | 1945055 | 2021-11-23 | Hall | Nebraska | 31079 | 10542 | 120 |
1941804 | 1941804 | 2021-11-22 | Hall | Nebraska | 31079 | 10503 | 120 |
1938554 | 1938554 | 2021-11-21 | Hall | Nebraska | 31079 | 10470 | 120 |
1935304 | 1935304 | 2021-11-20 | Hall | Nebraska | 31079 | 10470 | 120 |
1932054 | 1932054 | 2021-11-19 | Hall | Nebraska | 31079 | 10470 | 120 |
1928803 | 1928803 | 2021-11-18 | Hall | Nebraska | 31079 | 10443 | 120 |
1925553 | 1925553 | 2021-11-17 | Hall | Nebraska | 31079 | 10408 | 120 |
1922304 | 1922304 | 2021-11-16 | Hall | Nebraska | 31079 | 10371 | 120 |
1919054 | 1919054 | 2021-11-15 | Hall | Nebraska | 31079 | 10346 | 120 |
1915804 | 1915804 | 2021-11-14 | Hall | Nebraska | 31079 | 10300 | 120 |
1912554 | 1912554 | 2021-11-13 | Hall | Nebraska | 31079 | 10300 | 120 |
1909304 | 1909304 | 2021-11-12 | Hall | Nebraska | 31079 | 10300 | 120 |
1906055 | 1906055 | 2021-11-11 | Hall | Nebraska | 31079 | 10273 | 120 |
1902806 | 1902806 | 2021-11-10 | Hall | Nebraska | 31079 | 10240 | 120 |
1899556 | 1899556 | 2021-11-09 | Hall | Nebraska | 31079 | 10214 | 120 |
1896306 | 1896306 | 2021-11-08 | Hall | Nebraska | 31079 | 10190 | 120 |
1893056 | 1893056 | 2021-11-07 | Hall | Nebraska | 31079 | 10097 | 120 |
1889806 | 1889806 | 2021-11-06 | Hall | Nebraska | 31079 | 10097 | 120 |
1886556 | 1886556 | 2021-11-05 | Hall | Nebraska | 31079 | 10097 | 120 |
1883307 | 1883307 | 2021-11-04 | Hall | Nebraska | 31079 | 10097 | 120 |
1880058 | 1880058 | 2021-11-03 | Hall | Nebraska | 31079 | 10097 | 120 |
1876809 | 1876809 | 2021-11-02 | Hall | Nebraska | 31079 | 10027 | 120 |
1873560 | 1873560 | 2021-11-01 | Hall | Nebraska | 31079 | 10027 | 120 |
1870311 | 1870311 | 2021-10-31 | Hall | Nebraska | 31079 | 9959 | 120 |
1867062 | 1867062 | 2021-10-30 | Hall | Nebraska | 31079 | 9949 | 120 |
1863813 | 1863813 | 2021-10-29 | Hall | Nebraska | 31079 | 9949 | 120 |
1860564 | 1860564 | 2021-10-28 | Hall | Nebraska | 31079 | 9933 | 120 |
1857315 | 1857315 | 2021-10-27 | Hall | Nebraska | 31079 | 9933 | 120 |
1854066 | 1854066 | 2021-10-26 | Hall | Nebraska | 31079 | 9810 | 120 |
1850817 | 1850817 | 2021-10-25 | Hall | Nebraska | 31079 | 9810 | 120 |
1847567 | 1847567 | 2021-10-24 | Hall | Nebraska | 31079 | 9810 | 120 |
1844317 | 1844317 | 2021-10-23 | Hall | Nebraska | 31079 | 9810 | 120 |
1841067 | 1841067 | 2021-10-22 | Hall | Nebraska | 31079 | 9810 | 120 |
1837818 | 1837818 | 2021-10-21 | Hall | Nebraska | 31079 | 9810 | 120 |
1834569 | 1834569 | 2021-10-20 | Hall | Nebraska | 31079 | 9782 | 120 |
1831320 | 1831320 | 2021-10-19 | Hall | Nebraska | 31079 | 9746 | 120 |
1828071 | 1828071 | 2021-10-18 | Hall | Nebraska | 31079 | 9727 | 120 |
1824822 | 1824822 | 2021-10-17 | Hall | Nebraska | 31079 | 9696 | 120 |
1821573 | 1821573 | 2021-10-16 | Hall | Nebraska | 31079 | 9696 | 120 |
1818324 | 1818324 | 2021-10-15 | Hall | Nebraska | 31079 | 9696 | 120 |
1815075 | 1815075 | 2021-10-14 | Hall | Nebraska | 31079 | 9666 | 120 |
1811827 | 1811827 | 2021-10-13 | Hall | Nebraska | 31079 | 9641 | 120 |
1808578 | 1808578 | 2021-10-12 | Hall | Nebraska | 31079 | 9627 | 120 |
1805327 | 1805327 | 2021-10-11 | Hall | Nebraska | 31079 | 9554 | 120 |
1802078 | 1802078 | 2021-10-10 | Hall | Nebraska | 31079 | 9554 | 120 |
1798829 | 1798829 | 2021-10-09 | Hall | Nebraska | 31079 | 9554 | 120 |
1795580 | 1795580 | 2021-10-08 | Hall | Nebraska | 31079 | 9554 | 120 |
1792331 | 1792331 | 2021-10-07 | Hall | Nebraska | 31079 | 9530 | 120 |
1789082 | 1789082 | 2021-10-06 | Hall | Nebraska | 31079 | 9491 | 120 |
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);