ny_times_us_counties

Table actions
⚠️ 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

30,298 rows where state = "Ohio" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Ohio · 30,298 ✖
Link rowid date ▲ county state fips cases deaths
1084776 1084776 2021-03-03 Adams Ohio 39001 2170 36
1084777 1084777 2021-03-03 Allen Ohio 39003 10793 216
1084778 1084778 2021-03-03 Ashland Ohio 39005 3805 81
1084779 1084779 2021-03-03 Ashtabula Ohio 39007 5978 152
1084780 1084780 2021-03-03 Athens Ohio 39009 4650 47
1084781 1084781 2021-03-03 Auglaize Ohio 39011 4561 80
1084782 1084782 2021-03-03 Belmont Ohio 39013 4966 59
1084783 1084783 2021-03-03 Brown Ohio 39015 3698 44
1084784 1084784 2021-03-03 Butler Ohio 39017 35577 505
1084785 1084785 2021-03-03 Carroll Ohio 39019 1813 41
1084786 1084786 2021-03-03 Champaign Ohio 39021 2881 49
1084787 1084787 2021-03-03 Clark Ohio 39023 12288 248
1084788 1084788 2021-03-03 Clermont Ohio 39025 18425 201
1084789 1084789 2021-03-03 Clinton Ohio 39027 3408 52
1084790 1084790 2021-03-03 Columbiana Ohio 39029 8151 200
1084791 1084791 2021-03-03 Coshocton Ohio 39031 2374 54
1084792 1084792 2021-03-03 Crawford Ohio 39033 3583 96
1084793 1084793 2021-03-03 Cuyahoga Ohio 39035 96186 1832
1084794 1084794 2021-03-03 Darke Ohio 39037 5036 114
1084795 1084795 2021-03-03 Defiance Ohio 39039 3725 83
1084796 1084796 2021-03-03 Delaware Ohio 39041 16499 116
1084797 1084797 2021-03-03 Erie Ohio 39043 6914 140
1084798 1084798 2021-03-03 Fairfield Ohio 39045 14563 180
1084799 1084799 2021-03-03 Fayette Ohio 39047 2691 41
1084800 1084800 2021-03-03 Franklin Ohio 39049 112367 1214
1084801 1084801 2021-03-03 Fulton Ohio 39051 3806 58
1084802 1084802 2021-03-03 Gallia Ohio 39053 2226 31
1084803 1084803 2021-03-03 Geauga Ohio 39055 6083 136
1084804 1084804 2021-03-03 Greene Ohio 39057 13595 218
1084805 1084805 2021-03-03 Guernsey Ohio 39059 2878 44
1084806 1084806 2021-03-03 Hamilton Ohio 39061 73572 1034
1084807 1084807 2021-03-03 Hancock Ohio 39063 6006 116
1084808 1084808 2021-03-03 Hardin Ohio 39065 2458 58
1084809 1084809 2021-03-03 Harrison Ohio 39067 1006 24
1084810 1084810 2021-03-03 Henry Ohio 39069 2466 58
1084811 1084811 2021-03-03 Highland Ohio 39071 3283 49
1084812 1084812 2021-03-03 Hocking Ohio 39073 1945 54
1084813 1084813 2021-03-03 Holmes Ohio 39075 2432 93
1084814 1084814 2021-03-03 Huron Ohio 39077 4825 107
1084815 1084815 2021-03-03 Jackson Ohio 39079 2905 45
1084816 1084816 2021-03-03 Jefferson Ohio 39081 4806 107
1084817 1084817 2021-03-03 Knox Ohio 39083 4037 101
1084818 1084818 2021-03-03 Lake Ohio 39085 18445 318
1084819 1084819 2021-03-03 Lawrence Ohio 39087 5271 18
1084820 1084820 2021-03-03 Licking Ohio 39089 15022 189
1084821 1084821 2021-03-03 Logan Ohio 39091 3557 72
1084822 1084822 2021-03-03 Lorain Ohio 39093 22068 414
1084823 1084823 2021-03-03 Lucas Ohio 39095 35489 685
1084824 1084824 2021-03-03 Madison Ohio 39097 3935 53
1084825 1084825 2021-03-03 Mahoning Ohio 39099 19509 537
1084826 1084826 2021-03-03 Marion Ohio 39101 7996 125
1084827 1084827 2021-03-03 Medina Ohio 39103 13423 226
1084828 1084828 2021-03-03 Meigs Ohio 39105 1357 30
1084829 1084829 2021-03-03 Mercer Ohio 39107 4587 80
1084830 1084830 2021-03-03 Miami Ohio 39109 10035 189
1084831 1084831 2021-03-03 Monroe Ohio 39111 1170 27
1084832 1084832 2021-03-03 Montgomery Ohio 39113 47359 903
1084833 1084833 2021-03-03 Morgan Ohio 39115 1011 19
1084834 1084834 2021-03-03 Morrow Ohio 39117 2603 34
1084835 1084835 2021-03-03 Muskingum Ohio 39119 8195 112
1084836 1084836 2021-03-03 Noble Ohio 39121 1292 33
1084837 1084837 2021-03-03 Ottawa Ohio 39123 3243 69
1084838 1084838 2021-03-03 Paulding Ohio 39125 1605 30
1084839 1084839 2021-03-03 Perry Ohio 39127 2698 47
1084840 1084840 2021-03-03 Pickaway Ohio 39129 8067 107
1084841 1084841 2021-03-03 Pike Ohio 39131 2156 26
1084842 1084842 2021-03-03 Portage Ohio 39133 11050 164
1084843 1084843 2021-03-03 Preble Ohio 39135 3536 78
1084844 1084844 2021-03-03 Putnam Ohio 39137 3993 90
1084845 1084845 2021-03-03 Richland Ohio 39139 10316 183
1084846 1084846 2021-03-03 Ross Ohio 39141 6152 128
1084847 1084847 2021-03-03 Sandusky Ohio 39143 4780 108
1084848 1084848 2021-03-03 Scioto Ohio 39145 5962 80
1084849 1084849 2021-03-03 Seneca Ohio 39147 4702 107
1084850 1084850 2021-03-03 Shelby Ohio 39149 4416 79
1084851 1084851 2021-03-03 Stark Ohio 39151 29456 803
1084852 1084852 2021-03-03 Summit Ohio 39153 40384 802
1084853 1084853 2021-03-03 Trumbull Ohio 39155 14369 413
1084854 1084854 2021-03-03 Tuscarawas Ohio 39157 8054 227
1084855 1084855 2021-03-03 Union Ohio 39159 5135 37
1084856 1084856 2021-03-03 Van Wert Ohio 39161 2298 54
1084857 1084857 2021-03-03 Vinton Ohio 39163 766 13
1084858 1084858 2021-03-03 Warren Ohio 39165 22464 271
1084859 1084859 2021-03-03 Washington Ohio 39167 4657 91
1084860 1084860 2021-03-03 Wayne Ohio 39169 7886 193
1084861 1084861 2021-03-03 Williams Ohio 39171 3026 62
1084862 1084862 2021-03-03 Wood Ohio 39173 11575 163
1084863 1084863 2021-03-03 Wyandot Ohio 39175 2104 47
1081530 1081530 2021-03-02 Adams Ohio 39001 2163 36
1081531 1081531 2021-03-02 Allen Ohio 39003 10774 216
1081532 1081532 2021-03-02 Ashland Ohio 39005 3800 81
1081533 1081533 2021-03-02 Ashtabula Ohio 39007 5964 152
1081534 1081534 2021-03-02 Athens Ohio 39009 4644 47
1081535 1081535 2021-03-02 Auglaize Ohio 39011 4557 80
1081536 1081536 2021-03-02 Belmont Ohio 39013 4942 59
1081537 1081537 2021-03-02 Brown Ohio 39015 3696 44
1081538 1081538 2021-03-02 Butler Ohio 39017 35496 505
1081539 1081539 2021-03-02 Carroll Ohio 39019 1812 41
1081540 1081540 2021-03-02 Champaign Ohio 39021 2870 49
1081541 1081541 2021-03-02 Clark Ohio 39023 12268 248

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
);
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]);