ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

8,913 rows where state = "Ohio" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Ohio · 8,913
Link rowid date ▲ county state fips cases deaths
293760 2020-07-03 Adams Ohio 39001 22 1
293761 2020-07-03 Allen Ohio 39003 305 40
293762 2020-07-03 Ashland Ohio 39005 58 1
293763 2020-07-03 Ashtabula Ohio 39007 425 44
293764 2020-07-03 Athens Ohio 39009 43 1
293765 2020-07-03 Auglaize Ohio 39011 104 4
293766 2020-07-03 Belmont Ohio 39013 543 22
293767 2020-07-03 Brown Ohio 39015 54 1
293768 2020-07-03 Butler Ohio 39017 1511 44
293769 2020-07-03 Carroll Ohio 39019 58 3
293770 2020-07-03 Champaign Ohio 39021 39 1
293771 2020-07-03 Clark Ohio 39023 761 9
293772 2020-07-03 Clermont Ohio 39025 390 6
293773 2020-07-03 Clinton Ohio 39027 66 0
293774 2020-07-03 Columbiana Ohio 39029 1288 60
293775 2020-07-03 Coshocton Ohio 39031 90 2
293776 2020-07-03 Crawford Ohio 39033 134 5
293777 2020-07-03 Cuyahoga Ohio 39035 7392 372
293778 2020-07-03 Darke Ohio 39037 245 25
293779 2020-07-03 Defiance Ohio 39039 49 3
293780 2020-07-03 Delaware Ohio 39041 541 15
293781 2020-07-03 Erie Ohio 39043 234 22
293782 2020-07-03 Fairfield Ohio 39045 529 16
293783 2020-07-03 Fayette Ohio 39047 46 0
293784 2020-07-03 Franklin Ohio 39049 9825 417
293785 2020-07-03 Fulton Ohio 39051 61 0
293786 2020-07-03 Gallia Ohio 39053 14 1
293787 2020-07-03 Geauga Ohio 39055 399 42
293788 2020-07-03 Greene Ohio 39057 244 9
293789 2020-07-03 Guernsey Ohio 39059 67 3
293790 2020-07-03 Hamilton Ohio 39061 5605 197
293791 2020-07-03 Hancock Ohio 39063 78 1
293792 2020-07-03 Hardin Ohio 39065 120 12
293793 2020-07-03 Harrison Ohio 39067 12 1
293794 2020-07-03 Henry Ohio 39069 29 0
293795 2020-07-03 Highland Ohio 39071 44 1
293796 2020-07-03 Hocking Ohio 39073 78 8
293797 2020-07-03 Holmes Ohio 39075 220 3
293798 2020-07-03 Huron Ohio 39077 199 2
293799 2020-07-03 Jackson Ohio 39079 18 0
293800 2020-07-03 Jefferson Ohio 39081 83 2
293801 2020-07-03 Knox Ohio 39083 45 1
293802 2020-07-03 Lake Ohio 39085 480 18
293803 2020-07-03 Lawrence Ohio 39087 67 0
293804 2020-07-03 Licking Ohio 39089 442 12
293805 2020-07-03 Logan Ohio 39091 58 1
293806 2020-07-03 Lorain Ohio 39093 983 67
293807 2020-07-03 Lucas Ohio 39095 2669 302
293808 2020-07-03 Madison Ohio 39097 192 8
293809 2020-07-03 Mahoning Ohio 39099 1805 231
293810 2020-07-03 Marion Ohio 39101 2730 38
293811 2020-07-03 Medina Ohio 39103 506 32
293812 2020-07-03 Meigs Ohio 39105 11 0
293813 2020-07-03 Mercer Ohio 39107 278 8
293814 2020-07-03 Miami Ohio 39109 455 31
293815 2020-07-03 Monroe Ohio 39111 88 17
293816 2020-07-03 Montgomery Ohio 39113 1918 26
293817 2020-07-03 Morgan Ohio 39115 11 0
293818 2020-07-03 Morrow Ohio 39117 116 1
293819 2020-07-03 Muskingum Ohio 39119 76 1
293820 2020-07-03 Noble Ohio 39121 11 0
293821 2020-07-03 Ottawa Ohio 39123 139 23
293822 2020-07-03 Paulding Ohio 39125 23 0
293823 2020-07-03 Perry Ohio 39127 32 1
293824 2020-07-03 Pickaway Ohio 39129 2184 41
293825 2020-07-03 Pike Ohio 39131 22 0
293826 2020-07-03 Portage Ohio 39133 428 58
293827 2020-07-03 Preble Ohio 39135 70 1
293828 2020-07-03 Putnam Ohio 39137 126 15
293829 2020-07-03 Richland Ohio 39139 325 5
293830 2020-07-03 Ross Ohio 39141 113 3
293831 2020-07-03 Sandusky Ohio 39143 126 14
293832 2020-07-03 Scioto Ohio 39145 38 0
293833 2020-07-03 Seneca Ohio 39147 33 2
293834 2020-07-03 Shelby Ohio 39149 64 4
293835 2020-07-03 Stark Ohio 39151 1079 112
293836 2020-07-03 Summit Ohio 39153 2079 206
293837 2020-07-03 Trumbull Ohio 39155 916 65
293838 2020-07-03 Tuscarawas Ohio 39157 529 10
293839 2020-07-03 Union Ohio 39159 80 1
293840 2020-07-03 Van Wert Ohio 39161 32 0
293841 2020-07-03 Vinton Ohio 39163 22 2
293842 2020-07-03 Warren Ohio 39165 814 21
293843 2020-07-03 Washington Ohio 39167 130 20
293844 2020-07-03 Wayne Ohio 39169 359 51
293845 2020-07-03 Williams Ohio 39171 68 2
293846 2020-07-03 Wood Ohio 39173 404 51
293847 2020-07-03 Wyandot Ohio 39175 58 5
290679 2020-07-02 Adams Ohio 39001 21 1
290680 2020-07-02 Allen Ohio 39003 297 40
290681 2020-07-02 Ashland Ohio 39005 55 1
290682 2020-07-02 Ashtabula Ohio 39007 421 44
290683 2020-07-02 Athens Ohio 39009 37 1
290684 2020-07-02 Auglaize Ohio 39011 99 3
290685 2020-07-02 Belmont Ohio 39013 534 21
290686 2020-07-02 Brown Ohio 39015 53 1
290687 2020-07-02 Butler Ohio 39017 1448 44
290688 2020-07-02 Carroll Ohio 39019 51 3
290689 2020-07-02 Champaign Ohio 39021 38 1
290690 2020-07-02 Clark Ohio 39023 739 9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1001.611ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette