ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Carolina" 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 |
---|---|---|---|---|---|---|---|
2176545 | 2176545 | 2022-02-02 | Carolina | Puerto Rico | 72031 | 26436 | |
2173291 | 2173291 | 2022-02-01 | Carolina | Puerto Rico | 72031 | 26356 | |
2170039 | 2170039 | 2022-01-31 | Carolina | Puerto Rico | 72031 | 26353 | |
2166785 | 2166785 | 2022-01-30 | Carolina | Puerto Rico | 72031 | 26317 | |
2163530 | 2163530 | 2022-01-29 | Carolina | Puerto Rico | 72031 | 26239 | |
2160275 | 2160275 | 2022-01-28 | Carolina | Puerto Rico | 72031 | 26181 | |
2157019 | 2157019 | 2022-01-27 | Carolina | Puerto Rico | 72031 | 26027 | |
2153766 | 2153766 | 2022-01-26 | Carolina | Puerto Rico | 72031 | 25957 | |
2150514 | 2150514 | 2022-01-25 | Carolina | Puerto Rico | 72031 | 25755 | |
2147262 | 2147262 | 2022-01-24 | Carolina | Puerto Rico | 72031 | 25741 | |
2144008 | 2144008 | 2022-01-23 | Carolina | Puerto Rico | 72031 | 25647 | |
2140753 | 2140753 | 2022-01-22 | Carolina | Puerto Rico | 72031 | 25502 | |
2137497 | 2137497 | 2022-01-21 | Carolina | Puerto Rico | 72031 | 25260 | |
2134243 | 2134243 | 2022-01-20 | Carolina | Puerto Rico | 72031 | 25054 | |
2130991 | 2130991 | 2022-01-19 | Carolina | Puerto Rico | 72031 | 24891 | |
2127737 | 2127737 | 2022-01-18 | Carolina | Puerto Rico | 72031 | 24789 | |
2124485 | 2124485 | 2022-01-17 | Carolina | Puerto Rico | 72031 | 24765 | |
2121233 | 2121233 | 2022-01-16 | Carolina | Puerto Rico | 72031 | 24532 | |
2117981 | 2117981 | 2022-01-15 | Carolina | Puerto Rico | 72031 | 24294 | |
2114730 | 2114730 | 2022-01-14 | Carolina | Puerto Rico | 72031 | 23798 | |
2111478 | 2111478 | 2022-01-13 | Carolina | Puerto Rico | 72031 | 23243 | |
2108226 | 2108226 | 2022-01-12 | Carolina | Puerto Rico | 72031 | 22758 | |
2104975 | 2104975 | 2022-01-11 | Carolina | Puerto Rico | 72031 | 22307 | |
2101724 | 2101724 | 2022-01-10 | Carolina | Puerto Rico | 72031 | 22202 | |
2098473 | 2098473 | 2022-01-09 | Carolina | Puerto Rico | 72031 | 21893 | |
2095221 | 2095221 | 2022-01-08 | Carolina | Puerto Rico | 72031 | 21615 | |
2091969 | 2091969 | 2022-01-07 | Carolina | Puerto Rico | 72031 | 21334 | |
2088717 | 2088717 | 2022-01-06 | Carolina | Puerto Rico | 72031 | 20645 | |
2085466 | 2085466 | 2022-01-05 | Carolina | Puerto Rico | 72031 | 20096 | |
2082214 | 2082214 | 2022-01-04 | Carolina | Puerto Rico | 72031 | 19695 | |
2078962 | 2078962 | 2022-01-03 | Carolina | Puerto Rico | 72031 | 19614 | |
2075711 | 2075711 | 2022-01-02 | Carolina | Puerto Rico | 72031 | 19445 | |
2072460 | 2072460 | 2022-01-01 | Carolina | Puerto Rico | 72031 | 18215 | |
2069209 | 2069209 | 2021-12-31 | Carolina | Puerto Rico | 72031 | 18215 | |
2065958 | 2065958 | 2021-12-30 | Carolina | Puerto Rico | 72031 | 17448 | |
2062708 | 2062708 | 2021-12-29 | Carolina | Puerto Rico | 72031 | 16552 | |
2059458 | 2059458 | 2021-12-28 | Carolina | Puerto Rico | 72031 | 16044 | |
2056209 | 2056209 | 2021-12-27 | Carolina | Puerto Rico | 72031 | 15941 | |
2052960 | 2052960 | 2021-12-26 | Carolina | Puerto Rico | 72031 | 15877 | |
2049710 | 2049710 | 2021-12-25 | Carolina | Puerto Rico | 72031 | 15462 | |
2046460 | 2046460 | 2021-12-24 | Carolina | Puerto Rico | 72031 | 14403 | |
2043210 | 2043210 | 2021-12-23 | Carolina | Puerto Rico | 72031 | 14401 | |
2039961 | 2039961 | 2021-12-22 | Carolina | Puerto Rico | 72031 | 13978 | |
2036711 | 2036711 | 2021-12-21 | Carolina | Puerto Rico | 72031 | 13775 | |
2033461 | 2033461 | 2021-12-20 | Carolina | Puerto Rico | 72031 | 13737 | |
2030211 | 2030211 | 2021-12-19 | Carolina | Puerto Rico | 72031 | 13553 | |
2026960 | 2026960 | 2021-12-18 | Carolina | Puerto Rico | 72031 | 13414 | |
2023709 | 2023709 | 2021-12-17 | Carolina | Puerto Rico | 72031 | 13307 | |
2020458 | 2020458 | 2021-12-16 | Carolina | Puerto Rico | 72031 | 13260 | |
2017207 | 2017207 | 2021-12-15 | Carolina | Puerto Rico | 72031 | 13231 | |
2013957 | 2013957 | 2021-12-14 | Carolina | Puerto Rico | 72031 | 13221 | |
2010706 | 2010706 | 2021-12-13 | Carolina | Puerto Rico | 72031 | 13210 | |
2007455 | 2007455 | 2021-12-12 | Carolina | Puerto Rico | 72031 | 13210 | |
2004204 | 2004204 | 2021-12-11 | Carolina | Puerto Rico | 72031 | 13202 | |
2000953 | 2000953 | 2021-12-10 | Carolina | Puerto Rico | 72031 | 13202 | |
1997703 | 1997703 | 2021-12-09 | Carolina | Puerto Rico | 72031 | 13188 | |
1994452 | 1994452 | 2021-12-08 | Carolina | Puerto Rico | 72031 | 13178 | |
1991201 | 1991201 | 2021-12-07 | Carolina | Puerto Rico | 72031 | 13167 | |
1987950 | 1987950 | 2021-12-06 | Carolina | Puerto Rico | 72031 | 13167 | |
1984700 | 1984700 | 2021-12-05 | Carolina | Puerto Rico | 72031 | 13163 | |
1981450 | 1981450 | 2021-12-04 | Carolina | Puerto Rico | 72031 | 13158 | |
1978200 | 1978200 | 2021-12-03 | Carolina | Puerto Rico | 72031 | 13153 | |
1974950 | 1974950 | 2021-12-02 | Carolina | Puerto Rico | 72031 | 13148 | |
1971701 | 1971701 | 2021-12-01 | Carolina | Puerto Rico | 72031 | 13144 | |
1968451 | 1968451 | 2021-11-30 | Carolina | Puerto Rico | 72031 | 13137 | |
1965200 | 1965200 | 2021-11-29 | Carolina | Puerto Rico | 72031 | 13136 | |
1961948 | 1961948 | 2021-11-28 | Carolina | Puerto Rico | 72031 | 13134 | |
1958697 | 1958697 | 2021-11-27 | Carolina | Puerto Rico | 72031 | 13130 | |
1955446 | 1955446 | 2021-11-26 | Carolina | Puerto Rico | 72031 | 13130 | |
1952195 | 1952195 | 2021-11-25 | Carolina | Puerto Rico | 72031 | 13127 | |
1948944 | 1948944 | 2021-11-24 | Carolina | Puerto Rico | 72031 | 13124 | |
1945693 | 1945693 | 2021-11-23 | Carolina | Puerto Rico | 72031 | 13120 | |
1942442 | 1942442 | 2021-11-22 | Carolina | Puerto Rico | 72031 | 13120 | |
1939192 | 1939192 | 2021-11-21 | Carolina | Puerto Rico | 72031 | 13116 | |
1935942 | 1935942 | 2021-11-20 | Carolina | Puerto Rico | 72031 | 13110 | |
1932692 | 1932692 | 2021-11-19 | Carolina | Puerto Rico | 72031 | 13105 | |
1929441 | 1929441 | 2021-11-18 | Carolina | Puerto Rico | 72031 | 13097 | |
1926191 | 1926191 | 2021-11-17 | Carolina | Puerto Rico | 72031 | 13088 | |
1922941 | 1922941 | 2021-11-16 | Carolina | Puerto Rico | 72031 | 13082 | |
1919692 | 1919692 | 2021-11-15 | Carolina | Puerto Rico | 72031 | 13082 | |
1916442 | 1916442 | 2021-11-14 | Carolina | Puerto Rico | 72031 | 13079 | |
1913192 | 1913192 | 2021-11-13 | Carolina | Puerto Rico | 72031 | 13075 | |
1909942 | 1909942 | 2021-11-12 | Carolina | Puerto Rico | 72031 | 13071 | |
1906693 | 1906693 | 2021-11-11 | Carolina | Puerto Rico | 72031 | 13066 | |
1903444 | 1903444 | 2021-11-10 | Carolina | Puerto Rico | 72031 | 13061 | |
1900194 | 1900194 | 2021-11-09 | Carolina | Puerto Rico | 72031 | 13058 | |
1896944 | 1896944 | 2021-11-08 | Carolina | Puerto Rico | 72031 | 13057 | |
1893694 | 1893694 | 2021-11-07 | Carolina | Puerto Rico | 72031 | 13052 | |
1890444 | 1890444 | 2021-11-06 | Carolina | Puerto Rico | 72031 | 13042 | |
1887194 | 1887194 | 2021-11-05 | Carolina | Puerto Rico | 72031 | 13042 | |
1883944 | 1883944 | 2021-11-04 | Carolina | Puerto Rico | 72031 | 13040 | |
1880695 | 1880695 | 2021-11-03 | Carolina | Puerto Rico | 72031 | 13031 | |
1877446 | 1877446 | 2021-11-02 | Carolina | Puerto Rico | 72031 | 13023 | |
1874197 | 1874197 | 2021-11-01 | Carolina | Puerto Rico | 72031 | 13022 | |
1870948 | 1870948 | 2021-10-31 | Carolina | Puerto Rico | 72031 | 13020 | |
1867699 | 1867699 | 2021-10-30 | Carolina | Puerto Rico | 72031 | 13014 | |
1864450 | 1864450 | 2021-10-29 | Carolina | Puerto Rico | 72031 | 13007 | |
1861201 | 1861201 | 2021-10-28 | Carolina | Puerto Rico | 72031 | 13005 | |
1857952 | 1857952 | 2021-10-27 | Carolina | Puerto Rico | 72031 | 13004 | |
1854703 | 1854703 | 2021-10-26 | Carolina | Puerto Rico | 72031 | 13000 |
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);