ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72029 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 |
---|---|---|---|---|---|---|---|
1812463 | 1812463 | 2021-10-13 | Canovanas | Puerto Rico | 72029 | 3068 | |
1809214 | 1809214 | 2021-10-12 | Canovanas | Puerto Rico | 72029 | 3066 | |
1805964 | 1805964 | 2021-10-11 | Canovanas | Puerto Rico | 72029 | 3066 | |
1802714 | 1802714 | 2021-10-10 | Canovanas | Puerto Rico | 72029 | 3061 | |
1799465 | 1799465 | 2021-10-09 | Canovanas | Puerto Rico | 72029 | 3061 | |
1796216 | 1796216 | 2021-10-08 | Canovanas | Puerto Rico | 72029 | 3061 | |
1792967 | 1792967 | 2021-10-07 | Canovanas | Puerto Rico | 72029 | 3060 | |
1789718 | 1789718 | 2021-10-06 | Canovanas | Puerto Rico | 72029 | 3055 | |
1786470 | 1786470 | 2021-10-05 | Canovanas | Puerto Rico | 72029 | 3051 | |
1783221 | 1783221 | 2021-10-04 | Canovanas | Puerto Rico | 72029 | 3049 | |
1779972 | 1779972 | 2021-10-03 | Canovanas | Puerto Rico | 72029 | 3046 | |
1776722 | 1776722 | 2021-10-02 | Canovanas | Puerto Rico | 72029 | 3046 | |
1773472 | 1773472 | 2021-10-01 | Canovanas | Puerto Rico | 72029 | 3041 | |
1770222 | 1770222 | 2021-09-30 | Canovanas | Puerto Rico | 72029 | 3040 | |
1766973 | 1766973 | 2021-09-29 | Canovanas | Puerto Rico | 72029 | 3032 | |
1763724 | 1763724 | 2021-09-28 | Canovanas | Puerto Rico | 72029 | 3029 | |
1760475 | 1760475 | 2021-09-27 | Canovanas | Puerto Rico | 72029 | 3029 | |
1757227 | 1757227 | 2021-09-26 | Canovanas | Puerto Rico | 72029 | 3025 | |
1753979 | 1753979 | 2021-09-25 | Canovanas | Puerto Rico | 72029 | 3022 | |
1750731 | 1750731 | 2021-09-24 | Canovanas | Puerto Rico | 72029 | 3017 | |
1747482 | 1747482 | 2021-09-23 | Canovanas | Puerto Rico | 72029 | 3016 | |
1744232 | 1744232 | 2021-09-22 | Canovanas | Puerto Rico | 72029 | 3013 | |
1740983 | 1740983 | 2021-09-21 | Canovanas | Puerto Rico | 72029 | 3008 | |
1737734 | 1737734 | 2021-09-20 | Canovanas | Puerto Rico | 72029 | 3008 | |
1734484 | 1734484 | 2021-09-19 | Canovanas | Puerto Rico | 72029 | 3004 | |
1731234 | 1731234 | 2021-09-18 | Canovanas | Puerto Rico | 72029 | 3002 | |
1727984 | 1727984 | 2021-09-17 | Canovanas | Puerto Rico | 72029 | 2990 | |
1724735 | 1724735 | 2021-09-16 | Canovanas | Puerto Rico | 72029 | 2983 | |
1721486 | 1721486 | 2021-09-15 | Canovanas | Puerto Rico | 72029 | 2976 | |
1718238 | 1718238 | 2021-09-14 | Canovanas | Puerto Rico | 72029 | 2973 | |
1714990 | 1714990 | 2021-09-13 | Canovanas | Puerto Rico | 72029 | 2973 | |
1711744 | 1711744 | 2021-09-12 | Canovanas | Puerto Rico | 72029 | 2970 | |
1708497 | 1708497 | 2021-09-11 | Canovanas | Puerto Rico | 72029 | 2960 | |
1705250 | 1705250 | 2021-09-10 | Canovanas | Puerto Rico | 72029 | 2956 | |
1702000 | 1702000 | 2021-09-09 | Canovanas | Puerto Rico | 72029 | 2949 | |
1698751 | 1698751 | 2021-09-08 | Canovanas | Puerto Rico | 72029 | 2939 | |
1695503 | 1695503 | 2021-09-07 | Canovanas | Puerto Rico | 72029 | 2938 | |
1692255 | 1692255 | 2021-09-06 | Canovanas | Puerto Rico | 72029 | 2938 | |
1689006 | 1689006 | 2021-09-05 | Canovanas | Puerto Rico | 72029 | 2926 | |
1685756 | 1685756 | 2021-09-04 | Canovanas | Puerto Rico | 72029 | 2915 | |
1682505 | 1682505 | 2021-09-03 | Canovanas | Puerto Rico | 72029 | 2910 | |
1679255 | 1679255 | 2021-09-02 | Canovanas | Puerto Rico | 72029 | 2901 | |
1676007 | 1676007 | 2021-09-01 | Canovanas | Puerto Rico | 72029 | 2891 | |
1672760 | 1672760 | 2021-08-31 | Canovanas | Puerto Rico | 72029 | 2859 | |
1669512 | 1669512 | 2021-08-30 | Canovanas | Puerto Rico | 72029 | 2852 | |
1666265 | 1666265 | 2021-08-29 | Canovanas | Puerto Rico | 72029 | 2848 | |
1663017 | 1663017 | 2021-08-28 | Canovanas | Puerto Rico | 72029 | 2835 | |
1659769 | 1659769 | 2021-08-27 | Canovanas | Puerto Rico | 72029 | 2809 | |
1656520 | 1656520 | 2021-08-26 | Canovanas | Puerto Rico | 72029 | 2796 | |
1653273 | 1653273 | 2021-08-25 | Canovanas | Puerto Rico | 72029 | 2769 | |
1650026 | 1650026 | 2021-08-24 | Canovanas | Puerto Rico | 72029 | 2759 | |
1646777 | 1646777 | 2021-08-23 | Canovanas | Puerto Rico | 72029 | 2758 | |
1643528 | 1643528 | 2021-08-22 | Canovanas | Puerto Rico | 72029 | 2748 | |
1640278 | 1640278 | 2021-08-21 | Canovanas | Puerto Rico | 72029 | 2740 | |
1637028 | 1637028 | 2021-08-20 | Canovanas | Puerto Rico | 72029 | 2708 | |
1633778 | 1633778 | 2021-08-19 | Canovanas | Puerto Rico | 72029 | 2684 | |
1630531 | 1630531 | 2021-08-18 | Canovanas | Puerto Rico | 72029 | 2665 | |
1627284 | 1627284 | 2021-08-17 | Canovanas | Puerto Rico | 72029 | 2664 | |
1624037 | 1624037 | 2021-08-16 | Canovanas | Puerto Rico | 72029 | 2660 | |
1620790 | 1620790 | 2021-08-15 | Canovanas | Puerto Rico | 72029 | 2656 | |
1617542 | 1617542 | 2021-08-14 | Canovanas | Puerto Rico | 72029 | 2640 | |
1614294 | 1614294 | 2021-08-13 | Canovanas | Puerto Rico | 72029 | 2606 | |
1611045 | 1611045 | 2021-08-12 | Canovanas | Puerto Rico | 72029 | 2589 | |
1607797 | 1607797 | 2021-08-11 | Canovanas | Puerto Rico | 72029 | 2566 | |
1604548 | 1604548 | 2021-08-10 | Canovanas | Puerto Rico | 72029 | 2547 | |
1601299 | 1601299 | 2021-08-09 | Canovanas | Puerto Rico | 72029 | 2544 | |
1598051 | 1598051 | 2021-08-08 | Canovanas | Puerto Rico | 72029 | 2531 | |
1594802 | 1594802 | 2021-08-07 | Canovanas | Puerto Rico | 72029 | 2518 | |
1591553 | 1591553 | 2021-08-06 | Canovanas | Puerto Rico | 72029 | 2506 | |
1588304 | 1588304 | 2021-08-05 | Canovanas | Puerto Rico | 72029 | 2501 | |
1585054 | 1585054 | 2021-08-04 | Canovanas | Puerto Rico | 72029 | 2488 | |
1581804 | 1581804 | 2021-08-03 | Canovanas | Puerto Rico | 72029 | 2488 | |
1578555 | 1578555 | 2021-08-02 | Canovanas | Puerto Rico | 72029 | 2488 | |
1575307 | 1575307 | 2021-08-01 | Canovanas | Puerto Rico | 72029 | 2479 | |
1572059 | 1572059 | 2021-07-31 | Canovanas | Puerto Rico | 72029 | 2476 | |
1568811 | 1568811 | 2021-07-30 | Canovanas | Puerto Rico | 72029 | 2464 | |
1565563 | 1565563 | 2021-07-29 | Canovanas | Puerto Rico | 72029 | 2455 | |
1562315 | 1562315 | 2021-07-28 | Canovanas | Puerto Rico | 72029 | 2452 | |
1559067 | 1559067 | 2021-07-27 | Canovanas | Puerto Rico | 72029 | 2452 | |
1555820 | 1555820 | 2021-07-26 | Canovanas | Puerto Rico | 72029 | 2451 | |
1552573 | 1552573 | 2021-07-25 | Canovanas | Puerto Rico | 72029 | 2451 | |
1549326 | 1549326 | 2021-07-24 | Canovanas | Puerto Rico | 72029 | 2446 | |
1546079 | 1546079 | 2021-07-23 | Canovanas | Puerto Rico | 72029 | 2438 | |
1542832 | 1542832 | 2021-07-22 | Canovanas | Puerto Rico | 72029 | 2421 | |
1539584 | 1539584 | 2021-07-21 | Canovanas | Puerto Rico | 72029 | 2418 | |
1536337 | 1536337 | 2021-07-20 | Canovanas | Puerto Rico | 72029 | 2418 | |
1533089 | 1533089 | 2021-07-19 | Canovanas | Puerto Rico | 72029 | 2418 | |
1529842 | 1529842 | 2021-07-18 | Canovanas | Puerto Rico | 72029 | 2416 | |
1526595 | 1526595 | 2021-07-17 | Canovanas | Puerto Rico | 72029 | 2412 | |
1523348 | 1523348 | 2021-07-16 | Canovanas | Puerto Rico | 72029 | 2410 | |
1520100 | 1520100 | 2021-07-15 | Canovanas | Puerto Rico | 72029 | 2407 | |
1516852 | 1516852 | 2021-07-14 | Canovanas | Puerto Rico | 72029 | 2406 | |
1513605 | 1513605 | 2021-07-13 | Canovanas | Puerto Rico | 72029 | 2406 | |
1510359 | 1510359 | 2021-07-12 | Canovanas | Puerto Rico | 72029 | 2405 | |
1507112 | 1507112 | 2021-07-11 | Canovanas | Puerto Rico | 72029 | 2403 | |
1503866 | 1503866 | 2021-07-10 | Canovanas | Puerto Rico | 72029 | 2401 | |
1500620 | 1500620 | 2021-07-09 | Canovanas | Puerto Rico | 72029 | 2399 | |
1497374 | 1497374 | 2021-07-08 | Canovanas | Puerto Rico | 72029 | 2399 | |
1494127 | 1494127 | 2021-07-07 | Canovanas | Puerto Rico | 72029 | 2399 | |
1490880 | 1490880 | 2021-07-06 | Canovanas | Puerto Rico | 72029 | 2399 |
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);