ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "San Lorenzo" 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 |
---|---|---|---|---|---|---|---|
1419523 | 1419523 | 2021-06-14 | San Lorenzo | Puerto Rico | 72129 | 2039 | |
1416278 | 1416278 | 2021-06-13 | San Lorenzo | Puerto Rico | 72129 | 2039 | |
1413032 | 1413032 | 2021-06-12 | San Lorenzo | Puerto Rico | 72129 | 2039 | |
1409787 | 1409787 | 2021-06-11 | San Lorenzo | Puerto Rico | 72129 | 2037 | |
1406542 | 1406542 | 2021-06-10 | San Lorenzo | Puerto Rico | 72129 | 2037 | |
1403296 | 1403296 | 2021-06-09 | San Lorenzo | Puerto Rico | 72129 | 2037 | |
1400051 | 1400051 | 2021-06-08 | San Lorenzo | Puerto Rico | 72129 | 2037 | |
1396806 | 1396806 | 2021-06-07 | San Lorenzo | Puerto Rico | 72129 | 2036 | |
1393559 | 1393559 | 2021-06-06 | San Lorenzo | Puerto Rico | 72129 | 2035 | |
1390314 | 1390314 | 2021-06-05 | San Lorenzo | Puerto Rico | 72129 | 2035 | |
1387069 | 1387069 | 2021-06-04 | San Lorenzo | Puerto Rico | 72129 | 2034 | |
1383824 | 1383824 | 2021-06-03 | San Lorenzo | Puerto Rico | 72129 | 2034 | |
1380578 | 1380578 | 2021-06-02 | San Lorenzo | Puerto Rico | 72129 | 2034 | |
1377333 | 1377333 | 2021-06-01 | San Lorenzo | Puerto Rico | 72129 | 2034 | |
1374087 | 1374087 | 2021-05-31 | San Lorenzo | Puerto Rico | 72129 | 2029 | |
1370842 | 1370842 | 2021-05-30 | San Lorenzo | Puerto Rico | 72129 | 2029 | |
1367596 | 1367596 | 2021-05-29 | San Lorenzo | Puerto Rico | 72129 | 2028 | |
1364350 | 1364350 | 2021-05-28 | San Lorenzo | Puerto Rico | 72129 | 2026 | |
1361104 | 1361104 | 2021-05-27 | San Lorenzo | Puerto Rico | 72129 | 2027 | |
1357858 | 1357858 | 2021-05-26 | San Lorenzo | Puerto Rico | 72129 | 2027 | |
1354612 | 1354612 | 2021-05-25 | San Lorenzo | Puerto Rico | 72129 | 2027 | |
1351366 | 1351366 | 2021-05-24 | San Lorenzo | Puerto Rico | 72129 | 2027 | |
1348120 | 1348120 | 2021-05-23 | San Lorenzo | Puerto Rico | 72129 | 2024 | |
1344872 | 1344872 | 2021-05-22 | San Lorenzo | Puerto Rico | 72129 | 2023 | |
1341624 | 1341624 | 2021-05-21 | San Lorenzo | Puerto Rico | 72129 | 2021 | |
1338376 | 1338376 | 2021-05-20 | San Lorenzo | Puerto Rico | 72129 | 2021 | |
1335129 | 1335129 | 2021-05-19 | San Lorenzo | Puerto Rico | 72129 | 2021 | |
1331882 | 1331882 | 2021-05-18 | San Lorenzo | Puerto Rico | 72129 | 2020 | |
1328635 | 1328635 | 2021-05-17 | San Lorenzo | Puerto Rico | 72129 | 2020 | |
1325389 | 1325389 | 2021-05-16 | San Lorenzo | Puerto Rico | 72129 | 2018 | |
1322143 | 1322143 | 2021-05-15 | San Lorenzo | Puerto Rico | 72129 | 2017 | |
1318897 | 1318897 | 2021-05-14 | San Lorenzo | Puerto Rico | 72129 | 2016 | |
1315649 | 1315649 | 2021-05-13 | San Lorenzo | Puerto Rico | 72129 | 2014 | |
1312403 | 1312403 | 2021-05-12 | San Lorenzo | Puerto Rico | 72129 | 2013 | |
1309156 | 1309156 | 2021-05-11 | San Lorenzo | Puerto Rico | 72129 | 2013 | |
1305910 | 1305910 | 2021-05-10 | San Lorenzo | Puerto Rico | 72129 | 2013 | |
1302664 | 1302664 | 2021-05-09 | San Lorenzo | Puerto Rico | 72129 | 2011 | |
1299417 | 1299417 | 2021-05-08 | San Lorenzo | Puerto Rico | 72129 | 2006 | |
1296170 | 1296170 | 2021-05-07 | San Lorenzo | Puerto Rico | 72129 | 2002 | |
1292924 | 1292924 | 2021-05-06 | San Lorenzo | Puerto Rico | 72129 | 1992 | |
1289678 | 1289678 | 2021-05-05 | San Lorenzo | Puerto Rico | 72129 | 1990 | |
1286432 | 1286432 | 2021-05-04 | San Lorenzo | Puerto Rico | 72129 | 1986 | |
1283186 | 1283186 | 2021-05-03 | San Lorenzo | Puerto Rico | 72129 | 1969 | |
1279939 | 1279939 | 2021-05-02 | San Lorenzo | Puerto Rico | 72129 | 1961 | |
1276692 | 1276692 | 2021-05-01 | San Lorenzo | Puerto Rico | 72129 | 1955 | |
1273445 | 1273445 | 2021-04-30 | San Lorenzo | Puerto Rico | 72129 | 1953 | |
1270198 | 1270198 | 2021-04-29 | San Lorenzo | Puerto Rico | 72129 | 1944 | |
1266951 | 1266951 | 2021-04-28 | San Lorenzo | Puerto Rico | 72129 | 1941 | |
1263704 | 1263704 | 2021-04-27 | San Lorenzo | Puerto Rico | 72129 | 1934 | |
1260457 | 1260457 | 2021-04-26 | San Lorenzo | Puerto Rico | 72129 | 1917 | |
1257210 | 1257210 | 2021-04-25 | San Lorenzo | Puerto Rico | 72129 | 1909 | |
1253963 | 1253963 | 2021-04-24 | San Lorenzo | Puerto Rico | 72129 | 1893 | |
1250716 | 1250716 | 2021-04-23 | San Lorenzo | Puerto Rico | 72129 | 1886 | |
1247469 | 1247469 | 2021-04-22 | San Lorenzo | Puerto Rico | 72129 | 1875 | |
1244222 | 1244222 | 2021-04-21 | San Lorenzo | Puerto Rico | 72129 | 1871 | |
1240975 | 1240975 | 2021-04-20 | San Lorenzo | Puerto Rico | 72129 | 1862 | |
1237728 | 1237728 | 2021-04-19 | San Lorenzo | Puerto Rico | 72129 | 1843 | |
1234481 | 1234481 | 2021-04-18 | San Lorenzo | Puerto Rico | 72129 | 1830 | |
1231233 | 1231233 | 2021-04-17 | San Lorenzo | Puerto Rico | 72129 | 1805 | |
1227985 | 1227985 | 2021-04-16 | San Lorenzo | Puerto Rico | 72129 | 1780 | |
1224737 | 1224737 | 2021-04-15 | San Lorenzo | Puerto Rico | 72129 | 1765 | |
1221490 | 1221490 | 2021-04-14 | San Lorenzo | Puerto Rico | 72129 | 1762 | |
1218242 | 1218242 | 2021-04-13 | San Lorenzo | Puerto Rico | 72129 | 1746 | |
1214994 | 1214994 | 2021-04-12 | San Lorenzo | Puerto Rico | 72129 | 1738 | |
1211747 | 1211747 | 2021-04-11 | San Lorenzo | Puerto Rico | 72129 | 1724 | |
1208498 | 1208498 | 2021-04-10 | San Lorenzo | Puerto Rico | 72129 | 1712 | |
1205250 | 1205250 | 2021-04-09 | San Lorenzo | Puerto Rico | 72129 | 1694 | |
1202002 | 1202002 | 2021-04-08 | San Lorenzo | Puerto Rico | 72129 | 1681 | |
1198753 | 1198753 | 2021-04-07 | San Lorenzo | Puerto Rico | 72129 | 1676 | |
1195504 | 1195504 | 2021-04-06 | San Lorenzo | Puerto Rico | 72129 | 1674 | |
1192256 | 1192256 | 2021-04-05 | San Lorenzo | Puerto Rico | 72129 | 1673 | |
1189007 | 1189007 | 2021-04-04 | San Lorenzo | Puerto Rico | 72129 | 1672 | |
1185760 | 1185760 | 2021-04-03 | San Lorenzo | Puerto Rico | 72129 | 1669 | |
1182513 | 1182513 | 2021-04-02 | San Lorenzo | Puerto Rico | 72129 | 1656 | |
1179266 | 1179266 | 2021-04-01 | San Lorenzo | Puerto Rico | 72129 | 1647 | |
1176019 | 1176019 | 2021-03-31 | San Lorenzo | Puerto Rico | 72129 | 1643 | |
1172772 | 1172772 | 2021-03-30 | San Lorenzo | Puerto Rico | 72129 | 1640 | |
1169525 | 1169525 | 2021-03-29 | San Lorenzo | Puerto Rico | 72129 | 1627 | |
1166277 | 1166277 | 2021-03-28 | San Lorenzo | Puerto Rico | 72129 | 1585 | |
1163029 | 1163029 | 2021-03-27 | San Lorenzo | Puerto Rico | 72129 | 1571 | |
1159780 | 1159780 | 2021-03-26 | San Lorenzo | Puerto Rico | 72129 | 1557 | |
1156533 | 1156533 | 2021-03-25 | San Lorenzo | Puerto Rico | 72129 | 1550 | |
1153286 | 1153286 | 2021-03-24 | San Lorenzo | Puerto Rico | 72129 | 1548 | |
1150039 | 1150039 | 2021-03-23 | San Lorenzo | Puerto Rico | 72129 | 1546 | |
1146792 | 1146792 | 2021-03-22 | San Lorenzo | Puerto Rico | 72129 | 1533 | |
1143545 | 1143545 | 2021-03-21 | San Lorenzo | Puerto Rico | 72129 | 1529 | |
1140298 | 1140298 | 2021-03-20 | San Lorenzo | Puerto Rico | 72129 | 1518 | |
1137052 | 1137052 | 2021-03-19 | San Lorenzo | Puerto Rico | 72129 | 1510 | |
1133806 | 1133806 | 2021-03-18 | San Lorenzo | Puerto Rico | 72129 | 1500 | |
1130558 | 1130558 | 2021-03-17 | San Lorenzo | Puerto Rico | 72129 | 1499 | |
1127311 | 1127311 | 2021-03-16 | San Lorenzo | Puerto Rico | 72129 | 1499 | |
1124065 | 1124065 | 2021-03-15 | San Lorenzo | Puerto Rico | 72129 | 1493 | |
1120819 | 1120819 | 2021-03-14 | San Lorenzo | Puerto Rico | 72129 | 1492 | |
1117572 | 1117572 | 2021-03-13 | San Lorenzo | Puerto Rico | 72129 | 1486 | |
1114325 | 1114325 | 2021-03-12 | San Lorenzo | Puerto Rico | 72129 | 1486 | |
1111079 | 1111079 | 2021-03-11 | San Lorenzo | Puerto Rico | 72129 | 1484 | |
1107833 | 1107833 | 2021-03-10 | San Lorenzo | Puerto Rico | 72129 | 1485 | |
1104587 | 1104587 | 2021-03-09 | San Lorenzo | Puerto Rico | 72129 | 1485 | |
1101341 | 1101341 | 2021-03-08 | San Lorenzo | Puerto Rico | 72129 | 1483 | |
1098095 | 1098095 | 2021-03-07 | San Lorenzo | Puerto Rico | 72129 | 1475 |
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);