ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72089 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 |
---|---|---|---|---|---|---|---|
1841734 | 1841734 | 2021-10-22 | Luquillo | Puerto Rico | 72089 | 1245 | |
1838485 | 1838485 | 2021-10-21 | Luquillo | Puerto Rico | 72089 | 1245 | |
1835236 | 1835236 | 2021-10-20 | Luquillo | Puerto Rico | 72089 | 1244 | |
1831987 | 1831987 | 2021-10-19 | Luquillo | Puerto Rico | 72089 | 1242 | |
1828738 | 1828738 | 2021-10-18 | Luquillo | Puerto Rico | 72089 | 1242 | |
1825489 | 1825489 | 2021-10-17 | Luquillo | Puerto Rico | 72089 | 1241 | |
1822240 | 1822240 | 2021-10-16 | Luquillo | Puerto Rico | 72089 | 1241 | |
1818991 | 1818991 | 2021-10-15 | Luquillo | Puerto Rico | 72089 | 1241 | |
1815742 | 1815742 | 2021-10-14 | Luquillo | Puerto Rico | 72089 | 1241 | |
1812494 | 1812494 | 2021-10-13 | Luquillo | Puerto Rico | 72089 | 1240 | |
1809245 | 1809245 | 2021-10-12 | Luquillo | Puerto Rico | 72089 | 1238 | |
1805995 | 1805995 | 2021-10-11 | Luquillo | Puerto Rico | 72089 | 1238 | |
1802745 | 1802745 | 2021-10-10 | Luquillo | Puerto Rico | 72089 | 1235 | |
1799496 | 1799496 | 2021-10-09 | Luquillo | Puerto Rico | 72089 | 1235 | |
1796247 | 1796247 | 2021-10-08 | Luquillo | Puerto Rico | 72089 | 1230 | |
1792998 | 1792998 | 2021-10-07 | Luquillo | Puerto Rico | 72089 | 1227 | |
1789749 | 1789749 | 2021-10-06 | Luquillo | Puerto Rico | 72089 | 1227 | |
1786501 | 1786501 | 2021-10-05 | Luquillo | Puerto Rico | 72089 | 1226 | |
1783252 | 1783252 | 2021-10-04 | Luquillo | Puerto Rico | 72089 | 1226 | |
1780003 | 1780003 | 2021-10-03 | Luquillo | Puerto Rico | 72089 | 1224 | |
1776753 | 1776753 | 2021-10-02 | Luquillo | Puerto Rico | 72089 | 1222 | |
1773503 | 1773503 | 2021-10-01 | Luquillo | Puerto Rico | 72089 | 1220 | |
1770253 | 1770253 | 2021-09-30 | Luquillo | Puerto Rico | 72089 | 1218 | |
1767004 | 1767004 | 2021-09-29 | Luquillo | Puerto Rico | 72089 | 1218 | |
1763755 | 1763755 | 2021-09-28 | Luquillo | Puerto Rico | 72089 | 1215 | |
1760506 | 1760506 | 2021-09-27 | Luquillo | Puerto Rico | 72089 | 1215 | |
1757258 | 1757258 | 2021-09-26 | Luquillo | Puerto Rico | 72089 | 1214 | |
1754010 | 1754010 | 2021-09-25 | Luquillo | Puerto Rico | 72089 | 1212 | |
1750762 | 1750762 | 2021-09-24 | Luquillo | Puerto Rico | 72089 | 1212 | |
1747513 | 1747513 | 2021-09-23 | Luquillo | Puerto Rico | 72089 | 1211 | |
1744263 | 1744263 | 2021-09-22 | Luquillo | Puerto Rico | 72089 | 1209 | |
1741014 | 1741014 | 2021-09-21 | Luquillo | Puerto Rico | 72089 | 1207 | |
1737765 | 1737765 | 2021-09-20 | Luquillo | Puerto Rico | 72089 | 1207 | |
1734515 | 1734515 | 2021-09-19 | Luquillo | Puerto Rico | 72089 | 1206 | |
1731265 | 1731265 | 2021-09-18 | Luquillo | Puerto Rico | 72089 | 1206 | |
1728015 | 1728015 | 2021-09-17 | Luquillo | Puerto Rico | 72089 | 1205 | |
1724766 | 1724766 | 2021-09-16 | Luquillo | Puerto Rico | 72089 | 1204 | |
1721517 | 1721517 | 2021-09-15 | Luquillo | Puerto Rico | 72089 | 1201 | |
1718269 | 1718269 | 2021-09-14 | Luquillo | Puerto Rico | 72089 | 1201 | |
1715021 | 1715021 | 2021-09-13 | Luquillo | Puerto Rico | 72089 | 1200 | |
1711775 | 1711775 | 2021-09-12 | Luquillo | Puerto Rico | 72089 | 1196 | |
1708528 | 1708528 | 2021-09-11 | Luquillo | Puerto Rico | 72089 | 1195 | |
1705281 | 1705281 | 2021-09-10 | Luquillo | Puerto Rico | 72089 | 1183 | |
1702031 | 1702031 | 2021-09-09 | Luquillo | Puerto Rico | 72089 | 1181 | |
1698782 | 1698782 | 2021-09-08 | Luquillo | Puerto Rico | 72089 | 1177 | |
1695534 | 1695534 | 2021-09-07 | Luquillo | Puerto Rico | 72089 | 1177 | |
1692286 | 1692286 | 2021-09-06 | Luquillo | Puerto Rico | 72089 | 1177 | |
1689037 | 1689037 | 2021-09-05 | Luquillo | Puerto Rico | 72089 | 1173 | |
1685787 | 1685787 | 2021-09-04 | Luquillo | Puerto Rico | 72089 | 1163 | |
1682536 | 1682536 | 2021-09-03 | Luquillo | Puerto Rico | 72089 | 1157 | |
1679286 | 1679286 | 2021-09-02 | Luquillo | Puerto Rico | 72089 | 1155 | |
1676038 | 1676038 | 2021-09-01 | Luquillo | Puerto Rico | 72089 | 1152 | |
1672791 | 1672791 | 2021-08-31 | Luquillo | Puerto Rico | 72089 | 1142 | |
1669543 | 1669543 | 2021-08-30 | Luquillo | Puerto Rico | 72089 | 1138 | |
1666296 | 1666296 | 2021-08-29 | Luquillo | Puerto Rico | 72089 | 1130 | |
1663048 | 1663048 | 2021-08-28 | Luquillo | Puerto Rico | 72089 | 1128 | |
1659800 | 1659800 | 2021-08-27 | Luquillo | Puerto Rico | 72089 | 1115 | |
1656551 | 1656551 | 2021-08-26 | Luquillo | Puerto Rico | 72089 | 1103 | |
1653304 | 1653304 | 2021-08-25 | Luquillo | Puerto Rico | 72089 | 1086 | |
1650057 | 1650057 | 2021-08-24 | Luquillo | Puerto Rico | 72089 | 1085 | |
1646808 | 1646808 | 2021-08-23 | Luquillo | Puerto Rico | 72089 | 1083 | |
1643559 | 1643559 | 2021-08-22 | Luquillo | Puerto Rico | 72089 | 1082 | |
1640309 | 1640309 | 2021-08-21 | Luquillo | Puerto Rico | 72089 | 1078 | |
1637059 | 1637059 | 2021-08-20 | Luquillo | Puerto Rico | 72089 | 1069 | |
1633809 | 1633809 | 2021-08-19 | Luquillo | Puerto Rico | 72089 | 1056 | |
1630562 | 1630562 | 2021-08-18 | Luquillo | Puerto Rico | 72089 | 1053 | |
1627315 | 1627315 | 2021-08-17 | Luquillo | Puerto Rico | 72089 | 1050 | |
1624068 | 1624068 | 2021-08-16 | Luquillo | Puerto Rico | 72089 | 1050 | |
1620821 | 1620821 | 2021-08-15 | Luquillo | Puerto Rico | 72089 | 1046 | |
1617573 | 1617573 | 2021-08-14 | Luquillo | Puerto Rico | 72089 | 1036 | |
1614325 | 1614325 | 2021-08-13 | Luquillo | Puerto Rico | 72089 | 1023 | |
1611076 | 1611076 | 2021-08-12 | Luquillo | Puerto Rico | 72089 | 1016 | |
1607828 | 1607828 | 2021-08-11 | Luquillo | Puerto Rico | 72089 | 1012 | |
1604579 | 1604579 | 2021-08-10 | Luquillo | Puerto Rico | 72089 | 1006 | |
1601330 | 1601330 | 2021-08-09 | Luquillo | Puerto Rico | 72089 | 1006 | |
1598082 | 1598082 | 2021-08-08 | Luquillo | Puerto Rico | 72089 | 999 | |
1594833 | 1594833 | 2021-08-07 | Luquillo | Puerto Rico | 72089 | 992 | |
1591584 | 1591584 | 2021-08-06 | Luquillo | Puerto Rico | 72089 | 989 | |
1588335 | 1588335 | 2021-08-05 | Luquillo | Puerto Rico | 72089 | 986 | |
1585085 | 1585085 | 2021-08-04 | Luquillo | Puerto Rico | 72089 | 980 | |
1581835 | 1581835 | 2021-08-03 | Luquillo | Puerto Rico | 72089 | 977 | |
1578586 | 1578586 | 2021-08-02 | Luquillo | Puerto Rico | 72089 | 976 | |
1575338 | 1575338 | 2021-08-01 | Luquillo | Puerto Rico | 72089 | 973 | |
1572090 | 1572090 | 2021-07-31 | Luquillo | Puerto Rico | 72089 | 967 | |
1568842 | 1568842 | 2021-07-30 | Luquillo | Puerto Rico | 72089 | 962 | |
1565594 | 1565594 | 2021-07-29 | Luquillo | Puerto Rico | 72089 | 960 | |
1562346 | 1562346 | 2021-07-28 | Luquillo | Puerto Rico | 72089 | 960 | |
1559098 | 1559098 | 2021-07-27 | Luquillo | Puerto Rico | 72089 | 958 | |
1555851 | 1555851 | 2021-07-26 | Luquillo | Puerto Rico | 72089 | 958 | |
1552604 | 1552604 | 2021-07-25 | Luquillo | Puerto Rico | 72089 | 958 | |
1549357 | 1549357 | 2021-07-24 | Luquillo | Puerto Rico | 72089 | 953 | |
1546110 | 1546110 | 2021-07-23 | Luquillo | Puerto Rico | 72089 | 951 | |
1542863 | 1542863 | 2021-07-22 | Luquillo | Puerto Rico | 72089 | 946 | |
1539615 | 1539615 | 2021-07-21 | Luquillo | Puerto Rico | 72089 | 945 | |
1536368 | 1536368 | 2021-07-20 | Luquillo | Puerto Rico | 72089 | 945 | |
1533120 | 1533120 | 2021-07-19 | Luquillo | Puerto Rico | 72089 | 944 | |
1529873 | 1529873 | 2021-07-18 | Luquillo | Puerto Rico | 72089 | 942 | |
1526626 | 1526626 | 2021-07-17 | Luquillo | Puerto Rico | 72089 | 940 | |
1523379 | 1523379 | 2021-07-16 | Luquillo | Puerto Rico | 72089 | 939 | |
1520131 | 1520131 | 2021-07-15 | Luquillo | Puerto Rico | 72089 | 936 |
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);