ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "York" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419457 | 1419457 | 2021-06-14 | York | Pennsylvania | 42133 | 46863 | 821 |
1416212 | 1416212 | 2021-06-13 | York | Pennsylvania | 42133 | 46859 | 821 |
1412966 | 1412966 | 2021-06-12 | York | Pennsylvania | 42133 | 46848 | 821 |
1409721 | 1409721 | 2021-06-11 | York | Pennsylvania | 42133 | 46819 | 821 |
1406476 | 1406476 | 2021-06-10 | York | Pennsylvania | 42133 | 46810 | 821 |
1403230 | 1403230 | 2021-06-09 | York | Pennsylvania | 42133 | 46717 | 819 |
1399985 | 1399985 | 2021-06-08 | York | Pennsylvania | 42133 | 46626 | 818 |
1396740 | 1396740 | 2021-06-07 | York | Pennsylvania | 42133 | 46573 | 816 |
1393493 | 1393493 | 2021-06-06 | York | Pennsylvania | 42133 | 46554 | 816 |
1390248 | 1390248 | 2021-06-05 | York | Pennsylvania | 42133 | 46537 | 816 |
1387003 | 1387003 | 2021-06-04 | York | Pennsylvania | 42133 | 46516 | 815 |
1383758 | 1383758 | 2021-06-03 | York | Pennsylvania | 42133 | 46465 | 815 |
1380512 | 1380512 | 2021-06-02 | York | Pennsylvania | 42133 | 46429 | 813 |
1377267 | 1377267 | 2021-06-01 | York | Pennsylvania | 42133 | 46392 | 812 |
1374021 | 1374021 | 2021-05-31 | York | Pennsylvania | 42133 | 46362 | 812 |
1370776 | 1370776 | 2021-05-30 | York | Pennsylvania | 42133 | 46346 | 811 |
1367530 | 1367530 | 2021-05-29 | York | Pennsylvania | 42133 | 46318 | 811 |
1364284 | 1364284 | 2021-05-28 | York | Pennsylvania | 42133 | 46271 | 810 |
1361038 | 1361038 | 2021-05-27 | York | Pennsylvania | 42133 | 46227 | 809 |
1357792 | 1357792 | 2021-05-26 | York | Pennsylvania | 42133 | 46182 | 808 |
1354546 | 1354546 | 2021-05-25 | York | Pennsylvania | 42133 | 46132 | 807 |
1351300 | 1351300 | 2021-05-24 | York | Pennsylvania | 42133 | 46099 | 806 |
1348054 | 1348054 | 2021-05-23 | York | Pennsylvania | 42133 | 46066 | 806 |
1344806 | 1344806 | 2021-05-22 | York | Pennsylvania | 42133 | 45968 | 806 |
1341558 | 1341558 | 2021-05-21 | York | Pennsylvania | 42133 | 45968 | 806 |
1338310 | 1338310 | 2021-05-20 | York | Pennsylvania | 42133 | 45868 | 806 |
1335063 | 1335063 | 2021-05-19 | York | Pennsylvania | 42133 | 45812 | 804 |
1331816 | 1331816 | 2021-05-18 | York | Pennsylvania | 42133 | 45741 | 803 |
1328569 | 1328569 | 2021-05-17 | York | Pennsylvania | 42133 | 45654 | 802 |
1325323 | 1325323 | 2021-05-16 | York | Pennsylvania | 42133 | 45610 | 801 |
1322077 | 1322077 | 2021-05-15 | York | Pennsylvania | 42133 | 45567 | 800 |
1318831 | 1318831 | 2021-05-14 | York | Pennsylvania | 42133 | 45477 | 798 |
1315583 | 1315583 | 2021-05-13 | York | Pennsylvania | 42133 | 45420 | 797 |
1312337 | 1312337 | 2021-05-12 | York | Pennsylvania | 42133 | 45339 | 796 |
1309090 | 1309090 | 2021-05-11 | York | Pennsylvania | 42133 | 45255 | 794 |
1305844 | 1305844 | 2021-05-10 | York | Pennsylvania | 42133 | 45183 | 792 |
1302598 | 1302598 | 2021-05-09 | York | Pennsylvania | 42133 | 45139 | 792 |
1299351 | 1299351 | 2021-05-08 | York | Pennsylvania | 42133 | 45087 | 792 |
1296104 | 1296104 | 2021-05-07 | York | Pennsylvania | 42133 | 44970 | 789 |
1292858 | 1292858 | 2021-05-06 | York | Pennsylvania | 42133 | 44837 | 788 |
1289612 | 1289612 | 2021-05-05 | York | Pennsylvania | 42133 | 44732 | 786 |
1286366 | 1286366 | 2021-05-04 | York | Pennsylvania | 42133 | 44608 | 783 |
1283120 | 1283120 | 2021-05-03 | York | Pennsylvania | 42133 | 44485 | 783 |
1279873 | 1279873 | 2021-05-02 | York | Pennsylvania | 42133 | 44398 | 783 |
1276626 | 1276626 | 2021-05-01 | York | Pennsylvania | 42133 | 44286 | 783 |
1273379 | 1273379 | 2021-04-30 | York | Pennsylvania | 42133 | 44127 | 783 |
1270132 | 1270132 | 2021-04-29 | York | Pennsylvania | 42133 | 43963 | 781 |
1266885 | 1266885 | 2021-04-28 | York | Pennsylvania | 42133 | 43821 | 778 |
1263638 | 1263638 | 2021-04-27 | York | Pennsylvania | 42133 | 43700 | 778 |
1260391 | 1260391 | 2021-04-26 | York | Pennsylvania | 42133 | 43576 | 774 |
1257144 | 1257144 | 2021-04-25 | York | Pennsylvania | 42133 | 43493 | 774 |
1253897 | 1253897 | 2021-04-24 | York | Pennsylvania | 42133 | 43372 | 774 |
1250650 | 1250650 | 2021-04-23 | York | Pennsylvania | 42133 | 43204 | 771 |
1247403 | 1247403 | 2021-04-22 | York | Pennsylvania | 42133 | 43072 | 766 |
1244156 | 1244156 | 2021-04-21 | York | Pennsylvania | 42133 | 42890 | 765 |
1240909 | 1240909 | 2021-04-20 | York | Pennsylvania | 42133 | 42693 | 763 |
1237662 | 1237662 | 2021-04-19 | York | Pennsylvania | 42133 | 42532 | 763 |
1234415 | 1234415 | 2021-04-18 | York | Pennsylvania | 42133 | 42464 | 763 |
1231167 | 1231167 | 2021-04-17 | York | Pennsylvania | 42133 | 42335 | 762 |
1227919 | 1227919 | 2021-04-16 | York | Pennsylvania | 42133 | 42125 | 761 |
1224671 | 1224671 | 2021-04-15 | York | Pennsylvania | 42133 | 41908 | 761 |
1221424 | 1221424 | 2021-04-14 | York | Pennsylvania | 42133 | 41711 | 760 |
1218176 | 1218176 | 2021-04-13 | York | Pennsylvania | 42133 | 41539 | 759 |
1214928 | 1214928 | 2021-04-12 | York | Pennsylvania | 42133 | 41306 | 757 |
1211681 | 1211681 | 2021-04-11 | York | Pennsylvania | 42133 | 41220 | 757 |
1208432 | 1208432 | 2021-04-10 | York | Pennsylvania | 42133 | 41076 | 757 |
1205184 | 1205184 | 2021-04-09 | York | Pennsylvania | 42133 | 40851 | 755 |
1201936 | 1201936 | 2021-04-08 | York | Pennsylvania | 42133 | 40691 | 755 |
1198687 | 1198687 | 2021-04-07 | York | Pennsylvania | 42133 | 40526 | 754 |
1195438 | 1195438 | 2021-04-06 | York | Pennsylvania | 42133 | 40322 | 752 |
1192190 | 1192190 | 2021-04-05 | York | Pennsylvania | 42133 | 40198 | 752 |
1188941 | 1188941 | 2021-04-04 | York | Pennsylvania | 42133 | 40118 | 752 |
1185694 | 1185694 | 2021-04-03 | York | Pennsylvania | 42133 | 39993 | 752 |
1182447 | 1182447 | 2021-04-02 | York | Pennsylvania | 42133 | 39820 | 751 |
1179200 | 1179200 | 2021-04-01 | York | Pennsylvania | 42133 | 39646 | 749 |
1175953 | 1175953 | 2021-03-31 | York | Pennsylvania | 42133 | 39481 | 749 |
1172706 | 1172706 | 2021-03-30 | York | Pennsylvania | 42133 | 39298 | 749 |
1169459 | 1169459 | 2021-03-29 | York | Pennsylvania | 42133 | 39111 | 746 |
1166211 | 1166211 | 2021-03-28 | York | Pennsylvania | 42133 | 39027 | 746 |
1162963 | 1162963 | 2021-03-27 | York | Pennsylvania | 42133 | 38923 | 746 |
1159714 | 1159714 | 2021-03-26 | York | Pennsylvania | 42133 | 38767 | 746 |
1156467 | 1156467 | 2021-03-25 | York | Pennsylvania | 42133 | 38521 | 746 |
1153220 | 1153220 | 2021-03-24 | York | Pennsylvania | 42133 | 38367 | 745 |
1149973 | 1149973 | 2021-03-23 | York | Pennsylvania | 42133 | 38120 | 744 |
1146726 | 1146726 | 2021-03-22 | York | Pennsylvania | 42133 | 38027 | 743 |
1143479 | 1143479 | 2021-03-21 | York | Pennsylvania | 42133 | 37964 | 743 |
1140232 | 1140232 | 2021-03-20 | York | Pennsylvania | 42133 | 37881 | 743 |
1136986 | 1136986 | 2021-03-19 | York | Pennsylvania | 42133 | 37680 | 743 |
1133740 | 1133740 | 2021-03-18 | York | Pennsylvania | 42133 | 37544 | 742 |
1130492 | 1130492 | 2021-03-17 | York | Pennsylvania | 42133 | 37393 | 743 |
1127245 | 1127245 | 2021-03-16 | York | Pennsylvania | 42133 | 37258 | 743 |
1123999 | 1123999 | 2021-03-15 | York | Pennsylvania | 42133 | 37166 | 742 |
1120753 | 1120753 | 2021-03-14 | York | Pennsylvania | 42133 | 37115 | 741 |
1117506 | 1117506 | 2021-03-13 | York | Pennsylvania | 42133 | 37029 | 741 |
1114259 | 1114259 | 2021-03-12 | York | Pennsylvania | 42133 | 36923 | 741 |
1111013 | 1111013 | 2021-03-11 | York | Pennsylvania | 42133 | 36781 | 738 |
1107767 | 1107767 | 2021-03-10 | York | Pennsylvania | 42133 | 36669 | 737 |
1104521 | 1104521 | 2021-03-09 | York | Pennsylvania | 42133 | 36540 | 737 |
1101275 | 1101275 | 2021-03-08 | York | Pennsylvania | 42133 | 36466 | 734 |
1098029 | 1098029 | 2021-03-07 | York | Pennsylvania | 42133 | 36413 | 734 |
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);