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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 39153 786
- 39155 786
- 39157 786
- 39005 785
- 39007 785
- 39013 785
- 39017 785
- 39023 785
- 39029 785
- 39031 785
- 39035 785
- 39037 785
- 39041 785
- 39049 785
- 39055 785
- 39061 785
- 39077 785
- 39085 785
- 39093 785
- 39095 785
- 39099 785
- 39101 785
- 39103 785
- 39109 785
- 39113 785
- 39139 785
- 39151 785
- 39159 785
- 39165 785
- 39025 784
- …
county >30
- Summit 786
- Trumbull 786
- Tuscarawas 786
- Ashland 785
- Ashtabula 785
- Belmont 785
- Butler 785
- Clark 785
- Columbiana 785
- Coshocton 785
- Cuyahoga 785
- Darke 785
- Delaware 785
- Franklin 785
- Geauga 785
- Hamilton 785
- Huron 785
- Lake 785
- Lorain 785
- Lucas 785
- Mahoning 785
- Marion 785
- Medina 785
- Miami 785
- Montgomery 785
- Richland 785
- Stark 785
- Union 785
- Warren 785
- Clermont 784
- …
state 1
- Ohio · 69,001 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4947 | 4947 | 2020-03-19 | Summit | Ohio | 39153 | 6 | 0 |
4948 | 4948 | 2020-03-19 | Trumbull | Ohio | 39155 | 2 | 0 |
4949 | 4949 | 2020-03-19 | Tuscarawas | Ohio | 39157 | 1 | 0 |
5787 | 5787 | 2020-03-20 | Ashland | Ohio | 39005 | 1 | 0 |
5788 | 5788 | 2020-03-20 | Ashtabula | Ohio | 39007 | 1 | 0 |
5789 | 5789 | 2020-03-20 | Belmont | Ohio | 39013 | 2 | 0 |
5790 | 5790 | 2020-03-20 | Butler | Ohio | 39017 | 12 | 0 |
5791 | 5791 | 2020-03-20 | Clark | Ohio | 39023 | 1 | 0 |
5792 | 5792 | 2020-03-20 | Columbiana | Ohio | 39029 | 1 | 0 |
5793 | 5793 | 2020-03-20 | Coshocton | Ohio | 39031 | 2 | 0 |
5794 | 5794 | 2020-03-20 | Cuyahoga | Ohio | 39035 | 69 | 0 |
5795 | 5795 | 2020-03-20 | Darke | Ohio | 39037 | 1 | 0 |
5796 | 5796 | 2020-03-20 | Delaware | Ohio | 39041 | 2 | 0 |
5797 | 5797 | 2020-03-20 | Franklin | Ohio | 39049 | 14 | 0 |
5798 | 5798 | 2020-03-20 | Geauga | Ohio | 39055 | 1 | 0 |
5799 | 5799 | 2020-03-20 | Hamilton | Ohio | 39061 | 7 | 0 |
5800 | 5800 | 2020-03-20 | Huron | Ohio | 39077 | 1 | 0 |
5801 | 5801 | 2020-03-20 | Lake | Ohio | 39085 | 3 | 0 |
5802 | 5802 | 2020-03-20 | Lorain | Ohio | 39093 | 10 | 0 |
5803 | 5803 | 2020-03-20 | Lucas | Ohio | 39095 | 2 | 1 |
5804 | 5804 | 2020-03-20 | Mahoning | Ohio | 39099 | 7 | 0 |
5805 | 5805 | 2020-03-20 | Marion | Ohio | 39101 | 1 | 0 |
5806 | 5806 | 2020-03-20 | Medina | Ohio | 39103 | 5 | 0 |
5807 | 5807 | 2020-03-20 | Miami | Ohio | 39109 | 1 | 0 |
5808 | 5808 | 2020-03-20 | Montgomery | Ohio | 39113 | 1 | 0 |
5809 | 5809 | 2020-03-20 | Richland | Ohio | 39139 | 1 | 0 |
5810 | 5810 | 2020-03-20 | Stark | Ohio | 39151 | 6 | 0 |
5811 | 5811 | 2020-03-20 | Summit | Ohio | 39153 | 10 | 0 |
5812 | 5812 | 2020-03-20 | Trumbull | Ohio | 39155 | 3 | 0 |
5813 | 5813 | 2020-03-20 | Tuscarawas | Ohio | 39157 | 1 | 0 |
5814 | 5814 | 2020-03-20 | Union | Ohio | 39159 | 1 | 0 |
5815 | 5815 | 2020-03-20 | Warren | Ohio | 39165 | 2 | 0 |
6784 | 6784 | 2020-03-21 | Ashland | Ohio | 39005 | 1 | 0 |
6785 | 6785 | 2020-03-21 | Ashtabula | Ohio | 39007 | 1 | 0 |
6786 | 6786 | 2020-03-21 | Belmont | Ohio | 39013 | 2 | 0 |
6787 | 6787 | 2020-03-21 | Butler | Ohio | 39017 | 16 | 0 |
6788 | 6788 | 2020-03-21 | Clark | Ohio | 39023 | 1 | 0 |
6789 | 6789 | 2020-03-21 | Clermont | Ohio | 39025 | 2 | 0 |
6790 | 6790 | 2020-03-21 | Columbiana | Ohio | 39029 | 1 | 0 |
6791 | 6791 | 2020-03-21 | Coshocton | Ohio | 39031 | 2 | 0 |
6792 | 6792 | 2020-03-21 | Cuyahoga | Ohio | 39035 | 92 | 1 |
6793 | 6793 | 2020-03-21 | Darke | Ohio | 39037 | 1 | 0 |
6794 | 6794 | 2020-03-21 | Defiance | Ohio | 39039 | 2 | 0 |
6795 | 6795 | 2020-03-21 | Delaware | Ohio | 39041 | 4 | 0 |
6796 | 6796 | 2020-03-21 | Erie | Ohio | 39043 | 1 | 1 |
6797 | 6797 | 2020-03-21 | Franklin | Ohio | 39049 | 21 | 0 |
6798 | 6798 | 2020-03-21 | Geauga | Ohio | 39055 | 1 | 0 |
6799 | 6799 | 2020-03-21 | Hamilton | Ohio | 39061 | 8 | 0 |
6800 | 6800 | 2020-03-21 | Huron | Ohio | 39077 | 1 | 0 |
6801 | 6801 | 2020-03-21 | Lake | Ohio | 39085 | 4 | 0 |
6802 | 6802 | 2020-03-21 | Licking | Ohio | 39089 | 1 | 0 |
6803 | 6803 | 2020-03-21 | Lorain | Ohio | 39093 | 14 | 0 |
6804 | 6804 | 2020-03-21 | Lucas | Ohio | 39095 | 4 | 1 |
6805 | 6805 | 2020-03-21 | Mahoning | Ohio | 39099 | 14 | 0 |
6806 | 6806 | 2020-03-21 | Marion | Ohio | 39101 | 1 | 0 |
6807 | 6807 | 2020-03-21 | Medina | Ohio | 39103 | 9 | 0 |
6808 | 6808 | 2020-03-21 | Miami | Ohio | 39109 | 11 | 0 |
6809 | 6809 | 2020-03-21 | Montgomery | Ohio | 39113 | 1 | 0 |
6810 | 6810 | 2020-03-21 | Richland | Ohio | 39139 | 1 | 0 |
6811 | 6811 | 2020-03-21 | Stark | Ohio | 39151 | 8 | 0 |
6812 | 6812 | 2020-03-21 | Summit | Ohio | 39153 | 15 | 0 |
6813 | 6813 | 2020-03-21 | Trumbull | Ohio | 39155 | 3 | 0 |
6814 | 6814 | 2020-03-21 | Tuscarawas | Ohio | 39157 | 1 | 0 |
6815 | 6815 | 2020-03-21 | Union | Ohio | 39159 | 1 | 0 |
6816 | 6816 | 2020-03-21 | Warren | Ohio | 39165 | 2 | 0 |
7890 | 7890 | 2020-03-22 | Ashland | Ohio | 39005 | 1 | 0 |
7891 | 7891 | 2020-03-22 | Ashtabula | Ohio | 39007 | 2 | 0 |
7892 | 7892 | 2020-03-22 | Belmont | Ohio | 39013 | 2 | 0 |
7893 | 7893 | 2020-03-22 | Butler | Ohio | 39017 | 17 | 0 |
7894 | 7894 | 2020-03-22 | Carroll | Ohio | 39019 | 1 | 0 |
7895 | 7895 | 2020-03-22 | Clark | Ohio | 39023 | 1 | 0 |
7896 | 7896 | 2020-03-22 | Clermont | Ohio | 39025 | 5 | 0 |
7897 | 7897 | 2020-03-22 | Clinton | Ohio | 39027 | 1 | 0 |
7898 | 7898 | 2020-03-22 | Columbiana | Ohio | 39029 | 2 | 0 |
7899 | 7899 | 2020-03-22 | Coshocton | Ohio | 39031 | 2 | 0 |
7900 | 7900 | 2020-03-22 | Cuyahoga | Ohio | 39035 | 125 | 1 |
7901 | 7901 | 2020-03-22 | Darke | Ohio | 39037 | 1 | 0 |
7902 | 7902 | 2020-03-22 | Defiance | Ohio | 39039 | 2 | 0 |
7903 | 7903 | 2020-03-22 | Delaware | Ohio | 39041 | 6 | 0 |
7904 | 7904 | 2020-03-22 | Erie | Ohio | 39043 | 1 | 1 |
7905 | 7905 | 2020-03-22 | Franklin | Ohio | 39049 | 34 | 0 |
7906 | 7906 | 2020-03-22 | Gallia | Ohio | 39053 | 1 | 0 |
7907 | 7907 | 2020-03-22 | Geauga | Ohio | 39055 | 2 | 0 |
7908 | 7908 | 2020-03-22 | Greene | Ohio | 39057 | 1 | 0 |
7909 | 7909 | 2020-03-22 | Hamilton | Ohio | 39061 | 19 | 0 |
7910 | 7910 | 2020-03-22 | Hancock | Ohio | 39063 | 1 | 0 |
7911 | 7911 | 2020-03-22 | Huron | Ohio | 39077 | 1 | 0 |
7912 | 7912 | 2020-03-22 | Lake | Ohio | 39085 | 6 | 0 |
7913 | 7913 | 2020-03-22 | Licking | Ohio | 39089 | 1 | 0 |
7914 | 7914 | 2020-03-22 | Lorain | Ohio | 39093 | 19 | 0 |
7915 | 7915 | 2020-03-22 | Lucas | Ohio | 39095 | 5 | 1 |
7916 | 7916 | 2020-03-22 | Mahoning | Ohio | 39099 | 18 | 0 |
7917 | 7917 | 2020-03-22 | Marion | Ohio | 39101 | 1 | 0 |
7918 | 7918 | 2020-03-22 | Medina | Ohio | 39103 | 10 | 0 |
7919 | 7919 | 2020-03-22 | Miami | Ohio | 39109 | 13 | 0 |
7920 | 7920 | 2020-03-22 | Montgomery | Ohio | 39113 | 5 | 0 |
7921 | 7921 | 2020-03-22 | Portage | Ohio | 39133 | 1 | 0 |
7922 | 7922 | 2020-03-22 | Richland | Ohio | 39139 | 1 | 0 |
7923 | 7923 | 2020-03-22 | Stark | Ohio | 39151 | 10 | 0 |
7924 | 7924 | 2020-03-22 | Summit | Ohio | 39153 | 23 | 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);