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-05-18 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 |
---|---|---|---|---|---|---|---|
1331547 | 1331547 | 2021-05-18 | Adams | Ohio | 39001 | 2401 | 54 |
1331548 | 1331548 | 2021-05-18 | Allen | Ohio | 39003 | 11752 | 233 |
1331549 | 1331549 | 2021-05-18 | Ashland | Ohio | 39005 | 4270 | 90 |
1331550 | 1331550 | 2021-05-18 | Ashtabula | Ohio | 39007 | 6918 | 172 |
1331551 | 1331551 | 2021-05-18 | Athens | Ohio | 39009 | 5208 | 59 |
1331552 | 1331552 | 2021-05-18 | Auglaize | Ohio | 39011 | 4950 | 86 |
1331553 | 1331553 | 2021-05-18 | Belmont | Ohio | 39013 | 6001 | 171 |
1331554 | 1331554 | 2021-05-18 | Brown | Ohio | 39015 | 3978 | 57 |
1331555 | 1331555 | 2021-05-18 | Butler | Ohio | 39017 | 38567 | 588 |
1331556 | 1331556 | 2021-05-18 | Carroll | Ohio | 39019 | 1924 | 48 |
1331557 | 1331557 | 2021-05-18 | Champaign | Ohio | 39021 | 3356 | 58 |
1331558 | 1331558 | 2021-05-18 | Clark | Ohio | 39023 | 14107 | 301 |
1331559 | 1331559 | 2021-05-18 | Clermont | Ohio | 39025 | 19891 | 246 |
1331560 | 1331560 | 2021-05-18 | Clinton | Ohio | 39027 | 3747 | 64 |
1331561 | 1331561 | 2021-05-18 | Columbiana | Ohio | 39029 | 8888 | 229 |
1331562 | 1331562 | 2021-05-18 | Coshocton | Ohio | 39031 | 2665 | 57 |
1331563 | 1331563 | 2021-05-18 | Crawford | Ohio | 39033 | 3996 | 109 |
1331564 | 1331564 | 2021-05-18 | Cuyahoga | Ohio | 39035 | 113441 | 2139 |
1331565 | 1331565 | 2021-05-18 | Darke | Ohio | 39037 | 5376 | 126 |
1331566 | 1331566 | 2021-05-18 | Defiance | Ohio | 39039 | 4253 | 97 |
1331567 | 1331567 | 2021-05-18 | Delaware | Ohio | 39041 | 18617 | 133 |
1331568 | 1331568 | 2021-05-18 | Erie | Ohio | 39043 | 7967 | 157 |
1331569 | 1331569 | 2021-05-18 | Fairfield | Ohio | 39045 | 16339 | 201 |
1331570 | 1331570 | 2021-05-18 | Fayette | Ohio | 39047 | 2836 | 50 |
1331571 | 1331571 | 2021-05-18 | Franklin | Ohio | 39049 | 126903 | 1415 |
1331572 | 1331572 | 2021-05-18 | Fulton | Ohio | 39051 | 4269 | 70 |
1331573 | 1331573 | 2021-05-18 | Gallia | Ohio | 39053 | 2370 | 49 |
1331574 | 1331574 | 2021-05-18 | Geauga | Ohio | 39055 | 6746 | 149 |
1331575 | 1331575 | 2021-05-18 | Greene | Ohio | 39057 | 15143 | 246 |
1331576 | 1331576 | 2021-05-18 | Guernsey | Ohio | 39059 | 3180 | 53 |
1331577 | 1331577 | 2021-05-18 | Hamilton | Ohio | 39061 | 80476 | 1218 |
1331578 | 1331578 | 2021-05-18 | Hancock | Ohio | 39063 | 6961 | 130 |
1331579 | 1331579 | 2021-05-18 | Hardin | Ohio | 39065 | 2721 | 64 |
1331580 | 1331580 | 2021-05-18 | Harrison | Ohio | 39067 | 1098 | 37 |
1331581 | 1331581 | 2021-05-18 | Henry | Ohio | 39069 | 2705 | 67 |
1331582 | 1331582 | 2021-05-18 | Highland | Ohio | 39071 | 3567 | 62 |
1331583 | 1331583 | 2021-05-18 | Hocking | Ohio | 39073 | 2164 | 62 |
1331584 | 1331584 | 2021-05-18 | Holmes | Ohio | 39075 | 2625 | 101 |
1331585 | 1331585 | 2021-05-18 | Huron | Ohio | 39077 | 5469 | 120 |
1331586 | 1331586 | 2021-05-18 | Jackson | Ohio | 39079 | 3140 | 52 |
1331587 | 1331587 | 2021-05-18 | Jefferson | Ohio | 39081 | 5589 | 153 |
1331588 | 1331588 | 2021-05-18 | Knox | Ohio | 39083 | 4515 | 110 |
1331589 | 1331589 | 2021-05-18 | Lake | Ohio | 39085 | 20860 | 372 |
1331590 | 1331590 | 2021-05-18 | Lawrence | Ohio | 39087 | 5594 | 103 |
1331591 | 1331591 | 2021-05-18 | Licking | Ohio | 39089 | 16494 | 214 |
1331592 | 1331592 | 2021-05-18 | Logan | Ohio | 39091 | 3836 | 76 |
1331593 | 1331593 | 2021-05-18 | Lorain | Ohio | 39093 | 25226 | 489 |
1331594 | 1331594 | 2021-05-18 | Lucas | Ohio | 39095 | 42665 | 793 |
1331595 | 1331595 | 2021-05-18 | Madison | Ohio | 39097 | 4401 | 63 |
1331596 | 1331596 | 2021-05-18 | Mahoning | Ohio | 39099 | 21828 | 589 |
1331597 | 1331597 | 2021-05-18 | Marion | Ohio | 39101 | 8565 | 136 |
1331598 | 1331598 | 2021-05-18 | Medina | Ohio | 39103 | 15395 | 267 |
1331599 | 1331599 | 2021-05-18 | Meigs | Ohio | 39105 | 1455 | 40 |
1331600 | 1331600 | 2021-05-18 | Mercer | Ohio | 39107 | 4821 | 85 |
1331601 | 1331601 | 2021-05-18 | Miami | Ohio | 39109 | 10721 | 221 |
1331602 | 1331602 | 2021-05-18 | Monroe | Ohio | 39111 | 1325 | 42 |
1331603 | 1331603 | 2021-05-18 | Montgomery | Ohio | 39113 | 51858 | 1019 |
1331604 | 1331604 | 2021-05-18 | Morgan | Ohio | 39115 | 1088 | 23 |
1331605 | 1331605 | 2021-05-18 | Morrow | Ohio | 39117 | 2875 | 39 |
1331606 | 1331606 | 2021-05-18 | Muskingum | Ohio | 39119 | 8836 | 133 |
1331607 | 1331607 | 2021-05-18 | Noble | Ohio | 39121 | 1341 | 37 |
1331608 | 1331608 | 2021-05-18 | Ottawa | Ohio | 39123 | 3692 | 81 |
1331609 | 1331609 | 2021-05-18 | Paulding | Ohio | 39125 | 1745 | 41 |
1331610 | 1331610 | 2021-05-18 | Perry | Ohio | 39127 | 2959 | 50 |
1331611 | 1331611 | 2021-05-18 | Pickaway | Ohio | 39129 | 8601 | 121 |
1331612 | 1331612 | 2021-05-18 | Pike | Ohio | 39131 | 2392 | 34 |
1331613 | 1331613 | 2021-05-18 | Portage | Ohio | 39133 | 12981 | 210 |
1331614 | 1331614 | 2021-05-18 | Preble | Ohio | 39135 | 3813 | 99 |
1331615 | 1331615 | 2021-05-18 | Putnam | Ohio | 39137 | 4306 | 101 |
1331616 | 1331616 | 2021-05-18 | Richland | Ohio | 39139 | 11444 | 203 |
1331617 | 1331617 | 2021-05-18 | Ross | Ohio | 39141 | 6878 | 157 |
1331618 | 1331618 | 2021-05-18 | Sandusky | Ohio | 39143 | 5382 | 123 |
1331619 | 1331619 | 2021-05-18 | Scioto | Ohio | 39145 | 6451 | 103 |
1331620 | 1331620 | 2021-05-18 | Seneca | Ohio | 39147 | 5316 | 123 |
1331621 | 1331621 | 2021-05-18 | Shelby | Ohio | 39149 | 4707 | 93 |
1331622 | 1331622 | 2021-05-18 | Stark | Ohio | 39151 | 32726 | 911 |
1331623 | 1331623 | 2021-05-18 | Summit | Ohio | 39153 | 47670 | 961 |
1331624 | 1331624 | 2021-05-18 | Trumbull | Ohio | 39155 | 16218 | 469 |
1331625 | 1331625 | 2021-05-18 | Tuscarawas | Ohio | 39157 | 8515 | 245 |
1331626 | 1331626 | 2021-05-18 | Union | Ohio | 39159 | 5755 | 49 |
1331627 | 1331627 | 2021-05-18 | Unknown | Ohio | 0 | 2 | |
1331628 | 1331628 | 2021-05-18 | Van Wert | Ohio | 39161 | 2442 | 64 |
1331629 | 1331629 | 2021-05-18 | Vinton | Ohio | 39163 | 849 | 15 |
1331630 | 1331630 | 2021-05-18 | Warren | Ohio | 39165 | 24398 | 301 |
1331631 | 1331631 | 2021-05-18 | Washington | Ohio | 39167 | 5230 | 109 |
1331632 | 1331632 | 2021-05-18 | Wayne | Ohio | 39169 | 8936 | 214 |
1331633 | 1331633 | 2021-05-18 | Williams | Ohio | 39171 | 3438 | 77 |
1331634 | 1331634 | 2021-05-18 | Wood | Ohio | 39173 | 13177 | 192 |
1331635 | 1331635 | 2021-05-18 | Wyandot | Ohio | 39175 | 2322 | 56 |
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);