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-19 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 |
---|---|---|---|---|---|---|---|
1334794 | 1334794 | 2021-05-19 | Adams | Ohio | 39001 | 2402 | 54 |
1334795 | 1334795 | 2021-05-19 | Allen | Ohio | 39003 | 11759 | 233 |
1334796 | 1334796 | 2021-05-19 | Ashland | Ohio | 39005 | 4276 | 90 |
1334797 | 1334797 | 2021-05-19 | Ashtabula | Ohio | 39007 | 6929 | 172 |
1334798 | 1334798 | 2021-05-19 | Athens | Ohio | 39009 | 5208 | 59 |
1334799 | 1334799 | 2021-05-19 | Auglaize | Ohio | 39011 | 4956 | 86 |
1334800 | 1334800 | 2021-05-19 | Belmont | Ohio | 39013 | 6016 | 171 |
1334801 | 1334801 | 2021-05-19 | Brown | Ohio | 39015 | 3978 | 57 |
1334802 | 1334802 | 2021-05-19 | Butler | Ohio | 39017 | 38586 | 588 |
1334803 | 1334803 | 2021-05-19 | Carroll | Ohio | 39019 | 1928 | 48 |
1334804 | 1334804 | 2021-05-19 | Champaign | Ohio | 39021 | 3366 | 58 |
1334805 | 1334805 | 2021-05-19 | Clark | Ohio | 39023 | 14115 | 301 |
1334806 | 1334806 | 2021-05-19 | Clermont | Ohio | 39025 | 19898 | 246 |
1334807 | 1334807 | 2021-05-19 | Clinton | Ohio | 39027 | 3750 | 64 |
1334808 | 1334808 | 2021-05-19 | Columbiana | Ohio | 39029 | 8893 | 229 |
1334809 | 1334809 | 2021-05-19 | Coshocton | Ohio | 39031 | 2667 | 57 |
1334810 | 1334810 | 2021-05-19 | Crawford | Ohio | 39033 | 3997 | 109 |
1334811 | 1334811 | 2021-05-19 | Cuyahoga | Ohio | 39035 | 113585 | 2139 |
1334812 | 1334812 | 2021-05-19 | Darke | Ohio | 39037 | 5376 | 126 |
1334813 | 1334813 | 2021-05-19 | Defiance | Ohio | 39039 | 4255 | 97 |
1334814 | 1334814 | 2021-05-19 | Delaware | Ohio | 39041 | 18627 | 133 |
1334815 | 1334815 | 2021-05-19 | Erie | Ohio | 39043 | 7973 | 157 |
1334816 | 1334816 | 2021-05-19 | Fairfield | Ohio | 39045 | 16346 | 201 |
1334817 | 1334817 | 2021-05-19 | Fayette | Ohio | 39047 | 2835 | 50 |
1334818 | 1334818 | 2021-05-19 | Franklin | Ohio | 39049 | 126988 | 1415 |
1334819 | 1334819 | 2021-05-19 | Fulton | Ohio | 39051 | 4275 | 70 |
1334820 | 1334820 | 2021-05-19 | Gallia | Ohio | 39053 | 2374 | 49 |
1334821 | 1334821 | 2021-05-19 | Geauga | Ohio | 39055 | 6754 | 149 |
1334822 | 1334822 | 2021-05-19 | Greene | Ohio | 39057 | 15153 | 246 |
1334823 | 1334823 | 2021-05-19 | Guernsey | Ohio | 39059 | 3187 | 53 |
1334824 | 1334824 | 2021-05-19 | Hamilton | Ohio | 39061 | 80521 | 1218 |
1334825 | 1334825 | 2021-05-19 | Hancock | Ohio | 39063 | 6965 | 130 |
1334826 | 1334826 | 2021-05-19 | Hardin | Ohio | 39065 | 2724 | 64 |
1334827 | 1334827 | 2021-05-19 | Harrison | Ohio | 39067 | 1104 | 37 |
1334828 | 1334828 | 2021-05-19 | Henry | Ohio | 39069 | 2708 | 67 |
1334829 | 1334829 | 2021-05-19 | Highland | Ohio | 39071 | 3567 | 62 |
1334830 | 1334830 | 2021-05-19 | Hocking | Ohio | 39073 | 2169 | 62 |
1334831 | 1334831 | 2021-05-19 | Holmes | Ohio | 39075 | 2628 | 101 |
1334832 | 1334832 | 2021-05-19 | Huron | Ohio | 39077 | 5473 | 120 |
1334833 | 1334833 | 2021-05-19 | Jackson | Ohio | 39079 | 3146 | 52 |
1334834 | 1334834 | 2021-05-19 | Jefferson | Ohio | 39081 | 5596 | 153 |
1334835 | 1334835 | 2021-05-19 | Knox | Ohio | 39083 | 4517 | 110 |
1334836 | 1334836 | 2021-05-19 | Lake | Ohio | 39085 | 20874 | 372 |
1334837 | 1334837 | 2021-05-19 | Lawrence | Ohio | 39087 | 5603 | 103 |
1334838 | 1334838 | 2021-05-19 | Licking | Ohio | 39089 | 16506 | 214 |
1334839 | 1334839 | 2021-05-19 | Logan | Ohio | 39091 | 3838 | 76 |
1334840 | 1334840 | 2021-05-19 | Lorain | Ohio | 39093 | 25247 | 489 |
1334841 | 1334841 | 2021-05-19 | Lucas | Ohio | 39095 | 42721 | 793 |
1334842 | 1334842 | 2021-05-19 | Madison | Ohio | 39097 | 4402 | 63 |
1334843 | 1334843 | 2021-05-19 | Mahoning | Ohio | 39099 | 21862 | 589 |
1334844 | 1334844 | 2021-05-19 | Marion | Ohio | 39101 | 8567 | 136 |
1334845 | 1334845 | 2021-05-19 | Medina | Ohio | 39103 | 15407 | 267 |
1334846 | 1334846 | 2021-05-19 | Meigs | Ohio | 39105 | 1458 | 40 |
1334847 | 1334847 | 2021-05-19 | Mercer | Ohio | 39107 | 4824 | 85 |
1334848 | 1334848 | 2021-05-19 | Miami | Ohio | 39109 | 10723 | 221 |
1334849 | 1334849 | 2021-05-19 | Monroe | Ohio | 39111 | 1329 | 42 |
1334850 | 1334850 | 2021-05-19 | Montgomery | Ohio | 39113 | 51884 | 1019 |
1334851 | 1334851 | 2021-05-19 | Morgan | Ohio | 39115 | 1088 | 23 |
1334852 | 1334852 | 2021-05-19 | Morrow | Ohio | 39117 | 2879 | 39 |
1334853 | 1334853 | 2021-05-19 | Muskingum | Ohio | 39119 | 8840 | 133 |
1334854 | 1334854 | 2021-05-19 | Noble | Ohio | 39121 | 1341 | 37 |
1334855 | 1334855 | 2021-05-19 | Ottawa | Ohio | 39123 | 3698 | 81 |
1334856 | 1334856 | 2021-05-19 | Paulding | Ohio | 39125 | 1746 | 41 |
1334857 | 1334857 | 2021-05-19 | Perry | Ohio | 39127 | 2959 | 50 |
1334858 | 1334858 | 2021-05-19 | Pickaway | Ohio | 39129 | 8606 | 121 |
1334859 | 1334859 | 2021-05-19 | Pike | Ohio | 39131 | 2395 | 34 |
1334860 | 1334860 | 2021-05-19 | Portage | Ohio | 39133 | 12994 | 210 |
1334861 | 1334861 | 2021-05-19 | Preble | Ohio | 39135 | 3813 | 99 |
1334862 | 1334862 | 2021-05-19 | Putnam | Ohio | 39137 | 4308 | 101 |
1334863 | 1334863 | 2021-05-19 | Richland | Ohio | 39139 | 11455 | 203 |
1334864 | 1334864 | 2021-05-19 | Ross | Ohio | 39141 | 6883 | 157 |
1334865 | 1334865 | 2021-05-19 | Sandusky | Ohio | 39143 | 5382 | 123 |
1334866 | 1334866 | 2021-05-19 | Scioto | Ohio | 39145 | 6457 | 103 |
1334867 | 1334867 | 2021-05-19 | Seneca | Ohio | 39147 | 5318 | 123 |
1334868 | 1334868 | 2021-05-19 | Shelby | Ohio | 39149 | 4709 | 93 |
1334869 | 1334869 | 2021-05-19 | Stark | Ohio | 39151 | 32776 | 911 |
1334870 | 1334870 | 2021-05-19 | Summit | Ohio | 39153 | 47716 | 961 |
1334871 | 1334871 | 2021-05-19 | Trumbull | Ohio | 39155 | 16238 | 469 |
1334872 | 1334872 | 2021-05-19 | Tuscarawas | Ohio | 39157 | 8519 | 245 |
1334873 | 1334873 | 2021-05-19 | Union | Ohio | 39159 | 5765 | 49 |
1334874 | 1334874 | 2021-05-19 | Unknown | Ohio | 0 | 2 | |
1334875 | 1334875 | 2021-05-19 | Van Wert | Ohio | 39161 | 2443 | 64 |
1334876 | 1334876 | 2021-05-19 | Vinton | Ohio | 39163 | 849 | 15 |
1334877 | 1334877 | 2021-05-19 | Warren | Ohio | 39165 | 24410 | 301 |
1334878 | 1334878 | 2021-05-19 | Washington | Ohio | 39167 | 5231 | 109 |
1334879 | 1334879 | 2021-05-19 | Wayne | Ohio | 39169 | 8948 | 214 |
1334880 | 1334880 | 2021-05-19 | Williams | Ohio | 39171 | 3439 | 77 |
1334881 | 1334881 | 2021-05-19 | Wood | Ohio | 39173 | 13189 | 192 |
1334882 | 1334882 | 2021-05-19 | Wyandot | Ohio | 39175 | 2325 | 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);