ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72109 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 |
---|---|---|---|---|---|---|---|
2498711 | 2498711 | 2022-05-12 | Patillas | Puerto Rico | 72109 | 2739 | |
2495453 | 2495453 | 2022-05-11 | Patillas | Puerto Rico | 72109 | 2721 | |
2492195 | 2492195 | 2022-05-10 | Patillas | Puerto Rico | 72109 | 2693 | |
2488937 | 2488937 | 2022-05-09 | Patillas | Puerto Rico | 72109 | 2684 | |
2485680 | 2485680 | 2022-05-08 | Patillas | Puerto Rico | 72109 | 2620 | |
2482422 | 2482422 | 2022-05-07 | Patillas | Puerto Rico | 72109 | 2620 | |
2479164 | 2479164 | 2022-05-06 | Patillas | Puerto Rico | 72109 | 2571 | |
2475906 | 2475906 | 2022-05-05 | Patillas | Puerto Rico | 72109 | 2534 | |
2472649 | 2472649 | 2022-05-04 | Patillas | Puerto Rico | 72109 | 2507 | |
2469393 | 2469393 | 2022-05-03 | Patillas | Puerto Rico | 72109 | 2487 | |
2466137 | 2466137 | 2022-05-02 | Patillas | Puerto Rico | 72109 | 2474 | |
2462882 | 2462882 | 2022-05-01 | Patillas | Puerto Rico | 72109 | 2443 | |
2459626 | 2459626 | 2022-04-30 | Patillas | Puerto Rico | 72109 | 2410 | |
2456370 | 2456370 | 2022-04-29 | Patillas | Puerto Rico | 72109 | 2365 | |
2453114 | 2453114 | 2022-04-28 | Patillas | Puerto Rico | 72109 | 2319 | |
2449858 | 2449858 | 2022-04-27 | Patillas | Puerto Rico | 72109 | 2273 | |
2446601 | 2446601 | 2022-04-26 | Patillas | Puerto Rico | 72109 | 2259 | |
2443346 | 2443346 | 2022-04-25 | Patillas | Puerto Rico | 72109 | 2244 | |
2440090 | 2440090 | 2022-04-24 | Patillas | Puerto Rico | 72109 | 2221 | |
2436834 | 2436834 | 2022-04-23 | Patillas | Puerto Rico | 72109 | 2205 | |
2433578 | 2433578 | 2022-04-22 | Patillas | Puerto Rico | 72109 | 2160 | |
2430322 | 2430322 | 2022-04-21 | Patillas | Puerto Rico | 72109 | 2131 | |
2427066 | 2427066 | 2022-04-20 | Patillas | Puerto Rico | 72109 | 2086 | |
2423810 | 2423810 | 2022-04-19 | Patillas | Puerto Rico | 72109 | 2077 | |
2420554 | 2420554 | 2022-04-18 | Patillas | Puerto Rico | 72109 | 2066 | |
2417298 | 2417298 | 2022-04-17 | Patillas | Puerto Rico | 72109 | 2033 | |
2414042 | 2414042 | 2022-04-16 | Patillas | Puerto Rico | 72109 | 2018 | |
2410786 | 2410786 | 2022-04-15 | Patillas | Puerto Rico | 72109 | 2018 | |
2407530 | 2407530 | 2022-04-14 | Patillas | Puerto Rico | 72109 | 2018 | |
2404274 | 2404274 | 2022-04-13 | Patillas | Puerto Rico | 72109 | 2011 | |
2401019 | 2401019 | 2022-04-12 | Patillas | Puerto Rico | 72109 | 2007 | |
2397764 | 2397764 | 2022-04-11 | Patillas | Puerto Rico | 72109 | 2006 | |
2394509 | 2394509 | 2022-04-10 | Patillas | Puerto Rico | 72109 | 2006 | |
2391253 | 2391253 | 2022-04-09 | Patillas | Puerto Rico | 72109 | 2003 | |
2387997 | 2387997 | 2022-04-08 | Patillas | Puerto Rico | 72109 | 1999 | |
2384742 | 2384742 | 2022-04-07 | Patillas | Puerto Rico | 72109 | 1998 | |
2381487 | 2381487 | 2022-04-06 | Patillas | Puerto Rico | 72109 | 1993 | |
2378232 | 2378232 | 2022-04-05 | Patillas | Puerto Rico | 72109 | 1993 | |
2374978 | 2374978 | 2022-04-04 | Patillas | Puerto Rico | 72109 | 1992 | |
2371726 | 2371726 | 2022-04-03 | Patillas | Puerto Rico | 72109 | 1991 | |
2368473 | 2368473 | 2022-04-02 | Patillas | Puerto Rico | 72109 | 1990 | |
2365220 | 2365220 | 2022-04-01 | Patillas | Puerto Rico | 72109 | 1988 | |
2361967 | 2361967 | 2022-03-31 | Patillas | Puerto Rico | 72109 | 1986 | |
2358713 | 2358713 | 2022-03-30 | Patillas | Puerto Rico | 72109 | 1986 | |
2355459 | 2355459 | 2022-03-29 | Patillas | Puerto Rico | 72109 | 1985 | |
2352206 | 2352206 | 2022-03-28 | Patillas | Puerto Rico | 72109 | 1985 | |
2348954 | 2348954 | 2022-03-27 | Patillas | Puerto Rico | 72109 | 1985 | |
2345701 | 2345701 | 2022-03-26 | Patillas | Puerto Rico | 72109 | 1984 | |
2342448 | 2342448 | 2022-03-25 | Patillas | Puerto Rico | 72109 | 1983 | |
2339195 | 2339195 | 2022-03-24 | Patillas | Puerto Rico | 72109 | 1982 | |
2335941 | 2335941 | 2022-03-23 | Patillas | Puerto Rico | 72109 | 1981 | |
2332687 | 2332687 | 2022-03-22 | Patillas | Puerto Rico | 72109 | 1979 | |
2329434 | 2329434 | 2022-03-21 | Patillas | Puerto Rico | 72109 | 1979 | |
2326182 | 2326182 | 2022-03-20 | Patillas | Puerto Rico | 72109 | 1973 | |
2322929 | 2322929 | 2022-03-19 | Patillas | Puerto Rico | 72109 | 1972 | |
2319675 | 2319675 | 2022-03-18 | Patillas | Puerto Rico | 72109 | 1971 | |
2316421 | 2316421 | 2022-03-17 | Patillas | Puerto Rico | 72109 | 1971 | |
2313168 | 2313168 | 2022-03-16 | Patillas | Puerto Rico | 72109 | 1968 | |
2309915 | 2309915 | 2022-03-15 | Patillas | Puerto Rico | 72109 | 1965 | |
2306662 | 2306662 | 2022-03-14 | Patillas | Puerto Rico | 72109 | 1965 | |
2303411 | 2303411 | 2022-03-13 | Patillas | Puerto Rico | 72109 | 1965 | |
2300159 | 2300159 | 2022-03-12 | Patillas | Puerto Rico | 72109 | 1965 | |
2296907 | 2296907 | 2022-03-11 | Patillas | Puerto Rico | 72109 | 1964 | |
2293655 | 2293655 | 2022-03-10 | Patillas | Puerto Rico | 72109 | 1964 | |
2290403 | 2290403 | 2022-03-09 | Patillas | Puerto Rico | 72109 | 1961 | |
2287151 | 2287151 | 2022-03-08 | Patillas | Puerto Rico | 72109 | 1961 | |
2283899 | 2283899 | 2022-03-07 | Patillas | Puerto Rico | 72109 | 1961 | |
2280647 | 2280647 | 2022-03-06 | Patillas | Puerto Rico | 72109 | 1959 | |
2277394 | 2277394 | 2022-03-05 | Patillas | Puerto Rico | 72109 | 1958 | |
2274141 | 2274141 | 2022-03-04 | Patillas | Puerto Rico | 72109 | 1957 | |
2270888 | 2270888 | 2022-03-03 | Patillas | Puerto Rico | 72109 | 1955 | |
2267636 | 2267636 | 2022-03-02 | Patillas | Puerto Rico | 72109 | 1955 | |
2264383 | 2264383 | 2022-03-01 | Patillas | Puerto Rico | 72109 | 1955 | |
2261133 | 2261133 | 2022-02-28 | Patillas | Puerto Rico | 72109 | 1955 | |
2257882 | 2257882 | 2022-02-27 | Patillas | Puerto Rico | 72109 | 1955 | |
2254631 | 2254631 | 2022-02-26 | Patillas | Puerto Rico | 72109 | 1953 | |
2251380 | 2251380 | 2022-02-25 | Patillas | Puerto Rico | 72109 | 1952 | |
2248129 | 2248129 | 2022-02-24 | Patillas | Puerto Rico | 72109 | 1952 | |
2244878 | 2244878 | 2022-02-23 | Patillas | Puerto Rico | 72109 | 1952 | |
2241627 | 2241627 | 2022-02-22 | Patillas | Puerto Rico | 72109 | 1952 | |
2238376 | 2238376 | 2022-02-21 | Patillas | Puerto Rico | 72109 | 1952 | |
2235125 | 2235125 | 2022-02-20 | Patillas | Puerto Rico | 72109 | 1950 | |
2231874 | 2231874 | 2022-02-19 | Patillas | Puerto Rico | 72109 | 1950 | |
2228623 | 2228623 | 2022-02-18 | Patillas | Puerto Rico | 72109 | 1947 | |
2225372 | 2225372 | 2022-02-17 | Patillas | Puerto Rico | 72109 | 1946 | |
2222121 | 2222121 | 2022-02-16 | Patillas | Puerto Rico | 72109 | 1945 | |
2218870 | 2218870 | 2022-02-15 | Patillas | Puerto Rico | 72109 | 1943 | |
2215619 | 2215619 | 2022-02-14 | Patillas | Puerto Rico | 72109 | 1943 | |
2212368 | 2212368 | 2022-02-13 | Patillas | Puerto Rico | 72109 | 1942 | |
2209115 | 2209115 | 2022-02-12 | Patillas | Puerto Rico | 72109 | 1940 | |
2205862 | 2205862 | 2022-02-11 | Patillas | Puerto Rico | 72109 | 1932 | |
2202609 | 2202609 | 2022-02-10 | Patillas | Puerto Rico | 72109 | 1930 | |
2199355 | 2199355 | 2022-02-09 | Patillas | Puerto Rico | 72109 | 1923 | |
2196101 | 2196101 | 2022-02-08 | Patillas | Puerto Rico | 72109 | 1921 | |
2192847 | 2192847 | 2022-02-07 | Patillas | Puerto Rico | 72109 | 1921 | |
2189593 | 2189593 | 2022-02-06 | Patillas | Puerto Rico | 72109 | 1913 | |
2186340 | 2186340 | 2022-02-05 | Patillas | Puerto Rico | 72109 | 1912 | |
2183088 | 2183088 | 2022-02-04 | Patillas | Puerto Rico | 72109 | 1912 | |
2179836 | 2179836 | 2022-02-03 | Patillas | Puerto Rico | 72109 | 1900 | |
2176585 | 2176585 | 2022-02-02 | Patillas | Puerto Rico | 72109 | 1897 |
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);