ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where county = "Kings", deaths = 87 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
781091 | 781091 | 2020-11-30 | Kings | California | 6031 | 11366 | 87 |
777845 | 777845 | 2020-11-29 | Kings | California | 6031 | 11270 | 87 |
774600 | 774600 | 2020-11-28 | Kings | California | 6031 | 11093 | 87 |
771355 | 771355 | 2020-11-27 | Kings | California | 6031 | 10687 | 87 |
768110 | 768110 | 2020-11-26 | Kings | California | 6031 | 10496 | 87 |
764864 | 764864 | 2020-11-25 | Kings | California | 6031 | 10440 | 87 |
761619 | 761619 | 2020-11-24 | Kings | California | 6031 | 10359 | 87 |
758374 | 758374 | 2020-11-23 | Kings | California | 6031 | 10259 | 87 |
742142 | 742142 | 2020-11-18 | Kings | California | 6031 | 9708 | 87 |
738895 | 738895 | 2020-11-17 | Kings | California | 6031 | 9664 | 87 |
735651 | 735651 | 2020-11-16 | Kings | California | 6031 | 9601 | 87 |
732405 | 732405 | 2020-11-15 | Kings | California | 6031 | 9515 | 87 |
729160 | 729160 | 2020-11-14 | Kings | California | 6031 | 9434 | 87 |
725917 | 725917 | 2020-11-13 | Kings | California | 6031 | 9372 | 87 |
722674 | 722674 | 2020-11-12 | Kings | California | 6031 | 9277 | 87 |
719431 | 719431 | 2020-11-11 | Kings | California | 6031 | 9236 | 87 |
716188 | 716188 | 2020-11-10 | Kings | California | 6031 | 9141 | 87 |
712944 | 712944 | 2020-11-09 | Kings | California | 6031 | 9070 | 87 |
709700 | 709700 | 2020-11-08 | Kings | California | 6031 | 9002 | 87 |
706456 | 706456 | 2020-11-07 | Kings | California | 6031 | 8889 | 87 |
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);