ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Lawrence" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418193 | 1418193 | 2021-06-14 | Lawrence | Kentucky | 21127 | 1481 | 27 |
1414947 | 1414947 | 2021-06-13 | Lawrence | Kentucky | 21127 | 1481 | 27 |
1411702 | 1411702 | 2021-06-12 | Lawrence | Kentucky | 21127 | 1481 | 27 |
1408457 | 1408457 | 2021-06-11 | Lawrence | Kentucky | 21127 | 1480 | 27 |
1405211 | 1405211 | 2021-06-10 | Lawrence | Kentucky | 21127 | 1478 | 27 |
1401966 | 1401966 | 2021-06-09 | Lawrence | Kentucky | 21127 | 1476 | 27 |
1398721 | 1398721 | 2021-06-08 | Lawrence | Kentucky | 21127 | 1476 | 26 |
1395474 | 1395474 | 2021-06-07 | Lawrence | Kentucky | 21127 | 1476 | 26 |
1392229 | 1392229 | 2021-06-06 | Lawrence | Kentucky | 21127 | 1476 | 26 |
1388984 | 1388984 | 2021-06-05 | Lawrence | Kentucky | 21127 | 1476 | 26 |
1385739 | 1385739 | 2021-06-04 | Lawrence | Kentucky | 21127 | 1475 | 26 |
1382493 | 1382493 | 2021-06-03 | Lawrence | Kentucky | 21127 | 1475 | 25 |
1379248 | 1379248 | 2021-06-02 | Lawrence | Kentucky | 21127 | 1475 | 25 |
1376002 | 1376002 | 2021-06-01 | Lawrence | Kentucky | 21127 | 1472 | 25 |
1372757 | 1372757 | 2021-05-31 | Lawrence | Kentucky | 21127 | 1471 | 25 |
1369512 | 1369512 | 2021-05-30 | Lawrence | Kentucky | 21127 | 1471 | 25 |
1366266 | 1366266 | 2021-05-29 | Lawrence | Kentucky | 21127 | 1471 | 25 |
1363020 | 1363020 | 2021-05-28 | Lawrence | Kentucky | 21127 | 1471 | 25 |
1359773 | 1359773 | 2021-05-27 | Lawrence | Kentucky | 21127 | 1468 | 25 |
1356527 | 1356527 | 2021-05-26 | Lawrence | Kentucky | 21127 | 1466 | 25 |
1353281 | 1353281 | 2021-05-25 | Lawrence | Kentucky | 21127 | 1466 | 25 |
1350035 | 1350035 | 2021-05-24 | Lawrence | Kentucky | 21127 | 1464 | 25 |
1346788 | 1346788 | 2021-05-23 | Lawrence | Kentucky | 21127 | 1462 | 25 |
1343540 | 1343540 | 2021-05-22 | Lawrence | Kentucky | 21127 | 1461 | 25 |
1340292 | 1340292 | 2021-05-21 | Lawrence | Kentucky | 21127 | 1460 | 25 |
1337045 | 1337045 | 2021-05-20 | Lawrence | Kentucky | 21127 | 1460 | 25 |
1333798 | 1333798 | 2021-05-19 | Lawrence | Kentucky | 21127 | 1460 | 25 |
1330551 | 1330551 | 2021-05-18 | Lawrence | Kentucky | 21127 | 1459 | 25 |
1327304 | 1327304 | 2021-05-17 | Lawrence | Kentucky | 21127 | 1455 | 25 |
1324058 | 1324058 | 2021-05-16 | Lawrence | Kentucky | 21127 | 1455 | 25 |
1320812 | 1320812 | 2021-05-15 | Lawrence | Kentucky | 21127 | 1455 | 25 |
1317565 | 1317565 | 2021-05-14 | Lawrence | Kentucky | 21127 | 1453 | 25 |
1314318 | 1314318 | 2021-05-13 | Lawrence | Kentucky | 21127 | 1450 | 25 |
1311071 | 1311071 | 2021-05-12 | Lawrence | Kentucky | 21127 | 1448 | 25 |
1307825 | 1307825 | 2021-05-11 | Lawrence | Kentucky | 21127 | 1445 | 25 |
1304579 | 1304579 | 2021-05-10 | Lawrence | Kentucky | 21127 | 1442 | 24 |
1301332 | 1301332 | 2021-05-09 | Lawrence | Kentucky | 21127 | 1442 | 24 |
1298085 | 1298085 | 2021-05-08 | Lawrence | Kentucky | 21127 | 1442 | 24 |
1294839 | 1294839 | 2021-05-07 | Lawrence | Kentucky | 21127 | 1440 | 24 |
1291593 | 1291593 | 2021-05-06 | Lawrence | Kentucky | 21127 | 1439 | 24 |
1288347 | 1288347 | 2021-05-05 | Lawrence | Kentucky | 21127 | 1438 | 23 |
1285101 | 1285101 | 2021-05-04 | Lawrence | Kentucky | 21127 | 1435 | 22 |
1281854 | 1281854 | 2021-05-03 | Lawrence | Kentucky | 21127 | 1429 | 22 |
1278607 | 1278607 | 2021-05-02 | Lawrence | Kentucky | 21127 | 1426 | 21 |
1275360 | 1275360 | 2021-05-01 | Lawrence | Kentucky | 21127 | 1423 | 21 |
1272113 | 1272113 | 2021-04-30 | Lawrence | Kentucky | 21127 | 1420 | 20 |
1268866 | 1268866 | 2021-04-29 | Lawrence | Kentucky | 21127 | 1417 | 20 |
1265619 | 1265619 | 2021-04-28 | Lawrence | Kentucky | 21127 | 1416 | 20 |
1262372 | 1262372 | 2021-04-27 | Lawrence | Kentucky | 21127 | 1412 | 20 |
1259125 | 1259125 | 2021-04-26 | Lawrence | Kentucky | 21127 | 1409 | 20 |
1255878 | 1255878 | 2021-04-25 | Lawrence | Kentucky | 21127 | 1408 | 20 |
1252631 | 1252631 | 2021-04-24 | Lawrence | Kentucky | 21127 | 1407 | 20 |
1249384 | 1249384 | 2021-04-23 | Lawrence | Kentucky | 21127 | 1404 | 20 |
1246137 | 1246137 | 2021-04-22 | Lawrence | Kentucky | 21127 | 1402 | 20 |
1242890 | 1242890 | 2021-04-21 | Lawrence | Kentucky | 21127 | 1398 | 20 |
1239643 | 1239643 | 2021-04-20 | Lawrence | Kentucky | 21127 | 1394 | 20 |
1236396 | 1236396 | 2021-04-19 | Lawrence | Kentucky | 21127 | 1390 | 20 |
1233149 | 1233149 | 2021-04-18 | Lawrence | Kentucky | 21127 | 1390 | 20 |
1229901 | 1229901 | 2021-04-17 | Lawrence | Kentucky | 21127 | 1390 | 20 |
1226653 | 1226653 | 2021-04-16 | Lawrence | Kentucky | 21127 | 1388 | 20 |
1223406 | 1223406 | 2021-04-15 | Lawrence | Kentucky | 21127 | 1383 | 20 |
1220158 | 1220158 | 2021-04-14 | Lawrence | Kentucky | 21127 | 1381 | 20 |
1216910 | 1216910 | 2021-04-13 | Lawrence | Kentucky | 21127 | 1381 | 20 |
1213663 | 1213663 | 2021-04-12 | Lawrence | Kentucky | 21127 | 1378 | 20 |
1210415 | 1210415 | 2021-04-11 | Lawrence | Kentucky | 21127 | 1374 | 20 |
1207166 | 1207166 | 2021-04-10 | Lawrence | Kentucky | 21127 | 1372 | 20 |
1203918 | 1203918 | 2021-04-09 | Lawrence | Kentucky | 21127 | 1371 | 20 |
1200670 | 1200670 | 2021-04-08 | Lawrence | Kentucky | 21127 | 1367 | 20 |
1197421 | 1197421 | 2021-04-07 | Lawrence | Kentucky | 21127 | 1358 | 20 |
1194173 | 1194173 | 2021-04-06 | Lawrence | Kentucky | 21127 | 1351 | 20 |
1190923 | 1190923 | 2021-04-05 | Lawrence | Kentucky | 21127 | 1351 | 20 |
1187676 | 1187676 | 2021-04-04 | Lawrence | Kentucky | 21127 | 1350 | 20 |
1184429 | 1184429 | 2021-04-03 | Lawrence | Kentucky | 21127 | 1350 | 20 |
1181182 | 1181182 | 2021-04-02 | Lawrence | Kentucky | 21127 | 1348 | 20 |
1177935 | 1177935 | 2021-04-01 | Lawrence | Kentucky | 21127 | 1345 | 20 |
1174688 | 1174688 | 2021-03-31 | Lawrence | Kentucky | 21127 | 1342 | 20 |
1171441 | 1171441 | 2021-03-30 | Lawrence | Kentucky | 21127 | 1336 | 20 |
1168193 | 1168193 | 2021-03-29 | Lawrence | Kentucky | 21127 | 1329 | 20 |
1164945 | 1164945 | 2021-03-28 | Lawrence | Kentucky | 21127 | 1329 | 20 |
1161697 | 1161697 | 2021-03-27 | Lawrence | Kentucky | 21127 | 1327 | 20 |
1158449 | 1158449 | 2021-03-26 | Lawrence | Kentucky | 21127 | 1324 | 20 |
1155202 | 1155202 | 2021-03-25 | Lawrence | Kentucky | 21127 | 1324 | 20 |
1151955 | 1151955 | 2021-03-24 | Lawrence | Kentucky | 21127 | 1324 | 20 |
1148708 | 1148708 | 2021-03-23 | Lawrence | Kentucky | 21127 | 1318 | 20 |
1145461 | 1145461 | 2021-03-22 | Lawrence | Kentucky | 21127 | 1318 | 20 |
1142214 | 1142214 | 2021-03-21 | Lawrence | Kentucky | 21127 | 1318 | 20 |
1138968 | 1138968 | 2021-03-20 | Lawrence | Kentucky | 21127 | 1318 | 20 |
1135722 | 1135722 | 2021-03-19 | Lawrence | Kentucky | 21127 | 1315 | 20 |
1132475 | 1132475 | 2021-03-18 | Lawrence | Kentucky | 21127 | 1312 | 20 |
1129227 | 1129227 | 2021-03-17 | Lawrence | Kentucky | 21127 | 1305 | 20 |
1125981 | 1125981 | 2021-03-16 | Lawrence | Kentucky | 21127 | 1303 | 20 |
1122735 | 1122735 | 2021-03-15 | Lawrence | Kentucky | 21127 | 1299 | 20 |
1119488 | 1119488 | 2021-03-14 | Lawrence | Kentucky | 21127 | 1299 | 20 |
1116241 | 1116241 | 2021-03-13 | Lawrence | Kentucky | 21127 | 1298 | 20 |
1112995 | 1112995 | 2021-03-12 | Lawrence | Kentucky | 21127 | 1296 | 20 |
1109749 | 1109749 | 2021-03-11 | Lawrence | Kentucky | 21127 | 1294 | 20 |
1106503 | 1106503 | 2021-03-10 | Lawrence | Kentucky | 21127 | 1292 | 20 |
1103257 | 1103257 | 2021-03-09 | Lawrence | Kentucky | 21127 | 1289 | 20 |
1100011 | 1100011 | 2021-03-08 | Lawrence | Kentucky | 21127 | 1284 | 20 |
1096763 | 1096763 | 2021-03-07 | Lawrence | Kentucky | 21127 | 1285 | 20 |
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);