ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72015 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 |
---|---|---|---|---|---|---|---|
2176537 | 2176537 | 2022-02-02 | Arroyo | Puerto Rico | 72015 | 1740 | |
2173283 | 2173283 | 2022-02-01 | Arroyo | Puerto Rico | 72015 | 1739 | |
2170031 | 2170031 | 2022-01-31 | Arroyo | Puerto Rico | 72015 | 1737 | |
2166777 | 2166777 | 2022-01-30 | Arroyo | Puerto Rico | 72015 | 1719 | |
2163522 | 2163522 | 2022-01-29 | Arroyo | Puerto Rico | 72015 | 1714 | |
2160267 | 2160267 | 2022-01-28 | Arroyo | Puerto Rico | 72015 | 1705 | |
2157011 | 2157011 | 2022-01-27 | Arroyo | Puerto Rico | 72015 | 1671 | |
2153758 | 2153758 | 2022-01-26 | Arroyo | Puerto Rico | 72015 | 1660 | |
2150506 | 2150506 | 2022-01-25 | Arroyo | Puerto Rico | 72015 | 1651 | |
2147254 | 2147254 | 2022-01-24 | Arroyo | Puerto Rico | 72015 | 1637 | |
2144000 | 2144000 | 2022-01-23 | Arroyo | Puerto Rico | 72015 | 1626 | |
2140745 | 2140745 | 2022-01-22 | Arroyo | Puerto Rico | 72015 | 1604 | |
2137489 | 2137489 | 2022-01-21 | Arroyo | Puerto Rico | 72015 | 1577 | |
2134235 | 2134235 | 2022-01-20 | Arroyo | Puerto Rico | 72015 | 1550 | |
2130983 | 2130983 | 2022-01-19 | Arroyo | Puerto Rico | 72015 | 1528 | |
2127729 | 2127729 | 2022-01-18 | Arroyo | Puerto Rico | 72015 | 1519 | |
2124477 | 2124477 | 2022-01-17 | Arroyo | Puerto Rico | 72015 | 1514 | |
2121225 | 2121225 | 2022-01-16 | Arroyo | Puerto Rico | 72015 | 1465 | |
2117973 | 2117973 | 2022-01-15 | Arroyo | Puerto Rico | 72015 | 1427 | |
2114722 | 2114722 | 2022-01-14 | Arroyo | Puerto Rico | 72015 | 1399 | |
2111470 | 2111470 | 2022-01-13 | Arroyo | Puerto Rico | 72015 | 1361 | |
2108218 | 2108218 | 2022-01-12 | Arroyo | Puerto Rico | 72015 | 1286 | |
2104967 | 2104967 | 2022-01-11 | Arroyo | Puerto Rico | 72015 | 1269 | |
2101716 | 2101716 | 2022-01-10 | Arroyo | Puerto Rico | 72015 | 1253 | |
2098465 | 2098465 | 2022-01-09 | Arroyo | Puerto Rico | 72015 | 1226 | |
2095213 | 2095213 | 2022-01-08 | Arroyo | Puerto Rico | 72015 | 1194 | |
2091961 | 2091961 | 2022-01-07 | Arroyo | Puerto Rico | 72015 | 1156 | |
2088709 | 2088709 | 2022-01-06 | Arroyo | Puerto Rico | 72015 | 1071 | |
2085458 | 2085458 | 2022-01-05 | Arroyo | Puerto Rico | 72015 | 991 | |
2082206 | 2082206 | 2022-01-04 | Arroyo | Puerto Rico | 72015 | 972 | |
2078954 | 2078954 | 2022-01-03 | Arroyo | Puerto Rico | 72015 | 965 | |
2075703 | 2075703 | 2022-01-02 | Arroyo | Puerto Rico | 72015 | 939 | |
2072452 | 2072452 | 2022-01-01 | Arroyo | Puerto Rico | 72015 | 822 | |
2069201 | 2069201 | 2021-12-31 | Arroyo | Puerto Rico | 72015 | 822 | |
2065950 | 2065950 | 2021-12-30 | Arroyo | Puerto Rico | 72015 | 755 | |
2062700 | 2062700 | 2021-12-29 | Arroyo | Puerto Rico | 72015 | 706 | |
2059450 | 2059450 | 2021-12-28 | Arroyo | Puerto Rico | 72015 | 695 | |
2056201 | 2056201 | 2021-12-27 | Arroyo | Puerto Rico | 72015 | 686 | |
2052952 | 2052952 | 2021-12-26 | Arroyo | Puerto Rico | 72015 | 673 | |
2049702 | 2049702 | 2021-12-25 | Arroyo | Puerto Rico | 72015 | 647 | |
2046452 | 2046452 | 2021-12-24 | Arroyo | Puerto Rico | 72015 | 604 | |
2043202 | 2043202 | 2021-12-23 | Arroyo | Puerto Rico | 72015 | 604 | |
2039953 | 2039953 | 2021-12-22 | Arroyo | Puerto Rico | 72015 | 590 | |
2036703 | 2036703 | 2021-12-21 | Arroyo | Puerto Rico | 72015 | 588 | |
2033453 | 2033453 | 2021-12-20 | Arroyo | Puerto Rico | 72015 | 587 | |
2030203 | 2030203 | 2021-12-19 | Arroyo | Puerto Rico | 72015 | 580 | |
2026952 | 2026952 | 2021-12-18 | Arroyo | Puerto Rico | 72015 | 573 | |
2023701 | 2023701 | 2021-12-17 | Arroyo | Puerto Rico | 72015 | 570 | |
2020450 | 2020450 | 2021-12-16 | Arroyo | Puerto Rico | 72015 | 566 | |
2017199 | 2017199 | 2021-12-15 | Arroyo | Puerto Rico | 72015 | 566 | |
2013949 | 2013949 | 2021-12-14 | Arroyo | Puerto Rico | 72015 | 566 | |
2010698 | 2010698 | 2021-12-13 | Arroyo | Puerto Rico | 72015 | 565 | |
2007447 | 2007447 | 2021-12-12 | Arroyo | Puerto Rico | 72015 | 565 | |
2004196 | 2004196 | 2021-12-11 | Arroyo | Puerto Rico | 72015 | 565 | |
2000945 | 2000945 | 2021-12-10 | Arroyo | Puerto Rico | 72015 | 565 | |
1997695 | 1997695 | 2021-12-09 | Arroyo | Puerto Rico | 72015 | 563 | |
1994444 | 1994444 | 2021-12-08 | Arroyo | Puerto Rico | 72015 | 563 | |
1991193 | 1991193 | 2021-12-07 | Arroyo | Puerto Rico | 72015 | 563 | |
1987942 | 1987942 | 2021-12-06 | Arroyo | Puerto Rico | 72015 | 563 | |
1984692 | 1984692 | 2021-12-05 | Arroyo | Puerto Rico | 72015 | 560 | |
1981442 | 1981442 | 2021-12-04 | Arroyo | Puerto Rico | 72015 | 560 | |
1978192 | 1978192 | 2021-12-03 | Arroyo | Puerto Rico | 72015 | 560 | |
1974942 | 1974942 | 2021-12-02 | Arroyo | Puerto Rico | 72015 | 559 | |
1971693 | 1971693 | 2021-12-01 | Arroyo | Puerto Rico | 72015 | 559 | |
1968443 | 1968443 | 2021-11-30 | Arroyo | Puerto Rico | 72015 | 559 | |
1965192 | 1965192 | 2021-11-29 | Arroyo | Puerto Rico | 72015 | 559 | |
1961940 | 1961940 | 2021-11-28 | Arroyo | Puerto Rico | 72015 | 558 | |
1958689 | 1958689 | 2021-11-27 | Arroyo | Puerto Rico | 72015 | 558 | |
1955438 | 1955438 | 2021-11-26 | Arroyo | Puerto Rico | 72015 | 558 | |
1952187 | 1952187 | 2021-11-25 | Arroyo | Puerto Rico | 72015 | 558 | |
1948936 | 1948936 | 2021-11-24 | Arroyo | Puerto Rico | 72015 | 557 | |
1945685 | 1945685 | 2021-11-23 | Arroyo | Puerto Rico | 72015 | 557 | |
1942434 | 1942434 | 2021-11-22 | Arroyo | Puerto Rico | 72015 | 557 | |
1939184 | 1939184 | 2021-11-21 | Arroyo | Puerto Rico | 72015 | 557 | |
1935934 | 1935934 | 2021-11-20 | Arroyo | Puerto Rico | 72015 | 555 | |
1932684 | 1932684 | 2021-11-19 | Arroyo | Puerto Rico | 72015 | 554 | |
1929433 | 1929433 | 2021-11-18 | Arroyo | Puerto Rico | 72015 | 554 | |
1926183 | 1926183 | 2021-11-17 | Arroyo | Puerto Rico | 72015 | 553 | |
1922933 | 1922933 | 2021-11-16 | Arroyo | Puerto Rico | 72015 | 553 | |
1919684 | 1919684 | 2021-11-15 | Arroyo | Puerto Rico | 72015 | 553 | |
1916434 | 1916434 | 2021-11-14 | Arroyo | Puerto Rico | 72015 | 553 | |
1913184 | 1913184 | 2021-11-13 | Arroyo | Puerto Rico | 72015 | 552 | |
1909934 | 1909934 | 2021-11-12 | Arroyo | Puerto Rico | 72015 | 552 | |
1906685 | 1906685 | 2021-11-11 | Arroyo | Puerto Rico | 72015 | 552 | |
1903436 | 1903436 | 2021-11-10 | Arroyo | Puerto Rico | 72015 | 552 | |
1900186 | 1900186 | 2021-11-09 | Arroyo | Puerto Rico | 72015 | 552 | |
1896936 | 1896936 | 2021-11-08 | Arroyo | Puerto Rico | 72015 | 552 | |
1893686 | 1893686 | 2021-11-07 | Arroyo | Puerto Rico | 72015 | 552 | |
1890436 | 1890436 | 2021-11-06 | Arroyo | Puerto Rico | 72015 | 552 | |
1887186 | 1887186 | 2021-11-05 | Arroyo | Puerto Rico | 72015 | 552 | |
1883936 | 1883936 | 2021-11-04 | Arroyo | Puerto Rico | 72015 | 552 | |
1880687 | 1880687 | 2021-11-03 | Arroyo | Puerto Rico | 72015 | 552 | |
1877438 | 1877438 | 2021-11-02 | Arroyo | Puerto Rico | 72015 | 552 | |
1874189 | 1874189 | 2021-11-01 | Arroyo | Puerto Rico | 72015 | 552 | |
1870940 | 1870940 | 2021-10-31 | Arroyo | Puerto Rico | 72015 | 552 | |
1867691 | 1867691 | 2021-10-30 | Arroyo | Puerto Rico | 72015 | 552 | |
1864442 | 1864442 | 2021-10-29 | Arroyo | Puerto Rico | 72015 | 551 | |
1861193 | 1861193 | 2021-10-28 | Arroyo | Puerto Rico | 72015 | 551 | |
1857944 | 1857944 | 2021-10-27 | Arroyo | Puerto Rico | 72015 | 551 | |
1854695 | 1854695 | 2021-10-26 | Arroyo | Puerto Rico | 72015 | 550 |
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);