ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
737 rows where county = "Harlan" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418177 | 1418177 | 2021-06-14 | Harlan | Kentucky | 21095 | 2923 | 88 |
1414931 | 1414931 | 2021-06-13 | Harlan | Kentucky | 21095 | 2922 | 87 |
1411686 | 1411686 | 2021-06-12 | Harlan | Kentucky | 21095 | 2922 | 87 |
1408441 | 1408441 | 2021-06-11 | Harlan | Kentucky | 21095 | 2922 | 87 |
1405195 | 1405195 | 2021-06-10 | Harlan | Kentucky | 21095 | 2921 | 86 |
1401950 | 1401950 | 2021-06-09 | Harlan | Kentucky | 21095 | 2914 | 86 |
1398705 | 1398705 | 2021-06-08 | Harlan | Kentucky | 21095 | 2914 | 85 |
1395458 | 1395458 | 2021-06-07 | Harlan | Kentucky | 21095 | 2913 | 85 |
1392213 | 1392213 | 2021-06-06 | Harlan | Kentucky | 21095 | 2913 | 85 |
1388968 | 1388968 | 2021-06-05 | Harlan | Kentucky | 21095 | 2913 | 85 |
1385723 | 1385723 | 2021-06-04 | Harlan | Kentucky | 21095 | 2912 | 85 |
1382477 | 1382477 | 2021-06-03 | Harlan | Kentucky | 21095 | 2911 | 85 |
1379232 | 1379232 | 2021-06-02 | Harlan | Kentucky | 21095 | 2908 | 85 |
1375986 | 1375986 | 2021-06-01 | Harlan | Kentucky | 21095 | 2901 | 85 |
1372741 | 1372741 | 2021-05-31 | Harlan | Kentucky | 21095 | 2896 | 84 |
1369496 | 1369496 | 2021-05-30 | Harlan | Kentucky | 21095 | 2896 | 84 |
1366250 | 1366250 | 2021-05-29 | Harlan | Kentucky | 21095 | 2896 | 84 |
1363004 | 1363004 | 2021-05-28 | Harlan | Kentucky | 21095 | 2893 | 84 |
1359757 | 1359757 | 2021-05-27 | Harlan | Kentucky | 21095 | 2889 | 84 |
1356511 | 1356511 | 2021-05-26 | Harlan | Kentucky | 21095 | 2889 | 84 |
1353265 | 1353265 | 2021-05-25 | Harlan | Kentucky | 21095 | 2879 | 84 |
1350019 | 1350019 | 2021-05-24 | Harlan | Kentucky | 21095 | 2868 | 84 |
1346772 | 1346772 | 2021-05-23 | Harlan | Kentucky | 21095 | 2866 | 84 |
1343524 | 1343524 | 2021-05-22 | Harlan | Kentucky | 21095 | 2866 | 83 |
1340276 | 1340276 | 2021-05-21 | Harlan | Kentucky | 21095 | 2862 | 83 |
1337029 | 1337029 | 2021-05-20 | Harlan | Kentucky | 21095 | 2861 | 83 |
1333782 | 1333782 | 2021-05-19 | Harlan | Kentucky | 21095 | 2853 | 83 |
1330535 | 1330535 | 2021-05-18 | Harlan | Kentucky | 21095 | 2847 | 83 |
1327288 | 1327288 | 2021-05-17 | Harlan | Kentucky | 21095 | 2843 | 83 |
1324042 | 1324042 | 2021-05-16 | Harlan | Kentucky | 21095 | 2840 | 83 |
1320796 | 1320796 | 2021-05-15 | Harlan | Kentucky | 21095 | 2838 | 83 |
1317549 | 1317549 | 2021-05-14 | Harlan | Kentucky | 21095 | 2834 | 83 |
1314302 | 1314302 | 2021-05-13 | Harlan | Kentucky | 21095 | 2831 | 83 |
1311055 | 1311055 | 2021-05-12 | Harlan | Kentucky | 21095 | 2830 | 83 |
1307809 | 1307809 | 2021-05-11 | Harlan | Kentucky | 21095 | 2827 | 83 |
1304563 | 1304563 | 2021-05-10 | Harlan | Kentucky | 21095 | 2824 | 83 |
1301316 | 1301316 | 2021-05-09 | Harlan | Kentucky | 21095 | 2821 | 83 |
1298069 | 1298069 | 2021-05-08 | Harlan | Kentucky | 21095 | 2821 | 83 |
1294823 | 1294823 | 2021-05-07 | Harlan | Kentucky | 21095 | 2819 | 83 |
1291577 | 1291577 | 2021-05-06 | Harlan | Kentucky | 21095 | 2815 | 83 |
1288331 | 1288331 | 2021-05-05 | Harlan | Kentucky | 21095 | 2809 | 83 |
1285085 | 1285085 | 2021-05-04 | Harlan | Kentucky | 21095 | 2806 | 83 |
1281838 | 1281838 | 2021-05-03 | Harlan | Kentucky | 21095 | 2803 | 83 |
1278591 | 1278591 | 2021-05-02 | Harlan | Kentucky | 21095 | 2802 | 83 |
1275344 | 1275344 | 2021-05-01 | Harlan | Kentucky | 21095 | 2800 | 83 |
1272097 | 1272097 | 2021-04-30 | Harlan | Kentucky | 21095 | 2795 | 83 |
1268850 | 1268850 | 2021-04-29 | Harlan | Kentucky | 21095 | 2789 | 83 |
1265603 | 1265603 | 2021-04-28 | Harlan | Kentucky | 21095 | 2782 | 83 |
1262356 | 1262356 | 2021-04-27 | Harlan | Kentucky | 21095 | 2776 | 83 |
1259109 | 1259109 | 2021-04-26 | Harlan | Kentucky | 21095 | 2763 | 83 |
1255862 | 1255862 | 2021-04-25 | Harlan | Kentucky | 21095 | 2760 | 83 |
1252615 | 1252615 | 2021-04-24 | Harlan | Kentucky | 21095 | 2759 | 83 |
1249368 | 1249368 | 2021-04-23 | Harlan | Kentucky | 21095 | 2755 | 83 |
1246121 | 1246121 | 2021-04-22 | Harlan | Kentucky | 21095 | 2751 | 83 |
1242874 | 1242874 | 2021-04-21 | Harlan | Kentucky | 21095 | 2744 | 83 |
1239627 | 1239627 | 2021-04-20 | Harlan | Kentucky | 21095 | 2741 | 83 |
1236380 | 1236380 | 2021-04-19 | Harlan | Kentucky | 21095 | 2725 | 83 |
1233133 | 1233133 | 2021-04-18 | Harlan | Kentucky | 21095 | 2725 | 83 |
1229885 | 1229885 | 2021-04-17 | Harlan | Kentucky | 21095 | 2723 | 83 |
1226637 | 1226637 | 2021-04-16 | Harlan | Kentucky | 21095 | 2712 | 82 |
1223390 | 1223390 | 2021-04-15 | Harlan | Kentucky | 21095 | 2700 | 82 |
1220142 | 1220142 | 2021-04-14 | Harlan | Kentucky | 21095 | 2681 | 82 |
1216894 | 1216894 | 2021-04-13 | Harlan | Kentucky | 21095 | 2674 | 81 |
1213647 | 1213647 | 2021-04-12 | Harlan | Kentucky | 21095 | 2670 | 81 |
1210399 | 1210399 | 2021-04-11 | Harlan | Kentucky | 21095 | 2639 | 80 |
1207150 | 1207150 | 2021-04-10 | Harlan | Kentucky | 21095 | 2637 | 80 |
1203902 | 1203902 | 2021-04-09 | Harlan | Kentucky | 21095 | 2633 | 80 |
1200654 | 1200654 | 2021-04-08 | Harlan | Kentucky | 21095 | 2629 | 80 |
1197405 | 1197405 | 2021-04-07 | Harlan | Kentucky | 21095 | 2617 | 80 |
1194157 | 1194157 | 2021-04-06 | Harlan | Kentucky | 21095 | 2601 | 80 |
1190907 | 1190907 | 2021-04-05 | Harlan | Kentucky | 21095 | 2591 | 80 |
1187660 | 1187660 | 2021-04-04 | Harlan | Kentucky | 21095 | 2584 | 80 |
1184413 | 1184413 | 2021-04-03 | Harlan | Kentucky | 21095 | 2584 | 80 |
1181166 | 1181166 | 2021-04-02 | Harlan | Kentucky | 21095 | 2580 | 79 |
1177919 | 1177919 | 2021-04-01 | Harlan | Kentucky | 21095 | 2574 | 79 |
1174672 | 1174672 | 2021-03-31 | Harlan | Kentucky | 21095 | 2555 | 78 |
1171425 | 1171425 | 2021-03-30 | Harlan | Kentucky | 21095 | 2544 | 77 |
1168177 | 1168177 | 2021-03-29 | Harlan | Kentucky | 21095 | 2534 | 77 |
1164929 | 1164929 | 2021-03-28 | Harlan | Kentucky | 21095 | 2519 | 77 |
1161681 | 1161681 | 2021-03-27 | Harlan | Kentucky | 21095 | 2508 | 77 |
1158433 | 1158433 | 2021-03-26 | Harlan | Kentucky | 21095 | 2505 | 77 |
1155186 | 1155186 | 2021-03-25 | Harlan | Kentucky | 21095 | 2498 | 77 |
1151939 | 1151939 | 2021-03-24 | Harlan | Kentucky | 21095 | 2489 | 77 |
1148692 | 1148692 | 2021-03-23 | Harlan | Kentucky | 21095 | 2485 | 77 |
1145445 | 1145445 | 2021-03-22 | Harlan | Kentucky | 21095 | 2483 | 77 |
1142198 | 1142198 | 2021-03-21 | Harlan | Kentucky | 21095 | 2483 | 77 |
1138952 | 1138952 | 2021-03-20 | Harlan | Kentucky | 21095 | 2480 | 77 |
1135706 | 1135706 | 2021-03-19 | Harlan | Kentucky | 21095 | 2476 | 77 |
1132459 | 1132459 | 2021-03-18 | Harlan | Kentucky | 21095 | 2472 | 77 |
1129211 | 1129211 | 2021-03-17 | Harlan | Kentucky | 21095 | 2466 | 72 |
1125965 | 1125965 | 2021-03-16 | Harlan | Kentucky | 21095 | 2460 | 72 |
1122719 | 1122719 | 2021-03-15 | Harlan | Kentucky | 21095 | 2453 | 72 |
1119472 | 1119472 | 2021-03-14 | Harlan | Kentucky | 21095 | 2452 | 72 |
1116225 | 1116225 | 2021-03-13 | Harlan | Kentucky | 21095 | 2451 | 72 |
1112979 | 1112979 | 2021-03-12 | Harlan | Kentucky | 21095 | 2446 | 71 |
1109733 | 1109733 | 2021-03-11 | Harlan | Kentucky | 21095 | 2442 | 71 |
1106487 | 1106487 | 2021-03-10 | Harlan | Kentucky | 21095 | 2433 | 71 |
1103241 | 1103241 | 2021-03-09 | Harlan | Kentucky | 21095 | 2427 | 70 |
1099995 | 1099995 | 2021-03-08 | Harlan | Kentucky | 21095 | 2426 | 70 |
1096747 | 1096747 | 2021-03-07 | Harlan | Kentucky | 21095 | 2424 | 70 |
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);