ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72035 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 |
---|---|---|---|---|---|---|---|
2176547 | 2176547 | 2022-02-02 | Cayey | Puerto Rico | 72035 | 5494 | |
2173293 | 2173293 | 2022-02-01 | Cayey | Puerto Rico | 72035 | 5474 | |
2170041 | 2170041 | 2022-01-31 | Cayey | Puerto Rico | 72035 | 5473 | |
2166787 | 2166787 | 2022-01-30 | Cayey | Puerto Rico | 72035 | 5466 | |
2163532 | 2163532 | 2022-01-29 | Cayey | Puerto Rico | 72035 | 5454 | |
2160277 | 2160277 | 2022-01-28 | Cayey | Puerto Rico | 72035 | 5444 | |
2157021 | 2157021 | 2022-01-27 | Cayey | Puerto Rico | 72035 | 5419 | |
2153768 | 2153768 | 2022-01-26 | Cayey | Puerto Rico | 72035 | 5401 | |
2150516 | 2150516 | 2022-01-25 | Cayey | Puerto Rico | 72035 | 5350 | |
2147264 | 2147264 | 2022-01-24 | Cayey | Puerto Rico | 72035 | 5343 | |
2144010 | 2144010 | 2022-01-23 | Cayey | Puerto Rico | 72035 | 5325 | |
2140755 | 2140755 | 2022-01-22 | Cayey | Puerto Rico | 72035 | 5282 | |
2137499 | 2137499 | 2022-01-21 | Cayey | Puerto Rico | 72035 | 5201 | |
2134245 | 2134245 | 2022-01-20 | Cayey | Puerto Rico | 72035 | 5143 | |
2130993 | 2130993 | 2022-01-19 | Cayey | Puerto Rico | 72035 | 5095 | |
2127739 | 2127739 | 2022-01-18 | Cayey | Puerto Rico | 72035 | 5017 | |
2124487 | 2124487 | 2022-01-17 | Cayey | Puerto Rico | 72035 | 5004 | |
2121235 | 2121235 | 2022-01-16 | Cayey | Puerto Rico | 72035 | 4962 | |
2117983 | 2117983 | 2022-01-15 | Cayey | Puerto Rico | 72035 | 4885 | |
2114732 | 2114732 | 2022-01-14 | Cayey | Puerto Rico | 72035 | 4722 | |
2111480 | 2111480 | 2022-01-13 | Cayey | Puerto Rico | 72035 | 4572 | |
2108228 | 2108228 | 2022-01-12 | Cayey | Puerto Rico | 72035 | 4372 | |
2104977 | 2104977 | 2022-01-11 | Cayey | Puerto Rico | 72035 | 4257 | |
2101726 | 2101726 | 2022-01-10 | Cayey | Puerto Rico | 72035 | 4227 | |
2098475 | 2098475 | 2022-01-09 | Cayey | Puerto Rico | 72035 | 4191 | |
2095223 | 2095223 | 2022-01-08 | Cayey | Puerto Rico | 72035 | 4041 | |
2091971 | 2091971 | 2022-01-07 | Cayey | Puerto Rico | 72035 | 3983 | |
2088719 | 2088719 | 2022-01-06 | Cayey | Puerto Rico | 72035 | 3853 | |
2085468 | 2085468 | 2022-01-05 | Cayey | Puerto Rico | 72035 | 3697 | |
2082216 | 2082216 | 2022-01-04 | Cayey | Puerto Rico | 72035 | 3582 | |
2078964 | 2078964 | 2022-01-03 | Cayey | Puerto Rico | 72035 | 3571 | |
2075713 | 2075713 | 2022-01-02 | Cayey | Puerto Rico | 72035 | 3510 | |
2072462 | 2072462 | 2022-01-01 | Cayey | Puerto Rico | 72035 | 3149 | |
2069211 | 2069211 | 2021-12-31 | Cayey | Puerto Rico | 72035 | 3149 | |
2065960 | 2065960 | 2021-12-30 | Cayey | Puerto Rico | 72035 | 2910 | |
2062710 | 2062710 | 2021-12-29 | Cayey | Puerto Rico | 72035 | 2770 | |
2059460 | 2059460 | 2021-12-28 | Cayey | Puerto Rico | 72035 | 2660 | |
2056211 | 2056211 | 2021-12-27 | Cayey | Puerto Rico | 72035 | 2646 | |
2052962 | 2052962 | 2021-12-26 | Cayey | Puerto Rico | 72035 | 2624 | |
2049712 | 2049712 | 2021-12-25 | Cayey | Puerto Rico | 72035 | 2571 | |
2046462 | 2046462 | 2021-12-24 | Cayey | Puerto Rico | 72035 | 2314 | |
2043212 | 2043212 | 2021-12-23 | Cayey | Puerto Rico | 72035 | 2314 | |
2039963 | 2039963 | 2021-12-22 | Cayey | Puerto Rico | 72035 | 2243 | |
2036713 | 2036713 | 2021-12-21 | Cayey | Puerto Rico | 72035 | 2203 | |
2033463 | 2033463 | 2021-12-20 | Cayey | Puerto Rico | 72035 | 2196 | |
2030213 | 2030213 | 2021-12-19 | Cayey | Puerto Rico | 72035 | 2173 | |
2026962 | 2026962 | 2021-12-18 | Cayey | Puerto Rico | 72035 | 2132 | |
2023711 | 2023711 | 2021-12-17 | Cayey | Puerto Rico | 72035 | 2117 | |
2020460 | 2020460 | 2021-12-16 | Cayey | Puerto Rico | 72035 | 2099 | |
2017209 | 2017209 | 2021-12-15 | Cayey | Puerto Rico | 72035 | 2096 | |
2013959 | 2013959 | 2021-12-14 | Cayey | Puerto Rico | 72035 | 2095 | |
2010708 | 2010708 | 2021-12-13 | Cayey | Puerto Rico | 72035 | 2095 | |
2007457 | 2007457 | 2021-12-12 | Cayey | Puerto Rico | 72035 | 2095 | |
2004206 | 2004206 | 2021-12-11 | Cayey | Puerto Rico | 72035 | 2095 | |
2000955 | 2000955 | 2021-12-10 | Cayey | Puerto Rico | 72035 | 2095 | |
1997705 | 1997705 | 2021-12-09 | Cayey | Puerto Rico | 72035 | 2093 | |
1994454 | 1994454 | 2021-12-08 | Cayey | Puerto Rico | 72035 | 2089 | |
1991203 | 1991203 | 2021-12-07 | Cayey | Puerto Rico | 72035 | 2088 | |
1987952 | 1987952 | 2021-12-06 | Cayey | Puerto Rico | 72035 | 2088 | |
1984702 | 1984702 | 2021-12-05 | Cayey | Puerto Rico | 72035 | 2088 | |
1981452 | 1981452 | 2021-12-04 | Cayey | Puerto Rico | 72035 | 2086 | |
1978202 | 1978202 | 2021-12-03 | Cayey | Puerto Rico | 72035 | 2083 | |
1974952 | 1974952 | 2021-12-02 | Cayey | Puerto Rico | 72035 | 2081 | |
1971703 | 1971703 | 2021-12-01 | Cayey | Puerto Rico | 72035 | 2080 | |
1968453 | 1968453 | 2021-11-30 | Cayey | Puerto Rico | 72035 | 2078 | |
1965202 | 1965202 | 2021-11-29 | Cayey | Puerto Rico | 72035 | 2078 | |
1961950 | 1961950 | 2021-11-28 | Cayey | Puerto Rico | 72035 | 2077 | |
1958699 | 1958699 | 2021-11-27 | Cayey | Puerto Rico | 72035 | 2073 | |
1955448 | 1955448 | 2021-11-26 | Cayey | Puerto Rico | 72035 | 2073 | |
1952197 | 1952197 | 2021-11-25 | Cayey | Puerto Rico | 72035 | 2069 | |
1948946 | 1948946 | 2021-11-24 | Cayey | Puerto Rico | 72035 | 2067 | |
1945695 | 1945695 | 2021-11-23 | Cayey | Puerto Rico | 72035 | 2066 | |
1942444 | 1942444 | 2021-11-22 | Cayey | Puerto Rico | 72035 | 2066 | |
1939194 | 1939194 | 2021-11-21 | Cayey | Puerto Rico | 72035 | 2066 | |
1935944 | 1935944 | 2021-11-20 | Cayey | Puerto Rico | 72035 | 2064 | |
1932694 | 1932694 | 2021-11-19 | Cayey | Puerto Rico | 72035 | 2062 | |
1929443 | 1929443 | 2021-11-18 | Cayey | Puerto Rico | 72035 | 2060 | |
1926193 | 1926193 | 2021-11-17 | Cayey | Puerto Rico | 72035 | 2059 | |
1922943 | 1922943 | 2021-11-16 | Cayey | Puerto Rico | 72035 | 2058 | |
1919694 | 1919694 | 2021-11-15 | Cayey | Puerto Rico | 72035 | 2058 | |
1916444 | 1916444 | 2021-11-14 | Cayey | Puerto Rico | 72035 | 2058 | |
1913194 | 1913194 | 2021-11-13 | Cayey | Puerto Rico | 72035 | 2058 | |
1909944 | 1909944 | 2021-11-12 | Cayey | Puerto Rico | 72035 | 2054 | |
1906695 | 1906695 | 2021-11-11 | Cayey | Puerto Rico | 72035 | 2054 | |
1903446 | 1903446 | 2021-11-10 | Cayey | Puerto Rico | 72035 | 2051 | |
1900196 | 1900196 | 2021-11-09 | Cayey | Puerto Rico | 72035 | 2047 | |
1896946 | 1896946 | 2021-11-08 | Cayey | Puerto Rico | 72035 | 2047 | |
1893696 | 1893696 | 2021-11-07 | Cayey | Puerto Rico | 72035 | 2047 | |
1890446 | 1890446 | 2021-11-06 | Cayey | Puerto Rico | 72035 | 2047 | |
1887196 | 1887196 | 2021-11-05 | Cayey | Puerto Rico | 72035 | 2046 | |
1883946 | 1883946 | 2021-11-04 | Cayey | Puerto Rico | 72035 | 2044 | |
1880697 | 1880697 | 2021-11-03 | Cayey | Puerto Rico | 72035 | 2041 | |
1877448 | 1877448 | 2021-11-02 | Cayey | Puerto Rico | 72035 | 2041 | |
1874199 | 1874199 | 2021-11-01 | Cayey | Puerto Rico | 72035 | 2041 | |
1870950 | 1870950 | 2021-10-31 | Cayey | Puerto Rico | 72035 | 2041 | |
1867701 | 1867701 | 2021-10-30 | Cayey | Puerto Rico | 72035 | 2040 | |
1864452 | 1864452 | 2021-10-29 | Cayey | Puerto Rico | 72035 | 2035 | |
1861203 | 1861203 | 2021-10-28 | Cayey | Puerto Rico | 72035 | 2032 | |
1857954 | 1857954 | 2021-10-27 | Cayey | Puerto Rico | 72035 | 2030 | |
1854705 | 1854705 | 2021-10-26 | Cayey | Puerto Rico | 72035 | 2029 |
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);