ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 42071 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279842 | 1279842 | 2021-05-02 | Lancaster | Pennsylvania | 42071 | 53445 | 1112 |
1276595 | 1276595 | 2021-05-01 | Lancaster | Pennsylvania | 42071 | 53334 | 1112 |
1273348 | 1273348 | 2021-04-30 | Lancaster | Pennsylvania | 42071 | 53202 | 1112 |
1270101 | 1270101 | 2021-04-29 | Lancaster | Pennsylvania | 42071 | 53029 | 1111 |
1266854 | 1266854 | 2021-04-28 | Lancaster | Pennsylvania | 42071 | 52895 | 1108 |
1263607 | 1263607 | 2021-04-27 | Lancaster | Pennsylvania | 42071 | 52725 | 1107 |
1260360 | 1260360 | 2021-04-26 | Lancaster | Pennsylvania | 42071 | 52602 | 1105 |
1257113 | 1257113 | 2021-04-25 | Lancaster | Pennsylvania | 42071 | 52510 | 1105 |
1253866 | 1253866 | 2021-04-24 | Lancaster | Pennsylvania | 42071 | 52360 | 1105 |
1250619 | 1250619 | 2021-04-23 | Lancaster | Pennsylvania | 42071 | 52209 | 1104 |
1247372 | 1247372 | 2021-04-22 | Lancaster | Pennsylvania | 42071 | 52041 | 1100 |
1244125 | 1244125 | 2021-04-21 | Lancaster | Pennsylvania | 42071 | 51803 | 1098 |
1240878 | 1240878 | 2021-04-20 | Lancaster | Pennsylvania | 42071 | 51619 | 1096 |
1237631 | 1237631 | 2021-04-19 | Lancaster | Pennsylvania | 42071 | 51426 | 1094 |
1234384 | 1234384 | 2021-04-18 | Lancaster | Pennsylvania | 42071 | 51347 | 1094 |
1231136 | 1231136 | 2021-04-17 | Lancaster | Pennsylvania | 42071 | 51164 | 1094 |
1227888 | 1227888 | 2021-04-16 | Lancaster | Pennsylvania | 42071 | 50949 | 1093 |
1224640 | 1224640 | 2021-04-15 | Lancaster | Pennsylvania | 42071 | 50699 | 1091 |
1221393 | 1221393 | 2021-04-14 | Lancaster | Pennsylvania | 42071 | 50487 | 1088 |
1218145 | 1218145 | 2021-04-13 | Lancaster | Pennsylvania | 42071 | 50283 | 1087 |
1214897 | 1214897 | 2021-04-12 | Lancaster | Pennsylvania | 42071 | 49979 | 1086 |
1211650 | 1211650 | 2021-04-11 | Lancaster | Pennsylvania | 42071 | 49812 | 1086 |
1208401 | 1208401 | 2021-04-10 | Lancaster | Pennsylvania | 42071 | 49665 | 1086 |
1205153 | 1205153 | 2021-04-09 | Lancaster | Pennsylvania | 42071 | 49469 | 1085 |
1201905 | 1201905 | 2021-04-08 | Lancaster | Pennsylvania | 42071 | 49282 | 1084 |
1198656 | 1198656 | 2021-04-07 | Lancaster | Pennsylvania | 42071 | 49099 | 1083 |
1195407 | 1195407 | 2021-04-06 | Lancaster | Pennsylvania | 42071 | 48920 | 1082 |
1192159 | 1192159 | 2021-04-05 | Lancaster | Pennsylvania | 42071 | 48771 | 1080 |
1188910 | 1188910 | 2021-04-04 | Lancaster | Pennsylvania | 42071 | 48681 | 1080 |
1185663 | 1185663 | 2021-04-03 | Lancaster | Pennsylvania | 42071 | 48481 | 1080 |
1182416 | 1182416 | 2021-04-02 | Lancaster | Pennsylvania | 42071 | 48232 | 1080 |
1179169 | 1179169 | 2021-04-01 | Lancaster | Pennsylvania | 42071 | 48010 | 1079 |
1175922 | 1175922 | 2021-03-31 | Lancaster | Pennsylvania | 42071 | 47817 | 1077 |
1172675 | 1172675 | 2021-03-30 | Lancaster | Pennsylvania | 42071 | 47656 | 1077 |
1169428 | 1169428 | 2021-03-29 | Lancaster | Pennsylvania | 42071 | 47420 | 1077 |
1166180 | 1166180 | 2021-03-28 | Lancaster | Pennsylvania | 42071 | 47271 | 1077 |
1162932 | 1162932 | 2021-03-27 | Lancaster | Pennsylvania | 42071 | 47113 | 1077 |
1159683 | 1159683 | 2021-03-26 | Lancaster | Pennsylvania | 42071 | 46948 | 1077 |
1156436 | 1156436 | 2021-03-25 | Lancaster | Pennsylvania | 42071 | 46758 | 1075 |
1153189 | 1153189 | 2021-03-24 | Lancaster | Pennsylvania | 42071 | 46596 | 1074 |
1149942 | 1149942 | 2021-03-23 | Lancaster | Pennsylvania | 42071 | 46403 | 1073 |
1146695 | 1146695 | 2021-03-22 | Lancaster | Pennsylvania | 42071 | 46275 | 1073 |
1143448 | 1143448 | 2021-03-21 | Lancaster | Pennsylvania | 42071 | 46207 | 1073 |
1140201 | 1140201 | 2021-03-20 | Lancaster | Pennsylvania | 42071 | 46125 | 1073 |
1136955 | 1136955 | 2021-03-19 | Lancaster | Pennsylvania | 42071 | 45968 | 1072 |
1133709 | 1133709 | 2021-03-18 | Lancaster | Pennsylvania | 42071 | 45838 | 1070 |
1130461 | 1130461 | 2021-03-17 | Lancaster | Pennsylvania | 42071 | 45695 | 1066 |
1127214 | 1127214 | 2021-03-16 | Lancaster | Pennsylvania | 42071 | 45542 | 1065 |
1123968 | 1123968 | 2021-03-15 | Lancaster | Pennsylvania | 42071 | 45397 | 1063 |
1120722 | 1120722 | 2021-03-14 | Lancaster | Pennsylvania | 42071 | 45335 | 1062 |
1117475 | 1117475 | 2021-03-13 | Lancaster | Pennsylvania | 42071 | 45247 | 1062 |
1114228 | 1114228 | 2021-03-12 | Lancaster | Pennsylvania | 42071 | 45127 | 1062 |
1110982 | 1110982 | 2021-03-11 | Lancaster | Pennsylvania | 42071 | 44965 | 1058 |
1107736 | 1107736 | 2021-03-10 | Lancaster | Pennsylvania | 42071 | 44833 | 1057 |
1104490 | 1104490 | 2021-03-09 | Lancaster | Pennsylvania | 42071 | 44684 | 1056 |
1101244 | 1101244 | 2021-03-08 | Lancaster | Pennsylvania | 42071 | 44556 | 1053 |
1097998 | 1097998 | 2021-03-07 | Lancaster | Pennsylvania | 42071 | 44480 | 1053 |
1094750 | 1094750 | 2021-03-06 | Lancaster | Pennsylvania | 42071 | 44383 | 1049 |
1091504 | 1091504 | 2021-03-05 | Lancaster | Pennsylvania | 42071 | 44249 | 1045 |
1088258 | 1088258 | 2021-03-04 | Lancaster | Pennsylvania | 42071 | 44116 | 1041 |
1085013 | 1085013 | 2021-03-03 | Lancaster | Pennsylvania | 42071 | 43951 | 1038 |
1081767 | 1081767 | 2021-03-02 | Lancaster | Pennsylvania | 42071 | 43809 | 1034 |
1078521 | 1078521 | 2021-03-01 | Lancaster | Pennsylvania | 42071 | 43705 | 1033 |
1075276 | 1075276 | 2021-02-28 | Lancaster | Pennsylvania | 42071 | 43630 | 1033 |
1072030 | 1072030 | 2021-02-27 | Lancaster | Pennsylvania | 42071 | 43527 | 1030 |
1068784 | 1068784 | 2021-02-26 | Lancaster | Pennsylvania | 42071 | 43348 | 1030 |
1065539 | 1065539 | 2021-02-25 | Lancaster | Pennsylvania | 42071 | 43240 | 1025 |
1062294 | 1062294 | 2021-02-24 | Lancaster | Pennsylvania | 42071 | 43120 | 1017 |
1059049 | 1059049 | 2021-02-23 | Lancaster | Pennsylvania | 42071 | 42945 | 1012 |
1055803 | 1055803 | 2021-02-22 | Lancaster | Pennsylvania | 42071 | 42843 | 1004 |
1052557 | 1052557 | 2021-02-21 | Lancaster | Pennsylvania | 42071 | 42740 | 1004 |
1049310 | 1049310 | 2021-02-20 | Lancaster | Pennsylvania | 42071 | 42660 | 1003 |
1046063 | 1046063 | 2021-02-19 | Lancaster | Pennsylvania | 42071 | 42502 | 998 |
1042818 | 1042818 | 2021-02-18 | Lancaster | Pennsylvania | 42071 | 42361 | 998 |
1039573 | 1039573 | 2021-02-17 | Lancaster | Pennsylvania | 42071 | 42180 | 989 |
1036328 | 1036328 | 2021-02-16 | Lancaster | Pennsylvania | 42071 | 41955 | 980 |
1033083 | 1033083 | 2021-02-15 | Lancaster | Pennsylvania | 42071 | 41851 | 980 |
1029837 | 1029837 | 2021-02-14 | Lancaster | Pennsylvania | 42071 | 41722 | 979 |
1026590 | 1026590 | 2021-02-13 | Lancaster | Pennsylvania | 42071 | 41546 | 979 |
1023345 | 1023345 | 2021-02-12 | Lancaster | Pennsylvania | 42071 | 41254 | 974 |
1020100 | 1020100 | 2021-02-11 | Lancaster | Pennsylvania | 42071 | 41059 | 970 |
1016855 | 1016855 | 2021-02-10 | Lancaster | Pennsylvania | 42071 | 40750 | 965 |
1013610 | 1013610 | 2021-02-09 | Lancaster | Pennsylvania | 42071 | 40554 | 961 |
1010365 | 1010365 | 2021-02-08 | Lancaster | Pennsylvania | 42071 | 40309 | 949 |
1007119 | 1007119 | 2021-02-07 | Lancaster | Pennsylvania | 42071 | 40175 | 949 |
1003873 | 1003873 | 2021-02-06 | Lancaster | Pennsylvania | 42071 | 39798 | 948 |
1000627 | 1000627 | 2021-02-05 | Lancaster | Pennsylvania | 42071 | 39492 | 944 |
997381 | 997381 | 2021-02-04 | Lancaster | Pennsylvania | 42071 | 39259 | 939 |
994135 | 994135 | 2021-02-03 | Lancaster | Pennsylvania | 42071 | 39065 | 935 |
990889 | 990889 | 2021-02-02 | Lancaster | Pennsylvania | 42071 | 38895 | 926 |
987643 | 987643 | 2021-02-01 | Lancaster | Pennsylvania | 42071 | 38660 | 923 |
984396 | 984396 | 2021-01-31 | Lancaster | Pennsylvania | 42071 | 38485 | 921 |
981149 | 981149 | 2021-01-30 | Lancaster | Pennsylvania | 42071 | 38168 | 918 |
977903 | 977903 | 2021-01-29 | Lancaster | Pennsylvania | 42071 | 37912 | 911 |
974658 | 974658 | 2021-01-28 | Lancaster | Pennsylvania | 42071 | 36945 | 903 |
971413 | 971413 | 2021-01-27 | Lancaster | Pennsylvania | 42071 | 36657 | 897 |
968168 | 968168 | 2021-01-26 | Lancaster | Pennsylvania | 42071 | 36283 | 885 |
964924 | 964924 | 2021-01-25 | Lancaster | Pennsylvania | 42071 | 36083 | 878 |
961679 | 961679 | 2021-01-24 | Lancaster | Pennsylvania | 42071 | 35871 | 876 |
958434 | 958434 | 2021-01-23 | Lancaster | Pennsylvania | 42071 | 35670 | 872 |
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);