ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69,101 rows where state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 39035 594
- 39151 592
- 39155 591
- 39013 589
- 39017 589
- 39049 589
- 39093 589
- 39153 589
- 39157 589
- 39095 588
- 39103 588
- 39055 587
- 39031 586
- 39037 586
- 39085 586
- 39099 586
- 39005 585
- 39023 585
- 39041 585
- 39077 585
- 39109 585
- 39061 584
- 39113 584
- 39139 584
- 39007 583
- 39029 583
- 39101 583
- 39159 583
- 39165 583
- 39025 582
- …
county >30
- Cuyahoga 594
- Stark 592
- Trumbull 591
- Belmont 589
- Butler 589
- Franklin 589
- Lorain 589
- Summit 589
- Tuscarawas 589
- Lucas 588
- Medina 588
- Geauga 587
- Coshocton 586
- Darke 586
- Lake 586
- Mahoning 586
- Ashland 585
- Clark 585
- Delaware 585
- Huron 585
- Miami 585
- Hamilton 584
- Montgomery 584
- Richland 584
- Ashtabula 583
- Columbiana 583
- Marion 583
- Union 583
- Warren 583
- Clermont 582
- …
state 1
- Ohio · 51,123 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1844669 | 1844669 | 2021-10-23 | Adams | Ohio | 39001 | 4171 | 95 |
1844670 | 1844670 | 2021-10-23 | Allen | Ohio | 39003 | 16001 | 279 |
1844671 | 1844671 | 2021-10-23 | Ashland | Ohio | 39005 | 6967 | 130 |
1844672 | 1844672 | 2021-10-23 | Ashtabula | Ohio | 39007 | 9741 | 204 |
1844673 | 1844673 | 2021-10-23 | Athens | Ohio | 39009 | 7777 | 79 |
1844674 | 1844674 | 2021-10-23 | Auglaize | Ohio | 39011 | 6797 | 99 |
1844675 | 1844675 | 2021-10-23 | Belmont | Ohio | 39013 | 9309 | 209 |
1844676 | 1844676 | 2021-10-23 | Brown | Ohio | 39015 | 6364 | 91 |
1844677 | 1844677 | 2021-10-23 | Butler | Ohio | 39017 | 51580 | 718 |
1844678 | 1844678 | 2021-10-23 | Carroll | Ohio | 39019 | 3023 | 65 |
1844679 | 1844679 | 2021-10-23 | Champaign | Ohio | 39021 | 5131 | 73 |
1844680 | 1844680 | 2021-10-23 | Clark | Ohio | 39023 | 19863 | 354 |
1844681 | 1844681 | 2021-10-23 | Clermont | Ohio | 39025 | 28193 | 330 |
1844682 | 1844682 | 2021-10-23 | Clinton | Ohio | 39027 | 5837 | 93 |
1844683 | 1844683 | 2021-10-23 | Columbiana | Ohio | 39029 | 14080 | 274 |
1844684 | 1844684 | 2021-10-23 | Coshocton | Ohio | 39031 | 4846 | 83 |
1844685 | 1844685 | 2021-10-23 | Crawford | Ohio | 39033 | 6274 | 130 |
1844686 | 1844686 | 2021-10-23 | Cuyahoga | Ohio | 39035 | 146407 | 2459 |
1844687 | 1844687 | 2021-10-23 | Darke | Ohio | 39037 | 7689 | 158 |
1844688 | 1844688 | 2021-10-23 | Defiance | Ohio | 39039 | 6218 | 105 |
1844689 | 1844689 | 2021-10-23 | Delaware | Ohio | 39041 | 24208 | 164 |
1844690 | 1844690 | 2021-10-23 | Erie | Ohio | 39043 | 10904 | 184 |
1844691 | 1844691 | 2021-10-23 | Fairfield | Ohio | 39045 | 22395 | 247 |
1844692 | 1844692 | 2021-10-23 | Fayette | Ohio | 39047 | 4292 | 63 |
1844693 | 1844693 | 2021-10-23 | Franklin | Ohio | 39049 | 164265 | 1696 |
1844694 | 1844694 | 2021-10-23 | Fulton | Ohio | 39051 | 6028 | 96 |
1844695 | 1844695 | 2021-10-23 | Gallia | Ohio | 39053 | 4184 | 67 |
1844696 | 1844696 | 2021-10-23 | Geauga | Ohio | 39055 | 8965 | 158 |
1844697 | 1844697 | 2021-10-23 | Greene | Ohio | 39057 | 22350 | 326 |
1844698 | 1844698 | 2021-10-23 | Guernsey | Ohio | 39059 | 5930 | 71 |
1844699 | 1844699 | 2021-10-23 | Hamilton | Ohio | 39061 | 105366 | 1431 |
1844700 | 1844700 | 2021-10-23 | Hancock | Ohio | 39063 | 9707 | 155 |
1844701 | 1844701 | 2021-10-23 | Hardin | Ohio | 39065 | 4194 | 80 |
1844702 | 1844702 | 2021-10-23 | Harrison | Ohio | 39067 | 1821 | 46 |
1844703 | 1844703 | 2021-10-23 | Henry | Ohio | 39069 | 3653 | 72 |
1844704 | 1844704 | 2021-10-23 | Highland | Ohio | 39071 | 6004 | 99 |
1844705 | 1844705 | 2021-10-23 | Hocking | Ohio | 39073 | 3567 | 82 |
1844706 | 1844706 | 2021-10-23 | Holmes | Ohio | 39075 | 3642 | 125 |
1844707 | 1844707 | 2021-10-23 | Huron | Ohio | 39077 | 8404 | 143 |
1844708 | 1844708 | 2021-10-23 | Jackson | Ohio | 39079 | 5102 | 73 |
1844709 | 1844709 | 2021-10-23 | Jefferson | Ohio | 39081 | 8567 | 199 |
1844710 | 1844710 | 2021-10-23 | Knox | Ohio | 39083 | 7739 | 144 |
1844711 | 1844711 | 2021-10-23 | Lake | Ohio | 39085 | 27063 | 448 |
1844712 | 1844712 | 2021-10-23 | Lawrence | Ohio | 39087 | 9759 | 153 |
1844713 | 1844713 | 2021-10-23 | Licking | Ohio | 39089 | 23939 | 294 |
1844714 | 1844714 | 2021-10-23 | Logan | Ohio | 39091 | 5910 | 96 |
1844715 | 1844715 | 2021-10-23 | Lorain | Ohio | 39093 | 35628 | 585 |
1844716 | 1844716 | 2021-10-23 | Lucas | Ohio | 39095 | 56338 | 917 |
1844717 | 1844717 | 2021-10-23 | Madison | Ohio | 39097 | 5945 | 78 |
1844718 | 1844718 | 2021-10-23 | Mahoning | Ohio | 39099 | 30787 | 693 |
1844719 | 1844719 | 2021-10-23 | Marion | Ohio | 39101 | 11976 | 180 |
1844720 | 1844720 | 2021-10-23 | Medina | Ohio | 39103 | 22047 | 313 |
1844721 | 1844721 | 2021-10-23 | Meigs | Ohio | 39105 | 2658 | 51 |
1844722 | 1844722 | 2021-10-23 | Mercer | Ohio | 39107 | 6164 | 93 |
1844723 | 1844723 | 2021-10-23 | Miami | Ohio | 39109 | 15582 | 306 |
1844724 | 1844724 | 2021-10-23 | Monroe | Ohio | 39111 | 2162 | 54 |
1844725 | 1844725 | 2021-10-23 | Montgomery | Ohio | 39113 | 74066 | 1279 |
1844726 | 1844726 | 2021-10-23 | Morgan | Ohio | 39115 | 1940 | 33 |
1844727 | 1844727 | 2021-10-23 | Morrow | Ohio | 39117 | 4588 | 58 |
1844728 | 1844728 | 2021-10-23 | Muskingum | Ohio | 39119 | 14831 | 185 |
1844729 | 1844729 | 2021-10-23 | Noble | Ohio | 39121 | 2003 | 47 |
1844730 | 1844730 | 2021-10-23 | Ottawa | Ohio | 39123 | 4885 | 86 |
1844731 | 1844731 | 2021-10-23 | Paulding | Ohio | 39125 | 2803 | 47 |
1844732 | 1844732 | 2021-10-23 | Perry | Ohio | 39127 | 5183 | 63 |
1844733 | 1844733 | 2021-10-23 | Pickaway | Ohio | 39129 | 11373 | 142 |
1844734 | 1844734 | 2021-10-23 | Pike | Ohio | 39131 | 4343 | 67 |
1844735 | 1844735 | 2021-10-23 | Portage | Ohio | 39133 | 17978 | 252 |
1844736 | 1844736 | 2021-10-23 | Preble | Ohio | 39135 | 5720 | 125 |
1844737 | 1844737 | 2021-10-23 | Putnam | Ohio | 39137 | 5335 | 110 |
1844738 | 1844738 | 2021-10-23 | Richland | Ohio | 39139 | 18586 | 292 |
1844739 | 1844739 | 2021-10-23 | Ross | Ohio | 39141 | 10586 | 203 |
1844740 | 1844740 | 2021-10-23 | Sandusky | Ohio | 39143 | 7827 | 151 |
1844741 | 1844741 | 2021-10-23 | Scioto | Ohio | 39145 | 11469 | 162 |
1844742 | 1844742 | 2021-10-23 | Seneca | Ohio | 39147 | 7372 | 145 |
1844743 | 1844743 | 2021-10-23 | Shelby | Ohio | 39149 | 6530 | 115 |
1844744 | 1844744 | 2021-10-23 | Stark | Ohio | 39151 | 46681 | 1064 |
1844745 | 1844745 | 2021-10-23 | Summit | Ohio | 39153 | 61784 | 1111 |
1844746 | 1844746 | 2021-10-23 | Trumbull | Ohio | 39155 | 22885 | 561 |
1844747 | 1844747 | 2021-10-23 | Tuscarawas | Ohio | 39157 | 12724 | 311 |
1844748 | 1844748 | 2021-10-23 | Union | Ohio | 39159 | 8198 | 59 |
1844749 | 1844749 | 2021-10-23 | Unknown | Ohio | 0 | 4 | |
1844750 | 1844750 | 2021-10-23 | Van Wert | Ohio | 39161 | 3723 | 82 |
1844751 | 1844751 | 2021-10-23 | Vinton | Ohio | 39163 | 1666 | 25 |
1844752 | 1844752 | 2021-10-23 | Warren | Ohio | 39165 | 32836 | 377 |
1844753 | 1844753 | 2021-10-23 | Washington | Ohio | 39167 | 8093 | 144 |
1844754 | 1844754 | 2021-10-23 | Wayne | Ohio | 39169 | 13791 | 271 |
1844755 | 1844755 | 2021-10-23 | Williams | Ohio | 39171 | 5292 | 88 |
1844756 | 1844756 | 2021-10-23 | Wood | Ohio | 39173 | 17454 | 224 |
1844757 | 1844757 | 2021-10-23 | Wyandot | Ohio | 39175 | 3246 | 62 |
1841419 | 1841419 | 2021-10-22 | Adams | Ohio | 39001 | 4166 | 95 |
1841420 | 1841420 | 2021-10-22 | Allen | Ohio | 39003 | 15967 | 279 |
1841421 | 1841421 | 2021-10-22 | Ashland | Ohio | 39005 | 6945 | 130 |
1841422 | 1841422 | 2021-10-22 | Ashtabula | Ohio | 39007 | 9701 | 204 |
1841423 | 1841423 | 2021-10-22 | Athens | Ohio | 39009 | 7761 | 79 |
1841424 | 1841424 | 2021-10-22 | Auglaize | Ohio | 39011 | 6786 | 99 |
1841425 | 1841425 | 2021-10-22 | Belmont | Ohio | 39013 | 9287 | 209 |
1841426 | 1841426 | 2021-10-22 | Brown | Ohio | 39015 | 6352 | 91 |
1841427 | 1841427 | 2021-10-22 | Butler | Ohio | 39017 | 51500 | 718 |
1841428 | 1841428 | 2021-10-22 | Carroll | Ohio | 39019 | 3017 | 65 |
1841429 | 1841429 | 2021-10-22 | Champaign | Ohio | 39021 | 5115 | 73 |
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);