ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72003 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 |
---|---|---|---|---|---|---|---|
2176531 | 2176531 | 2022-02-02 | Aguada | Puerto Rico | 72003 | 5790 | |
2173277 | 2173277 | 2022-02-01 | Aguada | Puerto Rico | 72003 | 5765 | |
2170025 | 2170025 | 2022-01-31 | Aguada | Puerto Rico | 72003 | 5765 | |
2166771 | 2166771 | 2022-01-30 | Aguada | Puerto Rico | 72003 | 5753 | |
2163516 | 2163516 | 2022-01-29 | Aguada | Puerto Rico | 72003 | 5728 | |
2160261 | 2160261 | 2022-01-28 | Aguada | Puerto Rico | 72003 | 5723 | |
2157005 | 2157005 | 2022-01-27 | Aguada | Puerto Rico | 72003 | 5671 | |
2153752 | 2153752 | 2022-01-26 | Aguada | Puerto Rico | 72003 | 5650 | |
2150500 | 2150500 | 2022-01-25 | Aguada | Puerto Rico | 72003 | 5603 | |
2147248 | 2147248 | 2022-01-24 | Aguada | Puerto Rico | 72003 | 5600 | |
2143994 | 2143994 | 2022-01-23 | Aguada | Puerto Rico | 72003 | 5586 | |
2140739 | 2140739 | 2022-01-22 | Aguada | Puerto Rico | 72003 | 5534 | |
2137483 | 2137483 | 2022-01-21 | Aguada | Puerto Rico | 72003 | 5482 | |
2134229 | 2134229 | 2022-01-20 | Aguada | Puerto Rico | 72003 | 5427 | |
2130977 | 2130977 | 2022-01-19 | Aguada | Puerto Rico | 72003 | 5378 | |
2127723 | 2127723 | 2022-01-18 | Aguada | Puerto Rico | 72003 | 5317 | |
2124471 | 2124471 | 2022-01-17 | Aguada | Puerto Rico | 72003 | 5311 | |
2121219 | 2121219 | 2022-01-16 | Aguada | Puerto Rico | 72003 | 5254 | |
2117967 | 2117967 | 2022-01-15 | Aguada | Puerto Rico | 72003 | 5198 | |
2114716 | 2114716 | 2022-01-14 | Aguada | Puerto Rico | 72003 | 5059 | |
2111464 | 2111464 | 2022-01-13 | Aguada | Puerto Rico | 72003 | 4866 | |
2108212 | 2108212 | 2022-01-12 | Aguada | Puerto Rico | 72003 | 4701 | |
2104961 | 2104961 | 2022-01-11 | Aguada | Puerto Rico | 72003 | 4580 | |
2101710 | 2101710 | 2022-01-10 | Aguada | Puerto Rico | 72003 | 4576 | |
2098459 | 2098459 | 2022-01-09 | Aguada | Puerto Rico | 72003 | 4450 | |
2095207 | 2095207 | 2022-01-08 | Aguada | Puerto Rico | 72003 | 4359 | |
2091955 | 2091955 | 2022-01-07 | Aguada | Puerto Rico | 72003 | 4258 | |
2088703 | 2088703 | 2022-01-06 | Aguada | Puerto Rico | 72003 | 4137 | |
2085452 | 2085452 | 2022-01-05 | Aguada | Puerto Rico | 72003 | 3913 | |
2082200 | 2082200 | 2022-01-04 | Aguada | Puerto Rico | 72003 | 3833 | |
2078948 | 2078948 | 2022-01-03 | Aguada | Puerto Rico | 72003 | 3819 | |
2075697 | 2075697 | 2022-01-02 | Aguada | Puerto Rico | 72003 | 3724 | |
2072446 | 2072446 | 2022-01-01 | Aguada | Puerto Rico | 72003 | 3334 | |
2069195 | 2069195 | 2021-12-31 | Aguada | Puerto Rico | 72003 | 3334 | |
2065944 | 2065944 | 2021-12-30 | Aguada | Puerto Rico | 72003 | 3188 | |
2062694 | 2062694 | 2021-12-29 | Aguada | Puerto Rico | 72003 | 3020 | |
2059444 | 2059444 | 2021-12-28 | Aguada | Puerto Rico | 72003 | 2965 | |
2056195 | 2056195 | 2021-12-27 | Aguada | Puerto Rico | 72003 | 2953 | |
2052946 | 2052946 | 2021-12-26 | Aguada | Puerto Rico | 72003 | 2950 | |
2049696 | 2049696 | 2021-12-25 | Aguada | Puerto Rico | 72003 | 2830 | |
2046446 | 2046446 | 2021-12-24 | Aguada | Puerto Rico | 72003 | 2658 | |
2043196 | 2043196 | 2021-12-23 | Aguada | Puerto Rico | 72003 | 2658 | |
2039947 | 2039947 | 2021-12-22 | Aguada | Puerto Rico | 72003 | 2613 | |
2036697 | 2036697 | 2021-12-21 | Aguada | Puerto Rico | 72003 | 2568 | |
2033447 | 2033447 | 2021-12-20 | Aguada | Puerto Rico | 72003 | 2563 | |
2030197 | 2030197 | 2021-12-19 | Aguada | Puerto Rico | 72003 | 2532 | |
2026946 | 2026946 | 2021-12-18 | Aguada | Puerto Rico | 72003 | 2505 | |
2023695 | 2023695 | 2021-12-17 | Aguada | Puerto Rico | 72003 | 2496 | |
2020444 | 2020444 | 2021-12-16 | Aguada | Puerto Rico | 72003 | 2478 | |
2017193 | 2017193 | 2021-12-15 | Aguada | Puerto Rico | 72003 | 2474 | |
2013943 | 2013943 | 2021-12-14 | Aguada | Puerto Rico | 72003 | 2472 | |
2010692 | 2010692 | 2021-12-13 | Aguada | Puerto Rico | 72003 | 2472 | |
2007441 | 2007441 | 2021-12-12 | Aguada | Puerto Rico | 72003 | 2472 | |
2004190 | 2004190 | 2021-12-11 | Aguada | Puerto Rico | 72003 | 2472 | |
2000939 | 2000939 | 2021-12-10 | Aguada | Puerto Rico | 72003 | 2472 | |
1997689 | 1997689 | 2021-12-09 | Aguada | Puerto Rico | 72003 | 2471 | |
1994438 | 1994438 | 2021-12-08 | Aguada | Puerto Rico | 72003 | 2471 | |
1991187 | 1991187 | 2021-12-07 | Aguada | Puerto Rico | 72003 | 2469 | |
1987936 | 1987936 | 2021-12-06 | Aguada | Puerto Rico | 72003 | 2469 | |
1984686 | 1984686 | 2021-12-05 | Aguada | Puerto Rico | 72003 | 2469 | |
1981436 | 1981436 | 2021-12-04 | Aguada | Puerto Rico | 72003 | 2469 | |
1978186 | 1978186 | 2021-12-03 | Aguada | Puerto Rico | 72003 | 2466 | |
1974936 | 1974936 | 2021-12-02 | Aguada | Puerto Rico | 72003 | 2463 | |
1971687 | 1971687 | 2021-12-01 | Aguada | Puerto Rico | 72003 | 2462 | |
1968437 | 1968437 | 2021-11-30 | Aguada | Puerto Rico | 72003 | 2459 | |
1965186 | 1965186 | 2021-11-29 | Aguada | Puerto Rico | 72003 | 2459 | |
1961934 | 1961934 | 2021-11-28 | Aguada | Puerto Rico | 72003 | 2459 | |
1958683 | 1958683 | 2021-11-27 | Aguada | Puerto Rico | 72003 | 2458 | |
1955432 | 1955432 | 2021-11-26 | Aguada | Puerto Rico | 72003 | 2458 | |
1952181 | 1952181 | 2021-11-25 | Aguada | Puerto Rico | 72003 | 2456 | |
1948930 | 1948930 | 2021-11-24 | Aguada | Puerto Rico | 72003 | 2456 | |
1945679 | 1945679 | 2021-11-23 | Aguada | Puerto Rico | 72003 | 2454 | |
1942428 | 1942428 | 2021-11-22 | Aguada | Puerto Rico | 72003 | 2453 | |
1939178 | 1939178 | 2021-11-21 | Aguada | Puerto Rico | 72003 | 2453 | |
1935928 | 1935928 | 2021-11-20 | Aguada | Puerto Rico | 72003 | 2453 | |
1932678 | 1932678 | 2021-11-19 | Aguada | Puerto Rico | 72003 | 2452 | |
1929427 | 1929427 | 2021-11-18 | Aguada | Puerto Rico | 72003 | 2450 | |
1926177 | 1926177 | 2021-11-17 | Aguada | Puerto Rico | 72003 | 2448 | |
1922927 | 1922927 | 2021-11-16 | Aguada | Puerto Rico | 72003 | 2444 | |
1919678 | 1919678 | 2021-11-15 | Aguada | Puerto Rico | 72003 | 2444 | |
1916428 | 1916428 | 2021-11-14 | Aguada | Puerto Rico | 72003 | 2444 | |
1913178 | 1913178 | 2021-11-13 | Aguada | Puerto Rico | 72003 | 2442 | |
1909928 | 1909928 | 2021-11-12 | Aguada | Puerto Rico | 72003 | 2441 | |
1906679 | 1906679 | 2021-11-11 | Aguada | Puerto Rico | 72003 | 2441 | |
1903430 | 1903430 | 2021-11-10 | Aguada | Puerto Rico | 72003 | 2440 | |
1900180 | 1900180 | 2021-11-09 | Aguada | Puerto Rico | 72003 | 2440 | |
1896930 | 1896930 | 2021-11-08 | Aguada | Puerto Rico | 72003 | 2439 | |
1893680 | 1893680 | 2021-11-07 | Aguada | Puerto Rico | 72003 | 2438 | |
1890430 | 1890430 | 2021-11-06 | Aguada | Puerto Rico | 72003 | 2438 | |
1887180 | 1887180 | 2021-11-05 | Aguada | Puerto Rico | 72003 | 2435 | |
1883930 | 1883930 | 2021-11-04 | Aguada | Puerto Rico | 72003 | 2435 | |
1880681 | 1880681 | 2021-11-03 | Aguada | Puerto Rico | 72003 | 2435 | |
1877432 | 1877432 | 2021-11-02 | Aguada | Puerto Rico | 72003 | 2435 | |
1874183 | 1874183 | 2021-11-01 | Aguada | Puerto Rico | 72003 | 2435 | |
1870934 | 1870934 | 2021-10-31 | Aguada | Puerto Rico | 72003 | 2435 | |
1867685 | 1867685 | 2021-10-30 | Aguada | Puerto Rico | 72003 | 2435 | |
1864436 | 1864436 | 2021-10-29 | Aguada | Puerto Rico | 72003 | 2434 | |
1861187 | 1861187 | 2021-10-28 | Aguada | Puerto Rico | 72003 | 2430 | |
1857938 | 1857938 | 2021-10-27 | Aguada | Puerto Rico | 72003 | 2429 | |
1854689 | 1854689 | 2021-10-26 | Aguada | Puerto Rico | 72003 | 2429 |
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);