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

69,101 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 >30

county >30

state 1

  • Ohio · 69,101 ✖
Link rowid date ▲ county state fips cases deaths
2501644 2501644 2022-05-13 Adams Ohio 39001 7022 148
2501645 2501645 2022-05-13 Allen Ohio 39003 27636 478
2501646 2501646 2022-05-13 Ashland Ohio 39005 12109 218
2501647 2501647 2022-05-13 Ashtabula Ohio 39007 20537 431
2501648 2501648 2022-05-13 Athens Ohio 39009 14852 142
2501649 2501649 2022-05-13 Auglaize Ohio 39011 11642 189
2501650 2501650 2022-05-13 Belmont Ohio 39013 15805 309
2501651 2501651 2022-05-13 Brown Ohio 39015 11248 180
2501652 2501652 2022-05-13 Butler Ohio 39017 93927 1157
2501653 2501653 2022-05-13 Carroll Ohio 39019 5291 126
2501654 2501654 2022-05-13 Champaign Ohio 39021 8819 147
2501655 2501655 2022-05-13 Clark Ohio 39023 35217 586
2501656 2501656 2022-05-13 Clermont Ohio 39025 51997 560
2501657 2501657 2022-05-13 Clinton Ohio 39027 10410 168
2501658 2501658 2022-05-13 Columbiana Ohio 39029 24651 486
2501659 2501659 2022-05-13 Coshocton Ohio 39031 8008 159
2501660 2501660 2022-05-13 Crawford Ohio 39033 11254 215
2501661 2501661 2022-05-13 Cuyahoga Ohio 39035 276160 3794
2501662 2501662 2022-05-13 Darke Ohio 39037 12442 239
2501663 2501663 2022-05-13 Defiance Ohio 39039 10275 165
2501664 2501664 2022-05-13 Delaware Ohio 39041 45538 272
2501665 2501665 2022-05-13 Erie Ohio 39043 19730 267
2501666 2501666 2022-05-13 Fairfield Ohio 39045 39082 430
2501667 2501667 2022-05-13 Fayette Ohio 39047 7846 121
2501668 2501668 2022-05-13 Franklin Ohio 39049 296037 2610
2501669 2501669 2022-05-13 Fulton Ohio 39051 10436 180
2501670 2501670 2022-05-13 Gallia Ohio 39053 7565 127
2501671 2501671 2022-05-13 Geauga Ohio 39055 16413 265
2501672 2501672 2022-05-13 Greene Ohio 39057 38049 513
2501673 2501673 2022-05-13 Guernsey Ohio 39059 10567 151
2501674 2501674 2022-05-13 Hamilton Ohio 39061 191030 2069
2501675 2501675 2022-05-13 Hancock Ohio 39063 17253 277
2501676 2501676 2022-05-13 Hardin Ohio 39065 7138 158
2501677 2501677 2022-05-13 Harrison Ohio 39067 3263 74
2501678 2501678 2022-05-13 Henry Ohio 39069 6485 106
2501679 2501679 2022-05-13 Highland Ohio 39071 10675 184
2501680 2501680 2022-05-13 Hocking Ohio 39073 6731 123
2501681 2501681 2022-05-13 Holmes Ohio 39075 5135 182
2501682 2501682 2022-05-13 Huron Ohio 39077 14626 222
2501683 2501683 2022-05-13 Jackson Ohio 39079 8988 141
2501684 2501684 2022-05-13 Jefferson Ohio 39081 14900 322
2501685 2501685 2022-05-13 Knox Ohio 39083 13325 228
2501686 2501686 2022-05-13 Lake Ohio 39085 49961 737
2501687 2501687 2022-05-13 Lawrence Ohio 39087 18071 256
2501688 2501688 2022-05-13 Licking Ohio 39089 42276 475
2501689 2501689 2022-05-13 Logan Ohio 39091 10333 173
2501690 2501690 2022-05-13 Lorain Ohio 39093 68382 981
2501691 2501691 2022-05-13 Lucas Ohio 39095 103434 1420
2501692 2501692 2022-05-13 Madison Ohio 39097 9754 136
2501693 2501693 2022-05-13 Mahoning Ohio 39099 54021 1089
2501694 2501694 2022-05-13 Marion Ohio 39101 20070 268
2501695 2501695 2022-05-13 Medina Ohio 39103 40840 507
2501696 2501696 2022-05-13 Meigs Ohio 39105 4686 88
2501697 2501697 2022-05-13 Mercer Ohio 39107 9715 144
2501698 2501698 2022-05-13 Miami Ohio 39109 25909 483
2501699 2501699 2022-05-13 Monroe Ohio 39111 3499 82
2501700 2501700 2022-05-13 Montgomery Ohio 39113 128090 2019
2501701 2501701 2022-05-13 Morgan Ohio 39115 3278 60
2501702 2501702 2022-05-13 Morrow Ohio 39117 7845 103
2501703 2501703 2022-05-13 Muskingum Ohio 39119 25481 294
2501704 2501704 2022-05-13 Noble Ohio 39121 3220 58
2501705 2501705 2022-05-13 Ottawa Ohio 39123 8618 138
2501706 2501706 2022-05-13 Paulding Ohio 39125 4639 74
2501707 2501707 2022-05-13 Perry Ohio 39127 8356 125
2501708 2501708 2022-05-13 Pickaway Ohio 39129 17679 230
2501709 2501709 2022-05-13 Pike Ohio 39131 7493 123
2501710 2501710 2022-05-13 Portage Ohio 39133 35026 450
2501711 2501711 2022-05-13 Preble Ohio 39135 9494 201
2501712 2501712 2022-05-13 Putnam Ohio 39137 8492 157
2501713 2501713 2022-05-13 Richland Ohio 39139 31806 508
2501714 2501714 2022-05-13 Ross Ohio 39141 19410 301
2501715 2501715 2022-05-13 Sandusky Ohio 39143 14015 238
2501716 2501716 2022-05-13 Scioto Ohio 39145 20777 257
2501717 2501717 2022-05-13 Seneca Ohio 39147 12869 230
2501718 2501718 2022-05-13 Shelby Ohio 39149 11102 188
2501719 2501719 2022-05-13 Stark Ohio 39151 80794 1718
2501720 2501720 2022-05-13 Summit Ohio 39153 115094 1710
2501721 2501721 2022-05-13 Trumbull Ohio 39155 42078 941
2501722 2501722 2022-05-13 Tuscarawas Ohio 39157 20753 505
2501723 2501723 2022-05-13 Union Ohio 39159 15952 102
2501724 2501724 2022-05-13 Unknown Ohio   0 5
2501725 2501725 2022-05-13 Van Wert Ohio 39161 6755 148
2501726 2501726 2022-05-13 Vinton Ohio 39163 2918 55
2501727 2501727 2022-05-13 Warren Ohio 39165 58538 584
2501728 2501728 2022-05-13 Washington Ohio 39167 12409 207
2501729 2501729 2022-05-13 Wayne Ohio 39169 23392 439
2501730 2501730 2022-05-13 Williams Ohio 39171 9090 164
2501731 2501731 2022-05-13 Wood Ohio 39173 32072 355
2501732 2501732 2022-05-13 Wyandot Ohio 39175 5441 105
2498386 2498386 2022-05-12 Adams Ohio 39001 7022 148
2498387 2498387 2022-05-12 Allen Ohio 39003 27636 478
2498388 2498388 2022-05-12 Ashland Ohio 39005 12109 218
2498389 2498389 2022-05-12 Ashtabula Ohio 39007 20537 431
2498390 2498390 2022-05-12 Athens Ohio 39009 14852 142
2498391 2498391 2022-05-12 Auglaize Ohio 39011 11642 189
2498392 2498392 2022-05-12 Belmont Ohio 39013 15805 309
2498393 2498393 2022-05-12 Brown Ohio 39015 11248 180
2498394 2498394 2022-05-12 Butler Ohio 39017 93927 1157
2498395 2498395 2022-05-12 Carroll Ohio 39019 5291 126
2498396 2498396 2022-05-12 Champaign Ohio 39021 8819 147

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