ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 106 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 |
---|---|---|---|---|---|---|---|
701860 | 701860 | 2020-11-05 | Harrison | Ohio | 39067 | 106 | 3 |
662987 | 662987 | 2020-10-24 | Vinton | Ohio | 39163 | 106 | 3 |
562437 | 562437 | 2020-09-23 | Paulding | Ohio | 39125 | 106 | 0 |
552719 | 552719 | 2020-09-20 | Monroe | Ohio | 39111 | 106 | 18 |
549480 | 549480 | 2020-09-19 | Monroe | Ohio | 39111 | 106 | 18 |
546241 | 546241 | 2020-09-18 | Monroe | Ohio | 39111 | 106 | 18 |
543004 | 543004 | 2020-09-17 | Monroe | Ohio | 39111 | 106 | 18 |
539768 | 539768 | 2020-09-16 | Monroe | Ohio | 39111 | 106 | 18 |
536531 | 536531 | 2020-09-15 | Monroe | Ohio | 39111 | 106 | 18 |
533295 | 533295 | 2020-09-14 | Monroe | Ohio | 39111 | 106 | 18 |
530060 | 530060 | 2020-09-13 | Monroe | Ohio | 39111 | 106 | 18 |
526823 | 526823 | 2020-09-12 | Monroe | Ohio | 39111 | 106 | 18 |
523587 | 523587 | 2020-09-11 | Monroe | Ohio | 39111 | 106 | 18 |
520351 | 520351 | 2020-09-10 | Monroe | Ohio | 39111 | 106 | 18 |
471842 | 471842 | 2020-08-26 | Meigs | Ohio | 39105 | 106 | 0 |
458899 | 458899 | 2020-08-22 | Gallia | Ohio | 39053 | 106 | 2 |
397661 | 397661 | 2020-08-03 | Henry | Ohio | 39069 | 106 | 1 |
397690 | 397690 | 2020-08-03 | Perry | Ohio | 39127 | 106 | 2 |
394444 | 394444 | 2020-08-02 | Henry | Ohio | 39069 | 106 | 1 |
391230 | 391230 | 2020-08-01 | Hocking | Ohio | 39073 | 106 | 9 |
388013 | 388013 | 2020-07-31 | Hocking | Ohio | 39073 | 106 | 9 |
381577 | 381577 | 2020-07-29 | Highland | Ohio | 39071 | 106 | 1 |
375195 | 375195 | 2020-07-27 | Wyandot | Ohio | 39175 | 106 | 5 |
371981 | 371981 | 2020-07-26 | Williams | Ohio | 39171 | 106 | 3 |
368703 | 368703 | 2020-07-25 | Defiance | Ohio | 39039 | 106 | 4 |
355931 | 355931 | 2020-07-21 | Scioto | Ohio | 39145 | 106 | 0 |
352669 | 352669 | 2020-07-20 | Clinton | Ohio | 39027 | 106 | 2 |
333524 | 333524 | 2020-07-14 | Muskingum | Ohio | 39119 | 106 | 1 |
330332 | 330332 | 2020-07-13 | Muskingum | Ohio | 39119 | 106 | 1 |
304868 | 304868 | 2020-07-05 | Auglaize | Ohio | 39011 | 106 | 4 |
301705 | 301705 | 2020-07-04 | Auglaize | Ohio | 39011 | 106 | 4 |
270263 | 270263 | 2020-06-24 | Putnam | Ohio | 39137 | 106 | 15 |
254585 | 254585 | 2020-06-19 | Hardin | Ohio | 39065 | 106 | 5 |
251509 | 251509 | 2020-06-18 | Sandusky | Ohio | 39143 | 106 | 13 |
211132 | 211132 | 2020-06-05 | Greene | Ohio | 39057 | 106 | 5 |
180432 | 180432 | 2020-05-26 | Crawford | Ohio | 39033 | 106 | 3 |
120273 | 120273 | 2020-05-06 | Washington | Ohio | 39167 | 106 | 16 |
91499 | 91499 | 2020-04-26 | Allen | Ohio | 39003 | 106 | 18 |
91504 | 91504 | 2020-04-26 | Belmont | Ohio | 39013 | 106 | 6 |
80287 | 80287 | 2020-04-22 | Fairfield | Ohio | 39045 | 106 | 2 |
44924 | 44924 | 2020-04-09 | Lake | Ohio | 39085 | 106 | 5 |
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);