ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21047 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1486313 | 1486313 | 2021-07-05 | Christian | Kentucky | 21047 | 7089 | 107 |
1483067 | 1483067 | 2021-07-04 | Christian | Kentucky | 21047 | 7089 | 107 |
1479820 | 1479820 | 2021-07-03 | Christian | Kentucky | 21047 | 7089 | 107 |
1476574 | 1476574 | 2021-07-02 | Christian | Kentucky | 21047 | 7089 | 107 |
1473328 | 1473328 | 2021-07-01 | Christian | Kentucky | 21047 | 7085 | 107 |
1470082 | 1470082 | 2021-06-30 | Christian | Kentucky | 21047 | 7085 | 107 |
1466837 | 1466837 | 2021-06-29 | Christian | Kentucky | 21047 | 7081 | 107 |
1463592 | 1463592 | 2021-06-28 | Christian | Kentucky | 21047 | 7081 | 107 |
1460347 | 1460347 | 2021-06-27 | Christian | Kentucky | 21047 | 7079 | 107 |
1457102 | 1457102 | 2021-06-26 | Christian | Kentucky | 21047 | 7079 | 107 |
1453857 | 1453857 | 2021-06-25 | Christian | Kentucky | 21047 | 7079 | 107 |
1450611 | 1450611 | 2021-06-24 | Christian | Kentucky | 21047 | 7078 | 107 |
1447366 | 1447366 | 2021-06-23 | Christian | Kentucky | 21047 | 7077 | 107 |
1444121 | 1444121 | 2021-06-22 | Christian | Kentucky | 21047 | 7074 | 107 |
1440876 | 1440876 | 2021-06-21 | Christian | Kentucky | 21047 | 7067 | 107 |
1437629 | 1437629 | 2021-06-20 | Christian | Kentucky | 21047 | 7062 | 107 |
1434382 | 1434382 | 2021-06-19 | Christian | Kentucky | 21047 | 7062 | 107 |
1431136 | 1431136 | 2021-06-18 | Christian | Kentucky | 21047 | 7062 | 107 |
1427891 | 1427891 | 2021-06-17 | Christian | Kentucky | 21047 | 7058 | 107 |
1424646 | 1424646 | 2021-06-16 | Christian | Kentucky | 21047 | 7053 | 107 |
1421398 | 1421398 | 2021-06-15 | Christian | Kentucky | 21047 | 7106 | 107 |
1418153 | 1418153 | 2021-06-14 | Christian | Kentucky | 21047 | 7106 | 107 |
1414907 | 1414907 | 2021-06-13 | Christian | Kentucky | 21047 | 7106 | 107 |
1411662 | 1411662 | 2021-06-12 | Christian | Kentucky | 21047 | 7106 | 107 |
1408417 | 1408417 | 2021-06-11 | Christian | Kentucky | 21047 | 7106 | 107 |
1405171 | 1405171 | 2021-06-10 | Christian | Kentucky | 21047 | 7106 | 107 |
1401926 | 1401926 | 2021-06-09 | Christian | Kentucky | 21047 | 7084 | 107 |
1398681 | 1398681 | 2021-06-08 | Christian | Kentucky | 21047 | 7084 | 107 |
1395434 | 1395434 | 2021-06-07 | Christian | Kentucky | 21047 | 7084 | 107 |
1392189 | 1392189 | 2021-06-06 | Christian | Kentucky | 21047 | 7084 | 107 |
1388944 | 1388944 | 2021-06-05 | Christian | Kentucky | 21047 | 7084 | 107 |
1385699 | 1385699 | 2021-06-04 | Christian | Kentucky | 21047 | 7084 | 107 |
1382453 | 1382453 | 2021-06-03 | Christian | Kentucky | 21047 | 7084 | 107 |
1379208 | 1379208 | 2021-06-02 | Christian | Kentucky | 21047 | 7069 | 106 |
1375962 | 1375962 | 2021-06-01 | Christian | Kentucky | 21047 | 7069 | 106 |
1372717 | 1372717 | 2021-05-31 | Christian | Kentucky | 21047 | 7069 | 104 |
1369472 | 1369472 | 2021-05-30 | Christian | Kentucky | 21047 | 7069 | 104 |
1366226 | 1366226 | 2021-05-29 | Christian | Kentucky | 21047 | 7069 | 104 |
1362980 | 1362980 | 2021-05-28 | Christian | Kentucky | 21047 | 7069 | 104 |
1359733 | 1359733 | 2021-05-27 | Christian | Kentucky | 21047 | 7069 | 104 |
1356487 | 1356487 | 2021-05-26 | Christian | Kentucky | 21047 | 7053 | 104 |
1353241 | 1353241 | 2021-05-25 | Christian | Kentucky | 21047 | 7053 | 104 |
1349995 | 1349995 | 2021-05-24 | Christian | Kentucky | 21047 | 7053 | 104 |
1346748 | 1346748 | 2021-05-23 | Christian | Kentucky | 21047 | 7053 | 104 |
1343500 | 1343500 | 2021-05-22 | Christian | Kentucky | 21047 | 7053 | 104 |
1340252 | 1340252 | 2021-05-21 | Christian | Kentucky | 21047 | 7053 | 104 |
1337005 | 1337005 | 2021-05-20 | Christian | Kentucky | 21047 | 7053 | 104 |
1333758 | 1333758 | 2021-05-19 | Christian | Kentucky | 21047 | 7052 | 104 |
1330511 | 1330511 | 2021-05-18 | Christian | Kentucky | 21047 | 7047 | 104 |
1327264 | 1327264 | 2021-05-17 | Christian | Kentucky | 21047 | 7044 | 104 |
1324018 | 1324018 | 2021-05-16 | Christian | Kentucky | 21047 | 7035 | 104 |
1320772 | 1320772 | 2021-05-15 | Christian | Kentucky | 21047 | 7035 | 104 |
1317525 | 1317525 | 2021-05-14 | Christian | Kentucky | 21047 | 7035 | 104 |
1314278 | 1314278 | 2021-05-13 | Christian | Kentucky | 21047 | 7035 | 104 |
1311031 | 1311031 | 2021-05-12 | Christian | Kentucky | 21047 | 7031 | 104 |
1307785 | 1307785 | 2021-05-11 | Christian | Kentucky | 21047 | 7025 | 104 |
1304539 | 1304539 | 2021-05-10 | Christian | Kentucky | 21047 | 7019 | 104 |
1301292 | 1301292 | 2021-05-09 | Christian | Kentucky | 21047 | 7001 | 104 |
1298045 | 1298045 | 2021-05-08 | Christian | Kentucky | 21047 | 7001 | 104 |
1294799 | 1294799 | 2021-05-07 | Christian | Kentucky | 21047 | 7001 | 104 |
1291553 | 1291553 | 2021-05-06 | Christian | Kentucky | 21047 | 6998 | 104 |
1288307 | 1288307 | 2021-05-05 | Christian | Kentucky | 21047 | 6989 | 104 |
1285061 | 1285061 | 2021-05-04 | Christian | Kentucky | 21047 | 6981 | 104 |
1281814 | 1281814 | 2021-05-03 | Christian | Kentucky | 21047 | 6981 | 104 |
1278567 | 1278567 | 2021-05-02 | Christian | Kentucky | 21047 | 6961 | 104 |
1275320 | 1275320 | 2021-05-01 | Christian | Kentucky | 21047 | 6961 | 104 |
1272073 | 1272073 | 2021-04-30 | Christian | Kentucky | 21047 | 6961 | 104 |
1268826 | 1268826 | 2021-04-29 | Christian | Kentucky | 21047 | 6952 | 104 |
1265579 | 1265579 | 2021-04-28 | Christian | Kentucky | 21047 | 6934 | 104 |
1262332 | 1262332 | 2021-04-27 | Christian | Kentucky | 21047 | 6915 | 104 |
1259085 | 1259085 | 2021-04-26 | Christian | Kentucky | 21047 | 6890 | 104 |
1255838 | 1255838 | 2021-04-25 | Christian | Kentucky | 21047 | 6890 | 104 |
1252591 | 1252591 | 2021-04-24 | Christian | Kentucky | 21047 | 6890 | 104 |
1249344 | 1249344 | 2021-04-23 | Christian | Kentucky | 21047 | 6890 | 103 |
1246097 | 1246097 | 2021-04-22 | Christian | Kentucky | 21047 | 6883 | 103 |
1242850 | 1242850 | 2021-04-21 | Christian | Kentucky | 21047 | 6871 | 103 |
1239603 | 1239603 | 2021-04-20 | Christian | Kentucky | 21047 | 6853 | 102 |
1236356 | 1236356 | 2021-04-19 | Christian | Kentucky | 21047 | 6853 | 102 |
1233109 | 1233109 | 2021-04-18 | Christian | Kentucky | 21047 | 6826 | 102 |
1229861 | 1229861 | 2021-04-17 | Christian | Kentucky | 21047 | 6826 | 102 |
1226613 | 1226613 | 2021-04-16 | Christian | Kentucky | 21047 | 6826 | 102 |
1223366 | 1223366 | 2021-04-15 | Christian | Kentucky | 21047 | 6816 | 102 |
1220118 | 1220118 | 2021-04-14 | Christian | Kentucky | 21047 | 6795 | 102 |
1216870 | 1216870 | 2021-04-13 | Christian | Kentucky | 21047 | 6778 | 100 |
1213623 | 1213623 | 2021-04-12 | Christian | Kentucky | 21047 | 6759 | 100 |
1210375 | 1210375 | 2021-04-11 | Christian | Kentucky | 21047 | 6719 | 100 |
1207126 | 1207126 | 2021-04-10 | Christian | Kentucky | 21047 | 6719 | 100 |
1203878 | 1203878 | 2021-04-09 | Christian | Kentucky | 21047 | 6719 | 100 |
1200630 | 1200630 | 2021-04-08 | Christian | Kentucky | 21047 | 6705 | 99 |
1197381 | 1197381 | 2021-04-07 | Christian | Kentucky | 21047 | 6683 | 98 |
1194133 | 1194133 | 2021-04-06 | Christian | Kentucky | 21047 | 6658 | 98 |
1190883 | 1190883 | 2021-04-05 | Christian | Kentucky | 21047 | 6658 | 98 |
1187636 | 1187636 | 2021-04-04 | Christian | Kentucky | 21047 | 6611 | 98 |
1184389 | 1184389 | 2021-04-03 | Christian | Kentucky | 21047 | 6611 | 98 |
1181142 | 1181142 | 2021-04-02 | Christian | Kentucky | 21047 | 6611 | 98 |
1177895 | 1177895 | 2021-04-01 | Christian | Kentucky | 21047 | 6611 | 98 |
1174648 | 1174648 | 2021-03-31 | Christian | Kentucky | 21047 | 6587 | 98 |
1171401 | 1171401 | 2021-03-30 | Christian | Kentucky | 21047 | 6587 | 98 |
1168153 | 1168153 | 2021-03-29 | Christian | Kentucky | 21047 | 6570 | 97 |
1164905 | 1164905 | 2021-03-28 | Christian | Kentucky | 21047 | 6539 | 97 |
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);