ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lamar" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1387958 | 1387958 | 2021-06-05 | Lamar | Alabama | 1075 | 1458 | 37 |
1384713 | 1384713 | 2021-06-04 | Lamar | Alabama | 1075 | 1458 | 37 |
1381467 | 1381467 | 2021-06-03 | Lamar | Alabama | 1075 | 1457 | 37 |
1378222 | 1378222 | 2021-06-02 | Lamar | Alabama | 1075 | 1454 | 37 |
1374976 | 1374976 | 2021-06-01 | Lamar | Alabama | 1075 | 1452 | 37 |
1371731 | 1371731 | 2021-05-31 | Lamar | Alabama | 1075 | 1450 | 37 |
1368485 | 1368485 | 2021-05-30 | Lamar | Alabama | 1075 | 1450 | 37 |
1365239 | 1365239 | 2021-05-29 | Lamar | Alabama | 1075 | 1450 | 37 |
1361993 | 1361993 | 2021-05-28 | Lamar | Alabama | 1075 | 1450 | 37 |
1358747 | 1358747 | 2021-05-27 | Lamar | Alabama | 1075 | 1449 | 37 |
1355501 | 1355501 | 2021-05-26 | Lamar | Alabama | 1075 | 1446 | 37 |
1352255 | 1352255 | 2021-05-25 | Lamar | Alabama | 1075 | 1444 | 37 |
1349009 | 1349009 | 2021-05-24 | Lamar | Alabama | 1075 | 1442 | 37 |
1345761 | 1345761 | 2021-05-23 | Lamar | Alabama | 1075 | 1441 | 37 |
1342513 | 1342513 | 2021-05-22 | Lamar | Alabama | 1075 | 1441 | 37 |
1339265 | 1339265 | 2021-05-21 | Lamar | Alabama | 1075 | 1441 | 37 |
1336018 | 1336018 | 2021-05-20 | Lamar | Alabama | 1075 | 1440 | 37 |
1332771 | 1332771 | 2021-05-19 | Lamar | Alabama | 1075 | 1440 | 36 |
1329524 | 1329524 | 2021-05-18 | Lamar | Alabama | 1075 | 1434 | 36 |
1326278 | 1326278 | 2021-05-17 | Lamar | Alabama | 1075 | 1433 | 36 |
1323032 | 1323032 | 2021-05-16 | Lamar | Alabama | 1075 | 1433 | 36 |
1319786 | 1319786 | 2021-05-15 | Lamar | Alabama | 1075 | 1432 | 36 |
1316538 | 1316538 | 2021-05-14 | Lamar | Alabama | 1075 | 1430 | 35 |
1313292 | 1313292 | 2021-05-13 | Lamar | Alabama | 1075 | 1429 | 35 |
1310045 | 1310045 | 2021-05-12 | Lamar | Alabama | 1075 | 1427 | 35 |
1306799 | 1306799 | 2021-05-11 | Lamar | Alabama | 1075 | 1425 | 35 |
1303553 | 1303553 | 2021-05-10 | Lamar | Alabama | 1075 | 1425 | 35 |
1300306 | 1300306 | 2021-05-09 | Lamar | Alabama | 1075 | 1425 | 35 |
1297059 | 1297059 | 2021-05-08 | Lamar | Alabama | 1075 | 1425 | 35 |
1293813 | 1293813 | 2021-05-07 | Lamar | Alabama | 1075 | 1419 | 34 |
1290567 | 1290567 | 2021-05-06 | Lamar | Alabama | 1075 | 1418 | 34 |
1287321 | 1287321 | 2021-05-05 | Lamar | Alabama | 1075 | 1415 | 34 |
1284075 | 1284075 | 2021-05-04 | Lamar | Alabama | 1075 | 1412 | 34 |
1280828 | 1280828 | 2021-05-03 | Lamar | Alabama | 1075 | 1412 | 34 |
1277581 | 1277581 | 2021-05-02 | Lamar | Alabama | 1075 | 1411 | 34 |
1274334 | 1274334 | 2021-05-01 | Lamar | Alabama | 1075 | 1409 | 34 |
1271087 | 1271087 | 2021-04-30 | Lamar | Alabama | 1075 | 1408 | 34 |
1267840 | 1267840 | 2021-04-29 | Lamar | Alabama | 1075 | 1406 | 34 |
1264593 | 1264593 | 2021-04-28 | Lamar | Alabama | 1075 | 1406 | 34 |
1261346 | 1261346 | 2021-04-27 | Lamar | Alabama | 1075 | 1404 | 34 |
1258099 | 1258099 | 2021-04-26 | Lamar | Alabama | 1075 | 1404 | 34 |
1254852 | 1254852 | 2021-04-25 | Lamar | Alabama | 1075 | 1404 | 34 |
1251605 | 1251605 | 2021-04-24 | Lamar | Alabama | 1075 | 1403 | 34 |
1248358 | 1248358 | 2021-04-23 | Lamar | Alabama | 1075 | 1399 | 34 |
1245111 | 1245111 | 2021-04-22 | Lamar | Alabama | 1075 | 1398 | 34 |
1241864 | 1241864 | 2021-04-21 | Lamar | Alabama | 1075 | 1398 | 34 |
1238617 | 1238617 | 2021-04-20 | Lamar | Alabama | 1075 | 1400 | 34 |
1235370 | 1235370 | 2021-04-19 | Lamar | Alabama | 1075 | 1400 | 34 |
1232122 | 1232122 | 2021-04-18 | Lamar | Alabama | 1075 | 1399 | 34 |
1228874 | 1228874 | 2021-04-17 | Lamar | Alabama | 1075 | 1397 | 34 |
1225626 | 1225626 | 2021-04-16 | Lamar | Alabama | 1075 | 1397 | 34 |
1222379 | 1222379 | 2021-04-15 | Lamar | Alabama | 1075 | 1396 | 34 |
1219131 | 1219131 | 2021-04-14 | Lamar | Alabama | 1075 | 1394 | 34 |
1215883 | 1215883 | 2021-04-13 | Lamar | Alabama | 1075 | 1393 | 34 |
1212636 | 1212636 | 2021-04-12 | Lamar | Alabama | 1075 | 1393 | 34 |
1209387 | 1209387 | 2021-04-11 | Lamar | Alabama | 1075 | 1392 | 34 |
1206139 | 1206139 | 2021-04-10 | Lamar | Alabama | 1075 | 1392 | 34 |
1202891 | 1202891 | 2021-04-09 | Lamar | Alabama | 1075 | 1392 | 34 |
1199643 | 1199643 | 2021-04-08 | Lamar | Alabama | 1075 | 1392 | 34 |
1196394 | 1196394 | 2021-04-07 | Lamar | Alabama | 1075 | 1392 | 33 |
1193146 | 1193146 | 2021-04-06 | Lamar | Alabama | 1075 | 1392 | 33 |
1189896 | 1189896 | 2021-04-05 | Lamar | Alabama | 1075 | 1392 | 33 |
1186649 | 1186649 | 2021-04-04 | Lamar | Alabama | 1075 | 1392 | 33 |
1183402 | 1183402 | 2021-04-03 | Lamar | Alabama | 1075 | 1392 | 33 |
1180155 | 1180155 | 2021-04-02 | Lamar | Alabama | 1075 | 1392 | 33 |
1176908 | 1176908 | 2021-04-01 | Lamar | Alabama | 1075 | 1390 | 33 |
1173661 | 1173661 | 2021-03-31 | Lamar | Alabama | 1075 | 1384 | 33 |
1170414 | 1170414 | 2021-03-30 | Lamar | Alabama | 1075 | 1384 | 33 |
1167166 | 1167166 | 2021-03-29 | Lamar | Alabama | 1075 | 1384 | 33 |
1163918 | 1163918 | 2021-03-28 | Lamar | Alabama | 1075 | 1384 | 33 |
1160670 | 1160670 | 2021-03-27 | Lamar | Alabama | 1075 | 1384 | 33 |
1157422 | 1157422 | 2021-03-26 | Lamar | Alabama | 1075 | 1382 | 33 |
1154175 | 1154175 | 2021-03-25 | Lamar | Alabama | 1075 | 1378 | 33 |
1150928 | 1150928 | 2021-03-24 | Lamar | Alabama | 1075 | 1378 | 33 |
1147681 | 1147681 | 2021-03-23 | Lamar | Alabama | 1075 | 1372 | 33 |
1144434 | 1144434 | 2021-03-22 | Lamar | Alabama | 1075 | 1373 | 33 |
1141187 | 1141187 | 2021-03-21 | Lamar | Alabama | 1075 | 1372 | 33 |
1137941 | 1137941 | 2021-03-20 | Lamar | Alabama | 1075 | 1372 | 33 |
1134695 | 1134695 | 2021-03-19 | Lamar | Alabama | 1075 | 1369 | 33 |
1131447 | 1131447 | 2021-03-18 | Lamar | Alabama | 1075 | 1368 | 33 |
1128200 | 1128200 | 2021-03-17 | Lamar | Alabama | 1075 | 1367 | 33 |
1124954 | 1124954 | 2021-03-16 | Lamar | Alabama | 1075 | 1366 | 33 |
1121708 | 1121708 | 2021-03-15 | Lamar | Alabama | 1075 | 1365 | 33 |
1118461 | 1118461 | 2021-03-14 | Lamar | Alabama | 1075 | 1352 | 33 |
1115214 | 1115214 | 2021-03-13 | Lamar | Alabama | 1075 | 1351 | 33 |
1111968 | 1111968 | 2021-03-12 | Lamar | Alabama | 1075 | 1349 | 33 |
1108722 | 1108722 | 2021-03-11 | Lamar | Alabama | 1075 | 1351 | 33 |
1105476 | 1105476 | 2021-03-10 | Lamar | Alabama | 1075 | 1349 | 33 |
1102230 | 1102230 | 2021-03-09 | Lamar | Alabama | 1075 | 1340 | 33 |
1098984 | 1098984 | 2021-03-08 | Lamar | Alabama | 1075 | 1339 | 33 |
1095736 | 1095736 | 2021-03-07 | Lamar | Alabama | 1075 | 1339 | 33 |
1092490 | 1092490 | 2021-03-06 | Lamar | Alabama | 1075 | 1339 | 33 |
1089244 | 1089244 | 2021-03-05 | Lamar | Alabama | 1075 | 1339 | 33 |
1085999 | 1085999 | 2021-03-04 | Lamar | Alabama | 1075 | 1337 | 33 |
1082753 | 1082753 | 2021-03-03 | Lamar | Alabama | 1075 | 1337 | 33 |
1079507 | 1079507 | 2021-03-02 | Lamar | Alabama | 1075 | 1331 | 33 |
1076262 | 1076262 | 2021-03-01 | Lamar | Alabama | 1075 | 1328 | 33 |
1073016 | 1073016 | 2021-02-28 | Lamar | Alabama | 1075 | 1328 | 33 |
1069770 | 1069770 | 2021-02-27 | Lamar | Alabama | 1075 | 1325 | 33 |
1066525 | 1066525 | 2021-02-26 | Lamar | Alabama | 1075 | 1324 | 32 |
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);