ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Delaware" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195394 | 1195394 | 2021-04-06 | Delaware | Pennsylvania | 42045 | 45953 | 1346 |
1192146 | 1192146 | 2021-04-05 | Delaware | Pennsylvania | 42045 | 45808 | 1346 |
1188897 | 1188897 | 2021-04-04 | Delaware | Pennsylvania | 42045 | 45656 | 1346 |
1185650 | 1185650 | 2021-04-03 | Delaware | Pennsylvania | 42045 | 45443 | 1346 |
1182403 | 1182403 | 2021-04-02 | Delaware | Pennsylvania | 42045 | 45211 | 1346 |
1179156 | 1179156 | 2021-04-01 | Delaware | Pennsylvania | 42045 | 44969 | 1345 |
1175909 | 1175909 | 2021-03-31 | Delaware | Pennsylvania | 42045 | 44791 | 1341 |
1172662 | 1172662 | 2021-03-30 | Delaware | Pennsylvania | 42045 | 44618 | 1339 |
1169415 | 1169415 | 2021-03-29 | Delaware | Pennsylvania | 42045 | 44363 | 1339 |
1166167 | 1166167 | 2021-03-28 | Delaware | Pennsylvania | 42045 | 44208 | 1338 |
1162919 | 1162919 | 2021-03-27 | Delaware | Pennsylvania | 42045 | 44040 | 1338 |
1159670 | 1159670 | 2021-03-26 | Delaware | Pennsylvania | 42045 | 43859 | 1338 |
1156423 | 1156423 | 2021-03-25 | Delaware | Pennsylvania | 42045 | 43647 | 1332 |
1153176 | 1153176 | 2021-03-24 | Delaware | Pennsylvania | 42045 | 43530 | 1332 |
1149929 | 1149929 | 2021-03-23 | Delaware | Pennsylvania | 42045 | 43357 | 1322 |
1146682 | 1146682 | 2021-03-22 | Delaware | Pennsylvania | 42045 | 43248 | 1322 |
1143435 | 1143435 | 2021-03-21 | Delaware | Pennsylvania | 42045 | 43191 | 1322 |
1140188 | 1140188 | 2021-03-20 | Delaware | Pennsylvania | 42045 | 43081 | 1322 |
1136942 | 1136942 | 2021-03-19 | Delaware | Pennsylvania | 42045 | 42897 | 1322 |
1133696 | 1133696 | 2021-03-18 | Delaware | Pennsylvania | 42045 | 42772 | 1322 |
1130448 | 1130448 | 2021-03-17 | Delaware | Pennsylvania | 42045 | 42704 | 1308 |
1127201 | 1127201 | 2021-03-16 | Delaware | Pennsylvania | 42045 | 42598 | 1308 |
1123955 | 1123955 | 2021-03-15 | Delaware | Pennsylvania | 42045 | 42502 | 1305 |
1120709 | 1120709 | 2021-03-14 | Delaware | Pennsylvania | 42045 | 42429 | 1305 |
1117462 | 1117462 | 2021-03-13 | Delaware | Pennsylvania | 42045 | 42325 | 1305 |
1114215 | 1114215 | 2021-03-12 | Delaware | Pennsylvania | 42045 | 42232 | 1305 |
1110969 | 1110969 | 2021-03-11 | Delaware | Pennsylvania | 42045 | 42118 | 1298 |
1107723 | 1107723 | 2021-03-10 | Delaware | Pennsylvania | 42045 | 42015 | 1294 |
1104477 | 1104477 | 2021-03-09 | Delaware | Pennsylvania | 42045 | 41923 | 1294 |
1101231 | 1101231 | 2021-03-08 | Delaware | Pennsylvania | 42045 | 41841 | 1294 |
1097985 | 1097985 | 2021-03-07 | Delaware | Pennsylvania | 42045 | 41765 | 1293 |
1094737 | 1094737 | 2021-03-06 | Delaware | Pennsylvania | 42045 | 41601 | 1293 |
1091491 | 1091491 | 2021-03-05 | Delaware | Pennsylvania | 42045 | 41427 | 1293 |
1088245 | 1088245 | 2021-03-04 | Delaware | Pennsylvania | 42045 | 41315 | 1290 |
1085000 | 1085000 | 2021-03-03 | Delaware | Pennsylvania | 42045 | 41224 | 1288 |
1081754 | 1081754 | 2021-03-02 | Delaware | Pennsylvania | 42045 | 41132 | 1277 |
1078508 | 1078508 | 2021-03-01 | Delaware | Pennsylvania | 42045 | 41033 | 1276 |
1075263 | 1075263 | 2021-02-28 | Delaware | Pennsylvania | 42045 | 40957 | 1272 |
1072017 | 1072017 | 2021-02-27 | Delaware | Pennsylvania | 42045 | 40849 | 1272 |
1068771 | 1068771 | 2021-02-26 | Delaware | Pennsylvania | 42045 | 40700 | 1272 |
1065526 | 1065526 | 2021-02-25 | Delaware | Pennsylvania | 42045 | 40512 | 1270 |
1062281 | 1062281 | 2021-02-24 | Delaware | Pennsylvania | 42045 | 40383 | 1270 |
1059036 | 1059036 | 2021-02-23 | Delaware | Pennsylvania | 42045 | 40241 | 1261 |
1055790 | 1055790 | 2021-02-22 | Delaware | Pennsylvania | 42045 | 40132 | 1261 |
1052544 | 1052544 | 2021-02-21 | Delaware | Pennsylvania | 42045 | 40052 | 1261 |
1049297 | 1049297 | 2021-02-20 | Delaware | Pennsylvania | 42045 | 39983 | 1261 |
1046050 | 1046050 | 2021-02-19 | Delaware | Pennsylvania | 42045 | 39905 | 1261 |
1042805 | 1042805 | 2021-02-18 | Delaware | Pennsylvania | 42045 | 39778 | 1250 |
1039560 | 1039560 | 2021-02-17 | Delaware | Pennsylvania | 42045 | 39642 | 1250 |
1036315 | 1036315 | 2021-02-16 | Delaware | Pennsylvania | 42045 | 39479 | 1238 |
1033070 | 1033070 | 2021-02-15 | Delaware | Pennsylvania | 42045 | 39393 | 1236 |
1029824 | 1029824 | 2021-02-14 | Delaware | Pennsylvania | 42045 | 39312 | 1236 |
1026577 | 1026577 | 2021-02-13 | Delaware | Pennsylvania | 42045 | 39222 | 1236 |
1023332 | 1023332 | 2021-02-12 | Delaware | Pennsylvania | 42045 | 39041 | 1236 |
1020087 | 1020087 | 2021-02-11 | Delaware | Pennsylvania | 42045 | 38901 | 1232 |
1016842 | 1016842 | 2021-02-10 | Delaware | Pennsylvania | 42045 | 38751 | 1230 |
1013597 | 1013597 | 2021-02-09 | Delaware | Pennsylvania | 42045 | 38616 | 1213 |
1010352 | 1010352 | 2021-02-08 | Delaware | Pennsylvania | 42045 | 38461 | 1199 |
1007106 | 1007106 | 2021-02-07 | Delaware | Pennsylvania | 42045 | 38324 | 1199 |
1003860 | 1003860 | 2021-02-06 | Delaware | Pennsylvania | 42045 | 38137 | 1199 |
1000614 | 1000614 | 2021-02-05 | Delaware | Pennsylvania | 42045 | 37983 | 1199 |
997368 | 997368 | 2021-02-04 | Delaware | Pennsylvania | 42045 | 37868 | 1199 |
994122 | 994122 | 2021-02-03 | Delaware | Pennsylvania | 42045 | 37727 | 1200 |
990876 | 990876 | 2021-02-02 | Delaware | Pennsylvania | 42045 | 37617 | 1192 |
987630 | 987630 | 2021-02-01 | Delaware | Pennsylvania | 42045 | 37443 | 1190 |
984383 | 984383 | 2021-01-31 | Delaware | Pennsylvania | 42045 | 37339 | 1190 |
981136 | 981136 | 2021-01-30 | Delaware | Pennsylvania | 42045 | 37190 | 1190 |
977890 | 977890 | 2021-01-29 | Delaware | Pennsylvania | 42045 | 37027 | 1190 |
974645 | 974645 | 2021-01-28 | Delaware | Pennsylvania | 42045 | 36636 | 1170 |
971400 | 971400 | 2021-01-27 | Delaware | Pennsylvania | 42045 | 36447 | 1116 |
968155 | 968155 | 2021-01-26 | Delaware | Pennsylvania | 42045 | 36252 | 1110 |
964911 | 964911 | 2021-01-25 | Delaware | Pennsylvania | 42045 | 36048 | 1104 |
961666 | 961666 | 2021-01-24 | Delaware | Pennsylvania | 42045 | 35855 | 1103 |
958421 | 958421 | 2021-01-23 | Delaware | Pennsylvania | 42045 | 35642 | 1103 |
955175 | 955175 | 2021-01-22 | Delaware | Pennsylvania | 42045 | 35351 | 1097 |
951930 | 951930 | 2021-01-21 | Delaware | Pennsylvania | 42045 | 35169 | 1090 |
948685 | 948685 | 2021-01-20 | Delaware | Pennsylvania | 42045 | 34955 | 1080 |
945439 | 945439 | 2021-01-19 | Delaware | Pennsylvania | 42045 | 34717 | 1062 |
942192 | 942192 | 2021-01-18 | Delaware | Pennsylvania | 42045 | 34536 | 1059 |
938947 | 938947 | 2021-01-17 | Delaware | Pennsylvania | 42045 | 34398 | 1057 |
935702 | 935702 | 2021-01-16 | Delaware | Pennsylvania | 42045 | 34188 | 1053 |
932457 | 932457 | 2021-01-15 | Delaware | Pennsylvania | 42045 | 33933 | 1053 |
929212 | 929212 | 2021-01-14 | Delaware | Pennsylvania | 42045 | 33696 | 1049 |
925967 | 925967 | 2021-01-13 | Delaware | Pennsylvania | 42045 | 33407 | 1049 |
922721 | 922721 | 2021-01-12 | Delaware | Pennsylvania | 42045 | 33132 | 1024 |
919476 | 919476 | 2021-01-11 | Delaware | Pennsylvania | 42045 | 32836 | 1024 |
916231 | 916231 | 2021-01-10 | Delaware | Pennsylvania | 42045 | 32640 | 1023 |
912986 | 912986 | 2021-01-09 | Delaware | Pennsylvania | 42045 | 32337 | 1023 |
909741 | 909741 | 2021-01-08 | Delaware | Pennsylvania | 42045 | 32008 | 1023 |
906496 | 906496 | 2021-01-07 | Delaware | Pennsylvania | 42045 | 31675 | 1022 |
903250 | 903250 | 2021-01-06 | Delaware | Pennsylvania | 42045 | 31063 | 1016 |
900005 | 900005 | 2021-01-05 | Delaware | Pennsylvania | 42045 | 30786 | 1000 |
896760 | 896760 | 2021-01-04 | Delaware | Pennsylvania | 42045 | 30443 | 999 |
893514 | 893514 | 2021-01-03 | Delaware | Pennsylvania | 42045 | 30337 | 993 |
890268 | 890268 | 2021-01-02 | Delaware | Pennsylvania | 42045 | 30182 | 993 |
887021 | 887021 | 2021-01-01 | Delaware | Pennsylvania | 42045 | 29944 | 993 |
883776 | 883776 | 2020-12-31 | Delaware | Pennsylvania | 42045 | 29745 | 993 |
880531 | 880531 | 2020-12-30 | Delaware | Pennsylvania | 42045 | 29371 | 990 |
877286 | 877286 | 2020-12-29 | Delaware | Pennsylvania | 42045 | 28738 | 973 |
874041 | 874041 | 2020-12-28 | Delaware | Pennsylvania | 42045 | 28406 | 956 |
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);