ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Rio Grande" 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 |
---|---|---|---|---|---|---|---|
2173336 | 2173336 | 2022-02-01 | Rio Grande | Puerto Rico | 72119 | 7054 | |
2170084 | 2170084 | 2022-01-31 | Rio Grande | Puerto Rico | 72119 | 7053 | |
2166830 | 2166830 | 2022-01-30 | Rio Grande | Puerto Rico | 72119 | 7048 | |
2163575 | 2163575 | 2022-01-29 | Rio Grande | Puerto Rico | 72119 | 7031 | |
2160320 | 2160320 | 2022-01-28 | Rio Grande | Puerto Rico | 72119 | 7014 | |
2157064 | 2157064 | 2022-01-27 | Rio Grande | Puerto Rico | 72119 | 6970 | |
2153811 | 2153811 | 2022-01-26 | Rio Grande | Puerto Rico | 72119 | 6951 | |
2150559 | 2150559 | 2022-01-25 | Rio Grande | Puerto Rico | 72119 | 6917 | |
2147307 | 2147307 | 2022-01-24 | Rio Grande | Puerto Rico | 72119 | 6914 | |
2144053 | 2144053 | 2022-01-23 | Rio Grande | Puerto Rico | 72119 | 6885 | |
2140798 | 2140798 | 2022-01-22 | Rio Grande | Puerto Rico | 72119 | 6828 | |
2137542 | 2137542 | 2022-01-21 | Rio Grande | Puerto Rico | 72119 | 6755 | |
2134288 | 2134288 | 2022-01-20 | Rio Grande | Puerto Rico | 72119 | 6690 | |
2131036 | 2131036 | 2022-01-19 | Rio Grande | Puerto Rico | 72119 | 6655 | |
2127782 | 2127782 | 2022-01-18 | Rio Grande | Puerto Rico | 72119 | 6617 | |
2124530 | 2124530 | 2022-01-17 | Rio Grande | Puerto Rico | 72119 | 6608 | |
2121278 | 2121278 | 2022-01-16 | Rio Grande | Puerto Rico | 72119 | 6573 | |
2118026 | 2118026 | 2022-01-15 | Rio Grande | Puerto Rico | 72119 | 6491 | |
2114775 | 2114775 | 2022-01-14 | Rio Grande | Puerto Rico | 72119 | 6405 | |
2111523 | 2111523 | 2022-01-13 | Rio Grande | Puerto Rico | 72119 | 6170 | |
2108271 | 2108271 | 2022-01-12 | Rio Grande | Puerto Rico | 72119 | 6021 | |
2105020 | 2105020 | 2022-01-11 | Rio Grande | Puerto Rico | 72119 | 5891 | |
2101769 | 2101769 | 2022-01-10 | Rio Grande | Puerto Rico | 72119 | 5872 | |
2098518 | 2098518 | 2022-01-09 | Rio Grande | Puerto Rico | 72119 | 5787 | |
2095266 | 2095266 | 2022-01-08 | Rio Grande | Puerto Rico | 72119 | 5611 | |
2092014 | 2092014 | 2022-01-07 | Rio Grande | Puerto Rico | 72119 | 5542 | |
2088762 | 2088762 | 2022-01-06 | Rio Grande | Puerto Rico | 72119 | 5255 | |
2085511 | 2085511 | 2022-01-05 | Rio Grande | Puerto Rico | 72119 | 5124 | |
2082259 | 2082259 | 2022-01-04 | Rio Grande | Puerto Rico | 72119 | 5059 | |
2079007 | 2079007 | 2022-01-03 | Rio Grande | Puerto Rico | 72119 | 5043 | |
2075756 | 2075756 | 2022-01-02 | Rio Grande | Puerto Rico | 72119 | 5027 | |
2072505 | 2072505 | 2022-01-01 | Rio Grande | Puerto Rico | 72119 | 4622 | |
2069254 | 2069254 | 2021-12-31 | Rio Grande | Puerto Rico | 72119 | 4622 | |
2066003 | 2066003 | 2021-12-30 | Rio Grande | Puerto Rico | 72119 | 4285 | |
2062753 | 2062753 | 2021-12-29 | Rio Grande | Puerto Rico | 72119 | 4115 | |
2059503 | 2059503 | 2021-12-28 | Rio Grande | Puerto Rico | 72119 | 4019 | |
2056254 | 2056254 | 2021-12-27 | Rio Grande | Puerto Rico | 72119 | 3999 | |
2053005 | 2053005 | 2021-12-26 | Rio Grande | Puerto Rico | 72119 | 3987 | |
2049755 | 2049755 | 2021-12-25 | Rio Grande | Puerto Rico | 72119 | 3890 | |
2046505 | 2046505 | 2021-12-24 | Rio Grande | Puerto Rico | 72119 | 3572 | |
2043255 | 2043255 | 2021-12-23 | Rio Grande | Puerto Rico | 72119 | 3572 | |
2040006 | 2040006 | 2021-12-22 | Rio Grande | Puerto Rico | 72119 | 3476 | |
2036756 | 2036756 | 2021-12-21 | Rio Grande | Puerto Rico | 72119 | 3448 | |
2033506 | 2033506 | 2021-12-20 | Rio Grande | Puerto Rico | 72119 | 3446 | |
2030256 | 2030256 | 2021-12-19 | Rio Grande | Puerto Rico | 72119 | 3410 | |
2027005 | 2027005 | 2021-12-18 | Rio Grande | Puerto Rico | 72119 | 3387 | |
2023754 | 2023754 | 2021-12-17 | Rio Grande | Puerto Rico | 72119 | 3363 | |
2020503 | 2020503 | 2021-12-16 | Rio Grande | Puerto Rico | 72119 | 3357 | |
2017252 | 2017252 | 2021-12-15 | Rio Grande | Puerto Rico | 72119 | 3352 | |
2014002 | 2014002 | 2021-12-14 | Rio Grande | Puerto Rico | 72119 | 3351 | |
2010751 | 2010751 | 2021-12-13 | Rio Grande | Puerto Rico | 72119 | 3351 | |
2007500 | 2007500 | 2021-12-12 | Rio Grande | Puerto Rico | 72119 | 3351 | |
2004249 | 2004249 | 2021-12-11 | Rio Grande | Puerto Rico | 72119 | 3350 | |
2000998 | 2000998 | 2021-12-10 | Rio Grande | Puerto Rico | 72119 | 3350 | |
1997748 | 1997748 | 2021-12-09 | Rio Grande | Puerto Rico | 72119 | 3349 | |
1994497 | 1994497 | 2021-12-08 | Rio Grande | Puerto Rico | 72119 | 3347 | |
1991246 | 1991246 | 2021-12-07 | Rio Grande | Puerto Rico | 72119 | 3342 | |
1987995 | 1987995 | 2021-12-06 | Rio Grande | Puerto Rico | 72119 | 3341 | |
1984745 | 1984745 | 2021-12-05 | Rio Grande | Puerto Rico | 72119 | 3339 | |
1981495 | 1981495 | 2021-12-04 | Rio Grande | Puerto Rico | 72119 | 3339 | |
1978245 | 1978245 | 2021-12-03 | Rio Grande | Puerto Rico | 72119 | 3336 | |
1974995 | 1974995 | 2021-12-02 | Rio Grande | Puerto Rico | 72119 | 3336 | |
1971746 | 1971746 | 2021-12-01 | Rio Grande | Puerto Rico | 72119 | 3335 | |
1968496 | 1968496 | 2021-11-30 | Rio Grande | Puerto Rico | 72119 | 3335 | |
1965245 | 1965245 | 2021-11-29 | Rio Grande | Puerto Rico | 72119 | 3335 | |
1961993 | 1961993 | 2021-11-28 | Rio Grande | Puerto Rico | 72119 | 3334 | |
1958742 | 1958742 | 2021-11-27 | Rio Grande | Puerto Rico | 72119 | 3333 | |
1955491 | 1955491 | 2021-11-26 | Rio Grande | Puerto Rico | 72119 | 3332 | |
1952240 | 1952240 | 2021-11-25 | Rio Grande | Puerto Rico | 72119 | 3331 | |
1948989 | 1948989 | 2021-11-24 | Rio Grande | Puerto Rico | 72119 | 3325 | |
1945738 | 1945738 | 2021-11-23 | Rio Grande | Puerto Rico | 72119 | 3320 | |
1942487 | 1942487 | 2021-11-22 | Rio Grande | Puerto Rico | 72119 | 3320 | |
1939237 | 1939237 | 2021-11-21 | Rio Grande | Puerto Rico | 72119 | 3318 | |
1935987 | 1935987 | 2021-11-20 | Rio Grande | Puerto Rico | 72119 | 3315 | |
1932737 | 1932737 | 2021-11-19 | Rio Grande | Puerto Rico | 72119 | 3308 | |
1929486 | 1929486 | 2021-11-18 | Rio Grande | Puerto Rico | 72119 | 3306 | |
1926236 | 1926236 | 2021-11-17 | Rio Grande | Puerto Rico | 72119 | 3306 | |
1922986 | 1922986 | 2021-11-16 | Rio Grande | Puerto Rico | 72119 | 3305 | |
1919737 | 1919737 | 2021-11-15 | Rio Grande | Puerto Rico | 72119 | 3305 | |
1916487 | 1916487 | 2021-11-14 | Rio Grande | Puerto Rico | 72119 | 3302 | |
1913237 | 1913237 | 2021-11-13 | Rio Grande | Puerto Rico | 72119 | 3302 | |
1909987 | 1909987 | 2021-11-12 | Rio Grande | Puerto Rico | 72119 | 3299 | |
1906738 | 1906738 | 2021-11-11 | Rio Grande | Puerto Rico | 72119 | 3298 | |
1903489 | 1903489 | 2021-11-10 | Rio Grande | Puerto Rico | 72119 | 3294 | |
1900239 | 1900239 | 2021-11-09 | Rio Grande | Puerto Rico | 72119 | 3291 | |
1896989 | 1896989 | 2021-11-08 | Rio Grande | Puerto Rico | 72119 | 3287 | |
1893739 | 1893739 | 2021-11-07 | Rio Grande | Puerto Rico | 72119 | 3286 | |
1890489 | 1890489 | 2021-11-06 | Rio Grande | Puerto Rico | 72119 | 3285 | |
1887239 | 1887239 | 2021-11-05 | Rio Grande | Puerto Rico | 72119 | 3282 | |
1883989 | 1883989 | 2021-11-04 | Rio Grande | Puerto Rico | 72119 | 3281 | |
1880740 | 1880740 | 2021-11-03 | Rio Grande | Puerto Rico | 72119 | 3279 | |
1877491 | 1877491 | 2021-11-02 | Rio Grande | Puerto Rico | 72119 | 3276 | |
1874242 | 1874242 | 2021-11-01 | Rio Grande | Puerto Rico | 72119 | 3276 | |
1870993 | 1870993 | 2021-10-31 | Rio Grande | Puerto Rico | 72119 | 3275 | |
1867744 | 1867744 | 2021-10-30 | Rio Grande | Puerto Rico | 72119 | 3275 | |
1864495 | 1864495 | 2021-10-29 | Rio Grande | Puerto Rico | 72119 | 3274 | |
1861246 | 1861246 | 2021-10-28 | Rio Grande | Puerto Rico | 72119 | 3270 | |
1857997 | 1857997 | 2021-10-27 | Rio Grande | Puerto Rico | 72119 | 3269 | |
1854748 | 1854748 | 2021-10-26 | Rio Grande | Puerto Rico | 72119 | 3269 | |
1851499 | 1851499 | 2021-10-25 | Rio Grande | Puerto Rico | 72119 | 3269 |
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);