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 555
- 39151 553
- 39155 552
- 39013 550
- 39017 550
- 39049 550
- 39093 550
- 39153 550
- 39157 550
- 39095 549
- 39103 549
- 39055 548
- 39031 547
- 39037 547
- 39085 547
- 39099 547
- 39005 546
- 39023 546
- 39041 546
- 39077 546
- 39109 546
- 39061 545
- 39113 545
- 39139 545
- 39007 544
- 39029 544
- 39101 544
- 39159 544
- 39165 544
- 39025 543
- …
county >30
- Cuyahoga 555
- Stark 553
- Trumbull 552
- Belmont 550
- Butler 550
- Franklin 550
- Lorain 550
- Summit 550
- Tuscarawas 550
- Lucas 549
- Medina 549
- Geauga 548
- Coshocton 547
- Darke 547
- Lake 547
- Mahoning 547
- Ashland 546
- Clark 546
- Delaware 546
- Huron 546
- Miami 546
- Hamilton 545
- Montgomery 545
- Richland 545
- Ashtabula 544
- Columbiana 544
- Marion 544
- Union 544
- Warren 544
- Clermont 543
- …
state 1
- Ohio · 47,652 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717954 | 1717954 | 2021-09-14 | Adams | Ohio | 39001 | 3357 | 64 |
1717955 | 1717955 | 2021-09-14 | Allen | Ohio | 39003 | 13581 | 254 |
1717956 | 1717956 | 2021-09-14 | Ashland | Ohio | 39005 | 5590 | 110 |
1717957 | 1717957 | 2021-09-14 | Ashtabula | Ohio | 39007 | 8031 | 184 |
1717958 | 1717958 | 2021-09-14 | Athens | Ohio | 39009 | 6616 | 63 |
1717959 | 1717959 | 2021-09-14 | Auglaize | Ohio | 39011 | 5676 | 88 |
1717960 | 1717960 | 2021-09-14 | Belmont | Ohio | 39013 | 7719 | 183 |
1717961 | 1717961 | 2021-09-14 | Brown | Ohio | 39015 | 5259 | 67 |
1717962 | 1717962 | 2021-09-14 | Butler | Ohio | 39017 | 45737 | 649 |
1717963 | 1717963 | 2021-09-14 | Carroll | Ohio | 39019 | 2481 | 51 |
1717964 | 1717964 | 2021-09-14 | Champaign | Ohio | 39021 | 4225 | 63 |
1717965 | 1717965 | 2021-09-14 | Clark | Ohio | 39023 | 17093 | 321 |
1717966 | 1717966 | 2021-09-14 | Clermont | Ohio | 39025 | 24582 | 278 |
1717967 | 1717967 | 2021-09-14 | Clinton | Ohio | 39027 | 5025 | 79 |
1717968 | 1717968 | 2021-09-14 | Columbiana | Ohio | 39029 | 11032 | 239 |
1717969 | 1717969 | 2021-09-14 | Coshocton | Ohio | 39031 | 3383 | 64 |
1717970 | 1717970 | 2021-09-14 | Crawford | Ohio | 39033 | 5103 | 113 |
1717971 | 1717971 | 2021-09-14 | Cuyahoga | Ohio | 39035 | 130656 | 2313 |
1717972 | 1717972 | 2021-09-14 | Darke | Ohio | 39037 | 6323 | 135 |
1717973 | 1717973 | 2021-09-14 | Defiance | Ohio | 39039 | 5242 | 100 |
1717974 | 1717974 | 2021-09-14 | Delaware | Ohio | 39041 | 21635 | 140 |
1717975 | 1717975 | 2021-09-14 | Erie | Ohio | 39043 | 9410 | 170 |
1717976 | 1717976 | 2021-09-14 | Fairfield | Ohio | 39045 | 19645 | 218 |
1717977 | 1717977 | 2021-09-14 | Fayette | Ohio | 39047 | 3515 | 51 |
1717978 | 1717978 | 2021-09-14 | Franklin | Ohio | 39049 | 147419 | 1537 |
1717979 | 1717979 | 2021-09-14 | Fulton | Ohio | 39051 | 5059 | 81 |
1717980 | 1717980 | 2021-09-14 | Gallia | Ohio | 39053 | 3254 | 54 |
1717981 | 1717981 | 2021-09-14 | Geauga | Ohio | 39055 | 7942 | 155 |
1717982 | 1717982 | 2021-09-14 | Greene | Ohio | 39057 | 19552 | 266 |
1717983 | 1717983 | 2021-09-14 | Guernsey | Ohio | 39059 | 4363 | 57 |
1717984 | 1717984 | 2021-09-14 | Hamilton | Ohio | 39061 | 94500 | 1307 |
1717985 | 1717985 | 2021-09-14 | Hancock | Ohio | 39063 | 8042 | 140 |
1717986 | 1717986 | 2021-09-14 | Hardin | Ohio | 39065 | 3372 | 68 |
1717987 | 1717987 | 2021-09-14 | Harrison | Ohio | 39067 | 1439 | 40 |
1717988 | 1717988 | 2021-09-14 | Henry | Ohio | 39069 | 3107 | 68 |
1717989 | 1717989 | 2021-09-14 | Highland | Ohio | 39071 | 5084 | 76 |
1717990 | 1717990 | 2021-09-14 | Hocking | Ohio | 39073 | 2779 | 67 |
1717991 | 1717991 | 2021-09-14 | Holmes | Ohio | 39075 | 3120 | 107 |
1717992 | 1717992 | 2021-09-14 | Huron | Ohio | 39077 | 7020 | 125 |
1717993 | 1717993 | 2021-09-14 | Jackson | Ohio | 39079 | 3994 | 59 |
1717994 | 1717994 | 2021-09-14 | Jefferson | Ohio | 39081 | 7003 | 168 |
1717995 | 1717995 | 2021-09-14 | Knox | Ohio | 39083 | 6269 | 120 |
1717996 | 1717996 | 2021-09-14 | Lake | Ohio | 39085 | 23984 | 411 |
1717997 | 1717997 | 2021-09-14 | Lawrence | Ohio | 39087 | 8111 | 116 |
1717998 | 1717998 | 2021-09-14 | Licking | Ohio | 39089 | 19661 | 239 |
1717999 | 1717999 | 2021-09-14 | Logan | Ohio | 39091 | 4903 | 82 |
1718000 | 1718000 | 2021-09-14 | Lorain | Ohio | 39093 | 30240 | 525 |
1718001 | 1718001 | 2021-09-14 | Lucas | Ohio | 39095 | 49206 | 853 |
1718002 | 1718002 | 2021-09-14 | Madison | Ohio | 39097 | 5237 | 68 |
1718003 | 1718003 | 2021-09-14 | Mahoning | Ohio | 39099 | 25848 | 629 |
1718004 | 1718004 | 2021-09-14 | Marion | Ohio | 39101 | 10201 | 144 |
1718005 | 1718005 | 2021-09-14 | Medina | Ohio | 39103 | 19108 | 285 |
1718006 | 1718006 | 2021-09-14 | Meigs | Ohio | 39105 | 1947 | 42 |
1718007 | 1718007 | 2021-09-14 | Mercer | Ohio | 39107 | 5427 | 88 |
1718008 | 1718008 | 2021-09-14 | Miami | Ohio | 39109 | 13216 | 244 |
1718009 | 1718009 | 2021-09-14 | Monroe | Ohio | 39111 | 1766 | 49 |
1718010 | 1718010 | 2021-09-14 | Montgomery | Ohio | 39113 | 64425 | 1122 |
1718011 | 1718011 | 2021-09-14 | Morgan | Ohio | 39115 | 1505 | 28 |
1718012 | 1718012 | 2021-09-14 | Morrow | Ohio | 39117 | 3560 | 49 |
1718013 | 1718013 | 2021-09-14 | Muskingum | Ohio | 39119 | 11678 | 148 |
1718014 | 1718014 | 2021-09-14 | Noble | Ohio | 39121 | 1589 | 40 |
1718015 | 1718015 | 2021-09-14 | Ottawa | Ohio | 39123 | 4234 | 83 |
1718016 | 1718016 | 2021-09-14 | Paulding | Ohio | 39125 | 2289 | 42 |
1718017 | 1718017 | 2021-09-14 | Perry | Ohio | 39127 | 4070 | 51 |
1718018 | 1718018 | 2021-09-14 | Pickaway | Ohio | 39129 | 10131 | 128 |
1718019 | 1718019 | 2021-09-14 | Pike | Ohio | 39131 | 3628 | 40 |
1718020 | 1718020 | 2021-09-14 | Portage | Ohio | 39133 | 15502 | 224 |
1718021 | 1718021 | 2021-09-14 | Preble | Ohio | 39135 | 4747 | 110 |
1718022 | 1718022 | 2021-09-14 | Putnam | Ohio | 39137 | 4717 | 106 |
1718023 | 1718023 | 2021-09-14 | Richland | Ohio | 39139 | 15409 | 228 |
1718024 | 1718024 | 2021-09-14 | Ross | Ohio | 39141 | 8904 | 172 |
1718025 | 1718025 | 2021-09-14 | Sandusky | Ohio | 39143 | 6575 | 132 |
1718026 | 1718026 | 2021-09-14 | Scioto | Ohio | 39145 | 9614 | 124 |
1718027 | 1718027 | 2021-09-14 | Seneca | Ohio | 39147 | 6083 | 135 |
1718028 | 1718028 | 2021-09-14 | Shelby | Ohio | 39149 | 5533 | 99 |
1718029 | 1718029 | 2021-09-14 | Stark | Ohio | 39151 | 39689 | 963 |
1718030 | 1718030 | 2021-09-14 | Summit | Ohio | 39153 | 54635 | 1041 |
1718031 | 1718031 | 2021-09-14 | Trumbull | Ohio | 39155 | 19093 | 506 |
1718032 | 1718032 | 2021-09-14 | Tuscarawas | Ohio | 39157 | 10304 | 264 |
1718033 | 1718033 | 2021-09-14 | Union | Ohio | 39159 | 7004 | 49 |
1718034 | 1718034 | 2021-09-14 | Unknown | Ohio | 0 | 5 | |
1718035 | 1718035 | 2021-09-14 | Van Wert | Ohio | 39161 | 2975 | 69 |
1718036 | 1718036 | 2021-09-14 | Vinton | Ohio | 39163 | 1287 | 17 |
1718037 | 1718037 | 2021-09-14 | Warren | Ohio | 39165 | 29045 | 326 |
1718038 | 1718038 | 2021-09-14 | Washington | Ohio | 39167 | 6732 | 116 |
1718039 | 1718039 | 2021-09-14 | Wayne | Ohio | 39169 | 11347 | 234 |
1718040 | 1718040 | 2021-09-14 | Williams | Ohio | 39171 | 4334 | 81 |
1718041 | 1718041 | 2021-09-14 | Wood | Ohio | 39173 | 15091 | 208 |
1718042 | 1718042 | 2021-09-14 | Wyandot | Ohio | 39175 | 2700 | 58 |
1714706 | 1714706 | 2021-09-13 | Adams | Ohio | 39001 | 3309 | 63 |
1714707 | 1714707 | 2021-09-13 | Allen | Ohio | 39003 | 13525 | 254 |
1714708 | 1714708 | 2021-09-13 | Ashland | Ohio | 39005 | 5541 | 107 |
1714709 | 1714709 | 2021-09-13 | Ashtabula | Ohio | 39007 | 7991 | 184 |
1714710 | 1714710 | 2021-09-13 | Athens | Ohio | 39009 | 6571 | 63 |
1714711 | 1714711 | 2021-09-13 | Auglaize | Ohio | 39011 | 5664 | 88 |
1714712 | 1714712 | 2021-09-13 | Belmont | Ohio | 39013 | 7660 | 183 |
1714713 | 1714713 | 2021-09-13 | Brown | Ohio | 39015 | 5214 | 67 |
1714714 | 1714714 | 2021-09-13 | Butler | Ohio | 39017 | 45521 | 646 |
1714715 | 1714715 | 2021-09-13 | Carroll | Ohio | 39019 | 2451 | 51 |
1714716 | 1714716 | 2021-09-13 | Champaign | Ohio | 39021 | 4195 | 63 |
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);