ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Guayama" 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 |
---|---|---|---|---|---|---|---|
1841718 | 1841718 | 2021-10-22 | Guayama | Puerto Rico | 72057 | 1348 | |
1838469 | 1838469 | 2021-10-21 | Guayama | Puerto Rico | 72057 | 1348 | |
1835220 | 1835220 | 2021-10-20 | Guayama | Puerto Rico | 72057 | 1348 | |
1831971 | 1831971 | 2021-10-19 | Guayama | Puerto Rico | 72057 | 1348 | |
1828722 | 1828722 | 2021-10-18 | Guayama | Puerto Rico | 72057 | 1348 | |
1825473 | 1825473 | 2021-10-17 | Guayama | Puerto Rico | 72057 | 1348 | |
1822224 | 1822224 | 2021-10-16 | Guayama | Puerto Rico | 72057 | 1348 | |
1818975 | 1818975 | 2021-10-15 | Guayama | Puerto Rico | 72057 | 1349 | |
1815726 | 1815726 | 2021-10-14 | Guayama | Puerto Rico | 72057 | 1348 | |
1812478 | 1812478 | 2021-10-13 | Guayama | Puerto Rico | 72057 | 1348 | |
1809229 | 1809229 | 2021-10-12 | Guayama | Puerto Rico | 72057 | 1348 | |
1805979 | 1805979 | 2021-10-11 | Guayama | Puerto Rico | 72057 | 1347 | |
1802729 | 1802729 | 2021-10-10 | Guayama | Puerto Rico | 72057 | 1346 | |
1799480 | 1799480 | 2021-10-09 | Guayama | Puerto Rico | 72057 | 1346 | |
1796231 | 1796231 | 2021-10-08 | Guayama | Puerto Rico | 72057 | 1343 | |
1792982 | 1792982 | 2021-10-07 | Guayama | Puerto Rico | 72057 | 1343 | |
1789733 | 1789733 | 2021-10-06 | Guayama | Puerto Rico | 72057 | 1343 | |
1786485 | 1786485 | 2021-10-05 | Guayama | Puerto Rico | 72057 | 1343 | |
1783236 | 1783236 | 2021-10-04 | Guayama | Puerto Rico | 72057 | 1343 | |
1779987 | 1779987 | 2021-10-03 | Guayama | Puerto Rico | 72057 | 1343 | |
1776737 | 1776737 | 2021-10-02 | Guayama | Puerto Rico | 72057 | 1340 | |
1773487 | 1773487 | 2021-10-01 | Guayama | Puerto Rico | 72057 | 1340 | |
1770237 | 1770237 | 2021-09-30 | Guayama | Puerto Rico | 72057 | 1338 | |
1766988 | 1766988 | 2021-09-29 | Guayama | Puerto Rico | 72057 | 1337 | |
1763739 | 1763739 | 2021-09-28 | Guayama | Puerto Rico | 72057 | 1335 | |
1760490 | 1760490 | 2021-09-27 | Guayama | Puerto Rico | 72057 | 1335 | |
1757242 | 1757242 | 2021-09-26 | Guayama | Puerto Rico | 72057 | 1335 | |
1753994 | 1753994 | 2021-09-25 | Guayama | Puerto Rico | 72057 | 1334 | |
1750746 | 1750746 | 2021-09-24 | Guayama | Puerto Rico | 72057 | 1331 | |
1747497 | 1747497 | 2021-09-23 | Guayama | Puerto Rico | 72057 | 1324 | |
1744247 | 1744247 | 2021-09-22 | Guayama | Puerto Rico | 72057 | 1323 | |
1740998 | 1740998 | 2021-09-21 | Guayama | Puerto Rico | 72057 | 1323 | |
1737749 | 1737749 | 2021-09-20 | Guayama | Puerto Rico | 72057 | 1323 | |
1734499 | 1734499 | 2021-09-19 | Guayama | Puerto Rico | 72057 | 1321 | |
1731249 | 1731249 | 2021-09-18 | Guayama | Puerto Rico | 72057 | 1320 | |
1727999 | 1727999 | 2021-09-17 | Guayama | Puerto Rico | 72057 | 1320 | |
1724750 | 1724750 | 2021-09-16 | Guayama | Puerto Rico | 72057 | 1314 | |
1721501 | 1721501 | 2021-09-15 | Guayama | Puerto Rico | 72057 | 1312 | |
1718253 | 1718253 | 2021-09-14 | Guayama | Puerto Rico | 72057 | 1312 | |
1715005 | 1715005 | 2021-09-13 | Guayama | Puerto Rico | 72057 | 1312 | |
1711759 | 1711759 | 2021-09-12 | Guayama | Puerto Rico | 72057 | 1311 | |
1708512 | 1708512 | 2021-09-11 | Guayama | Puerto Rico | 72057 | 1311 | |
1705265 | 1705265 | 2021-09-10 | Guayama | Puerto Rico | 72057 | 1305 | |
1702015 | 1702015 | 2021-09-09 | Guayama | Puerto Rico | 72057 | 1301 | |
1698766 | 1698766 | 2021-09-08 | Guayama | Puerto Rico | 72057 | 1301 | |
1695518 | 1695518 | 2021-09-07 | Guayama | Puerto Rico | 72057 | 1297 | |
1692270 | 1692270 | 2021-09-06 | Guayama | Puerto Rico | 72057 | 1297 | |
1689021 | 1689021 | 2021-09-05 | Guayama | Puerto Rico | 72057 | 1295 | |
1685771 | 1685771 | 2021-09-04 | Guayama | Puerto Rico | 72057 | 1292 | |
1682520 | 1682520 | 2021-09-03 | Guayama | Puerto Rico | 72057 | 1281 | |
1679270 | 1679270 | 2021-09-02 | Guayama | Puerto Rico | 72057 | 1272 | |
1676022 | 1676022 | 2021-09-01 | Guayama | Puerto Rico | 72057 | 1271 | |
1672775 | 1672775 | 2021-08-31 | Guayama | Puerto Rico | 72057 | 1261 | |
1669527 | 1669527 | 2021-08-30 | Guayama | Puerto Rico | 72057 | 1260 | |
1666280 | 1666280 | 2021-08-29 | Guayama | Puerto Rico | 72057 | 1255 | |
1663032 | 1663032 | 2021-08-28 | Guayama | Puerto Rico | 72057 | 1252 | |
1659784 | 1659784 | 2021-08-27 | Guayama | Puerto Rico | 72057 | 1249 | |
1656535 | 1656535 | 2021-08-26 | Guayama | Puerto Rico | 72057 | 1248 | |
1653288 | 1653288 | 2021-08-25 | Guayama | Puerto Rico | 72057 | 1244 | |
1650041 | 1650041 | 2021-08-24 | Guayama | Puerto Rico | 72057 | 1242 | |
1646792 | 1646792 | 2021-08-23 | Guayama | Puerto Rico | 72057 | 1241 | |
1643543 | 1643543 | 2021-08-22 | Guayama | Puerto Rico | 72057 | 1230 | |
1640293 | 1640293 | 2021-08-21 | Guayama | Puerto Rico | 72057 | 1222 | |
1637043 | 1637043 | 2021-08-20 | Guayama | Puerto Rico | 72057 | 1208 | |
1633793 | 1633793 | 2021-08-19 | Guayama | Puerto Rico | 72057 | 1206 | |
1630546 | 1630546 | 2021-08-18 | Guayama | Puerto Rico | 72057 | 1206 | |
1627299 | 1627299 | 2021-08-17 | Guayama | Puerto Rico | 72057 | 1205 | |
1624052 | 1624052 | 2021-08-16 | Guayama | Puerto Rico | 72057 | 1199 | |
1620805 | 1620805 | 2021-08-15 | Guayama | Puerto Rico | 72057 | 1190 | |
1617557 | 1617557 | 2021-08-14 | Guayama | Puerto Rico | 72057 | 1187 | |
1614309 | 1614309 | 2021-08-13 | Guayama | Puerto Rico | 72057 | 1180 | |
1611060 | 1611060 | 2021-08-12 | Guayama | Puerto Rico | 72057 | 1173 | |
1607812 | 1607812 | 2021-08-11 | Guayama | Puerto Rico | 72057 | 1164 | |
1604563 | 1604563 | 2021-08-10 | Guayama | Puerto Rico | 72057 | 1161 | |
1601314 | 1601314 | 2021-08-09 | Guayama | Puerto Rico | 72057 | 1160 | |
1598066 | 1598066 | 2021-08-08 | Guayama | Puerto Rico | 72057 | 1159 | |
1594817 | 1594817 | 2021-08-07 | Guayama | Puerto Rico | 72057 | 1155 | |
1591568 | 1591568 | 2021-08-06 | Guayama | Puerto Rico | 72057 | 1153 | |
1588319 | 1588319 | 2021-08-05 | Guayama | Puerto Rico | 72057 | 1145 | |
1585069 | 1585069 | 2021-08-04 | Guayama | Puerto Rico | 72057 | 1140 | |
1581819 | 1581819 | 2021-08-03 | Guayama | Puerto Rico | 72057 | 1139 | |
1578570 | 1578570 | 2021-08-02 | Guayama | Puerto Rico | 72057 | 1136 | |
1575322 | 1575322 | 2021-08-01 | Guayama | Puerto Rico | 72057 | 1127 | |
1572074 | 1572074 | 2021-07-31 | Guayama | Puerto Rico | 72057 | 1124 | |
1568826 | 1568826 | 2021-07-30 | Guayama | Puerto Rico | 72057 | 1122 | |
1565578 | 1565578 | 2021-07-29 | Guayama | Puerto Rico | 72057 | 1121 | |
1562330 | 1562330 | 2021-07-28 | Guayama | Puerto Rico | 72057 | 1120 | |
1559082 | 1559082 | 2021-07-27 | Guayama | Puerto Rico | 72057 | 1119 | |
1555835 | 1555835 | 2021-07-26 | Guayama | Puerto Rico | 72057 | 1119 | |
1552588 | 1552588 | 2021-07-25 | Guayama | Puerto Rico | 72057 | 1115 | |
1549341 | 1549341 | 2021-07-24 | Guayama | Puerto Rico | 72057 | 1111 | |
1546094 | 1546094 | 2021-07-23 | Guayama | Puerto Rico | 72057 | 1110 | |
1542847 | 1542847 | 2021-07-22 | Guayama | Puerto Rico | 72057 | 1107 | |
1539599 | 1539599 | 2021-07-21 | Guayama | Puerto Rico | 72057 | 1107 | |
1536352 | 1536352 | 2021-07-20 | Guayama | Puerto Rico | 72057 | 1107 | |
1533104 | 1533104 | 2021-07-19 | Guayama | Puerto Rico | 72057 | 1106 | |
1529857 | 1529857 | 2021-07-18 | Guayama | Puerto Rico | 72057 | 1104 | |
1526610 | 1526610 | 2021-07-17 | Guayama | Puerto Rico | 72057 | 1104 | |
1523363 | 1523363 | 2021-07-16 | Guayama | Puerto Rico | 72057 | 1104 | |
1520115 | 1520115 | 2021-07-15 | Guayama | Puerto Rico | 72057 | 1103 |
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);