ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where deaths = 19, fips = 39011 and state = "Ohio" 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 |
---|---|---|---|---|---|---|---|
718049 | 718049 | 2020-11-10 | Auglaize | Ohio | 39011 | 1591 | 19 |
714806 | 714806 | 2020-11-09 | Auglaize | Ohio | 39011 | 1535 | 19 |
711562 | 711562 | 2020-11-08 | Auglaize | Ohio | 39011 | 1515 | 19 |
708318 | 708318 | 2020-11-07 | Auglaize | Ohio | 39011 | 1494 | 19 |
705075 | 705075 | 2020-11-06 | Auglaize | Ohio | 39011 | 1460 | 19 |
701832 | 701832 | 2020-11-05 | Auglaize | Ohio | 39011 | 1430 | 19 |
698588 | 698588 | 2020-11-04 | Auglaize | Ohio | 39011 | 1393 | 19 |
695345 | 695345 | 2020-11-03 | Auglaize | Ohio | 39011 | 1341 | 19 |
692103 | 692103 | 2020-11-02 | Auglaize | Ohio | 39011 | 1300 | 19 |
688859 | 688859 | 2020-11-01 | Auglaize | Ohio | 39011 | 1279 | 19 |
685614 | 685614 | 2020-10-31 | Auglaize | Ohio | 39011 | 1258 | 19 |
682371 | 682371 | 2020-10-30 | Auglaize | Ohio | 39011 | 1233 | 19 |
679128 | 679128 | 2020-10-29 | Auglaize | Ohio | 39011 | 1198 | 19 |
675885 | 675885 | 2020-10-28 | Auglaize | Ohio | 39011 | 1147 | 19 |
672642 | 672642 | 2020-10-27 | Auglaize | Ohio | 39011 | 1127 | 19 |
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);