ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 35025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176023 | 2176023 | 2022-02-02 | Lea | New Mexico | 35025 | 19488 | 305 |
2172770 | 2172770 | 2022-02-01 | Lea | New Mexico | 35025 | 19398 | 305 |
2169517 | 2169517 | 2022-01-31 | Lea | New Mexico | 35025 | 19333 | 305 |
2166262 | 2166262 | 2022-01-30 | Lea | New Mexico | 35025 | 19188 | 305 |
2163007 | 2163007 | 2022-01-29 | Lea | New Mexico | 35025 | 19188 | 305 |
2159752 | 2159752 | 2022-01-28 | Lea | New Mexico | 35025 | 19188 | 305 |
2156498 | 2156498 | 2022-01-27 | Lea | New Mexico | 35025 | 19101 | 305 |
2153245 | 2153245 | 2022-01-26 | Lea | New Mexico | 35025 | 19037 | 303 |
2149993 | 2149993 | 2022-01-25 | Lea | New Mexico | 35025 | 18894 | 302 |
2146741 | 2146741 | 2022-01-24 | Lea | New Mexico | 35025 | 18784 | 301 |
2143486 | 2143486 | 2022-01-23 | Lea | New Mexico | 35025 | 18546 | 299 |
2140231 | 2140231 | 2022-01-22 | Lea | New Mexico | 35025 | 18546 | 299 |
2136975 | 2136975 | 2022-01-21 | Lea | New Mexico | 35025 | 18546 | 299 |
2133723 | 2133723 | 2022-01-20 | Lea | New Mexico | 35025 | 18432 | 299 |
2130470 | 2130470 | 2022-01-19 | Lea | New Mexico | 35025 | 18260 | 299 |
2127216 | 2127216 | 2022-01-18 | Lea | New Mexico | 35025 | 18030 | 299 |
2123964 | 2123964 | 2022-01-17 | Lea | New Mexico | 35025 | 17525 | 299 |
2120712 | 2120712 | 2022-01-16 | Lea | New Mexico | 35025 | 17525 | 299 |
2117460 | 2117460 | 2022-01-15 | Lea | New Mexico | 35025 | 17525 | 299 |
2114209 | 2114209 | 2022-01-14 | Lea | New Mexico | 35025 | 17525 | 299 |
2110957 | 2110957 | 2022-01-13 | Lea | New Mexico | 35025 | 17331 | 294 |
2107706 | 2107706 | 2022-01-12 | Lea | New Mexico | 35025 | 17119 | 292 |
2104455 | 2104455 | 2022-01-11 | Lea | New Mexico | 35025 | 16854 | 292 |
2101204 | 2101204 | 2022-01-10 | Lea | New Mexico | 35025 | 16714 | 292 |
2097953 | 2097953 | 2022-01-09 | Lea | New Mexico | 35025 | 16391 | 291 |
2094701 | 2094701 | 2022-01-08 | Lea | New Mexico | 35025 | 16391 | 291 |
2091449 | 2091449 | 2022-01-07 | Lea | New Mexico | 35025 | 16391 | 291 |
2088198 | 2088198 | 2022-01-06 | Lea | New Mexico | 35025 | 16234 | 291 |
2084946 | 2084946 | 2022-01-05 | Lea | New Mexico | 35025 | 16089 | 289 |
2081694 | 2081694 | 2022-01-04 | Lea | New Mexico | 35025 | 15939 | 289 |
2078442 | 2078442 | 2022-01-03 | Lea | New Mexico | 35025 | 15841 | 289 |
2075191 | 2075191 | 2022-01-02 | Lea | New Mexico | 35025 | 15625 | 289 |
2071940 | 2071940 | 2022-01-01 | Lea | New Mexico | 35025 | 15625 | 289 |
2068689 | 2068689 | 2021-12-31 | Lea | New Mexico | 35025 | 15625 | 289 |
2065438 | 2065438 | 2021-12-30 | Lea | New Mexico | 35025 | 15625 | 289 |
2062188 | 2062188 | 2021-12-29 | Lea | New Mexico | 35025 | 15547 | 289 |
2058939 | 2058939 | 2021-12-28 | Lea | New Mexico | 35025 | 15467 | 288 |
2055690 | 2055690 | 2021-12-27 | Lea | New Mexico | 35025 | 15431 | 288 |
2052440 | 2052440 | 2021-12-26 | Lea | New Mexico | 35025 | 15373 | 288 |
2049190 | 2049190 | 2021-12-25 | Lea | New Mexico | 35025 | 15373 | 288 |
2045940 | 2045940 | 2021-12-24 | Lea | New Mexico | 35025 | 15373 | 288 |
2042690 | 2042690 | 2021-12-23 | Lea | New Mexico | 35025 | 15373 | 288 |
2039441 | 2039441 | 2021-12-22 | Lea | New Mexico | 35025 | 15340 | 287 |
2036191 | 2036191 | 2021-12-21 | Lea | New Mexico | 35025 | 15299 | 287 |
2032941 | 2032941 | 2021-12-20 | Lea | New Mexico | 35025 | 15268 | 287 |
2029690 | 2029690 | 2021-12-19 | Lea | New Mexico | 35025 | 15211 | 287 |
2026439 | 2026439 | 2021-12-18 | Lea | New Mexico | 35025 | 15211 | 287 |
2023188 | 2023188 | 2021-12-17 | Lea | New Mexico | 35025 | 15211 | 287 |
2019937 | 2019937 | 2021-12-16 | Lea | New Mexico | 35025 | 15185 | 287 |
2016687 | 2016687 | 2021-12-15 | Lea | New Mexico | 35025 | 15157 | 287 |
2013436 | 2013436 | 2021-12-14 | Lea | New Mexico | 35025 | 15129 | 287 |
2010185 | 2010185 | 2021-12-13 | Lea | New Mexico | 35025 | 15091 | 287 |
2006934 | 2006934 | 2021-12-12 | Lea | New Mexico | 35025 | 15035 | 287 |
2003683 | 2003683 | 2021-12-11 | Lea | New Mexico | 35025 | 15035 | 287 |
2000433 | 2000433 | 2021-12-10 | Lea | New Mexico | 35025 | 15035 | 287 |
1997182 | 1997182 | 2021-12-09 | Lea | New Mexico | 35025 | 15007 | 287 |
1993931 | 1993931 | 2021-12-08 | Lea | New Mexico | 35025 | 14962 | 287 |
1990680 | 1990680 | 2021-12-07 | Lea | New Mexico | 35025 | 14939 | 287 |
1987430 | 1987430 | 2021-12-06 | Lea | New Mexico | 35025 | 14922 | 282 |
1984180 | 1984180 | 2021-12-05 | Lea | New Mexico | 35025 | 14887 | 282 |
1980930 | 1980930 | 2021-12-04 | Lea | New Mexico | 35025 | 14887 | 282 |
1977680 | 1977680 | 2021-12-03 | Lea | New Mexico | 35025 | 14887 | 282 |
1974430 | 1974430 | 2021-12-02 | Lea | New Mexico | 35025 | 14866 | 281 |
1971181 | 1971181 | 2021-12-01 | Lea | New Mexico | 35025 | 14832 | 281 |
1967931 | 1967931 | 2021-11-30 | Lea | New Mexico | 35025 | 14809 | 281 |
1964679 | 1964679 | 2021-11-29 | Lea | New Mexico | 35025 | 14789 | 281 |
1961428 | 1961428 | 2021-11-28 | Lea | New Mexico | 35025 | 14729 | 280 |
1958177 | 1958177 | 2021-11-27 | Lea | New Mexico | 35025 | 14729 | 280 |
1954926 | 1954926 | 2021-11-26 | Lea | New Mexico | 35025 | 14729 | 280 |
1951675 | 1951675 | 2021-11-25 | Lea | New Mexico | 35025 | 14729 | 280 |
1948424 | 1948424 | 2021-11-24 | Lea | New Mexico | 35025 | 14729 | 280 |
1945173 | 1945173 | 2021-11-23 | Lea | New Mexico | 35025 | 14717 | 279 |
1941922 | 1941922 | 2021-11-22 | Lea | New Mexico | 35025 | 14703 | 278 |
1938672 | 1938672 | 2021-11-21 | Lea | New Mexico | 35025 | 14671 | 278 |
1935422 | 1935422 | 2021-11-20 | Lea | New Mexico | 35025 | 14671 | 278 |
1932172 | 1932172 | 2021-11-19 | Lea | New Mexico | 35025 | 14671 | 278 |
1928921 | 1928921 | 2021-11-18 | Lea | New Mexico | 35025 | 14652 | 278 |
1925671 | 1925671 | 2021-11-17 | Lea | New Mexico | 35025 | 14641 | 278 |
1922422 | 1922422 | 2021-11-16 | Lea | New Mexico | 35025 | 14631 | 278 |
1919172 | 1919172 | 2021-11-15 | Lea | New Mexico | 35025 | 14619 | 278 |
1915922 | 1915922 | 2021-11-14 | Lea | New Mexico | 35025 | 14596 | 278 |
1912672 | 1912672 | 2021-11-13 | Lea | New Mexico | 35025 | 14596 | 278 |
1909422 | 1909422 | 2021-11-12 | Lea | New Mexico | 35025 | 14596 | 278 |
1906173 | 1906173 | 2021-11-11 | Lea | New Mexico | 35025 | 14557 | 278 |
1902924 | 1902924 | 2021-11-10 | Lea | New Mexico | 35025 | 14557 | 278 |
1899674 | 1899674 | 2021-11-09 | Lea | New Mexico | 35025 | 14532 | 278 |
1896424 | 1896424 | 2021-11-08 | Lea | New Mexico | 35025 | 14512 | 278 |
1893174 | 1893174 | 2021-11-07 | Lea | New Mexico | 35025 | 14468 | 277 |
1889924 | 1889924 | 2021-11-06 | Lea | New Mexico | 35025 | 14468 | 277 |
1886674 | 1886674 | 2021-11-05 | Lea | New Mexico | 35025 | 14468 | 277 |
1883425 | 1883425 | 2021-11-04 | Lea | New Mexico | 35025 | 14454 | 275 |
1880176 | 1880176 | 2021-11-03 | Lea | New Mexico | 35025 | 14432 | 274 |
1876927 | 1876927 | 2021-11-02 | Lea | New Mexico | 35025 | 14412 | 271 |
1873678 | 1873678 | 2021-11-01 | Lea | New Mexico | 35025 | 14399 | 271 |
1870429 | 1870429 | 2021-10-31 | Lea | New Mexico | 35025 | 14369 | 271 |
1867180 | 1867180 | 2021-10-30 | Lea | New Mexico | 35025 | 14369 | 271 |
1863931 | 1863931 | 2021-10-29 | Lea | New Mexico | 35025 | 14369 | 271 |
1860682 | 1860682 | 2021-10-28 | Lea | New Mexico | 35025 | 14353 | 270 |
1857433 | 1857433 | 2021-10-27 | Lea | New Mexico | 35025 | 14330 | 270 |
1854184 | 1854184 | 2021-10-26 | Lea | New Mexico | 35025 | 14300 | 270 |
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);