ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 21067 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1489570 | 1489570 | 2021-07-06 | Fayette | Kentucky | 21067 | 36549 | 323 |
1486323 | 1486323 | 2021-07-05 | Fayette | Kentucky | 21067 | 36544 | 323 |
1483077 | 1483077 | 2021-07-04 | Fayette | Kentucky | 21067 | 36544 | 323 |
1479830 | 1479830 | 2021-07-03 | Fayette | Kentucky | 21067 | 36544 | 323 |
1476584 | 1476584 | 2021-07-02 | Fayette | Kentucky | 21067 | 36544 | 323 |
1473338 | 1473338 | 2021-07-01 | Fayette | Kentucky | 21067 | 36557 | 323 |
1470092 | 1470092 | 2021-06-30 | Fayette | Kentucky | 21067 | 36543 | 323 |
1466847 | 1466847 | 2021-06-29 | Fayette | Kentucky | 21067 | 36531 | 323 |
1463602 | 1463602 | 2021-06-28 | Fayette | Kentucky | 21067 | 36519 | 323 |
1460357 | 1460357 | 2021-06-27 | Fayette | Kentucky | 21067 | 36498 | 323 |
1457112 | 1457112 | 2021-06-26 | Fayette | Kentucky | 21067 | 36498 | 323 |
1453867 | 1453867 | 2021-06-25 | Fayette | Kentucky | 21067 | 36498 | 323 |
1450621 | 1450621 | 2021-06-24 | Fayette | Kentucky | 21067 | 36485 | 322 |
1447376 | 1447376 | 2021-06-23 | Fayette | Kentucky | 21067 | 36483 | 322 |
1444131 | 1444131 | 2021-06-22 | Fayette | Kentucky | 21067 | 36473 | 322 |
1440886 | 1440886 | 2021-06-21 | Fayette | Kentucky | 21067 | 36460 | 322 |
1437639 | 1437639 | 2021-06-20 | Fayette | Kentucky | 21067 | 36440 | 322 |
1434392 | 1434392 | 2021-06-19 | Fayette | Kentucky | 21067 | 36440 | 322 |
1431146 | 1431146 | 2021-06-18 | Fayette | Kentucky | 21067 | 36440 | 322 |
1427901 | 1427901 | 2021-06-17 | Fayette | Kentucky | 21067 | 36418 | 322 |
1424656 | 1424656 | 2021-06-16 | Fayette | Kentucky | 21067 | 36406 | 322 |
1421408 | 1421408 | 2021-06-15 | Fayette | Kentucky | 21067 | 36396 | 322 |
1418163 | 1418163 | 2021-06-14 | Fayette | Kentucky | 21067 | 36386 | 322 |
1414917 | 1414917 | 2021-06-13 | Fayette | Kentucky | 21067 | 36375 | 322 |
1411672 | 1411672 | 2021-06-12 | Fayette | Kentucky | 21067 | 36372 | 322 |
1408427 | 1408427 | 2021-06-11 | Fayette | Kentucky | 21067 | 36355 | 322 |
1405181 | 1405181 | 2021-06-10 | Fayette | Kentucky | 21067 | 36333 | 318 |
1401936 | 1401936 | 2021-06-09 | Fayette | Kentucky | 21067 | 36319 | 317 |
1398691 | 1398691 | 2021-06-08 | Fayette | Kentucky | 21067 | 36303 | 317 |
1395444 | 1395444 | 2021-06-07 | Fayette | Kentucky | 21067 | 36269 | 317 |
1392199 | 1392199 | 2021-06-06 | Fayette | Kentucky | 21067 | 36260 | 317 |
1388954 | 1388954 | 2021-06-05 | Fayette | Kentucky | 21067 | 36260 | 317 |
1385709 | 1385709 | 2021-06-04 | Fayette | Kentucky | 21067 | 36244 | 317 |
1382463 | 1382463 | 2021-06-03 | Fayette | Kentucky | 21067 | 36216 | 316 |
1379218 | 1379218 | 2021-06-02 | Fayette | Kentucky | 21067 | 36205 | 316 |
1375972 | 1375972 | 2021-06-01 | Fayette | Kentucky | 21067 | 36193 | 316 |
1372727 | 1372727 | 2021-05-31 | Fayette | Kentucky | 21067 | 36164 | 316 |
1369482 | 1369482 | 2021-05-30 | Fayette | Kentucky | 21067 | 36164 | 316 |
1366236 | 1366236 | 2021-05-29 | Fayette | Kentucky | 21067 | 36164 | 316 |
1362990 | 1362990 | 2021-05-28 | Fayette | Kentucky | 21067 | 36143 | 316 |
1359743 | 1359743 | 2021-05-27 | Fayette | Kentucky | 21067 | 36111 | 316 |
1356497 | 1356497 | 2021-05-26 | Fayette | Kentucky | 21067 | 36088 | 316 |
1353251 | 1353251 | 2021-05-25 | Fayette | Kentucky | 21067 | 36061 | 316 |
1350005 | 1350005 | 2021-05-24 | Fayette | Kentucky | 21067 | 36025 | 316 |
1346758 | 1346758 | 2021-05-23 | Fayette | Kentucky | 21067 | 36020 | 316 |
1343510 | 1343510 | 2021-05-22 | Fayette | Kentucky | 21067 | 36002 | 316 |
1340262 | 1340262 | 2021-05-21 | Fayette | Kentucky | 21067 | 35973 | 316 |
1337015 | 1337015 | 2021-05-20 | Fayette | Kentucky | 21067 | 35949 | 315 |
1333768 | 1333768 | 2021-05-19 | Fayette | Kentucky | 21067 | 35923 | 315 |
1330521 | 1330521 | 2021-05-18 | Fayette | Kentucky | 21067 | 35895 | 315 |
1327274 | 1327274 | 2021-05-17 | Fayette | Kentucky | 21067 | 35854 | 314 |
1324028 | 1324028 | 2021-05-16 | Fayette | Kentucky | 21067 | 35850 | 314 |
1320782 | 1320782 | 2021-05-15 | Fayette | Kentucky | 21067 | 35837 | 314 |
1317535 | 1317535 | 2021-05-14 | Fayette | Kentucky | 21067 | 35810 | 314 |
1314288 | 1314288 | 2021-05-13 | Fayette | Kentucky | 21067 | 35779 | 309 |
1311041 | 1311041 | 2021-05-12 | Fayette | Kentucky | 21067 | 35741 | 309 |
1307795 | 1307795 | 2021-05-11 | Fayette | Kentucky | 21067 | 35702 | 309 |
1304549 | 1304549 | 2021-05-10 | Fayette | Kentucky | 21067 | 35653 | 309 |
1301302 | 1301302 | 2021-05-09 | Fayette | Kentucky | 21067 | 35651 | 309 |
1298055 | 1298055 | 2021-05-08 | Fayette | Kentucky | 21067 | 35625 | 309 |
1294809 | 1294809 | 2021-05-07 | Fayette | Kentucky | 21067 | 35584 | 309 |
1291563 | 1291563 | 2021-05-06 | Fayette | Kentucky | 21067 | 35557 | 308 |
1288317 | 1288317 | 2021-05-05 | Fayette | Kentucky | 21067 | 35506 | 308 |
1285071 | 1285071 | 2021-05-04 | Fayette | Kentucky | 21067 | 35451 | 309 |
1281824 | 1281824 | 2021-05-03 | Fayette | Kentucky | 21067 | 35400 | 307 |
1278577 | 1278577 | 2021-05-02 | Fayette | Kentucky | 21067 | 35389 | 307 |
1275330 | 1275330 | 2021-05-01 | Fayette | Kentucky | 21067 | 35355 | 307 |
1272083 | 1272083 | 2021-04-30 | Fayette | Kentucky | 21067 | 35315 | 307 |
1268836 | 1268836 | 2021-04-29 | Fayette | Kentucky | 21067 | 35268 | 304 |
1265589 | 1265589 | 2021-04-28 | Fayette | Kentucky | 21067 | 35226 | 304 |
1262342 | 1262342 | 2021-04-27 | Fayette | Kentucky | 21067 | 35170 | 304 |
1259095 | 1259095 | 2021-04-26 | Fayette | Kentucky | 21067 | 35117 | 304 |
1255848 | 1255848 | 2021-04-25 | Fayette | Kentucky | 21067 | 35103 | 304 |
1252601 | 1252601 | 2021-04-24 | Fayette | Kentucky | 21067 | 35076 | 304 |
1249354 | 1249354 | 2021-04-23 | Fayette | Kentucky | 21067 | 35035 | 304 |
1246107 | 1246107 | 2021-04-22 | Fayette | Kentucky | 21067 | 34986 | 303 |
1242860 | 1242860 | 2021-04-21 | Fayette | Kentucky | 21067 | 34932 | 297 |
1239613 | 1239613 | 2021-04-20 | Fayette | Kentucky | 21067 | 34881 | 297 |
1236366 | 1236366 | 2021-04-19 | Fayette | Kentucky | 21067 | 34833 | 297 |
1233119 | 1233119 | 2021-04-18 | Fayette | Kentucky | 21067 | 34821 | 297 |
1229871 | 1229871 | 2021-04-17 | Fayette | Kentucky | 21067 | 34787 | 297 |
1226623 | 1226623 | 2021-04-16 | Fayette | Kentucky | 21067 | 34750 | 297 |
1223376 | 1223376 | 2021-04-15 | Fayette | Kentucky | 21067 | 34706 | 296 |
1220128 | 1220128 | 2021-04-14 | Fayette | Kentucky | 21067 | 34653 | 296 |
1216880 | 1216880 | 2021-04-13 | Fayette | Kentucky | 21067 | 34593 | 296 |
1213633 | 1213633 | 2021-04-12 | Fayette | Kentucky | 21067 | 34552 | 296 |
1210385 | 1210385 | 2021-04-11 | Fayette | Kentucky | 21067 | 34557 | 296 |
1207136 | 1207136 | 2021-04-10 | Fayette | Kentucky | 21067 | 34495 | 296 |
1203888 | 1203888 | 2021-04-09 | Fayette | Kentucky | 21067 | 34461 | 296 |
1200640 | 1200640 | 2021-04-08 | Fayette | Kentucky | 21067 | 34405 | 293 |
1197391 | 1197391 | 2021-04-07 | Fayette | Kentucky | 21067 | 34359 | 293 |
1194143 | 1194143 | 2021-04-06 | Fayette | Kentucky | 21067 | 34294 | 290 |
1190893 | 1190893 | 2021-04-05 | Fayette | Kentucky | 21067 | 34277 | 290 |
1187646 | 1187646 | 2021-04-04 | Fayette | Kentucky | 21067 | 34270 | 290 |
1184399 | 1184399 | 2021-04-03 | Fayette | Kentucky | 21067 | 34270 | 290 |
1181152 | 1181152 | 2021-04-02 | Fayette | Kentucky | 21067 | 34220 | 286 |
1177905 | 1177905 | 2021-04-01 | Fayette | Kentucky | 21067 | 34187 | 286 |
1174658 | 1174658 | 2021-03-31 | Fayette | Kentucky | 21067 | 34153 | 282 |
1171411 | 1171411 | 2021-03-30 | Fayette | Kentucky | 21067 | 34089 | 282 |
1168163 | 1168163 | 2021-03-29 | Fayette | Kentucky | 21067 | 34032 | 281 |
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);