ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where deaths = 74 and fips = 6095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
664325 | 664325 | 2020-10-25 | Solano | California | 6095 | 7291 | 74 |
661081 | 661081 | 2020-10-24 | Solano | California | 6095 | 7291 | 74 |
657837 | 657837 | 2020-10-23 | Solano | California | 6095 | 7291 | 74 |
654592 | 654592 | 2020-10-22 | Solano | California | 6095 | 7254 | 74 |
651347 | 651347 | 2020-10-21 | Solano | California | 6095 | 7210 | 74 |
648103 | 648103 | 2020-10-20 | Solano | California | 6095 | 7176 | 74 |
644858 | 644858 | 2020-10-19 | Solano | California | 6095 | 7122 | 74 |
641610 | 641610 | 2020-10-18 | Solano | California | 6095 | 7014 | 74 |
638363 | 638363 | 2020-10-17 | Solano | California | 6095 | 7014 | 74 |
635118 | 635118 | 2020-10-16 | Solano | California | 6095 | 7014 | 74 |
631872 | 631872 | 2020-10-15 | Solano | California | 6095 | 6956 | 74 |
628628 | 628628 | 2020-10-14 | Solano | California | 6095 | 6913 | 74 |
625385 | 625385 | 2020-10-13 | Solano | California | 6095 | 6881 | 74 |
622142 | 622142 | 2020-10-12 | Solano | California | 6095 | 6755 | 74 |
618899 | 618899 | 2020-10-11 | Solano | California | 6095 | 6755 | 74 |
615657 | 615657 | 2020-10-10 | Solano | California | 6095 | 6755 | 74 |
612416 | 612416 | 2020-10-09 | Solano | California | 6095 | 6755 | 74 |
609174 | 609174 | 2020-10-08 | Solano | California | 6095 | 6713 | 74 |
605931 | 605931 | 2020-10-07 | Solano | California | 6095 | 6663 | 74 |
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);