ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Lares" 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 |
---|---|---|---|---|---|---|---|
1841730 | 1841730 | 2021-10-22 | Lares | Puerto Rico | 72081 | 1405 | |
1838481 | 1838481 | 2021-10-21 | Lares | Puerto Rico | 72081 | 1405 | |
1835232 | 1835232 | 2021-10-20 | Lares | Puerto Rico | 72081 | 1404 | |
1831983 | 1831983 | 2021-10-19 | Lares | Puerto Rico | 72081 | 1403 | |
1828734 | 1828734 | 2021-10-18 | Lares | Puerto Rico | 72081 | 1403 | |
1825485 | 1825485 | 2021-10-17 | Lares | Puerto Rico | 72081 | 1403 | |
1822236 | 1822236 | 2021-10-16 | Lares | Puerto Rico | 72081 | 1403 | |
1818987 | 1818987 | 2021-10-15 | Lares | Puerto Rico | 72081 | 1403 | |
1815738 | 1815738 | 2021-10-14 | Lares | Puerto Rico | 72081 | 1402 | |
1812490 | 1812490 | 2021-10-13 | Lares | Puerto Rico | 72081 | 1402 | |
1809241 | 1809241 | 2021-10-12 | Lares | Puerto Rico | 72081 | 1402 | |
1805991 | 1805991 | 2021-10-11 | Lares | Puerto Rico | 72081 | 1402 | |
1802741 | 1802741 | 2021-10-10 | Lares | Puerto Rico | 72081 | 1401 | |
1799492 | 1799492 | 2021-10-09 | Lares | Puerto Rico | 72081 | 1401 | |
1796243 | 1796243 | 2021-10-08 | Lares | Puerto Rico | 72081 | 1401 | |
1792994 | 1792994 | 2021-10-07 | Lares | Puerto Rico | 72081 | 1401 | |
1789745 | 1789745 | 2021-10-06 | Lares | Puerto Rico | 72081 | 1400 | |
1786497 | 1786497 | 2021-10-05 | Lares | Puerto Rico | 72081 | 1399 | |
1783248 | 1783248 | 2021-10-04 | Lares | Puerto Rico | 72081 | 1399 | |
1779999 | 1779999 | 2021-10-03 | Lares | Puerto Rico | 72081 | 1397 | |
1776749 | 1776749 | 2021-10-02 | Lares | Puerto Rico | 72081 | 1395 | |
1773499 | 1773499 | 2021-10-01 | Lares | Puerto Rico | 72081 | 1394 | |
1770249 | 1770249 | 2021-09-30 | Lares | Puerto Rico | 72081 | 1394 | |
1767000 | 1767000 | 2021-09-29 | Lares | Puerto Rico | 72081 | 1394 | |
1763751 | 1763751 | 2021-09-28 | Lares | Puerto Rico | 72081 | 1394 | |
1760502 | 1760502 | 2021-09-27 | Lares | Puerto Rico | 72081 | 1394 | |
1757254 | 1757254 | 2021-09-26 | Lares | Puerto Rico | 72081 | 1392 | |
1754006 | 1754006 | 2021-09-25 | Lares | Puerto Rico | 72081 | 1392 | |
1750758 | 1750758 | 2021-09-24 | Lares | Puerto Rico | 72081 | 1389 | |
1747509 | 1747509 | 2021-09-23 | Lares | Puerto Rico | 72081 | 1387 | |
1744259 | 1744259 | 2021-09-22 | Lares | Puerto Rico | 72081 | 1387 | |
1741010 | 1741010 | 2021-09-21 | Lares | Puerto Rico | 72081 | 1385 | |
1737761 | 1737761 | 2021-09-20 | Lares | Puerto Rico | 72081 | 1385 | |
1734511 | 1734511 | 2021-09-19 | Lares | Puerto Rico | 72081 | 1385 | |
1731261 | 1731261 | 2021-09-18 | Lares | Puerto Rico | 72081 | 1380 | |
1728011 | 1728011 | 2021-09-17 | Lares | Puerto Rico | 72081 | 1376 | |
1724762 | 1724762 | 2021-09-16 | Lares | Puerto Rico | 72081 | 1373 | |
1721513 | 1721513 | 2021-09-15 | Lares | Puerto Rico | 72081 | 1366 | |
1718265 | 1718265 | 2021-09-14 | Lares | Puerto Rico | 72081 | 1360 | |
1715017 | 1715017 | 2021-09-13 | Lares | Puerto Rico | 72081 | 1360 | |
1711771 | 1711771 | 2021-09-12 | Lares | Puerto Rico | 72081 | 1359 | |
1708524 | 1708524 | 2021-09-11 | Lares | Puerto Rico | 72081 | 1355 | |
1705277 | 1705277 | 2021-09-10 | Lares | Puerto Rico | 72081 | 1354 | |
1702027 | 1702027 | 2021-09-09 | Lares | Puerto Rico | 72081 | 1348 | |
1698778 | 1698778 | 2021-09-08 | Lares | Puerto Rico | 72081 | 1341 | |
1695530 | 1695530 | 2021-09-07 | Lares | Puerto Rico | 72081 | 1340 | |
1692282 | 1692282 | 2021-09-06 | Lares | Puerto Rico | 72081 | 1340 | |
1689033 | 1689033 | 2021-09-05 | Lares | Puerto Rico | 72081 | 1334 | |
1685783 | 1685783 | 2021-09-04 | Lares | Puerto Rico | 72081 | 1330 | |
1682532 | 1682532 | 2021-09-03 | Lares | Puerto Rico | 72081 | 1326 | |
1679282 | 1679282 | 2021-09-02 | Lares | Puerto Rico | 72081 | 1322 | |
1676034 | 1676034 | 2021-09-01 | Lares | Puerto Rico | 72081 | 1322 | |
1672787 | 1672787 | 2021-08-31 | Lares | Puerto Rico | 72081 | 1306 | |
1669539 | 1669539 | 2021-08-30 | Lares | Puerto Rico | 72081 | 1306 | |
1666292 | 1666292 | 2021-08-29 | Lares | Puerto Rico | 72081 | 1305 | |
1663044 | 1663044 | 2021-08-28 | Lares | Puerto Rico | 72081 | 1304 | |
1659796 | 1659796 | 2021-08-27 | Lares | Puerto Rico | 72081 | 1301 | |
1656547 | 1656547 | 2021-08-26 | Lares | Puerto Rico | 72081 | 1298 | |
1653300 | 1653300 | 2021-08-25 | Lares | Puerto Rico | 72081 | 1296 | |
1650053 | 1650053 | 2021-08-24 | Lares | Puerto Rico | 72081 | 1290 | |
1646804 | 1646804 | 2021-08-23 | Lares | Puerto Rico | 72081 | 1289 | |
1643555 | 1643555 | 2021-08-22 | Lares | Puerto Rico | 72081 | 1283 | |
1640305 | 1640305 | 2021-08-21 | Lares | Puerto Rico | 72081 | 1276 | |
1637055 | 1637055 | 2021-08-20 | Lares | Puerto Rico | 72081 | 1263 | |
1633805 | 1633805 | 2021-08-19 | Lares | Puerto Rico | 72081 | 1252 | |
1630558 | 1630558 | 2021-08-18 | Lares | Puerto Rico | 72081 | 1252 | |
1627311 | 1627311 | 2021-08-17 | Lares | Puerto Rico | 72081 | 1251 | |
1624064 | 1624064 | 2021-08-16 | Lares | Puerto Rico | 72081 | 1251 | |
1620817 | 1620817 | 2021-08-15 | Lares | Puerto Rico | 72081 | 1247 | |
1617569 | 1617569 | 2021-08-14 | Lares | Puerto Rico | 72081 | 1235 | |
1614321 | 1614321 | 2021-08-13 | Lares | Puerto Rico | 72081 | 1227 | |
1611072 | 1611072 | 2021-08-12 | Lares | Puerto Rico | 72081 | 1218 | |
1607824 | 1607824 | 2021-08-11 | Lares | Puerto Rico | 72081 | 1213 | |
1604575 | 1604575 | 2021-08-10 | Lares | Puerto Rico | 72081 | 1208 | |
1601326 | 1601326 | 2021-08-09 | Lares | Puerto Rico | 72081 | 1206 | |
1598078 | 1598078 | 2021-08-08 | Lares | Puerto Rico | 72081 | 1199 | |
1594829 | 1594829 | 2021-08-07 | Lares | Puerto Rico | 72081 | 1187 | |
1591580 | 1591580 | 2021-08-06 | Lares | Puerto Rico | 72081 | 1181 | |
1588331 | 1588331 | 2021-08-05 | Lares | Puerto Rico | 72081 | 1175 | |
1585081 | 1585081 | 2021-08-04 | Lares | Puerto Rico | 72081 | 1171 | |
1581831 | 1581831 | 2021-08-03 | Lares | Puerto Rico | 72081 | 1167 | |
1578582 | 1578582 | 2021-08-02 | Lares | Puerto Rico | 72081 | 1165 | |
1575334 | 1575334 | 2021-08-01 | Lares | Puerto Rico | 72081 | 1165 | |
1572086 | 1572086 | 2021-07-31 | Lares | Puerto Rico | 72081 | 1155 | |
1568838 | 1568838 | 2021-07-30 | Lares | Puerto Rico | 72081 | 1153 | |
1565590 | 1565590 | 2021-07-29 | Lares | Puerto Rico | 72081 | 1149 | |
1562342 | 1562342 | 2021-07-28 | Lares | Puerto Rico | 72081 | 1149 | |
1559094 | 1559094 | 2021-07-27 | Lares | Puerto Rico | 72081 | 1149 | |
1555847 | 1555847 | 2021-07-26 | Lares | Puerto Rico | 72081 | 1149 | |
1552600 | 1552600 | 2021-07-25 | Lares | Puerto Rico | 72081 | 1148 | |
1549353 | 1549353 | 2021-07-24 | Lares | Puerto Rico | 72081 | 1143 | |
1546106 | 1546106 | 2021-07-23 | Lares | Puerto Rico | 72081 | 1140 | |
1542859 | 1542859 | 2021-07-22 | Lares | Puerto Rico | 72081 | 1137 | |
1539611 | 1539611 | 2021-07-21 | Lares | Puerto Rico | 72081 | 1135 | |
1536364 | 1536364 | 2021-07-20 | Lares | Puerto Rico | 72081 | 1135 | |
1533116 | 1533116 | 2021-07-19 | Lares | Puerto Rico | 72081 | 1135 | |
1529869 | 1529869 | 2021-07-18 | Lares | Puerto Rico | 72081 | 1134 | |
1526622 | 1526622 | 2021-07-17 | Lares | Puerto Rico | 72081 | 1134 | |
1523375 | 1523375 | 2021-07-16 | Lares | Puerto Rico | 72081 | 1134 | |
1520127 | 1520127 | 2021-07-15 | Lares | Puerto Rico | 72081 | 1134 |
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);