ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 312 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 |
---|---|---|---|---|---|---|---|
701827 | 701827 | 2020-11-05 | Adams | Ohio | 39001 | 312 | 6 |
659727 | 659727 | 2020-10-23 | Pike | Ohio | 39131 | 312 | 0 |
643523 | 643523 | 2020-10-18 | Williams | Ohio | 39171 | 312 | 4 |
624002 | 624002 | 2020-10-12 | Highland | Ohio | 39071 | 312 | 4 |
588329 | 588329 | 2020-10-01 | Fulton | Ohio | 39051 | 312 | 1 |
575388 | 575388 | 2020-09-27 | Logan | Ohio | 39091 | 312 | 3 |
572144 | 572144 | 2020-09-26 | Logan | Ohio | 39091 | 312 | 3 |
568891 | 568891 | 2020-09-25 | Henry | Ohio | 39069 | 312 | 13 |
536516 | 536516 | 2020-09-15 | Jefferson | Ohio | 39081 | 312 | 4 |
468630 | 468630 | 2020-08-25 | Scioto | Ohio | 39145 | 312 | 1 |
452496 | 452496 | 2020-08-20 | Union | Ohio | 39159 | 312 | 1 |
387995 | 387995 | 2020-07-31 | Darke | Ohio | 39037 | 312 | 27 |
285989 | 285989 | 2020-06-29 | Richland | Ohio | 39139 | 312 | 4 |
239033 | 239033 | 2020-06-14 | Licking | Ohio | 39089 | 312 | 11 |
226653 | 226653 | 2020-06-10 | Wood | Ohio | 39173 | 312 | 49 |
174407 | 174407 | 2020-05-24 | Tuscarawas | Ohio | 39157 | 312 | 2 |
94399 | 94399 | 2020-04-27 | Stark | Ohio | 39151 | 312 | 35 |
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);