ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Santa Fe" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176036 | 2176036 | 2022-02-02 | Santa Fe | New Mexico | 35049 | 26384 | 232 |
2172783 | 2172783 | 2022-02-01 | Santa Fe | New Mexico | 35049 | 26200 | 230 |
2169530 | 2169530 | 2022-01-31 | Santa Fe | New Mexico | 35049 | 26110 | 230 |
2166275 | 2166275 | 2022-01-30 | Santa Fe | New Mexico | 35049 | 25597 | 226 |
2163020 | 2163020 | 2022-01-29 | Santa Fe | New Mexico | 35049 | 25597 | 226 |
2159765 | 2159765 | 2022-01-28 | Santa Fe | New Mexico | 35049 | 25597 | 226 |
2156511 | 2156511 | 2022-01-27 | Santa Fe | New Mexico | 35049 | 25271 | 225 |
2153258 | 2153258 | 2022-01-26 | Santa Fe | New Mexico | 35049 | 25038 | 224 |
2150006 | 2150006 | 2022-01-25 | Santa Fe | New Mexico | 35049 | 24794 | 223 |
2146754 | 2146754 | 2022-01-24 | Santa Fe | New Mexico | 35049 | 24604 | 220 |
2143499 | 2143499 | 2022-01-23 | Santa Fe | New Mexico | 35049 | 23706 | 219 |
2140244 | 2140244 | 2022-01-22 | Santa Fe | New Mexico | 35049 | 23706 | 219 |
2136988 | 2136988 | 2022-01-21 | Santa Fe | New Mexico | 35049 | 23706 | 219 |
2133736 | 2133736 | 2022-01-20 | Santa Fe | New Mexico | 35049 | 23343 | 218 |
2130483 | 2130483 | 2022-01-19 | Santa Fe | New Mexico | 35049 | 22828 | 217 |
2127229 | 2127229 | 2022-01-18 | Santa Fe | New Mexico | 35049 | 22588 | 216 |
2123977 | 2123977 | 2022-01-17 | Santa Fe | New Mexico | 35049 | 20786 | 215 |
2120725 | 2120725 | 2022-01-16 | Santa Fe | New Mexico | 35049 | 20786 | 215 |
2117473 | 2117473 | 2022-01-15 | Santa Fe | New Mexico | 35049 | 20786 | 215 |
2114222 | 2114222 | 2022-01-14 | Santa Fe | New Mexico | 35049 | 20786 | 215 |
2110970 | 2110970 | 2022-01-13 | Santa Fe | New Mexico | 35049 | 20388 | 213 |
2107719 | 2107719 | 2022-01-12 | Santa Fe | New Mexico | 35049 | 20070 | 212 |
2104468 | 2104468 | 2022-01-11 | Santa Fe | New Mexico | 35049 | 19582 | 211 |
2101217 | 2101217 | 2022-01-10 | Santa Fe | New Mexico | 35049 | 19389 | 210 |
2097966 | 2097966 | 2022-01-09 | Santa Fe | New Mexico | 35049 | 18735 | 210 |
2094714 | 2094714 | 2022-01-08 | Santa Fe | New Mexico | 35049 | 18735 | 210 |
2091462 | 2091462 | 2022-01-07 | Santa Fe | New Mexico | 35049 | 18735 | 210 |
2088211 | 2088211 | 2022-01-06 | Santa Fe | New Mexico | 35049 | 18341 | 209 |
2084959 | 2084959 | 2022-01-05 | Santa Fe | New Mexico | 35049 | 18079 | 208 |
2081707 | 2081707 | 2022-01-04 | Santa Fe | New Mexico | 35049 | 17942 | 208 |
2078455 | 2078455 | 2022-01-03 | Santa Fe | New Mexico | 35049 | 17845 | 205 |
2075204 | 2075204 | 2022-01-02 | Santa Fe | New Mexico | 35049 | 17151 | 204 |
2071953 | 2071953 | 2022-01-01 | Santa Fe | New Mexico | 35049 | 17151 | 204 |
2068702 | 2068702 | 2021-12-31 | Santa Fe | New Mexico | 35049 | 17151 | 204 |
2065451 | 2065451 | 2021-12-30 | Santa Fe | New Mexico | 35049 | 17151 | 204 |
2062201 | 2062201 | 2021-12-29 | Santa Fe | New Mexico | 35049 | 16967 | 200 |
2058952 | 2058952 | 2021-12-28 | Santa Fe | New Mexico | 35049 | 16882 | 198 |
2055703 | 2055703 | 2021-12-27 | Santa Fe | New Mexico | 35049 | 16844 | 196 |
2052453 | 2052453 | 2021-12-26 | Santa Fe | New Mexico | 35049 | 16599 | 195 |
2049203 | 2049203 | 2021-12-25 | Santa Fe | New Mexico | 35049 | 16599 | 195 |
2045953 | 2045953 | 2021-12-24 | Santa Fe | New Mexico | 35049 | 16599 | 195 |
2042703 | 2042703 | 2021-12-23 | Santa Fe | New Mexico | 35049 | 16599 | 195 |
2039454 | 2039454 | 2021-12-22 | Santa Fe | New Mexico | 35049 | 16515 | 195 |
2036204 | 2036204 | 2021-12-21 | Santa Fe | New Mexico | 35049 | 16476 | 193 |
2032954 | 2032954 | 2021-12-20 | Santa Fe | New Mexico | 35049 | 16442 | 192 |
2029703 | 2029703 | 2021-12-19 | Santa Fe | New Mexico | 35049 | 16236 | 191 |
2026452 | 2026452 | 2021-12-18 | Santa Fe | New Mexico | 35049 | 16236 | 191 |
2023201 | 2023201 | 2021-12-17 | Santa Fe | New Mexico | 35049 | 16236 | 191 |
2019950 | 2019950 | 2021-12-16 | Santa Fe | New Mexico | 35049 | 16135 | 191 |
2016700 | 2016700 | 2021-12-15 | Santa Fe | New Mexico | 35049 | 16068 | 190 |
2013449 | 2013449 | 2021-12-14 | Santa Fe | New Mexico | 35049 | 16011 | 188 |
2010198 | 2010198 | 2021-12-13 | Santa Fe | New Mexico | 35049 | 16000 | 188 |
2006947 | 2006947 | 2021-12-12 | Santa Fe | New Mexico | 35049 | 15874 | 187 |
2003696 | 2003696 | 2021-12-11 | Santa Fe | New Mexico | 35049 | 15874 | 187 |
2000446 | 2000446 | 2021-12-10 | Santa Fe | New Mexico | 35049 | 15874 | 187 |
1997195 | 1997195 | 2021-12-09 | Santa Fe | New Mexico | 35049 | 15794 | 185 |
1993944 | 1993944 | 2021-12-08 | Santa Fe | New Mexico | 35049 | 15698 | 185 |
1990693 | 1990693 | 2021-12-07 | Santa Fe | New Mexico | 35049 | 15624 | 185 |
1987443 | 1987443 | 2021-12-06 | Santa Fe | New Mexico | 35049 | 15593 | 185 |
1984193 | 1984193 | 2021-12-05 | Santa Fe | New Mexico | 35049 | 15417 | 185 |
1980943 | 1980943 | 2021-12-04 | Santa Fe | New Mexico | 35049 | 15417 | 185 |
1977693 | 1977693 | 2021-12-03 | Santa Fe | New Mexico | 35049 | 15417 | 185 |
1974443 | 1974443 | 2021-12-02 | Santa Fe | New Mexico | 35049 | 15310 | 184 |
1971194 | 1971194 | 2021-12-01 | Santa Fe | New Mexico | 35049 | 15215 | 184 |
1967944 | 1967944 | 2021-11-30 | Santa Fe | New Mexico | 35049 | 15161 | 184 |
1964692 | 1964692 | 2021-11-29 | Santa Fe | New Mexico | 35049 | 15116 | 183 |
1961441 | 1961441 | 2021-11-28 | Santa Fe | New Mexico | 35049 | 14858 | 181 |
1958190 | 1958190 | 2021-11-27 | Santa Fe | New Mexico | 35049 | 14858 | 181 |
1954939 | 1954939 | 2021-11-26 | Santa Fe | New Mexico | 35049 | 14858 | 181 |
1951688 | 1951688 | 2021-11-25 | Santa Fe | New Mexico | 35049 | 14858 | 181 |
1948437 | 1948437 | 2021-11-24 | Santa Fe | New Mexico | 35049 | 14858 | 181 |
1945186 | 1945186 | 2021-11-23 | Santa Fe | New Mexico | 35049 | 14799 | 181 |
1941935 | 1941935 | 2021-11-22 | Santa Fe | New Mexico | 35049 | 14762 | 180 |
1938685 | 1938685 | 2021-11-21 | Santa Fe | New Mexico | 35049 | 14521 | 180 |
1935435 | 1935435 | 2021-11-20 | Santa Fe | New Mexico | 35049 | 14521 | 180 |
1932185 | 1932185 | 2021-11-19 | Santa Fe | New Mexico | 35049 | 14521 | 180 |
1928934 | 1928934 | 2021-11-18 | Santa Fe | New Mexico | 35049 | 14418 | 177 |
1925684 | 1925684 | 2021-11-17 | Santa Fe | New Mexico | 35049 | 14352 | 175 |
1922435 | 1922435 | 2021-11-16 | Santa Fe | New Mexico | 35049 | 14324 | 175 |
1919185 | 1919185 | 2021-11-15 | Santa Fe | New Mexico | 35049 | 14292 | 175 |
1915935 | 1915935 | 2021-11-14 | Santa Fe | New Mexico | 35049 | 14148 | 175 |
1912685 | 1912685 | 2021-11-13 | Santa Fe | New Mexico | 35049 | 14148 | 175 |
1909435 | 1909435 | 2021-11-12 | Santa Fe | New Mexico | 35049 | 14148 | 175 |
1906186 | 1906186 | 2021-11-11 | Santa Fe | New Mexico | 35049 | 13986 | 175 |
1902937 | 1902937 | 2021-11-10 | Santa Fe | New Mexico | 35049 | 13986 | 175 |
1899687 | 1899687 | 2021-11-09 | Santa Fe | New Mexico | 35049 | 13954 | 175 |
1896437 | 1896437 | 2021-11-08 | Santa Fe | New Mexico | 35049 | 13912 | 174 |
1893187 | 1893187 | 2021-11-07 | Santa Fe | New Mexico | 35049 | 13750 | 173 |
1889937 | 1889937 | 2021-11-06 | Santa Fe | New Mexico | 35049 | 13750 | 173 |
1886687 | 1886687 | 2021-11-05 | Santa Fe | New Mexico | 35049 | 13750 | 173 |
1883438 | 1883438 | 2021-11-04 | Santa Fe | New Mexico | 35049 | 13691 | 172 |
1880189 | 1880189 | 2021-11-03 | Santa Fe | New Mexico | 35049 | 13632 | 172 |
1876940 | 1876940 | 2021-11-02 | Santa Fe | New Mexico | 35049 | 13585 | 171 |
1873691 | 1873691 | 2021-11-01 | Santa Fe | New Mexico | 35049 | 13558 | 171 |
1870442 | 1870442 | 2021-10-31 | Santa Fe | New Mexico | 35049 | 13456 | 171 |
1867193 | 1867193 | 2021-10-30 | Santa Fe | New Mexico | 35049 | 13456 | 171 |
1863944 | 1863944 | 2021-10-29 | Santa Fe | New Mexico | 35049 | 13456 | 171 |
1860695 | 1860695 | 2021-10-28 | Santa Fe | New Mexico | 35049 | 13422 | 170 |
1857446 | 1857446 | 2021-10-27 | Santa Fe | New Mexico | 35049 | 13381 | 170 |
1854197 | 1854197 | 2021-10-26 | Santa Fe | New Mexico | 35049 | 13342 | 169 |
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);