ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where county = "Lawrence" and deaths = 20 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
- Kentucky 65
- Tennessee 9
- Alabama 8
- Mississippi 8
- Missouri 3
- Pennsylvania 2
- Arkansas 1
- Illinois 1
county 1
- Lawrence · 97 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1093517 | 1093517 | 2021-03-06 | Lawrence | Kentucky | 21127 | 1282 | 20 |
1090271 | 1090271 | 2021-03-05 | Lawrence | Kentucky | 21127 | 1277 | 20 |
1087026 | 1087026 | 2021-03-04 | Lawrence | Kentucky | 21127 | 1273 | 20 |
1083780 | 1083780 | 2021-03-03 | Lawrence | Kentucky | 21127 | 1269 | 20 |
1080534 | 1080534 | 2021-03-02 | Lawrence | Kentucky | 21127 | 1259 | 20 |
1077289 | 1077289 | 2021-03-01 | Lawrence | Kentucky | 21127 | 1258 | 20 |
1074043 | 1074043 | 2021-02-28 | Lawrence | Kentucky | 21127 | 1255 | 20 |
1070797 | 1070797 | 2021-02-27 | Lawrence | Kentucky | 21127 | 1252 | 20 |
1067552 | 1067552 | 2021-02-26 | Lawrence | Kentucky | 21127 | 1251 | 20 |
1064307 | 1064307 | 2021-02-25 | Lawrence | Kentucky | 21127 | 1240 | 20 |
1058205 | 1058205 | 2021-02-23 | Lawrence | Mississippi | 28077 | 1184 | 20 |
1054959 | 1054959 | 2021-02-22 | Lawrence | Mississippi | 28077 | 1181 | 20 |
1051712 | 1051712 | 2021-02-21 | Lawrence | Mississippi | 28077 | 1179 | 20 |
1048465 | 1048465 | 2021-02-20 | Lawrence | Mississippi | 28077 | 1180 | 20 |
1045219 | 1045219 | 2021-02-19 | Lawrence | Mississippi | 28077 | 1178 | 20 |
1041974 | 1041974 | 2021-02-18 | Lawrence | Mississippi | 28077 | 1177 | 20 |
1038729 | 1038729 | 2021-02-17 | Lawrence | Mississippi | 28077 | 1176 | 20 |
1035484 | 1035484 | 2021-02-16 | Lawrence | Mississippi | 28077 | 1176 | 20 |
820480 | 820480 | 2020-12-12 | Lawrence | Illinois | 17101 | 1414 | 20 |
692613 | 692613 | 2020-11-02 | Lawrence | Tennessee | 47099 | 1780 | 20 |
689369 | 689369 | 2020-11-01 | Lawrence | Tennessee | 47099 | 1746 | 20 |
683698 | 683698 | 2020-10-31 | Lawrence | Arkansas | 5075 | 873 | 20 |
686124 | 686124 | 2020-10-31 | Lawrence | Tennessee | 47099 | 1740 | 20 |
682881 | 682881 | 2020-10-30 | Lawrence | Tennessee | 47099 | 1732 | 20 |
679638 | 679638 | 2020-10-29 | Lawrence | Tennessee | 47099 | 1707 | 20 |
676395 | 676395 | 2020-10-28 | Lawrence | Tennessee | 47099 | 1696 | 20 |
673152 | 673152 | 2020-10-27 | Lawrence | Tennessee | 47099 | 1665 | 20 |
668889 | 668889 | 2020-10-26 | Lawrence | Missouri | 29109 | 1096 | 20 |
669910 | 669910 | 2020-10-26 | Lawrence | Tennessee | 47099 | 1645 | 20 |
665645 | 665645 | 2020-10-25 | Lawrence | Missouri | 29109 | 1089 | 20 |
666666 | 666666 | 2020-10-25 | Lawrence | Tennessee | 47099 | 1618 | 20 |
662400 | 662400 | 2020-10-24 | Lawrence | Missouri | 29109 | 1062 | 20 |
557124 | 557124 | 2020-09-22 | Lawrence | Alabama | 1079 | 603 | 20 |
553887 | 553887 | 2020-09-21 | Lawrence | Alabama | 1079 | 592 | 20 |
550648 | 550648 | 2020-09-20 | Lawrence | Alabama | 1079 | 585 | 20 |
547409 | 547409 | 2020-09-19 | Lawrence | Alabama | 1079 | 582 | 20 |
544172 | 544172 | 2020-09-18 | Lawrence | Alabama | 1079 | 578 | 20 |
540936 | 540936 | 2020-09-17 | Lawrence | Alabama | 1079 | 576 | 20 |
537699 | 537699 | 2020-09-16 | Lawrence | Alabama | 1079 | 573 | 20 |
534463 | 534463 | 2020-09-15 | Lawrence | Alabama | 1079 | 568 | 20 |
507596 | 507596 | 2020-09-06 | Lawrence | Pennsylvania | 42073 | 474 | 20 |
504364 | 504364 | 2020-09-05 | Lawrence | Pennsylvania | 42073 | 474 | 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);