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 486
- 39151 484
- 39155 483
- 39013 481
- 39017 481
- 39049 481
- 39093 481
- 39153 481
- 39157 481
- 39095 480
- 39103 480
- 39055 479
- 39031 478
- 39037 478
- 39085 478
- 39099 478
- 39005 477
- 39023 477
- 39041 477
- 39077 477
- 39109 477
- 39061 476
- 39113 476
- 39139 476
- 39007 475
- 39029 475
- 39101 475
- 39159 475
- 39165 475
- 39025 474
- …
county >30
- Cuyahoga 486
- Stark 484
- Trumbull 483
- Belmont 481
- Butler 481
- Franklin 481
- Lorain 481
- Summit 481
- Tuscarawas 481
- Lucas 480
- Medina 480
- Geauga 479
- Coshocton 478
- Darke 478
- Lake 478
- Mahoning 478
- Ashland 477
- Clark 477
- Delaware 477
- Huron 477
- Miami 477
- Hamilton 476
- Montgomery 476
- Richland 476
- Ashtabula 475
- Columbiana 475
- Marion 475
- Union 475
- Warren 475
- Clermont 474
- …
state 1
- Ohio · 41,511 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1493843 | 1493843 | 2021-07-07 | Adams | Ohio | 39001 | 2441 | 56 |
1493844 | 1493844 | 2021-07-07 | Allen | Ohio | 39003 | 11954 | 245 |
1493845 | 1493845 | 2021-07-07 | Ashland | Ohio | 39005 | 4370 | 98 |
1493846 | 1493846 | 2021-07-07 | Ashtabula | Ohio | 39007 | 7220 | 179 |
1493847 | 1493847 | 2021-07-07 | Athens | Ohio | 39009 | 5250 | 60 |
1493848 | 1493848 | 2021-07-07 | Auglaize | Ohio | 39011 | 5045 | 87 |
1493849 | 1493849 | 2021-07-07 | Belmont | Ohio | 39013 | 6180 | 177 |
1493850 | 1493850 | 2021-07-07 | Brown | Ohio | 39015 | 4035 | 61 |
1493851 | 1493851 | 2021-07-07 | Butler | Ohio | 39017 | 39547 | 611 |
1493852 | 1493852 | 2021-07-07 | Carroll | Ohio | 39019 | 1981 | 48 |
1493853 | 1493853 | 2021-07-07 | Champaign | Ohio | 39021 | 3456 | 60 |
1493854 | 1493854 | 2021-07-07 | Clark | Ohio | 39023 | 14268 | 306 |
1493855 | 1493855 | 2021-07-07 | Clermont | Ohio | 39025 | 20202 | 257 |
1493856 | 1493856 | 2021-07-07 | Clinton | Ohio | 39027 | 3827 | 66 |
1493857 | 1493857 | 2021-07-07 | Columbiana | Ohio | 39029 | 9057 | 235 |
1493858 | 1493858 | 2021-07-07 | Coshocton | Ohio | 39031 | 2705 | 60 |
1493859 | 1493859 | 2021-07-07 | Crawford | Ohio | 39033 | 4064 | 111 |
1493860 | 1493860 | 2021-07-07 | Cuyahoga | Ohio | 39035 | 116189 | 2240 |
1493861 | 1493861 | 2021-07-07 | Darke | Ohio | 39037 | 5430 | 129 |
1493862 | 1493862 | 2021-07-07 | Defiance | Ohio | 39039 | 4327 | 99 |
1493863 | 1493863 | 2021-07-07 | Delaware | Ohio | 39041 | 18943 | 137 |
1493864 | 1493864 | 2021-07-07 | Erie | Ohio | 39043 | 8070 | 166 |
1493865 | 1493865 | 2021-07-07 | Fairfield | Ohio | 39045 | 16614 | 206 |
1493866 | 1493866 | 2021-07-07 | Fayette | Ohio | 39047 | 2864 | 50 |
1493867 | 1493867 | 2021-07-07 | Franklin | Ohio | 39049 | 129322 | 1487 |
1493868 | 1493868 | 2021-07-07 | Fulton | Ohio | 39051 | 4330 | 75 |
1493869 | 1493869 | 2021-07-07 | Gallia | Ohio | 39053 | 2415 | 50 |
1493870 | 1493870 | 2021-07-07 | Geauga | Ohio | 39055 | 6877 | 153 |
1493871 | 1493871 | 2021-07-07 | Greene | Ohio | 39057 | 15330 | 250 |
1493872 | 1493872 | 2021-07-07 | Guernsey | Ohio | 39059 | 3269 | 54 |
1493873 | 1493873 | 2021-07-07 | Hamilton | Ohio | 39061 | 81604 | 1254 |
1493874 | 1493874 | 2021-07-07 | Hancock | Ohio | 39063 | 7012 | 134 |
1493875 | 1493875 | 2021-07-07 | Hardin | Ohio | 39065 | 2773 | 65 |
1493876 | 1493876 | 2021-07-07 | Harrison | Ohio | 39067 | 1144 | 38 |
1493877 | 1493877 | 2021-07-07 | Henry | Ohio | 39069 | 2749 | 67 |
1493878 | 1493878 | 2021-07-07 | Highland | Ohio | 39071 | 3611 | 67 |
1493879 | 1493879 | 2021-07-07 | Hocking | Ohio | 39073 | 2207 | 63 |
1493880 | 1493880 | 2021-07-07 | Holmes | Ohio | 39075 | 2716 | 102 |
1493881 | 1493881 | 2021-07-07 | Huron | Ohio | 39077 | 5577 | 122 |
1493882 | 1493882 | 2021-07-07 | Jackson | Ohio | 39079 | 3194 | 54 |
1493883 | 1493883 | 2021-07-07 | Jefferson | Ohio | 39081 | 5693 | 160 |
1493884 | 1493884 | 2021-07-07 | Knox | Ohio | 39083 | 4582 | 112 |
1493885 | 1493885 | 2021-07-07 | Lake | Ohio | 39085 | 21267 | 391 |
1493886 | 1493886 | 2021-07-07 | Lawrence | Ohio | 39087 | 5768 | 103 |
1493887 | 1493887 | 2021-07-07 | Licking | Ohio | 39089 | 16708 | 225 |
1493888 | 1493888 | 2021-07-07 | Logan | Ohio | 39091 | 3892 | 79 |
1493889 | 1493889 | 2021-07-07 | Lorain | Ohio | 39093 | 25751 | 507 |
1493890 | 1493890 | 2021-07-07 | Lucas | Ohio | 39095 | 43467 | 829 |
1493891 | 1493891 | 2021-07-07 | Madison | Ohio | 39097 | 4452 | 66 |
1493892 | 1493892 | 2021-07-07 | Mahoning | Ohio | 39099 | 22447 | 611 |
1493893 | 1493893 | 2021-07-07 | Marion | Ohio | 39101 | 8657 | 140 |
1493894 | 1493894 | 2021-07-07 | Medina | Ohio | 39103 | 15670 | 275 |
1493895 | 1493895 | 2021-07-07 | Meigs | Ohio | 39105 | 1492 | 40 |
1493896 | 1493896 | 2021-07-07 | Mercer | Ohio | 39107 | 4883 | 85 |
1493897 | 1493897 | 2021-07-07 | Miami | Ohio | 39109 | 10882 | 226 |
1493898 | 1493898 | 2021-07-07 | Monroe | Ohio | 39111 | 1367 | 45 |
1493899 | 1493899 | 2021-07-07 | Montgomery | Ohio | 39113 | 52713 | 1056 |
1493900 | 1493900 | 2021-07-07 | Morgan | Ohio | 39115 | 1102 | 24 |
1493901 | 1493901 | 2021-07-07 | Morrow | Ohio | 39117 | 2927 | 42 |
1493902 | 1493902 | 2021-07-07 | Muskingum | Ohio | 39119 | 8986 | 137 |
1493903 | 1493903 | 2021-07-07 | Noble | Ohio | 39121 | 1365 | 39 |
1493904 | 1493904 | 2021-07-07 | Ottawa | Ohio | 39123 | 3739 | 81 |
1493905 | 1493905 | 2021-07-07 | Paulding | Ohio | 39125 | 1776 | 42 |
1493906 | 1493906 | 2021-07-07 | Perry | Ohio | 39127 | 2974 | 50 |
1493907 | 1493907 | 2021-07-07 | Pickaway | Ohio | 39129 | 8684 | 122 |
1493908 | 1493908 | 2021-07-07 | Pike | Ohio | 39131 | 2430 | 37 |
1493909 | 1493909 | 2021-07-07 | Portage | Ohio | 39133 | 13277 | 216 |
1493910 | 1493910 | 2021-07-07 | Preble | Ohio | 39135 | 3886 | 106 |
1493911 | 1493911 | 2021-07-07 | Putnam | Ohio | 39137 | 4337 | 104 |
1493912 | 1493912 | 2021-07-07 | Richland | Ohio | 39139 | 11633 | 212 |
1493913 | 1493913 | 2021-07-07 | Ross | Ohio | 39141 | 6966 | 164 |
1493914 | 1493914 | 2021-07-07 | Sandusky | Ohio | 39143 | 5454 | 129 |
1493915 | 1493915 | 2021-07-07 | Scioto | Ohio | 39145 | 6573 | 108 |
1493916 | 1493916 | 2021-07-07 | Seneca | Ohio | 39147 | 5354 | 128 |
1493917 | 1493917 | 2021-07-07 | Shelby | Ohio | 39149 | 4786 | 97 |
1493918 | 1493918 | 2021-07-07 | Stark | Ohio | 39151 | 33484 | 936 |
1493919 | 1493919 | 2021-07-07 | Summit | Ohio | 39153 | 48559 | 1011 |
1493920 | 1493920 | 2021-07-07 | Trumbull | Ohio | 39155 | 16613 | 486 |
1493921 | 1493921 | 2021-07-07 | Tuscarawas | Ohio | 39157 | 8676 | 254 |
1493922 | 1493922 | 2021-07-07 | Union | Ohio | 39159 | 5862 | 49 |
1493923 | 1493923 | 2021-07-07 | Unknown | Ohio | 0 | 3 | |
1493924 | 1493924 | 2021-07-07 | Van Wert | Ohio | 39161 | 2482 | 65 |
1493925 | 1493925 | 2021-07-07 | Vinton | Ohio | 39163 | 865 | 17 |
1493926 | 1493926 | 2021-07-07 | Warren | Ohio | 39165 | 24672 | 307 |
1493927 | 1493927 | 2021-07-07 | Washington | Ohio | 39167 | 5331 | 110 |
1493928 | 1493928 | 2021-07-07 | Wayne | Ohio | 39169 | 9185 | 226 |
1493929 | 1493929 | 2021-07-07 | Williams | Ohio | 39171 | 3514 | 78 |
1493930 | 1493930 | 2021-07-07 | Wood | Ohio | 39173 | 13304 | 200 |
1493931 | 1493931 | 2021-07-07 | Wyandot | Ohio | 39175 | 2350 | 57 |
1490596 | 1490596 | 2021-07-06 | Adams | Ohio | 39001 | 2441 | 56 |
1490597 | 1490597 | 2021-07-06 | Allen | Ohio | 39003 | 11951 | 244 |
1490598 | 1490598 | 2021-07-06 | Ashland | Ohio | 39005 | 4370 | 98 |
1490599 | 1490599 | 2021-07-06 | Ashtabula | Ohio | 39007 | 7219 | 179 |
1490600 | 1490600 | 2021-07-06 | Athens | Ohio | 39009 | 5251 | 60 |
1490601 | 1490601 | 2021-07-06 | Auglaize | Ohio | 39011 | 5045 | 87 |
1490602 | 1490602 | 2021-07-06 | Belmont | Ohio | 39013 | 6175 | 177 |
1490603 | 1490603 | 2021-07-06 | Brown | Ohio | 39015 | 4033 | 61 |
1490604 | 1490604 | 2021-07-06 | Butler | Ohio | 39017 | 39538 | 610 |
1490605 | 1490605 | 2021-07-06 | Carroll | Ohio | 39019 | 1981 | 48 |
1490606 | 1490606 | 2021-07-06 | Champaign | Ohio | 39021 | 3456 | 60 |
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);