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

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

county

state

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