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 2021-02-02 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 |
---|---|---|---|---|---|---|---|
990652 | 990652 | 2021-02-02 | Adams | Ohio | 39001 | 1971 | 15 |
990653 | 990653 | 2021-02-02 | Allen | Ohio | 39003 | 10320 | 133 |
990654 | 990654 | 2021-02-02 | Ashland | Ohio | 39005 | 3592 | 38 |
990655 | 990655 | 2021-02-02 | Ashtabula | Ohio | 39007 | 4782 | 76 |
990656 | 990656 | 2021-02-02 | Athens | Ohio | 39009 | 4089 | 9 |
990657 | 990657 | 2021-02-02 | Auglaize | Ohio | 39011 | 4343 | 66 |
990658 | 990658 | 2021-02-02 | Belmont | Ohio | 39013 | 4459 | 50 |
990659 | 990659 | 2021-02-02 | Brown | Ohio | 39015 | 3377 | 25 |
990660 | 990660 | 2021-02-02 | Butler | Ohio | 39017 | 32614 | 254 |
990661 | 990661 | 2021-02-02 | Carroll | Ohio | 39019 | 1661 | 18 |
990662 | 990662 | 2021-02-02 | Champaign | Ohio | 39021 | 2641 | 28 |
990663 | 990663 | 2021-02-02 | Clark | Ohio | 39023 | 11518 | 293 |
990664 | 990664 | 2021-02-02 | Clermont | Ohio | 39025 | 16946 | 120 |
990665 | 990665 | 2021-02-02 | Clinton | Ohio | 39027 | 3095 | 46 |
990666 | 990666 | 2021-02-02 | Columbiana | Ohio | 39029 | 7634 | 130 |
990667 | 990667 | 2021-02-02 | Coshocton | Ohio | 39031 | 2168 | 24 |
990668 | 990668 | 2021-02-02 | Crawford | Ohio | 39033 | 3383 | 85 |
990669 | 990669 | 2021-02-02 | Cuyahoga | Ohio | 39035 | 89554 | 1207 |
990670 | 990670 | 2021-02-02 | Darke | Ohio | 39037 | 4839 | 96 |
990671 | 990671 | 2021-02-02 | Defiance | Ohio | 39039 | 3478 | 88 |
990672 | 990672 | 2021-02-02 | Delaware | Ohio | 39041 | 15165 | 82 |
990673 | 990673 | 2021-02-02 | Erie | Ohio | 39043 | 6468 | 134 |
990674 | 990674 | 2021-02-02 | Fairfield | Ohio | 39045 | 13491 | 85 |
990675 | 990675 | 2021-02-02 | Fayette | Ohio | 39047 | 2478 | 30 |
990676 | 990676 | 2021-02-02 | Franklin | Ohio | 39049 | 105457 | 710 |
990677 | 990677 | 2021-02-02 | Fulton | Ohio | 39051 | 3525 | 45 |
990678 | 990678 | 2021-02-02 | Gallia | Ohio | 39053 | 2064 | 31 |
990679 | 990679 | 2021-02-02 | Geauga | Ohio | 39055 | 5491 | 56 |
990680 | 990680 | 2021-02-02 | Greene | Ohio | 39057 | 12677 | 150 |
990681 | 990681 | 2021-02-02 | Guernsey | Ohio | 39059 | 2678 | 27 |
990682 | 990682 | 2021-02-02 | Hamilton | Ohio | 39061 | 67772 | 460 |
990683 | 990683 | 2021-02-02 | Hancock | Ohio | 39063 | 5678 | 94 |
990684 | 990684 | 2021-02-02 | Hardin | Ohio | 39065 | 2280 | 33 |
990685 | 990685 | 2021-02-02 | Harrison | Ohio | 39067 | 922 | 22 |
990686 | 990686 | 2021-02-02 | Henry | Ohio | 39069 | 2303 | 56 |
990687 | 990687 | 2021-02-02 | Highland | Ohio | 39071 | 2984 | 22 |
990688 | 990688 | 2021-02-02 | Hocking | Ohio | 39073 | 1808 | 27 |
990689 | 990689 | 2021-02-02 | Holmes | Ohio | 39075 | 2325 | 76 |
990690 | 990690 | 2021-02-02 | Huron | Ohio | 39077 | 4482 | 76 |
990691 | 990691 | 2021-02-02 | Jackson | Ohio | 39079 | 2731 | 47 |
990692 | 990692 | 2021-02-02 | Jefferson | Ohio | 39081 | 4352 | 84 |
990693 | 990693 | 2021-02-02 | Knox | Ohio | 39083 | 3745 | 23 |
990694 | 990694 | 2021-02-02 | Lake | Ohio | 39085 | 16931 | 169 |
990695 | 990695 | 2021-02-02 | Lawrence | Ohio | 39087 | 4854 | 61 |
990696 | 990696 | 2021-02-02 | Licking | Ohio | 39089 | 13946 | 147 |
990697 | 990697 | 2021-02-02 | Logan | Ohio | 39091 | 3279 | 37 |
990698 | 990698 | 2021-02-02 | Lorain | Ohio | 39093 | 20199 | 239 |
990699 | 990699 | 2021-02-02 | Lucas | Ohio | 39095 | 32852 | 675 |
990700 | 990700 | 2021-02-02 | Madison | Ohio | 39097 | 3701 | 30 |
990701 | 990701 | 2021-02-02 | Mahoning | Ohio | 39099 | 18135 | 339 |
990702 | 990702 | 2021-02-02 | Marion | Ohio | 39101 | 7657 | 113 |
990703 | 990703 | 2021-02-02 | Medina | Ohio | 39103 | 12285 | 177 |
990704 | 990704 | 2021-02-02 | Meigs | Ohio | 39105 | 1197 | 25 |
990705 | 990705 | 2021-02-02 | Mercer | Ohio | 39107 | 4435 | 93 |
990706 | 990706 | 2021-02-02 | Miami | Ohio | 39109 | 9527 | 73 |
990707 | 990707 | 2021-02-02 | Monroe | Ohio | 39111 | 1080 | 35 |
990708 | 990708 | 2021-02-02 | Montgomery | Ohio | 39113 | 44835 | 438 |
990709 | 990709 | 2021-02-02 | Morgan | Ohio | 39115 | 906 | 31 |
990710 | 990710 | 2021-02-02 | Morrow | Ohio | 39117 | 2424 | 4 |
990711 | 990711 | 2021-02-02 | Muskingum | Ohio | 39119 | 7504 | 42 |
990712 | 990712 | 2021-02-02 | Noble | Ohio | 39121 | 1233 | 41 |
990713 | 990713 | 2021-02-02 | Ottawa | Ohio | 39123 | 3053 | 47 |
990714 | 990714 | 2021-02-02 | Paulding | Ohio | 39125 | 1509 | 21 |
990715 | 990715 | 2021-02-02 | Perry | Ohio | 39127 | 2462 | 18 |
990716 | 990716 | 2021-02-02 | Pickaway | Ohio | 39129 | 7581 | 50 |
990717 | 990717 | 2021-02-02 | Pike | Ohio | 39131 | 1926 | 19 |
990718 | 990718 | 2021-02-02 | Portage | Ohio | 39133 | 9973 | 115 |
990719 | 990719 | 2021-02-02 | Preble | Ohio | 39135 | 3320 | 37 |
990720 | 990720 | 2021-02-02 | Putnam | Ohio | 39137 | 3865 | 76 |
990721 | 990721 | 2021-02-02 | Richland | Ohio | 39139 | 9605 | 146 |
990722 | 990722 | 2021-02-02 | Ross | Ohio | 39141 | 5739 | 104 |
990723 | 990723 | 2021-02-02 | Sandusky | Ohio | 39143 | 4511 | 64 |
990724 | 990724 | 2021-02-02 | Scioto | Ohio | 39145 | 5578 | 68 |
990725 | 990725 | 2021-02-02 | Seneca | Ohio | 39147 | 4455 | 67 |
990726 | 990726 | 2021-02-02 | Shelby | Ohio | 39149 | 4288 | 24 |
990727 | 990727 | 2021-02-02 | Stark | Ohio | 39151 | 27202 | 466 |
990728 | 990728 | 2021-02-02 | Summit | Ohio | 39153 | 36733 | 811 |
990729 | 990729 | 2021-02-02 | Trumbull | Ohio | 39155 | 13329 | 325 |
990730 | 990730 | 2021-02-02 | Tuscarawas | Ohio | 39157 | 7665 | 191 |
990731 | 990731 | 2021-02-02 | Union | Ohio | 39159 | 4773 | 31 |
990732 | 990732 | 2021-02-02 | Van Wert | Ohio | 39161 | 2103 | 46 |
990733 | 990733 | 2021-02-02 | Vinton | Ohio | 39163 | 733 | 14 |
990734 | 990734 | 2021-02-02 | Warren | Ohio | 39165 | 20726 | 150 |
990735 | 990735 | 2021-02-02 | Washington | Ohio | 39167 | 4117 | 51 |
990736 | 990736 | 2021-02-02 | Wayne | Ohio | 39169 | 7397 | 175 |
990737 | 990737 | 2021-02-02 | Williams | Ohio | 39171 | 2883 | 73 |
990738 | 990738 | 2021-02-02 | Wood | Ohio | 39173 | 10870 | 159 |
990739 | 990739 | 2021-02-02 | Wyandot | Ohio | 39175 | 2020 | 51 |
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);