ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Jefferson" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1489592 | 1489592 | 2021-07-06 | Jefferson | Kentucky | 21111 | 83251 | 1341 |
1486345 | 1486345 | 2021-07-05 | Jefferson | Kentucky | 21111 | 83167 | 1339 |
1483099 | 1483099 | 2021-07-04 | Jefferson | Kentucky | 21111 | 83167 | 1339 |
1479852 | 1479852 | 2021-07-03 | Jefferson | Kentucky | 21111 | 83167 | 1339 |
1476606 | 1476606 | 2021-07-02 | Jefferson | Kentucky | 21111 | 83167 | 1339 |
1473360 | 1473360 | 2021-07-01 | Jefferson | Kentucky | 21111 | 83141 | 1336 |
1470114 | 1470114 | 2021-06-30 | Jefferson | Kentucky | 21111 | 83124 | 1336 |
1466869 | 1466869 | 2021-06-29 | Jefferson | Kentucky | 21111 | 83118 | 1336 |
1463624 | 1463624 | 2021-06-28 | Jefferson | Kentucky | 21111 | 83089 | 1335 |
1460379 | 1460379 | 2021-06-27 | Jefferson | Kentucky | 21111 | 83074 | 1333 |
1457134 | 1457134 | 2021-06-26 | Jefferson | Kentucky | 21111 | 83074 | 1333 |
1453889 | 1453889 | 2021-06-25 | Jefferson | Kentucky | 21111 | 83074 | 1333 |
1450643 | 1450643 | 2021-06-24 | Jefferson | Kentucky | 21111 | 83074 | 1333 |
1447398 | 1447398 | 2021-06-23 | Jefferson | Kentucky | 21111 | 83054 | 1333 |
1444153 | 1444153 | 2021-06-22 | Jefferson | Kentucky | 21111 | 83054 | 1333 |
1440908 | 1440908 | 2021-06-21 | Jefferson | Kentucky | 21111 | 83054 | 1330 |
1437661 | 1437661 | 2021-06-20 | Jefferson | Kentucky | 21111 | 83054 | 1329 |
1434414 | 1434414 | 2021-06-19 | Jefferson | Kentucky | 21111 | 83050 | 1329 |
1431168 | 1431168 | 2021-06-18 | Jefferson | Kentucky | 21111 | 83038 | 1329 |
1427923 | 1427923 | 2021-06-17 | Jefferson | Kentucky | 21111 | 83033 | 1329 |
1424678 | 1424678 | 2021-06-16 | Jefferson | Kentucky | 21111 | 83025 | 1329 |
1421430 | 1421430 | 2021-06-15 | Jefferson | Kentucky | 21111 | 83025 | 1329 |
1418185 | 1418185 | 2021-06-14 | Jefferson | Kentucky | 21111 | 83019 | 1329 |
1414939 | 1414939 | 2021-06-13 | Jefferson | Kentucky | 21111 | 83011 | 1329 |
1411694 | 1411694 | 2021-06-12 | Jefferson | Kentucky | 21111 | 82988 | 1329 |
1408449 | 1408449 | 2021-06-11 | Jefferson | Kentucky | 21111 | 82981 | 1327 |
1405203 | 1405203 | 2021-06-10 | Jefferson | Kentucky | 21111 | 82981 | 1325 |
1401958 | 1401958 | 2021-06-09 | Jefferson | Kentucky | 21111 | 82981 | 1323 |
1398713 | 1398713 | 2021-06-08 | Jefferson | Kentucky | 21111 | 82979 | 1320 |
1395466 | 1395466 | 2021-06-07 | Jefferson | Kentucky | 21111 | 82942 | 1318 |
1392221 | 1392221 | 2021-06-06 | Jefferson | Kentucky | 21111 | 82942 | 1317 |
1388976 | 1388976 | 2021-06-05 | Jefferson | Kentucky | 21111 | 82942 | 1317 |
1385731 | 1385731 | 2021-06-04 | Jefferson | Kentucky | 21111 | 82942 | 1317 |
1382485 | 1382485 | 2021-06-03 | Jefferson | Kentucky | 21111 | 82942 | 1316 |
1379240 | 1379240 | 2021-06-02 | Jefferson | Kentucky | 21111 | 82942 | 1314 |
1375994 | 1375994 | 2021-06-01 | Jefferson | Kentucky | 21111 | 82942 | 1314 |
1372749 | 1372749 | 2021-05-31 | Jefferson | Kentucky | 21111 | 82919 | 1269 |
1369504 | 1369504 | 2021-05-30 | Jefferson | Kentucky | 21111 | 82919 | 1269 |
1366258 | 1366258 | 2021-05-29 | Jefferson | Kentucky | 21111 | 82888 | 1269 |
1363012 | 1363012 | 2021-05-28 | Jefferson | Kentucky | 21111 | 82841 | 1269 |
1359765 | 1359765 | 2021-05-27 | Jefferson | Kentucky | 21111 | 82824 | 1269 |
1356519 | 1356519 | 2021-05-26 | Jefferson | Kentucky | 21111 | 82775 | 1269 |
1353273 | 1353273 | 2021-05-25 | Jefferson | Kentucky | 21111 | 82748 | 1269 |
1350027 | 1350027 | 2021-05-24 | Jefferson | Kentucky | 21111 | 82678 | 1269 |
1346780 | 1346780 | 2021-05-23 | Jefferson | Kentucky | 21111 | 82631 | 1269 |
1343532 | 1343532 | 2021-05-22 | Jefferson | Kentucky | 21111 | 82555 | 1269 |
1340284 | 1340284 | 2021-05-21 | Jefferson | Kentucky | 21111 | 82508 | 1269 |
1337037 | 1337037 | 2021-05-20 | Jefferson | Kentucky | 21111 | 82401 | 1269 |
1333790 | 1333790 | 2021-05-19 | Jefferson | Kentucky | 21111 | 82286 | 1269 |
1330543 | 1330543 | 2021-05-18 | Jefferson | Kentucky | 21111 | 82228 | 1269 |
1327296 | 1327296 | 2021-05-17 | Jefferson | Kentucky | 21111 | 82159 | 1269 |
1324050 | 1324050 | 2021-05-16 | Jefferson | Kentucky | 21111 | 82107 | 1269 |
1320804 | 1320804 | 2021-05-15 | Jefferson | Kentucky | 21111 | 82029 | 1266 |
1317557 | 1317557 | 2021-05-14 | Jefferson | Kentucky | 21111 | 81937 | 1193 |
1314310 | 1314310 | 2021-05-13 | Jefferson | Kentucky | 21111 | 81845 | 1190 |
1311063 | 1311063 | 2021-05-12 | Jefferson | Kentucky | 21111 | 81762 | 1189 |
1307817 | 1307817 | 2021-05-11 | Jefferson | Kentucky | 21111 | 81685 | 1187 |
1304571 | 1304571 | 2021-05-10 | Jefferson | Kentucky | 21111 | 81644 | 1185 |
1301324 | 1301324 | 2021-05-09 | Jefferson | Kentucky | 21111 | 81630 | 1185 |
1298077 | 1298077 | 2021-05-08 | Jefferson | Kentucky | 21111 | 81577 | 1185 |
1294831 | 1294831 | 2021-05-07 | Jefferson | Kentucky | 21111 | 81534 | 1183 |
1291585 | 1291585 | 2021-05-06 | Jefferson | Kentucky | 21111 | 81414 | 1180 |
1288339 | 1288339 | 2021-05-05 | Jefferson | Kentucky | 21111 | 81305 | 1179 |
1285093 | 1285093 | 2021-05-04 | Jefferson | Kentucky | 21111 | 81209 | 1178 |
1281846 | 1281846 | 2021-05-03 | Jefferson | Kentucky | 21111 | 81112 | 1178 |
1278599 | 1278599 | 2021-05-02 | Jefferson | Kentucky | 21111 | 81037 | 1178 |
1275352 | 1275352 | 2021-05-01 | Jefferson | Kentucky | 21111 | 80963 | 1178 |
1272105 | 1272105 | 2021-04-30 | Jefferson | Kentucky | 21111 | 80858 | 1177 |
1268858 | 1268858 | 2021-04-29 | Jefferson | Kentucky | 21111 | 80733 | 1177 |
1265611 | 1265611 | 2021-04-28 | Jefferson | Kentucky | 21111 | 80526 | 1177 |
1262364 | 1262364 | 2021-04-27 | Jefferson | Kentucky | 21111 | 80421 | 1176 |
1259117 | 1259117 | 2021-04-26 | Jefferson | Kentucky | 21111 | 80316 | 1173 |
1255870 | 1255870 | 2021-04-25 | Jefferson | Kentucky | 21111 | 80241 | 1169 |
1252623 | 1252623 | 2021-04-24 | Jefferson | Kentucky | 21111 | 80176 | 1167 |
1249376 | 1249376 | 2021-04-23 | Jefferson | Kentucky | 21111 | 80093 | 1153 |
1246129 | 1246129 | 2021-04-22 | Jefferson | Kentucky | 21111 | 79997 | 1148 |
1242882 | 1242882 | 2021-04-21 | Jefferson | Kentucky | 21111 | 79906 | 1147 |
1239635 | 1239635 | 2021-04-20 | Jefferson | Kentucky | 21111 | 79829 | 1143 |
1236388 | 1236388 | 2021-04-19 | Jefferson | Kentucky | 21111 | 79723 | 1142 |
1233141 | 1233141 | 2021-04-18 | Jefferson | Kentucky | 21111 | 79683 | 1141 |
1229893 | 1229893 | 2021-04-17 | Jefferson | Kentucky | 21111 | 79629 | 1139 |
1226645 | 1226645 | 2021-04-16 | Jefferson | Kentucky | 21111 | 79525 | 1134 |
1223398 | 1223398 | 2021-04-15 | Jefferson | Kentucky | 21111 | 79401 | 1131 |
1220150 | 1220150 | 2021-04-14 | Jefferson | Kentucky | 21111 | 79259 | 1131 |
1216902 | 1216902 | 2021-04-13 | Jefferson | Kentucky | 21111 | 79152 | 1126 |
1213655 | 1213655 | 2021-04-12 | Jefferson | Kentucky | 21111 | 78937 | 1125 |
1210407 | 1210407 | 2021-04-11 | Jefferson | Kentucky | 21111 | 78868 | 1123 |
1207158 | 1207158 | 2021-04-10 | Jefferson | Kentucky | 21111 | 78660 | 1122 |
1203910 | 1203910 | 2021-04-09 | Jefferson | Kentucky | 21111 | 78660 | 1116 |
1200662 | 1200662 | 2021-04-08 | Jefferson | Kentucky | 21111 | 78510 | 1115 |
1197413 | 1197413 | 2021-04-07 | Jefferson | Kentucky | 21111 | 78376 | 1108 |
1194165 | 1194165 | 2021-04-06 | Jefferson | Kentucky | 21111 | 78243 | 1106 |
1190915 | 1190915 | 2021-04-05 | Jefferson | Kentucky | 21111 | 78139 | 1101 |
1187668 | 1187668 | 2021-04-04 | Jefferson | Kentucky | 21111 | 78099 | 1098 |
1184421 | 1184421 | 2021-04-03 | Jefferson | Kentucky | 21111 | 78042 | 1098 |
1181174 | 1181174 | 2021-04-02 | Jefferson | Kentucky | 21111 | 77945 | 1096 |
1177927 | 1177927 | 2021-04-01 | Jefferson | Kentucky | 21111 | 77863 | 1093 |
1174680 | 1174680 | 2021-03-31 | Jefferson | Kentucky | 21111 | 77649 | 1091 |
1171433 | 1171433 | 2021-03-30 | Jefferson | Kentucky | 21111 | 77649 | 1088 |
1168185 | 1168185 | 2021-03-29 | Jefferson | Kentucky | 21111 | 77580 | 1086 |
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);