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

51,123 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 · 51,123 ✖
Link rowid date ▲ county state fips cases deaths
1844669 1844669 2021-10-23 Adams Ohio 39001 4171 95
1844670 1844670 2021-10-23 Allen Ohio 39003 16001 279
1844671 1844671 2021-10-23 Ashland Ohio 39005 6967 130
1844672 1844672 2021-10-23 Ashtabula Ohio 39007 9741 204
1844673 1844673 2021-10-23 Athens Ohio 39009 7777 79
1844674 1844674 2021-10-23 Auglaize Ohio 39011 6797 99
1844675 1844675 2021-10-23 Belmont Ohio 39013 9309 209
1844676 1844676 2021-10-23 Brown Ohio 39015 6364 91
1844677 1844677 2021-10-23 Butler Ohio 39017 51580 718
1844678 1844678 2021-10-23 Carroll Ohio 39019 3023 65
1844679 1844679 2021-10-23 Champaign Ohio 39021 5131 73
1844680 1844680 2021-10-23 Clark Ohio 39023 19863 354
1844681 1844681 2021-10-23 Clermont Ohio 39025 28193 330
1844682 1844682 2021-10-23 Clinton Ohio 39027 5837 93
1844683 1844683 2021-10-23 Columbiana Ohio 39029 14080 274
1844684 1844684 2021-10-23 Coshocton Ohio 39031 4846 83
1844685 1844685 2021-10-23 Crawford Ohio 39033 6274 130
1844686 1844686 2021-10-23 Cuyahoga Ohio 39035 146407 2459
1844687 1844687 2021-10-23 Darke Ohio 39037 7689 158
1844688 1844688 2021-10-23 Defiance Ohio 39039 6218 105
1844689 1844689 2021-10-23 Delaware Ohio 39041 24208 164
1844690 1844690 2021-10-23 Erie Ohio 39043 10904 184
1844691 1844691 2021-10-23 Fairfield Ohio 39045 22395 247
1844692 1844692 2021-10-23 Fayette Ohio 39047 4292 63
1844693 1844693 2021-10-23 Franklin Ohio 39049 164265 1696
1844694 1844694 2021-10-23 Fulton Ohio 39051 6028 96
1844695 1844695 2021-10-23 Gallia Ohio 39053 4184 67
1844696 1844696 2021-10-23 Geauga Ohio 39055 8965 158
1844697 1844697 2021-10-23 Greene Ohio 39057 22350 326
1844698 1844698 2021-10-23 Guernsey Ohio 39059 5930 71
1844699 1844699 2021-10-23 Hamilton Ohio 39061 105366 1431
1844700 1844700 2021-10-23 Hancock Ohio 39063 9707 155
1844701 1844701 2021-10-23 Hardin Ohio 39065 4194 80
1844702 1844702 2021-10-23 Harrison Ohio 39067 1821 46
1844703 1844703 2021-10-23 Henry Ohio 39069 3653 72
1844704 1844704 2021-10-23 Highland Ohio 39071 6004 99
1844705 1844705 2021-10-23 Hocking Ohio 39073 3567 82
1844706 1844706 2021-10-23 Holmes Ohio 39075 3642 125
1844707 1844707 2021-10-23 Huron Ohio 39077 8404 143
1844708 1844708 2021-10-23 Jackson Ohio 39079 5102 73
1844709 1844709 2021-10-23 Jefferson Ohio 39081 8567 199
1844710 1844710 2021-10-23 Knox Ohio 39083 7739 144
1844711 1844711 2021-10-23 Lake Ohio 39085 27063 448
1844712 1844712 2021-10-23 Lawrence Ohio 39087 9759 153
1844713 1844713 2021-10-23 Licking Ohio 39089 23939 294
1844714 1844714 2021-10-23 Logan Ohio 39091 5910 96
1844715 1844715 2021-10-23 Lorain Ohio 39093 35628 585
1844716 1844716 2021-10-23 Lucas Ohio 39095 56338 917
1844717 1844717 2021-10-23 Madison Ohio 39097 5945 78
1844718 1844718 2021-10-23 Mahoning Ohio 39099 30787 693
1844719 1844719 2021-10-23 Marion Ohio 39101 11976 180
1844720 1844720 2021-10-23 Medina Ohio 39103 22047 313
1844721 1844721 2021-10-23 Meigs Ohio 39105 2658 51
1844722 1844722 2021-10-23 Mercer Ohio 39107 6164 93
1844723 1844723 2021-10-23 Miami Ohio 39109 15582 306
1844724 1844724 2021-10-23 Monroe Ohio 39111 2162 54
1844725 1844725 2021-10-23 Montgomery Ohio 39113 74066 1279
1844726 1844726 2021-10-23 Morgan Ohio 39115 1940 33
1844727 1844727 2021-10-23 Morrow Ohio 39117 4588 58
1844728 1844728 2021-10-23 Muskingum Ohio 39119 14831 185
1844729 1844729 2021-10-23 Noble Ohio 39121 2003 47
1844730 1844730 2021-10-23 Ottawa Ohio 39123 4885 86
1844731 1844731 2021-10-23 Paulding Ohio 39125 2803 47
1844732 1844732 2021-10-23 Perry Ohio 39127 5183 63
1844733 1844733 2021-10-23 Pickaway Ohio 39129 11373 142
1844734 1844734 2021-10-23 Pike Ohio 39131 4343 67
1844735 1844735 2021-10-23 Portage Ohio 39133 17978 252
1844736 1844736 2021-10-23 Preble Ohio 39135 5720 125
1844737 1844737 2021-10-23 Putnam Ohio 39137 5335 110
1844738 1844738 2021-10-23 Richland Ohio 39139 18586 292
1844739 1844739 2021-10-23 Ross Ohio 39141 10586 203
1844740 1844740 2021-10-23 Sandusky Ohio 39143 7827 151
1844741 1844741 2021-10-23 Scioto Ohio 39145 11469 162
1844742 1844742 2021-10-23 Seneca Ohio 39147 7372 145
1844743 1844743 2021-10-23 Shelby Ohio 39149 6530 115
1844744 1844744 2021-10-23 Stark Ohio 39151 46681 1064
1844745 1844745 2021-10-23 Summit Ohio 39153 61784 1111
1844746 1844746 2021-10-23 Trumbull Ohio 39155 22885 561
1844747 1844747 2021-10-23 Tuscarawas Ohio 39157 12724 311
1844748 1844748 2021-10-23 Union Ohio 39159 8198 59
1844749 1844749 2021-10-23 Unknown Ohio   0 4
1844750 1844750 2021-10-23 Van Wert Ohio 39161 3723 82
1844751 1844751 2021-10-23 Vinton Ohio 39163 1666 25
1844752 1844752 2021-10-23 Warren Ohio 39165 32836 377
1844753 1844753 2021-10-23 Washington Ohio 39167 8093 144
1844754 1844754 2021-10-23 Wayne Ohio 39169 13791 271
1844755 1844755 2021-10-23 Williams Ohio 39171 5292 88
1844756 1844756 2021-10-23 Wood Ohio 39173 17454 224
1844757 1844757 2021-10-23 Wyandot Ohio 39175 3246 62
1841419 1841419 2021-10-22 Adams Ohio 39001 4166 95
1841420 1841420 2021-10-22 Allen Ohio 39003 15967 279
1841421 1841421 2021-10-22 Ashland Ohio 39005 6945 130
1841422 1841422 2021-10-22 Ashtabula Ohio 39007 9701 204
1841423 1841423 2021-10-22 Athens Ohio 39009 7761 79
1841424 1841424 2021-10-22 Auglaize Ohio 39011 6786 99
1841425 1841425 2021-10-22 Belmont Ohio 39013 9287 209
1841426 1841426 2021-10-22 Brown Ohio 39015 6352 91
1841427 1841427 2021-10-22 Butler Ohio 39017 51500 718
1841428 1841428 2021-10-22 Carroll Ohio 39019 3017 65
1841429 1841429 2021-10-22 Champaign Ohio 39021 5115 73

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