ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 31119 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175924 | 2175924 | 2022-02-02 | Madison | Nebraska | 31119 | 9087 | 58 |
2172671 | 2172671 | 2022-02-01 | Madison | Nebraska | 31119 | 9014 | 58 |
2169418 | 2169418 | 2022-01-31 | Madison | Nebraska | 31119 | 9014 | 58 |
2166163 | 2166163 | 2022-01-30 | Madison | Nebraska | 31119 | 8952 | 58 |
2162908 | 2162908 | 2022-01-29 | Madison | Nebraska | 31119 | 8952 | 58 |
2159653 | 2159653 | 2022-01-28 | Madison | Nebraska | 31119 | 8952 | 58 |
2156399 | 2156399 | 2022-01-27 | Madison | Nebraska | 31119 | 8876 | 58 |
2153146 | 2153146 | 2022-01-26 | Madison | Nebraska | 31119 | 8807 | 58 |
2149894 | 2149894 | 2022-01-25 | Madison | Nebraska | 31119 | 8678 | 58 |
2146642 | 2146642 | 2022-01-24 | Madison | Nebraska | 31119 | 8627 | 58 |
2143387 | 2143387 | 2022-01-23 | Madison | Nebraska | 31119 | 8419 | 58 |
2140132 | 2140132 | 2022-01-22 | Madison | Nebraska | 31119 | 8419 | 58 |
2136876 | 2136876 | 2022-01-21 | Madison | Nebraska | 31119 | 8419 | 58 |
2133624 | 2133624 | 2022-01-20 | Madison | Nebraska | 31119 | 8314 | 58 |
2130371 | 2130371 | 2022-01-19 | Madison | Nebraska | 31119 | 8206 | 58 |
2127117 | 2127117 | 2022-01-18 | Madison | Nebraska | 31119 | 8094 | 55 |
2123865 | 2123865 | 2022-01-17 | Madison | Nebraska | 31119 | 8004 | 55 |
2120613 | 2120613 | 2022-01-16 | Madison | Nebraska | 31119 | 7807 | 55 |
2117361 | 2117361 | 2022-01-15 | Madison | Nebraska | 31119 | 7807 | 55 |
2114110 | 2114110 | 2022-01-14 | Madison | Nebraska | 31119 | 7807 | 55 |
2110858 | 2110858 | 2022-01-13 | Madison | Nebraska | 31119 | 7694 | 55 |
2107607 | 2107607 | 2022-01-12 | Madison | Nebraska | 31119 | 7599 | 55 |
2104356 | 2104356 | 2022-01-11 | Madison | Nebraska | 31119 | 7521 | 55 |
2101105 | 2101105 | 2022-01-10 | Madison | Nebraska | 31119 | 7421 | 55 |
2097854 | 2097854 | 2022-01-09 | Madison | Nebraska | 31119 | 7326 | 55 |
2094602 | 2094602 | 2022-01-08 | Madison | Nebraska | 31119 | 7326 | 55 |
2091350 | 2091350 | 2022-01-07 | Madison | Nebraska | 31119 | 7326 | 55 |
2088099 | 2088099 | 2022-01-06 | Madison | Nebraska | 31119 | 7284 | 55 |
2084847 | 2084847 | 2022-01-05 | Madison | Nebraska | 31119 | 7215 | 53 |
2081595 | 2081595 | 2022-01-04 | Madison | Nebraska | 31119 | 7179 | 53 |
2078343 | 2078343 | 2022-01-03 | Madison | Nebraska | 31119 | 7141 | 53 |
2075092 | 2075092 | 2022-01-02 | Madison | Nebraska | 31119 | 7068 | 53 |
2071841 | 2071841 | 2022-01-01 | Madison | Nebraska | 31119 | 7068 | 53 |
2068590 | 2068590 | 2021-12-31 | Madison | Nebraska | 31119 | 7068 | 53 |
2065339 | 2065339 | 2021-12-30 | Madison | Nebraska | 31119 | 7068 | 53 |
2062089 | 2062089 | 2021-12-29 | Madison | Nebraska | 31119 | 7043 | 53 |
2058840 | 2058840 | 2021-12-28 | Madison | Nebraska | 31119 | 7023 | 53 |
2055591 | 2055591 | 2021-12-27 | Madison | Nebraska | 31119 | 6983 | 53 |
2052341 | 2052341 | 2021-12-26 | Madison | Nebraska | 31119 | 6983 | 53 |
2049091 | 2049091 | 2021-12-25 | Madison | Nebraska | 31119 | 6983 | 53 |
2045841 | 2045841 | 2021-12-24 | Madison | Nebraska | 31119 | 6983 | 53 |
2042591 | 2042591 | 2021-12-23 | Madison | Nebraska | 31119 | 6983 | 53 |
2039342 | 2039342 | 2021-12-22 | Madison | Nebraska | 31119 | 6961 | 53 |
2036092 | 2036092 | 2021-12-21 | Madison | Nebraska | 31119 | 6941 | 53 |
2032842 | 2032842 | 2021-12-20 | Madison | Nebraska | 31119 | 6927 | 53 |
2029591 | 2029591 | 2021-12-19 | Madison | Nebraska | 31119 | 6895 | 53 |
2026340 | 2026340 | 2021-12-18 | Madison | Nebraska | 31119 | 6895 | 53 |
2023089 | 2023089 | 2021-12-17 | Madison | Nebraska | 31119 | 6895 | 53 |
2019838 | 2019838 | 2021-12-16 | Madison | Nebraska | 31119 | 6881 | 53 |
2016588 | 2016588 | 2021-12-15 | Madison | Nebraska | 31119 | 6863 | 53 |
2013337 | 2013337 | 2021-12-14 | Madison | Nebraska | 31119 | 6852 | 52 |
2010086 | 2010086 | 2021-12-13 | Madison | Nebraska | 31119 | 6843 | 52 |
2006835 | 2006835 | 2021-12-12 | Madison | Nebraska | 31119 | 6818 | 52 |
2003584 | 2003584 | 2021-12-11 | Madison | Nebraska | 31119 | 6818 | 52 |
2000334 | 2000334 | 2021-12-10 | Madison | Nebraska | 31119 | 6818 | 52 |
1997083 | 1997083 | 2021-12-09 | Madison | Nebraska | 31119 | 6795 | 50 |
1993832 | 1993832 | 2021-12-08 | Madison | Nebraska | 31119 | 6780 | 50 |
1990581 | 1990581 | 2021-12-07 | Madison | Nebraska | 31119 | 6753 | 50 |
1987331 | 1987331 | 2021-12-06 | Madison | Nebraska | 31119 | 6728 | 50 |
1984081 | 1984081 | 2021-12-05 | Madison | Nebraska | 31119 | 6680 | 50 |
1980831 | 1980831 | 2021-12-04 | Madison | Nebraska | 31119 | 6680 | 50 |
1977581 | 1977581 | 2021-12-03 | Madison | Nebraska | 31119 | 6680 | 50 |
1974331 | 1974331 | 2021-12-02 | Madison | Nebraska | 31119 | 6647 | 50 |
1971082 | 1971082 | 2021-12-01 | Madison | Nebraska | 31119 | 6610 | 50 |
1967832 | 1967832 | 2021-11-30 | Madison | Nebraska | 31119 | 6582 | 50 |
1964580 | 1964580 | 2021-11-29 | Madison | Nebraska | 31119 | 6543 | 50 |
1961329 | 1961329 | 2021-11-28 | Madison | Nebraska | 31119 | 6470 | 50 |
1958078 | 1958078 | 2021-11-27 | Madison | Nebraska | 31119 | 6470 | 50 |
1954827 | 1954827 | 2021-11-26 | Madison | Nebraska | 31119 | 6470 | 50 |
1951576 | 1951576 | 2021-11-25 | Madison | Nebraska | 31119 | 6470 | 49 |
1948325 | 1948325 | 2021-11-24 | Madison | Nebraska | 31119 | 6470 | 49 |
1945074 | 1945074 | 2021-11-23 | Madison | Nebraska | 31119 | 6455 | 49 |
1941823 | 1941823 | 2021-11-22 | Madison | Nebraska | 31119 | 6395 | 49 |
1938573 | 1938573 | 2021-11-21 | Madison | Nebraska | 31119 | 6348 | 49 |
1935323 | 1935323 | 2021-11-20 | Madison | Nebraska | 31119 | 6348 | 49 |
1932073 | 1932073 | 2021-11-19 | Madison | Nebraska | 31119 | 6348 | 49 |
1928822 | 1928822 | 2021-11-18 | Madison | Nebraska | 31119 | 6317 | 49 |
1925572 | 1925572 | 2021-11-17 | Madison | Nebraska | 31119 | 6255 | 49 |
1922323 | 1922323 | 2021-11-16 | Madison | Nebraska | 31119 | 6225 | 49 |
1919073 | 1919073 | 2021-11-15 | Madison | Nebraska | 31119 | 6168 | 49 |
1915823 | 1915823 | 2021-11-14 | Madison | Nebraska | 31119 | 6097 | 49 |
1912573 | 1912573 | 2021-11-13 | Madison | Nebraska | 31119 | 6097 | 49 |
1909323 | 1909323 | 2021-11-12 | Madison | Nebraska | 31119 | 6097 | 49 |
1906074 | 1906074 | 2021-11-11 | Madison | Nebraska | 31119 | 6078 | 49 |
1902825 | 1902825 | 2021-11-10 | Madison | Nebraska | 31119 | 6041 | 49 |
1899575 | 1899575 | 2021-11-09 | Madison | Nebraska | 31119 | 5979 | 49 |
1896325 | 1896325 | 2021-11-08 | Madison | Nebraska | 31119 | 5952 | 49 |
1893075 | 1893075 | 2021-11-07 | Madison | Nebraska | 31119 | 5887 | 47 |
1889825 | 1889825 | 2021-11-06 | Madison | Nebraska | 31119 | 5887 | 47 |
1886575 | 1886575 | 2021-11-05 | Madison | Nebraska | 31119 | 5887 | 47 |
1883326 | 1883326 | 2021-11-04 | Madison | Nebraska | 31119 | 5887 | 47 |
1880077 | 1880077 | 2021-11-03 | Madison | Nebraska | 31119 | 5887 | 47 |
1876828 | 1876828 | 2021-11-02 | Madison | Nebraska | 31119 | 5796 | 47 |
1873579 | 1873579 | 2021-11-01 | Madison | Nebraska | 31119 | 5796 | 47 |
1870330 | 1870330 | 2021-10-31 | Madison | Nebraska | 31119 | 5746 | 47 |
1867081 | 1867081 | 2021-10-30 | Madison | Nebraska | 31119 | 5741 | 47 |
1863832 | 1863832 | 2021-10-29 | Madison | Nebraska | 31119 | 5741 | 47 |
1860583 | 1860583 | 2021-10-28 | Madison | Nebraska | 31119 | 5704 | 46 |
1857334 | 1857334 | 2021-10-27 | Madison | Nebraska | 31119 | 5704 | 45 |
1854085 | 1854085 | 2021-10-26 | Madison | Nebraska | 31119 | 5621 | 45 |
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);