ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 42111 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419446 | 1419446 | 2021-06-14 | Somerset | Pennsylvania | 42111 | 8035 | 216 |
1416201 | 1416201 | 2021-06-13 | Somerset | Pennsylvania | 42111 | 8034 | 216 |
1412955 | 1412955 | 2021-06-12 | Somerset | Pennsylvania | 42111 | 8033 | 216 |
1409710 | 1409710 | 2021-06-11 | Somerset | Pennsylvania | 42111 | 8032 | 216 |
1406465 | 1406465 | 2021-06-10 | Somerset | Pennsylvania | 42111 | 8025 | 215 |
1403219 | 1403219 | 2021-06-09 | Somerset | Pennsylvania | 42111 | 8020 | 214 |
1399974 | 1399974 | 2021-06-08 | Somerset | Pennsylvania | 42111 | 8016 | 214 |
1396729 | 1396729 | 2021-06-07 | Somerset | Pennsylvania | 42111 | 8017 | 213 |
1393482 | 1393482 | 2021-06-06 | Somerset | Pennsylvania | 42111 | 8017 | 213 |
1390237 | 1390237 | 2021-06-05 | Somerset | Pennsylvania | 42111 | 8016 | 213 |
1386992 | 1386992 | 2021-06-04 | Somerset | Pennsylvania | 42111 | 8012 | 213 |
1383747 | 1383747 | 2021-06-03 | Somerset | Pennsylvania | 42111 | 8004 | 213 |
1380501 | 1380501 | 2021-06-02 | Somerset | Pennsylvania | 42111 | 8002 | 213 |
1377256 | 1377256 | 2021-06-01 | Somerset | Pennsylvania | 42111 | 7995 | 212 |
1374010 | 1374010 | 2021-05-31 | Somerset | Pennsylvania | 42111 | 7989 | 212 |
1370765 | 1370765 | 2021-05-30 | Somerset | Pennsylvania | 42111 | 7985 | 212 |
1367519 | 1367519 | 2021-05-29 | Somerset | Pennsylvania | 42111 | 7980 | 212 |
1364273 | 1364273 | 2021-05-28 | Somerset | Pennsylvania | 42111 | 7967 | 212 |
1361027 | 1361027 | 2021-05-27 | Somerset | Pennsylvania | 42111 | 7964 | 212 |
1357781 | 1357781 | 2021-05-26 | Somerset | Pennsylvania | 42111 | 7951 | 211 |
1354535 | 1354535 | 2021-05-25 | Somerset | Pennsylvania | 42111 | 7937 | 210 |
1351289 | 1351289 | 2021-05-24 | Somerset | Pennsylvania | 42111 | 7924 | 209 |
1348043 | 1348043 | 2021-05-23 | Somerset | Pennsylvania | 42111 | 7923 | 209 |
1344795 | 1344795 | 2021-05-22 | Somerset | Pennsylvania | 42111 | 7903 | 208 |
1341547 | 1341547 | 2021-05-21 | Somerset | Pennsylvania | 42111 | 7903 | 208 |
1338299 | 1338299 | 2021-05-20 | Somerset | Pennsylvania | 42111 | 7877 | 208 |
1335052 | 1335052 | 2021-05-19 | Somerset | Pennsylvania | 42111 | 7852 | 208 |
1331805 | 1331805 | 2021-05-18 | Somerset | Pennsylvania | 42111 | 7842 | 208 |
1328558 | 1328558 | 2021-05-17 | Somerset | Pennsylvania | 42111 | 7819 | 207 |
1325312 | 1325312 | 2021-05-16 | Somerset | Pennsylvania | 42111 | 7809 | 207 |
1322066 | 1322066 | 2021-05-15 | Somerset | Pennsylvania | 42111 | 7803 | 207 |
1318820 | 1318820 | 2021-05-14 | Somerset | Pennsylvania | 42111 | 7784 | 207 |
1315572 | 1315572 | 2021-05-13 | Somerset | Pennsylvania | 42111 | 7768 | 207 |
1312326 | 1312326 | 2021-05-12 | Somerset | Pennsylvania | 42111 | 7761 | 207 |
1309079 | 1309079 | 2021-05-11 | Somerset | Pennsylvania | 42111 | 7741 | 205 |
1305833 | 1305833 | 2021-05-10 | Somerset | Pennsylvania | 42111 | 7728 | 205 |
1302587 | 1302587 | 2021-05-09 | Somerset | Pennsylvania | 42111 | 7722 | 205 |
1299340 | 1299340 | 2021-05-08 | Somerset | Pennsylvania | 42111 | 7717 | 205 |
1296093 | 1296093 | 2021-05-07 | Somerset | Pennsylvania | 42111 | 7689 | 203 |
1292847 | 1292847 | 2021-05-06 | Somerset | Pennsylvania | 42111 | 7671 | 203 |
1289601 | 1289601 | 2021-05-05 | Somerset | Pennsylvania | 42111 | 7649 | 202 |
1286355 | 1286355 | 2021-05-04 | Somerset | Pennsylvania | 42111 | 7639 | 201 |
1283109 | 1283109 | 2021-05-03 | Somerset | Pennsylvania | 42111 | 7622 | 201 |
1279862 | 1279862 | 2021-05-02 | Somerset | Pennsylvania | 42111 | 7604 | 201 |
1276615 | 1276615 | 2021-05-01 | Somerset | Pennsylvania | 42111 | 7576 | 201 |
1273368 | 1273368 | 2021-04-30 | Somerset | Pennsylvania | 42111 | 7563 | 201 |
1270121 | 1270121 | 2021-04-29 | Somerset | Pennsylvania | 42111 | 7522 | 201 |
1266874 | 1266874 | 2021-04-28 | Somerset | Pennsylvania | 42111 | 7497 | 200 |
1263627 | 1263627 | 2021-04-27 | Somerset | Pennsylvania | 42111 | 7469 | 198 |
1260380 | 1260380 | 2021-04-26 | Somerset | Pennsylvania | 42111 | 7444 | 196 |
1257133 | 1257133 | 2021-04-25 | Somerset | Pennsylvania | 42111 | 7437 | 196 |
1253886 | 1253886 | 2021-04-24 | Somerset | Pennsylvania | 42111 | 7416 | 196 |
1250639 | 1250639 | 2021-04-23 | Somerset | Pennsylvania | 42111 | 7388 | 195 |
1247392 | 1247392 | 2021-04-22 | Somerset | Pennsylvania | 42111 | 7366 | 195 |
1244145 | 1244145 | 2021-04-21 | Somerset | Pennsylvania | 42111 | 7334 | 195 |
1240898 | 1240898 | 2021-04-20 | Somerset | Pennsylvania | 42111 | 7316 | 195 |
1237651 | 1237651 | 2021-04-19 | Somerset | Pennsylvania | 42111 | 7288 | 193 |
1234404 | 1234404 | 2021-04-18 | Somerset | Pennsylvania | 42111 | 7281 | 193 |
1231156 | 1231156 | 2021-04-17 | Somerset | Pennsylvania | 42111 | 7261 | 193 |
1227908 | 1227908 | 2021-04-16 | Somerset | Pennsylvania | 42111 | 7238 | 193 |
1224660 | 1224660 | 2021-04-15 | Somerset | Pennsylvania | 42111 | 7220 | 193 |
1221413 | 1221413 | 2021-04-14 | Somerset | Pennsylvania | 42111 | 7200 | 192 |
1218165 | 1218165 | 2021-04-13 | Somerset | Pennsylvania | 42111 | 7165 | 192 |
1214917 | 1214917 | 2021-04-12 | Somerset | Pennsylvania | 42111 | 7128 | 192 |
1211670 | 1211670 | 2021-04-11 | Somerset | Pennsylvania | 42111 | 7119 | 192 |
1208421 | 1208421 | 2021-04-10 | Somerset | Pennsylvania | 42111 | 7095 | 192 |
1205173 | 1205173 | 2021-04-09 | Somerset | Pennsylvania | 42111 | 7088 | 191 |
1201925 | 1201925 | 2021-04-08 | Somerset | Pennsylvania | 42111 | 7066 | 191 |
1198676 | 1198676 | 2021-04-07 | Somerset | Pennsylvania | 42111 | 7058 | 191 |
1195427 | 1195427 | 2021-04-06 | Somerset | Pennsylvania | 42111 | 7047 | 190 |
1192179 | 1192179 | 2021-04-05 | Somerset | Pennsylvania | 42111 | 7020 | 190 |
1188930 | 1188930 | 2021-04-04 | Somerset | Pennsylvania | 42111 | 7018 | 190 |
1185683 | 1185683 | 2021-04-03 | Somerset | Pennsylvania | 42111 | 7013 | 190 |
1182436 | 1182436 | 2021-04-02 | Somerset | Pennsylvania | 42111 | 6983 | 190 |
1179189 | 1179189 | 2021-04-01 | Somerset | Pennsylvania | 42111 | 6973 | 190 |
1175942 | 1175942 | 2021-03-31 | Somerset | Pennsylvania | 42111 | 6970 | 189 |
1172695 | 1172695 | 2021-03-30 | Somerset | Pennsylvania | 42111 | 6954 | 188 |
1169448 | 1169448 | 2021-03-29 | Somerset | Pennsylvania | 42111 | 6950 | 188 |
1166200 | 1166200 | 2021-03-28 | Somerset | Pennsylvania | 42111 | 6933 | 187 |
1162952 | 1162952 | 2021-03-27 | Somerset | Pennsylvania | 42111 | 6921 | 187 |
1159703 | 1159703 | 2021-03-26 | Somerset | Pennsylvania | 42111 | 6907 | 187 |
1156456 | 1156456 | 2021-03-25 | Somerset | Pennsylvania | 42111 | 6899 | 186 |
1153209 | 1153209 | 2021-03-24 | Somerset | Pennsylvania | 42111 | 6888 | 186 |
1149962 | 1149962 | 2021-03-23 | Somerset | Pennsylvania | 42111 | 6875 | 185 |
1146715 | 1146715 | 2021-03-22 | Somerset | Pennsylvania | 42111 | 6859 | 185 |
1143468 | 1143468 | 2021-03-21 | Somerset | Pennsylvania | 42111 | 6855 | 185 |
1140221 | 1140221 | 2021-03-20 | Somerset | Pennsylvania | 42111 | 6850 | 185 |
1136975 | 1136975 | 2021-03-19 | Somerset | Pennsylvania | 42111 | 6842 | 185 |
1133729 | 1133729 | 2021-03-18 | Somerset | Pennsylvania | 42111 | 6835 | 185 |
1130481 | 1130481 | 2021-03-17 | Somerset | Pennsylvania | 42111 | 6824 | 186 |
1127234 | 1127234 | 2021-03-16 | Somerset | Pennsylvania | 42111 | 6811 | 186 |
1123988 | 1123988 | 2021-03-15 | Somerset | Pennsylvania | 42111 | 6797 | 186 |
1120742 | 1120742 | 2021-03-14 | Somerset | Pennsylvania | 42111 | 6795 | 186 |
1117495 | 1117495 | 2021-03-13 | Somerset | Pennsylvania | 42111 | 6791 | 186 |
1114248 | 1114248 | 2021-03-12 | Somerset | Pennsylvania | 42111 | 6775 | 186 |
1111002 | 1111002 | 2021-03-11 | Somerset | Pennsylvania | 42111 | 6768 | 186 |
1107756 | 1107756 | 2021-03-10 | Somerset | Pennsylvania | 42111 | 6763 | 186 |
1104510 | 1104510 | 2021-03-09 | Somerset | Pennsylvania | 42111 | 6750 | 186 |
1101264 | 1101264 | 2021-03-08 | Somerset | Pennsylvania | 42111 | 6725 | 186 |
1098018 | 1098018 | 2021-03-07 | Somerset | Pennsylvania | 42111 | 6723 | 186 |
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);