ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where date = "2021-06-20" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
1438666 | 1438666 | 2021-06-20 | Adams | Ohio | 39001 | 2432 | 56 |
1438667 | 1438667 | 2021-06-20 | Allen | Ohio | 39003 | 11914 | 239 |
1438668 | 1438668 | 2021-06-20 | Ashland | Ohio | 39005 | 4357 | 97 |
1438669 | 1438669 | 2021-06-20 | Ashtabula | Ohio | 39007 | 7161 | 179 |
1438670 | 1438670 | 2021-06-20 | Athens | Ohio | 39009 | 5239 | 60 |
1438671 | 1438671 | 2021-06-20 | Auglaize | Ohio | 39011 | 5021 | 87 |
1438672 | 1438672 | 2021-06-20 | Belmont | Ohio | 39013 | 6157 | 174 |
1438673 | 1438673 | 2021-06-20 | Brown | Ohio | 39015 | 4024 | 61 |
1438674 | 1438674 | 2021-06-20 | Butler | Ohio | 39017 | 39018 | 606 |
1438675 | 1438675 | 2021-06-20 | Carroll | Ohio | 39019 | 1973 | 48 |
1438676 | 1438676 | 2021-06-20 | Champaign | Ohio | 39021 | 3448 | 59 |
1438677 | 1438677 | 2021-06-20 | Clark | Ohio | 39023 | 14237 | 306 |
1438678 | 1438678 | 2021-06-20 | Clermont | Ohio | 39025 | 20124 | 253 |
1438679 | 1438679 | 2021-06-20 | Clinton | Ohio | 39027 | 3791 | 66 |
1438680 | 1438680 | 2021-06-20 | Columbiana | Ohio | 39029 | 9034 | 230 |
1438681 | 1438681 | 2021-06-20 | Coshocton | Ohio | 39031 | 2690 | 60 |
1438682 | 1438682 | 2021-06-20 | Crawford | Ohio | 39033 | 4040 | 110 |
1438683 | 1438683 | 2021-06-20 | Cuyahoga | Ohio | 39035 | 115808 | 2211 |
1438684 | 1438684 | 2021-06-20 | Darke | Ohio | 39037 | 5420 | 129 |
1438685 | 1438685 | 2021-06-20 | Defiance | Ohio | 39039 | 4323 | 99 |
1438686 | 1438686 | 2021-06-20 | Delaware | Ohio | 39041 | 18856 | 136 |
1438687 | 1438687 | 2021-06-20 | Erie | Ohio | 39043 | 8056 | 165 |
1438688 | 1438688 | 2021-06-20 | Fairfield | Ohio | 39045 | 16576 | 204 |
1438689 | 1438689 | 2021-06-20 | Fayette | Ohio | 39047 | 2854 | 50 |
1438690 | 1438690 | 2021-06-20 | Franklin | Ohio | 39049 | 128749 | 1467 |
1438691 | 1438691 | 2021-06-20 | Fulton | Ohio | 39051 | 4321 | 74 |
1438692 | 1438692 | 2021-06-20 | Gallia | Ohio | 39053 | 2407 | 50 |
1438693 | 1438693 | 2021-06-20 | Geauga | Ohio | 39055 | 6838 | 151 |
1438694 | 1438694 | 2021-06-20 | Greene | Ohio | 39057 | 15284 | 248 |
1438695 | 1438695 | 2021-06-20 | Guernsey | Ohio | 39059 | 3249 | 53 |
1438696 | 1438696 | 2021-06-20 | Hamilton | Ohio | 39061 | 81409 | 1250 |
1438697 | 1438697 | 2021-06-20 | Hancock | Ohio | 39063 | 6999 | 132 |
1438698 | 1438698 | 2021-06-20 | Hardin | Ohio | 39065 | 2753 | 65 |
1438699 | 1438699 | 2021-06-20 | Harrison | Ohio | 39067 | 1141 | 38 |
1438700 | 1438700 | 2021-06-20 | Henry | Ohio | 39069 | 2734 | 67 |
1438701 | 1438701 | 2021-06-20 | Highland | Ohio | 39071 | 3598 | 65 |
1438702 | 1438702 | 2021-06-20 | Hocking | Ohio | 39073 | 2205 | 63 |
1438703 | 1438703 | 2021-06-20 | Holmes | Ohio | 39075 | 2702 | 101 |
1438704 | 1438704 | 2021-06-20 | Huron | Ohio | 39077 | 5546 | 122 |
1438705 | 1438705 | 2021-06-20 | Jackson | Ohio | 39079 | 3182 | 54 |
1438706 | 1438706 | 2021-06-20 | Jefferson | Ohio | 39081 | 5679 | 158 |
1438707 | 1438707 | 2021-06-20 | Knox | Ohio | 39083 | 4572 | 112 |
1438708 | 1438708 | 2021-06-20 | Lake | Ohio | 39085 | 21211 | 388 |
1438709 | 1438709 | 2021-06-20 | Lawrence | Ohio | 39087 | 5732 | 102 |
1438710 | 1438710 | 2021-06-20 | Licking | Ohio | 39089 | 16663 | 222 |
1438711 | 1438711 | 2021-06-20 | Logan | Ohio | 39091 | 3876 | 77 |
1438712 | 1438712 | 2021-06-20 | Lorain | Ohio | 39093 | 25675 | 505 |
1438713 | 1438713 | 2021-06-20 | Lucas | Ohio | 39095 | 43359 | 820 |
1438714 | 1438714 | 2021-06-20 | Madison | Ohio | 39097 | 4443 | 66 |
1438715 | 1438715 | 2021-06-20 | Mahoning | Ohio | 39099 | 22376 | 603 |
1438716 | 1438716 | 2021-06-20 | Marion | Ohio | 39101 | 8642 | 138 |
1438717 | 1438717 | 2021-06-20 | Medina | Ohio | 39103 | 15612 | 271 |
1438718 | 1438718 | 2021-06-20 | Meigs | Ohio | 39105 | 1484 | 40 |
1438719 | 1438719 | 2021-06-20 | Mercer | Ohio | 39107 | 4873 | 85 |
1438720 | 1438720 | 2021-06-20 | Miami | Ohio | 39109 | 10849 | 225 |
1438721 | 1438721 | 2021-06-20 | Monroe | Ohio | 39111 | 1363 | 44 |
1438722 | 1438722 | 2021-06-20 | Montgomery | Ohio | 39113 | 52557 | 1043 |
1438723 | 1438723 | 2021-06-20 | Morgan | Ohio | 39115 | 1096 | 24 |
1438724 | 1438724 | 2021-06-20 | Morrow | Ohio | 39117 | 2918 | 40 |
1438725 | 1438725 | 2021-06-20 | Muskingum | Ohio | 39119 | 8906 | 135 |
1438726 | 1438726 | 2021-06-20 | Noble | Ohio | 39121 | 1362 | 39 |
1438727 | 1438727 | 2021-06-20 | Ottawa | Ohio | 39123 | 3736 | 81 |
1438728 | 1438728 | 2021-06-20 | Paulding | Ohio | 39125 | 1765 | 42 |
1438729 | 1438729 | 2021-06-20 | Perry | Ohio | 39127 | 2973 | 50 |
1438730 | 1438730 | 2021-06-20 | Pickaway | Ohio | 39129 | 8664 | 122 |
1438731 | 1438731 | 2021-06-20 | Pike | Ohio | 39131 | 2428 | 35 |
1438732 | 1438732 | 2021-06-20 | Portage | Ohio | 39133 | 13251 | 215 |
1438733 | 1438733 | 2021-06-20 | Preble | Ohio | 39135 | 3856 | 105 |
1438734 | 1438734 | 2021-06-20 | Putnam | Ohio | 39137 | 4336 | 103 |
1438735 | 1438735 | 2021-06-20 | Richland | Ohio | 39139 | 11607 | 211 |
1438736 | 1438736 | 2021-06-20 | Ross | Ohio | 39141 | 6945 | 161 |
1438737 | 1438737 | 2021-06-20 | Sandusky | Ohio | 39143 | 5442 | 126 |
1438738 | 1438738 | 2021-06-20 | Scioto | Ohio | 39145 | 6534 | 106 |
1438739 | 1438739 | 2021-06-20 | Seneca | Ohio | 39147 | 5350 | 128 |
1438740 | 1438740 | 2021-06-20 | Shelby | Ohio | 39149 | 4768 | 95 |
1438741 | 1438741 | 2021-06-20 | Stark | Ohio | 39151 | 33338 | 929 |
1438742 | 1438742 | 2021-06-20 | Summit | Ohio | 39153 | 48435 | 1001 |
1438743 | 1438743 | 2021-06-20 | Trumbull | Ohio | 39155 | 16551 | 482 |
1438744 | 1438744 | 2021-06-20 | Tuscarawas | Ohio | 39157 | 8650 | 250 |
1438745 | 1438745 | 2021-06-20 | Union | Ohio | 39159 | 5846 | 49 |
1438746 | 1438746 | 2021-06-20 | Unknown | Ohio | 0 | 3 | |
1438747 | 1438747 | 2021-06-20 | Van Wert | Ohio | 39161 | 2472 | 64 |
1438748 | 1438748 | 2021-06-20 | Vinton | Ohio | 39163 | 857 | 17 |
1438749 | 1438749 | 2021-06-20 | Warren | Ohio | 39165 | 24595 | 303 |
1438750 | 1438750 | 2021-06-20 | Washington | Ohio | 39167 | 5320 | 109 |
1438751 | 1438751 | 2021-06-20 | Wayne | Ohio | 39169 | 9146 | 223 |
1438752 | 1438752 | 2021-06-20 | Williams | Ohio | 39171 | 3482 | 78 |
1438753 | 1438753 | 2021-06-20 | Wood | Ohio | 39173 | 13292 | 200 |
1438754 | 1438754 | 2021-06-20 | Wyandot | Ohio | 39175 | 2345 | 56 |
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);