ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Otero" and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176029 | 2176029 | 2022-02-02 | Otero | New Mexico | 35035 | 14380 | 159 |
2172776 | 2172776 | 2022-02-01 | Otero | New Mexico | 35035 | 14331 | 158 |
2169523 | 2169523 | 2022-01-31 | Otero | New Mexico | 35035 | 14243 | 158 |
2166268 | 2166268 | 2022-01-30 | Otero | New Mexico | 35035 | 13940 | 158 |
2163013 | 2163013 | 2022-01-29 | Otero | New Mexico | 35035 | 13940 | 158 |
2159758 | 2159758 | 2022-01-28 | Otero | New Mexico | 35035 | 13940 | 158 |
2156504 | 2156504 | 2022-01-27 | Otero | New Mexico | 35035 | 13757 | 158 |
2153251 | 2153251 | 2022-01-26 | Otero | New Mexico | 35035 | 13656 | 157 |
2149999 | 2149999 | 2022-01-25 | Otero | New Mexico | 35035 | 13575 | 157 |
2146747 | 2146747 | 2022-01-24 | Otero | New Mexico | 35035 | 13482 | 157 |
2143492 | 2143492 | 2022-01-23 | Otero | New Mexico | 35035 | 13002 | 156 |
2140237 | 2140237 | 2022-01-22 | Otero | New Mexico | 35035 | 13002 | 156 |
2136981 | 2136981 | 2022-01-21 | Otero | New Mexico | 35035 | 13002 | 156 |
2133729 | 2133729 | 2022-01-20 | Otero | New Mexico | 35035 | 12852 | 156 |
2130476 | 2130476 | 2022-01-19 | Otero | New Mexico | 35035 | 12719 | 154 |
2127222 | 2127222 | 2022-01-18 | Otero | New Mexico | 35035 | 12481 | 152 |
2123970 | 2123970 | 2022-01-17 | Otero | New Mexico | 35035 | 11957 | 152 |
2120718 | 2120718 | 2022-01-16 | Otero | New Mexico | 35035 | 11957 | 152 |
2117466 | 2117466 | 2022-01-15 | Otero | New Mexico | 35035 | 11957 | 152 |
2114215 | 2114215 | 2022-01-14 | Otero | New Mexico | 35035 | 11957 | 152 |
2110963 | 2110963 | 2022-01-13 | Otero | New Mexico | 35035 | 11879 | 152 |
2107712 | 2107712 | 2022-01-12 | Otero | New Mexico | 35035 | 11757 | 151 |
2104461 | 2104461 | 2022-01-11 | Otero | New Mexico | 35035 | 11656 | 150 |
2101210 | 2101210 | 2022-01-10 | Otero | New Mexico | 35035 | 11547 | 149 |
2097959 | 2097959 | 2022-01-09 | Otero | New Mexico | 35035 | 11355 | 148 |
2094707 | 2094707 | 2022-01-08 | Otero | New Mexico | 35035 | 11355 | 148 |
2091455 | 2091455 | 2022-01-07 | Otero | New Mexico | 35035 | 11355 | 148 |
2088204 | 2088204 | 2022-01-06 | Otero | New Mexico | 35035 | 11286 | 148 |
2084952 | 2084952 | 2022-01-05 | Otero | New Mexico | 35035 | 11199 | 147 |
2081700 | 2081700 | 2022-01-04 | Otero | New Mexico | 35035 | 11151 | 146 |
2078448 | 2078448 | 2022-01-03 | Otero | New Mexico | 35035 | 11103 | 145 |
2075197 | 2075197 | 2022-01-02 | Otero | New Mexico | 35035 | 10918 | 145 |
2071946 | 2071946 | 2022-01-01 | Otero | New Mexico | 35035 | 10918 | 145 |
2068695 | 2068695 | 2021-12-31 | Otero | New Mexico | 35035 | 10918 | 145 |
2065444 | 2065444 | 2021-12-30 | Otero | New Mexico | 35035 | 10918 | 145 |
2062194 | 2062194 | 2021-12-29 | Otero | New Mexico | 35035 | 10895 | 145 |
2058945 | 2058945 | 2021-12-28 | Otero | New Mexico | 35035 | 10867 | 143 |
2055696 | 2055696 | 2021-12-27 | Otero | New Mexico | 35035 | 10847 | 143 |
2052446 | 2052446 | 2021-12-26 | Otero | New Mexico | 35035 | 10723 | 140 |
2049196 | 2049196 | 2021-12-25 | Otero | New Mexico | 35035 | 10723 | 140 |
2045946 | 2045946 | 2021-12-24 | Otero | New Mexico | 35035 | 10723 | 140 |
2042696 | 2042696 | 2021-12-23 | Otero | New Mexico | 35035 | 10723 | 140 |
2039447 | 2039447 | 2021-12-22 | Otero | New Mexico | 35035 | 10707 | 139 |
2036197 | 2036197 | 2021-12-21 | Otero | New Mexico | 35035 | 10690 | 139 |
2032947 | 2032947 | 2021-12-20 | Otero | New Mexico | 35035 | 10678 | 136 |
2029696 | 2029696 | 2021-12-19 | Otero | New Mexico | 35035 | 10621 | 133 |
2026445 | 2026445 | 2021-12-18 | Otero | New Mexico | 35035 | 10621 | 133 |
2023194 | 2023194 | 2021-12-17 | Otero | New Mexico | 35035 | 10621 | 133 |
2019943 | 2019943 | 2021-12-16 | Otero | New Mexico | 35035 | 10587 | 133 |
2016693 | 2016693 | 2021-12-15 | Otero | New Mexico | 35035 | 10567 | 132 |
2013442 | 2013442 | 2021-12-14 | Otero | New Mexico | 35035 | 10529 | 132 |
2010191 | 2010191 | 2021-12-13 | Otero | New Mexico | 35035 | 10503 | 131 |
2006940 | 2006940 | 2021-12-12 | Otero | New Mexico | 35035 | 10462 | 131 |
2003689 | 2003689 | 2021-12-11 | Otero | New Mexico | 35035 | 10462 | 131 |
2000439 | 2000439 | 2021-12-10 | Otero | New Mexico | 35035 | 10462 | 131 |
1997188 | 1997188 | 2021-12-09 | Otero | New Mexico | 35035 | 10379 | 130 |
1993937 | 1993937 | 2021-12-08 | Otero | New Mexico | 35035 | 10339 | 128 |
1990686 | 1990686 | 2021-12-07 | Otero | New Mexico | 35035 | 10305 | 128 |
1987436 | 1987436 | 2021-12-06 | Otero | New Mexico | 35035 | 10269 | 128 |
1984186 | 1984186 | 2021-12-05 | Otero | New Mexico | 35035 | 10134 | 128 |
1980936 | 1980936 | 2021-12-04 | Otero | New Mexico | 35035 | 10134 | 128 |
1977686 | 1977686 | 2021-12-03 | Otero | New Mexico | 35035 | 10134 | 128 |
1974436 | 1974436 | 2021-12-02 | Otero | New Mexico | 35035 | 10035 | 126 |
1971187 | 1971187 | 2021-12-01 | Otero | New Mexico | 35035 | 9958 | 125 |
1967937 | 1967937 | 2021-11-30 | Otero | New Mexico | 35035 | 9934 | 125 |
1964685 | 1964685 | 2021-11-29 | Otero | New Mexico | 35035 | 9868 | 125 |
1961434 | 1961434 | 2021-11-28 | Otero | New Mexico | 35035 | 9738 | 122 |
1958183 | 1958183 | 2021-11-27 | Otero | New Mexico | 35035 | 9738 | 122 |
1954932 | 1954932 | 2021-11-26 | Otero | New Mexico | 35035 | 9738 | 122 |
1951681 | 1951681 | 2021-11-25 | Otero | New Mexico | 35035 | 9738 | 122 |
1948430 | 1948430 | 2021-11-24 | Otero | New Mexico | 35035 | 9738 | 122 |
1945179 | 1945179 | 2021-11-23 | Otero | New Mexico | 35035 | 9692 | 122 |
1941928 | 1941928 | 2021-11-22 | Otero | New Mexico | 35035 | 9670 | 122 |
1938678 | 1938678 | 2021-11-21 | Otero | New Mexico | 35035 | 9552 | 122 |
1935428 | 1935428 | 2021-11-20 | Otero | New Mexico | 35035 | 9552 | 122 |
1932178 | 1932178 | 2021-11-19 | Otero | New Mexico | 35035 | 9552 | 122 |
1928927 | 1928927 | 2021-11-18 | Otero | New Mexico | 35035 | 9490 | 120 |
1925677 | 1925677 | 2021-11-17 | Otero | New Mexico | 35035 | 9441 | 118 |
1922428 | 1922428 | 2021-11-16 | Otero | New Mexico | 35035 | 9404 | 114 |
1919178 | 1919178 | 2021-11-15 | Otero | New Mexico | 35035 | 9363 | 113 |
1915928 | 1915928 | 2021-11-14 | Otero | New Mexico | 35035 | 9117 | 111 |
1912678 | 1912678 | 2021-11-13 | Otero | New Mexico | 35035 | 9117 | 111 |
1909428 | 1909428 | 2021-11-12 | Otero | New Mexico | 35035 | 9117 | 111 |
1906179 | 1906179 | 2021-11-11 | Otero | New Mexico | 35035 | 8996 | 110 |
1902930 | 1902930 | 2021-11-10 | Otero | New Mexico | 35035 | 8996 | 110 |
1899680 | 1899680 | 2021-11-09 | Otero | New Mexico | 35035 | 8970 | 106 |
1896430 | 1896430 | 2021-11-08 | Otero | New Mexico | 35035 | 8935 | 105 |
1893180 | 1893180 | 2021-11-07 | Otero | New Mexico | 35035 | 8803 | 104 |
1889930 | 1889930 | 2021-11-06 | Otero | New Mexico | 35035 | 8803 | 104 |
1886680 | 1886680 | 2021-11-05 | Otero | New Mexico | 35035 | 8803 | 104 |
1883431 | 1883431 | 2021-11-04 | Otero | New Mexico | 35035 | 8713 | 104 |
1880182 | 1880182 | 2021-11-03 | Otero | New Mexico | 35035 | 8663 | 103 |
1876933 | 1876933 | 2021-11-02 | Otero | New Mexico | 35035 | 8607 | 103 |
1873684 | 1873684 | 2021-11-01 | Otero | New Mexico | 35035 | 8569 | 103 |
1870435 | 1870435 | 2021-10-31 | Otero | New Mexico | 35035 | 8408 | 102 |
1867186 | 1867186 | 2021-10-30 | Otero | New Mexico | 35035 | 8408 | 102 |
1863937 | 1863937 | 2021-10-29 | Otero | New Mexico | 35035 | 8408 | 102 |
1860688 | 1860688 | 2021-10-28 | Otero | New Mexico | 35035 | 8316 | 102 |
1857439 | 1857439 | 2021-10-27 | Otero | New Mexico | 35035 | 8280 | 102 |
1854190 | 1854190 | 2021-10-26 | Otero | New Mexico | 35035 | 8256 | 100 |
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);