ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39023 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279615 | 1279615 | 2021-05-02 | Clark | Ohio | 39023 | 13903 | 297 |
1276368 | 1276368 | 2021-05-01 | Clark | Ohio | 39023 | 13892 | 297 |
1273121 | 1273121 | 2021-04-30 | Clark | Ohio | 39023 | 13863 | 297 |
1269874 | 1269874 | 2021-04-29 | Clark | Ohio | 39023 | 13849 | 297 |
1266627 | 1266627 | 2021-04-28 | Clark | Ohio | 39023 | 13830 | 297 |
1263380 | 1263380 | 2021-04-27 | Clark | Ohio | 39023 | 13801 | 297 |
1260133 | 1260133 | 2021-04-26 | Clark | Ohio | 39023 | 13782 | 294 |
1256886 | 1256886 | 2021-04-25 | Clark | Ohio | 39023 | 13774 | 294 |
1253639 | 1253639 | 2021-04-24 | Clark | Ohio | 39023 | 13761 | 294 |
1250392 | 1250392 | 2021-04-23 | Clark | Ohio | 39023 | 13738 | 294 |
1247145 | 1247145 | 2021-04-22 | Clark | Ohio | 39023 | 13718 | 293 |
1243898 | 1243898 | 2021-04-21 | Clark | Ohio | 39023 | 13697 | 293 |
1240651 | 1240651 | 2021-04-20 | Clark | Ohio | 39023 | 13682 | 293 |
1237404 | 1237404 | 2021-04-19 | Clark | Ohio | 39023 | 13660 | 293 |
1234157 | 1234157 | 2021-04-18 | Clark | Ohio | 39023 | 13652 | 293 |
1230909 | 1230909 | 2021-04-17 | Clark | Ohio | 39023 | 13634 | 293 |
1227661 | 1227661 | 2021-04-16 | Clark | Ohio | 39023 | 13602 | 293 |
1224413 | 1224413 | 2021-04-15 | Clark | Ohio | 39023 | 13576 | 288 |
1221166 | 1221166 | 2021-04-14 | Clark | Ohio | 39023 | 13542 | 288 |
1217918 | 1217918 | 2021-04-13 | Clark | Ohio | 39023 | 13515 | 288 |
1214670 | 1214670 | 2021-04-12 | Clark | Ohio | 39023 | 13476 | 287 |
1211423 | 1211423 | 2021-04-11 | Clark | Ohio | 39023 | 13455 | 287 |
1208174 | 1208174 | 2021-04-10 | Clark | Ohio | 39023 | 13433 | 287 |
1204926 | 1204926 | 2021-04-09 | Clark | Ohio | 39023 | 13397 | 287 |
1201678 | 1201678 | 2021-04-08 | Clark | Ohio | 39023 | 13378 | 286 |
1198429 | 1198429 | 2021-04-07 | Clark | Ohio | 39023 | 13347 | 286 |
1195180 | 1195180 | 2021-04-06 | Clark | Ohio | 39023 | 13319 | 286 |
1191932 | 1191932 | 2021-04-05 | Clark | Ohio | 39023 | 13298 | 282 |
1188683 | 1188683 | 2021-04-04 | Clark | Ohio | 39023 | 13257 | 282 |
1185436 | 1185436 | 2021-04-03 | Clark | Ohio | 39023 | 13257 | 282 |
1182189 | 1182189 | 2021-04-02 | Clark | Ohio | 39023 | 13201 | 282 |
1178942 | 1178942 | 2021-04-01 | Clark | Ohio | 39023 | 13171 | 282 |
1175695 | 1175695 | 2021-03-31 | Clark | Ohio | 39023 | 13137 | 282 |
1172448 | 1172448 | 2021-03-30 | Clark | Ohio | 39023 | 13107 | 282 |
1169201 | 1169201 | 2021-03-29 | Clark | Ohio | 39023 | 13048 | 280 |
1165953 | 1165953 | 2021-03-28 | Clark | Ohio | 39023 | 13023 | 280 |
1162705 | 1162705 | 2021-03-27 | Clark | Ohio | 39023 | 12995 | 280 |
1159456 | 1159456 | 2021-03-26 | Clark | Ohio | 39023 | 12961 | 280 |
1156209 | 1156209 | 2021-03-25 | Clark | Ohio | 39023 | 12895 | 279 |
1152962 | 1152962 | 2021-03-24 | Clark | Ohio | 39023 | 12857 | 279 |
1149715 | 1149715 | 2021-03-23 | Clark | Ohio | 39023 | 12828 | 279 |
1146468 | 1146468 | 2021-03-22 | Clark | Ohio | 39023 | 12788 | 279 |
1143221 | 1143221 | 2021-03-21 | Clark | Ohio | 39023 | 12763 | 279 |
1139974 | 1139974 | 2021-03-20 | Clark | Ohio | 39023 | 12736 | 279 |
1136728 | 1136728 | 2021-03-19 | Clark | Ohio | 39023 | 12691 | 279 |
1133482 | 1133482 | 2021-03-18 | Clark | Ohio | 39023 | 12657 | 272 |
1130234 | 1130234 | 2021-03-17 | Clark | Ohio | 39023 | 12622 | 272 |
1126987 | 1126987 | 2021-03-16 | Clark | Ohio | 39023 | 12587 | 272 |
1123741 | 1123741 | 2021-03-15 | Clark | Ohio | 39023 | 12546 | 266 |
1120495 | 1120495 | 2021-03-14 | Clark | Ohio | 39023 | 12532 | 266 |
1117248 | 1117248 | 2021-03-13 | Clark | Ohio | 39023 | 12518 | 266 |
1114001 | 1114001 | 2021-03-12 | Clark | Ohio | 39023 | 12506 | 266 |
1110755 | 1110755 | 2021-03-11 | Clark | Ohio | 39023 | 12465 | 260 |
1107509 | 1107509 | 2021-03-10 | Clark | Ohio | 39023 | 12453 | 260 |
1104263 | 1104263 | 2021-03-09 | Clark | Ohio | 39023 | 12432 | 260 |
1101017 | 1101017 | 2021-03-08 | Clark | Ohio | 39023 | 12411 | 256 |
1097771 | 1097771 | 2021-03-07 | Clark | Ohio | 39023 | 12394 | 256 |
1094523 | 1094523 | 2021-03-06 | Clark | Ohio | 39023 | 12376 | 256 |
1091277 | 1091277 | 2021-03-05 | Clark | Ohio | 39023 | 12352 | 256 |
1088032 | 1088032 | 2021-03-04 | Clark | Ohio | 39023 | 12319 | 248 |
1084787 | 1084787 | 2021-03-03 | Clark | Ohio | 39023 | 12288 | 248 |
1081541 | 1081541 | 2021-03-02 | Clark | Ohio | 39023 | 12268 | 248 |
1078295 | 1078295 | 2021-03-01 | Clark | Ohio | 39023 | 12246 | 336 |
1075050 | 1075050 | 2021-02-28 | Clark | Ohio | 39023 | 12223 | 336 |
1071804 | 1071804 | 2021-02-27 | Clark | Ohio | 39023 | 12210 | 335 |
1068558 | 1068558 | 2021-02-26 | Clark | Ohio | 39023 | 12194 | 335 |
1065313 | 1065313 | 2021-02-25 | Clark | Ohio | 39023 | 12162 | 335 |
1062069 | 1062069 | 2021-02-24 | Clark | Ohio | 39023 | 12139 | 333 |
1058823 | 1058823 | 2021-02-23 | Clark | Ohio | 39023 | 12121 | 332 |
1055577 | 1055577 | 2021-02-22 | Clark | Ohio | 39023 | 12101 | 331 |
1052331 | 1052331 | 2021-02-21 | Clark | Ohio | 39023 | 12082 | 330 |
1049084 | 1049084 | 2021-02-20 | Clark | Ohio | 39023 | 12064 | 329 |
1045837 | 1045837 | 2021-02-19 | Clark | Ohio | 39023 | 12046 | 328 |
1042592 | 1042592 | 2021-02-18 | Clark | Ohio | 39023 | 12018 | 320 |
1039347 | 1039347 | 2021-02-17 | Clark | Ohio | 39023 | 11995 | 317 |
1036102 | 1036102 | 2021-02-16 | Clark | Ohio | 39023 | 11978 | 317 |
1032857 | 1032857 | 2021-02-15 | Clark | Ohio | 39023 | 11957 | 321 |
1029611 | 1029611 | 2021-02-14 | Clark | Ohio | 39023 | 11930 | 320 |
1026364 | 1026364 | 2021-02-13 | Clark | Ohio | 39023 | 11913 | 320 |
1023119 | 1023119 | 2021-02-12 | Clark | Ohio | 39023 | 11881 | 318 |
1019874 | 1019874 | 2021-02-11 | Clark | Ohio | 39023 | 11838 | 303 |
1016629 | 1016629 | 2021-02-10 | Clark | Ohio | 39023 | 11815 | 301 |
1013384 | 1013384 | 2021-02-09 | Clark | Ohio | 39023 | 11778 | 300 |
1010139 | 1010139 | 2021-02-08 | Clark | Ohio | 39023 | 11741 | 299 |
1006893 | 1006893 | 2021-02-07 | Clark | Ohio | 39023 | 11716 | 299 |
1003647 | 1003647 | 2021-02-06 | Clark | Ohio | 39023 | 11685 | 299 |
1000401 | 1000401 | 2021-02-05 | Clark | Ohio | 39023 | 11633 | 295 |
997155 | 997155 | 2021-02-04 | Clark | Ohio | 39023 | 11599 | 295 |
993909 | 993909 | 2021-02-03 | Clark | Ohio | 39023 | 11552 | 295 |
990663 | 990663 | 2021-02-02 | Clark | Ohio | 39023 | 11518 | 293 |
987417 | 987417 | 2021-02-01 | Clark | Ohio | 39023 | 11462 | 289 |
984170 | 984170 | 2021-01-31 | Clark | Ohio | 39023 | 11420 | 288 |
980923 | 980923 | 2021-01-30 | Clark | Ohio | 39023 | 11372 | 288 |
977677 | 977677 | 2021-01-29 | Clark | Ohio | 39023 | 11297 | 288 |
974432 | 974432 | 2021-01-28 | Clark | Ohio | 39023 | 11205 | 281 |
971187 | 971187 | 2021-01-27 | Clark | Ohio | 39023 | 11147 | 266 |
967942 | 967942 | 2021-01-26 | Clark | Ohio | 39023 | 11094 | 266 |
964698 | 964698 | 2021-01-25 | Clark | Ohio | 39023 | 11058 | 265 |
961453 | 961453 | 2021-01-24 | Clark | Ohio | 39023 | 10995 | 265 |
958208 | 958208 | 2021-01-23 | Clark | Ohio | 39023 | 10942 | 265 |
Advanced export
JSON shape: default, array, newline-delimited
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);