ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lucas" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1243934 | 1243934 | 2021-04-21 | Lucas | Ohio | 39095 | 40568 | 768 |
1240687 | 1240687 | 2021-04-20 | Lucas | Ohio | 39095 | 40405 | 768 |
1237440 | 1237440 | 2021-04-19 | Lucas | Ohio | 39095 | 40298 | 765 |
1234193 | 1234193 | 2021-04-18 | Lucas | Ohio | 39095 | 40200 | 765 |
1230945 | 1230945 | 2021-04-17 | Lucas | Ohio | 39095 | 40122 | 765 |
1227697 | 1227697 | 2021-04-16 | Lucas | Ohio | 39095 | 39984 | 765 |
1224449 | 1224449 | 2021-04-15 | Lucas | Ohio | 39095 | 39826 | 760 |
1221202 | 1221202 | 2021-04-14 | Lucas | Ohio | 39095 | 39675 | 760 |
1217954 | 1217954 | 2021-04-13 | Lucas | Ohio | 39095 | 39537 | 760 |
1214706 | 1214706 | 2021-04-12 | Lucas | Ohio | 39095 | 39366 | 757 |
1211459 | 1211459 | 2021-04-11 | Lucas | Ohio | 39095 | 39235 | 757 |
1208210 | 1208210 | 2021-04-10 | Lucas | Ohio | 39095 | 39105 | 757 |
1204962 | 1204962 | 2021-04-09 | Lucas | Ohio | 39095 | 38950 | 757 |
1201714 | 1201714 | 2021-04-08 | Lucas | Ohio | 39095 | 38790 | 752 |
1198465 | 1198465 | 2021-04-07 | Lucas | Ohio | 39095 | 38669 | 752 |
1195216 | 1195216 | 2021-04-06 | Lucas | Ohio | 39095 | 38545 | 752 |
1191968 | 1191968 | 2021-04-05 | Lucas | Ohio | 39095 | 38460 | 752 |
1188719 | 1188719 | 2021-04-04 | Lucas | Ohio | 39095 | 38282 | 752 |
1185472 | 1185472 | 2021-04-03 | Lucas | Ohio | 39095 | 38282 | 752 |
1182225 | 1182225 | 2021-04-02 | Lucas | Ohio | 39095 | 38171 | 752 |
1178978 | 1178978 | 2021-04-01 | Lucas | Ohio | 39095 | 38036 | 752 |
1175731 | 1175731 | 2021-03-31 | Lucas | Ohio | 39095 | 37894 | 752 |
1172484 | 1172484 | 2021-03-30 | Lucas | Ohio | 39095 | 37779 | 752 |
1169237 | 1169237 | 2021-03-29 | Lucas | Ohio | 39095 | 37624 | 751 |
1165989 | 1165989 | 2021-03-28 | Lucas | Ohio | 39095 | 37541 | 751 |
1162741 | 1162741 | 2021-03-27 | Lucas | Ohio | 39095 | 37451 | 751 |
1159492 | 1159492 | 2021-03-26 | Lucas | Ohio | 39095 | 37340 | 751 |
1156245 | 1156245 | 2021-03-25 | Lucas | Ohio | 39095 | 37167 | 743 |
1152998 | 1152998 | 2021-03-24 | Lucas | Ohio | 39095 | 37090 | 743 |
1149751 | 1149751 | 2021-03-23 | Lucas | Ohio | 39095 | 36983 | 743 |
1146504 | 1146504 | 2021-03-22 | Lucas | Ohio | 39095 | 36896 | 742 |
1143257 | 1143257 | 2021-03-21 | Lucas | Ohio | 39095 | 36838 | 742 |
1140010 | 1140010 | 2021-03-20 | Lucas | Ohio | 39095 | 36804 | 742 |
1136764 | 1136764 | 2021-03-19 | Lucas | Ohio | 39095 | 36728 | 742 |
1133518 | 1133518 | 2021-03-18 | Lucas | Ohio | 39095 | 36651 | 740 |
1130270 | 1130270 | 2021-03-17 | Lucas | Ohio | 39095 | 36570 | 740 |
1127023 | 1127023 | 2021-03-16 | Lucas | Ohio | 39095 | 36507 | 740 |
1123777 | 1123777 | 2021-03-15 | Lucas | Ohio | 39095 | 36422 | 738 |
1120531 | 1120531 | 2021-03-14 | Lucas | Ohio | 39095 | 36357 | 738 |
1117284 | 1117284 | 2021-03-13 | Lucas | Ohio | 39095 | 36319 | 738 |
1114037 | 1114037 | 2021-03-12 | Lucas | Ohio | 39095 | 36254 | 738 |
1110791 | 1110791 | 2021-03-11 | Lucas | Ohio | 39095 | 36155 | 726 |
1107545 | 1107545 | 2021-03-10 | Lucas | Ohio | 39095 | 36060 | 726 |
1104299 | 1104299 | 2021-03-09 | Lucas | Ohio | 39095 | 35943 | 726 |
1101053 | 1101053 | 2021-03-08 | Lucas | Ohio | 39095 | 35853 | 720 |
1097807 | 1097807 | 2021-03-07 | Lucas | Ohio | 39095 | 35802 | 720 |
1094559 | 1094559 | 2021-03-06 | Lucas | Ohio | 39095 | 35779 | 720 |
1091313 | 1091313 | 2021-03-05 | Lucas | Ohio | 39095 | 35685 | 720 |
1088068 | 1088068 | 2021-03-04 | Lucas | Ohio | 39095 | 35588 | 685 |
1084823 | 1084823 | 2021-03-03 | Lucas | Ohio | 39095 | 35489 | 685 |
1081577 | 1081577 | 2021-03-02 | Lucas | Ohio | 39095 | 35389 | 685 |
1078331 | 1078331 | 2021-03-01 | Lucas | Ohio | 39095 | 35279 | 767 |
1075086 | 1075086 | 2021-02-28 | Lucas | Ohio | 39095 | 35217 | 765 |
1071840 | 1071840 | 2021-02-27 | Lucas | Ohio | 39095 | 35149 | 761 |
1068594 | 1068594 | 2021-02-26 | Lucas | Ohio | 39095 | 35069 | 761 |
1065349 | 1065349 | 2021-02-25 | Lucas | Ohio | 39095 | 34971 | 757 |
1062105 | 1062105 | 2021-02-24 | Lucas | Ohio | 39095 | 34829 | 757 |
1058859 | 1058859 | 2021-02-23 | Lucas | Ohio | 39095 | 34724 | 755 |
1055613 | 1055613 | 2021-02-22 | Lucas | Ohio | 39095 | 34620 | 753 |
1052367 | 1052367 | 2021-02-21 | Lucas | Ohio | 39095 | 34531 | 753 |
1049120 | 1049120 | 2021-02-20 | Lucas | Ohio | 39095 | 34467 | 752 |
1045873 | 1045873 | 2021-02-19 | Lucas | Ohio | 39095 | 34348 | 749 |
1042628 | 1042628 | 2021-02-18 | Lucas | Ohio | 39095 | 34243 | 748 |
1039383 | 1039383 | 2021-02-17 | Lucas | Ohio | 39095 | 34174 | 747 |
1036138 | 1036138 | 2021-02-16 | Lucas | Ohio | 39095 | 34122 | 745 |
1032893 | 1032893 | 2021-02-15 | Lucas | Ohio | 39095 | 34075 | 745 |
1029647 | 1029647 | 2021-02-14 | Lucas | Ohio | 39095 | 34038 | 742 |
1026400 | 1026400 | 2021-02-13 | Lucas | Ohio | 39095 | 33963 | 742 |
1023155 | 1023155 | 2021-02-12 | Lucas | Ohio | 39095 | 33877 | 732 |
1019910 | 1019910 | 2021-02-11 | Lucas | Ohio | 39095 | 33762 | 709 |
1016665 | 1016665 | 2021-02-10 | Lucas | Ohio | 39095 | 33665 | 695 |
1013420 | 1013420 | 2021-02-09 | Lucas | Ohio | 39095 | 33564 | 692 |
1010175 | 1010175 | 2021-02-08 | Lucas | Ohio | 39095 | 33471 | 690 |
1006929 | 1006929 | 2021-02-07 | Lucas | Ohio | 39095 | 33414 | 690 |
1003683 | 1003683 | 2021-02-06 | Lucas | Ohio | 39095 | 33333 | 690 |
1000437 | 1000437 | 2021-02-05 | Lucas | Ohio | 39095 | 33215 | 690 |
997191 | 997191 | 2021-02-04 | Lucas | Ohio | 39095 | 33105 | 685 |
993945 | 993945 | 2021-02-03 | Lucas | Ohio | 39095 | 32974 | 682 |
990699 | 990699 | 2021-02-02 | Lucas | Ohio | 39095 | 32852 | 675 |
987453 | 987453 | 2021-02-01 | Lucas | Ohio | 39095 | 32747 | 669 |
984206 | 984206 | 2021-01-31 | Lucas | Ohio | 39095 | 32637 | 669 |
980959 | 980959 | 2021-01-30 | Lucas | Ohio | 39095 | 32531 | 667 |
977713 | 977713 | 2021-01-29 | Lucas | Ohio | 39095 | 32356 | 654 |
974468 | 974468 | 2021-01-28 | Lucas | Ohio | 39095 | 32130 | 648 |
971223 | 971223 | 2021-01-27 | Lucas | Ohio | 39095 | 31968 | 647 |
967978 | 967978 | 2021-01-26 | Lucas | Ohio | 39095 | 31794 | 634 |
964734 | 964734 | 2021-01-25 | Lucas | Ohio | 39095 | 31663 | 631 |
961489 | 961489 | 2021-01-24 | Lucas | Ohio | 39095 | 31500 | 625 |
958244 | 958244 | 2021-01-23 | Lucas | Ohio | 39095 | 31350 | 625 |
954998 | 954998 | 2021-01-22 | Lucas | Ohio | 39095 | 31151 | 616 |
951753 | 951753 | 2021-01-21 | Lucas | Ohio | 39095 | 31041 | 611 |
948508 | 948508 | 2021-01-20 | Lucas | Ohio | 39095 | 30760 | 609 |
945262 | 945262 | 2021-01-19 | Lucas | Ohio | 39095 | 30524 | 605 |
942015 | 942015 | 2021-01-18 | Lucas | Ohio | 39095 | 30316 | 597 |
938770 | 938770 | 2021-01-17 | Lucas | Ohio | 39095 | 30111 | 597 |
935525 | 935525 | 2021-01-16 | Lucas | Ohio | 39095 | 29981 | 591 |
932280 | 932280 | 2021-01-15 | Lucas | Ohio | 39095 | 29709 | 580 |
929035 | 929035 | 2021-01-14 | Lucas | Ohio | 39095 | 29495 | 575 |
925790 | 925790 | 2021-01-13 | Lucas | Ohio | 39095 | 29249 | 567 |
922544 | 922544 | 2021-01-12 | Lucas | Ohio | 39095 | 29047 | 565 |
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);