ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Elk" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419414 | 1419414 | 2021-06-14 | Elk | Pennsylvania | 42047 | 2868 | 41 |
1416169 | 1416169 | 2021-06-13 | Elk | Pennsylvania | 42047 | 2868 | 41 |
1412923 | 1412923 | 2021-06-12 | Elk | Pennsylvania | 42047 | 2868 | 41 |
1409678 | 1409678 | 2021-06-11 | Elk | Pennsylvania | 42047 | 2867 | 40 |
1406433 | 1406433 | 2021-06-10 | Elk | Pennsylvania | 42047 | 2866 | 40 |
1403187 | 1403187 | 2021-06-09 | Elk | Pennsylvania | 42047 | 2866 | 40 |
1399942 | 1399942 | 2021-06-08 | Elk | Pennsylvania | 42047 | 2866 | 40 |
1396697 | 1396697 | 2021-06-07 | Elk | Pennsylvania | 42047 | 2866 | 40 |
1393450 | 1393450 | 2021-06-06 | Elk | Pennsylvania | 42047 | 2865 | 40 |
1390205 | 1390205 | 2021-06-05 | Elk | Pennsylvania | 42047 | 2865 | 40 |
1386960 | 1386960 | 2021-06-04 | Elk | Pennsylvania | 42047 | 2865 | 40 |
1383715 | 1383715 | 2021-06-03 | Elk | Pennsylvania | 42047 | 2865 | 40 |
1380469 | 1380469 | 2021-06-02 | Elk | Pennsylvania | 42047 | 2864 | 39 |
1377224 | 1377224 | 2021-06-01 | Elk | Pennsylvania | 42047 | 2861 | 39 |
1373978 | 1373978 | 2021-05-31 | Elk | Pennsylvania | 42047 | 2859 | 39 |
1370733 | 1370733 | 2021-05-30 | Elk | Pennsylvania | 42047 | 2859 | 39 |
1367487 | 1367487 | 2021-05-29 | Elk | Pennsylvania | 42047 | 2859 | 39 |
1364241 | 1364241 | 2021-05-28 | Elk | Pennsylvania | 42047 | 2858 | 39 |
1360995 | 1360995 | 2021-05-27 | Elk | Pennsylvania | 42047 | 2858 | 39 |
1357749 | 1357749 | 2021-05-26 | Elk | Pennsylvania | 42047 | 2856 | 39 |
1354503 | 1354503 | 2021-05-25 | Elk | Pennsylvania | 42047 | 2856 | 39 |
1351257 | 1351257 | 2021-05-24 | Elk | Pennsylvania | 42047 | 2856 | 39 |
1348011 | 1348011 | 2021-05-23 | Elk | Pennsylvania | 42047 | 2855 | 39 |
1344763 | 1344763 | 2021-05-22 | Elk | Pennsylvania | 42047 | 2854 | 39 |
1341515 | 1341515 | 2021-05-21 | Elk | Pennsylvania | 42047 | 2854 | 39 |
1338267 | 1338267 | 2021-05-20 | Elk | Pennsylvania | 42047 | 2852 | 39 |
1335020 | 1335020 | 2021-05-19 | Elk | Pennsylvania | 42047 | 2851 | 39 |
1331773 | 1331773 | 2021-05-18 | Elk | Pennsylvania | 42047 | 2851 | 39 |
1328526 | 1328526 | 2021-05-17 | Elk | Pennsylvania | 42047 | 2847 | 39 |
1325280 | 1325280 | 2021-05-16 | Elk | Pennsylvania | 42047 | 2847 | 39 |
1322034 | 1322034 | 2021-05-15 | Elk | Pennsylvania | 42047 | 2847 | 39 |
1318788 | 1318788 | 2021-05-14 | Elk | Pennsylvania | 42047 | 2837 | 39 |
1315540 | 1315540 | 2021-05-13 | Elk | Pennsylvania | 42047 | 2836 | 39 |
1312294 | 1312294 | 2021-05-12 | Elk | Pennsylvania | 42047 | 2834 | 39 |
1309047 | 1309047 | 2021-05-11 | Elk | Pennsylvania | 42047 | 2832 | 39 |
1305801 | 1305801 | 2021-05-10 | Elk | Pennsylvania | 42047 | 2827 | 39 |
1302555 | 1302555 | 2021-05-09 | Elk | Pennsylvania | 42047 | 2826 | 39 |
1299308 | 1299308 | 2021-05-08 | Elk | Pennsylvania | 42047 | 2825 | 39 |
1296061 | 1296061 | 2021-05-07 | Elk | Pennsylvania | 42047 | 2823 | 38 |
1292815 | 1292815 | 2021-05-06 | Elk | Pennsylvania | 42047 | 2821 | 38 |
1289569 | 1289569 | 2021-05-05 | Elk | Pennsylvania | 42047 | 2818 | 38 |
1286323 | 1286323 | 2021-05-04 | Elk | Pennsylvania | 42047 | 2816 | 38 |
1283077 | 1283077 | 2021-05-03 | Elk | Pennsylvania | 42047 | 2812 | 38 |
1279830 | 1279830 | 2021-05-02 | Elk | Pennsylvania | 42047 | 2810 | 38 |
1276583 | 1276583 | 2021-05-01 | Elk | Pennsylvania | 42047 | 2809 | 38 |
1273336 | 1273336 | 2021-04-30 | Elk | Pennsylvania | 42047 | 2804 | 38 |
1270089 | 1270089 | 2021-04-29 | Elk | Pennsylvania | 42047 | 2800 | 38 |
1266842 | 1266842 | 2021-04-28 | Elk | Pennsylvania | 42047 | 2794 | 38 |
1263595 | 1263595 | 2021-04-27 | Elk | Pennsylvania | 42047 | 2793 | 38 |
1260348 | 1260348 | 2021-04-26 | Elk | Pennsylvania | 42047 | 2785 | 38 |
1257101 | 1257101 | 2021-04-25 | Elk | Pennsylvania | 42047 | 2780 | 38 |
1253854 | 1253854 | 2021-04-24 | Elk | Pennsylvania | 42047 | 2775 | 38 |
1250607 | 1250607 | 2021-04-23 | Elk | Pennsylvania | 42047 | 2771 | 38 |
1247360 | 1247360 | 2021-04-22 | Elk | Pennsylvania | 42047 | 2761 | 38 |
1244113 | 1244113 | 2021-04-21 | Elk | Pennsylvania | 42047 | 2757 | 38 |
1240866 | 1240866 | 2021-04-20 | Elk | Pennsylvania | 42047 | 2749 | 38 |
1237619 | 1237619 | 2021-04-19 | Elk | Pennsylvania | 42047 | 2743 | 38 |
1234372 | 1234372 | 2021-04-18 | Elk | Pennsylvania | 42047 | 2740 | 38 |
1231124 | 1231124 | 2021-04-17 | Elk | Pennsylvania | 42047 | 2738 | 38 |
1227876 | 1227876 | 2021-04-16 | Elk | Pennsylvania | 42047 | 2730 | 38 |
1224628 | 1224628 | 2021-04-15 | Elk | Pennsylvania | 42047 | 2716 | 38 |
1221381 | 1221381 | 2021-04-14 | Elk | Pennsylvania | 42047 | 2705 | 38 |
1218133 | 1218133 | 2021-04-13 | Elk | Pennsylvania | 42047 | 2699 | 38 |
1214885 | 1214885 | 2021-04-12 | Elk | Pennsylvania | 42047 | 2687 | 37 |
1211638 | 1211638 | 2021-04-11 | Elk | Pennsylvania | 42047 | 2683 | 37 |
1208389 | 1208389 | 2021-04-10 | Elk | Pennsylvania | 42047 | 2677 | 37 |
1205141 | 1205141 | 2021-04-09 | Elk | Pennsylvania | 42047 | 2671 | 37 |
1201893 | 1201893 | 2021-04-08 | Elk | Pennsylvania | 42047 | 2651 | 37 |
1198644 | 1198644 | 2021-04-07 | Elk | Pennsylvania | 42047 | 2628 | 37 |
1195395 | 1195395 | 2021-04-06 | Elk | Pennsylvania | 42047 | 2612 | 37 |
1192147 | 1192147 | 2021-04-05 | Elk | Pennsylvania | 42047 | 2604 | 37 |
1188898 | 1188898 | 2021-04-04 | Elk | Pennsylvania | 42047 | 2602 | 37 |
1185651 | 1185651 | 2021-04-03 | Elk | Pennsylvania | 42047 | 2586 | 37 |
1182404 | 1182404 | 2021-04-02 | Elk | Pennsylvania | 42047 | 2576 | 37 |
1179157 | 1179157 | 2021-04-01 | Elk | Pennsylvania | 42047 | 2563 | 37 |
1175910 | 1175910 | 2021-03-31 | Elk | Pennsylvania | 42047 | 2548 | 37 |
1172663 | 1172663 | 2021-03-30 | Elk | Pennsylvania | 42047 | 2538 | 37 |
1169416 | 1169416 | 2021-03-29 | Elk | Pennsylvania | 42047 | 2514 | 37 |
1166168 | 1166168 | 2021-03-28 | Elk | Pennsylvania | 42047 | 2511 | 37 |
1162920 | 1162920 | 2021-03-27 | Elk | Pennsylvania | 42047 | 2508 | 37 |
1159671 | 1159671 | 2021-03-26 | Elk | Pennsylvania | 42047 | 2498 | 37 |
1156424 | 1156424 | 2021-03-25 | Elk | Pennsylvania | 42047 | 2483 | 36 |
1153177 | 1153177 | 2021-03-24 | Elk | Pennsylvania | 42047 | 2464 | 36 |
1149930 | 1149930 | 2021-03-23 | Elk | Pennsylvania | 42047 | 2446 | 36 |
1146683 | 1146683 | 2021-03-22 | Elk | Pennsylvania | 42047 | 2436 | 36 |
1143436 | 1143436 | 2021-03-21 | Elk | Pennsylvania | 42047 | 2427 | 36 |
1140189 | 1140189 | 2021-03-20 | Elk | Pennsylvania | 42047 | 2407 | 36 |
1136943 | 1136943 | 2021-03-19 | Elk | Pennsylvania | 42047 | 2402 | 36 |
1133697 | 1133697 | 2021-03-18 | Elk | Pennsylvania | 42047 | 2395 | 36 |
1130449 | 1130449 | 2021-03-17 | Elk | Pennsylvania | 42047 | 2381 | 36 |
1127202 | 1127202 | 2021-03-16 | Elk | Pennsylvania | 42047 | 2376 | 36 |
1123956 | 1123956 | 2021-03-15 | Elk | Pennsylvania | 42047 | 2370 | 36 |
1120710 | 1120710 | 2021-03-14 | Elk | Pennsylvania | 42047 | 2367 | 36 |
1117463 | 1117463 | 2021-03-13 | Elk | Pennsylvania | 42047 | 2366 | 36 |
1114216 | 1114216 | 2021-03-12 | Elk | Pennsylvania | 42047 | 2364 | 36 |
1110970 | 1110970 | 2021-03-11 | Elk | Pennsylvania | 42047 | 2362 | 36 |
1107724 | 1107724 | 2021-03-10 | Elk | Pennsylvania | 42047 | 2360 | 36 |
1104478 | 1104478 | 2021-03-09 | Elk | Pennsylvania | 42047 | 2358 | 36 |
1101232 | 1101232 | 2021-03-08 | Elk | Pennsylvania | 42047 | 2351 | 36 |
1097986 | 1097986 | 2021-03-07 | Elk | Pennsylvania | 42047 | 2350 | 36 |
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);