ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72043 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 |
---|---|---|---|---|---|---|---|
2176551 | 2176551 | 2022-02-02 | Coamo | Puerto Rico | 72043 | 4179 | |
2173297 | 2173297 | 2022-02-01 | Coamo | Puerto Rico | 72043 | 4164 | |
2170045 | 2170045 | 2022-01-31 | Coamo | Puerto Rico | 72043 | 4157 | |
2166791 | 2166791 | 2022-01-30 | Coamo | Puerto Rico | 72043 | 4138 | |
2163536 | 2163536 | 2022-01-29 | Coamo | Puerto Rico | 72043 | 4119 | |
2160281 | 2160281 | 2022-01-28 | Coamo | Puerto Rico | 72043 | 4096 | |
2157025 | 2157025 | 2022-01-27 | Coamo | Puerto Rico | 72043 | 4060 | |
2153772 | 2153772 | 2022-01-26 | Coamo | Puerto Rico | 72043 | 4035 | |
2150520 | 2150520 | 2022-01-25 | Coamo | Puerto Rico | 72043 | 4004 | |
2147268 | 2147268 | 2022-01-24 | Coamo | Puerto Rico | 72043 | 3997 | |
2144014 | 2144014 | 2022-01-23 | Coamo | Puerto Rico | 72043 | 3965 | |
2140759 | 2140759 | 2022-01-22 | Coamo | Puerto Rico | 72043 | 3938 | |
2137503 | 2137503 | 2022-01-21 | Coamo | Puerto Rico | 72043 | 3901 | |
2134249 | 2134249 | 2022-01-20 | Coamo | Puerto Rico | 72043 | 3855 | |
2130997 | 2130997 | 2022-01-19 | Coamo | Puerto Rico | 72043 | 3816 | |
2127743 | 2127743 | 2022-01-18 | Coamo | Puerto Rico | 72043 | 3759 | |
2124491 | 2124491 | 2022-01-17 | Coamo | Puerto Rico | 72043 | 3751 | |
2121239 | 2121239 | 2022-01-16 | Coamo | Puerto Rico | 72043 | 3711 | |
2117987 | 2117987 | 2022-01-15 | Coamo | Puerto Rico | 72043 | 3654 | |
2114736 | 2114736 | 2022-01-14 | Coamo | Puerto Rico | 72043 | 3564 | |
2111484 | 2111484 | 2022-01-13 | Coamo | Puerto Rico | 72043 | 3419 | |
2108232 | 2108232 | 2022-01-12 | Coamo | Puerto Rico | 72043 | 3313 | |
2104981 | 2104981 | 2022-01-11 | Coamo | Puerto Rico | 72043 | 3262 | |
2101730 | 2101730 | 2022-01-10 | Coamo | Puerto Rico | 72043 | 3225 | |
2098479 | 2098479 | 2022-01-09 | Coamo | Puerto Rico | 72043 | 3128 | |
2095227 | 2095227 | 2022-01-08 | Coamo | Puerto Rico | 72043 | 3052 | |
2091975 | 2091975 | 2022-01-07 | Coamo | Puerto Rico | 72043 | 3011 | |
2088723 | 2088723 | 2022-01-06 | Coamo | Puerto Rico | 72043 | 2756 | |
2085472 | 2085472 | 2022-01-05 | Coamo | Puerto Rico | 72043 | 2609 | |
2082220 | 2082220 | 2022-01-04 | Coamo | Puerto Rico | 72043 | 2536 | |
2078968 | 2078968 | 2022-01-03 | Coamo | Puerto Rico | 72043 | 2503 | |
2075717 | 2075717 | 2022-01-02 | Coamo | Puerto Rico | 72043 | 2455 | |
2072466 | 2072466 | 2022-01-01 | Coamo | Puerto Rico | 72043 | 2177 | |
2069215 | 2069215 | 2021-12-31 | Coamo | Puerto Rico | 72043 | 2177 | |
2065964 | 2065964 | 2021-12-30 | Coamo | Puerto Rico | 72043 | 2023 | |
2062714 | 2062714 | 2021-12-29 | Coamo | Puerto Rico | 72043 | 1895 | |
2059464 | 2059464 | 2021-12-28 | Coamo | Puerto Rico | 72043 | 1852 | |
2056215 | 2056215 | 2021-12-27 | Coamo | Puerto Rico | 72043 | 1833 | |
2052966 | 2052966 | 2021-12-26 | Coamo | Puerto Rico | 72043 | 1807 | |
2049716 | 2049716 | 2021-12-25 | Coamo | Puerto Rico | 72043 | 1733 | |
2046466 | 2046466 | 2021-12-24 | Coamo | Puerto Rico | 72043 | 1612 | |
2043216 | 2043216 | 2021-12-23 | Coamo | Puerto Rico | 72043 | 1612 | |
2039967 | 2039967 | 2021-12-22 | Coamo | Puerto Rico | 72043 | 1583 | |
2036717 | 2036717 | 2021-12-21 | Coamo | Puerto Rico | 72043 | 1548 | |
2033467 | 2033467 | 2021-12-20 | Coamo | Puerto Rico | 72043 | 1544 | |
2030217 | 2030217 | 2021-12-19 | Coamo | Puerto Rico | 72043 | 1515 | |
2026966 | 2026966 | 2021-12-18 | Coamo | Puerto Rico | 72043 | 1486 | |
2023715 | 2023715 | 2021-12-17 | Coamo | Puerto Rico | 72043 | 1472 | |
2020464 | 2020464 | 2021-12-16 | Coamo | Puerto Rico | 72043 | 1465 | |
2017213 | 2017213 | 2021-12-15 | Coamo | Puerto Rico | 72043 | 1459 | |
2013963 | 2013963 | 2021-12-14 | Coamo | Puerto Rico | 72043 | 1459 | |
2010712 | 2010712 | 2021-12-13 | Coamo | Puerto Rico | 72043 | 1456 | |
2007461 | 2007461 | 2021-12-12 | Coamo | Puerto Rico | 72043 | 1456 | |
2004210 | 2004210 | 2021-12-11 | Coamo | Puerto Rico | 72043 | 1454 | |
2000959 | 2000959 | 2021-12-10 | Coamo | Puerto Rico | 72043 | 1454 | |
1997709 | 1997709 | 2021-12-09 | Coamo | Puerto Rico | 72043 | 1454 | |
1994458 | 1994458 | 2021-12-08 | Coamo | Puerto Rico | 72043 | 1454 | |
1991207 | 1991207 | 2021-12-07 | Coamo | Puerto Rico | 72043 | 1453 | |
1987956 | 1987956 | 2021-12-06 | Coamo | Puerto Rico | 72043 | 1453 | |
1984706 | 1984706 | 2021-12-05 | Coamo | Puerto Rico | 72043 | 1453 | |
1981456 | 1981456 | 2021-12-04 | Coamo | Puerto Rico | 72043 | 1453 | |
1978206 | 1978206 | 2021-12-03 | Coamo | Puerto Rico | 72043 | 1452 | |
1974956 | 1974956 | 2021-12-02 | Coamo | Puerto Rico | 72043 | 1451 | |
1971707 | 1971707 | 2021-12-01 | Coamo | Puerto Rico | 72043 | 1450 | |
1968457 | 1968457 | 2021-11-30 | Coamo | Puerto Rico | 72043 | 1446 | |
1965206 | 1965206 | 2021-11-29 | Coamo | Puerto Rico | 72043 | 1446 | |
1961954 | 1961954 | 2021-11-28 | Coamo | Puerto Rico | 72043 | 1445 | |
1958703 | 1958703 | 2021-11-27 | Coamo | Puerto Rico | 72043 | 1445 | |
1955452 | 1955452 | 2021-11-26 | Coamo | Puerto Rico | 72043 | 1445 | |
1952201 | 1952201 | 2021-11-25 | Coamo | Puerto Rico | 72043 | 1442 | |
1948950 | 1948950 | 2021-11-24 | Coamo | Puerto Rico | 72043 | 1442 | |
1945699 | 1945699 | 2021-11-23 | Coamo | Puerto Rico | 72043 | 1439 | |
1942448 | 1942448 | 2021-11-22 | Coamo | Puerto Rico | 72043 | 1438 | |
1939198 | 1939198 | 2021-11-21 | Coamo | Puerto Rico | 72043 | 1438 | |
1935948 | 1935948 | 2021-11-20 | Coamo | Puerto Rico | 72043 | 1436 | |
1932698 | 1932698 | 2021-11-19 | Coamo | Puerto Rico | 72043 | 1436 | |
1929447 | 1929447 | 2021-11-18 | Coamo | Puerto Rico | 72043 | 1432 | |
1926197 | 1926197 | 2021-11-17 | Coamo | Puerto Rico | 72043 | 1430 | |
1922947 | 1922947 | 2021-11-16 | Coamo | Puerto Rico | 72043 | 1429 | |
1919698 | 1919698 | 2021-11-15 | Coamo | Puerto Rico | 72043 | 1429 | |
1916448 | 1916448 | 2021-11-14 | Coamo | Puerto Rico | 72043 | 1428 | |
1913198 | 1913198 | 2021-11-13 | Coamo | Puerto Rico | 72043 | 1427 | |
1909948 | 1909948 | 2021-11-12 | Coamo | Puerto Rico | 72043 | 1427 | |
1906699 | 1906699 | 2021-11-11 | Coamo | Puerto Rico | 72043 | 1427 | |
1903450 | 1903450 | 2021-11-10 | Coamo | Puerto Rico | 72043 | 1427 | |
1900200 | 1900200 | 2021-11-09 | Coamo | Puerto Rico | 72043 | 1425 | |
1896950 | 1896950 | 2021-11-08 | Coamo | Puerto Rico | 72043 | 1425 | |
1893700 | 1893700 | 2021-11-07 | Coamo | Puerto Rico | 72043 | 1425 | |
1890450 | 1890450 | 2021-11-06 | Coamo | Puerto Rico | 72043 | 1423 | |
1887200 | 1887200 | 2021-11-05 | Coamo | Puerto Rico | 72043 | 1423 | |
1883950 | 1883950 | 2021-11-04 | Coamo | Puerto Rico | 72043 | 1422 | |
1880701 | 1880701 | 2021-11-03 | Coamo | Puerto Rico | 72043 | 1422 | |
1877452 | 1877452 | 2021-11-02 | Coamo | Puerto Rico | 72043 | 1420 | |
1874203 | 1874203 | 2021-11-01 | Coamo | Puerto Rico | 72043 | 1419 | |
1870954 | 1870954 | 2021-10-31 | Coamo | Puerto Rico | 72043 | 1419 | |
1867705 | 1867705 | 2021-10-30 | Coamo | Puerto Rico | 72043 | 1419 | |
1864456 | 1864456 | 2021-10-29 | Coamo | Puerto Rico | 72043 | 1419 | |
1861207 | 1861207 | 2021-10-28 | Coamo | Puerto Rico | 72043 | 1418 | |
1857958 | 1857958 | 2021-10-27 | Coamo | Puerto Rico | 72043 | 1418 | |
1854709 | 1854709 | 2021-10-26 | Coamo | Puerto Rico | 72043 | 1417 |
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);