ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72054 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 |
---|---|---|---|---|---|---|---|
2176557 | 2176557 | 2022-02-02 | Florida | Puerto Rico | 72054 | 2295 | |
2173303 | 2173303 | 2022-02-01 | Florida | Puerto Rico | 72054 | 2282 | |
2170051 | 2170051 | 2022-01-31 | Florida | Puerto Rico | 72054 | 2282 | |
2166797 | 2166797 | 2022-01-30 | Florida | Puerto Rico | 72054 | 2280 | |
2163542 | 2163542 | 2022-01-29 | Florida | Puerto Rico | 72054 | 2266 | |
2160287 | 2160287 | 2022-01-28 | Florida | Puerto Rico | 72054 | 2240 | |
2157031 | 2157031 | 2022-01-27 | Florida | Puerto Rico | 72054 | 2219 | |
2153778 | 2153778 | 2022-01-26 | Florida | Puerto Rico | 72054 | 2206 | |
2150526 | 2150526 | 2022-01-25 | Florida | Puerto Rico | 72054 | 2189 | |
2147274 | 2147274 | 2022-01-24 | Florida | Puerto Rico | 72054 | 2188 | |
2144020 | 2144020 | 2022-01-23 | Florida | Puerto Rico | 72054 | 2183 | |
2140765 | 2140765 | 2022-01-22 | Florida | Puerto Rico | 72054 | 2174 | |
2137509 | 2137509 | 2022-01-21 | Florida | Puerto Rico | 72054 | 2115 | |
2134255 | 2134255 | 2022-01-20 | Florida | Puerto Rico | 72054 | 2087 | |
2131003 | 2131003 | 2022-01-19 | Florida | Puerto Rico | 72054 | 2062 | |
2127749 | 2127749 | 2022-01-18 | Florida | Puerto Rico | 72054 | 2043 | |
2124497 | 2124497 | 2022-01-17 | Florida | Puerto Rico | 72054 | 2042 | |
2121245 | 2121245 | 2022-01-16 | Florida | Puerto Rico | 72054 | 2014 | |
2117993 | 2117993 | 2022-01-15 | Florida | Puerto Rico | 72054 | 1991 | |
2114742 | 2114742 | 2022-01-14 | Florida | Puerto Rico | 72054 | 1915 | |
2111490 | 2111490 | 2022-01-13 | Florida | Puerto Rico | 72054 | 1855 | |
2108238 | 2108238 | 2022-01-12 | Florida | Puerto Rico | 72054 | 1780 | |
2104987 | 2104987 | 2022-01-11 | Florida | Puerto Rico | 72054 | 1727 | |
2101736 | 2101736 | 2022-01-10 | Florida | Puerto Rico | 72054 | 1724 | |
2098485 | 2098485 | 2022-01-09 | Florida | Puerto Rico | 72054 | 1685 | |
2095233 | 2095233 | 2022-01-08 | Florida | Puerto Rico | 72054 | 1635 | |
2091981 | 2091981 | 2022-01-07 | Florida | Puerto Rico | 72054 | 1598 | |
2088729 | 2088729 | 2022-01-06 | Florida | Puerto Rico | 72054 | 1532 | |
2085478 | 2085478 | 2022-01-05 | Florida | Puerto Rico | 72054 | 1430 | |
2082226 | 2082226 | 2022-01-04 | Florida | Puerto Rico | 72054 | 1406 | |
2078974 | 2078974 | 2022-01-03 | Florida | Puerto Rico | 72054 | 1399 | |
2075723 | 2075723 | 2022-01-02 | Florida | Puerto Rico | 72054 | 1358 | |
2072472 | 2072472 | 2022-01-01 | Florida | Puerto Rico | 72054 | 1245 | |
2069221 | 2069221 | 2021-12-31 | Florida | Puerto Rico | 72054 | 1245 | |
2065970 | 2065970 | 2021-12-30 | Florida | Puerto Rico | 72054 | 1168 | |
2062720 | 2062720 | 2021-12-29 | Florida | Puerto Rico | 72054 | 1122 | |
2059470 | 2059470 | 2021-12-28 | Florida | Puerto Rico | 72054 | 1107 | |
2056221 | 2056221 | 2021-12-27 | Florida | Puerto Rico | 72054 | 1102 | |
2052972 | 2052972 | 2021-12-26 | Florida | Puerto Rico | 72054 | 1100 | |
2049722 | 2049722 | 2021-12-25 | Florida | Puerto Rico | 72054 | 1079 | |
2046472 | 2046472 | 2021-12-24 | Florida | Puerto Rico | 72054 | 1030 | |
2043222 | 2043222 | 2021-12-23 | Florida | Puerto Rico | 72054 | 1030 | |
2039973 | 2039973 | 2021-12-22 | Florida | Puerto Rico | 72054 | 1017 | |
2036723 | 2036723 | 2021-12-21 | Florida | Puerto Rico | 72054 | 1015 | |
2033473 | 2033473 | 2021-12-20 | Florida | Puerto Rico | 72054 | 1015 | |
2030223 | 2030223 | 2021-12-19 | Florida | Puerto Rico | 72054 | 1012 | |
2026972 | 2026972 | 2021-12-18 | Florida | Puerto Rico | 72054 | 1012 | |
2023721 | 2023721 | 2021-12-17 | Florida | Puerto Rico | 72054 | 1011 | |
2020470 | 2020470 | 2021-12-16 | Florida | Puerto Rico | 72054 | 1010 | |
2017219 | 2017219 | 2021-12-15 | Florida | Puerto Rico | 72054 | 1010 | |
2013969 | 2013969 | 2021-12-14 | Florida | Puerto Rico | 72054 | 1010 | |
2010718 | 2010718 | 2021-12-13 | Florida | Puerto Rico | 72054 | 1010 | |
2007467 | 2007467 | 2021-12-12 | Florida | Puerto Rico | 72054 | 1010 | |
2004216 | 2004216 | 2021-12-11 | Florida | Puerto Rico | 72054 | 1010 | |
2000965 | 2000965 | 2021-12-10 | Florida | Puerto Rico | 72054 | 1010 | |
1997715 | 1997715 | 2021-12-09 | Florida | Puerto Rico | 72054 | 1010 | |
1994464 | 1994464 | 2021-12-08 | Florida | Puerto Rico | 72054 | 1010 | |
1991213 | 1991213 | 2021-12-07 | Florida | Puerto Rico | 72054 | 1010 | |
1987962 | 1987962 | 2021-12-06 | Florida | Puerto Rico | 72054 | 1010 | |
1984712 | 1984712 | 2021-12-05 | Florida | Puerto Rico | 72054 | 1010 | |
1981462 | 1981462 | 2021-12-04 | Florida | Puerto Rico | 72054 | 1009 | |
1978212 | 1978212 | 2021-12-03 | Florida | Puerto Rico | 72054 | 1008 | |
1974962 | 1974962 | 2021-12-02 | Florida | Puerto Rico | 72054 | 1006 | |
1971713 | 1971713 | 2021-12-01 | Florida | Puerto Rico | 72054 | 1006 | |
1968463 | 1968463 | 2021-11-30 | Florida | Puerto Rico | 72054 | 1006 | |
1965212 | 1965212 | 2021-11-29 | Florida | Puerto Rico | 72054 | 1006 | |
1961960 | 1961960 | 2021-11-28 | Florida | Puerto Rico | 72054 | 1006 | |
1958709 | 1958709 | 2021-11-27 | Florida | Puerto Rico | 72054 | 1006 | |
1955458 | 1955458 | 2021-11-26 | Florida | Puerto Rico | 72054 | 1005 | |
1952207 | 1952207 | 2021-11-25 | Florida | Puerto Rico | 72054 | 1005 | |
1948956 | 1948956 | 2021-11-24 | Florida | Puerto Rico | 72054 | 1005 | |
1945705 | 1945705 | 2021-11-23 | Florida | Puerto Rico | 72054 | 1005 | |
1942454 | 1942454 | 2021-11-22 | Florida | Puerto Rico | 72054 | 1005 | |
1939204 | 1939204 | 2021-11-21 | Florida | Puerto Rico | 72054 | 1005 | |
1935954 | 1935954 | 2021-11-20 | Florida | Puerto Rico | 72054 | 1005 | |
1932704 | 1932704 | 2021-11-19 | Florida | Puerto Rico | 72054 | 1005 | |
1929453 | 1929453 | 2021-11-18 | Florida | Puerto Rico | 72054 | 1005 | |
1926203 | 1926203 | 2021-11-17 | Florida | Puerto Rico | 72054 | 1005 | |
1922953 | 1922953 | 2021-11-16 | Florida | Puerto Rico | 72054 | 1005 | |
1919704 | 1919704 | 2021-11-15 | Florida | Puerto Rico | 72054 | 1005 | |
1916454 | 1916454 | 2021-11-14 | Florida | Puerto Rico | 72054 | 1005 | |
1913204 | 1913204 | 2021-11-13 | Florida | Puerto Rico | 72054 | 1005 | |
1909954 | 1909954 | 2021-11-12 | Florida | Puerto Rico | 72054 | 1004 | |
1906705 | 1906705 | 2021-11-11 | Florida | Puerto Rico | 72054 | 1004 | |
1903456 | 1903456 | 2021-11-10 | Florida | Puerto Rico | 72054 | 1004 | |
1900206 | 1900206 | 2021-11-09 | Florida | Puerto Rico | 72054 | 1004 | |
1896956 | 1896956 | 2021-11-08 | Florida | Puerto Rico | 72054 | 1004 | |
1893706 | 1893706 | 2021-11-07 | Florida | Puerto Rico | 72054 | 1003 | |
1890456 | 1890456 | 2021-11-06 | Florida | Puerto Rico | 72054 | 1002 | |
1887206 | 1887206 | 2021-11-05 | Florida | Puerto Rico | 72054 | 1001 | |
1883956 | 1883956 | 2021-11-04 | Florida | Puerto Rico | 72054 | 1001 | |
1880707 | 1880707 | 2021-11-03 | Florida | Puerto Rico | 72054 | 1001 | |
1877458 | 1877458 | 2021-11-02 | Florida | Puerto Rico | 72054 | 1001 | |
1874209 | 1874209 | 2021-11-01 | Florida | Puerto Rico | 72054 | 1001 | |
1870960 | 1870960 | 2021-10-31 | Florida | Puerto Rico | 72054 | 1000 | |
1867711 | 1867711 | 2021-10-30 | Florida | Puerto Rico | 72054 | 1000 | |
1864462 | 1864462 | 2021-10-29 | Florida | Puerto Rico | 72054 | 1000 | |
1861213 | 1861213 | 2021-10-28 | Florida | Puerto Rico | 72054 | 997 | |
1857964 | 1857964 | 2021-10-27 | Florida | Puerto Rico | 72054 | 997 | |
1854715 | 1854715 | 2021-10-26 | Florida | Puerto Rico | 72054 | 997 |
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);