ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where "date" is on date 2021-05-06 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 · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1292589 | 1292589 | 2021-05-06 | Adams | Ohio | 39001 | 2370 | 52 |
1292590 | 1292590 | 2021-05-06 | Allen | Ohio | 39003 | 11609 | 231 |
1292591 | 1292591 | 2021-05-06 | Ashland | Ohio | 39005 | 4212 | 89 |
1292592 | 1292592 | 2021-05-06 | Ashtabula | Ohio | 39007 | 6777 | 169 |
1292593 | 1292593 | 2021-05-06 | Athens | Ohio | 39009 | 5182 | 58 |
1292594 | 1292594 | 2021-05-06 | Auglaize | Ohio | 39011 | 4884 | 84 |
1292595 | 1292595 | 2021-05-06 | Belmont | Ohio | 39013 | 5856 | 167 |
1292596 | 1292596 | 2021-05-06 | Brown | Ohio | 39015 | 3929 | 57 |
1292597 | 1292597 | 2021-05-06 | Butler | Ohio | 39017 | 38273 | 580 |
1292598 | 1292598 | 2021-05-06 | Carroll | Ohio | 39019 | 1912 | 47 |
1292599 | 1292599 | 2021-05-06 | Champaign | Ohio | 39021 | 3304 | 58 |
1292600 | 1292600 | 2021-05-06 | Clark | Ohio | 39023 | 13960 | 297 |
1292601 | 1292601 | 2021-05-06 | Clermont | Ohio | 39025 | 19727 | 238 |
1292602 | 1292602 | 2021-05-06 | Clinton | Ohio | 39027 | 3705 | 61 |
1292603 | 1292603 | 2021-05-06 | Columbiana | Ohio | 39029 | 8756 | 229 |
1292604 | 1292604 | 2021-05-06 | Coshocton | Ohio | 39031 | 2642 | 58 |
1292605 | 1292605 | 2021-05-06 | Crawford | Ohio | 39033 | 3965 | 106 |
1292606 | 1292606 | 2021-05-06 | Cuyahoga | Ohio | 39035 | 111520 | 2107 |
1292607 | 1292607 | 2021-05-06 | Darke | Ohio | 39037 | 5344 | 122 |
1292608 | 1292608 | 2021-05-06 | Defiance | Ohio | 39039 | 4189 | 97 |
1292609 | 1292609 | 2021-05-06 | Delaware | Ohio | 39041 | 18496 | 131 |
1292610 | 1292610 | 2021-05-06 | Erie | Ohio | 39043 | 7859 | 154 |
1292611 | 1292611 | 2021-05-06 | Fairfield | Ohio | 39045 | 16144 | 199 |
1292612 | 1292612 | 2021-05-06 | Fayette | Ohio | 39047 | 2814 | 49 |
1292613 | 1292613 | 2021-05-06 | Franklin | Ohio | 39049 | 125498 | 1392 |
1292614 | 1292614 | 2021-05-06 | Fulton | Ohio | 39051 | 4209 | 69 |
1292615 | 1292615 | 2021-05-06 | Gallia | Ohio | 39053 | 2350 | 48 |
1292616 | 1292616 | 2021-05-06 | Geauga | Ohio | 39055 | 6665 | 148 |
1292617 | 1292617 | 2021-05-06 | Greene | Ohio | 39057 | 15027 | 244 |
1292618 | 1292618 | 2021-05-06 | Guernsey | Ohio | 39059 | 3154 | 53 |
1292619 | 1292619 | 2021-05-06 | Hamilton | Ohio | 39061 | 79817 | 1200 |
1292620 | 1292620 | 2021-05-06 | Hancock | Ohio | 39063 | 6900 | 126 |
1292621 | 1292621 | 2021-05-06 | Hardin | Ohio | 39065 | 2703 | 64 |
1292622 | 1292622 | 2021-05-06 | Harrison | Ohio | 39067 | 1075 | 37 |
1292623 | 1292623 | 2021-05-06 | Henry | Ohio | 39069 | 2681 | 66 |
1292624 | 1292624 | 2021-05-06 | Highland | Ohio | 39071 | 3538 | 61 |
1292625 | 1292625 | 2021-05-06 | Hocking | Ohio | 39073 | 2151 | 62 |
1292626 | 1292626 | 2021-05-06 | Holmes | Ohio | 39075 | 2590 | 101 |
1292627 | 1292627 | 2021-05-06 | Huron | Ohio | 39077 | 5422 | 119 |
1292628 | 1292628 | 2021-05-06 | Jackson | Ohio | 39079 | 3120 | 51 |
1292629 | 1292629 | 2021-05-06 | Jefferson | Ohio | 39081 | 5511 | 151 |
1292630 | 1292630 | 2021-05-06 | Knox | Ohio | 39083 | 4479 | 110 |
1292631 | 1292631 | 2021-05-06 | Lake | Ohio | 39085 | 20586 | 368 |
1292632 | 1292632 | 2021-05-06 | Lawrence | Ohio | 39087 | 5542 | 102 |
1292633 | 1292633 | 2021-05-06 | Licking | Ohio | 39089 | 16396 | 210 |
1292634 | 1292634 | 2021-05-06 | Logan | Ohio | 39091 | 3811 | 76 |
1292635 | 1292635 | 2021-05-06 | Lorain | Ohio | 39093 | 24910 | 480 |
1292636 | 1292636 | 2021-05-06 | Lucas | Ohio | 39095 | 41982 | 782 |
1292637 | 1292637 | 2021-05-06 | Madison | Ohio | 39097 | 4354 | 61 |
1292638 | 1292638 | 2021-05-06 | Mahoning | Ohio | 39099 | 21474 | 586 |
1292639 | 1292639 | 2021-05-06 | Marion | Ohio | 39101 | 8511 | 135 |
1292640 | 1292640 | 2021-05-06 | Medina | Ohio | 39103 | 15233 | 262 |
1292641 | 1292641 | 2021-05-06 | Meigs | Ohio | 39105 | 1446 | 39 |
1292642 | 1292642 | 2021-05-06 | Mercer | Ohio | 39107 | 4801 | 85 |
1292643 | 1292643 | 2021-05-06 | Miami | Ohio | 39109 | 10659 | 215 |
1292644 | 1292644 | 2021-05-06 | Monroe | Ohio | 39111 | 1319 | 42 |
1292645 | 1292645 | 2021-05-06 | Montgomery | Ohio | 39113 | 51271 | 1012 |
1292646 | 1292646 | 2021-05-06 | Morgan | Ohio | 39115 | 1083 | 23 |
1292647 | 1292647 | 2021-05-06 | Morrow | Ohio | 39117 | 2838 | 39 |
1292648 | 1292648 | 2021-05-06 | Muskingum | Ohio | 39119 | 8795 | 132 |
1292649 | 1292649 | 2021-05-06 | Noble | Ohio | 39121 | 1333 | 37 |
1292650 | 1292650 | 2021-05-06 | Ottawa | Ohio | 39123 | 3662 | 79 |
1292651 | 1292651 | 2021-05-06 | Paulding | Ohio | 39125 | 1724 | 40 |
1292652 | 1292652 | 2021-05-06 | Perry | Ohio | 39127 | 2945 | 50 |
1292653 | 1292653 | 2021-05-06 | Pickaway | Ohio | 39129 | 8547 | 121 |
1292654 | 1292654 | 2021-05-06 | Pike | Ohio | 39131 | 2374 | 33 |
1292655 | 1292655 | 2021-05-06 | Portage | Ohio | 39133 | 12806 | 201 |
1292656 | 1292656 | 2021-05-06 | Preble | Ohio | 39135 | 3790 | 98 |
1292657 | 1292657 | 2021-05-06 | Putnam | Ohio | 39137 | 4268 | 100 |
1292658 | 1292658 | 2021-05-06 | Richland | Ohio | 39139 | 11308 | 198 |
1292659 | 1292659 | 2021-05-06 | Ross | Ohio | 39141 | 6835 | 152 |
1292660 | 1292660 | 2021-05-06 | Sandusky | Ohio | 39143 | 5330 | 120 |
1292661 | 1292661 | 2021-05-06 | Scioto | Ohio | 39145 | 6398 | 101 |
1292662 | 1292662 | 2021-05-06 | Seneca | Ohio | 39147 | 5268 | 121 |
1292663 | 1292663 | 2021-05-06 | Shelby | Ohio | 39149 | 4685 | 93 |
1292664 | 1292664 | 2021-05-06 | Stark | Ohio | 39151 | 32190 | 907 |
1292665 | 1292665 | 2021-05-06 | Summit | Ohio | 39153 | 46997 | 933 |
1292666 | 1292666 | 2021-05-06 | Trumbull | Ohio | 39155 | 15996 | 466 |
1292667 | 1292667 | 2021-05-06 | Tuscarawas | Ohio | 39157 | 8467 | 243 |
1292668 | 1292668 | 2021-05-06 | Union | Ohio | 39159 | 5700 | 47 |
1292669 | 1292669 | 2021-05-06 | Unknown | Ohio | 0 | 2 | |
1292670 | 1292670 | 2021-05-06 | Van Wert | Ohio | 39161 | 2428 | 63 |
1292671 | 1292671 | 2021-05-06 | Vinton | Ohio | 39163 | 824 | 15 |
1292672 | 1292672 | 2021-05-06 | Warren | Ohio | 39165 | 24249 | 297 |
1292673 | 1292673 | 2021-05-06 | Washington | Ohio | 39167 | 5148 | 109 |
1292674 | 1292674 | 2021-05-06 | Wayne | Ohio | 39169 | 8777 | 210 |
1292675 | 1292675 | 2021-05-06 | Williams | Ohio | 39171 | 3380 | 75 |
1292676 | 1292676 | 2021-05-06 | Wood | Ohio | 39173 | 13056 | 188 |
1292677 | 1292677 | 2021-05-06 | Wyandot | Ohio | 39175 | 2306 | 54 |
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);