ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Coamo" 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 |
---|---|---|---|---|---|---|---|
1812470 | 1812470 | 2021-10-13 | Coamo | Puerto Rico | 72043 | 1406 | |
1809221 | 1809221 | 2021-10-12 | Coamo | Puerto Rico | 72043 | 1405 | |
1805971 | 1805971 | 2021-10-11 | Coamo | Puerto Rico | 72043 | 1405 | |
1802721 | 1802721 | 2021-10-10 | Coamo | Puerto Rico | 72043 | 1405 | |
1799472 | 1799472 | 2021-10-09 | Coamo | Puerto Rico | 72043 | 1405 | |
1796223 | 1796223 | 2021-10-08 | Coamo | Puerto Rico | 72043 | 1403 | |
1792974 | 1792974 | 2021-10-07 | Coamo | Puerto Rico | 72043 | 1403 | |
1789725 | 1789725 | 2021-10-06 | Coamo | Puerto Rico | 72043 | 1403 | |
1786477 | 1786477 | 2021-10-05 | Coamo | Puerto Rico | 72043 | 1403 | |
1783228 | 1783228 | 2021-10-04 | Coamo | Puerto Rico | 72043 | 1403 | |
1779979 | 1779979 | 2021-10-03 | Coamo | Puerto Rico | 72043 | 1403 | |
1776729 | 1776729 | 2021-10-02 | Coamo | Puerto Rico | 72043 | 1403 | |
1773479 | 1773479 | 2021-10-01 | Coamo | Puerto Rico | 72043 | 1403 | |
1770229 | 1770229 | 2021-09-30 | Coamo | Puerto Rico | 72043 | 1401 | |
1766980 | 1766980 | 2021-09-29 | Coamo | Puerto Rico | 72043 | 1401 | |
1763731 | 1763731 | 2021-09-28 | Coamo | Puerto Rico | 72043 | 1400 | |
1760482 | 1760482 | 2021-09-27 | Coamo | Puerto Rico | 72043 | 1400 | |
1757234 | 1757234 | 2021-09-26 | Coamo | Puerto Rico | 72043 | 1400 | |
1753986 | 1753986 | 2021-09-25 | Coamo | Puerto Rico | 72043 | 1399 | |
1750738 | 1750738 | 2021-09-24 | Coamo | Puerto Rico | 72043 | 1397 | |
1747489 | 1747489 | 2021-09-23 | Coamo | Puerto Rico | 72043 | 1397 | |
1744239 | 1744239 | 2021-09-22 | Coamo | Puerto Rico | 72043 | 1397 | |
1740990 | 1740990 | 2021-09-21 | Coamo | Puerto Rico | 72043 | 1396 | |
1737741 | 1737741 | 2021-09-20 | Coamo | Puerto Rico | 72043 | 1396 | |
1734491 | 1734491 | 2021-09-19 | Coamo | Puerto Rico | 72043 | 1395 | |
1731241 | 1731241 | 2021-09-18 | Coamo | Puerto Rico | 72043 | 1392 | |
1727991 | 1727991 | 2021-09-17 | Coamo | Puerto Rico | 72043 | 1390 | |
1724742 | 1724742 | 2021-09-16 | Coamo | Puerto Rico | 72043 | 1389 | |
1721493 | 1721493 | 2021-09-15 | Coamo | Puerto Rico | 72043 | 1388 | |
1718245 | 1718245 | 2021-09-14 | Coamo | Puerto Rico | 72043 | 1388 | |
1714997 | 1714997 | 2021-09-13 | Coamo | Puerto Rico | 72043 | 1387 | |
1711751 | 1711751 | 2021-09-12 | Coamo | Puerto Rico | 72043 | 1385 | |
1708504 | 1708504 | 2021-09-11 | Coamo | Puerto Rico | 72043 | 1376 | |
1705257 | 1705257 | 2021-09-10 | Coamo | Puerto Rico | 72043 | 1375 | |
1702007 | 1702007 | 2021-09-09 | Coamo | Puerto Rico | 72043 | 1369 | |
1698758 | 1698758 | 2021-09-08 | Coamo | Puerto Rico | 72043 | 1367 | |
1695510 | 1695510 | 2021-09-07 | Coamo | Puerto Rico | 72043 | 1362 | |
1692262 | 1692262 | 2021-09-06 | Coamo | Puerto Rico | 72043 | 1360 | |
1689013 | 1689013 | 2021-09-05 | Coamo | Puerto Rico | 72043 | 1356 | |
1685763 | 1685763 | 2021-09-04 | Coamo | Puerto Rico | 72043 | 1344 | |
1682512 | 1682512 | 2021-09-03 | Coamo | Puerto Rico | 72043 | 1339 | |
1679262 | 1679262 | 2021-09-02 | Coamo | Puerto Rico | 72043 | 1331 | |
1676014 | 1676014 | 2021-09-01 | Coamo | Puerto Rico | 72043 | 1326 | |
1672767 | 1672767 | 2021-08-31 | Coamo | Puerto Rico | 72043 | 1315 | |
1669519 | 1669519 | 2021-08-30 | Coamo | Puerto Rico | 72043 | 1313 | |
1666272 | 1666272 | 2021-08-29 | Coamo | Puerto Rico | 72043 | 1313 | |
1663024 | 1663024 | 2021-08-28 | Coamo | Puerto Rico | 72043 | 1309 | |
1659776 | 1659776 | 2021-08-27 | Coamo | Puerto Rico | 72043 | 1307 | |
1656527 | 1656527 | 2021-08-26 | Coamo | Puerto Rico | 72043 | 1303 | |
1653280 | 1653280 | 2021-08-25 | Coamo | Puerto Rico | 72043 | 1298 | |
1650033 | 1650033 | 2021-08-24 | Coamo | Puerto Rico | 72043 | 1288 | |
1646784 | 1646784 | 2021-08-23 | Coamo | Puerto Rico | 72043 | 1287 | |
1643535 | 1643535 | 2021-08-22 | Coamo | Puerto Rico | 72043 | 1285 | |
1640285 | 1640285 | 2021-08-21 | Coamo | Puerto Rico | 72043 | 1278 | |
1637035 | 1637035 | 2021-08-20 | Coamo | Puerto Rico | 72043 | 1268 | |
1633785 | 1633785 | 2021-08-19 | Coamo | Puerto Rico | 72043 | 1265 | |
1630538 | 1630538 | 2021-08-18 | Coamo | Puerto Rico | 72043 | 1265 | |
1627291 | 1627291 | 2021-08-17 | Coamo | Puerto Rico | 72043 | 1263 | |
1624044 | 1624044 | 2021-08-16 | Coamo | Puerto Rico | 72043 | 1253 | |
1620797 | 1620797 | 2021-08-15 | Coamo | Puerto Rico | 72043 | 1251 | |
1617549 | 1617549 | 2021-08-14 | Coamo | Puerto Rico | 72043 | 1239 | |
1614301 | 1614301 | 2021-08-13 | Coamo | Puerto Rico | 72043 | 1234 | |
1611052 | 1611052 | 2021-08-12 | Coamo | Puerto Rico | 72043 | 1229 | |
1607804 | 1607804 | 2021-08-11 | Coamo | Puerto Rico | 72043 | 1227 | |
1604555 | 1604555 | 2021-08-10 | Coamo | Puerto Rico | 72043 | 1226 | |
1601306 | 1601306 | 2021-08-09 | Coamo | Puerto Rico | 72043 | 1226 | |
1598058 | 1598058 | 2021-08-08 | Coamo | Puerto Rico | 72043 | 1223 | |
1594809 | 1594809 | 2021-08-07 | Coamo | Puerto Rico | 72043 | 1219 | |
1591560 | 1591560 | 2021-08-06 | Coamo | Puerto Rico | 72043 | 1218 | |
1588311 | 1588311 | 2021-08-05 | Coamo | Puerto Rico | 72043 | 1214 | |
1585061 | 1585061 | 2021-08-04 | Coamo | Puerto Rico | 72043 | 1212 | |
1581811 | 1581811 | 2021-08-03 | Coamo | Puerto Rico | 72043 | 1208 | |
1578562 | 1578562 | 2021-08-02 | Coamo | Puerto Rico | 72043 | 1208 | |
1575314 | 1575314 | 2021-08-01 | Coamo | Puerto Rico | 72043 | 1208 | |
1572066 | 1572066 | 2021-07-31 | Coamo | Puerto Rico | 72043 | 1202 | |
1568818 | 1568818 | 2021-07-30 | Coamo | Puerto Rico | 72043 | 1197 | |
1565570 | 1565570 | 2021-07-29 | Coamo | Puerto Rico | 72043 | 1187 | |
1562322 | 1562322 | 2021-07-28 | Coamo | Puerto Rico | 72043 | 1187 | |
1559074 | 1559074 | 2021-07-27 | Coamo | Puerto Rico | 72043 | 1187 | |
1555827 | 1555827 | 2021-07-26 | Coamo | Puerto Rico | 72043 | 1187 | |
1552580 | 1552580 | 2021-07-25 | Coamo | Puerto Rico | 72043 | 1185 | |
1549333 | 1549333 | 2021-07-24 | Coamo | Puerto Rico | 72043 | 1183 | |
1546086 | 1546086 | 2021-07-23 | Coamo | Puerto Rico | 72043 | 1183 | |
1542839 | 1542839 | 2021-07-22 | Coamo | Puerto Rico | 72043 | 1180 | |
1539591 | 1539591 | 2021-07-21 | Coamo | Puerto Rico | 72043 | 1179 | |
1536344 | 1536344 | 2021-07-20 | Coamo | Puerto Rico | 72043 | 1179 | |
1533096 | 1533096 | 2021-07-19 | Coamo | Puerto Rico | 72043 | 1178 | |
1529849 | 1529849 | 2021-07-18 | Coamo | Puerto Rico | 72043 | 1178 | |
1526602 | 1526602 | 2021-07-17 | Coamo | Puerto Rico | 72043 | 1177 | |
1523355 | 1523355 | 2021-07-16 | Coamo | Puerto Rico | 72043 | 1177 | |
1520107 | 1520107 | 2021-07-15 | Coamo | Puerto Rico | 72043 | 1176 | |
1516859 | 1516859 | 2021-07-14 | Coamo | Puerto Rico | 72043 | 1175 | |
1513612 | 1513612 | 2021-07-13 | Coamo | Puerto Rico | 72043 | 1174 | |
1510366 | 1510366 | 2021-07-12 | Coamo | Puerto Rico | 72043 | 1174 | |
1507119 | 1507119 | 2021-07-11 | Coamo | Puerto Rico | 72043 | 1174 | |
1503873 | 1503873 | 2021-07-10 | Coamo | Puerto Rico | 72043 | 1174 | |
1500627 | 1500627 | 2021-07-09 | Coamo | Puerto Rico | 72043 | 1174 | |
1497381 | 1497381 | 2021-07-08 | Coamo | Puerto Rico | 72043 | 1175 | |
1494134 | 1494134 | 2021-07-07 | Coamo | Puerto Rico | 72043 | 1175 | |
1490887 | 1490887 | 2021-07-06 | Coamo | Puerto Rico | 72043 | 1175 |
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);