ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72055 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 |
---|---|---|---|---|---|---|---|
2176558 | 2176558 | 2022-02-02 | Guanica | Puerto Rico | 72055 | 1365 | |
2173304 | 2173304 | 2022-02-01 | Guanica | Puerto Rico | 72055 | 1362 | |
2170052 | 2170052 | 2022-01-31 | Guanica | Puerto Rico | 72055 | 1362 | |
2166798 | 2166798 | 2022-01-30 | Guanica | Puerto Rico | 72055 | 1358 | |
2163543 | 2163543 | 2022-01-29 | Guanica | Puerto Rico | 72055 | 1353 | |
2160288 | 2160288 | 2022-01-28 | Guanica | Puerto Rico | 72055 | 1348 | |
2157032 | 2157032 | 2022-01-27 | Guanica | Puerto Rico | 72055 | 1320 | |
2153779 | 2153779 | 2022-01-26 | Guanica | Puerto Rico | 72055 | 1316 | |
2150527 | 2150527 | 2022-01-25 | Guanica | Puerto Rico | 72055 | 1298 | |
2147275 | 2147275 | 2022-01-24 | Guanica | Puerto Rico | 72055 | 1298 | |
2144021 | 2144021 | 2022-01-23 | Guanica | Puerto Rico | 72055 | 1288 | |
2140766 | 2140766 | 2022-01-22 | Guanica | Puerto Rico | 72055 | 1276 | |
2137510 | 2137510 | 2022-01-21 | Guanica | Puerto Rico | 72055 | 1263 | |
2134256 | 2134256 | 2022-01-20 | Guanica | Puerto Rico | 72055 | 1245 | |
2131004 | 2131004 | 2022-01-19 | Guanica | Puerto Rico | 72055 | 1218 | |
2127750 | 2127750 | 2022-01-18 | Guanica | Puerto Rico | 72055 | 1201 | |
2124498 | 2124498 | 2022-01-17 | Guanica | Puerto Rico | 72055 | 1200 | |
2121246 | 2121246 | 2022-01-16 | Guanica | Puerto Rico | 72055 | 1184 | |
2117994 | 2117994 | 2022-01-15 | Guanica | Puerto Rico | 72055 | 1164 | |
2114743 | 2114743 | 2022-01-14 | Guanica | Puerto Rico | 72055 | 1133 | |
2111491 | 2111491 | 2022-01-13 | Guanica | Puerto Rico | 72055 | 1057 | |
2108239 | 2108239 | 2022-01-12 | Guanica | Puerto Rico | 72055 | 1002 | |
2104988 | 2104988 | 2022-01-11 | Guanica | Puerto Rico | 72055 | 972 | |
2101737 | 2101737 | 2022-01-10 | Guanica | Puerto Rico | 72055 | 970 | |
2098486 | 2098486 | 2022-01-09 | Guanica | Puerto Rico | 72055 | 953 | |
2095234 | 2095234 | 2022-01-08 | Guanica | Puerto Rico | 72055 | 895 | |
2091982 | 2091982 | 2022-01-07 | Guanica | Puerto Rico | 72055 | 886 | |
2088730 | 2088730 | 2022-01-06 | Guanica | Puerto Rico | 72055 | 839 | |
2085479 | 2085479 | 2022-01-05 | Guanica | Puerto Rico | 72055 | 774 | |
2082227 | 2082227 | 2022-01-04 | Guanica | Puerto Rico | 72055 | 748 | |
2078975 | 2078975 | 2022-01-03 | Guanica | Puerto Rico | 72055 | 747 | |
2075724 | 2075724 | 2022-01-02 | Guanica | Puerto Rico | 72055 | 738 | |
2072473 | 2072473 | 2022-01-01 | Guanica | Puerto Rico | 72055 | 672 | |
2069222 | 2069222 | 2021-12-31 | Guanica | Puerto Rico | 72055 | 672 | |
2065971 | 2065971 | 2021-12-30 | Guanica | Puerto Rico | 72055 | 623 | |
2062721 | 2062721 | 2021-12-29 | Guanica | Puerto Rico | 72055 | 589 | |
2059471 | 2059471 | 2021-12-28 | Guanica | Puerto Rico | 72055 | 579 | |
2056222 | 2056222 | 2021-12-27 | Guanica | Puerto Rico | 72055 | 578 | |
2052973 | 2052973 | 2021-12-26 | Guanica | Puerto Rico | 72055 | 577 | |
2049723 | 2049723 | 2021-12-25 | Guanica | Puerto Rico | 72055 | 558 | |
2046473 | 2046473 | 2021-12-24 | Guanica | Puerto Rico | 72055 | 516 | |
2043223 | 2043223 | 2021-12-23 | Guanica | Puerto Rico | 72055 | 516 | |
2039974 | 2039974 | 2021-12-22 | Guanica | Puerto Rico | 72055 | 505 | |
2036724 | 2036724 | 2021-12-21 | Guanica | Puerto Rico | 72055 | 496 | |
2033474 | 2033474 | 2021-12-20 | Guanica | Puerto Rico | 72055 | 492 | |
2030224 | 2030224 | 2021-12-19 | Guanica | Puerto Rico | 72055 | 486 | |
2026973 | 2026973 | 2021-12-18 | Guanica | Puerto Rico | 72055 | 472 | |
2023722 | 2023722 | 2021-12-17 | Guanica | Puerto Rico | 72055 | 467 | |
2020471 | 2020471 | 2021-12-16 | Guanica | Puerto Rico | 72055 | 461 | |
2017220 | 2017220 | 2021-12-15 | Guanica | Puerto Rico | 72055 | 461 | |
2013970 | 2013970 | 2021-12-14 | Guanica | Puerto Rico | 72055 | 461 | |
2010719 | 2010719 | 2021-12-13 | Guanica | Puerto Rico | 72055 | 460 | |
2007468 | 2007468 | 2021-12-12 | Guanica | Puerto Rico | 72055 | 460 | |
2004217 | 2004217 | 2021-12-11 | Guanica | Puerto Rico | 72055 | 460 | |
2000966 | 2000966 | 2021-12-10 | Guanica | Puerto Rico | 72055 | 460 | |
1997716 | 1997716 | 2021-12-09 | Guanica | Puerto Rico | 72055 | 460 | |
1994465 | 1994465 | 2021-12-08 | Guanica | Puerto Rico | 72055 | 460 | |
1991214 | 1991214 | 2021-12-07 | Guanica | Puerto Rico | 72055 | 459 | |
1987963 | 1987963 | 2021-12-06 | Guanica | Puerto Rico | 72055 | 459 | |
1984713 | 1984713 | 2021-12-05 | Guanica | Puerto Rico | 72055 | 459 | |
1981463 | 1981463 | 2021-12-04 | Guanica | Puerto Rico | 72055 | 459 | |
1978213 | 1978213 | 2021-12-03 | Guanica | Puerto Rico | 72055 | 459 | |
1974963 | 1974963 | 2021-12-02 | Guanica | Puerto Rico | 72055 | 458 | |
1971714 | 1971714 | 2021-12-01 | Guanica | Puerto Rico | 72055 | 458 | |
1968464 | 1968464 | 2021-11-30 | Guanica | Puerto Rico | 72055 | 458 | |
1965213 | 1965213 | 2021-11-29 | Guanica | Puerto Rico | 72055 | 458 | |
1961961 | 1961961 | 2021-11-28 | Guanica | Puerto Rico | 72055 | 458 | |
1958710 | 1958710 | 2021-11-27 | Guanica | Puerto Rico | 72055 | 458 | |
1955459 | 1955459 | 2021-11-26 | Guanica | Puerto Rico | 72055 | 458 | |
1952208 | 1952208 | 2021-11-25 | Guanica | Puerto Rico | 72055 | 457 | |
1948957 | 1948957 | 2021-11-24 | Guanica | Puerto Rico | 72055 | 456 | |
1945706 | 1945706 | 2021-11-23 | Guanica | Puerto Rico | 72055 | 456 | |
1942455 | 1942455 | 2021-11-22 | Guanica | Puerto Rico | 72055 | 456 | |
1939205 | 1939205 | 2021-11-21 | Guanica | Puerto Rico | 72055 | 456 | |
1935955 | 1935955 | 2021-11-20 | Guanica | Puerto Rico | 72055 | 455 | |
1932705 | 1932705 | 2021-11-19 | Guanica | Puerto Rico | 72055 | 455 | |
1929454 | 1929454 | 2021-11-18 | Guanica | Puerto Rico | 72055 | 455 | |
1926204 | 1926204 | 2021-11-17 | Guanica | Puerto Rico | 72055 | 455 | |
1922954 | 1922954 | 2021-11-16 | Guanica | Puerto Rico | 72055 | 453 | |
1919705 | 1919705 | 2021-11-15 | Guanica | Puerto Rico | 72055 | 453 | |
1916455 | 1916455 | 2021-11-14 | Guanica | Puerto Rico | 72055 | 452 | |
1913205 | 1913205 | 2021-11-13 | Guanica | Puerto Rico | 72055 | 452 | |
1909955 | 1909955 | 2021-11-12 | Guanica | Puerto Rico | 72055 | 450 | |
1906706 | 1906706 | 2021-11-11 | Guanica | Puerto Rico | 72055 | 450 | |
1903457 | 1903457 | 2021-11-10 | Guanica | Puerto Rico | 72055 | 450 | |
1900207 | 1900207 | 2021-11-09 | Guanica | Puerto Rico | 72055 | 450 | |
1896957 | 1896957 | 2021-11-08 | Guanica | Puerto Rico | 72055 | 450 | |
1893707 | 1893707 | 2021-11-07 | Guanica | Puerto Rico | 72055 | 450 | |
1890457 | 1890457 | 2021-11-06 | Guanica | Puerto Rico | 72055 | 450 | |
1887207 | 1887207 | 2021-11-05 | Guanica | Puerto Rico | 72055 | 450 | |
1883957 | 1883957 | 2021-11-04 | Guanica | Puerto Rico | 72055 | 449 | |
1880708 | 1880708 | 2021-11-03 | Guanica | Puerto Rico | 72055 | 448 | |
1877459 | 1877459 | 2021-11-02 | Guanica | Puerto Rico | 72055 | 448 | |
1874210 | 1874210 | 2021-11-01 | Guanica | Puerto Rico | 72055 | 448 | |
1870961 | 1870961 | 2021-10-31 | Guanica | Puerto Rico | 72055 | 448 | |
1867712 | 1867712 | 2021-10-30 | Guanica | Puerto Rico | 72055 | 448 | |
1864463 | 1864463 | 2021-10-29 | Guanica | Puerto Rico | 72055 | 448 | |
1861214 | 1861214 | 2021-10-28 | Guanica | Puerto Rico | 72055 | 448 | |
1857965 | 1857965 | 2021-10-27 | Guanica | Puerto Rico | 72055 | 447 | |
1854716 | 1854716 | 2021-10-26 | Guanica | Puerto Rico | 72055 | 446 |
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);