ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where "date" is on date 2020-04-13 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adams 1
- Allen 1
- Ashland 1
- Ashtabula 1
- Athens 1
- Auglaize 1
- Belmont 1
- Brown 1
- Butler 1
- Carroll 1
- Champaign 1
- Clark 1
- Clermont 1
- Clinton 1
- Columbiana 1
- Coshocton 1
- Crawford 1
- Cuyahoga 1
- Darke 1
- Defiance 1
- Delaware 1
- Erie 1
- Fairfield 1
- Fayette 1
- Franklin 1
- Fulton 1
- Gallia 1
- Geauga 1
- Greene 1
- Guernsey 1
- …
state 1
- Ohio · 86 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
55511 | 55511 | 2020-04-13 | Adams | Ohio | 39001 | 3 | 0 |
55512 | 55512 | 2020-04-13 | Allen | Ohio | 39003 | 37 | 4 |
55513 | 55513 | 2020-04-13 | Ashland | Ohio | 39005 | 5 | 0 |
55514 | 55514 | 2020-04-13 | Ashtabula | Ohio | 39007 | 31 | 2 |
55515 | 55515 | 2020-04-13 | Athens | Ohio | 39009 | 3 | 1 |
55516 | 55516 | 2020-04-13 | Auglaize | Ohio | 39011 | 14 | 1 |
55517 | 55517 | 2020-04-13 | Belmont | Ohio | 39013 | 53 | 2 |
55518 | 55518 | 2020-04-13 | Brown | Ohio | 39015 | 5 | 1 |
55519 | 55519 | 2020-04-13 | Butler | Ohio | 39017 | 121 | 2 |
55520 | 55520 | 2020-04-13 | Carroll | Ohio | 39019 | 14 | 0 |
55521 | 55521 | 2020-04-13 | Champaign | Ohio | 39021 | 6 | 1 |
55522 | 55522 | 2020-04-13 | Clark | Ohio | 39023 | 20 | 0 |
55523 | 55523 | 2020-04-13 | Clermont | Ohio | 39025 | 39 | 1 |
55524 | 55524 | 2020-04-13 | Clinton | Ohio | 39027 | 16 | 0 |
55525 | 55525 | 2020-04-13 | Columbiana | Ohio | 39029 | 114 | 6 |
55526 | 55526 | 2020-04-13 | Coshocton | Ohio | 39031 | 16 | 0 |
55527 | 55527 | 2020-04-13 | Crawford | Ohio | 39033 | 17 | 0 |
55528 | 55528 | 2020-04-13 | Cuyahoga | Ohio | 39035 | 1197 | 24 |
55529 | 55529 | 2020-04-13 | Darke | Ohio | 39037 | 49 | 9 |
55530 | 55530 | 2020-04-13 | Defiance | Ohio | 39039 | 12 | 0 |
55531 | 55531 | 2020-04-13 | Delaware | Ohio | 39041 | 96 | 2 |
55532 | 55532 | 2020-04-13 | Erie | Ohio | 39043 | 12 | 1 |
55533 | 55533 | 2020-04-13 | Fairfield | Ohio | 39045 | 84 | 1 |
55534 | 55534 | 2020-04-13 | Fayette | Ohio | 39047 | 10 | 0 |
55535 | 55535 | 2020-04-13 | Franklin | Ohio | 39049 | 1012 | 15 |
55536 | 55536 | 2020-04-13 | Fulton | Ohio | 39051 | 7 | 0 |
55537 | 55537 | 2020-04-13 | Gallia | Ohio | 39053 | 8 | 1 |
55538 | 55538 | 2020-04-13 | Geauga | Ohio | 39055 | 68 | 2 |
55539 | 55539 | 2020-04-13 | Greene | Ohio | 39057 | 30 | 1 |
55540 | 55540 | 2020-04-13 | Guernsey | Ohio | 39059 | 6 | 0 |
55541 | 55541 | 2020-04-13 | Hamilton | Ohio | 39061 | 558 | 21 |
55542 | 55542 | 2020-04-13 | Hancock | Ohio | 39063 | 19 | 1 |
55543 | 55543 | 2020-04-13 | Hardin | Ohio | 39065 | 8 | 0 |
55544 | 55544 | 2020-04-13 | Henry | Ohio | 39069 | 1 | 0 |
55545 | 55545 | 2020-04-13 | Highland | Ohio | 39071 | 7 | 0 |
55546 | 55546 | 2020-04-13 | Hocking | Ohio | 39073 | 2 | 0 |
55547 | 55547 | 2020-04-13 | Holmes | Ohio | 39075 | 3 | 0 |
55548 | 55548 | 2020-04-13 | Huron | Ohio | 39077 | 14 | 1 |
55549 | 55549 | 2020-04-13 | Jackson | Ohio | 39079 | 2 | 0 |
55550 | 55550 | 2020-04-13 | Jefferson | Ohio | 39081 | 24 | 0 |
55551 | 55551 | 2020-04-13 | Knox | Ohio | 39083 | 10 | 1 |
55552 | 55552 | 2020-04-13 | Lake | Ohio | 39085 | 117 | 6 |
55553 | 55553 | 2020-04-13 | Lawrence | Ohio | 39087 | 17 | 0 |
55554 | 55554 | 2020-04-13 | Licking | Ohio | 39089 | 86 | 3 |
55555 | 55555 | 2020-04-13 | Logan | Ohio | 39091 | 8 | 0 |
55556 | 55556 | 2020-04-13 | Lorain | Ohio | 39093 | 184 | 6 |
55557 | 55557 | 2020-04-13 | Lucas | Ohio | 39095 | 514 | 21 |
55558 | 55558 | 2020-04-13 | Madison | Ohio | 39097 | 24 | 3 |
55559 | 55559 | 2020-04-13 | Mahoning | Ohio | 39099 | 443 | 31 |
55560 | 55560 | 2020-04-13 | Marion | Ohio | 39101 | 91 | 0 |
55561 | 55561 | 2020-04-13 | Medina | Ohio | 39103 | 112 | 8 |
55562 | 55562 | 2020-04-13 | Meigs | Ohio | 39105 | 1 | 0 |
55563 | 55563 | 2020-04-13 | Mercer | Ohio | 39107 | 13 | 1 |
55564 | 55564 | 2020-04-13 | Miami | Ohio | 39109 | 121 | 15 |
55565 | 55565 | 2020-04-13 | Monroe | Ohio | 39111 | 2 | 0 |
55566 | 55566 | 2020-04-13 | Montgomery | Ohio | 39113 | 201 | 7 |
55567 | 55567 | 2020-04-13 | Morgan | Ohio | 39115 | 2 | 0 |
55568 | 55568 | 2020-04-13 | Morrow | Ohio | 39117 | 9 | 0 |
55569 | 55569 | 2020-04-13 | Muskingum | Ohio | 39119 | 8 | 0 |
55570 | 55570 | 2020-04-13 | Noble | Ohio | 39121 | 2 | 0 |
55571 | 55571 | 2020-04-13 | Ottawa | Ohio | 39123 | 11 | 0 |
55572 | 55572 | 2020-04-13 | Paulding | Ohio | 39125 | 5 | 0 |
55573 | 55573 | 2020-04-13 | Perry | Ohio | 39127 | 8 | 0 |
55574 | 55574 | 2020-04-13 | Pickaway | Ohio | 39129 | 83 | 0 |
55575 | 55575 | 2020-04-13 | Pike | Ohio | 39131 | 1 | 0 |
55576 | 55576 | 2020-04-13 | Portage | Ohio | 39133 | 144 | 17 |
55577 | 55577 | 2020-04-13 | Preble | Ohio | 39135 | 16 | 1 |
55578 | 55578 | 2020-04-13 | Putnam | Ohio | 39137 | 1 | 0 |
55579 | 55579 | 2020-04-13 | Richland | Ohio | 39139 | 43 | 1 |
55580 | 55580 | 2020-04-13 | Ross | Ohio | 39141 | 19 | 0 |
55581 | 55581 | 2020-04-13 | Sandusky | Ohio | 39143 | 12 | 2 |
55582 | 55582 | 2020-04-13 | Scioto | Ohio | 39145 | 4 | 0 |
55583 | 55583 | 2020-04-13 | Seneca | Ohio | 39147 | 9 | 1 |
55584 | 55584 | 2020-04-13 | Shelby | Ohio | 39149 | 27 | 0 |
55585 | 55585 | 2020-04-13 | Stark | Ohio | 39151 | 167 | 12 |
55586 | 55586 | 2020-04-13 | Summit | Ohio | 39153 | 262 | 15 |
55587 | 55587 | 2020-04-13 | Trumbull | Ohio | 39155 | 174 | 10 |
55588 | 55588 | 2020-04-13 | Tuscarawas | Ohio | 39157 | 28 | 0 |
55589 | 55589 | 2020-04-13 | Union | Ohio | 39159 | 11 | 0 |
55590 | 55590 | 2020-04-13 | Van Wert | Ohio | 39161 | 2 | 0 |
55591 | 55591 | 2020-04-13 | Warren | Ohio | 39165 | 76 | 1 |
55592 | 55592 | 2020-04-13 | Washington | Ohio | 39167 | 41 | 1 |
55593 | 55593 | 2020-04-13 | Wayne | Ohio | 39169 | 54 | 5 |
55594 | 55594 | 2020-04-13 | Williams | Ohio | 39171 | 3 | 0 |
55595 | 55595 | 2020-04-13 | Wood | Ohio | 39173 | 54 | 4 |
55596 | 55596 | 2020-04-13 | Wyandot | Ohio | 39175 | 12 | 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);