ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where cases = 373 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
808940 | 808940 | 2020-12-08 | Harrison | Ohio | 39067 | 373 | 3 |
705157 | 705157 | 2020-11-06 | Wyandot | Ohio | 39175 | 373 | 14 |
701853 | 701853 | 2020-11-05 | Gallia | Ohio | 39053 | 373 | 13 |
666234 | 666234 | 2020-10-25 | Washington | Ohio | 39167 | 373 | 24 |
659725 | 659725 | 2020-10-23 | Perry | Ohio | 39127 | 373 | 11 |
649930 | 649930 | 2020-10-20 | Ashland | Ohio | 39005 | 373 | 5 |
636954 | 636954 | 2020-10-16 | Champaign | Ohio | 39021 | 373 | 3 |
607791 | 607791 | 2020-10-07 | Henry | Ohio | 39069 | 373 | 17 |
500960 | 500960 | 2020-09-04 | Preble | Ohio | 39135 | 373 | 6 |
465334 | 465334 | 2020-08-24 | Athens | Ohio | 39009 | 373 | 2 |
462105 | 462105 | 2020-08-23 | Athens | Ohio | 39009 | 373 | 2 |
413790 | 413790 | 2020-08-08 | Sandusky | Ohio | 39143 | 373 | 16 |
327170 | 327170 | 2020-07-12 | Wayne | Ohio | 39169 | 373 | 55 |
267103 | 267103 | 2020-06-23 | Lake | Ohio | 39085 | 373 | 15 |
214244 | 214244 | 2020-06-06 | Miami | Ohio | 39109 | 373 | 30 |
195798 | 195798 | 2020-05-31 | Warren | Ohio | 39165 | 373 | 21 |
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);