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 2022-02-08 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 |
---|---|---|---|---|---|---|---|
2195776 | 2195776 | 2022-02-08 | Adams | Ohio | 39001 | 6732 | 133 |
2195777 | 2195777 | 2022-02-08 | Allen | Ohio | 39003 | 27045 | 429 |
2195778 | 2195778 | 2022-02-08 | Ashland | Ohio | 39005 | 11728 | 202 |
2195779 | 2195779 | 2022-02-08 | Ashtabula | Ohio | 39007 | 19203 | 382 |
2195780 | 2195780 | 2022-02-08 | Athens | Ohio | 39009 | 13763 | 112 |
2195781 | 2195781 | 2022-02-08 | Auglaize | Ohio | 39011 | 11372 | 163 |
2195782 | 2195782 | 2022-02-08 | Belmont | Ohio | 39013 | 15227 | 263 |
2195783 | 2195783 | 2022-02-08 | Brown | Ohio | 39015 | 10919 | 154 |
2195784 | 2195784 | 2022-02-08 | Butler | Ohio | 39017 | 88443 | 1020 |
2195785 | 2195785 | 2022-02-08 | Carroll | Ohio | 39019 | 5187 | 113 |
2195786 | 2195786 | 2022-02-08 | Champaign | Ohio | 39021 | 8527 | 126 |
2195787 | 2195787 | 2022-02-08 | Clark | Ohio | 39023 | 34254 | 497 |
2195788 | 2195788 | 2022-02-08 | Clermont | Ohio | 39025 | 50014 | 483 |
2195789 | 2195789 | 2022-02-08 | Clinton | Ohio | 39027 | 10096 | 146 |
2195790 | 2195790 | 2022-02-08 | Columbiana | Ohio | 39029 | 23880 | 453 |
2195791 | 2195791 | 2022-02-08 | Coshocton | Ohio | 39031 | 7788 | 142 |
2195792 | 2195792 | 2022-02-08 | Crawford | Ohio | 39033 | 10927 | 187 |
2195793 | 2195793 | 2022-02-08 | Cuyahoga | Ohio | 39035 | 264367 | 3406 |
2195794 | 2195794 | 2022-02-08 | Darke | Ohio | 39037 | 12146 | 213 |
2195795 | 2195795 | 2022-02-08 | Defiance | Ohio | 39039 | 10004 | 152 |
2195796 | 2195796 | 2022-02-08 | Delaware | Ohio | 39041 | 43320 | 245 |
2195797 | 2195797 | 2022-02-08 | Erie | Ohio | 39043 | 19117 | 251 |
2195798 | 2195798 | 2022-02-08 | Fairfield | Ohio | 39045 | 37619 | 386 |
2195799 | 2195799 | 2022-02-08 | Fayette | Ohio | 39047 | 7636 | 101 |
2195800 | 2195800 | 2022-02-08 | Franklin | Ohio | 39049 | 282470 | 2301 |
2195801 | 2195801 | 2022-02-08 | Fulton | Ohio | 39051 | 10147 | 165 |
2195802 | 2195802 | 2022-02-08 | Gallia | Ohio | 39053 | 7022 | 105 |
2195803 | 2195803 | 2022-02-08 | Geauga | Ohio | 39055 | 15773 | 249 |
2195804 | 2195804 | 2022-02-08 | Greene | Ohio | 39057 | 36390 | 454 |
2195805 | 2195805 | 2022-02-08 | Guernsey | Ohio | 39059 | 10170 | 135 |
2195806 | 2195806 | 2022-02-08 | Hamilton | Ohio | 39061 | 183421 | 1847 |
2195807 | 2195807 | 2022-02-08 | Hancock | Ohio | 39063 | 16791 | 248 |
2195808 | 2195808 | 2022-02-08 | Hardin | Ohio | 39065 | 6942 | 138 |
2195809 | 2195809 | 2022-02-08 | Harrison | Ohio | 39067 | 3156 | 68 |
2195810 | 2195810 | 2022-02-08 | Henry | Ohio | 39069 | 6310 | 100 |
2195811 | 2195811 | 2022-02-08 | Highland | Ohio | 39071 | 10418 | 164 |
2195812 | 2195812 | 2022-02-08 | Hocking | Ohio | 39073 | 6361 | 111 |
2195813 | 2195813 | 2022-02-08 | Holmes | Ohio | 39075 | 5011 | 172 |
2195814 | 2195814 | 2022-02-08 | Huron | Ohio | 39077 | 14257 | 210 |
2195815 | 2195815 | 2022-02-08 | Jackson | Ohio | 39079 | 8484 | 127 |
2195816 | 2195816 | 2022-02-08 | Jefferson | Ohio | 39081 | 14355 | 286 |
2195817 | 2195817 | 2022-02-08 | Knox | Ohio | 39083 | 12815 | 215 |
2195818 | 2195818 | 2022-02-08 | Lake | Ohio | 39085 | 48205 | 687 |
2195819 | 2195819 | 2022-02-08 | Lawrence | Ohio | 39087 | 16910 | 208 |
2195820 | 2195820 | 2022-02-08 | Licking | Ohio | 39089 | 40481 | 437 |
2195821 | 2195821 | 2022-02-08 | Logan | Ohio | 39091 | 9960 | 153 |
2195822 | 2195822 | 2022-02-08 | Lorain | Ohio | 39093 | 65324 | 896 |
2195823 | 2195823 | 2022-02-08 | Lucas | Ohio | 39095 | 97190 | 1283 |
2195824 | 2195824 | 2022-02-08 | Madison | Ohio | 39097 | 9468 | 121 |
2195825 | 2195825 | 2022-02-08 | Mahoning | Ohio | 39099 | 52517 | 1003 |
2195826 | 2195826 | 2022-02-08 | Marion | Ohio | 39101 | 19433 | 244 |
2195827 | 2195827 | 2022-02-08 | Medina | Ohio | 39103 | 39469 | 464 |
2195828 | 2195828 | 2022-02-08 | Meigs | Ohio | 39105 | 4330 | 76 |
2195829 | 2195829 | 2022-02-08 | Mercer | Ohio | 39107 | 9514 | 119 |
2195830 | 2195830 | 2022-02-08 | Miami | Ohio | 39109 | 25334 | 436 |
2195831 | 2195831 | 2022-02-08 | Monroe | Ohio | 39111 | 3367 | 69 |
2195832 | 2195832 | 2022-02-08 | Montgomery | Ohio | 39113 | 124263 | 1775 |
2195833 | 2195833 | 2022-02-08 | Morgan | Ohio | 39115 | 3134 | 51 |
2195834 | 2195834 | 2022-02-08 | Morrow | Ohio | 39117 | 7588 | 89 |
2195835 | 2195835 | 2022-02-08 | Muskingum | Ohio | 39119 | 24721 | 268 |
2195836 | 2195836 | 2022-02-08 | Noble | Ohio | 39121 | 3128 | 53 |
2195837 | 2195837 | 2022-02-08 | Ottawa | Ohio | 39123 | 8232 | 130 |
2195838 | 2195838 | 2022-02-08 | Paulding | Ohio | 39125 | 4536 | 68 |
2195839 | 2195839 | 2022-02-08 | Perry | Ohio | 39127 | 7964 | 113 |
2195840 | 2195840 | 2022-02-08 | Pickaway | Ohio | 39129 | 17160 | 201 |
2195841 | 2195841 | 2022-02-08 | Pike | Ohio | 39131 | 7193 | 98 |
2195842 | 2195842 | 2022-02-08 | Portage | Ohio | 39133 | 33299 | 408 |
2195843 | 2195843 | 2022-02-08 | Preble | Ohio | 39135 | 9183 | 179 |
2195844 | 2195844 | 2022-02-08 | Putnam | Ohio | 39137 | 8338 | 140 |
2195845 | 2195845 | 2022-02-08 | Richland | Ohio | 39139 | 30832 | 471 |
2195846 | 2195846 | 2022-02-08 | Ross | Ohio | 39141 | 18684 | 271 |
2195847 | 2195847 | 2022-02-08 | Sandusky | Ohio | 39143 | 13737 | 214 |
2195848 | 2195848 | 2022-02-08 | Scioto | Ohio | 39145 | 19780 | 225 |
2195849 | 2195849 | 2022-02-08 | Seneca | Ohio | 39147 | 12509 | 216 |
2195850 | 2195850 | 2022-02-08 | Shelby | Ohio | 39149 | 10878 | 170 |
2195851 | 2195851 | 2022-02-08 | Stark | Ohio | 39151 | 78805 | 1577 |
2195852 | 2195852 | 2022-02-08 | Summit | Ohio | 39153 | 110772 | 1562 |
2195853 | 2195853 | 2022-02-08 | Trumbull | Ohio | 39155 | 40762 | 848 |
2195854 | 2195854 | 2022-02-08 | Tuscarawas | Ohio | 39157 | 20243 | 463 |
2195855 | 2195855 | 2022-02-08 | Union | Ohio | 39159 | 15156 | 88 |
2195856 | 2195856 | 2022-02-08 | Unknown | Ohio | 0 | 5 | |
2195857 | 2195857 | 2022-02-08 | Van Wert | Ohio | 39161 | 6422 | 130 |
2195858 | 2195858 | 2022-02-08 | Vinton | Ohio | 39163 | 2812 | 51 |
2195859 | 2195859 | 2022-02-08 | Warren | Ohio | 39165 | 56311 | 526 |
2195860 | 2195860 | 2022-02-08 | Washington | Ohio | 39167 | 11987 | 176 |
2195861 | 2195861 | 2022-02-08 | Wayne | Ohio | 39169 | 22792 | 402 |
2195862 | 2195862 | 2022-02-08 | Williams | Ohio | 39171 | 8781 | 152 |
2195863 | 2195863 | 2022-02-08 | Wood | Ohio | 39173 | 30653 | 324 |
2195864 | 2195864 | 2022-02-08 | Wyandot | Ohio | 39175 | 5340 | 98 |
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);