ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ciales" 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 |
---|---|---|---|---|---|---|---|
2176549 | 2176549 | 2022-02-02 | Ciales | Puerto Rico | 72039 | 2395 | |
2173295 | 2173295 | 2022-02-01 | Ciales | Puerto Rico | 72039 | 2388 | |
2170043 | 2170043 | 2022-01-31 | Ciales | Puerto Rico | 72039 | 2387 | |
2166789 | 2166789 | 2022-01-30 | Ciales | Puerto Rico | 72039 | 2382 | |
2163534 | 2163534 | 2022-01-29 | Ciales | Puerto Rico | 72039 | 2366 | |
2160279 | 2160279 | 2022-01-28 | Ciales | Puerto Rico | 72039 | 2353 | |
2157023 | 2157023 | 2022-01-27 | Ciales | Puerto Rico | 72039 | 2334 | |
2153770 | 2153770 | 2022-01-26 | Ciales | Puerto Rico | 72039 | 2319 | |
2150518 | 2150518 | 2022-01-25 | Ciales | Puerto Rico | 72039 | 2297 | |
2147266 | 2147266 | 2022-01-24 | Ciales | Puerto Rico | 72039 | 2297 | |
2144012 | 2144012 | 2022-01-23 | Ciales | Puerto Rico | 72039 | 2286 | |
2140757 | 2140757 | 2022-01-22 | Ciales | Puerto Rico | 72039 | 2261 | |
2137501 | 2137501 | 2022-01-21 | Ciales | Puerto Rico | 72039 | 2225 | |
2134247 | 2134247 | 2022-01-20 | Ciales | Puerto Rico | 72039 | 2193 | |
2130995 | 2130995 | 2022-01-19 | Ciales | Puerto Rico | 72039 | 2171 | |
2127741 | 2127741 | 2022-01-18 | Ciales | Puerto Rico | 72039 | 2149 | |
2124489 | 2124489 | 2022-01-17 | Ciales | Puerto Rico | 72039 | 2136 | |
2121237 | 2121237 | 2022-01-16 | Ciales | Puerto Rico | 72039 | 2110 | |
2117985 | 2117985 | 2022-01-15 | Ciales | Puerto Rico | 72039 | 2086 | |
2114734 | 2114734 | 2022-01-14 | Ciales | Puerto Rico | 72039 | 2051 | |
2111482 | 2111482 | 2022-01-13 | Ciales | Puerto Rico | 72039 | 1972 | |
2108230 | 2108230 | 2022-01-12 | Ciales | Puerto Rico | 72039 | 1913 | |
2104979 | 2104979 | 2022-01-11 | Ciales | Puerto Rico | 72039 | 1877 | |
2101728 | 2101728 | 2022-01-10 | Ciales | Puerto Rico | 72039 | 1856 | |
2098477 | 2098477 | 2022-01-09 | Ciales | Puerto Rico | 72039 | 1819 | |
2095225 | 2095225 | 2022-01-08 | Ciales | Puerto Rico | 72039 | 1765 | |
2091973 | 2091973 | 2022-01-07 | Ciales | Puerto Rico | 72039 | 1735 | |
2088721 | 2088721 | 2022-01-06 | Ciales | Puerto Rico | 72039 | 1680 | |
2085470 | 2085470 | 2022-01-05 | Ciales | Puerto Rico | 72039 | 1591 | |
2082218 | 2082218 | 2022-01-04 | Ciales | Puerto Rico | 72039 | 1567 | |
2078966 | 2078966 | 2022-01-03 | Ciales | Puerto Rico | 72039 | 1559 | |
2075715 | 2075715 | 2022-01-02 | Ciales | Puerto Rico | 72039 | 1540 | |
2072464 | 2072464 | 2022-01-01 | Ciales | Puerto Rico | 72039 | 1424 | |
2069213 | 2069213 | 2021-12-31 | Ciales | Puerto Rico | 72039 | 1424 | |
2065962 | 2065962 | 2021-12-30 | Ciales | Puerto Rico | 72039 | 1346 | |
2062712 | 2062712 | 2021-12-29 | Ciales | Puerto Rico | 72039 | 1269 | |
2059462 | 2059462 | 2021-12-28 | Ciales | Puerto Rico | 72039 | 1240 | |
2056213 | 2056213 | 2021-12-27 | Ciales | Puerto Rico | 72039 | 1236 | |
2052964 | 2052964 | 2021-12-26 | Ciales | Puerto Rico | 72039 | 1235 | |
2049714 | 2049714 | 2021-12-25 | Ciales | Puerto Rico | 72039 | 1228 | |
2046464 | 2046464 | 2021-12-24 | Ciales | Puerto Rico | 72039 | 1175 | |
2043214 | 2043214 | 2021-12-23 | Ciales | Puerto Rico | 72039 | 1175 | |
2039965 | 2039965 | 2021-12-22 | Ciales | Puerto Rico | 72039 | 1156 | |
2036715 | 2036715 | 2021-12-21 | Ciales | Puerto Rico | 72039 | 1145 | |
2033465 | 2033465 | 2021-12-20 | Ciales | Puerto Rico | 72039 | 1142 | |
2030215 | 2030215 | 2021-12-19 | Ciales | Puerto Rico | 72039 | 1131 | |
2026964 | 2026964 | 2021-12-18 | Ciales | Puerto Rico | 72039 | 1129 | |
2023713 | 2023713 | 2021-12-17 | Ciales | Puerto Rico | 72039 | 1120 | |
2020462 | 2020462 | 2021-12-16 | Ciales | Puerto Rico | 72039 | 1117 | |
2017211 | 2017211 | 2021-12-15 | Ciales | Puerto Rico | 72039 | 1113 | |
2013961 | 2013961 | 2021-12-14 | Ciales | Puerto Rico | 72039 | 1113 | |
2010710 | 2010710 | 2021-12-13 | Ciales | Puerto Rico | 72039 | 1111 | |
2007459 | 2007459 | 2021-12-12 | Ciales | Puerto Rico | 72039 | 1111 | |
2004208 | 2004208 | 2021-12-11 | Ciales | Puerto Rico | 72039 | 1108 | |
2000957 | 2000957 | 2021-12-10 | Ciales | Puerto Rico | 72039 | 1108 | |
1997707 | 1997707 | 2021-12-09 | Ciales | Puerto Rico | 72039 | 1103 | |
1994456 | 1994456 | 2021-12-08 | Ciales | Puerto Rico | 72039 | 1102 | |
1991205 | 1991205 | 2021-12-07 | Ciales | Puerto Rico | 72039 | 1100 | |
1987954 | 1987954 | 2021-12-06 | Ciales | Puerto Rico | 72039 | 1100 | |
1984704 | 1984704 | 2021-12-05 | Ciales | Puerto Rico | 72039 | 1100 | |
1981454 | 1981454 | 2021-12-04 | Ciales | Puerto Rico | 72039 | 1099 | |
1978204 | 1978204 | 2021-12-03 | Ciales | Puerto Rico | 72039 | 1099 | |
1974954 | 1974954 | 2021-12-02 | Ciales | Puerto Rico | 72039 | 1091 | |
1971705 | 1971705 | 2021-12-01 | Ciales | Puerto Rico | 72039 | 1091 | |
1968455 | 1968455 | 2021-11-30 | Ciales | Puerto Rico | 72039 | 1091 | |
1965204 | 1965204 | 2021-11-29 | Ciales | Puerto Rico | 72039 | 1090 | |
1961952 | 1961952 | 2021-11-28 | Ciales | Puerto Rico | 72039 | 1090 | |
1958701 | 1958701 | 2021-11-27 | Ciales | Puerto Rico | 72039 | 1089 | |
1955450 | 1955450 | 2021-11-26 | Ciales | Puerto Rico | 72039 | 1089 | |
1952199 | 1952199 | 2021-11-25 | Ciales | Puerto Rico | 72039 | 1088 | |
1948948 | 1948948 | 2021-11-24 | Ciales | Puerto Rico | 72039 | 1088 | |
1945697 | 1945697 | 2021-11-23 | Ciales | Puerto Rico | 72039 | 1088 | |
1942446 | 1942446 | 2021-11-22 | Ciales | Puerto Rico | 72039 | 1088 | |
1939196 | 1939196 | 2021-11-21 | Ciales | Puerto Rico | 72039 | 1087 | |
1935946 | 1935946 | 2021-11-20 | Ciales | Puerto Rico | 72039 | 1087 | |
1932696 | 1932696 | 2021-11-19 | Ciales | Puerto Rico | 72039 | 1087 | |
1929445 | 1929445 | 2021-11-18 | Ciales | Puerto Rico | 72039 | 1087 | |
1926195 | 1926195 | 2021-11-17 | Ciales | Puerto Rico | 72039 | 1086 | |
1922945 | 1922945 | 2021-11-16 | Ciales | Puerto Rico | 72039 | 1086 | |
1919696 | 1919696 | 2021-11-15 | Ciales | Puerto Rico | 72039 | 1086 | |
1916446 | 1916446 | 2021-11-14 | Ciales | Puerto Rico | 72039 | 1086 | |
1913196 | 1913196 | 2021-11-13 | Ciales | Puerto Rico | 72039 | 1086 | |
1909946 | 1909946 | 2021-11-12 | Ciales | Puerto Rico | 72039 | 1083 | |
1906697 | 1906697 | 2021-11-11 | Ciales | Puerto Rico | 72039 | 1083 | |
1903448 | 1903448 | 2021-11-10 | Ciales | Puerto Rico | 72039 | 1082 | |
1900198 | 1900198 | 2021-11-09 | Ciales | Puerto Rico | 72039 | 1082 | |
1896948 | 1896948 | 2021-11-08 | Ciales | Puerto Rico | 72039 | 1082 | |
1893698 | 1893698 | 2021-11-07 | Ciales | Puerto Rico | 72039 | 1081 | |
1890448 | 1890448 | 2021-11-06 | Ciales | Puerto Rico | 72039 | 1081 | |
1887198 | 1887198 | 2021-11-05 | Ciales | Puerto Rico | 72039 | 1080 | |
1883948 | 1883948 | 2021-11-04 | Ciales | Puerto Rico | 72039 | 1080 | |
1880699 | 1880699 | 2021-11-03 | Ciales | Puerto Rico | 72039 | 1079 | |
1877450 | 1877450 | 2021-11-02 | Ciales | Puerto Rico | 72039 | 1077 | |
1874201 | 1874201 | 2021-11-01 | Ciales | Puerto Rico | 72039 | 1077 | |
1870952 | 1870952 | 2021-10-31 | Ciales | Puerto Rico | 72039 | 1077 | |
1867703 | 1867703 | 2021-10-30 | Ciales | Puerto Rico | 72039 | 1075 | |
1864454 | 1864454 | 2021-10-29 | Ciales | Puerto Rico | 72039 | 1075 | |
1861205 | 1861205 | 2021-10-28 | Ciales | Puerto Rico | 72039 | 1075 | |
1857956 | 1857956 | 2021-10-27 | Ciales | Puerto Rico | 72039 | 1075 | |
1854707 | 1854707 | 2021-10-26 | Ciales | Puerto Rico | 72039 | 1075 |
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);