ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Franklin" and fips = 31061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175896 | 2175896 | 2022-02-02 | Franklin | Nebraska | 31061 | 390 | 9 |
2172643 | 2172643 | 2022-02-01 | Franklin | Nebraska | 31061 | 389 | 9 |
2169390 | 2169390 | 2022-01-31 | Franklin | Nebraska | 31061 | 389 | 8 |
2166135 | 2166135 | 2022-01-30 | Franklin | Nebraska | 31061 | 385 | 8 |
2162880 | 2162880 | 2022-01-29 | Franklin | Nebraska | 31061 | 385 | 8 |
2159625 | 2159625 | 2022-01-28 | Franklin | Nebraska | 31061 | 385 | 8 |
2156371 | 2156371 | 2022-01-27 | Franklin | Nebraska | 31061 | 381 | 8 |
2153118 | 2153118 | 2022-01-26 | Franklin | Nebraska | 31061 | 379 | 8 |
2149866 | 2149866 | 2022-01-25 | Franklin | Nebraska | 31061 | 378 | 8 |
2146614 | 2146614 | 2022-01-24 | Franklin | Nebraska | 31061 | 378 | 8 |
2143359 | 2143359 | 2022-01-23 | Franklin | Nebraska | 31061 | 375 | 8 |
2140104 | 2140104 | 2022-01-22 | Franklin | Nebraska | 31061 | 375 | 8 |
2136848 | 2136848 | 2022-01-21 | Franklin | Nebraska | 31061 | 375 | 8 |
2133596 | 2133596 | 2022-01-20 | Franklin | Nebraska | 31061 | 375 | 8 |
2130343 | 2130343 | 2022-01-19 | Franklin | Nebraska | 31061 | 373 | 8 |
2127089 | 2127089 | 2022-01-18 | Franklin | Nebraska | 31061 | 371 | 8 |
2123837 | 2123837 | 2022-01-17 | Franklin | Nebraska | 31061 | 371 | 8 |
2120585 | 2120585 | 2022-01-16 | Franklin | Nebraska | 31061 | 367 | 8 |
2117333 | 2117333 | 2022-01-15 | Franklin | Nebraska | 31061 | 367 | 8 |
2114082 | 2114082 | 2022-01-14 | Franklin | Nebraska | 31061 | 367 | 8 |
2110830 | 2110830 | 2022-01-13 | Franklin | Nebraska | 31061 | 368 | 8 |
2107579 | 2107579 | 2022-01-12 | Franklin | Nebraska | 31061 | 367 | 8 |
2104328 | 2104328 | 2022-01-11 | Franklin | Nebraska | 31061 | 366 | 8 |
2101077 | 2101077 | 2022-01-10 | Franklin | Nebraska | 31061 | 366 | 8 |
2097826 | 2097826 | 2022-01-09 | Franklin | Nebraska | 31061 | 363 | 8 |
2094574 | 2094574 | 2022-01-08 | Franklin | Nebraska | 31061 | 363 | 8 |
2091322 | 2091322 | 2022-01-07 | Franklin | Nebraska | 31061 | 363 | 8 |
2088071 | 2088071 | 2022-01-06 | Franklin | Nebraska | 31061 | 363 | 8 |
2084819 | 2084819 | 2022-01-05 | Franklin | Nebraska | 31061 | 360 | 8 |
2081567 | 2081567 | 2022-01-04 | Franklin | Nebraska | 31061 | 359 | 8 |
2078315 | 2078315 | 2022-01-03 | Franklin | Nebraska | 31061 | 358 | 8 |
2075064 | 2075064 | 2022-01-02 | Franklin | Nebraska | 31061 | 357 | 8 |
2071813 | 2071813 | 2022-01-01 | Franklin | Nebraska | 31061 | 357 | 8 |
2068562 | 2068562 | 2021-12-31 | Franklin | Nebraska | 31061 | 357 | 8 |
2065311 | 2065311 | 2021-12-30 | Franklin | Nebraska | 31061 | 357 | 8 |
2062061 | 2062061 | 2021-12-29 | Franklin | Nebraska | 31061 | 357 | 8 |
2058812 | 2058812 | 2021-12-28 | Franklin | Nebraska | 31061 | 354 | 8 |
2055563 | 2055563 | 2021-12-27 | Franklin | Nebraska | 31061 | 354 | 8 |
2052313 | 2052313 | 2021-12-26 | Franklin | Nebraska | 31061 | 354 | 8 |
2049063 | 2049063 | 2021-12-25 | Franklin | Nebraska | 31061 | 354 | 8 |
2045813 | 2045813 | 2021-12-24 | Franklin | Nebraska | 31061 | 354 | 8 |
2042563 | 2042563 | 2021-12-23 | Franklin | Nebraska | 31061 | 354 | 8 |
2039314 | 2039314 | 2021-12-22 | Franklin | Nebraska | 31061 | 354 | 7 |
2036064 | 2036064 | 2021-12-21 | Franklin | Nebraska | 31061 | 353 | 7 |
2032814 | 2032814 | 2021-12-20 | Franklin | Nebraska | 31061 | 353 | 7 |
2029563 | 2029563 | 2021-12-19 | Franklin | Nebraska | 31061 | 353 | 7 |
2026312 | 2026312 | 2021-12-18 | Franklin | Nebraska | 31061 | 353 | 7 |
2023061 | 2023061 | 2021-12-17 | Franklin | Nebraska | 31061 | 353 | 7 |
2019810 | 2019810 | 2021-12-16 | Franklin | Nebraska | 31061 | 353 | 7 |
2016560 | 2016560 | 2021-12-15 | Franklin | Nebraska | 31061 | 353 | 7 |
2013309 | 2013309 | 2021-12-14 | Franklin | Nebraska | 31061 | 353 | 7 |
2010058 | 2010058 | 2021-12-13 | Franklin | Nebraska | 31061 | 353 | 7 |
2006807 | 2006807 | 2021-12-12 | Franklin | Nebraska | 31061 | 352 | 7 |
2003556 | 2003556 | 2021-12-11 | Franklin | Nebraska | 31061 | 352 | 7 |
2000306 | 2000306 | 2021-12-10 | Franklin | Nebraska | 31061 | 352 | 7 |
1997055 | 1997055 | 2021-12-09 | Franklin | Nebraska | 31061 | 352 | 7 |
1993804 | 1993804 | 2021-12-08 | Franklin | Nebraska | 31061 | 348 | 7 |
1990553 | 1990553 | 2021-12-07 | Franklin | Nebraska | 31061 | 347 | 7 |
1987303 | 1987303 | 2021-12-06 | Franklin | Nebraska | 31061 | 345 | 7 |
1984053 | 1984053 | 2021-12-05 | Franklin | Nebraska | 31061 | 342 | 7 |
1980803 | 1980803 | 2021-12-04 | Franklin | Nebraska | 31061 | 342 | 7 |
1977553 | 1977553 | 2021-12-03 | Franklin | Nebraska | 31061 | 342 | 7 |
1974303 | 1974303 | 2021-12-02 | Franklin | Nebraska | 31061 | 342 | 7 |
1971054 | 1971054 | 2021-12-01 | Franklin | Nebraska | 31061 | 342 | 7 |
1967804 | 1967804 | 2021-11-30 | Franklin | Nebraska | 31061 | 341 | 7 |
1964552 | 1964552 | 2021-11-29 | Franklin | Nebraska | 31061 | 340 | 7 |
1961301 | 1961301 | 2021-11-28 | Franklin | Nebraska | 31061 | 336 | 7 |
1958050 | 1958050 | 2021-11-27 | Franklin | Nebraska | 31061 | 336 | 7 |
1954799 | 1954799 | 2021-11-26 | Franklin | Nebraska | 31061 | 336 | 7 |
1951548 | 1951548 | 2021-11-25 | Franklin | Nebraska | 31061 | 336 | 7 |
1948297 | 1948297 | 2021-11-24 | Franklin | Nebraska | 31061 | 336 | 7 |
1945046 | 1945046 | 2021-11-23 | Franklin | Nebraska | 31061 | 335 | 7 |
1941795 | 1941795 | 2021-11-22 | Franklin | Nebraska | 31061 | 331 | 7 |
1938545 | 1938545 | 2021-11-21 | Franklin | Nebraska | 31061 | 330 | 7 |
1935295 | 1935295 | 2021-11-20 | Franklin | Nebraska | 31061 | 330 | 7 |
1932045 | 1932045 | 2021-11-19 | Franklin | Nebraska | 31061 | 330 | 7 |
1928794 | 1928794 | 2021-11-18 | Franklin | Nebraska | 31061 | 330 | 7 |
1925544 | 1925544 | 2021-11-17 | Franklin | Nebraska | 31061 | 330 | 7 |
1922295 | 1922295 | 2021-11-16 | Franklin | Nebraska | 31061 | 330 | 7 |
1919045 | 1919045 | 2021-11-15 | Franklin | Nebraska | 31061 | 330 | 7 |
1915795 | 1915795 | 2021-11-14 | Franklin | Nebraska | 31061 | 328 | 7 |
1912545 | 1912545 | 2021-11-13 | Franklin | Nebraska | 31061 | 328 | 7 |
1909295 | 1909295 | 2021-11-12 | Franklin | Nebraska | 31061 | 328 | 7 |
1906046 | 1906046 | 2021-11-11 | Franklin | Nebraska | 31061 | 327 | 7 |
1902797 | 1902797 | 2021-11-10 | Franklin | Nebraska | 31061 | 325 | 7 |
1899547 | 1899547 | 2021-11-09 | Franklin | Nebraska | 31061 | 325 | 7 |
1896297 | 1896297 | 2021-11-08 | Franklin | Nebraska | 31061 | 325 | 7 |
1893047 | 1893047 | 2021-11-07 | Franklin | Nebraska | 31061 | 322 | 6 |
1889797 | 1889797 | 2021-11-06 | Franklin | Nebraska | 31061 | 322 | 6 |
1886547 | 1886547 | 2021-11-05 | Franklin | Nebraska | 31061 | 322 | 6 |
1883298 | 1883298 | 2021-11-04 | Franklin | Nebraska | 31061 | 322 | 6 |
1880049 | 1880049 | 2021-11-03 | Franklin | Nebraska | 31061 | 322 | 6 |
1876800 | 1876800 | 2021-11-02 | Franklin | Nebraska | 31061 | 321 | 6 |
1873551 | 1873551 | 2021-11-01 | Franklin | Nebraska | 31061 | 321 | 6 |
1870302 | 1870302 | 2021-10-31 | Franklin | Nebraska | 31061 | 321 | 6 |
1867053 | 1867053 | 2021-10-30 | Franklin | Nebraska | 31061 | 320 | 6 |
1863804 | 1863804 | 2021-10-29 | Franklin | Nebraska | 31061 | 320 | 6 |
1860555 | 1860555 | 2021-10-28 | Franklin | Nebraska | 31061 | 320 | 6 |
1857306 | 1857306 | 2021-10-27 | Franklin | Nebraska | 31061 | 320 | 6 |
1854057 | 1854057 | 2021-10-26 | Franklin | Nebraska | 31061 | 316 | 6 |
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);