ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where county = "Franklin", deaths = 8 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
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);