ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72005 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 |
---|---|---|---|---|---|---|---|
2176532 | 2176532 | 2022-02-02 | Aguadilla | Puerto Rico | 72005 | 6688 | |
2173278 | 2173278 | 2022-02-01 | Aguadilla | Puerto Rico | 72005 | 6673 | |
2170026 | 2170026 | 2022-01-31 | Aguadilla | Puerto Rico | 72005 | 6672 | |
2166772 | 2166772 | 2022-01-30 | Aguadilla | Puerto Rico | 72005 | 6656 | |
2163517 | 2163517 | 2022-01-29 | Aguadilla | Puerto Rico | 72005 | 6632 | |
2160262 | 2160262 | 2022-01-28 | Aguadilla | Puerto Rico | 72005 | 6612 | |
2157006 | 2157006 | 2022-01-27 | Aguadilla | Puerto Rico | 72005 | 6568 | |
2153753 | 2153753 | 2022-01-26 | Aguadilla | Puerto Rico | 72005 | 6555 | |
2150501 | 2150501 | 2022-01-25 | Aguadilla | Puerto Rico | 72005 | 6481 | |
2147249 | 2147249 | 2022-01-24 | Aguadilla | Puerto Rico | 72005 | 6477 | |
2143995 | 2143995 | 2022-01-23 | Aguadilla | Puerto Rico | 72005 | 6428 | |
2140740 | 2140740 | 2022-01-22 | Aguadilla | Puerto Rico | 72005 | 6378 | |
2137484 | 2137484 | 2022-01-21 | Aguadilla | Puerto Rico | 72005 | 6298 | |
2134230 | 2134230 | 2022-01-20 | Aguadilla | Puerto Rico | 72005 | 6250 | |
2130978 | 2130978 | 2022-01-19 | Aguadilla | Puerto Rico | 72005 | 6186 | |
2127724 | 2127724 | 2022-01-18 | Aguadilla | Puerto Rico | 72005 | 6092 | |
2124472 | 2124472 | 2022-01-17 | Aguadilla | Puerto Rico | 72005 | 6088 | |
2121220 | 2121220 | 2022-01-16 | Aguadilla | Puerto Rico | 72005 | 6044 | |
2117968 | 2117968 | 2022-01-15 | Aguadilla | Puerto Rico | 72005 | 5964 | |
2114717 | 2114717 | 2022-01-14 | Aguadilla | Puerto Rico | 72005 | 5837 | |
2111465 | 2111465 | 2022-01-13 | Aguadilla | Puerto Rico | 72005 | 5698 | |
2108213 | 2108213 | 2022-01-12 | Aguadilla | Puerto Rico | 72005 | 5516 | |
2104962 | 2104962 | 2022-01-11 | Aguadilla | Puerto Rico | 72005 | 5372 | |
2101711 | 2101711 | 2022-01-10 | Aguadilla | Puerto Rico | 72005 | 5370 | |
2098460 | 2098460 | 2022-01-09 | Aguadilla | Puerto Rico | 72005 | 5258 | |
2095208 | 2095208 | 2022-01-08 | Aguadilla | Puerto Rico | 72005 | 5104 | |
2091956 | 2091956 | 2022-01-07 | Aguadilla | Puerto Rico | 72005 | 5047 | |
2088704 | 2088704 | 2022-01-06 | Aguadilla | Puerto Rico | 72005 | 4841 | |
2085453 | 2085453 | 2022-01-05 | Aguadilla | Puerto Rico | 72005 | 4555 | |
2082201 | 2082201 | 2022-01-04 | Aguadilla | Puerto Rico | 72005 | 4396 | |
2078949 | 2078949 | 2022-01-03 | Aguadilla | Puerto Rico | 72005 | 4350 | |
2075698 | 2075698 | 2022-01-02 | Aguadilla | Puerto Rico | 72005 | 4304 | |
2072447 | 2072447 | 2022-01-01 | Aguadilla | Puerto Rico | 72005 | 3955 | |
2069196 | 2069196 | 2021-12-31 | Aguadilla | Puerto Rico | 72005 | 3955 | |
2065945 | 2065945 | 2021-12-30 | Aguadilla | Puerto Rico | 72005 | 3811 | |
2062695 | 2062695 | 2021-12-29 | Aguadilla | Puerto Rico | 72005 | 3667 | |
2059445 | 2059445 | 2021-12-28 | Aguadilla | Puerto Rico | 72005 | 3583 | |
2056196 | 2056196 | 2021-12-27 | Aguadilla | Puerto Rico | 72005 | 3559 | |
2052947 | 2052947 | 2021-12-26 | Aguadilla | Puerto Rico | 72005 | 3556 | |
2049697 | 2049697 | 2021-12-25 | Aguadilla | Puerto Rico | 72005 | 3474 | |
2046447 | 2046447 | 2021-12-24 | Aguadilla | Puerto Rico | 72005 | 3281 | |
2043197 | 2043197 | 2021-12-23 | Aguadilla | Puerto Rico | 72005 | 3281 | |
2039948 | 2039948 | 2021-12-22 | Aguadilla | Puerto Rico | 72005 | 3211 | |
2036698 | 2036698 | 2021-12-21 | Aguadilla | Puerto Rico | 72005 | 3186 | |
2033448 | 2033448 | 2021-12-20 | Aguadilla | Puerto Rico | 72005 | 3186 | |
2030198 | 2030198 | 2021-12-19 | Aguadilla | Puerto Rico | 72005 | 3166 | |
2026947 | 2026947 | 2021-12-18 | Aguadilla | Puerto Rico | 72005 | 3145 | |
2023696 | 2023696 | 2021-12-17 | Aguadilla | Puerto Rico | 72005 | 3133 | |
2020445 | 2020445 | 2021-12-16 | Aguadilla | Puerto Rico | 72005 | 3126 | |
2017194 | 2017194 | 2021-12-15 | Aguadilla | Puerto Rico | 72005 | 3120 | |
2013944 | 2013944 | 2021-12-14 | Aguadilla | Puerto Rico | 72005 | 3119 | |
2010693 | 2010693 | 2021-12-13 | Aguadilla | Puerto Rico | 72005 | 3113 | |
2007442 | 2007442 | 2021-12-12 | Aguadilla | Puerto Rico | 72005 | 3113 | |
2004191 | 2004191 | 2021-12-11 | Aguadilla | Puerto Rico | 72005 | 3110 | |
2000940 | 2000940 | 2021-12-10 | Aguadilla | Puerto Rico | 72005 | 3110 | |
1997690 | 1997690 | 2021-12-09 | Aguadilla | Puerto Rico | 72005 | 3104 | |
1994439 | 1994439 | 2021-12-08 | Aguadilla | Puerto Rico | 72005 | 3103 | |
1991188 | 1991188 | 2021-12-07 | Aguadilla | Puerto Rico | 72005 | 3101 | |
1987937 | 1987937 | 2021-12-06 | Aguadilla | Puerto Rico | 72005 | 3101 | |
1984687 | 1984687 | 2021-12-05 | Aguadilla | Puerto Rico | 72005 | 3100 | |
1981437 | 1981437 | 2021-12-04 | Aguadilla | Puerto Rico | 72005 | 3100 | |
1978187 | 1978187 | 2021-12-03 | Aguadilla | Puerto Rico | 72005 | 3099 | |
1974937 | 1974937 | 2021-12-02 | Aguadilla | Puerto Rico | 72005 | 3097 | |
1971688 | 1971688 | 2021-12-01 | Aguadilla | Puerto Rico | 72005 | 3096 | |
1968438 | 1968438 | 2021-11-30 | Aguadilla | Puerto Rico | 72005 | 3092 | |
1965187 | 1965187 | 2021-11-29 | Aguadilla | Puerto Rico | 72005 | 3091 | |
1961935 | 1961935 | 2021-11-28 | Aguadilla | Puerto Rico | 72005 | 3091 | |
1958684 | 1958684 | 2021-11-27 | Aguadilla | Puerto Rico | 72005 | 3090 | |
1955433 | 1955433 | 2021-11-26 | Aguadilla | Puerto Rico | 72005 | 3090 | |
1952182 | 1952182 | 2021-11-25 | Aguadilla | Puerto Rico | 72005 | 3091 | |
1948931 | 1948931 | 2021-11-24 | Aguadilla | Puerto Rico | 72005 | 3090 | |
1945680 | 1945680 | 2021-11-23 | Aguadilla | Puerto Rico | 72005 | 3089 | |
1942429 | 1942429 | 2021-11-22 | Aguadilla | Puerto Rico | 72005 | 3089 | |
1939179 | 1939179 | 2021-11-21 | Aguadilla | Puerto Rico | 72005 | 3089 | |
1935929 | 1935929 | 2021-11-20 | Aguadilla | Puerto Rico | 72005 | 3088 | |
1932679 | 1932679 | 2021-11-19 | Aguadilla | Puerto Rico | 72005 | 3084 | |
1929428 | 1929428 | 2021-11-18 | Aguadilla | Puerto Rico | 72005 | 3082 | |
1926178 | 1926178 | 2021-11-17 | Aguadilla | Puerto Rico | 72005 | 3078 | |
1922928 | 1922928 | 2021-11-16 | Aguadilla | Puerto Rico | 72005 | 3076 | |
1919679 | 1919679 | 2021-11-15 | Aguadilla | Puerto Rico | 72005 | 3076 | |
1916429 | 1916429 | 2021-11-14 | Aguadilla | Puerto Rico | 72005 | 3076 | |
1913179 | 1913179 | 2021-11-13 | Aguadilla | Puerto Rico | 72005 | 3076 | |
1909929 | 1909929 | 2021-11-12 | Aguadilla | Puerto Rico | 72005 | 3072 | |
1906680 | 1906680 | 2021-11-11 | Aguadilla | Puerto Rico | 72005 | 3072 | |
1903431 | 1903431 | 2021-11-10 | Aguadilla | Puerto Rico | 72005 | 3070 | |
1900181 | 1900181 | 2021-11-09 | Aguadilla | Puerto Rico | 72005 | 3069 | |
1896931 | 1896931 | 2021-11-08 | Aguadilla | Puerto Rico | 72005 | 3069 | |
1893681 | 1893681 | 2021-11-07 | Aguadilla | Puerto Rico | 72005 | 3068 | |
1890431 | 1890431 | 2021-11-06 | Aguadilla | Puerto Rico | 72005 | 3064 | |
1887181 | 1887181 | 2021-11-05 | Aguadilla | Puerto Rico | 72005 | 3059 | |
1883931 | 1883931 | 2021-11-04 | Aguadilla | Puerto Rico | 72005 | 3058 | |
1880682 | 1880682 | 2021-11-03 | Aguadilla | Puerto Rico | 72005 | 3055 | |
1877433 | 1877433 | 2021-11-02 | Aguadilla | Puerto Rico | 72005 | 3054 | |
1874184 | 1874184 | 2021-11-01 | Aguadilla | Puerto Rico | 72005 | 3053 | |
1870935 | 1870935 | 2021-10-31 | Aguadilla | Puerto Rico | 72005 | 3053 | |
1867686 | 1867686 | 2021-10-30 | Aguadilla | Puerto Rico | 72005 | 3053 | |
1864437 | 1864437 | 2021-10-29 | Aguadilla | Puerto Rico | 72005 | 3050 | |
1861188 | 1861188 | 2021-10-28 | Aguadilla | Puerto Rico | 72005 | 3049 | |
1857939 | 1857939 | 2021-10-27 | Aguadilla | Puerto Rico | 72005 | 3049 | |
1854690 | 1854690 | 2021-10-26 | Aguadilla | Puerto Rico | 72005 | 3046 |
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);