ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 109 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
669476 | 669476 | 2020-10-26 | Vinton | Ohio | 39163 | 109 | 3 |
559193 | 559193 | 2020-09-22 | Monroe | Ohio | 39111 | 109 | 18 |
536476 | 536476 | 2020-09-15 | Adams | Ohio | 39001 | 109 | 4 |
407302 | 407302 | 2020-08-06 | Fayette | Ohio | 39047 | 109 | 0 |
400905 | 400905 | 2020-08-04 | Perry | Ohio | 39127 | 109 | 3 |
384805 | 384805 | 2020-07-30 | Logan | Ohio | 39091 | 109 | 1 |
365500 | 365500 | 2020-07-24 | Fulton | Ohio | 39051 | 109 | 0 |
343084 | 343084 | 2020-07-17 | Hancock | Ohio | 39063 | 109 | 1 |
323906 | 323906 | 2020-07-11 | Auglaize | Ohio | 39011 | 109 | 4 |
323941 | 323941 | 2020-07-11 | Jefferson | Ohio | 39081 | 109 | 2 |
320726 | 320726 | 2020-07-10 | Auglaize | Ohio | 39011 | 109 | 4 |
317549 | 317549 | 2020-07-09 | Auglaize | Ohio | 39011 | 109 | 4 |
295447 | 295447 | 2020-07-02 | Ross | Ohio | 39141 | 109 | 2 |
292292 | 292292 | 2020-07-01 | Ross | Ohio | 39141 | 109 | 2 |
276549 | 276549 | 2020-06-26 | Putnam | Ohio | 39137 | 109 | 15 |
260876 | 260876 | 2020-06-21 | Sandusky | Ohio | 39143 | 109 | 13 |
257749 | 257749 | 2020-06-20 | Sandusky | Ohio | 39143 | 109 | 13 |
254590 | 254590 | 2020-06-19 | Holmes | Ohio | 39075 | 109 | 3 |
254624 | 254624 | 2020-06-19 | Sandusky | Ohio | 39143 | 109 | 13 |
220433 | 220433 | 2020-06-08 | Ottawa | Ohio | 39123 | 109 | 19 |
217341 | 217341 | 2020-06-07 | Ottawa | Ohio | 39123 | 109 | 19 |
214251 | 214251 | 2020-06-06 | Ottawa | Ohio | 39123 | 109 | 19 |
144153 | 144153 | 2020-05-14 | Mercer | Ohio | 39107 | 109 | 1 |
117241 | 117241 | 2020-05-05 | Clermont | Ohio | 39025 | 109 | 3 |
108671 | 108671 | 2020-05-02 | Tuscarawas | Ohio | 39157 | 109 | 0 |
83086 | 83086 | 2020-04-23 | Fairfield | Ohio | 39045 | 109 | 2 |
37275 | 37275 | 2020-04-06 | Montgomery | Ohio | 39113 | 109 | 2 |
37293 | 37293 | 2020-04-06 | Stark | Ohio | 39151 | 109 | 7 |
13478 | 13478 | 2020-03-26 | Franklin | Ohio | 39049 | 109 | 2 |
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);