ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where county = "Lincoln", 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 |
---|---|---|---|---|---|---|---|
733927 | 733927 | 2020-11-15 | Lincoln | Nebraska | 31111 | 1757 | 8 |
730682 | 730682 | 2020-11-14 | Lincoln | Nebraska | 31111 | 1725 | 8 |
727439 | 727439 | 2020-11-13 | Lincoln | Nebraska | 31111 | 1656 | 8 |
724196 | 724196 | 2020-11-12 | Lincoln | Nebraska | 31111 | 1613 | 8 |
720953 | 720953 | 2020-11-11 | Lincoln | Nebraska | 31111 | 1587 | 8 |
717710 | 717710 | 2020-11-10 | Lincoln | Nebraska | 31111 | 1516 | 8 |
714466 | 714466 | 2020-11-09 | Lincoln | Nebraska | 31111 | 1461 | 8 |
711222 | 711222 | 2020-11-08 | Lincoln | Nebraska | 31111 | 1426 | 8 |
707978 | 707978 | 2020-11-07 | Lincoln | Nebraska | 31111 | 1391 | 8 |
704735 | 704735 | 2020-11-06 | Lincoln | Nebraska | 31111 | 1322 | 8 |
701493 | 701493 | 2020-11-05 | Lincoln | Nebraska | 31111 | 1171 | 8 |
698249 | 698249 | 2020-11-04 | Lincoln | Nebraska | 31111 | 1148 | 8 |
695006 | 695006 | 2020-11-03 | Lincoln | Nebraska | 31111 | 1090 | 8 |
691764 | 691764 | 2020-11-02 | Lincoln | Nebraska | 31111 | 1052 | 8 |
688519 | 688519 | 2020-11-01 | Lincoln | Nebraska | 31111 | 1033 | 8 |
685275 | 685275 | 2020-10-31 | Lincoln | Nebraska | 31111 | 999 | 8 |
682032 | 682032 | 2020-10-30 | Lincoln | Nebraska | 31111 | 969 | 8 |
678788 | 678788 | 2020-10-29 | Lincoln | Nebraska | 31111 | 938 | 8 |
675546 | 675546 | 2020-10-28 | Lincoln | Nebraska | 31111 | 902 | 8 |
672303 | 672303 | 2020-10-27 | Lincoln | Nebraska | 31111 | 888 | 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);