ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where deaths = 40 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2127227 | 2127227 | 2022-01-18 | San Miguel | New Mexico | 35047 | 4411 | 40 |
2123975 | 2123975 | 2022-01-17 | San Miguel | New Mexico | 35047 | 4089 | 40 |
2120723 | 2120723 | 2022-01-16 | San Miguel | New Mexico | 35047 | 4089 | 40 |
2117471 | 2117471 | 2022-01-15 | San Miguel | New Mexico | 35047 | 4089 | 40 |
2114220 | 2114220 | 2022-01-14 | San Miguel | New Mexico | 35047 | 4089 | 40 |
2110968 | 2110968 | 2022-01-13 | San Miguel | New Mexico | 35047 | 4036 | 40 |
2107723 | 2107723 | 2022-01-12 | Torrance | New Mexico | 35057 | 2473 | 40 |
2104472 | 2104472 | 2022-01-11 | Torrance | New Mexico | 35057 | 2427 | 40 |
1974431 | 1974431 | 2021-12-02 | Lincoln | New Mexico | 35027 | 3473 | 40 |
1971182 | 1971182 | 2021-12-01 | Lincoln | New Mexico | 35027 | 3456 | 40 |
1967932 | 1967932 | 2021-11-30 | Lincoln | New Mexico | 35027 | 3420 | 40 |
1964680 | 1964680 | 2021-11-29 | Lincoln | New Mexico | 35027 | 3410 | 40 |
1961429 | 1961429 | 2021-11-28 | Lincoln | New Mexico | 35027 | 3377 | 40 |
1958178 | 1958178 | 2021-11-27 | Lincoln | New Mexico | 35027 | 3377 | 40 |
1954927 | 1954927 | 2021-11-26 | Lincoln | New Mexico | 35027 | 3377 | 40 |
1951676 | 1951676 | 2021-11-25 | Lincoln | New Mexico | 35027 | 3377 | 40 |
1948425 | 1948425 | 2021-11-24 | Lincoln | New Mexico | 35027 | 3377 | 40 |
1945174 | 1945174 | 2021-11-23 | Lincoln | New Mexico | 35027 | 3358 | 40 |
1941923 | 1941923 | 2021-11-22 | Lincoln | New Mexico | 35027 | 3358 | 40 |
1938673 | 1938673 | 2021-11-21 | Lincoln | New Mexico | 35027 | 3329 | 40 |
1935423 | 1935423 | 2021-11-20 | Lincoln | New Mexico | 35027 | 3329 | 40 |
1932173 | 1932173 | 2021-11-19 | Lincoln | New Mexico | 35027 | 3329 | 40 |
1928922 | 1928922 | 2021-11-18 | Lincoln | New Mexico | 35027 | 3313 | 40 |
1360531 | 1360531 | 2021-05-27 | Grant | New Mexico | 35017 | 1720 | 40 |
1357285 | 1357285 | 2021-05-26 | Grant | New Mexico | 35017 | 1718 | 40 |
1354039 | 1354039 | 2021-05-25 | Grant | New Mexico | 35017 | 1718 | 40 |
1350793 | 1350793 | 2021-05-24 | Grant | New Mexico | 35017 | 1717 | 40 |
990409 | 990409 | 2021-02-02 | Colfax | New Mexico | 35007 | 815 | 40 |
987162 | 987162 | 2021-02-01 | Colfax | New Mexico | 35007 | 815 | 40 |
938498 | 938498 | 2021-01-17 | Roosevelt | New Mexico | 35041 | 1695 | 40 |
938503 | 938503 | 2021-01-17 | Sierra | New Mexico | 35051 | 647 | 40 |
935253 | 935253 | 2021-01-16 | Roosevelt | New Mexico | 35041 | 1682 | 40 |
935258 | 935258 | 2021-01-16 | Sierra | New Mexico | 35051 | 647 | 40 |
932008 | 932008 | 2021-01-15 | Roosevelt | New Mexico | 35041 | 1678 | 40 |
932013 | 932013 | 2021-01-15 | Sierra | New Mexico | 35051 | 645 | 40 |
893061 | 893061 | 2021-01-03 | Otero | New Mexico | 35035 | 3273 | 40 |
889815 | 889815 | 2021-01-02 | Otero | New Mexico | 35035 | 3263 | 40 |
880081 | 880081 | 2020-12-30 | Rio Arriba | New Mexico | 35039 | 2232 | 40 |
860618 | 860618 | 2020-12-24 | Socorro | New Mexico | 35053 | 907 | 40 |
857373 | 857373 | 2020-12-23 | Socorro | New Mexico | 35053 | 889 | 40 |
854105 | 854105 | 2020-12-22 | Curry | New Mexico | 35009 | 3804 | 40 |
854128 | 854128 | 2020-12-22 | Socorro | New Mexico | 35053 | 877 | 40 |
850883 | 850883 | 2020-12-21 | Socorro | New Mexico | 35053 | 872 | 40 |
847638 | 847638 | 2020-12-20 | Socorro | New Mexico | 35053 | 870 | 40 |
795706 | 795706 | 2020-12-04 | Santa Fe | New Mexico | 35049 | 5713 | 40 |
769723 | 769723 | 2020-11-26 | Cibola | New Mexico | 35006 | 1985 | 40 |
769733 | 769733 | 2020-11-26 | Lea | New Mexico | 35025 | 4127 | 40 |
766477 | 766477 | 2020-11-25 | Cibola | New Mexico | 35006 | 1972 | 40 |
766487 | 766487 | 2020-11-25 | Lea | New Mexico | 35025 | 4073 | 40 |
763237 | 763237 | 2020-11-24 | Eddy | New Mexico | 35015 | 2721 | 40 |
763242 | 763242 | 2020-11-24 | Lea | New Mexico | 35025 | 3975 | 40 |
759997 | 759997 | 2020-11-23 | Lea | New Mexico | 35025 | 3857 | 40 |
552440 | 552440 | 2020-09-20 | Sandoval | New Mexico | 35043 | 1313 | 40 |
549201 | 549201 | 2020-09-19 | Sandoval | New Mexico | 35043 | 1313 | 40 |
545963 | 545963 | 2020-09-18 | Sandoval | New Mexico | 35043 | 1311 | 40 |
542726 | 542726 | 2020-09-17 | Sandoval | New Mexico | 35043 | 1309 | 40 |
471550 | 471550 | 2020-08-26 | Doña Ana | New Mexico | 35013 | 2763 | 40 |
468318 | 468318 | 2020-08-25 | Doña Ana | New Mexico | 35013 | 2744 | 40 |
128927 | 128927 | 2020-05-09 | McKinley | New Mexico | 35031 | 1508 | 40 |
114123 | 114123 | 2020-05-04 | Bernalillo | New Mexico | 35001 | 944 | 40 |
111242 | 111242 | 2020-05-03 | Bernalillo | New Mexico | 35001 | 920 | 40 |
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);