ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72045 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 |
---|---|---|---|---|---|---|---|
2176552 | 2176552 | 2022-02-02 | Comerio | Puerto Rico | 72045 | 2673 | |
2173298 | 2173298 | 2022-02-01 | Comerio | Puerto Rico | 72045 | 2656 | |
2170046 | 2170046 | 2022-01-31 | Comerio | Puerto Rico | 72045 | 2655 | |
2166792 | 2166792 | 2022-01-30 | Comerio | Puerto Rico | 72045 | 2650 | |
2163537 | 2163537 | 2022-01-29 | Comerio | Puerto Rico | 72045 | 2641 | |
2160282 | 2160282 | 2022-01-28 | Comerio | Puerto Rico | 72045 | 2637 | |
2157026 | 2157026 | 2022-01-27 | Comerio | Puerto Rico | 72045 | 2613 | |
2153773 | 2153773 | 2022-01-26 | Comerio | Puerto Rico | 72045 | 2594 | |
2150521 | 2150521 | 2022-01-25 | Comerio | Puerto Rico | 72045 | 2570 | |
2147269 | 2147269 | 2022-01-24 | Comerio | Puerto Rico | 72045 | 2568 | |
2144015 | 2144015 | 2022-01-23 | Comerio | Puerto Rico | 72045 | 2562 | |
2140760 | 2140760 | 2022-01-22 | Comerio | Puerto Rico | 72045 | 2546 | |
2137504 | 2137504 | 2022-01-21 | Comerio | Puerto Rico | 72045 | 2505 | |
2134250 | 2134250 | 2022-01-20 | Comerio | Puerto Rico | 72045 | 2469 | |
2130998 | 2130998 | 2022-01-19 | Comerio | Puerto Rico | 72045 | 2450 | |
2127744 | 2127744 | 2022-01-18 | Comerio | Puerto Rico | 72045 | 2404 | |
2124492 | 2124492 | 2022-01-17 | Comerio | Puerto Rico | 72045 | 2403 | |
2121240 | 2121240 | 2022-01-16 | Comerio | Puerto Rico | 72045 | 2368 | |
2117988 | 2117988 | 2022-01-15 | Comerio | Puerto Rico | 72045 | 2342 | |
2114737 | 2114737 | 2022-01-14 | Comerio | Puerto Rico | 72045 | 2303 | |
2111485 | 2111485 | 2022-01-13 | Comerio | Puerto Rico | 72045 | 2216 | |
2108233 | 2108233 | 2022-01-12 | Comerio | Puerto Rico | 72045 | 2059 | |
2104982 | 2104982 | 2022-01-11 | Comerio | Puerto Rico | 72045 | 1971 | |
2101731 | 2101731 | 2022-01-10 | Comerio | Puerto Rico | 72045 | 1957 | |
2098480 | 2098480 | 2022-01-09 | Comerio | Puerto Rico | 72045 | 1923 | |
2095228 | 2095228 | 2022-01-08 | Comerio | Puerto Rico | 72045 | 1889 | |
2091976 | 2091976 | 2022-01-07 | Comerio | Puerto Rico | 72045 | 1862 | |
2088724 | 2088724 | 2022-01-06 | Comerio | Puerto Rico | 72045 | 1776 | |
2085473 | 2085473 | 2022-01-05 | Comerio | Puerto Rico | 72045 | 1706 | |
2082221 | 2082221 | 2022-01-04 | Comerio | Puerto Rico | 72045 | 1565 | |
2078969 | 2078969 | 2022-01-03 | Comerio | Puerto Rico | 72045 | 1554 | |
2075718 | 2075718 | 2022-01-02 | Comerio | Puerto Rico | 72045 | 1500 | |
2072467 | 2072467 | 2022-01-01 | Comerio | Puerto Rico | 72045 | 1412 | |
2069216 | 2069216 | 2021-12-31 | Comerio | Puerto Rico | 72045 | 1412 | |
2065965 | 2065965 | 2021-12-30 | Comerio | Puerto Rico | 72045 | 1385 | |
2062715 | 2062715 | 2021-12-29 | Comerio | Puerto Rico | 72045 | 1310 | |
2059465 | 2059465 | 2021-12-28 | Comerio | Puerto Rico | 72045 | 1277 | |
2056216 | 2056216 | 2021-12-27 | Comerio | Puerto Rico | 72045 | 1259 | |
2052967 | 2052967 | 2021-12-26 | Comerio | Puerto Rico | 72045 | 1255 | |
2049717 | 2049717 | 2021-12-25 | Comerio | Puerto Rico | 72045 | 1232 | |
2046467 | 2046467 | 2021-12-24 | Comerio | Puerto Rico | 72045 | 1159 | |
2043217 | 2043217 | 2021-12-23 | Comerio | Puerto Rico | 72045 | 1159 | |
2039968 | 2039968 | 2021-12-22 | Comerio | Puerto Rico | 72045 | 1122 | |
2036718 | 2036718 | 2021-12-21 | Comerio | Puerto Rico | 72045 | 1110 | |
2033468 | 2033468 | 2021-12-20 | Comerio | Puerto Rico | 72045 | 1110 | |
2030218 | 2030218 | 2021-12-19 | Comerio | Puerto Rico | 72045 | 1110 | |
2026967 | 2026967 | 2021-12-18 | Comerio | Puerto Rico | 72045 | 1103 | |
2023716 | 2023716 | 2021-12-17 | Comerio | Puerto Rico | 72045 | 1092 | |
2020465 | 2020465 | 2021-12-16 | Comerio | Puerto Rico | 72045 | 1089 | |
2017214 | 2017214 | 2021-12-15 | Comerio | Puerto Rico | 72045 | 1088 | |
2013964 | 2013964 | 2021-12-14 | Comerio | Puerto Rico | 72045 | 1087 | |
2010713 | 2010713 | 2021-12-13 | Comerio | Puerto Rico | 72045 | 1086 | |
2007462 | 2007462 | 2021-12-12 | Comerio | Puerto Rico | 72045 | 1086 | |
2004211 | 2004211 | 2021-12-11 | Comerio | Puerto Rico | 72045 | 1086 | |
2000960 | 2000960 | 2021-12-10 | Comerio | Puerto Rico | 72045 | 1086 | |
1997710 | 1997710 | 2021-12-09 | Comerio | Puerto Rico | 72045 | 1085 | |
1994459 | 1994459 | 2021-12-08 | Comerio | Puerto Rico | 72045 | 1085 | |
1991208 | 1991208 | 2021-12-07 | Comerio | Puerto Rico | 72045 | 1085 | |
1987957 | 1987957 | 2021-12-06 | Comerio | Puerto Rico | 72045 | 1085 | |
1984707 | 1984707 | 2021-12-05 | Comerio | Puerto Rico | 72045 | 1083 | |
1981457 | 1981457 | 2021-12-04 | Comerio | Puerto Rico | 72045 | 1083 | |
1978207 | 1978207 | 2021-12-03 | Comerio | Puerto Rico | 72045 | 1082 | |
1974957 | 1974957 | 2021-12-02 | Comerio | Puerto Rico | 72045 | 1081 | |
1971708 | 1971708 | 2021-12-01 | Comerio | Puerto Rico | 72045 | 1080 | |
1968458 | 1968458 | 2021-11-30 | Comerio | Puerto Rico | 72045 | 1080 | |
1965207 | 1965207 | 2021-11-29 | Comerio | Puerto Rico | 72045 | 1080 | |
1961955 | 1961955 | 2021-11-28 | Comerio | Puerto Rico | 72045 | 1080 | |
1958704 | 1958704 | 2021-11-27 | Comerio | Puerto Rico | 72045 | 1080 | |
1955453 | 1955453 | 2021-11-26 | Comerio | Puerto Rico | 72045 | 1080 | |
1952202 | 1952202 | 2021-11-25 | Comerio | Puerto Rico | 72045 | 1080 | |
1948951 | 1948951 | 2021-11-24 | Comerio | Puerto Rico | 72045 | 1078 | |
1945700 | 1945700 | 2021-11-23 | Comerio | Puerto Rico | 72045 | 1078 | |
1942449 | 1942449 | 2021-11-22 | Comerio | Puerto Rico | 72045 | 1078 | |
1939199 | 1939199 | 2021-11-21 | Comerio | Puerto Rico | 72045 | 1077 | |
1935949 | 1935949 | 2021-11-20 | Comerio | Puerto Rico | 72045 | 1074 | |
1932699 | 1932699 | 2021-11-19 | Comerio | Puerto Rico | 72045 | 1073 | |
1929448 | 1929448 | 2021-11-18 | Comerio | Puerto Rico | 72045 | 1073 | |
1926198 | 1926198 | 2021-11-17 | Comerio | Puerto Rico | 72045 | 1072 | |
1922948 | 1922948 | 2021-11-16 | Comerio | Puerto Rico | 72045 | 1072 | |
1919699 | 1919699 | 2021-11-15 | Comerio | Puerto Rico | 72045 | 1072 | |
1916449 | 1916449 | 2021-11-14 | Comerio | Puerto Rico | 72045 | 1072 | |
1913199 | 1913199 | 2021-11-13 | Comerio | Puerto Rico | 72045 | 1072 | |
1909949 | 1909949 | 2021-11-12 | Comerio | Puerto Rico | 72045 | 1072 | |
1906700 | 1906700 | 2021-11-11 | Comerio | Puerto Rico | 72045 | 1072 | |
1903451 | 1903451 | 2021-11-10 | Comerio | Puerto Rico | 72045 | 1072 | |
1900201 | 1900201 | 2021-11-09 | Comerio | Puerto Rico | 72045 | 1071 | |
1896951 | 1896951 | 2021-11-08 | Comerio | Puerto Rico | 72045 | 1070 | |
1893701 | 1893701 | 2021-11-07 | Comerio | Puerto Rico | 72045 | 1070 | |
1890451 | 1890451 | 2021-11-06 | Comerio | Puerto Rico | 72045 | 1068 | |
1887201 | 1887201 | 2021-11-05 | Comerio | Puerto Rico | 72045 | 1068 | |
1883951 | 1883951 | 2021-11-04 | Comerio | Puerto Rico | 72045 | 1068 | |
1880702 | 1880702 | 2021-11-03 | Comerio | Puerto Rico | 72045 | 1068 | |
1877453 | 1877453 | 2021-11-02 | Comerio | Puerto Rico | 72045 | 1069 | |
1874204 | 1874204 | 2021-11-01 | Comerio | Puerto Rico | 72045 | 1069 | |
1870955 | 1870955 | 2021-10-31 | Comerio | Puerto Rico | 72045 | 1069 | |
1867706 | 1867706 | 2021-10-30 | Comerio | Puerto Rico | 72045 | 1069 | |
1864457 | 1864457 | 2021-10-29 | Comerio | Puerto Rico | 72045 | 1069 | |
1861208 | 1861208 | 2021-10-28 | Comerio | Puerto Rico | 72045 | 1068 | |
1857959 | 1857959 | 2021-10-27 | Comerio | Puerto Rico | 72045 | 1068 | |
1854710 | 1854710 | 2021-10-26 | Comerio | Puerto Rico | 72045 | 1068 |
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);