ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where county = "Cedar", 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 |
---|---|---|---|---|---|---|---|
879930 | 879930 | 2020-12-30 | Cedar | Nebraska | 31027 | 544 | 8 |
876685 | 876685 | 2020-12-29 | Cedar | Nebraska | 31027 | 547 | 8 |
873440 | 873440 | 2020-12-28 | Cedar | Nebraska | 31027 | 547 | 8 |
870195 | 870195 | 2020-12-27 | Cedar | Nebraska | 31027 | 548 | 8 |
866950 | 866950 | 2020-12-26 | Cedar | Nebraska | 31027 | 547 | 8 |
863705 | 863705 | 2020-12-25 | Cedar | Nebraska | 31027 | 547 | 8 |
860460 | 860460 | 2020-12-24 | Cedar | Nebraska | 31027 | 547 | 8 |
857215 | 857215 | 2020-12-23 | Cedar | Nebraska | 31027 | 546 | 8 |
853970 | 853970 | 2020-12-22 | Cedar | Nebraska | 31027 | 541 | 8 |
850725 | 850725 | 2020-12-21 | Cedar | Nebraska | 31027 | 540 | 8 |
847480 | 847480 | 2020-12-20 | Cedar | Nebraska | 31027 | 541 | 8 |
844234 | 844234 | 2020-12-19 | Cedar | Nebraska | 31027 | 539 | 8 |
840989 | 840989 | 2020-12-18 | Cedar | Nebraska | 31027 | 537 | 8 |
837744 | 837744 | 2020-12-17 | Cedar | Nebraska | 31027 | 525 | 8 |
834498 | 834498 | 2020-12-16 | Cedar | Nebraska | 31027 | 525 | 8 |
831251 | 831251 | 2020-12-15 | Cedar | Nebraska | 31027 | 523 | 8 |
828005 | 828005 | 2020-12-14 | Cedar | Nebraska | 31027 | 506 | 8 |
824758 | 824758 | 2020-12-13 | Cedar | Nebraska | 31027 | 506 | 8 |
821512 | 821512 | 2020-12-12 | Cedar | Nebraska | 31027 | 504 | 8 |
818266 | 818266 | 2020-12-11 | Cedar | Nebraska | 31027 | 497 | 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);