ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72003 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1487620 | 1487620 | 2021-07-05 | Aguada | Puerto Rico | 72003 | 1559 | |
1484373 | 1484373 | 2021-07-04 | Aguada | Puerto Rico | 72003 | 1559 | |
1481127 | 1481127 | 2021-07-03 | Aguada | Puerto Rico | 72003 | 1558 | |
1477880 | 1477880 | 2021-07-02 | Aguada | Puerto Rico | 72003 | 1557 | |
1474634 | 1474634 | 2021-07-01 | Aguada | Puerto Rico | 72003 | 1557 | |
1471388 | 1471388 | 2021-06-30 | Aguada | Puerto Rico | 72003 | 1557 | |
1468143 | 1468143 | 2021-06-29 | Aguada | Puerto Rico | 72003 | 1557 | |
1464898 | 1464898 | 2021-06-28 | Aguada | Puerto Rico | 72003 | 1558 | |
1461653 | 1461653 | 2021-06-27 | Aguada | Puerto Rico | 72003 | 1558 | |
1458408 | 1458408 | 2021-06-26 | Aguada | Puerto Rico | 72003 | 1558 | |
1455163 | 1455163 | 2021-06-25 | Aguada | Puerto Rico | 72003 | 1557 | |
1451918 | 1451918 | 2021-06-24 | Aguada | Puerto Rico | 72003 | 1556 | |
1448672 | 1448672 | 2021-06-23 | Aguada | Puerto Rico | 72003 | 1556 | |
1445427 | 1445427 | 2021-06-22 | Aguada | Puerto Rico | 72003 | 1557 | |
1442182 | 1442182 | 2021-06-21 | Aguada | Puerto Rico | 72003 | 1557 | |
1438937 | 1438937 | 2021-06-20 | Aguada | Puerto Rico | 72003 | 1557 | |
1435690 | 1435690 | 2021-06-19 | Aguada | Puerto Rico | 72003 | 1557 | |
1432443 | 1432443 | 2021-06-18 | Aguada | Puerto Rico | 72003 | 1556 | |
1429197 | 1429197 | 2021-06-17 | Aguada | Puerto Rico | 72003 | 1555 | |
1425952 | 1425952 | 2021-06-16 | Aguada | Puerto Rico | 72003 | 1555 | |
1422705 | 1422705 | 2021-06-15 | Aguada | Puerto Rico | 72003 | 1555 | |
1419459 | 1419459 | 2021-06-14 | Aguada | Puerto Rico | 72003 | 1555 | |
1416214 | 1416214 | 2021-06-13 | Aguada | Puerto Rico | 72003 | 1555 | |
1412968 | 1412968 | 2021-06-12 | Aguada | Puerto Rico | 72003 | 1555 | |
1409723 | 1409723 | 2021-06-11 | Aguada | Puerto Rico | 72003 | 1554 | |
1406478 | 1406478 | 2021-06-10 | Aguada | Puerto Rico | 72003 | 1554 | |
1403232 | 1403232 | 2021-06-09 | Aguada | Puerto Rico | 72003 | 1554 | |
1399987 | 1399987 | 2021-06-08 | Aguada | Puerto Rico | 72003 | 1554 | |
1396742 | 1396742 | 2021-06-07 | Aguada | Puerto Rico | 72003 | 1552 | |
1393495 | 1393495 | 2021-06-06 | Aguada | Puerto Rico | 72003 | 1551 | |
1390250 | 1390250 | 2021-06-05 | Aguada | Puerto Rico | 72003 | 1551 | |
1387005 | 1387005 | 2021-06-04 | Aguada | Puerto Rico | 72003 | 1546 | |
1383760 | 1383760 | 2021-06-03 | Aguada | Puerto Rico | 72003 | 1546 | |
1380514 | 1380514 | 2021-06-02 | Aguada | Puerto Rico | 72003 | 1546 | |
1377269 | 1377269 | 2021-06-01 | Aguada | Puerto Rico | 72003 | 1546 | |
1374023 | 1374023 | 2021-05-31 | Aguada | Puerto Rico | 72003 | 1544 | |
1370778 | 1370778 | 2021-05-30 | Aguada | Puerto Rico | 72003 | 1544 | |
1367532 | 1367532 | 2021-05-29 | Aguada | Puerto Rico | 72003 | 1543 | |
1364286 | 1364286 | 2021-05-28 | Aguada | Puerto Rico | 72003 | 1540 | |
1361040 | 1361040 | 2021-05-27 | Aguada | Puerto Rico | 72003 | 1540 | |
1357794 | 1357794 | 2021-05-26 | Aguada | Puerto Rico | 72003 | 1538 | |
1354548 | 1354548 | 2021-05-25 | Aguada | Puerto Rico | 72003 | 1538 | |
1351302 | 1351302 | 2021-05-24 | Aguada | Puerto Rico | 72003 | 1538 | |
1348056 | 1348056 | 2021-05-23 | Aguada | Puerto Rico | 72003 | 1537 | |
1344808 | 1344808 | 2021-05-22 | Aguada | Puerto Rico | 72003 | 1536 | |
1341560 | 1341560 | 2021-05-21 | Aguada | Puerto Rico | 72003 | 1533 | |
1338312 | 1338312 | 2021-05-20 | Aguada | Puerto Rico | 72003 | 1531 | |
1335065 | 1335065 | 2021-05-19 | Aguada | Puerto Rico | 72003 | 1530 | |
1331818 | 1331818 | 2021-05-18 | Aguada | Puerto Rico | 72003 | 1530 | |
1328571 | 1328571 | 2021-05-17 | Aguada | Puerto Rico | 72003 | 1528 | |
1325325 | 1325325 | 2021-05-16 | Aguada | Puerto Rico | 72003 | 1527 | |
1322079 | 1322079 | 2021-05-15 | Aguada | Puerto Rico | 72003 | 1526 | |
1318833 | 1318833 | 2021-05-14 | Aguada | Puerto Rico | 72003 | 1523 | |
1315585 | 1315585 | 2021-05-13 | Aguada | Puerto Rico | 72003 | 1522 | |
1312339 | 1312339 | 2021-05-12 | Aguada | Puerto Rico | 72003 | 1520 | |
1309092 | 1309092 | 2021-05-11 | Aguada | Puerto Rico | 72003 | 1519 | |
1305846 | 1305846 | 2021-05-10 | Aguada | Puerto Rico | 72003 | 1517 | |
1302600 | 1302600 | 2021-05-09 | Aguada | Puerto Rico | 72003 | 1515 | |
1299353 | 1299353 | 2021-05-08 | Aguada | Puerto Rico | 72003 | 1510 | |
1296106 | 1296106 | 2021-05-07 | Aguada | Puerto Rico | 72003 | 1508 | |
1292860 | 1292860 | 2021-05-06 | Aguada | Puerto Rico | 72003 | 1506 | |
1289614 | 1289614 | 2021-05-05 | Aguada | Puerto Rico | 72003 | 1506 | |
1286368 | 1286368 | 2021-05-04 | Aguada | Puerto Rico | 72003 | 1506 | |
1283122 | 1283122 | 2021-05-03 | Aguada | Puerto Rico | 72003 | 1504 | |
1279875 | 1279875 | 2021-05-02 | Aguada | Puerto Rico | 72003 | 1458 | |
1276628 | 1276628 | 2021-05-01 | Aguada | Puerto Rico | 72003 | 1456 | |
1273381 | 1273381 | 2021-04-30 | Aguada | Puerto Rico | 72003 | 1452 | |
1270134 | 1270134 | 2021-04-29 | Aguada | Puerto Rico | 72003 | 1446 | |
1266887 | 1266887 | 2021-04-28 | Aguada | Puerto Rico | 72003 | 1445 | |
1263640 | 1263640 | 2021-04-27 | Aguada | Puerto Rico | 72003 | 1445 | |
1260393 | 1260393 | 2021-04-26 | Aguada | Puerto Rico | 72003 | 1436 | |
1257146 | 1257146 | 2021-04-25 | Aguada | Puerto Rico | 72003 | 1431 | |
1253899 | 1253899 | 2021-04-24 | Aguada | Puerto Rico | 72003 | 1427 | |
1250652 | 1250652 | 2021-04-23 | Aguada | Puerto Rico | 72003 | 1412 | |
1247405 | 1247405 | 2021-04-22 | Aguada | Puerto Rico | 72003 | 1403 | |
1244158 | 1244158 | 2021-04-21 | Aguada | Puerto Rico | 72003 | 1398 | |
1240911 | 1240911 | 2021-04-20 | Aguada | Puerto Rico | 72003 | 1396 | |
1237664 | 1237664 | 2021-04-19 | Aguada | Puerto Rico | 72003 | 1383 | |
1234417 | 1234417 | 2021-04-18 | Aguada | Puerto Rico | 72003 | 1376 | |
1231169 | 1231169 | 2021-04-17 | Aguada | Puerto Rico | 72003 | 1370 | |
1227921 | 1227921 | 2021-04-16 | Aguada | Puerto Rico | 72003 | 1357 | |
1224673 | 1224673 | 2021-04-15 | Aguada | Puerto Rico | 72003 | 1347 | |
1221426 | 1221426 | 2021-04-14 | Aguada | Puerto Rico | 72003 | 1345 | |
1218178 | 1218178 | 2021-04-13 | Aguada | Puerto Rico | 72003 | 1342 | |
1214930 | 1214930 | 2021-04-12 | Aguada | Puerto Rico | 72003 | 1332 | |
1211683 | 1211683 | 2021-04-11 | Aguada | Puerto Rico | 72003 | 1327 | |
1208434 | 1208434 | 2021-04-10 | Aguada | Puerto Rico | 72003 | 1312 | |
1205186 | 1205186 | 2021-04-09 | Aguada | Puerto Rico | 72003 | 1297 | |
1201938 | 1201938 | 2021-04-08 | Aguada | Puerto Rico | 72003 | 1290 | |
1198689 | 1198689 | 2021-04-07 | Aguada | Puerto Rico | 72003 | 1287 | |
1195440 | 1195440 | 2021-04-06 | Aguada | Puerto Rico | 72003 | 1287 | |
1192192 | 1192192 | 2021-04-05 | Aguada | Puerto Rico | 72003 | 1287 | |
1188943 | 1188943 | 2021-04-04 | Aguada | Puerto Rico | 72003 | 1285 | |
1185696 | 1185696 | 2021-04-03 | Aguada | Puerto Rico | 72003 | 1277 | |
1182449 | 1182449 | 2021-04-02 | Aguada | Puerto Rico | 72003 | 1266 | |
1179202 | 1179202 | 2021-04-01 | Aguada | Puerto Rico | 72003 | 1264 | |
1175955 | 1175955 | 2021-03-31 | Aguada | Puerto Rico | 72003 | 1262 | |
1172708 | 1172708 | 2021-03-30 | Aguada | Puerto Rico | 72003 | 1262 | |
1169461 | 1169461 | 2021-03-29 | Aguada | Puerto Rico | 72003 | 1259 | |
1166213 | 1166213 | 2021-03-28 | Aguada | Puerto Rico | 72003 | 1254 |
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);