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-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 · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
844612 | 844612 | 2020-12-19 | Adams | Ohio | 39001 | 1159 | 14 |
844613 | 844613 | 2020-12-19 | Allen | Ohio | 39003 | 7405 | 105 |
844614 | 844614 | 2020-12-19 | Ashland | Ohio | 39005 | 2265 | 36 |
844615 | 844615 | 2020-12-19 | Ashtabula | Ohio | 39007 | 3453 | 65 |
844616 | 844616 | 2020-12-19 | Athens | Ohio | 39009 | 2797 | 6 |
844617 | 844617 | 2020-12-19 | Auglaize | Ohio | 39011 | 3288 | 49 |
844618 | 844618 | 2020-12-19 | Belmont | Ohio | 39013 | 2741 | 32 |
844619 | 844619 | 2020-12-19 | Brown | Ohio | 39015 | 1986 | 10 |
844620 | 844620 | 2020-12-19 | Butler | Ohio | 39017 | 23057 | 179 |
844621 | 844621 | 2020-12-19 | Carroll | Ohio | 39019 | 933 | 12 |
844622 | 844622 | 2020-12-19 | Champaign | Ohio | 39021 | 1631 | 20 |
844623 | 844623 | 2020-12-19 | Clark | Ohio | 39023 | 8058 | 172 |
844624 | 844624 | 2020-12-19 | Clermont | Ohio | 39025 | 10175 | 65 |
844625 | 844625 | 2020-12-19 | Clinton | Ohio | 39027 | 2009 | 36 |
844626 | 844626 | 2020-12-19 | Columbiana | Ohio | 39029 | 5443 | 116 |
844627 | 844627 | 2020-12-19 | Coshocton | Ohio | 39031 | 1463 | 15 |
844628 | 844628 | 2020-12-19 | Crawford | Ohio | 39033 | 2281 | 32 |
844629 | 844629 | 2020-12-19 | Cuyahoga | Ohio | 39035 | 61201 | 843 |
844630 | 844630 | 2020-12-19 | Darke | Ohio | 39037 | 3748 | 73 |
844631 | 844631 | 2020-12-19 | Defiance | Ohio | 39039 | 2380 | 63 |
844632 | 844632 | 2020-12-19 | Delaware | Ohio | 39041 | 9708 | 54 |
844633 | 844633 | 2020-12-19 | Erie | Ohio | 39043 | 4155 | 91 |
844634 | 844634 | 2020-12-19 | Fairfield | Ohio | 39045 | 8676 | 70 |
844635 | 844635 | 2020-12-19 | Fayette | Ohio | 39047 | 1544 | 26 |
844636 | 844636 | 2020-12-19 | Franklin | Ohio | 39049 | 74477 | 693 |
844637 | 844637 | 2020-12-19 | Fulton | Ohio | 39051 | 2344 | 37 |
844638 | 844638 | 2020-12-19 | Gallia | Ohio | 39053 | 1441 | 18 |
844639 | 844639 | 2020-12-19 | Geauga | Ohio | 39055 | 3539 | 51 |
844640 | 844640 | 2020-12-19 | Greene | Ohio | 39057 | 8521 | 102 |
844641 | 844641 | 2020-12-19 | Guernsey | Ohio | 39059 | 1709 | 16 |
844642 | 844642 | 2020-12-19 | Hamilton | Ohio | 39061 | 46283 | 404 |
844643 | 844643 | 2020-12-19 | Hancock | Ohio | 39063 | 3998 | 69 |
844644 | 844644 | 2020-12-19 | Hardin | Ohio | 39065 | 1536 | 30 |
844645 | 844645 | 2020-12-19 | Harrison | Ohio | 39067 | 550 | 3 |
844646 | 844646 | 2020-12-19 | Henry | Ohio | 39069 | 1559 | 35 |
844647 | 844647 | 2020-12-19 | Highland | Ohio | 39071 | 1846 | 18 |
844648 | 844648 | 2020-12-19 | Hocking | Ohio | 39073 | 1204 | 22 |
844649 | 844649 | 2020-12-19 | Holmes | Ohio | 39075 | 1815 | 50 |
844650 | 844650 | 2020-12-19 | Huron | Ohio | 39077 | 2905 | 37 |
844651 | 844651 | 2020-12-19 | Jackson | Ohio | 39079 | 1865 | 19 |
844652 | 844652 | 2020-12-19 | Jefferson | Ohio | 39081 | 2886 | 42 |
844653 | 844653 | 2020-12-19 | Knox | Ohio | 39083 | 2332 | 22 |
844654 | 844654 | 2020-12-19 | Lake | Ohio | 39085 | 11034 | 98 |
844655 | 844655 | 2020-12-19 | Lawrence | Ohio | 39087 | 3055 | 45 |
844656 | 844656 | 2020-12-19 | Licking | Ohio | 39089 | 9196 | 102 |
844657 | 844657 | 2020-12-19 | Logan | Ohio | 39091 | 2137 | 21 |
844658 | 844658 | 2020-12-19 | Lorain | Ohio | 39093 | 12672 | 143 |
844659 | 844659 | 2020-12-19 | Lucas | Ohio | 39095 | 22989 | 504 |
844660 | 844660 | 2020-12-19 | Madison | Ohio | 39097 | 2603 | 21 |
844661 | 844661 | 2020-12-19 | Mahoning | Ohio | 39099 | 12795 | 311 |
844662 | 844662 | 2020-12-19 | Marion | Ohio | 39101 | 6221 | 93 |
844663 | 844663 | 2020-12-19 | Medina | Ohio | 39103 | 8104 | 89 |
844664 | 844664 | 2020-12-19 | Meigs | Ohio | 39105 | 722 | 14 |
844665 | 844665 | 2020-12-19 | Mercer | Ohio | 39107 | 3687 | 76 |
844666 | 844666 | 2020-12-19 | Miami | Ohio | 39109 | 6703 | 70 |
844667 | 844667 | 2020-12-19 | Monroe | Ohio | 39111 | 600 | 24 |
844668 | 844668 | 2020-12-19 | Montgomery | Ohio | 39113 | 31661 | 325 |
844669 | 844669 | 2020-12-19 | Morgan | Ohio | 39115 | 580 | 24 |
844670 | 844670 | 2020-12-19 | Morrow | Ohio | 39117 | 1539 | 2 |
844671 | 844671 | 2020-12-19 | Muskingum | Ohio | 39119 | 4514 | 22 |
844672 | 844672 | 2020-12-19 | Noble | Ohio | 39121 | 906 | 30 |
844673 | 844673 | 2020-12-19 | Ottawa | Ohio | 39123 | 2010 | 33 |
844674 | 844674 | 2020-12-19 | Paulding | Ohio | 39125 | 1057 | 18 |
844675 | 844675 | 2020-12-19 | Perry | Ohio | 39127 | 1571 | 15 |
844676 | 844676 | 2020-12-19 | Pickaway | Ohio | 39129 | 5344 | 50 |
844677 | 844677 | 2020-12-19 | Pike | Ohio | 39131 | 1244 | 5 |
844678 | 844678 | 2020-12-19 | Portage | Ohio | 39133 | 6360 | 89 |
844679 | 844679 | 2020-12-19 | Preble | Ohio | 39135 | 2440 | 29 |
844680 | 844680 | 2020-12-19 | Putnam | Ohio | 39137 | 3037 | 62 |
844681 | 844681 | 2020-12-19 | Richland | Ohio | 39139 | 6424 | 59 |
844682 | 844682 | 2020-12-19 | Ross | Ohio | 39141 | 3817 | 76 |
844683 | 844683 | 2020-12-19 | Sandusky | Ohio | 39143 | 3035 | 46 |
844684 | 844684 | 2020-12-19 | Scioto | Ohio | 39145 | 3680 | 35 |
844685 | 844685 | 2020-12-19 | Seneca | Ohio | 39147 | 3040 | 29 |
844686 | 844686 | 2020-12-19 | Shelby | Ohio | 39149 | 3009 | 18 |
844687 | 844687 | 2020-12-19 | Stark | Ohio | 39151 | 17808 | 258 |
844688 | 844688 | 2020-12-19 | Summit | Ohio | 39153 | 24258 | 486 |
844689 | 844689 | 2020-12-19 | Trumbull | Ohio | 39155 | 9595 | 224 |
844690 | 844690 | 2020-12-19 | Tuscarawas | Ohio | 39157 | 5530 | 110 |
844691 | 844691 | 2020-12-19 | Union | Ohio | 39159 | 3107 | 18 |
844692 | 844692 | 2020-12-19 | Van Wert | Ohio | 39161 | 1506 | 36 |
844693 | 844693 | 2020-12-19 | Vinton | Ohio | 39163 | 443 | 7 |
844694 | 844694 | 2020-12-19 | Warren | Ohio | 39165 | 13610 | 105 |
844695 | 844695 | 2020-12-19 | Washington | Ohio | 39167 | 2520 | 32 |
844696 | 844696 | 2020-12-19 | Wayne | Ohio | 39169 | 5234 | 133 |
844697 | 844697 | 2020-12-19 | Williams | Ohio | 39171 | 1991 | 32 |
844698 | 844698 | 2020-12-19 | Wood | Ohio | 39173 | 7328 | 133 |
844699 | 844699 | 2020-12-19 | Wyandot | Ohio | 39175 | 1347 | 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);