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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 89
- 39035 796
- 39151 794
- 39155 793
- 39013 791
- 39017 791
- 39049 791
- 39093 791
- 39153 791
- 39157 791
- 39095 790
- 39103 790
- 39055 789
- 39031 788
- 39037 788
- 39085 788
- 39099 788
- 39005 787
- 39023 787
- 39041 787
- 39077 787
- 39109 787
- 39061 786
- 39113 786
- 39139 786
- 39007 785
- 39029 785
- 39101 785
- 39159 785
- 39165 785
- 39025 784
- 39039 784
- 39043 784
- 39089 784
- 39019 783
- 39027 783
- 39053 783
- 39057 783
- 39063 783
- 39133 783
- 39173 783
- 39083 782
- 39091 782
- 39097 782
- 39143 782
- 39167 782
- 39021 781
- 39033 781
- 39045 781
- 39071 781
- 39047 780
- 39087 780
- 39107 780
- 39129 780
- 39147 780
- 39169 780
- 39009 779
- 39081 779
- 39119 779
- 39175 779
- 39051 778
- 39149 778
- 39003 777
- 39011 777
- 39123 777
- 39131 777
- 39161 777
- 39015 775
- 39075 775
- 39135 775
- 39141 775
- 39127 774
- 39117 773
- 39059 772
- 39065 772
- 39171 772
- 39001 770
- 39111 769
- 39115 768
- 39125 768
- 39137 768
- 39145 768
- 39105 767
- 39069 766
- 39079 766
- 39121 765
- 39073 763
- 39067 759
- 39163 746
- - 439
county 89
- Cuyahoga 796
- Stark 794
- Trumbull 793
- Belmont 791
- Butler 791
- Franklin 791
- Lorain 791
- Summit 791
- Tuscarawas 791
- Lucas 790
- Medina 790
- Geauga 789
- Coshocton 788
- Darke 788
- Lake 788
- Mahoning 788
- Ashland 787
- Clark 787
- Delaware 787
- Huron 787
- Miami 787
- Hamilton 786
- Montgomery 786
- Richland 786
- Ashtabula 785
- Columbiana 785
- Marion 785
- Union 785
- Warren 785
- Clermont 784
- Defiance 784
- Erie 784
- Licking 784
- Carroll 783
- Clinton 783
- Gallia 783
- Greene 783
- Hancock 783
- Portage 783
- Wood 783
- Knox 782
- Logan 782
- Madison 782
- Sandusky 782
- Washington 782
- Champaign 781
- Crawford 781
- Fairfield 781
- Highland 781
- Fayette 780
- Lawrence 780
- Mercer 780
- Pickaway 780
- Seneca 780
- Wayne 780
- Athens 779
- Jefferson 779
- Muskingum 779
- Wyandot 779
- Fulton 778
- Shelby 778
- Allen 777
- Auglaize 777
- Ottawa 777
- Pike 777
- Van Wert 777
- Brown 775
- Holmes 775
- Preble 775
- Ross 775
- Perry 774
- Morrow 773
- Guernsey 772
- Hardin 772
- Williams 772
- Adams 770
- Monroe 769
- Morgan 768
- Paulding 768
- Putnam 768
- Scioto 768
- Meigs 767
- Henry 766
- Jackson 766
- Noble 765
- Hocking 763
- Harrison 759
- Vinton 746
- Unknown 439
state 1
- Ohio · 69,101 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
956 | 956 | 2020-03-09 | Cuyahoga | Ohio | 39035 | 3 | 0 |
1107 | 1107 | 2020-03-10 | Cuyahoga | Ohio | 39035 | 3 | 0 |
1295 | 1295 | 2020-03-11 | Cuyahoga | Ohio | 39035 | 3 | 0 |
1296 | 1296 | 2020-03-11 | Stark | Ohio | 39151 | 1 | 0 |
1537 | 1537 | 2020-03-12 | Cuyahoga | Ohio | 39035 | 3 | 0 |
1538 | 1538 | 2020-03-12 | Stark | Ohio | 39151 | 1 | 0 |
1539 | 1539 | 2020-03-12 | Trumbull | Ohio | 39155 | 1 | 0 |
1832 | 1832 | 2020-03-13 | Cuyahoga | Ohio | 39035 | 11 | 0 |
1833 | 1833 | 2020-03-13 | Stark | Ohio | 39151 | 1 | 0 |
1834 | 1834 | 2020-03-13 | Trumbull | Ohio | 39155 | 1 | 0 |
2186 | 2186 | 2020-03-14 | Belmont | Ohio | 39013 | 2 | 0 |
2187 | 2187 | 2020-03-14 | Butler | Ohio | 39017 | 4 | 0 |
2188 | 2188 | 2020-03-14 | Cuyahoga | Ohio | 39035 | 11 | 0 |
2189 | 2189 | 2020-03-14 | Franklin | Ohio | 39049 | 1 | 0 |
2190 | 2190 | 2020-03-14 | Lorain | Ohio | 39093 | 1 | 0 |
2191 | 2191 | 2020-03-14 | Stark | Ohio | 39151 | 2 | 0 |
2192 | 2192 | 2020-03-14 | Summit | Ohio | 39153 | 2 | 0 |
2193 | 2193 | 2020-03-14 | Trumbull | Ohio | 39155 | 2 | 0 |
2194 | 2194 | 2020-03-14 | Tuscarawas | Ohio | 39157 | 1 | 0 |
2600 | 2600 | 2020-03-15 | Belmont | Ohio | 39013 | 2 | 0 |
2601 | 2601 | 2020-03-15 | Butler | Ohio | 39017 | 6 | 0 |
2602 | 2602 | 2020-03-15 | Cuyahoga | Ohio | 39035 | 14 | 0 |
2603 | 2603 | 2020-03-15 | Franklin | Ohio | 39049 | 3 | 0 |
2604 | 2604 | 2020-03-15 | Lorain | Ohio | 39093 | 2 | 0 |
2605 | 2605 | 2020-03-15 | Lucas | Ohio | 39095 | 1 | 0 |
2606 | 2606 | 2020-03-15 | Medina | Ohio | 39103 | 1 | 0 |
2607 | 2607 | 2020-03-15 | Stark | Ohio | 39151 | 3 | 0 |
2608 | 2608 | 2020-03-15 | Summit | Ohio | 39153 | 2 | 0 |
2609 | 2609 | 2020-03-15 | Trumbull | Ohio | 39155 | 2 | 0 |
2610 | 2610 | 2020-03-15 | Tuscarawas | Ohio | 39157 | 1 | 0 |
3062 | 3062 | 2020-03-16 | Belmont | Ohio | 39013 | 2 | 0 |
3063 | 3063 | 2020-03-16 | Butler | Ohio | 39017 | 6 | 0 |
3064 | 3064 | 2020-03-16 | Cuyahoga | Ohio | 39035 | 24 | 0 |
3065 | 3065 | 2020-03-16 | Franklin | Ohio | 39049 | 3 | 0 |
3066 | 3066 | 2020-03-16 | Geauga | Ohio | 39055 | 1 | 0 |
3067 | 3067 | 2020-03-16 | Lorain | Ohio | 39093 | 3 | 0 |
3068 | 3068 | 2020-03-16 | Lucas | Ohio | 39095 | 1 | 0 |
3069 | 3069 | 2020-03-16 | Medina | Ohio | 39103 | 2 | 0 |
3070 | 3070 | 2020-03-16 | Stark | Ohio | 39151 | 3 | 0 |
3071 | 3071 | 2020-03-16 | Summit | Ohio | 39153 | 2 | 0 |
3072 | 3072 | 2020-03-16 | Trumbull | Ohio | 39155 | 2 | 0 |
3073 | 3073 | 2020-03-16 | Tuscarawas | Ohio | 39157 | 1 | 0 |
3585 | 3585 | 2020-03-17 | Belmont | Ohio | 39013 | 2 | 0 |
3586 | 3586 | 2020-03-17 | Butler | Ohio | 39017 | 6 | 0 |
3587 | 3587 | 2020-03-17 | Coshocton | Ohio | 39031 | 2 | 0 |
3588 | 3588 | 2020-03-17 | Cuyahoga | Ohio | 39035 | 31 | 0 |
3589 | 3589 | 2020-03-17 | Darke | Ohio | 39037 | 1 | 0 |
3590 | 3590 | 2020-03-17 | Franklin | Ohio | 39049 | 4 | 0 |
3591 | 3591 | 2020-03-17 | Geauga | Ohio | 39055 | 1 | 0 |
3592 | 3592 | 2020-03-17 | Lake | Ohio | 39085 | 1 | 0 |
3593 | 3593 | 2020-03-17 | Lorain | Ohio | 39093 | 4 | 0 |
3594 | 3594 | 2020-03-17 | Lucas | Ohio | 39095 | 1 | 0 |
3595 | 3595 | 2020-03-17 | Mahoning | Ohio | 39099 | 1 | 0 |
3596 | 3596 | 2020-03-17 | Medina | Ohio | 39103 | 3 | 0 |
3597 | 3597 | 2020-03-17 | Stark | Ohio | 39151 | 3 | 0 |
3598 | 3598 | 2020-03-17 | Summit | Ohio | 39153 | 4 | 0 |
3599 | 3599 | 2020-03-17 | Trumbull | Ohio | 39155 | 2 | 0 |
3600 | 3600 | 2020-03-17 | Tuscarawas | Ohio | 39157 | 1 | 0 |
4195 | 4195 | 2020-03-18 | Ashland | Ohio | 39005 | 1 | 0 |
4196 | 4196 | 2020-03-18 | Belmont | Ohio | 39013 | 2 | 0 |
4197 | 4197 | 2020-03-18 | Butler | Ohio | 39017 | 8 | 0 |
4198 | 4198 | 2020-03-18 | Clark | Ohio | 39023 | 1 | 0 |
4199 | 4199 | 2020-03-18 | Coshocton | Ohio | 39031 | 2 | 0 |
4200 | 4200 | 2020-03-18 | Cuyahoga | Ohio | 39035 | 38 | 0 |
4201 | 4201 | 2020-03-18 | Darke | Ohio | 39037 | 1 | 0 |
4202 | 4202 | 2020-03-18 | Delaware | Ohio | 39041 | 1 | 0 |
4203 | 4203 | 2020-03-18 | Franklin | Ohio | 39049 | 7 | 0 |
4204 | 4204 | 2020-03-18 | Geauga | Ohio | 39055 | 1 | 0 |
4205 | 4205 | 2020-03-18 | Huron | Ohio | 39077 | 1 | 0 |
4206 | 4206 | 2020-03-18 | Lake | Ohio | 39085 | 2 | 0 |
4207 | 4207 | 2020-03-18 | Lorain | Ohio | 39093 | 6 | 0 |
4208 | 4208 | 2020-03-18 | Lucas | Ohio | 39095 | 1 | 0 |
4209 | 4209 | 2020-03-18 | Mahoning | Ohio | 39099 | 3 | 0 |
4210 | 4210 | 2020-03-18 | Medina | Ohio | 39103 | 4 | 0 |
4211 | 4211 | 2020-03-18 | Miami | Ohio | 39109 | 1 | 0 |
4212 | 4212 | 2020-03-18 | Stark | Ohio | 39151 | 3 | 0 |
4213 | 4213 | 2020-03-18 | Summit | Ohio | 39153 | 4 | 0 |
4214 | 4214 | 2020-03-18 | Trumbull | Ohio | 39155 | 2 | 0 |
4215 | 4215 | 2020-03-18 | Tuscarawas | Ohio | 39157 | 1 | 0 |
4926 | 4926 | 2020-03-19 | Ashland | Ohio | 39005 | 1 | 0 |
4927 | 4927 | 2020-03-19 | Belmont | Ohio | 39013 | 2 | 0 |
4928 | 4928 | 2020-03-19 | Butler | Ohio | 39017 | 8 | 0 |
4929 | 4929 | 2020-03-19 | Clark | Ohio | 39023 | 1 | 0 |
4930 | 4930 | 2020-03-19 | Coshocton | Ohio | 39031 | 2 | 0 |
4931 | 4931 | 2020-03-19 | Cuyahoga | Ohio | 39035 | 53 | 0 |
4932 | 4932 | 2020-03-19 | Darke | Ohio | 39037 | 1 | 0 |
4933 | 4933 | 2020-03-19 | Delaware | Ohio | 39041 | 2 | 0 |
4934 | 4934 | 2020-03-19 | Franklin | Ohio | 39049 | 10 | 0 |
4935 | 4935 | 2020-03-19 | Geauga | Ohio | 39055 | 1 | 0 |
4936 | 4936 | 2020-03-19 | Hamilton | Ohio | 39061 | 2 | 0 |
4937 | 4937 | 2020-03-19 | Huron | Ohio | 39077 | 1 | 0 |
4938 | 4938 | 2020-03-19 | Lake | Ohio | 39085 | 2 | 0 |
4939 | 4939 | 2020-03-19 | Lorain | Ohio | 39093 | 6 | 0 |
4940 | 4940 | 2020-03-19 | Lucas | Ohio | 39095 | 1 | 0 |
4941 | 4941 | 2020-03-19 | Mahoning | Ohio | 39099 | 5 | 0 |
4942 | 4942 | 2020-03-19 | Medina | Ohio | 39103 | 5 | 0 |
4943 | 4943 | 2020-03-19 | Miami | Ohio | 39109 | 1 | 0 |
4944 | 4944 | 2020-03-19 | Montgomery | Ohio | 39113 | 1 | 0 |
4945 | 4945 | 2020-03-19 | Richland | Ohio | 39139 | 1 | 0 |
4946 | 4946 | 2020-03-19 | Stark | Ohio | 39151 | 5 | 0 |
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);