ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72025 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 |
---|---|---|---|---|---|---|---|
2176542 | 2176542 | 2022-02-02 | Caguas | Puerto Rico | 72025 | 20462 | |
2173288 | 2173288 | 2022-02-01 | Caguas | Puerto Rico | 72025 | 20417 | |
2170036 | 2170036 | 2022-01-31 | Caguas | Puerto Rico | 72025 | 20414 | |
2166782 | 2166782 | 2022-01-30 | Caguas | Puerto Rico | 72025 | 20368 | |
2163527 | 2163527 | 2022-01-29 | Caguas | Puerto Rico | 72025 | 20302 | |
2160272 | 2160272 | 2022-01-28 | Caguas | Puerto Rico | 72025 | 20260 | |
2157016 | 2157016 | 2022-01-27 | Caguas | Puerto Rico | 72025 | 20164 | |
2153763 | 2153763 | 2022-01-26 | Caguas | Puerto Rico | 72025 | 20097 | |
2150511 | 2150511 | 2022-01-25 | Caguas | Puerto Rico | 72025 | 19990 | |
2147259 | 2147259 | 2022-01-24 | Caguas | Puerto Rico | 72025 | 19979 | |
2144005 | 2144005 | 2022-01-23 | Caguas | Puerto Rico | 72025 | 19907 | |
2140750 | 2140750 | 2022-01-22 | Caguas | Puerto Rico | 72025 | 19806 | |
2137494 | 2137494 | 2022-01-21 | Caguas | Puerto Rico | 72025 | 19583 | |
2134240 | 2134240 | 2022-01-20 | Caguas | Puerto Rico | 72025 | 19375 | |
2130988 | 2130988 | 2022-01-19 | Caguas | Puerto Rico | 72025 | 19227 | |
2127734 | 2127734 | 2022-01-18 | Caguas | Puerto Rico | 72025 | 19117 | |
2124482 | 2124482 | 2022-01-17 | Caguas | Puerto Rico | 72025 | 19101 | |
2121230 | 2121230 | 2022-01-16 | Caguas | Puerto Rico | 72025 | 18836 | |
2117978 | 2117978 | 2022-01-15 | Caguas | Puerto Rico | 72025 | 18608 | |
2114727 | 2114727 | 2022-01-14 | Caguas | Puerto Rico | 72025 | 18252 | |
2111475 | 2111475 | 2022-01-13 | Caguas | Puerto Rico | 72025 | 17714 | |
2108223 | 2108223 | 2022-01-12 | Caguas | Puerto Rico | 72025 | 17216 | |
2104972 | 2104972 | 2022-01-11 | Caguas | Puerto Rico | 72025 | 16939 | |
2101721 | 2101721 | 2022-01-10 | Caguas | Puerto Rico | 72025 | 16824 | |
2098470 | 2098470 | 2022-01-09 | Caguas | Puerto Rico | 72025 | 16458 | |
2095218 | 2095218 | 2022-01-08 | Caguas | Puerto Rico | 72025 | 16129 | |
2091966 | 2091966 | 2022-01-07 | Caguas | Puerto Rico | 72025 | 15829 | |
2088714 | 2088714 | 2022-01-06 | Caguas | Puerto Rico | 72025 | 15321 | |
2085463 | 2085463 | 2022-01-05 | Caguas | Puerto Rico | 72025 | 14811 | |
2082211 | 2082211 | 2022-01-04 | Caguas | Puerto Rico | 72025 | 14467 | |
2078959 | 2078959 | 2022-01-03 | Caguas | Puerto Rico | 72025 | 14389 | |
2075708 | 2075708 | 2022-01-02 | Caguas | Puerto Rico | 72025 | 14190 | |
2072457 | 2072457 | 2022-01-01 | Caguas | Puerto Rico | 72025 | 13094 | |
2069206 | 2069206 | 2021-12-31 | Caguas | Puerto Rico | 72025 | 13094 | |
2065955 | 2065955 | 2021-12-30 | Caguas | Puerto Rico | 72025 | 12324 | |
2062705 | 2062705 | 2021-12-29 | Caguas | Puerto Rico | 72025 | 11701 | |
2059455 | 2059455 | 2021-12-28 | Caguas | Puerto Rico | 72025 | 11208 | |
2056206 | 2056206 | 2021-12-27 | Caguas | Puerto Rico | 72025 | 11139 | |
2052957 | 2052957 | 2021-12-26 | Caguas | Puerto Rico | 72025 | 11060 | |
2049707 | 2049707 | 2021-12-25 | Caguas | Puerto Rico | 72025 | 10810 | |
2046457 | 2046457 | 2021-12-24 | Caguas | Puerto Rico | 72025 | 10014 | |
2043207 | 2043207 | 2021-12-23 | Caguas | Puerto Rico | 72025 | 10014 | |
2039958 | 2039958 | 2021-12-22 | Caguas | Puerto Rico | 72025 | 9771 | |
2036708 | 2036708 | 2021-12-21 | Caguas | Puerto Rico | 72025 | 9636 | |
2033458 | 2033458 | 2021-12-20 | Caguas | Puerto Rico | 72025 | 9563 | |
2030208 | 2030208 | 2021-12-19 | Caguas | Puerto Rico | 72025 | 9455 | |
2026957 | 2026957 | 2021-12-18 | Caguas | Puerto Rico | 72025 | 9294 | |
2023706 | 2023706 | 2021-12-17 | Caguas | Puerto Rico | 72025 | 9209 | |
2020455 | 2020455 | 2021-12-16 | Caguas | Puerto Rico | 72025 | 9163 | |
2017204 | 2017204 | 2021-12-15 | Caguas | Puerto Rico | 72025 | 9145 | |
2013954 | 2013954 | 2021-12-14 | Caguas | Puerto Rico | 72025 | 9143 | |
2010703 | 2010703 | 2021-12-13 | Caguas | Puerto Rico | 72025 | 9137 | |
2007452 | 2007452 | 2021-12-12 | Caguas | Puerto Rico | 72025 | 9137 | |
2004201 | 2004201 | 2021-12-11 | Caguas | Puerto Rico | 72025 | 9134 | |
2000950 | 2000950 | 2021-12-10 | Caguas | Puerto Rico | 72025 | 9134 | |
1997700 | 1997700 | 2021-12-09 | Caguas | Puerto Rico | 72025 | 9130 | |
1994449 | 1994449 | 2021-12-08 | Caguas | Puerto Rico | 72025 | 9127 | |
1991198 | 1991198 | 2021-12-07 | Caguas | Puerto Rico | 72025 | 9124 | |
1987947 | 1987947 | 2021-12-06 | Caguas | Puerto Rico | 72025 | 9122 | |
1984697 | 1984697 | 2021-12-05 | Caguas | Puerto Rico | 72025 | 9118 | |
1981447 | 1981447 | 2021-12-04 | Caguas | Puerto Rico | 72025 | 9110 | |
1978197 | 1978197 | 2021-12-03 | Caguas | Puerto Rico | 72025 | 9103 | |
1974947 | 1974947 | 2021-12-02 | Caguas | Puerto Rico | 72025 | 9096 | |
1971698 | 1971698 | 2021-12-01 | Caguas | Puerto Rico | 72025 | 9092 | |
1968448 | 1968448 | 2021-11-30 | Caguas | Puerto Rico | 72025 | 9086 | |
1965197 | 1965197 | 2021-11-29 | Caguas | Puerto Rico | 72025 | 9086 | |
1961945 | 1961945 | 2021-11-28 | Caguas | Puerto Rico | 72025 | 9082 | |
1958694 | 1958694 | 2021-11-27 | Caguas | Puerto Rico | 72025 | 9082 | |
1955443 | 1955443 | 2021-11-26 | Caguas | Puerto Rico | 72025 | 9078 | |
1952192 | 1952192 | 2021-11-25 | Caguas | Puerto Rico | 72025 | 9074 | |
1948941 | 1948941 | 2021-11-24 | Caguas | Puerto Rico | 72025 | 9065 | |
1945690 | 1945690 | 2021-11-23 | Caguas | Puerto Rico | 72025 | 9059 | |
1942439 | 1942439 | 2021-11-22 | Caguas | Puerto Rico | 72025 | 9059 | |
1939189 | 1939189 | 2021-11-21 | Caguas | Puerto Rico | 72025 | 9056 | |
1935939 | 1935939 | 2021-11-20 | Caguas | Puerto Rico | 72025 | 9052 | |
1932689 | 1932689 | 2021-11-19 | Caguas | Puerto Rico | 72025 | 9041 | |
1929438 | 1929438 | 2021-11-18 | Caguas | Puerto Rico | 72025 | 9033 | |
1926188 | 1926188 | 2021-11-17 | Caguas | Puerto Rico | 72025 | 9016 | |
1922938 | 1922938 | 2021-11-16 | Caguas | Puerto Rico | 72025 | 9007 | |
1919689 | 1919689 | 2021-11-15 | Caguas | Puerto Rico | 72025 | 9006 | |
1916439 | 1916439 | 2021-11-14 | Caguas | Puerto Rico | 72025 | 8994 | |
1913189 | 1913189 | 2021-11-13 | Caguas | Puerto Rico | 72025 | 8984 | |
1909939 | 1909939 | 2021-11-12 | Caguas | Puerto Rico | 72025 | 8981 | |
1906690 | 1906690 | 2021-11-11 | Caguas | Puerto Rico | 72025 | 8978 | |
1903441 | 1903441 | 2021-11-10 | Caguas | Puerto Rico | 72025 | 8976 | |
1900191 | 1900191 | 2021-11-09 | Caguas | Puerto Rico | 72025 | 8973 | |
1896941 | 1896941 | 2021-11-08 | Caguas | Puerto Rico | 72025 | 8969 | |
1893691 | 1893691 | 2021-11-07 | Caguas | Puerto Rico | 72025 | 8968 | |
1890441 | 1890441 | 2021-11-06 | Caguas | Puerto Rico | 72025 | 8962 | |
1887191 | 1887191 | 2021-11-05 | Caguas | Puerto Rico | 72025 | 8953 | |
1883941 | 1883941 | 2021-11-04 | Caguas | Puerto Rico | 72025 | 8946 | |
1880692 | 1880692 | 2021-11-03 | Caguas | Puerto Rico | 72025 | 8942 | |
1877443 | 1877443 | 2021-11-02 | Caguas | Puerto Rico | 72025 | 8939 | |
1874194 | 1874194 | 2021-11-01 | Caguas | Puerto Rico | 72025 | 8939 | |
1870945 | 1870945 | 2021-10-31 | Caguas | Puerto Rico | 72025 | 8936 | |
1867696 | 1867696 | 2021-10-30 | Caguas | Puerto Rico | 72025 | 8934 | |
1864447 | 1864447 | 2021-10-29 | Caguas | Puerto Rico | 72025 | 8930 | |
1861198 | 1861198 | 2021-10-28 | Caguas | Puerto Rico | 72025 | 8927 | |
1857949 | 1857949 | 2021-10-27 | Caguas | Puerto Rico | 72025 | 8922 | |
1854700 | 1854700 | 2021-10-26 | Caguas | Puerto Rico | 72025 | 8921 |
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);