ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72017 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 |
---|---|---|---|---|---|---|---|
2176538 | 2176538 | 2022-02-02 | Barceloneta | Puerto Rico | 72017 | 2991 | |
2173284 | 2173284 | 2022-02-01 | Barceloneta | Puerto Rico | 72017 | 2980 | |
2170032 | 2170032 | 2022-01-31 | Barceloneta | Puerto Rico | 72017 | 2980 | |
2166778 | 2166778 | 2022-01-30 | Barceloneta | Puerto Rico | 72017 | 2975 | |
2163523 | 2163523 | 2022-01-29 | Barceloneta | Puerto Rico | 72017 | 2966 | |
2160268 | 2160268 | 2022-01-28 | Barceloneta | Puerto Rico | 72017 | 2952 | |
2157012 | 2157012 | 2022-01-27 | Barceloneta | Puerto Rico | 72017 | 2925 | |
2153759 | 2153759 | 2022-01-26 | Barceloneta | Puerto Rico | 72017 | 2910 | |
2150507 | 2150507 | 2022-01-25 | Barceloneta | Puerto Rico | 72017 | 2885 | |
2147255 | 2147255 | 2022-01-24 | Barceloneta | Puerto Rico | 72017 | 2885 | |
2144001 | 2144001 | 2022-01-23 | Barceloneta | Puerto Rico | 72017 | 2875 | |
2140746 | 2140746 | 2022-01-22 | Barceloneta | Puerto Rico | 72017 | 2847 | |
2137490 | 2137490 | 2022-01-21 | Barceloneta | Puerto Rico | 72017 | 2784 | |
2134236 | 2134236 | 2022-01-20 | Barceloneta | Puerto Rico | 72017 | 2738 | |
2130984 | 2130984 | 2022-01-19 | Barceloneta | Puerto Rico | 72017 | 2702 | |
2127730 | 2127730 | 2022-01-18 | Barceloneta | Puerto Rico | 72017 | 2684 | |
2124478 | 2124478 | 2022-01-17 | Barceloneta | Puerto Rico | 72017 | 2684 | |
2121226 | 2121226 | 2022-01-16 | Barceloneta | Puerto Rico | 72017 | 2642 | |
2117974 | 2117974 | 2022-01-15 | Barceloneta | Puerto Rico | 72017 | 2620 | |
2114723 | 2114723 | 2022-01-14 | Barceloneta | Puerto Rico | 72017 | 2509 | |
2111471 | 2111471 | 2022-01-13 | Barceloneta | Puerto Rico | 72017 | 2408 | |
2108219 | 2108219 | 2022-01-12 | Barceloneta | Puerto Rico | 72017 | 2318 | |
2104968 | 2104968 | 2022-01-11 | Barceloneta | Puerto Rico | 72017 | 2241 | |
2101717 | 2101717 | 2022-01-10 | Barceloneta | Puerto Rico | 72017 | 2237 | |
2098466 | 2098466 | 2022-01-09 | Barceloneta | Puerto Rico | 72017 | 2194 | |
2095214 | 2095214 | 2022-01-08 | Barceloneta | Puerto Rico | 72017 | 2111 | |
2091962 | 2091962 | 2022-01-07 | Barceloneta | Puerto Rico | 72017 | 2039 | |
2088710 | 2088710 | 2022-01-06 | Barceloneta | Puerto Rico | 72017 | 1945 | |
2085459 | 2085459 | 2022-01-05 | Barceloneta | Puerto Rico | 72017 | 1862 | |
2082207 | 2082207 | 2022-01-04 | Barceloneta | Puerto Rico | 72017 | 1838 | |
2078955 | 2078955 | 2022-01-03 | Barceloneta | Puerto Rico | 72017 | 1823 | |
2075704 | 2075704 | 2022-01-02 | Barceloneta | Puerto Rico | 72017 | 1783 | |
2072453 | 2072453 | 2022-01-01 | Barceloneta | Puerto Rico | 72017 | 1665 | |
2069202 | 2069202 | 2021-12-31 | Barceloneta | Puerto Rico | 72017 | 1665 | |
2065951 | 2065951 | 2021-12-30 | Barceloneta | Puerto Rico | 72017 | 1566 | |
2062701 | 2062701 | 2021-12-29 | Barceloneta | Puerto Rico | 72017 | 1490 | |
2059451 | 2059451 | 2021-12-28 | Barceloneta | Puerto Rico | 72017 | 1443 | |
2056202 | 2056202 | 2021-12-27 | Barceloneta | Puerto Rico | 72017 | 1431 | |
2052953 | 2052953 | 2021-12-26 | Barceloneta | Puerto Rico | 72017 | 1429 | |
2049703 | 2049703 | 2021-12-25 | Barceloneta | Puerto Rico | 72017 | 1407 | |
2046453 | 2046453 | 2021-12-24 | Barceloneta | Puerto Rico | 72017 | 1318 | |
2043203 | 2043203 | 2021-12-23 | Barceloneta | Puerto Rico | 72017 | 1318 | |
2039954 | 2039954 | 2021-12-22 | Barceloneta | Puerto Rico | 72017 | 1288 | |
2036704 | 2036704 | 2021-12-21 | Barceloneta | Puerto Rico | 72017 | 1268 | |
2033454 | 2033454 | 2021-12-20 | Barceloneta | Puerto Rico | 72017 | 1266 | |
2030204 | 2030204 | 2021-12-19 | Barceloneta | Puerto Rico | 72017 | 1252 | |
2026953 | 2026953 | 2021-12-18 | Barceloneta | Puerto Rico | 72017 | 1237 | |
2023702 | 2023702 | 2021-12-17 | Barceloneta | Puerto Rico | 72017 | 1223 | |
2020451 | 2020451 | 2021-12-16 | Barceloneta | Puerto Rico | 72017 | 1221 | |
2017200 | 2017200 | 2021-12-15 | Barceloneta | Puerto Rico | 72017 | 1218 | |
2013950 | 2013950 | 2021-12-14 | Barceloneta | Puerto Rico | 72017 | 1218 | |
2010699 | 2010699 | 2021-12-13 | Barceloneta | Puerto Rico | 72017 | 1218 | |
2007448 | 2007448 | 2021-12-12 | Barceloneta | Puerto Rico | 72017 | 1218 | |
2004197 | 2004197 | 2021-12-11 | Barceloneta | Puerto Rico | 72017 | 1216 | |
2000946 | 2000946 | 2021-12-10 | Barceloneta | Puerto Rico | 72017 | 1216 | |
1997696 | 1997696 | 2021-12-09 | Barceloneta | Puerto Rico | 72017 | 1216 | |
1994445 | 1994445 | 2021-12-08 | Barceloneta | Puerto Rico | 72017 | 1216 | |
1991194 | 1991194 | 2021-12-07 | Barceloneta | Puerto Rico | 72017 | 1214 | |
1987943 | 1987943 | 2021-12-06 | Barceloneta | Puerto Rico | 72017 | 1214 | |
1984693 | 1984693 | 2021-12-05 | Barceloneta | Puerto Rico | 72017 | 1214 | |
1981443 | 1981443 | 2021-12-04 | Barceloneta | Puerto Rico | 72017 | 1213 | |
1978193 | 1978193 | 2021-12-03 | Barceloneta | Puerto Rico | 72017 | 1212 | |
1974943 | 1974943 | 2021-12-02 | Barceloneta | Puerto Rico | 72017 | 1211 | |
1971694 | 1971694 | 2021-12-01 | Barceloneta | Puerto Rico | 72017 | 1211 | |
1968444 | 1968444 | 2021-11-30 | Barceloneta | Puerto Rico | 72017 | 1211 | |
1965193 | 1965193 | 2021-11-29 | Barceloneta | Puerto Rico | 72017 | 1211 | |
1961941 | 1961941 | 2021-11-28 | Barceloneta | Puerto Rico | 72017 | 1210 | |
1958690 | 1958690 | 2021-11-27 | Barceloneta | Puerto Rico | 72017 | 1209 | |
1955439 | 1955439 | 2021-11-26 | Barceloneta | Puerto Rico | 72017 | 1209 | |
1952188 | 1952188 | 2021-11-25 | Barceloneta | Puerto Rico | 72017 | 1209 | |
1948937 | 1948937 | 2021-11-24 | Barceloneta | Puerto Rico | 72017 | 1209 | |
1945686 | 1945686 | 2021-11-23 | Barceloneta | Puerto Rico | 72017 | 1208 | |
1942435 | 1942435 | 2021-11-22 | Barceloneta | Puerto Rico | 72017 | 1208 | |
1939185 | 1939185 | 2021-11-21 | Barceloneta | Puerto Rico | 72017 | 1208 | |
1935935 | 1935935 | 2021-11-20 | Barceloneta | Puerto Rico | 72017 | 1208 | |
1932685 | 1932685 | 2021-11-19 | Barceloneta | Puerto Rico | 72017 | 1204 | |
1929434 | 1929434 | 2021-11-18 | Barceloneta | Puerto Rico | 72017 | 1202 | |
1926184 | 1926184 | 2021-11-17 | Barceloneta | Puerto Rico | 72017 | 1202 | |
1922934 | 1922934 | 2021-11-16 | Barceloneta | Puerto Rico | 72017 | 1201 | |
1919685 | 1919685 | 2021-11-15 | Barceloneta | Puerto Rico | 72017 | 1201 | |
1916435 | 1916435 | 2021-11-14 | Barceloneta | Puerto Rico | 72017 | 1201 | |
1913185 | 1913185 | 2021-11-13 | Barceloneta | Puerto Rico | 72017 | 1201 | |
1909935 | 1909935 | 2021-11-12 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1906686 | 1906686 | 2021-11-11 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1903437 | 1903437 | 2021-11-10 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1900187 | 1900187 | 2021-11-09 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1896937 | 1896937 | 2021-11-08 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1893687 | 1893687 | 2021-11-07 | Barceloneta | Puerto Rico | 72017 | 1199 | |
1890437 | 1890437 | 2021-11-06 | Barceloneta | Puerto Rico | 72017 | 1199 | |
1887187 | 1887187 | 2021-11-05 | Barceloneta | Puerto Rico | 72017 | 1196 | |
1883937 | 1883937 | 2021-11-04 | Barceloneta | Puerto Rico | 72017 | 1195 | |
1880688 | 1880688 | 2021-11-03 | Barceloneta | Puerto Rico | 72017 | 1194 | |
1877439 | 1877439 | 2021-11-02 | Barceloneta | Puerto Rico | 72017 | 1194 | |
1874190 | 1874190 | 2021-11-01 | Barceloneta | Puerto Rico | 72017 | 1194 | |
1870941 | 1870941 | 2021-10-31 | Barceloneta | Puerto Rico | 72017 | 1194 | |
1867692 | 1867692 | 2021-10-30 | Barceloneta | Puerto Rico | 72017 | 1194 | |
1864443 | 1864443 | 2021-10-29 | Barceloneta | Puerto Rico | 72017 | 1193 | |
1861194 | 1861194 | 2021-10-28 | Barceloneta | Puerto Rico | 72017 | 1189 | |
1857945 | 1857945 | 2021-10-27 | Barceloneta | Puerto Rico | 72017 | 1189 | |
1854696 | 1854696 | 2021-10-26 | Barceloneta | Puerto Rico | 72017 | 1189 |
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);