ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ceiba", fips = 72037 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 |
---|---|---|---|---|---|---|---|
2176548 | 2176548 | 2022-02-02 | Ceiba | Puerto Rico | 72037 | 1280 | |
2173294 | 2173294 | 2022-02-01 | Ceiba | Puerto Rico | 72037 | 1279 | |
2170042 | 2170042 | 2022-01-31 | Ceiba | Puerto Rico | 72037 | 1279 | |
2166788 | 2166788 | 2022-01-30 | Ceiba | Puerto Rico | 72037 | 1279 | |
2163533 | 2163533 | 2022-01-29 | Ceiba | Puerto Rico | 72037 | 1278 | |
2160278 | 2160278 | 2022-01-28 | Ceiba | Puerto Rico | 72037 | 1274 | |
2157022 | 2157022 | 2022-01-27 | Ceiba | Puerto Rico | 72037 | 1265 | |
2153769 | 2153769 | 2022-01-26 | Ceiba | Puerto Rico | 72037 | 1262 | |
2150517 | 2150517 | 2022-01-25 | Ceiba | Puerto Rico | 72037 | 1259 | |
2147265 | 2147265 | 2022-01-24 | Ceiba | Puerto Rico | 72037 | 1259 | |
2144011 | 2144011 | 2022-01-23 | Ceiba | Puerto Rico | 72037 | 1252 | |
2140756 | 2140756 | 2022-01-22 | Ceiba | Puerto Rico | 72037 | 1243 | |
2137500 | 2137500 | 2022-01-21 | Ceiba | Puerto Rico | 72037 | 1233 | |
2134246 | 2134246 | 2022-01-20 | Ceiba | Puerto Rico | 72037 | 1210 | |
2130994 | 2130994 | 2022-01-19 | Ceiba | Puerto Rico | 72037 | 1201 | |
2127740 | 2127740 | 2022-01-18 | Ceiba | Puerto Rico | 72037 | 1184 | |
2124488 | 2124488 | 2022-01-17 | Ceiba | Puerto Rico | 72037 | 1183 | |
2121236 | 2121236 | 2022-01-16 | Ceiba | Puerto Rico | 72037 | 1168 | |
2117984 | 2117984 | 2022-01-15 | Ceiba | Puerto Rico | 72037 | 1154 | |
2114733 | 2114733 | 2022-01-14 | Ceiba | Puerto Rico | 72037 | 1132 | |
2111481 | 2111481 | 2022-01-13 | Ceiba | Puerto Rico | 72037 | 1091 | |
2108229 | 2108229 | 2022-01-12 | Ceiba | Puerto Rico | 72037 | 1065 | |
2104978 | 2104978 | 2022-01-11 | Ceiba | Puerto Rico | 72037 | 1039 | |
2101727 | 2101727 | 2022-01-10 | Ceiba | Puerto Rico | 72037 | 1035 | |
2098476 | 2098476 | 2022-01-09 | Ceiba | Puerto Rico | 72037 | 1025 | |
2095224 | 2095224 | 2022-01-08 | Ceiba | Puerto Rico | 72037 | 995 | |
2091972 | 2091972 | 2022-01-07 | Ceiba | Puerto Rico | 72037 | 974 | |
2088720 | 2088720 | 2022-01-06 | Ceiba | Puerto Rico | 72037 | 927 | |
2085469 | 2085469 | 2022-01-05 | Ceiba | Puerto Rico | 72037 | 897 | |
2082217 | 2082217 | 2022-01-04 | Ceiba | Puerto Rico | 72037 | 881 | |
2078965 | 2078965 | 2022-01-03 | Ceiba | Puerto Rico | 72037 | 876 | |
2075714 | 2075714 | 2022-01-02 | Ceiba | Puerto Rico | 72037 | 873 | |
2072463 | 2072463 | 2022-01-01 | Ceiba | Puerto Rico | 72037 | 825 | |
2069212 | 2069212 | 2021-12-31 | Ceiba | Puerto Rico | 72037 | 825 | |
2065961 | 2065961 | 2021-12-30 | Ceiba | Puerto Rico | 72037 | 784 | |
2062711 | 2062711 | 2021-12-29 | Ceiba | Puerto Rico | 72037 | 762 | |
2059461 | 2059461 | 2021-12-28 | Ceiba | Puerto Rico | 72037 | 749 | |
2056212 | 2056212 | 2021-12-27 | Ceiba | Puerto Rico | 72037 | 749 | |
2052963 | 2052963 | 2021-12-26 | Ceiba | Puerto Rico | 72037 | 745 | |
2049713 | 2049713 | 2021-12-25 | Ceiba | Puerto Rico | 72037 | 737 | |
2046463 | 2046463 | 2021-12-24 | Ceiba | Puerto Rico | 72037 | 709 | |
2043213 | 2043213 | 2021-12-23 | Ceiba | Puerto Rico | 72037 | 709 | |
2039964 | 2039964 | 2021-12-22 | Ceiba | Puerto Rico | 72037 | 698 | |
2036714 | 2036714 | 2021-12-21 | Ceiba | Puerto Rico | 72037 | 693 | |
2033464 | 2033464 | 2021-12-20 | Ceiba | Puerto Rico | 72037 | 692 | |
2030214 | 2030214 | 2021-12-19 | Ceiba | Puerto Rico | 72037 | 691 | |
2026963 | 2026963 | 2021-12-18 | Ceiba | Puerto Rico | 72037 | 686 | |
2023712 | 2023712 | 2021-12-17 | Ceiba | Puerto Rico | 72037 | 684 | |
2020461 | 2020461 | 2021-12-16 | Ceiba | Puerto Rico | 72037 | 682 | |
2017210 | 2017210 | 2021-12-15 | Ceiba | Puerto Rico | 72037 | 682 | |
2013960 | 2013960 | 2021-12-14 | Ceiba | Puerto Rico | 72037 | 681 | |
2010709 | 2010709 | 2021-12-13 | Ceiba | Puerto Rico | 72037 | 681 | |
2007458 | 2007458 | 2021-12-12 | Ceiba | Puerto Rico | 72037 | 681 | |
2004207 | 2004207 | 2021-12-11 | Ceiba | Puerto Rico | 72037 | 681 | |
2000956 | 2000956 | 2021-12-10 | Ceiba | Puerto Rico | 72037 | 681 | |
1997706 | 1997706 | 2021-12-09 | Ceiba | Puerto Rico | 72037 | 681 | |
1994455 | 1994455 | 2021-12-08 | Ceiba | Puerto Rico | 72037 | 681 | |
1991204 | 1991204 | 2021-12-07 | Ceiba | Puerto Rico | 72037 | 680 | |
1987953 | 1987953 | 2021-12-06 | Ceiba | Puerto Rico | 72037 | 680 | |
1984703 | 1984703 | 2021-12-05 | Ceiba | Puerto Rico | 72037 | 680 | |
1981453 | 1981453 | 2021-12-04 | Ceiba | Puerto Rico | 72037 | 679 | |
1978203 | 1978203 | 2021-12-03 | Ceiba | Puerto Rico | 72037 | 678 | |
1974953 | 1974953 | 2021-12-02 | Ceiba | Puerto Rico | 72037 | 678 | |
1971704 | 1971704 | 2021-12-01 | Ceiba | Puerto Rico | 72037 | 678 | |
1968454 | 1968454 | 2021-11-30 | Ceiba | Puerto Rico | 72037 | 678 | |
1965203 | 1965203 | 2021-11-29 | Ceiba | Puerto Rico | 72037 | 678 | |
1961951 | 1961951 | 2021-11-28 | Ceiba | Puerto Rico | 72037 | 677 | |
1958700 | 1958700 | 2021-11-27 | Ceiba | Puerto Rico | 72037 | 677 | |
1955449 | 1955449 | 2021-11-26 | Ceiba | Puerto Rico | 72037 | 675 | |
1952198 | 1952198 | 2021-11-25 | Ceiba | Puerto Rico | 72037 | 675 | |
1948947 | 1948947 | 2021-11-24 | Ceiba | Puerto Rico | 72037 | 675 | |
1945696 | 1945696 | 2021-11-23 | Ceiba | Puerto Rico | 72037 | 675 | |
1942445 | 1942445 | 2021-11-22 | Ceiba | Puerto Rico | 72037 | 675 | |
1939195 | 1939195 | 2021-11-21 | Ceiba | Puerto Rico | 72037 | 674 | |
1935945 | 1935945 | 2021-11-20 | Ceiba | Puerto Rico | 72037 | 674 | |
1932695 | 1932695 | 2021-11-19 | Ceiba | Puerto Rico | 72037 | 672 | |
1929444 | 1929444 | 2021-11-18 | Ceiba | Puerto Rico | 72037 | 671 | |
1926194 | 1926194 | 2021-11-17 | Ceiba | Puerto Rico | 72037 | 670 | |
1922944 | 1922944 | 2021-11-16 | Ceiba | Puerto Rico | 72037 | 670 | |
1919695 | 1919695 | 2021-11-15 | Ceiba | Puerto Rico | 72037 | 670 | |
1916445 | 1916445 | 2021-11-14 | Ceiba | Puerto Rico | 72037 | 670 | |
1913195 | 1913195 | 2021-11-13 | Ceiba | Puerto Rico | 72037 | 670 | |
1909945 | 1909945 | 2021-11-12 | Ceiba | Puerto Rico | 72037 | 670 | |
1906696 | 1906696 | 2021-11-11 | Ceiba | Puerto Rico | 72037 | 670 | |
1903447 | 1903447 | 2021-11-10 | Ceiba | Puerto Rico | 72037 | 669 | |
1900197 | 1900197 | 2021-11-09 | Ceiba | Puerto Rico | 72037 | 669 | |
1896947 | 1896947 | 2021-11-08 | Ceiba | Puerto Rico | 72037 | 669 | |
1893697 | 1893697 | 2021-11-07 | Ceiba | Puerto Rico | 72037 | 669 | |
1890447 | 1890447 | 2021-11-06 | Ceiba | Puerto Rico | 72037 | 669 | |
1887197 | 1887197 | 2021-11-05 | Ceiba | Puerto Rico | 72037 | 668 | |
1883947 | 1883947 | 2021-11-04 | Ceiba | Puerto Rico | 72037 | 668 | |
1880698 | 1880698 | 2021-11-03 | Ceiba | Puerto Rico | 72037 | 668 | |
1877449 | 1877449 | 2021-11-02 | Ceiba | Puerto Rico | 72037 | 667 | |
1874200 | 1874200 | 2021-11-01 | Ceiba | Puerto Rico | 72037 | 667 | |
1870951 | 1870951 | 2021-10-31 | Ceiba | Puerto Rico | 72037 | 667 | |
1867702 | 1867702 | 2021-10-30 | Ceiba | Puerto Rico | 72037 | 667 | |
1864453 | 1864453 | 2021-10-29 | Ceiba | Puerto Rico | 72037 | 667 | |
1861204 | 1861204 | 2021-10-28 | Ceiba | Puerto Rico | 72037 | 667 | |
1857955 | 1857955 | 2021-10-27 | Ceiba | Puerto Rico | 72037 | 667 | |
1854706 | 1854706 | 2021-10-26 | Ceiba | Puerto Rico | 72037 | 667 |
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);