ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2020-12-20 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 · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
847857 | 847857 | 2020-12-20 | Adams | Ohio | 39001 | 1163 | 14 |
847858 | 847858 | 2020-12-20 | Allen | Ohio | 39003 | 7499 | 105 |
847859 | 847859 | 2020-12-20 | Ashland | Ohio | 39005 | 2327 | 36 |
847860 | 847860 | 2020-12-20 | Ashtabula | Ohio | 39007 | 3504 | 65 |
847861 | 847861 | 2020-12-20 | Athens | Ohio | 39009 | 2826 | 6 |
847862 | 847862 | 2020-12-20 | Auglaize | Ohio | 39011 | 3302 | 49 |
847863 | 847863 | 2020-12-20 | Belmont | Ohio | 39013 | 2772 | 32 |
847864 | 847864 | 2020-12-20 | Brown | Ohio | 39015 | 2012 | 10 |
847865 | 847865 | 2020-12-20 | Butler | Ohio | 39017 | 23321 | 179 |
847866 | 847866 | 2020-12-20 | Carroll | Ohio | 39019 | 955 | 12 |
847867 | 847867 | 2020-12-20 | Champaign | Ohio | 39021 | 1655 | 20 |
847868 | 847868 | 2020-12-20 | Clark | Ohio | 39023 | 8144 | 172 |
847869 | 847869 | 2020-12-20 | Clermont | Ohio | 39025 | 10326 | 65 |
847870 | 847870 | 2020-12-20 | Clinton | Ohio | 39027 | 2032 | 36 |
847871 | 847871 | 2020-12-20 | Columbiana | Ohio | 39029 | 5496 | 116 |
847872 | 847872 | 2020-12-20 | Coshocton | Ohio | 39031 | 1493 | 15 |
847873 | 847873 | 2020-12-20 | Crawford | Ohio | 39033 | 2318 | 33 |
847874 | 847874 | 2020-12-20 | Cuyahoga | Ohio | 39035 | 62366 | 835 |
847875 | 847875 | 2020-12-20 | Darke | Ohio | 39037 | 3786 | 74 |
847876 | 847876 | 2020-12-20 | Defiance | Ohio | 39039 | 2427 | 63 |
847877 | 847877 | 2020-12-20 | Delaware | Ohio | 39041 | 9869 | 55 |
847878 | 847878 | 2020-12-20 | Erie | Ohio | 39043 | 4215 | 91 |
847879 | 847879 | 2020-12-20 | Fairfield | Ohio | 39045 | 8786 | 70 |
847880 | 847880 | 2020-12-20 | Fayette | Ohio | 39047 | 1554 | 26 |
847881 | 847881 | 2020-12-20 | Franklin | Ohio | 39049 | 75316 | 693 |
847882 | 847882 | 2020-12-20 | Fulton | Ohio | 39051 | 2359 | 37 |
847883 | 847883 | 2020-12-20 | Gallia | Ohio | 39053 | 1455 | 18 |
847884 | 847884 | 2020-12-20 | Geauga | Ohio | 39055 | 3599 | 51 |
847885 | 847885 | 2020-12-20 | Greene | Ohio | 39057 | 8648 | 102 |
847886 | 847886 | 2020-12-20 | Guernsey | Ohio | 39059 | 1738 | 16 |
847887 | 847887 | 2020-12-20 | Hamilton | Ohio | 39061 | 46842 | 405 |
847888 | 847888 | 2020-12-20 | Hancock | Ohio | 39063 | 4057 | 69 |
847889 | 847889 | 2020-12-20 | Hardin | Ohio | 39065 | 1568 | 30 |
847890 | 847890 | 2020-12-20 | Harrison | Ohio | 39067 | 561 | 3 |
847891 | 847891 | 2020-12-20 | Henry | Ohio | 39069 | 1576 | 35 |
847892 | 847892 | 2020-12-20 | Highland | Ohio | 39071 | 1863 | 18 |
847893 | 847893 | 2020-12-20 | Hocking | Ohio | 39073 | 1222 | 22 |
847894 | 847894 | 2020-12-20 | Holmes | Ohio | 39075 | 1825 | 50 |
847895 | 847895 | 2020-12-20 | Huron | Ohio | 39077 | 2936 | 37 |
847896 | 847896 | 2020-12-20 | Jackson | Ohio | 39079 | 1907 | 20 |
847897 | 847897 | 2020-12-20 | Jefferson | Ohio | 39081 | 2936 | 42 |
847898 | 847898 | 2020-12-20 | Knox | Ohio | 39083 | 2365 | 22 |
847899 | 847899 | 2020-12-20 | Lake | Ohio | 39085 | 11200 | 98 |
847900 | 847900 | 2020-12-20 | Lawrence | Ohio | 39087 | 3086 | 45 |
847901 | 847901 | 2020-12-20 | Licking | Ohio | 39089 | 9309 | 103 |
847902 | 847902 | 2020-12-20 | Logan | Ohio | 39091 | 2149 | 21 |
847903 | 847903 | 2020-12-20 | Lorain | Ohio | 39093 | 12905 | 143 |
847904 | 847904 | 2020-12-20 | Lucas | Ohio | 39095 | 23166 | 504 |
847905 | 847905 | 2020-12-20 | Madison | Ohio | 39097 | 2635 | 21 |
847906 | 847906 | 2020-12-20 | Mahoning | Ohio | 39099 | 12999 | 311 |
847907 | 847907 | 2020-12-20 | Marion | Ohio | 39101 | 6289 | 93 |
847908 | 847908 | 2020-12-20 | Medina | Ohio | 39103 | 8218 | 91 |
847909 | 847909 | 2020-12-20 | Meigs | Ohio | 39105 | 732 | 14 |
847910 | 847910 | 2020-12-20 | Mercer | Ohio | 39107 | 3700 | 76 |
847911 | 847911 | 2020-12-20 | Miami | Ohio | 39109 | 6787 | 70 |
847912 | 847912 | 2020-12-20 | Monroe | Ohio | 39111 | 607 | 24 |
847913 | 847913 | 2020-12-20 | Montgomery | Ohio | 39113 | 31993 | 326 |
847914 | 847914 | 2020-12-20 | Morgan | Ohio | 39115 | 588 | 24 |
847915 | 847915 | 2020-12-20 | Morrow | Ohio | 39117 | 1572 | 2 |
847916 | 847916 | 2020-12-20 | Muskingum | Ohio | 39119 | 4601 | 22 |
847917 | 847917 | 2020-12-20 | Noble | Ohio | 39121 | 932 | 30 |
847918 | 847918 | 2020-12-20 | Ottawa | Ohio | 39123 | 2033 | 33 |
847919 | 847919 | 2020-12-20 | Paulding | Ohio | 39125 | 1066 | 18 |
847920 | 847920 | 2020-12-20 | Perry | Ohio | 39127 | 1617 | 15 |
847921 | 847921 | 2020-12-20 | Pickaway | Ohio | 39129 | 5492 | 50 |
847922 | 847922 | 2020-12-20 | Pike | Ohio | 39131 | 1258 | 5 |
847923 | 847923 | 2020-12-20 | Portage | Ohio | 39133 | 6507 | 89 |
847924 | 847924 | 2020-12-20 | Preble | Ohio | 39135 | 2464 | 29 |
847925 | 847925 | 2020-12-20 | Putnam | Ohio | 39137 | 3054 | 62 |
847926 | 847926 | 2020-12-20 | Richland | Ohio | 39139 | 6539 | 59 |
847927 | 847927 | 2020-12-20 | Ross | Ohio | 39141 | 3895 | 76 |
847928 | 847928 | 2020-12-20 | Sandusky | Ohio | 39143 | 3077 | 47 |
847929 | 847929 | 2020-12-20 | Scioto | Ohio | 39145 | 3733 | 35 |
847930 | 847930 | 2020-12-20 | Seneca | Ohio | 39147 | 3070 | 29 |
847931 | 847931 | 2020-12-20 | Shelby | Ohio | 39149 | 3045 | 18 |
847932 | 847932 | 2020-12-20 | Stark | Ohio | 39151 | 18097 | 258 |
847933 | 847933 | 2020-12-20 | Summit | Ohio | 39153 | 24560 | 490 |
847934 | 847934 | 2020-12-20 | Trumbull | Ohio | 39155 | 9733 | 230 |
847935 | 847935 | 2020-12-20 | Tuscarawas | Ohio | 39157 | 5622 | 111 |
847936 | 847936 | 2020-12-20 | Union | Ohio | 39159 | 3148 | 18 |
847937 | 847937 | 2020-12-20 | Van Wert | Ohio | 39161 | 1519 | 36 |
847938 | 847938 | 2020-12-20 | Vinton | Ohio | 39163 | 449 | 7 |
847939 | 847939 | 2020-12-20 | Warren | Ohio | 39165 | 13800 | 105 |
847940 | 847940 | 2020-12-20 | Washington | Ohio | 39167 | 2559 | 32 |
847941 | 847941 | 2020-12-20 | Wayne | Ohio | 39169 | 5286 | 133 |
847942 | 847942 | 2020-12-20 | Williams | Ohio | 39171 | 2014 | 35 |
847943 | 847943 | 2020-12-20 | Wood | Ohio | 39173 | 7391 | 133 |
847944 | 847944 | 2020-12-20 | Wyandot | Ohio | 39175 | 1389 | 27 |
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);