ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ciales" 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 |
---|---|---|---|---|---|---|---|
1812468 | 1812468 | 2021-10-13 | Ciales | Puerto Rico | 72039 | 1069 | |
1809219 | 1809219 | 2021-10-12 | Ciales | Puerto Rico | 72039 | 1069 | |
1805969 | 1805969 | 2021-10-11 | Ciales | Puerto Rico | 72039 | 1069 | |
1802719 | 1802719 | 2021-10-10 | Ciales | Puerto Rico | 72039 | 1067 | |
1799470 | 1799470 | 2021-10-09 | Ciales | Puerto Rico | 72039 | 1067 | |
1796221 | 1796221 | 2021-10-08 | Ciales | Puerto Rico | 72039 | 1067 | |
1792972 | 1792972 | 2021-10-07 | Ciales | Puerto Rico | 72039 | 1066 | |
1789723 | 1789723 | 2021-10-06 | Ciales | Puerto Rico | 72039 | 1066 | |
1786475 | 1786475 | 2021-10-05 | Ciales | Puerto Rico | 72039 | 1066 | |
1783226 | 1783226 | 2021-10-04 | Ciales | Puerto Rico | 72039 | 1066 | |
1779977 | 1779977 | 2021-10-03 | Ciales | Puerto Rico | 72039 | 1066 | |
1776727 | 1776727 | 2021-10-02 | Ciales | Puerto Rico | 72039 | 1066 | |
1773477 | 1773477 | 2021-10-01 | Ciales | Puerto Rico | 72039 | 1063 | |
1770227 | 1770227 | 2021-09-30 | Ciales | Puerto Rico | 72039 | 1063 | |
1766978 | 1766978 | 2021-09-29 | Ciales | Puerto Rico | 72039 | 1060 | |
1763729 | 1763729 | 2021-09-28 | Ciales | Puerto Rico | 72039 | 1060 | |
1760480 | 1760480 | 2021-09-27 | Ciales | Puerto Rico | 72039 | 1060 | |
1757232 | 1757232 | 2021-09-26 | Ciales | Puerto Rico | 72039 | 1060 | |
1753984 | 1753984 | 2021-09-25 | Ciales | Puerto Rico | 72039 | 1058 | |
1750736 | 1750736 | 2021-09-24 | Ciales | Puerto Rico | 72039 | 1056 | |
1747487 | 1747487 | 2021-09-23 | Ciales | Puerto Rico | 72039 | 1051 | |
1744237 | 1744237 | 2021-09-22 | Ciales | Puerto Rico | 72039 | 1050 | |
1740988 | 1740988 | 2021-09-21 | Ciales | Puerto Rico | 72039 | 1049 | |
1737739 | 1737739 | 2021-09-20 | Ciales | Puerto Rico | 72039 | 1049 | |
1734489 | 1734489 | 2021-09-19 | Ciales | Puerto Rico | 72039 | 1046 | |
1731239 | 1731239 | 2021-09-18 | Ciales | Puerto Rico | 72039 | 1046 | |
1727989 | 1727989 | 2021-09-17 | Ciales | Puerto Rico | 72039 | 1044 | |
1724740 | 1724740 | 2021-09-16 | Ciales | Puerto Rico | 72039 | 1044 | |
1721491 | 1721491 | 2021-09-15 | Ciales | Puerto Rico | 72039 | 1043 | |
1718243 | 1718243 | 2021-09-14 | Ciales | Puerto Rico | 72039 | 1041 | |
1714995 | 1714995 | 2021-09-13 | Ciales | Puerto Rico | 72039 | 1041 | |
1711749 | 1711749 | 2021-09-12 | Ciales | Puerto Rico | 72039 | 1041 | |
1708502 | 1708502 | 2021-09-11 | Ciales | Puerto Rico | 72039 | 1035 | |
1705255 | 1705255 | 2021-09-10 | Ciales | Puerto Rico | 72039 | 1035 | |
1702005 | 1702005 | 2021-09-09 | Ciales | Puerto Rico | 72039 | 1035 | |
1698756 | 1698756 | 2021-09-08 | Ciales | Puerto Rico | 72039 | 1035 | |
1695508 | 1695508 | 2021-09-07 | Ciales | Puerto Rico | 72039 | 1035 | |
1692260 | 1692260 | 2021-09-06 | Ciales | Puerto Rico | 72039 | 1034 | |
1689011 | 1689011 | 2021-09-05 | Ciales | Puerto Rico | 72039 | 1034 | |
1685761 | 1685761 | 2021-09-04 | Ciales | Puerto Rico | 72039 | 1033 | |
1682510 | 1682510 | 2021-09-03 | Ciales | Puerto Rico | 72039 | 1031 | |
1679260 | 1679260 | 2021-09-02 | Ciales | Puerto Rico | 72039 | 1030 | |
1676012 | 1676012 | 2021-09-01 | Ciales | Puerto Rico | 72039 | 1030 | |
1672765 | 1672765 | 2021-08-31 | Ciales | Puerto Rico | 72039 | 1023 | |
1669517 | 1669517 | 2021-08-30 | Ciales | Puerto Rico | 72039 | 1019 | |
1666270 | 1666270 | 2021-08-29 | Ciales | Puerto Rico | 72039 | 1019 | |
1663022 | 1663022 | 2021-08-28 | Ciales | Puerto Rico | 72039 | 1018 | |
1659774 | 1659774 | 2021-08-27 | Ciales | Puerto Rico | 72039 | 1011 | |
1656525 | 1656525 | 2021-08-26 | Ciales | Puerto Rico | 72039 | 1008 | |
1653278 | 1653278 | 2021-08-25 | Ciales | Puerto Rico | 72039 | 1008 | |
1650031 | 1650031 | 2021-08-24 | Ciales | Puerto Rico | 72039 | 1008 | |
1646782 | 1646782 | 2021-08-23 | Ciales | Puerto Rico | 72039 | 1001 | |
1643533 | 1643533 | 2021-08-22 | Ciales | Puerto Rico | 72039 | 996 | |
1640283 | 1640283 | 2021-08-21 | Ciales | Puerto Rico | 72039 | 991 | |
1637033 | 1637033 | 2021-08-20 | Ciales | Puerto Rico | 72039 | 982 | |
1633783 | 1633783 | 2021-08-19 | Ciales | Puerto Rico | 72039 | 979 | |
1630536 | 1630536 | 2021-08-18 | Ciales | Puerto Rico | 72039 | 979 | |
1627289 | 1627289 | 2021-08-17 | Ciales | Puerto Rico | 72039 | 979 | |
1624042 | 1624042 | 2021-08-16 | Ciales | Puerto Rico | 72039 | 977 | |
1620795 | 1620795 | 2021-08-15 | Ciales | Puerto Rico | 72039 | 975 | |
1617547 | 1617547 | 2021-08-14 | Ciales | Puerto Rico | 72039 | 973 | |
1614299 | 1614299 | 2021-08-13 | Ciales | Puerto Rico | 72039 | 973 | |
1611050 | 1611050 | 2021-08-12 | Ciales | Puerto Rico | 72039 | 969 | |
1607802 | 1607802 | 2021-08-11 | Ciales | Puerto Rico | 72039 | 969 | |
1604553 | 1604553 | 2021-08-10 | Ciales | Puerto Rico | 72039 | 966 | |
1601304 | 1601304 | 2021-08-09 | Ciales | Puerto Rico | 72039 | 965 | |
1598056 | 1598056 | 2021-08-08 | Ciales | Puerto Rico | 72039 | 959 | |
1594807 | 1594807 | 2021-08-07 | Ciales | Puerto Rico | 72039 | 953 | |
1591558 | 1591558 | 2021-08-06 | Ciales | Puerto Rico | 72039 | 953 | |
1588309 | 1588309 | 2021-08-05 | Ciales | Puerto Rico | 72039 | 951 | |
1585059 | 1585059 | 2021-08-04 | Ciales | Puerto Rico | 72039 | 948 | |
1581809 | 1581809 | 2021-08-03 | Ciales | Puerto Rico | 72039 | 947 | |
1578560 | 1578560 | 2021-08-02 | Ciales | Puerto Rico | 72039 | 946 | |
1575312 | 1575312 | 2021-08-01 | Ciales | Puerto Rico | 72039 | 945 | |
1572064 | 1572064 | 2021-07-31 | Ciales | Puerto Rico | 72039 | 944 | |
1568816 | 1568816 | 2021-07-30 | Ciales | Puerto Rico | 72039 | 944 | |
1565568 | 1565568 | 2021-07-29 | Ciales | Puerto Rico | 72039 | 944 | |
1562320 | 1562320 | 2021-07-28 | Ciales | Puerto Rico | 72039 | 944 | |
1559072 | 1559072 | 2021-07-27 | Ciales | Puerto Rico | 72039 | 944 | |
1555825 | 1555825 | 2021-07-26 | Ciales | Puerto Rico | 72039 | 942 | |
1552578 | 1552578 | 2021-07-25 | Ciales | Puerto Rico | 72039 | 942 | |
1549331 | 1549331 | 2021-07-24 | Ciales | Puerto Rico | 72039 | 940 | |
1546084 | 1546084 | 2021-07-23 | Ciales | Puerto Rico | 72039 | 939 | |
1542837 | 1542837 | 2021-07-22 | Ciales | Puerto Rico | 72039 | 934 | |
1539589 | 1539589 | 2021-07-21 | Ciales | Puerto Rico | 72039 | 934 | |
1536342 | 1536342 | 2021-07-20 | Ciales | Puerto Rico | 72039 | 933 | |
1533094 | 1533094 | 2021-07-19 | Ciales | Puerto Rico | 72039 | 933 | |
1529847 | 1529847 | 2021-07-18 | Ciales | Puerto Rico | 72039 | 933 | |
1526600 | 1526600 | 2021-07-17 | Ciales | Puerto Rico | 72039 | 933 | |
1523353 | 1523353 | 2021-07-16 | Ciales | Puerto Rico | 72039 | 933 | |
1520105 | 1520105 | 2021-07-15 | Ciales | Puerto Rico | 72039 | 932 | |
1516857 | 1516857 | 2021-07-14 | Ciales | Puerto Rico | 72039 | 932 | |
1513610 | 1513610 | 2021-07-13 | Ciales | Puerto Rico | 72039 | 932 | |
1510364 | 1510364 | 2021-07-12 | Ciales | Puerto Rico | 72039 | 932 | |
1507117 | 1507117 | 2021-07-11 | Ciales | Puerto Rico | 72039 | 932 | |
1503871 | 1503871 | 2021-07-10 | Ciales | Puerto Rico | 72039 | 932 | |
1500625 | 1500625 | 2021-07-09 | Ciales | Puerto Rico | 72039 | 932 | |
1497379 | 1497379 | 2021-07-08 | Ciales | Puerto Rico | 72039 | 932 | |
1494132 | 1494132 | 2021-07-07 | Ciales | Puerto Rico | 72039 | 932 | |
1490885 | 1490885 | 2021-07-06 | Ciales | Puerto Rico | 72039 | 932 |
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);