ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Pike" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195423 | 1195423 | 2021-04-06 | Pike | Pennsylvania | 42103 | 3273 | 51 |
1192175 | 1192175 | 2021-04-05 | Pike | Pennsylvania | 42103 | 3243 | 51 |
1188926 | 1188926 | 2021-04-04 | Pike | Pennsylvania | 42103 | 3237 | 51 |
1185679 | 1185679 | 2021-04-03 | Pike | Pennsylvania | 42103 | 3223 | 51 |
1182432 | 1182432 | 2021-04-02 | Pike | Pennsylvania | 42103 | 3194 | 51 |
1179185 | 1179185 | 2021-04-01 | Pike | Pennsylvania | 42103 | 3179 | 51 |
1175938 | 1175938 | 2021-03-31 | Pike | Pennsylvania | 42103 | 3156 | 51 |
1172691 | 1172691 | 2021-03-30 | Pike | Pennsylvania | 42103 | 3129 | 51 |
1169444 | 1169444 | 2021-03-29 | Pike | Pennsylvania | 42103 | 3088 | 51 |
1166196 | 1166196 | 2021-03-28 | Pike | Pennsylvania | 42103 | 3083 | 51 |
1162948 | 1162948 | 2021-03-27 | Pike | Pennsylvania | 42103 | 3061 | 50 |
1159699 | 1159699 | 2021-03-26 | Pike | Pennsylvania | 42103 | 3036 | 50 |
1156452 | 1156452 | 2021-03-25 | Pike | Pennsylvania | 42103 | 3003 | 50 |
1153205 | 1153205 | 2021-03-24 | Pike | Pennsylvania | 42103 | 2984 | 50 |
1149958 | 1149958 | 2021-03-23 | Pike | Pennsylvania | 42103 | 2934 | 50 |
1146711 | 1146711 | 2021-03-22 | Pike | Pennsylvania | 42103 | 2912 | 50 |
1143464 | 1143464 | 2021-03-21 | Pike | Pennsylvania | 42103 | 2901 | 50 |
1140217 | 1140217 | 2021-03-20 | Pike | Pennsylvania | 42103 | 2889 | 49 |
1136971 | 1136971 | 2021-03-19 | Pike | Pennsylvania | 42103 | 2871 | 49 |
1133725 | 1133725 | 2021-03-18 | Pike | Pennsylvania | 42103 | 2835 | 48 |
1130477 | 1130477 | 2021-03-17 | Pike | Pennsylvania | 42103 | 2805 | 48 |
1127230 | 1127230 | 2021-03-16 | Pike | Pennsylvania | 42103 | 2771 | 48 |
1123984 | 1123984 | 2021-03-15 | Pike | Pennsylvania | 42103 | 2753 | 48 |
1120738 | 1120738 | 2021-03-14 | Pike | Pennsylvania | 42103 | 2742 | 48 |
1117491 | 1117491 | 2021-03-13 | Pike | Pennsylvania | 42103 | 2735 | 48 |
1114244 | 1114244 | 2021-03-12 | Pike | Pennsylvania | 42103 | 2722 | 48 |
1110998 | 1110998 | 2021-03-11 | Pike | Pennsylvania | 42103 | 2706 | 48 |
1107752 | 1107752 | 2021-03-10 | Pike | Pennsylvania | 42103 | 2677 | 48 |
1104506 | 1104506 | 2021-03-09 | Pike | Pennsylvania | 42103 | 2659 | 48 |
1101260 | 1101260 | 2021-03-08 | Pike | Pennsylvania | 42103 | 2644 | 48 |
1098014 | 1098014 | 2021-03-07 | Pike | Pennsylvania | 42103 | 2639 | 48 |
1094766 | 1094766 | 2021-03-06 | Pike | Pennsylvania | 42103 | 2629 | 48 |
1091520 | 1091520 | 2021-03-05 | Pike | Pennsylvania | 42103 | 2620 | 48 |
1088274 | 1088274 | 2021-03-04 | Pike | Pennsylvania | 42103 | 2593 | 48 |
1085029 | 1085029 | 2021-03-03 | Pike | Pennsylvania | 42103 | 2568 | 48 |
1081783 | 1081783 | 2021-03-02 | Pike | Pennsylvania | 42103 | 2535 | 48 |
1078537 | 1078537 | 2021-03-01 | Pike | Pennsylvania | 42103 | 2527 | 48 |
1075292 | 1075292 | 2021-02-28 | Pike | Pennsylvania | 42103 | 2519 | 48 |
1072046 | 1072046 | 2021-02-27 | Pike | Pennsylvania | 42103 | 2514 | 47 |
1068800 | 1068800 | 2021-02-26 | Pike | Pennsylvania | 42103 | 2496 | 47 |
1065555 | 1065555 | 2021-02-25 | Pike | Pennsylvania | 42103 | 2477 | 47 |
1062310 | 1062310 | 2021-02-24 | Pike | Pennsylvania | 42103 | 2461 | 47 |
1059065 | 1059065 | 2021-02-23 | Pike | Pennsylvania | 42103 | 2450 | 47 |
1055819 | 1055819 | 2021-02-22 | Pike | Pennsylvania | 42103 | 2437 | 46 |
1052573 | 1052573 | 2021-02-21 | Pike | Pennsylvania | 42103 | 2436 | 46 |
1049326 | 1049326 | 2021-02-20 | Pike | Pennsylvania | 42103 | 2434 | 46 |
1046079 | 1046079 | 2021-02-19 | Pike | Pennsylvania | 42103 | 2412 | 46 |
1042834 | 1042834 | 2021-02-18 | Pike | Pennsylvania | 42103 | 2397 | 46 |
1039589 | 1039589 | 2021-02-17 | Pike | Pennsylvania | 42103 | 2382 | 46 |
1036344 | 1036344 | 2021-02-16 | Pike | Pennsylvania | 42103 | 2372 | 46 |
1033099 | 1033099 | 2021-02-15 | Pike | Pennsylvania | 42103 | 2363 | 46 |
1029853 | 1029853 | 2021-02-14 | Pike | Pennsylvania | 42103 | 2353 | 46 |
1026606 | 1026606 | 2021-02-13 | Pike | Pennsylvania | 42103 | 2351 | 46 |
1023361 | 1023361 | 2021-02-12 | Pike | Pennsylvania | 42103 | 2333 | 45 |
1020116 | 1020116 | 2021-02-11 | Pike | Pennsylvania | 42103 | 2305 | 45 |
1016871 | 1016871 | 2021-02-10 | Pike | Pennsylvania | 42103 | 2287 | 45 |
1013626 | 1013626 | 2021-02-09 | Pike | Pennsylvania | 42103 | 2268 | 45 |
1010381 | 1010381 | 2021-02-08 | Pike | Pennsylvania | 42103 | 2254 | 45 |
1007135 | 1007135 | 2021-02-07 | Pike | Pennsylvania | 42103 | 2251 | 45 |
1003889 | 1003889 | 2021-02-06 | Pike | Pennsylvania | 42103 | 2221 | 45 |
1000643 | 1000643 | 2021-02-05 | Pike | Pennsylvania | 42103 | 2202 | 44 |
997397 | 997397 | 2021-02-04 | Pike | Pennsylvania | 42103 | 2189 | 44 |
994151 | 994151 | 2021-02-03 | Pike | Pennsylvania | 42103 | 2180 | 44 |
990905 | 990905 | 2021-02-02 | Pike | Pennsylvania | 42103 | 2174 | 44 |
987659 | 987659 | 2021-02-01 | Pike | Pennsylvania | 42103 | 2146 | 44 |
984412 | 984412 | 2021-01-31 | Pike | Pennsylvania | 42103 | 2133 | 44 |
981165 | 981165 | 2021-01-30 | Pike | Pennsylvania | 42103 | 2122 | 44 |
977919 | 977919 | 2021-01-29 | Pike | Pennsylvania | 42103 | 2104 | 44 |
974674 | 974674 | 2021-01-28 | Pike | Pennsylvania | 42103 | 2087 | 44 |
971429 | 971429 | 2021-01-27 | Pike | Pennsylvania | 42103 | 2063 | 43 |
968184 | 968184 | 2021-01-26 | Pike | Pennsylvania | 42103 | 2042 | 42 |
964940 | 964940 | 2021-01-25 | Pike | Pennsylvania | 42103 | 2024 | 42 |
961695 | 961695 | 2021-01-24 | Pike | Pennsylvania | 42103 | 2006 | 42 |
958450 | 958450 | 2021-01-23 | Pike | Pennsylvania | 42103 | 1995 | 42 |
955204 | 955204 | 2021-01-22 | Pike | Pennsylvania | 42103 | 1975 | 42 |
951959 | 951959 | 2021-01-21 | Pike | Pennsylvania | 42103 | 1960 | 42 |
948714 | 948714 | 2021-01-20 | Pike | Pennsylvania | 42103 | 1944 | 42 |
945468 | 945468 | 2021-01-19 | Pike | Pennsylvania | 42103 | 1917 | 38 |
942221 | 942221 | 2021-01-18 | Pike | Pennsylvania | 42103 | 1890 | 38 |
938976 | 938976 | 2021-01-17 | Pike | Pennsylvania | 42103 | 1863 | 38 |
935731 | 935731 | 2021-01-16 | Pike | Pennsylvania | 42103 | 1841 | 38 |
932486 | 932486 | 2021-01-15 | Pike | Pennsylvania | 42103 | 1822 | 38 |
929241 | 929241 | 2021-01-14 | Pike | Pennsylvania | 42103 | 1798 | 38 |
925996 | 925996 | 2021-01-13 | Pike | Pennsylvania | 42103 | 1779 | 37 |
922750 | 922750 | 2021-01-12 | Pike | Pennsylvania | 42103 | 1756 | 36 |
919505 | 919505 | 2021-01-11 | Pike | Pennsylvania | 42103 | 1720 | 36 |
916260 | 916260 | 2021-01-10 | Pike | Pennsylvania | 42103 | 1702 | 36 |
913015 | 913015 | 2021-01-09 | Pike | Pennsylvania | 42103 | 1685 | 36 |
909770 | 909770 | 2021-01-08 | Pike | Pennsylvania | 42103 | 1645 | 35 |
906525 | 906525 | 2021-01-07 | Pike | Pennsylvania | 42103 | 1613 | 35 |
903279 | 903279 | 2021-01-06 | Pike | Pennsylvania | 42103 | 1576 | 34 |
900034 | 900034 | 2021-01-05 | Pike | Pennsylvania | 42103 | 1529 | 34 |
896789 | 896789 | 2021-01-04 | Pike | Pennsylvania | 42103 | 1506 | 34 |
893543 | 893543 | 2021-01-03 | Pike | Pennsylvania | 42103 | 1503 | 33 |
890297 | 890297 | 2021-01-02 | Pike | Pennsylvania | 42103 | 1495 | 33 |
887050 | 887050 | 2021-01-01 | Pike | Pennsylvania | 42103 | 1462 | 33 |
883805 | 883805 | 2020-12-31 | Pike | Pennsylvania | 42103 | 1440 | 33 |
880560 | 880560 | 2020-12-30 | Pike | Pennsylvania | 42103 | 1401 | 33 |
877315 | 877315 | 2020-12-29 | Pike | Pennsylvania | 42103 | 1375 | 33 |
874070 | 874070 | 2020-12-28 | Pike | Pennsylvania | 42103 | 1365 | 32 |
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);