ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39093 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279650 | 1279650 | 2021-05-02 | Lorain | Ohio | 39093 | 24757 | 479 |
1276403 | 1276403 | 2021-05-01 | Lorain | Ohio | 39093 | 24723 | 479 |
1273156 | 1273156 | 2021-04-30 | Lorain | Ohio | 39093 | 24685 | 479 |
1269909 | 1269909 | 2021-04-29 | Lorain | Ohio | 39093 | 24632 | 475 |
1266662 | 1266662 | 2021-04-28 | Lorain | Ohio | 39093 | 24585 | 475 |
1263415 | 1263415 | 2021-04-27 | Lorain | Ohio | 39093 | 24562 | 475 |
1260168 | 1260168 | 2021-04-26 | Lorain | Ohio | 39093 | 24525 | 473 |
1256921 | 1256921 | 2021-04-25 | Lorain | Ohio | 39093 | 24493 | 473 |
1253674 | 1253674 | 2021-04-24 | Lorain | Ohio | 39093 | 24476 | 473 |
1250427 | 1250427 | 2021-04-23 | Lorain | Ohio | 39093 | 24442 | 473 |
1247180 | 1247180 | 2021-04-22 | Lorain | Ohio | 39093 | 24375 | 473 |
1243933 | 1243933 | 2021-04-21 | Lorain | Ohio | 39093 | 24333 | 473 |
1240686 | 1240686 | 2021-04-20 | Lorain | Ohio | 39093 | 24284 | 473 |
1237439 | 1237439 | 2021-04-19 | Lorain | Ohio | 39093 | 24246 | 473 |
1234192 | 1234192 | 2021-04-18 | Lorain | Ohio | 39093 | 24190 | 473 |
1230944 | 1230944 | 2021-04-17 | Lorain | Ohio | 39093 | 24166 | 473 |
1227696 | 1227696 | 2021-04-16 | Lorain | Ohio | 39093 | 24111 | 473 |
1224448 | 1224448 | 2021-04-15 | Lorain | Ohio | 39093 | 24090 | 472 |
1221201 | 1221201 | 2021-04-14 | Lorain | Ohio | 39093 | 24038 | 472 |
1217953 | 1217953 | 2021-04-13 | Lorain | Ohio | 39093 | 23968 | 472 |
1214705 | 1214705 | 2021-04-12 | Lorain | Ohio | 39093 | 23887 | 467 |
1211458 | 1211458 | 2021-04-11 | Lorain | Ohio | 39093 | 23831 | 467 |
1208209 | 1208209 | 2021-04-10 | Lorain | Ohio | 39093 | 23775 | 467 |
1204961 | 1204961 | 2021-04-09 | Lorain | Ohio | 39093 | 23710 | 467 |
1201713 | 1201713 | 2021-04-08 | Lorain | Ohio | 39093 | 23670 | 465 |
1198464 | 1198464 | 2021-04-07 | Lorain | Ohio | 39093 | 23566 | 465 |
1195215 | 1195215 | 2021-04-06 | Lorain | Ohio | 39093 | 23511 | 465 |
1191967 | 1191967 | 2021-04-05 | Lorain | Ohio | 39093 | 23465 | 459 |
1188718 | 1188718 | 2021-04-04 | Lorain | Ohio | 39093 | 23400 | 459 |
1185471 | 1185471 | 2021-04-03 | Lorain | Ohio | 39093 | 23400 | 459 |
1182224 | 1182224 | 2021-04-02 | Lorain | Ohio | 39093 | 23338 | 459 |
1178977 | 1178977 | 2021-04-01 | Lorain | Ohio | 39093 | 23285 | 459 |
1175730 | 1175730 | 2021-03-31 | Lorain | Ohio | 39093 | 23229 | 459 |
1172483 | 1172483 | 2021-03-30 | Lorain | Ohio | 39093 | 23177 | 459 |
1169236 | 1169236 | 2021-03-29 | Lorain | Ohio | 39093 | 23109 | 457 |
1165988 | 1165988 | 2021-03-28 | Lorain | Ohio | 39093 | 23068 | 457 |
1162740 | 1162740 | 2021-03-27 | Lorain | Ohio | 39093 | 23043 | 457 |
1159491 | 1159491 | 2021-03-26 | Lorain | Ohio | 39093 | 22986 | 457 |
1156244 | 1156244 | 2021-03-25 | Lorain | Ohio | 39093 | 22915 | 453 |
1152997 | 1152997 | 2021-03-24 | Lorain | Ohio | 39093 | 22883 | 453 |
1149750 | 1149750 | 2021-03-23 | Lorain | Ohio | 39093 | 22810 | 453 |
1146503 | 1146503 | 2021-03-22 | Lorain | Ohio | 39093 | 22758 | 452 |
1143256 | 1143256 | 2021-03-21 | Lorain | Ohio | 39093 | 22703 | 452 |
1140009 | 1140009 | 2021-03-20 | Lorain | Ohio | 39093 | 22679 | 452 |
1136763 | 1136763 | 2021-03-19 | Lorain | Ohio | 39093 | 22637 | 452 |
1133517 | 1133517 | 2021-03-18 | Lorain | Ohio | 39093 | 22600 | 442 |
1130269 | 1130269 | 2021-03-17 | Lorain | Ohio | 39093 | 22549 | 442 |
1127022 | 1127022 | 2021-03-16 | Lorain | Ohio | 39093 | 22535 | 442 |
1123776 | 1123776 | 2021-03-15 | Lorain | Ohio | 39093 | 22504 | 439 |
1120530 | 1120530 | 2021-03-14 | Lorain | Ohio | 39093 | 22477 | 439 |
1117283 | 1117283 | 2021-03-13 | Lorain | Ohio | 39093 | 22463 | 439 |
1114036 | 1114036 | 2021-03-12 | Lorain | Ohio | 39093 | 22425 | 439 |
1110790 | 1110790 | 2021-03-11 | Lorain | Ohio | 39093 | 22390 | 427 |
1107544 | 1107544 | 2021-03-10 | Lorain | Ohio | 39093 | 22358 | 427 |
1104298 | 1104298 | 2021-03-09 | Lorain | Ohio | 39093 | 22314 | 427 |
1101052 | 1101052 | 2021-03-08 | Lorain | Ohio | 39093 | 22242 | 424 |
1097806 | 1097806 | 2021-03-07 | Lorain | Ohio | 39093 | 22218 | 424 |
1094558 | 1094558 | 2021-03-06 | Lorain | Ohio | 39093 | 22190 | 424 |
1091312 | 1091312 | 2021-03-05 | Lorain | Ohio | 39093 | 22149 | 424 |
1088067 | 1088067 | 2021-03-04 | Lorain | Ohio | 39093 | 22111 | 414 |
1084822 | 1084822 | 2021-03-03 | Lorain | Ohio | 39093 | 22068 | 414 |
1081576 | 1081576 | 2021-03-02 | Lorain | Ohio | 39093 | 22016 | 414 |
1078330 | 1078330 | 2021-03-01 | Lorain | Ohio | 39093 | 21994 | 391 |
1075085 | 1075085 | 2021-02-28 | Lorain | Ohio | 39093 | 21952 | 389 |
1071839 | 1071839 | 2021-02-27 | Lorain | Ohio | 39093 | 21938 | 389 |
1068593 | 1068593 | 2021-02-26 | Lorain | Ohio | 39093 | 21904 | 389 |
1065348 | 1065348 | 2021-02-25 | Lorain | Ohio | 39093 | 21846 | 388 |
1062104 | 1062104 | 2021-02-24 | Lorain | Ohio | 39093 | 21781 | 386 |
1058858 | 1058858 | 2021-02-23 | Lorain | Ohio | 39093 | 21738 | 385 |
1055612 | 1055612 | 2021-02-22 | Lorain | Ohio | 39093 | 21667 | 382 |
1052366 | 1052366 | 2021-02-21 | Lorain | Ohio | 39093 | 21602 | 381 |
1049119 | 1049119 | 2021-02-20 | Lorain | Ohio | 39093 | 21566 | 380 |
1045872 | 1045872 | 2021-02-19 | Lorain | Ohio | 39093 | 21523 | 379 |
1042627 | 1042627 | 2021-02-18 | Lorain | Ohio | 39093 | 21438 | 374 |
1039382 | 1039382 | 2021-02-17 | Lorain | Ohio | 39093 | 21377 | 371 |
1036137 | 1036137 | 2021-02-16 | Lorain | Ohio | 39093 | 21343 | 370 |
1032892 | 1032892 | 2021-02-15 | Lorain | Ohio | 39093 | 21291 | 368 |
1029646 | 1029646 | 2021-02-14 | Lorain | Ohio | 39093 | 21213 | 364 |
1026399 | 1026399 | 2021-02-13 | Lorain | Ohio | 39093 | 21152 | 364 |
1023154 | 1023154 | 2021-02-12 | Lorain | Ohio | 39093 | 21086 | 332 |
1019909 | 1019909 | 2021-02-11 | Lorain | Ohio | 39093 | 20987 | 270 |
1016664 | 1016664 | 2021-02-10 | Lorain | Ohio | 39093 | 20915 | 251 |
1013419 | 1013419 | 2021-02-09 | Lorain | Ohio | 39093 | 20801 | 251 |
1010174 | 1010174 | 2021-02-08 | Lorain | Ohio | 39093 | 20717 | 250 |
1006928 | 1006928 | 2021-02-07 | Lorain | Ohio | 39093 | 20672 | 250 |
1003682 | 1003682 | 2021-02-06 | Lorain | Ohio | 39093 | 20610 | 250 |
1000436 | 1000436 | 2021-02-05 | Lorain | Ohio | 39093 | 20505 | 249 |
997190 | 997190 | 2021-02-04 | Lorain | Ohio | 39093 | 20412 | 248 |
993944 | 993944 | 2021-02-03 | Lorain | Ohio | 39093 | 20311 | 248 |
990698 | 990698 | 2021-02-02 | Lorain | Ohio | 39093 | 20199 | 239 |
987452 | 987452 | 2021-02-01 | Lorain | Ohio | 39093 | 20107 | 239 |
984205 | 984205 | 2021-01-31 | Lorain | Ohio | 39093 | 20012 | 237 |
980958 | 980958 | 2021-01-30 | Lorain | Ohio | 39093 | 19927 | 237 |
977712 | 977712 | 2021-01-29 | Lorain | Ohio | 39093 | 19830 | 237 |
974467 | 974467 | 2021-01-28 | Lorain | Ohio | 39093 | 19729 | 237 |
971222 | 971222 | 2021-01-27 | Lorain | Ohio | 39093 | 19563 | 234 |
967977 | 967977 | 2021-01-26 | Lorain | Ohio | 39093 | 19378 | 229 |
964733 | 964733 | 2021-01-25 | Lorain | Ohio | 39093 | 19296 | 229 |
961488 | 961488 | 2021-01-24 | Lorain | Ohio | 39093 | 19165 | 223 |
958243 | 958243 | 2021-01-23 | Lorain | Ohio | 39093 | 19017 | 223 |
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);