ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Guayama" 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 |
---|---|---|---|---|---|---|---|
2176559 | 2176559 | 2022-02-02 | Guayama | Puerto Rico | 72057 | 4336 | |
2173305 | 2173305 | 2022-02-01 | Guayama | Puerto Rico | 72057 | 4331 | |
2170053 | 2170053 | 2022-01-31 | Guayama | Puerto Rico | 72057 | 4326 | |
2166799 | 2166799 | 2022-01-30 | Guayama | Puerto Rico | 72057 | 4301 | |
2163544 | 2163544 | 2022-01-29 | Guayama | Puerto Rico | 72057 | 4279 | |
2160289 | 2160289 | 2022-01-28 | Guayama | Puerto Rico | 72057 | 4271 | |
2157033 | 2157033 | 2022-01-27 | Guayama | Puerto Rico | 72057 | 4237 | |
2153780 | 2153780 | 2022-01-26 | Guayama | Puerto Rico | 72057 | 4198 | |
2150528 | 2150528 | 2022-01-25 | Guayama | Puerto Rico | 72057 | 4164 | |
2147276 | 2147276 | 2022-01-24 | Guayama | Puerto Rico | 72057 | 4160 | |
2144022 | 2144022 | 2022-01-23 | Guayama | Puerto Rico | 72057 | 4111 | |
2140767 | 2140767 | 2022-01-22 | Guayama | Puerto Rico | 72057 | 4089 | |
2137511 | 2137511 | 2022-01-21 | Guayama | Puerto Rico | 72057 | 4046 | |
2134257 | 2134257 | 2022-01-20 | Guayama | Puerto Rico | 72057 | 3970 | |
2131005 | 2131005 | 2022-01-19 | Guayama | Puerto Rico | 72057 | 3917 | |
2127751 | 2127751 | 2022-01-18 | Guayama | Puerto Rico | 72057 | 3898 | |
2124499 | 2124499 | 2022-01-17 | Guayama | Puerto Rico | 72057 | 3888 | |
2121247 | 2121247 | 2022-01-16 | Guayama | Puerto Rico | 72057 | 3813 | |
2117995 | 2117995 | 2022-01-15 | Guayama | Puerto Rico | 72057 | 3758 | |
2114744 | 2114744 | 2022-01-14 | Guayama | Puerto Rico | 72057 | 3685 | |
2111492 | 2111492 | 2022-01-13 | Guayama | Puerto Rico | 72057 | 3525 | |
2108240 | 2108240 | 2022-01-12 | Guayama | Puerto Rico | 72057 | 3420 | |
2104989 | 2104989 | 2022-01-11 | Guayama | Puerto Rico | 72057 | 3384 | |
2101738 | 2101738 | 2022-01-10 | Guayama | Puerto Rico | 72057 | 3364 | |
2098487 | 2098487 | 2022-01-09 | Guayama | Puerto Rico | 72057 | 3244 | |
2095235 | 2095235 | 2022-01-08 | Guayama | Puerto Rico | 72057 | 3182 | |
2091983 | 2091983 | 2022-01-07 | Guayama | Puerto Rico | 72057 | 3074 | |
2088731 | 2088731 | 2022-01-06 | Guayama | Puerto Rico | 72057 | 2852 | |
2085480 | 2085480 | 2022-01-05 | Guayama | Puerto Rico | 72057 | 2627 | |
2082228 | 2082228 | 2022-01-04 | Guayama | Puerto Rico | 72057 | 2568 | |
2078976 | 2078976 | 2022-01-03 | Guayama | Puerto Rico | 72057 | 2546 | |
2075725 | 2075725 | 2022-01-02 | Guayama | Puerto Rico | 72057 | 2509 | |
2072474 | 2072474 | 2022-01-01 | Guayama | Puerto Rico | 72057 | 2160 | |
2069223 | 2069223 | 2021-12-31 | Guayama | Puerto Rico | 72057 | 2160 | |
2065972 | 2065972 | 2021-12-30 | Guayama | Puerto Rico | 72057 | 2019 | |
2062722 | 2062722 | 2021-12-29 | Guayama | Puerto Rico | 72057 | 1868 | |
2059472 | 2059472 | 2021-12-28 | Guayama | Puerto Rico | 72057 | 1826 | |
2056223 | 2056223 | 2021-12-27 | Guayama | Puerto Rico | 72057 | 1809 | |
2052974 | 2052974 | 2021-12-26 | Guayama | Puerto Rico | 72057 | 1784 | |
2049724 | 2049724 | 2021-12-25 | Guayama | Puerto Rico | 72057 | 1694 | |
2046474 | 2046474 | 2021-12-24 | Guayama | Puerto Rico | 72057 | 1582 | |
2043224 | 2043224 | 2021-12-23 | Guayama | Puerto Rico | 72057 | 1582 | |
2039975 | 2039975 | 2021-12-22 | Guayama | Puerto Rico | 72057 | 1550 | |
2036725 | 2036725 | 2021-12-21 | Guayama | Puerto Rico | 72057 | 1531 | |
2033475 | 2033475 | 2021-12-20 | Guayama | Puerto Rico | 72057 | 1520 | |
2030225 | 2030225 | 2021-12-19 | Guayama | Puerto Rico | 72057 | 1486 | |
2026974 | 2026974 | 2021-12-18 | Guayama | Puerto Rico | 72057 | 1464 | |
2023723 | 2023723 | 2021-12-17 | Guayama | Puerto Rico | 72057 | 1454 | |
2020472 | 2020472 | 2021-12-16 | Guayama | Puerto Rico | 72057 | 1439 | |
2017221 | 2017221 | 2021-12-15 | Guayama | Puerto Rico | 72057 | 1437 | |
2013971 | 2013971 | 2021-12-14 | Guayama | Puerto Rico | 72057 | 1434 | |
2010720 | 2010720 | 2021-12-13 | Guayama | Puerto Rico | 72057 | 1434 | |
2007469 | 2007469 | 2021-12-12 | Guayama | Puerto Rico | 72057 | 1434 | |
2004218 | 2004218 | 2021-12-11 | Guayama | Puerto Rico | 72057 | 1434 | |
2000967 | 2000967 | 2021-12-10 | Guayama | Puerto Rico | 72057 | 1434 | |
1997717 | 1997717 | 2021-12-09 | Guayama | Puerto Rico | 72057 | 1433 | |
1994466 | 1994466 | 2021-12-08 | Guayama | Puerto Rico | 72057 | 1424 | |
1991215 | 1991215 | 2021-12-07 | Guayama | Puerto Rico | 72057 | 1424 | |
1987964 | 1987964 | 2021-12-06 | Guayama | Puerto Rico | 72057 | 1424 | |
1984714 | 1984714 | 2021-12-05 | Guayama | Puerto Rico | 72057 | 1422 | |
1981464 | 1981464 | 2021-12-04 | Guayama | Puerto Rico | 72057 | 1421 | |
1978214 | 1978214 | 2021-12-03 | Guayama | Puerto Rico | 72057 | 1412 | |
1974964 | 1974964 | 2021-12-02 | Guayama | Puerto Rico | 72057 | 1411 | |
1971715 | 1971715 | 2021-12-01 | Guayama | Puerto Rico | 72057 | 1405 | |
1968465 | 1968465 | 2021-11-30 | Guayama | Puerto Rico | 72057 | 1404 | |
1965214 | 1965214 | 2021-11-29 | Guayama | Puerto Rico | 72057 | 1403 | |
1961962 | 1961962 | 2021-11-28 | Guayama | Puerto Rico | 72057 | 1404 | |
1958711 | 1958711 | 2021-11-27 | Guayama | Puerto Rico | 72057 | 1404 | |
1955460 | 1955460 | 2021-11-26 | Guayama | Puerto Rico | 72057 | 1394 | |
1952209 | 1952209 | 2021-11-25 | Guayama | Puerto Rico | 72057 | 1391 | |
1948958 | 1948958 | 2021-11-24 | Guayama | Puerto Rico | 72057 | 1390 | |
1945707 | 1945707 | 2021-11-23 | Guayama | Puerto Rico | 72057 | 1390 | |
1942456 | 1942456 | 2021-11-22 | Guayama | Puerto Rico | 72057 | 1390 | |
1939206 | 1939206 | 2021-11-21 | Guayama | Puerto Rico | 72057 | 1389 | |
1935956 | 1935956 | 2021-11-20 | Guayama | Puerto Rico | 72057 | 1388 | |
1932706 | 1932706 | 2021-11-19 | Guayama | Puerto Rico | 72057 | 1384 | |
1929455 | 1929455 | 2021-11-18 | Guayama | Puerto Rico | 72057 | 1370 | |
1926205 | 1926205 | 2021-11-17 | Guayama | Puerto Rico | 72057 | 1370 | |
1922955 | 1922955 | 2021-11-16 | Guayama | Puerto Rico | 72057 | 1366 | |
1919706 | 1919706 | 2021-11-15 | Guayama | Puerto Rico | 72057 | 1365 | |
1916456 | 1916456 | 2021-11-14 | Guayama | Puerto Rico | 72057 | 1365 | |
1913206 | 1913206 | 2021-11-13 | Guayama | Puerto Rico | 72057 | 1364 | |
1909956 | 1909956 | 2021-11-12 | Guayama | Puerto Rico | 72057 | 1363 | |
1906707 | 1906707 | 2021-11-11 | Guayama | Puerto Rico | 72057 | 1361 | |
1903458 | 1903458 | 2021-11-10 | Guayama | Puerto Rico | 72057 | 1360 | |
1900208 | 1900208 | 2021-11-09 | Guayama | Puerto Rico | 72057 | 1360 | |
1896958 | 1896958 | 2021-11-08 | Guayama | Puerto Rico | 72057 | 1360 | |
1893708 | 1893708 | 2021-11-07 | Guayama | Puerto Rico | 72057 | 1357 | |
1890458 | 1890458 | 2021-11-06 | Guayama | Puerto Rico | 72057 | 1356 | |
1887208 | 1887208 | 2021-11-05 | Guayama | Puerto Rico | 72057 | 1354 | |
1883958 | 1883958 | 2021-11-04 | Guayama | Puerto Rico | 72057 | 1353 | |
1880709 | 1880709 | 2021-11-03 | Guayama | Puerto Rico | 72057 | 1352 | |
1877460 | 1877460 | 2021-11-02 | Guayama | Puerto Rico | 72057 | 1352 | |
1874211 | 1874211 | 2021-11-01 | Guayama | Puerto Rico | 72057 | 1352 | |
1870962 | 1870962 | 2021-10-31 | Guayama | Puerto Rico | 72057 | 1350 | |
1867713 | 1867713 | 2021-10-30 | Guayama | Puerto Rico | 72057 | 1349 | |
1864464 | 1864464 | 2021-10-29 | Guayama | Puerto Rico | 72057 | 1349 | |
1861215 | 1861215 | 2021-10-28 | Guayama | Puerto Rico | 72057 | 1349 | |
1857966 | 1857966 | 2021-10-27 | Guayama | Puerto Rico | 72057 | 1349 | |
1854717 | 1854717 | 2021-10-26 | Guayama | Puerto Rico | 72057 | 1349 |
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);