ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Humacao" 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 |
---|---|---|---|---|---|---|---|
1841724 | 1841724 | 2021-10-22 | Humacao | Puerto Rico | 72069 | 3035 | |
1838475 | 1838475 | 2021-10-21 | Humacao | Puerto Rico | 72069 | 3031 | |
1835226 | 1835226 | 2021-10-20 | Humacao | Puerto Rico | 72069 | 3028 | |
1831977 | 1831977 | 2021-10-19 | Humacao | Puerto Rico | 72069 | 3027 | |
1828728 | 1828728 | 2021-10-18 | Humacao | Puerto Rico | 72069 | 3027 | |
1825479 | 1825479 | 2021-10-17 | Humacao | Puerto Rico | 72069 | 3024 | |
1822230 | 1822230 | 2021-10-16 | Humacao | Puerto Rico | 72069 | 3021 | |
1818981 | 1818981 | 2021-10-15 | Humacao | Puerto Rico | 72069 | 3020 | |
1815732 | 1815732 | 2021-10-14 | Humacao | Puerto Rico | 72069 | 3018 | |
1812484 | 1812484 | 2021-10-13 | Humacao | Puerto Rico | 72069 | 3018 | |
1809235 | 1809235 | 2021-10-12 | Humacao | Puerto Rico | 72069 | 3010 | |
1805985 | 1805985 | 2021-10-11 | Humacao | Puerto Rico | 72069 | 3009 | |
1802735 | 1802735 | 2021-10-10 | Humacao | Puerto Rico | 72069 | 3002 | |
1799486 | 1799486 | 2021-10-09 | Humacao | Puerto Rico | 72069 | 3002 | |
1796237 | 1796237 | 2021-10-08 | Humacao | Puerto Rico | 72069 | 3000 | |
1792988 | 1792988 | 2021-10-07 | Humacao | Puerto Rico | 72069 | 2999 | |
1789739 | 1789739 | 2021-10-06 | Humacao | Puerto Rico | 72069 | 2996 | |
1786491 | 1786491 | 2021-10-05 | Humacao | Puerto Rico | 72069 | 2995 | |
1783242 | 1783242 | 2021-10-04 | Humacao | Puerto Rico | 72069 | 2994 | |
1779993 | 1779993 | 2021-10-03 | Humacao | Puerto Rico | 72069 | 2993 | |
1776743 | 1776743 | 2021-10-02 | Humacao | Puerto Rico | 72069 | 2992 | |
1773493 | 1773493 | 2021-10-01 | Humacao | Puerto Rico | 72069 | 2983 | |
1770243 | 1770243 | 2021-09-30 | Humacao | Puerto Rico | 72069 | 2984 | |
1766994 | 1766994 | 2021-09-29 | Humacao | Puerto Rico | 72069 | 2982 | |
1763745 | 1763745 | 2021-09-28 | Humacao | Puerto Rico | 72069 | 2979 | |
1760496 | 1760496 | 2021-09-27 | Humacao | Puerto Rico | 72069 | 2978 | |
1757248 | 1757248 | 2021-09-26 | Humacao | Puerto Rico | 72069 | 2977 | |
1754000 | 1754000 | 2021-09-25 | Humacao | Puerto Rico | 72069 | 2975 | |
1750752 | 1750752 | 2021-09-24 | Humacao | Puerto Rico | 72069 | 2972 | |
1747503 | 1747503 | 2021-09-23 | Humacao | Puerto Rico | 72069 | 2965 | |
1744253 | 1744253 | 2021-09-22 | Humacao | Puerto Rico | 72069 | 2962 | |
1741004 | 1741004 | 2021-09-21 | Humacao | Puerto Rico | 72069 | 2962 | |
1737755 | 1737755 | 2021-09-20 | Humacao | Puerto Rico | 72069 | 2961 | |
1734505 | 1734505 | 2021-09-19 | Humacao | Puerto Rico | 72069 | 2958 | |
1731255 | 1731255 | 2021-09-18 | Humacao | Puerto Rico | 72069 | 2955 | |
1728005 | 1728005 | 2021-09-17 | Humacao | Puerto Rico | 72069 | 2954 | |
1724756 | 1724756 | 2021-09-16 | Humacao | Puerto Rico | 72069 | 2949 | |
1721507 | 1721507 | 2021-09-15 | Humacao | Puerto Rico | 72069 | 2950 | |
1718259 | 1718259 | 2021-09-14 | Humacao | Puerto Rico | 72069 | 2949 | |
1715011 | 1715011 | 2021-09-13 | Humacao | Puerto Rico | 72069 | 2946 | |
1711765 | 1711765 | 2021-09-12 | Humacao | Puerto Rico | 72069 | 2944 | |
1708518 | 1708518 | 2021-09-11 | Humacao | Puerto Rico | 72069 | 2932 | |
1705271 | 1705271 | 2021-09-10 | Humacao | Puerto Rico | 72069 | 2924 | |
1702021 | 1702021 | 2021-09-09 | Humacao | Puerto Rico | 72069 | 2918 | |
1698772 | 1698772 | 2021-09-08 | Humacao | Puerto Rico | 72069 | 2914 | |
1695524 | 1695524 | 2021-09-07 | Humacao | Puerto Rico | 72069 | 2913 | |
1692276 | 1692276 | 2021-09-06 | Humacao | Puerto Rico | 72069 | 2913 | |
1689027 | 1689027 | 2021-09-05 | Humacao | Puerto Rico | 72069 | 2905 | |
1685777 | 1685777 | 2021-09-04 | Humacao | Puerto Rico | 72069 | 2892 | |
1682526 | 1682526 | 2021-09-03 | Humacao | Puerto Rico | 72069 | 2888 | |
1679276 | 1679276 | 2021-09-02 | Humacao | Puerto Rico | 72069 | 2875 | |
1676028 | 1676028 | 2021-09-01 | Humacao | Puerto Rico | 72069 | 2861 | |
1672781 | 1672781 | 2021-08-31 | Humacao | Puerto Rico | 72069 | 2849 | |
1669533 | 1669533 | 2021-08-30 | Humacao | Puerto Rico | 72069 | 2848 | |
1666286 | 1666286 | 2021-08-29 | Humacao | Puerto Rico | 72069 | 2837 | |
1663038 | 1663038 | 2021-08-28 | Humacao | Puerto Rico | 72069 | 2831 | |
1659790 | 1659790 | 2021-08-27 | Humacao | Puerto Rico | 72069 | 2820 | |
1656541 | 1656541 | 2021-08-26 | Humacao | Puerto Rico | 72069 | 2814 | |
1653294 | 1653294 | 2021-08-25 | Humacao | Puerto Rico | 72069 | 2794 | |
1650047 | 1650047 | 2021-08-24 | Humacao | Puerto Rico | 72069 | 2794 | |
1646798 | 1646798 | 2021-08-23 | Humacao | Puerto Rico | 72069 | 2789 | |
1643549 | 1643549 | 2021-08-22 | Humacao | Puerto Rico | 72069 | 2780 | |
1640299 | 1640299 | 2021-08-21 | Humacao | Puerto Rico | 72069 | 2779 | |
1637049 | 1637049 | 2021-08-20 | Humacao | Puerto Rico | 72069 | 2758 | |
1633799 | 1633799 | 2021-08-19 | Humacao | Puerto Rico | 72069 | 2744 | |
1630552 | 1630552 | 2021-08-18 | Humacao | Puerto Rico | 72069 | 2740 | |
1627305 | 1627305 | 2021-08-17 | Humacao | Puerto Rico | 72069 | 2738 | |
1624058 | 1624058 | 2021-08-16 | Humacao | Puerto Rico | 72069 | 2737 | |
1620811 | 1620811 | 2021-08-15 | Humacao | Puerto Rico | 72069 | 2736 | |
1617563 | 1617563 | 2021-08-14 | Humacao | Puerto Rico | 72069 | 2727 | |
1614315 | 1614315 | 2021-08-13 | Humacao | Puerto Rico | 72069 | 2716 | |
1611066 | 1611066 | 2021-08-12 | Humacao | Puerto Rico | 72069 | 2693 | |
1607818 | 1607818 | 2021-08-11 | Humacao | Puerto Rico | 72069 | 2676 | |
1604569 | 1604569 | 2021-08-10 | Humacao | Puerto Rico | 72069 | 2670 | |
1601320 | 1601320 | 2021-08-09 | Humacao | Puerto Rico | 72069 | 2663 | |
1598072 | 1598072 | 2021-08-08 | Humacao | Puerto Rico | 72069 | 2656 | |
1594823 | 1594823 | 2021-08-07 | Humacao | Puerto Rico | 72069 | 2644 | |
1591574 | 1591574 | 2021-08-06 | Humacao | Puerto Rico | 72069 | 2639 | |
1588325 | 1588325 | 2021-08-05 | Humacao | Puerto Rico | 72069 | 2634 | |
1585075 | 1585075 | 2021-08-04 | Humacao | Puerto Rico | 72069 | 2624 | |
1581825 | 1581825 | 2021-08-03 | Humacao | Puerto Rico | 72069 | 2621 | |
1578576 | 1578576 | 2021-08-02 | Humacao | Puerto Rico | 72069 | 2619 | |
1575328 | 1575328 | 2021-08-01 | Humacao | Puerto Rico | 72069 | 2613 | |
1572080 | 1572080 | 2021-07-31 | Humacao | Puerto Rico | 72069 | 2606 | |
1568832 | 1568832 | 2021-07-30 | Humacao | Puerto Rico | 72069 | 2595 | |
1565584 | 1565584 | 2021-07-29 | Humacao | Puerto Rico | 72069 | 2586 | |
1562336 | 1562336 | 2021-07-28 | Humacao | Puerto Rico | 72069 | 2574 | |
1559088 | 1559088 | 2021-07-27 | Humacao | Puerto Rico | 72069 | 2574 | |
1555841 | 1555841 | 2021-07-26 | Humacao | Puerto Rico | 72069 | 2573 | |
1552594 | 1552594 | 2021-07-25 | Humacao | Puerto Rico | 72069 | 2570 | |
1549347 | 1549347 | 2021-07-24 | Humacao | Puerto Rico | 72069 | 2567 | |
1546100 | 1546100 | 2021-07-23 | Humacao | Puerto Rico | 72069 | 2564 | |
1542853 | 1542853 | 2021-07-22 | Humacao | Puerto Rico | 72069 | 2549 | |
1539605 | 1539605 | 2021-07-21 | Humacao | Puerto Rico | 72069 | 2545 | |
1536358 | 1536358 | 2021-07-20 | Humacao | Puerto Rico | 72069 | 2543 | |
1533110 | 1533110 | 2021-07-19 | Humacao | Puerto Rico | 72069 | 2541 | |
1529863 | 1529863 | 2021-07-18 | Humacao | Puerto Rico | 72069 | 2539 | |
1526616 | 1526616 | 2021-07-17 | Humacao | Puerto Rico | 72069 | 2539 | |
1523369 | 1523369 | 2021-07-16 | Humacao | Puerto Rico | 72069 | 2535 | |
1520121 | 1520121 | 2021-07-15 | Humacao | Puerto Rico | 72069 | 2533 |
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);