ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72059 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 |
---|---|---|---|---|---|---|---|
2173306 | 2173306 | 2022-02-01 | Guayanilla | Puerto Rico | 72059 | 1884 | |
2170054 | 2170054 | 2022-01-31 | Guayanilla | Puerto Rico | 72059 | 1884 | |
2166800 | 2166800 | 2022-01-30 | Guayanilla | Puerto Rico | 72059 | 1883 | |
2163545 | 2163545 | 2022-01-29 | Guayanilla | Puerto Rico | 72059 | 1872 | |
2160290 | 2160290 | 2022-01-28 | Guayanilla | Puerto Rico | 72059 | 1862 | |
2157034 | 2157034 | 2022-01-27 | Guayanilla | Puerto Rico | 72059 | 1825 | |
2153781 | 2153781 | 2022-01-26 | Guayanilla | Puerto Rico | 72059 | 1813 | |
2150529 | 2150529 | 2022-01-25 | Guayanilla | Puerto Rico | 72059 | 1777 | |
2147277 | 2147277 | 2022-01-24 | Guayanilla | Puerto Rico | 72059 | 1776 | |
2144023 | 2144023 | 2022-01-23 | Guayanilla | Puerto Rico | 72059 | 1750 | |
2140768 | 2140768 | 2022-01-22 | Guayanilla | Puerto Rico | 72059 | 1728 | |
2137512 | 2137512 | 2022-01-21 | Guayanilla | Puerto Rico | 72059 | 1695 | |
2134258 | 2134258 | 2022-01-20 | Guayanilla | Puerto Rico | 72059 | 1666 | |
2131006 | 2131006 | 2022-01-19 | Guayanilla | Puerto Rico | 72059 | 1627 | |
2127752 | 2127752 | 2022-01-18 | Guayanilla | Puerto Rico | 72059 | 1596 | |
2124500 | 2124500 | 2022-01-17 | Guayanilla | Puerto Rico | 72059 | 1594 | |
2121248 | 2121248 | 2022-01-16 | Guayanilla | Puerto Rico | 72059 | 1565 | |
2117996 | 2117996 | 2022-01-15 | Guayanilla | Puerto Rico | 72059 | 1547 | |
2114745 | 2114745 | 2022-01-14 | Guayanilla | Puerto Rico | 72059 | 1488 | |
2111493 | 2111493 | 2022-01-13 | Guayanilla | Puerto Rico | 72059 | 1435 | |
2108241 | 2108241 | 2022-01-12 | Guayanilla | Puerto Rico | 72059 | 1346 | |
2104990 | 2104990 | 2022-01-11 | Guayanilla | Puerto Rico | 72059 | 1285 | |
2101739 | 2101739 | 2022-01-10 | Guayanilla | Puerto Rico | 72059 | 1283 | |
2098488 | 2098488 | 2022-01-09 | Guayanilla | Puerto Rico | 72059 | 1263 | |
2095236 | 2095236 | 2022-01-08 | Guayanilla | Puerto Rico | 72059 | 1204 | |
2091984 | 2091984 | 2022-01-07 | Guayanilla | Puerto Rico | 72059 | 1195 | |
2088732 | 2088732 | 2022-01-06 | Guayanilla | Puerto Rico | 72059 | 1143 | |
2085481 | 2085481 | 2022-01-05 | Guayanilla | Puerto Rico | 72059 | 1049 | |
2082229 | 2082229 | 2022-01-04 | Guayanilla | Puerto Rico | 72059 | 1013 | |
2078977 | 2078977 | 2022-01-03 | Guayanilla | Puerto Rico | 72059 | 1010 | |
2075726 | 2075726 | 2022-01-02 | Guayanilla | Puerto Rico | 72059 | 1002 | |
2072475 | 2072475 | 2022-01-01 | Guayanilla | Puerto Rico | 72059 | 935 | |
2069224 | 2069224 | 2021-12-31 | Guayanilla | Puerto Rico | 72059 | 935 | |
2065973 | 2065973 | 2021-12-30 | Guayanilla | Puerto Rico | 72059 | 887 | |
2062723 | 2062723 | 2021-12-29 | Guayanilla | Puerto Rico | 72059 | 857 | |
2059473 | 2059473 | 2021-12-28 | Guayanilla | Puerto Rico | 72059 | 829 | |
2056224 | 2056224 | 2021-12-27 | Guayanilla | Puerto Rico | 72059 | 829 | |
2052975 | 2052975 | 2021-12-26 | Guayanilla | Puerto Rico | 72059 | 829 | |
2049725 | 2049725 | 2021-12-25 | Guayanilla | Puerto Rico | 72059 | 822 | |
2046475 | 2046475 | 2021-12-24 | Guayanilla | Puerto Rico | 72059 | 768 | |
2043225 | 2043225 | 2021-12-23 | Guayanilla | Puerto Rico | 72059 | 768 | |
2039976 | 2039976 | 2021-12-22 | Guayanilla | Puerto Rico | 72059 | 750 | |
2036726 | 2036726 | 2021-12-21 | Guayanilla | Puerto Rico | 72059 | 737 | |
2033476 | 2033476 | 2021-12-20 | Guayanilla | Puerto Rico | 72059 | 734 | |
2030226 | 2030226 | 2021-12-19 | Guayanilla | Puerto Rico | 72059 | 730 | |
2026975 | 2026975 | 2021-12-18 | Guayanilla | Puerto Rico | 72059 | 724 | |
2023724 | 2023724 | 2021-12-17 | Guayanilla | Puerto Rico | 72059 | 717 | |
2020473 | 2020473 | 2021-12-16 | Guayanilla | Puerto Rico | 72059 | 716 | |
2017222 | 2017222 | 2021-12-15 | Guayanilla | Puerto Rico | 72059 | 716 | |
2013972 | 2013972 | 2021-12-14 | Guayanilla | Puerto Rico | 72059 | 715 | |
2010721 | 2010721 | 2021-12-13 | Guayanilla | Puerto Rico | 72059 | 715 | |
2007470 | 2007470 | 2021-12-12 | Guayanilla | Puerto Rico | 72059 | 715 | |
2004219 | 2004219 | 2021-12-11 | Guayanilla | Puerto Rico | 72059 | 715 | |
2000968 | 2000968 | 2021-12-10 | Guayanilla | Puerto Rico | 72059 | 715 | |
1997718 | 1997718 | 2021-12-09 | Guayanilla | Puerto Rico | 72059 | 714 | |
1994467 | 1994467 | 2021-12-08 | Guayanilla | Puerto Rico | 72059 | 714 | |
1991216 | 1991216 | 2021-12-07 | Guayanilla | Puerto Rico | 72059 | 714 | |
1987965 | 1987965 | 2021-12-06 | Guayanilla | Puerto Rico | 72059 | 713 | |
1984715 | 1984715 | 2021-12-05 | Guayanilla | Puerto Rico | 72059 | 712 | |
1981465 | 1981465 | 2021-12-04 | Guayanilla | Puerto Rico | 72059 | 712 | |
1978215 | 1978215 | 2021-12-03 | Guayanilla | Puerto Rico | 72059 | 711 | |
1974965 | 1974965 | 2021-12-02 | Guayanilla | Puerto Rico | 72059 | 709 | |
1971716 | 1971716 | 2021-12-01 | Guayanilla | Puerto Rico | 72059 | 707 | |
1968466 | 1968466 | 2021-11-30 | Guayanilla | Puerto Rico | 72059 | 706 | |
1965215 | 1965215 | 2021-11-29 | Guayanilla | Puerto Rico | 72059 | 706 | |
1961963 | 1961963 | 2021-11-28 | Guayanilla | Puerto Rico | 72059 | 706 | |
1958712 | 1958712 | 2021-11-27 | Guayanilla | Puerto Rico | 72059 | 706 | |
1955461 | 1955461 | 2021-11-26 | Guayanilla | Puerto Rico | 72059 | 706 | |
1952210 | 1952210 | 2021-11-25 | Guayanilla | Puerto Rico | 72059 | 706 | |
1948959 | 1948959 | 2021-11-24 | Guayanilla | Puerto Rico | 72059 | 703 | |
1945708 | 1945708 | 2021-11-23 | Guayanilla | Puerto Rico | 72059 | 702 | |
1942457 | 1942457 | 2021-11-22 | Guayanilla | Puerto Rico | 72059 | 702 | |
1939207 | 1939207 | 2021-11-21 | Guayanilla | Puerto Rico | 72059 | 702 | |
1935957 | 1935957 | 2021-11-20 | Guayanilla | Puerto Rico | 72059 | 701 | |
1932707 | 1932707 | 2021-11-19 | Guayanilla | Puerto Rico | 72059 | 700 | |
1929456 | 1929456 | 2021-11-18 | Guayanilla | Puerto Rico | 72059 | 699 | |
1926206 | 1926206 | 2021-11-17 | Guayanilla | Puerto Rico | 72059 | 699 | |
1922956 | 1922956 | 2021-11-16 | Guayanilla | Puerto Rico | 72059 | 699 | |
1919707 | 1919707 | 2021-11-15 | Guayanilla | Puerto Rico | 72059 | 699 | |
1916457 | 1916457 | 2021-11-14 | Guayanilla | Puerto Rico | 72059 | 699 | |
1913207 | 1913207 | 2021-11-13 | Guayanilla | Puerto Rico | 72059 | 699 | |
1909957 | 1909957 | 2021-11-12 | Guayanilla | Puerto Rico | 72059 | 698 | |
1906708 | 1906708 | 2021-11-11 | Guayanilla | Puerto Rico | 72059 | 698 | |
1903459 | 1903459 | 2021-11-10 | Guayanilla | Puerto Rico | 72059 | 697 | |
1900209 | 1900209 | 2021-11-09 | Guayanilla | Puerto Rico | 72059 | 697 | |
1896959 | 1896959 | 2021-11-08 | Guayanilla | Puerto Rico | 72059 | 697 | |
1893709 | 1893709 | 2021-11-07 | Guayanilla | Puerto Rico | 72059 | 697 | |
1890459 | 1890459 | 2021-11-06 | Guayanilla | Puerto Rico | 72059 | 694 | |
1887209 | 1887209 | 2021-11-05 | Guayanilla | Puerto Rico | 72059 | 692 | |
1883959 | 1883959 | 2021-11-04 | Guayanilla | Puerto Rico | 72059 | 691 | |
1880710 | 1880710 | 2021-11-03 | Guayanilla | Puerto Rico | 72059 | 691 | |
1877461 | 1877461 | 2021-11-02 | Guayanilla | Puerto Rico | 72059 | 690 | |
1874212 | 1874212 | 2021-11-01 | Guayanilla | Puerto Rico | 72059 | 690 | |
1870963 | 1870963 | 2021-10-31 | Guayanilla | Puerto Rico | 72059 | 690 | |
1867714 | 1867714 | 2021-10-30 | Guayanilla | Puerto Rico | 72059 | 690 | |
1864465 | 1864465 | 2021-10-29 | Guayanilla | Puerto Rico | 72059 | 690 | |
1861216 | 1861216 | 2021-10-28 | Guayanilla | Puerto Rico | 72059 | 687 | |
1857967 | 1857967 | 2021-10-27 | Guayanilla | Puerto Rico | 72059 | 686 | |
1854718 | 1854718 | 2021-10-26 | Guayanilla | Puerto Rico | 72059 | 684 | |
1851469 | 1851469 | 2021-10-25 | Guayanilla | Puerto Rico | 72059 | 684 |
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);