ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72011 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 |
---|---|---|---|---|---|---|---|
2176535 | 2176535 | 2022-02-02 | Anasco | Puerto Rico | 72011 | 3306 | |
2173281 | 2173281 | 2022-02-01 | Anasco | Puerto Rico | 72011 | 3295 | |
2170029 | 2170029 | 2022-01-31 | Anasco | Puerto Rico | 72011 | 3294 | |
2166775 | 2166775 | 2022-01-30 | Anasco | Puerto Rico | 72011 | 3285 | |
2163520 | 2163520 | 2022-01-29 | Anasco | Puerto Rico | 72011 | 3268 | |
2160265 | 2160265 | 2022-01-28 | Anasco | Puerto Rico | 72011 | 3252 | |
2157009 | 2157009 | 2022-01-27 | Anasco | Puerto Rico | 72011 | 3231 | |
2153756 | 2153756 | 2022-01-26 | Anasco | Puerto Rico | 72011 | 3218 | |
2150504 | 2150504 | 2022-01-25 | Anasco | Puerto Rico | 72011 | 3183 | |
2147252 | 2147252 | 2022-01-24 | Anasco | Puerto Rico | 72011 | 3183 | |
2143998 | 2143998 | 2022-01-23 | Anasco | Puerto Rico | 72011 | 3157 | |
2140743 | 2140743 | 2022-01-22 | Anasco | Puerto Rico | 72011 | 3112 | |
2137487 | 2137487 | 2022-01-21 | Anasco | Puerto Rico | 72011 | 3048 | |
2134233 | 2134233 | 2022-01-20 | Anasco | Puerto Rico | 72011 | 2994 | |
2130981 | 2130981 | 2022-01-19 | Anasco | Puerto Rico | 72011 | 2976 | |
2127727 | 2127727 | 2022-01-18 | Anasco | Puerto Rico | 72011 | 2950 | |
2124475 | 2124475 | 2022-01-17 | Anasco | Puerto Rico | 72011 | 2949 | |
2121223 | 2121223 | 2022-01-16 | Anasco | Puerto Rico | 72011 | 2935 | |
2117971 | 2117971 | 2022-01-15 | Anasco | Puerto Rico | 72011 | 2862 | |
2114720 | 2114720 | 2022-01-14 | Anasco | Puerto Rico | 72011 | 2803 | |
2111468 | 2111468 | 2022-01-13 | Anasco | Puerto Rico | 72011 | 2736 | |
2108216 | 2108216 | 2022-01-12 | Anasco | Puerto Rico | 72011 | 2661 | |
2104965 | 2104965 | 2022-01-11 | Anasco | Puerto Rico | 72011 | 2576 | |
2101714 | 2101714 | 2022-01-10 | Anasco | Puerto Rico | 72011 | 2575 | |
2098463 | 2098463 | 2022-01-09 | Anasco | Puerto Rico | 72011 | 2544 | |
2095211 | 2095211 | 2022-01-08 | Anasco | Puerto Rico | 72011 | 2475 | |
2091959 | 2091959 | 2022-01-07 | Anasco | Puerto Rico | 72011 | 2419 | |
2088707 | 2088707 | 2022-01-06 | Anasco | Puerto Rico | 72011 | 2362 | |
2085456 | 2085456 | 2022-01-05 | Anasco | Puerto Rico | 72011 | 2271 | |
2082204 | 2082204 | 2022-01-04 | Anasco | Puerto Rico | 72011 | 2222 | |
2078952 | 2078952 | 2022-01-03 | Anasco | Puerto Rico | 72011 | 2218 | |
2075701 | 2075701 | 2022-01-02 | Anasco | Puerto Rico | 72011 | 2180 | |
2072450 | 2072450 | 2022-01-01 | Anasco | Puerto Rico | 72011 | 1960 | |
2069199 | 2069199 | 2021-12-31 | Anasco | Puerto Rico | 72011 | 1960 | |
2065948 | 2065948 | 2021-12-30 | Anasco | Puerto Rico | 72011 | 1852 | |
2062698 | 2062698 | 2021-12-29 | Anasco | Puerto Rico | 72011 | 1735 | |
2059448 | 2059448 | 2021-12-28 | Anasco | Puerto Rico | 72011 | 1698 | |
2056199 | 2056199 | 2021-12-27 | Anasco | Puerto Rico | 72011 | 1684 | |
2052950 | 2052950 | 2021-12-26 | Anasco | Puerto Rico | 72011 | 1682 | |
2049700 | 2049700 | 2021-12-25 | Anasco | Puerto Rico | 72011 | 1621 | |
2046450 | 2046450 | 2021-12-24 | Anasco | Puerto Rico | 72011 | 1529 | |
2043200 | 2043200 | 2021-12-23 | Anasco | Puerto Rico | 72011 | 1529 | |
2039951 | 2039951 | 2021-12-22 | Anasco | Puerto Rico | 72011 | 1499 | |
2036701 | 2036701 | 2021-12-21 | Anasco | Puerto Rico | 72011 | 1479 | |
2033451 | 2033451 | 2021-12-20 | Anasco | Puerto Rico | 72011 | 1475 | |
2030201 | 2030201 | 2021-12-19 | Anasco | Puerto Rico | 72011 | 1470 | |
2026950 | 2026950 | 2021-12-18 | Anasco | Puerto Rico | 72011 | 1458 | |
2023699 | 2023699 | 2021-12-17 | Anasco | Puerto Rico | 72011 | 1452 | |
2020448 | 2020448 | 2021-12-16 | Anasco | Puerto Rico | 72011 | 1443 | |
2017197 | 2017197 | 2021-12-15 | Anasco | Puerto Rico | 72011 | 1441 | |
2013947 | 2013947 | 2021-12-14 | Anasco | Puerto Rico | 72011 | 1440 | |
2010696 | 2010696 | 2021-12-13 | Anasco | Puerto Rico | 72011 | 1439 | |
2007445 | 2007445 | 2021-12-12 | Anasco | Puerto Rico | 72011 | 1439 | |
2004194 | 2004194 | 2021-12-11 | Anasco | Puerto Rico | 72011 | 1439 | |
2000943 | 2000943 | 2021-12-10 | Anasco | Puerto Rico | 72011 | 1439 | |
1997693 | 1997693 | 2021-12-09 | Anasco | Puerto Rico | 72011 | 1439 | |
1994442 | 1994442 | 2021-12-08 | Anasco | Puerto Rico | 72011 | 1439 | |
1991191 | 1991191 | 2021-12-07 | Anasco | Puerto Rico | 72011 | 1439 | |
1987940 | 1987940 | 2021-12-06 | Anasco | Puerto Rico | 72011 | 1439 | |
1984690 | 1984690 | 2021-12-05 | Anasco | Puerto Rico | 72011 | 1439 | |
1981440 | 1981440 | 2021-12-04 | Anasco | Puerto Rico | 72011 | 1439 | |
1978190 | 1978190 | 2021-12-03 | Anasco | Puerto Rico | 72011 | 1437 | |
1974940 | 1974940 | 2021-12-02 | Anasco | Puerto Rico | 72011 | 1437 | |
1971691 | 1971691 | 2021-12-01 | Anasco | Puerto Rico | 72011 | 1437 | |
1968441 | 1968441 | 2021-11-30 | Anasco | Puerto Rico | 72011 | 1435 | |
1965190 | 1965190 | 2021-11-29 | Anasco | Puerto Rico | 72011 | 1435 | |
1961938 | 1961938 | 2021-11-28 | Anasco | Puerto Rico | 72011 | 1435 | |
1958687 | 1958687 | 2021-11-27 | Anasco | Puerto Rico | 72011 | 1435 | |
1955436 | 1955436 | 2021-11-26 | Anasco | Puerto Rico | 72011 | 1435 | |
1952185 | 1952185 | 2021-11-25 | Anasco | Puerto Rico | 72011 | 1432 | |
1948934 | 1948934 | 2021-11-24 | Anasco | Puerto Rico | 72011 | 1432 | |
1945683 | 1945683 | 2021-11-23 | Anasco | Puerto Rico | 72011 | 1432 | |
1942432 | 1942432 | 2021-11-22 | Anasco | Puerto Rico | 72011 | 1432 | |
1939182 | 1939182 | 2021-11-21 | Anasco | Puerto Rico | 72011 | 1432 | |
1935932 | 1935932 | 2021-11-20 | Anasco | Puerto Rico | 72011 | 1432 | |
1932682 | 1932682 | 2021-11-19 | Anasco | Puerto Rico | 72011 | 1432 | |
1929431 | 1929431 | 2021-11-18 | Anasco | Puerto Rico | 72011 | 1432 | |
1926181 | 1926181 | 2021-11-17 | Anasco | Puerto Rico | 72011 | 1431 | |
1922931 | 1922931 | 2021-11-16 | Anasco | Puerto Rico | 72011 | 1430 | |
1919682 | 1919682 | 2021-11-15 | Anasco | Puerto Rico | 72011 | 1430 | |
1916432 | 1916432 | 2021-11-14 | Anasco | Puerto Rico | 72011 | 1430 | |
1913182 | 1913182 | 2021-11-13 | Anasco | Puerto Rico | 72011 | 1430 | |
1909932 | 1909932 | 2021-11-12 | Anasco | Puerto Rico | 72011 | 1429 | |
1906683 | 1906683 | 2021-11-11 | Anasco | Puerto Rico | 72011 | 1429 | |
1903434 | 1903434 | 2021-11-10 | Anasco | Puerto Rico | 72011 | 1429 | |
1900184 | 1900184 | 2021-11-09 | Anasco | Puerto Rico | 72011 | 1428 | |
1896934 | 1896934 | 2021-11-08 | Anasco | Puerto Rico | 72011 | 1428 | |
1893684 | 1893684 | 2021-11-07 | Anasco | Puerto Rico | 72011 | 1427 | |
1890434 | 1890434 | 2021-11-06 | Anasco | Puerto Rico | 72011 | 1426 | |
1887184 | 1887184 | 2021-11-05 | Anasco | Puerto Rico | 72011 | 1425 | |
1883934 | 1883934 | 2021-11-04 | Anasco | Puerto Rico | 72011 | 1425 | |
1880685 | 1880685 | 2021-11-03 | Anasco | Puerto Rico | 72011 | 1425 | |
1877436 | 1877436 | 2021-11-02 | Anasco | Puerto Rico | 72011 | 1424 | |
1874187 | 1874187 | 2021-11-01 | Anasco | Puerto Rico | 72011 | 1424 | |
1870938 | 1870938 | 2021-10-31 | Anasco | Puerto Rico | 72011 | 1424 | |
1867689 | 1867689 | 2021-10-30 | Anasco | Puerto Rico | 72011 | 1424 | |
1864440 | 1864440 | 2021-10-29 | Anasco | Puerto Rico | 72011 | 1424 | |
1861191 | 1861191 | 2021-10-28 | Anasco | Puerto Rico | 72011 | 1424 | |
1857942 | 1857942 | 2021-10-27 | Anasco | Puerto Rico | 72011 | 1423 | |
1854693 | 1854693 | 2021-10-26 | Anasco | Puerto Rico | 72011 | 1423 |
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);