ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 31079 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175905 | 2175905 | 2022-02-02 | Hall | Nebraska | 31079 | 15270 | 120 |
2172652 | 2172652 | 2022-02-01 | Hall | Nebraska | 31079 | 15143 | 120 |
2169399 | 2169399 | 2022-01-31 | Hall | Nebraska | 31079 | 15143 | 120 |
2166144 | 2166144 | 2022-01-30 | Hall | Nebraska | 31079 | 15048 | 120 |
2162889 | 2162889 | 2022-01-29 | Hall | Nebraska | 31079 | 15048 | 120 |
2159634 | 2159634 | 2022-01-28 | Hall | Nebraska | 31079 | 15048 | 120 |
2156380 | 2156380 | 2022-01-27 | Hall | Nebraska | 31079 | 14917 | 120 |
2153127 | 2153127 | 2022-01-26 | Hall | Nebraska | 31079 | 14815 | 120 |
2149875 | 2149875 | 2022-01-25 | Hall | Nebraska | 31079 | 14701 | 120 |
2146623 | 2146623 | 2022-01-24 | Hall | Nebraska | 31079 | 14496 | 120 |
2143368 | 2143368 | 2022-01-23 | Hall | Nebraska | 31079 | 14172 | 120 |
2140113 | 2140113 | 2022-01-22 | Hall | Nebraska | 31079 | 14172 | 120 |
2136857 | 2136857 | 2022-01-21 | Hall | Nebraska | 31079 | 14172 | 120 |
2133605 | 2133605 | 2022-01-20 | Hall | Nebraska | 31079 | 14048 | 120 |
2130352 | 2130352 | 2022-01-19 | Hall | Nebraska | 31079 | 13822 | 120 |
2127098 | 2127098 | 2022-01-18 | Hall | Nebraska | 31079 | 13481 | 120 |
2123846 | 2123846 | 2022-01-17 | Hall | Nebraska | 31079 | 13277 | 120 |
2120594 | 2120594 | 2022-01-16 | Hall | Nebraska | 31079 | 13019 | 120 |
2117342 | 2117342 | 2022-01-15 | Hall | Nebraska | 31079 | 13019 | 120 |
2114091 | 2114091 | 2022-01-14 | Hall | Nebraska | 31079 | 13019 | 120 |
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 |
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);