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 2021-08-03 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 |
---|---|---|---|---|---|---|---|
1581520 | 1581520 | 2021-08-03 | Adams | Ohio | 39001 | 2536 | 58 |
1581521 | 1581521 | 2021-08-03 | Allen | Ohio | 39003 | 12124 | 245 |
1581522 | 1581522 | 2021-08-03 | Ashland | Ohio | 39005 | 4501 | 98 |
1581523 | 1581523 | 2021-08-03 | Ashtabula | Ohio | 39007 | 7318 | 180 |
1581524 | 1581524 | 2021-08-03 | Athens | Ohio | 39009 | 5286 | 60 |
1581525 | 1581525 | 2021-08-03 | Auglaize | Ohio | 39011 | 5105 | 87 |
1581526 | 1581526 | 2021-08-03 | Belmont | Ohio | 39013 | 6261 | 179 |
1581527 | 1581527 | 2021-08-03 | Brown | Ohio | 39015 | 4141 | 63 |
1581528 | 1581528 | 2021-08-03 | Butler | Ohio | 39017 | 40324 | 615 |
1581529 | 1581529 | 2021-08-03 | Carroll | Ohio | 39019 | 2033 | 49 |
1581530 | 1581530 | 2021-08-03 | Champaign | Ohio | 39021 | 3517 | 60 |
1581531 | 1581531 | 2021-08-03 | Clark | Ohio | 39023 | 14439 | 309 |
1581532 | 1581532 | 2021-08-03 | Clermont | Ohio | 39025 | 20592 | 261 |
1581533 | 1581533 | 2021-08-03 | Clinton | Ohio | 39027 | 3956 | 67 |
1581534 | 1581534 | 2021-08-03 | Columbiana | Ohio | 39029 | 9282 | 236 |
1581535 | 1581535 | 2021-08-03 | Coshocton | Ohio | 39031 | 2751 | 61 |
1581536 | 1581536 | 2021-08-03 | Crawford | Ohio | 39033 | 4152 | 112 |
1581537 | 1581537 | 2021-08-03 | Cuyahoga | Ohio | 39035 | 118059 | 2268 |
1581538 | 1581538 | 2021-08-03 | Darke | Ohio | 39037 | 5476 | 131 |
1581539 | 1581539 | 2021-08-03 | Defiance | Ohio | 39039 | 4445 | 99 |
1581540 | 1581540 | 2021-08-03 | Delaware | Ohio | 39041 | 19295 | 138 |
1581541 | 1581541 | 2021-08-03 | Erie | Ohio | 39043 | 8220 | 166 |
1581542 | 1581542 | 2021-08-03 | Fairfield | Ohio | 39045 | 16959 | 207 |
1581543 | 1581543 | 2021-08-03 | Fayette | Ohio | 39047 | 2913 | 50 |
1581544 | 1581544 | 2021-08-03 | Franklin | Ohio | 39049 | 131291 | 1496 |
1581545 | 1581545 | 2021-08-03 | Fulton | Ohio | 39051 | 4432 | 75 |
1581546 | 1581546 | 2021-08-03 | Gallia | Ohio | 39053 | 2541 | 50 |
1581547 | 1581547 | 2021-08-03 | Geauga | Ohio | 39055 | 7032 | 153 |
1581548 | 1581548 | 2021-08-03 | Greene | Ohio | 39057 | 15721 | 254 |
1581549 | 1581549 | 2021-08-03 | Guernsey | Ohio | 39059 | 3340 | 54 |
1581550 | 1581550 | 2021-08-03 | Hamilton | Ohio | 39061 | 83023 | 1263 |
1581551 | 1581551 | 2021-08-03 | Hancock | Ohio | 39063 | 7080 | 135 |
1581552 | 1581552 | 2021-08-03 | Hardin | Ohio | 39065 | 2804 | 65 |
1581553 | 1581553 | 2021-08-03 | Harrison | Ohio | 39067 | 1157 | 38 |
1581554 | 1581554 | 2021-08-03 | Henry | Ohio | 39069 | 2790 | 67 |
1581555 | 1581555 | 2021-08-03 | Highland | Ohio | 39071 | 3707 | 68 |
1581556 | 1581556 | 2021-08-03 | Hocking | Ohio | 39073 | 2241 | 63 |
1581557 | 1581557 | 2021-08-03 | Holmes | Ohio | 39075 | 2735 | 102 |
1581558 | 1581558 | 2021-08-03 | Huron | Ohio | 39077 | 5678 | 122 |
1581559 | 1581559 | 2021-08-03 | Jackson | Ohio | 39079 | 3249 | 54 |
1581560 | 1581560 | 2021-08-03 | Jefferson | Ohio | 39081 | 5787 | 162 |
1581561 | 1581561 | 2021-08-03 | Knox | Ohio | 39083 | 4678 | 112 |
1581562 | 1581562 | 2021-08-03 | Lake | Ohio | 39085 | 21602 | 397 |
1581563 | 1581563 | 2021-08-03 | Lawrence | Ohio | 39087 | 6033 | 106 |
1581564 | 1581564 | 2021-08-03 | Licking | Ohio | 39089 | 16977 | 227 |
1581565 | 1581565 | 2021-08-03 | Logan | Ohio | 39091 | 3963 | 79 |
1581566 | 1581566 | 2021-08-03 | Lorain | Ohio | 39093 | 26232 | 511 |
1581567 | 1581567 | 2021-08-03 | Lucas | Ohio | 39095 | 43982 | 835 |
1581568 | 1581568 | 2021-08-03 | Madison | Ohio | 39097 | 4500 | 66 |
1581569 | 1581569 | 2021-08-03 | Mahoning | Ohio | 39099 | 22881 | 614 |
1581570 | 1581570 | 2021-08-03 | Marion | Ohio | 39101 | 8774 | 140 |
1581571 | 1581571 | 2021-08-03 | Medina | Ohio | 39103 | 16019 | 278 |
1581572 | 1581572 | 2021-08-03 | Meigs | Ohio | 39105 | 1539 | 40 |
1581573 | 1581573 | 2021-08-03 | Mercer | Ohio | 39107 | 4928 | 85 |
1581574 | 1581574 | 2021-08-03 | Miami | Ohio | 39109 | 11140 | 229 |
1581575 | 1581575 | 2021-08-03 | Monroe | Ohio | 39111 | 1394 | 46 |
1581576 | 1581576 | 2021-08-03 | Montgomery | Ohio | 39113 | 54190 | 1064 |
1581577 | 1581577 | 2021-08-03 | Morgan | Ohio | 39115 | 1120 | 24 |
1581578 | 1581578 | 2021-08-03 | Morrow | Ohio | 39117 | 2985 | 44 |
1581579 | 1581579 | 2021-08-03 | Muskingum | Ohio | 39119 | 9207 | 137 |
1581580 | 1581580 | 2021-08-03 | Noble | Ohio | 39121 | 1387 | 39 |
1581581 | 1581581 | 2021-08-03 | Ottawa | Ohio | 39123 | 3782 | 81 |
1581582 | 1581582 | 2021-08-03 | Paulding | Ohio | 39125 | 1815 | 42 |
1581583 | 1581583 | 2021-08-03 | Perry | Ohio | 39127 | 3005 | 50 |
1581584 | 1581584 | 2021-08-03 | Pickaway | Ohio | 39129 | 8796 | 123 |
1581585 | 1581585 | 2021-08-03 | Pike | Ohio | 39131 | 2471 | 37 |
1581586 | 1581586 | 2021-08-03 | Portage | Ohio | 39133 | 13548 | 219 |
1581587 | 1581587 | 2021-08-03 | Preble | Ohio | 39135 | 3988 | 107 |
1581588 | 1581588 | 2021-08-03 | Putnam | Ohio | 39137 | 4366 | 104 |
1581589 | 1581589 | 2021-08-03 | Richland | Ohio | 39139 | 11870 | 214 |
1581590 | 1581590 | 2021-08-03 | Ross | Ohio | 39141 | 7070 | 165 |
1581591 | 1581591 | 2021-08-03 | Sandusky | Ohio | 39143 | 5536 | 130 |
1581592 | 1581592 | 2021-08-03 | Scioto | Ohio | 39145 | 6887 | 108 |
1581593 | 1581593 | 2021-08-03 | Seneca | Ohio | 39147 | 5391 | 128 |
1581594 | 1581594 | 2021-08-03 | Shelby | Ohio | 39149 | 4877 | 98 |
1581595 | 1581595 | 2021-08-03 | Stark | Ohio | 39151 | 34056 | 941 |
1581596 | 1581596 | 2021-08-03 | Summit | Ohio | 39153 | 49189 | 1018 |
1581597 | 1581597 | 2021-08-03 | Trumbull | Ohio | 39155 | 16940 | 493 |
1581598 | 1581598 | 2021-08-03 | Tuscarawas | Ohio | 39157 | 8756 | 257 |
1581599 | 1581599 | 2021-08-03 | Union | Ohio | 39159 | 5951 | 49 |
1581600 | 1581600 | 2021-08-03 | Unknown | Ohio | 0 | 4 | |
1581601 | 1581601 | 2021-08-03 | Van Wert | Ohio | 39161 | 2544 | 65 |
1581602 | 1581602 | 2021-08-03 | Vinton | Ohio | 39163 | 882 | 17 |
1581603 | 1581603 | 2021-08-03 | Warren | Ohio | 39165 | 25125 | 312 |
1581604 | 1581604 | 2021-08-03 | Washington | Ohio | 39167 | 5391 | 111 |
1581605 | 1581605 | 2021-08-03 | Wayne | Ohio | 39169 | 9344 | 228 |
1581606 | 1581606 | 2021-08-03 | Williams | Ohio | 39171 | 3618 | 78 |
1581607 | 1581607 | 2021-08-03 | Wood | Ohio | 39173 | 13411 | 201 |
1581608 | 1581608 | 2021-08-03 | Wyandot | Ohio | 39175 | 2365 | 57 |
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);