ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72059 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 |
---|---|---|---|---|---|---|---|
2498686 | 2498686 | 2022-05-12 | Guayanilla | Puerto Rico | 72059 | 2743 | |
2495428 | 2495428 | 2022-05-11 | Guayanilla | Puerto Rico | 72059 | 2718 | |
2492170 | 2492170 | 2022-05-10 | Guayanilla | Puerto Rico | 72059 | 2651 | |
2488912 | 2488912 | 2022-05-09 | Guayanilla | Puerto Rico | 72059 | 2650 | |
2485655 | 2485655 | 2022-05-08 | Guayanilla | Puerto Rico | 72059 | 2590 | |
2482397 | 2482397 | 2022-05-07 | Guayanilla | Puerto Rico | 72059 | 2590 | |
2479139 | 2479139 | 2022-05-06 | Guayanilla | Puerto Rico | 72059 | 2544 | |
2475881 | 2475881 | 2022-05-05 | Guayanilla | Puerto Rico | 72059 | 2473 | |
2472624 | 2472624 | 2022-05-04 | Guayanilla | Puerto Rico | 72059 | 2449 | |
2469368 | 2469368 | 2022-05-03 | Guayanilla | Puerto Rico | 72059 | 2388 | |
2466112 | 2466112 | 2022-05-02 | Guayanilla | Puerto Rico | 72059 | 2376 | |
2462857 | 2462857 | 2022-05-01 | Guayanilla | Puerto Rico | 72059 | 2368 | |
2459601 | 2459601 | 2022-04-30 | Guayanilla | Puerto Rico | 72059 | 2341 | |
2456345 | 2456345 | 2022-04-29 | Guayanilla | Puerto Rico | 72059 | 2315 | |
2453089 | 2453089 | 2022-04-28 | Guayanilla | Puerto Rico | 72059 | 2279 | |
2449833 | 2449833 | 2022-04-27 | Guayanilla | Puerto Rico | 72059 | 2259 | |
2446576 | 2446576 | 2022-04-26 | Guayanilla | Puerto Rico | 72059 | 2245 | |
2443321 | 2443321 | 2022-04-25 | Guayanilla | Puerto Rico | 72059 | 2244 | |
2440065 | 2440065 | 2022-04-24 | Guayanilla | Puerto Rico | 72059 | 2240 | |
2436809 | 2436809 | 2022-04-23 | Guayanilla | Puerto Rico | 72059 | 2203 | |
2433553 | 2433553 | 2022-04-22 | Guayanilla | Puerto Rico | 72059 | 2190 | |
2430297 | 2430297 | 2022-04-21 | Guayanilla | Puerto Rico | 72059 | 2161 | |
2427041 | 2427041 | 2022-04-20 | Guayanilla | Puerto Rico | 72059 | 2153 | |
2423785 | 2423785 | 2022-04-19 | Guayanilla | Puerto Rico | 72059 | 2124 | |
2420529 | 2420529 | 2022-04-18 | Guayanilla | Puerto Rico | 72059 | 2124 | |
2417273 | 2417273 | 2022-04-17 | Guayanilla | Puerto Rico | 72059 | 2124 | |
2414017 | 2414017 | 2022-04-16 | Guayanilla | Puerto Rico | 72059 | 2106 | |
2410761 | 2410761 | 2022-04-15 | Guayanilla | Puerto Rico | 72059 | 2106 | |
2407505 | 2407505 | 2022-04-14 | Guayanilla | Puerto Rico | 72059 | 2106 | |
2404249 | 2404249 | 2022-04-13 | Guayanilla | Puerto Rico | 72059 | 2088 | |
2400994 | 2400994 | 2022-04-12 | Guayanilla | Puerto Rico | 72059 | 2077 | |
2397739 | 2397739 | 2022-04-11 | Guayanilla | Puerto Rico | 72059 | 2077 | |
2394484 | 2394484 | 2022-04-10 | Guayanilla | Puerto Rico | 72059 | 2077 | |
2391228 | 2391228 | 2022-04-09 | Guayanilla | Puerto Rico | 72059 | 2071 | |
2387972 | 2387972 | 2022-04-08 | Guayanilla | Puerto Rico | 72059 | 2068 | |
2384717 | 2384717 | 2022-04-07 | Guayanilla | Puerto Rico | 72059 | 2061 | |
2381462 | 2381462 | 2022-04-06 | Guayanilla | Puerto Rico | 72059 | 2056 | |
2378207 | 2378207 | 2022-04-05 | Guayanilla | Puerto Rico | 72059 | 2053 | |
2374953 | 2374953 | 2022-04-04 | Guayanilla | Puerto Rico | 72059 | 2053 | |
2371701 | 2371701 | 2022-04-03 | Guayanilla | Puerto Rico | 72059 | 2053 | |
2368448 | 2368448 | 2022-04-02 | Guayanilla | Puerto Rico | 72059 | 2049 | |
2365195 | 2365195 | 2022-04-01 | Guayanilla | Puerto Rico | 72059 | 2048 | |
2361942 | 2361942 | 2022-03-31 | Guayanilla | Puerto Rico | 72059 | 2045 | |
2358688 | 2358688 | 2022-03-30 | Guayanilla | Puerto Rico | 72059 | 2045 | |
2355434 | 2355434 | 2022-03-29 | Guayanilla | Puerto Rico | 72059 | 2042 | |
2352181 | 2352181 | 2022-03-28 | Guayanilla | Puerto Rico | 72059 | 2042 | |
2348929 | 2348929 | 2022-03-27 | Guayanilla | Puerto Rico | 72059 | 2042 | |
2345676 | 2345676 | 2022-03-26 | Guayanilla | Puerto Rico | 72059 | 2038 | |
2342423 | 2342423 | 2022-03-25 | Guayanilla | Puerto Rico | 72059 | 2035 | |
2339170 | 2339170 | 2022-03-24 | Guayanilla | Puerto Rico | 72059 | 2026 | |
2335916 | 2335916 | 2022-03-23 | Guayanilla | Puerto Rico | 72059 | 2024 | |
2332662 | 2332662 | 2022-03-22 | Guayanilla | Puerto Rico | 72059 | 2021 | |
2329409 | 2329409 | 2022-03-21 | Guayanilla | Puerto Rico | 72059 | 2021 | |
2326157 | 2326157 | 2022-03-20 | Guayanilla | Puerto Rico | 72059 | 2021 | |
2322904 | 2322904 | 2022-03-19 | Guayanilla | Puerto Rico | 72059 | 2015 | |
2319650 | 2319650 | 2022-03-18 | Guayanilla | Puerto Rico | 72059 | 2014 | |
2316396 | 2316396 | 2022-03-17 | Guayanilla | Puerto Rico | 72059 | 2009 | |
2313143 | 2313143 | 2022-03-16 | Guayanilla | Puerto Rico | 72059 | 2001 | |
2309890 | 2309890 | 2022-03-15 | Guayanilla | Puerto Rico | 72059 | 2000 | |
2306637 | 2306637 | 2022-03-14 | Guayanilla | Puerto Rico | 72059 | 2000 | |
2303386 | 2303386 | 2022-03-13 | Guayanilla | Puerto Rico | 72059 | 2000 | |
2300134 | 2300134 | 2022-03-12 | Guayanilla | Puerto Rico | 72059 | 1999 | |
2296882 | 2296882 | 2022-03-11 | Guayanilla | Puerto Rico | 72059 | 1999 | |
2293630 | 2293630 | 2022-03-10 | Guayanilla | Puerto Rico | 72059 | 1996 | |
2290378 | 2290378 | 2022-03-09 | Guayanilla | Puerto Rico | 72059 | 1994 | |
2287126 | 2287126 | 2022-03-08 | Guayanilla | Puerto Rico | 72059 | 1993 | |
2283874 | 2283874 | 2022-03-07 | Guayanilla | Puerto Rico | 72059 | 1993 | |
2280622 | 2280622 | 2022-03-06 | Guayanilla | Puerto Rico | 72059 | 1991 | |
2277369 | 2277369 | 2022-03-05 | Guayanilla | Puerto Rico | 72059 | 1991 | |
2274116 | 2274116 | 2022-03-04 | Guayanilla | Puerto Rico | 72059 | 1990 | |
2270863 | 2270863 | 2022-03-03 | Guayanilla | Puerto Rico | 72059 | 1988 | |
2267611 | 2267611 | 2022-03-02 | Guayanilla | Puerto Rico | 72059 | 1987 | |
2264358 | 2264358 | 2022-03-01 | Guayanilla | Puerto Rico | 72059 | 1987 | |
2261108 | 2261108 | 2022-02-28 | Guayanilla | Puerto Rico | 72059 | 1987 | |
2257857 | 2257857 | 2022-02-27 | Guayanilla | Puerto Rico | 72059 | 1987 | |
2254606 | 2254606 | 2022-02-26 | Guayanilla | Puerto Rico | 72059 | 1986 | |
2251355 | 2251355 | 2022-02-25 | Guayanilla | Puerto Rico | 72059 | 1983 | |
2248104 | 2248104 | 2022-02-24 | Guayanilla | Puerto Rico | 72059 | 1982 | |
2244853 | 2244853 | 2022-02-23 | Guayanilla | Puerto Rico | 72059 | 1981 | |
2241602 | 2241602 | 2022-02-22 | Guayanilla | Puerto Rico | 72059 | 1981 | |
2238351 | 2238351 | 2022-02-21 | Guayanilla | Puerto Rico | 72059 | 1980 | |
2235100 | 2235100 | 2022-02-20 | Guayanilla | Puerto Rico | 72059 | 1980 | |
2231849 | 2231849 | 2022-02-19 | Guayanilla | Puerto Rico | 72059 | 1979 | |
2228598 | 2228598 | 2022-02-18 | Guayanilla | Puerto Rico | 72059 | 1974 | |
2225347 | 2225347 | 2022-02-17 | Guayanilla | Puerto Rico | 72059 | 1972 | |
2222096 | 2222096 | 2022-02-16 | Guayanilla | Puerto Rico | 72059 | 1972 | |
2218845 | 2218845 | 2022-02-15 | Guayanilla | Puerto Rico | 72059 | 1961 | |
2215594 | 2215594 | 2022-02-14 | Guayanilla | Puerto Rico | 72059 | 1961 | |
2212343 | 2212343 | 2022-02-13 | Guayanilla | Puerto Rico | 72059 | 1961 | |
2209090 | 2209090 | 2022-02-12 | Guayanilla | Puerto Rico | 72059 | 1954 | |
2205837 | 2205837 | 2022-02-11 | Guayanilla | Puerto Rico | 72059 | 1953 | |
2202584 | 2202584 | 2022-02-10 | Guayanilla | Puerto Rico | 72059 | 1952 | |
2199330 | 2199330 | 2022-02-09 | Guayanilla | Puerto Rico | 72059 | 1945 | |
2196076 | 2196076 | 2022-02-08 | Guayanilla | Puerto Rico | 72059 | 1945 | |
2192822 | 2192822 | 2022-02-07 | Guayanilla | Puerto Rico | 72059 | 1945 | |
2189568 | 2189568 | 2022-02-06 | Guayanilla | Puerto Rico | 72059 | 1944 | |
2186315 | 2186315 | 2022-02-05 | Guayanilla | Puerto Rico | 72059 | 1934 | |
2183063 | 2183063 | 2022-02-04 | Guayanilla | Puerto Rico | 72059 | 1930 | |
2179811 | 2179811 | 2022-02-03 | Guayanilla | Puerto Rico | 72059 | 1918 | |
2176560 | 2176560 | 2022-02-02 | Guayanilla | Puerto Rico | 72059 | 1891 |
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);