ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Cayey" 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 |
---|---|---|---|---|---|---|---|
1419475 | 1419475 | 2021-06-14 | Cayey | Puerto Rico | 72035 | 1632 | |
1416230 | 1416230 | 2021-06-13 | Cayey | Puerto Rico | 72035 | 1632 | |
1412984 | 1412984 | 2021-06-12 | Cayey | Puerto Rico | 72035 | 1632 | |
1409739 | 1409739 | 2021-06-11 | Cayey | Puerto Rico | 72035 | 1632 | |
1406494 | 1406494 | 2021-06-10 | Cayey | Puerto Rico | 72035 | 1632 | |
1403248 | 1403248 | 2021-06-09 | Cayey | Puerto Rico | 72035 | 1632 | |
1400003 | 1400003 | 2021-06-08 | Cayey | Puerto Rico | 72035 | 1632 | |
1396758 | 1396758 | 2021-06-07 | Cayey | Puerto Rico | 72035 | 1632 | |
1393511 | 1393511 | 2021-06-06 | Cayey | Puerto Rico | 72035 | 1632 | |
1390266 | 1390266 | 2021-06-05 | Cayey | Puerto Rico | 72035 | 1632 | |
1387021 | 1387021 | 2021-06-04 | Cayey | Puerto Rico | 72035 | 1630 | |
1383776 | 1383776 | 2021-06-03 | Cayey | Puerto Rico | 72035 | 1629 | |
1380530 | 1380530 | 2021-06-02 | Cayey | Puerto Rico | 72035 | 1629 | |
1377285 | 1377285 | 2021-06-01 | Cayey | Puerto Rico | 72035 | 1629 | |
1374039 | 1374039 | 2021-05-31 | Cayey | Puerto Rico | 72035 | 1629 | |
1370794 | 1370794 | 2021-05-30 | Cayey | Puerto Rico | 72035 | 1628 | |
1367548 | 1367548 | 2021-05-29 | Cayey | Puerto Rico | 72035 | 1628 | |
1364302 | 1364302 | 2021-05-28 | Cayey | Puerto Rico | 72035 | 1627 | |
1361056 | 1361056 | 2021-05-27 | Cayey | Puerto Rico | 72035 | 1626 | |
1357810 | 1357810 | 2021-05-26 | Cayey | Puerto Rico | 72035 | 1623 | |
1354564 | 1354564 | 2021-05-25 | Cayey | Puerto Rico | 72035 | 1623 | |
1351318 | 1351318 | 2021-05-24 | Cayey | Puerto Rico | 72035 | 1622 | |
1348072 | 1348072 | 2021-05-23 | Cayey | Puerto Rico | 72035 | 1619 | |
1344824 | 1344824 | 2021-05-22 | Cayey | Puerto Rico | 72035 | 1616 | |
1341576 | 1341576 | 2021-05-21 | Cayey | Puerto Rico | 72035 | 1614 | |
1338328 | 1338328 | 2021-05-20 | Cayey | Puerto Rico | 72035 | 1606 | |
1335081 | 1335081 | 2021-05-19 | Cayey | Puerto Rico | 72035 | 1603 | |
1331834 | 1331834 | 2021-05-18 | Cayey | Puerto Rico | 72035 | 1603 | |
1328587 | 1328587 | 2021-05-17 | Cayey | Puerto Rico | 72035 | 1603 | |
1325341 | 1325341 | 2021-05-16 | Cayey | Puerto Rico | 72035 | 1602 | |
1322095 | 1322095 | 2021-05-15 | Cayey | Puerto Rico | 72035 | 1599 | |
1318849 | 1318849 | 2021-05-14 | Cayey | Puerto Rico | 72035 | 1597 | |
1315601 | 1315601 | 2021-05-13 | Cayey | Puerto Rico | 72035 | 1596 | |
1312355 | 1312355 | 2021-05-12 | Cayey | Puerto Rico | 72035 | 1596 | |
1309108 | 1309108 | 2021-05-11 | Cayey | Puerto Rico | 72035 | 1596 | |
1305862 | 1305862 | 2021-05-10 | Cayey | Puerto Rico | 72035 | 1595 | |
1302616 | 1302616 | 2021-05-09 | Cayey | Puerto Rico | 72035 | 1593 | |
1299369 | 1299369 | 2021-05-08 | Cayey | Puerto Rico | 72035 | 1592 | |
1296122 | 1296122 | 2021-05-07 | Cayey | Puerto Rico | 72035 | 1586 | |
1292876 | 1292876 | 2021-05-06 | Cayey | Puerto Rico | 72035 | 1580 | |
1289630 | 1289630 | 2021-05-05 | Cayey | Puerto Rico | 72035 | 1576 | |
1286384 | 1286384 | 2021-05-04 | Cayey | Puerto Rico | 72035 | 1576 | |
1283138 | 1283138 | 2021-05-03 | Cayey | Puerto Rico | 72035 | 1574 | |
1279891 | 1279891 | 2021-05-02 | Cayey | Puerto Rico | 72035 | 1571 | |
1276644 | 1276644 | 2021-05-01 | Cayey | Puerto Rico | 72035 | 1567 | |
1273397 | 1273397 | 2021-04-30 | Cayey | Puerto Rico | 72035 | 1560 | |
1270150 | 1270150 | 2021-04-29 | Cayey | Puerto Rico | 72035 | 1557 | |
1266903 | 1266903 | 2021-04-28 | Cayey | Puerto Rico | 72035 | 1551 | |
1263656 | 1263656 | 2021-04-27 | Cayey | Puerto Rico | 72035 | 1550 | |
1260409 | 1260409 | 2021-04-26 | Cayey | Puerto Rico | 72035 | 1534 | |
1257162 | 1257162 | 2021-04-25 | Cayey | Puerto Rico | 72035 | 1530 | |
1253915 | 1253915 | 2021-04-24 | Cayey | Puerto Rico | 72035 | 1517 | |
1250668 | 1250668 | 2021-04-23 | Cayey | Puerto Rico | 72035 | 1512 | |
1247421 | 1247421 | 2021-04-22 | Cayey | Puerto Rico | 72035 | 1501 | |
1244174 | 1244174 | 2021-04-21 | Cayey | Puerto Rico | 72035 | 1498 | |
1240927 | 1240927 | 2021-04-20 | Cayey | Puerto Rico | 72035 | 1496 | |
1237680 | 1237680 | 2021-04-19 | Cayey | Puerto Rico | 72035 | 1493 | |
1234433 | 1234433 | 2021-04-18 | Cayey | Puerto Rico | 72035 | 1486 | |
1231185 | 1231185 | 2021-04-17 | Cayey | Puerto Rico | 72035 | 1479 | |
1227937 | 1227937 | 2021-04-16 | Cayey | Puerto Rico | 72035 | 1468 | |
1224689 | 1224689 | 2021-04-15 | Cayey | Puerto Rico | 72035 | 1459 | |
1221442 | 1221442 | 2021-04-14 | Cayey | Puerto Rico | 72035 | 1453 | |
1218194 | 1218194 | 2021-04-13 | Cayey | Puerto Rico | 72035 | 1450 | |
1214946 | 1214946 | 2021-04-12 | Cayey | Puerto Rico | 72035 | 1443 | |
1211699 | 1211699 | 2021-04-11 | Cayey | Puerto Rico | 72035 | 1441 | |
1208450 | 1208450 | 2021-04-10 | Cayey | Puerto Rico | 72035 | 1433 | |
1205202 | 1205202 | 2021-04-09 | Cayey | Puerto Rico | 72035 | 1423 | |
1201954 | 1201954 | 2021-04-08 | Cayey | Puerto Rico | 72035 | 1418 | |
1198705 | 1198705 | 2021-04-07 | Cayey | Puerto Rico | 72035 | 1412 | |
1195456 | 1195456 | 2021-04-06 | Cayey | Puerto Rico | 72035 | 1412 | |
1192208 | 1192208 | 2021-04-05 | Cayey | Puerto Rico | 72035 | 1404 | |
1188959 | 1188959 | 2021-04-04 | Cayey | Puerto Rico | 72035 | 1402 | |
1185712 | 1185712 | 2021-04-03 | Cayey | Puerto Rico | 72035 | 1396 | |
1182465 | 1182465 | 2021-04-02 | Cayey | Puerto Rico | 72035 | 1384 | |
1179218 | 1179218 | 2021-04-01 | Cayey | Puerto Rico | 72035 | 1375 | |
1175971 | 1175971 | 2021-03-31 | Cayey | Puerto Rico | 72035 | 1375 | |
1172724 | 1172724 | 2021-03-30 | Cayey | Puerto Rico | 72035 | 1375 | |
1169477 | 1169477 | 2021-03-29 | Cayey | Puerto Rico | 72035 | 1371 | |
1166229 | 1166229 | 2021-03-28 | Cayey | Puerto Rico | 72035 | 1354 | |
1162981 | 1162981 | 2021-03-27 | Cayey | Puerto Rico | 72035 | 1351 | |
1159732 | 1159732 | 2021-03-26 | Cayey | Puerto Rico | 72035 | 1346 | |
1156485 | 1156485 | 2021-03-25 | Cayey | Puerto Rico | 72035 | 1343 | |
1153238 | 1153238 | 2021-03-24 | Cayey | Puerto Rico | 72035 | 1342 | |
1149991 | 1149991 | 2021-03-23 | Cayey | Puerto Rico | 72035 | 1340 | |
1146744 | 1146744 | 2021-03-22 | Cayey | Puerto Rico | 72035 | 1340 | |
1143497 | 1143497 | 2021-03-21 | Cayey | Puerto Rico | 72035 | 1338 | |
1140250 | 1140250 | 2021-03-20 | Cayey | Puerto Rico | 72035 | 1333 | |
1137004 | 1137004 | 2021-03-19 | Cayey | Puerto Rico | 72035 | 1323 | |
1133758 | 1133758 | 2021-03-18 | Cayey | Puerto Rico | 72035 | 1320 | |
1130510 | 1130510 | 2021-03-17 | Cayey | Puerto Rico | 72035 | 1319 | |
1127263 | 1127263 | 2021-03-16 | Cayey | Puerto Rico | 72035 | 1319 | |
1124017 | 1124017 | 2021-03-15 | Cayey | Puerto Rico | 72035 | 1317 | |
1120771 | 1120771 | 2021-03-14 | Cayey | Puerto Rico | 72035 | 1315 | |
1117524 | 1117524 | 2021-03-13 | Cayey | Puerto Rico | 72035 | 1314 | |
1114277 | 1114277 | 2021-03-12 | Cayey | Puerto Rico | 72035 | 1312 | |
1111031 | 1111031 | 2021-03-11 | Cayey | Puerto Rico | 72035 | 1311 | |
1107785 | 1107785 | 2021-03-10 | Cayey | Puerto Rico | 72035 | 1309 | |
1104539 | 1104539 | 2021-03-09 | Cayey | Puerto Rico | 72035 | 1309 | |
1101293 | 1101293 | 2021-03-08 | Cayey | Puerto Rico | 72035 | 1308 | |
1098047 | 1098047 | 2021-03-07 | Cayey | Puerto Rico | 72035 | 1304 |
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);