ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where deaths = 79 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 |
---|---|---|---|---|---|---|---|
2309350 | 2309350 | 2022-03-15 | Grant | New Mexico | 35017 | 6607 | 79 |
2195554 | 2195554 | 2022-02-08 | Socorro | New Mexico | 35053 | 3663 | 79 |
2192300 | 2192300 | 2022-02-07 | Socorro | New Mexico | 35053 | 3637 | 79 |
2189047 | 2189047 | 2022-02-06 | Socorro | New Mexico | 35053 | 3613 | 79 |
2185794 | 2185794 | 2022-02-05 | Socorro | New Mexico | 35053 | 3613 | 79 |
2182542 | 2182542 | 2022-02-04 | Socorro | New Mexico | 35053 | 3613 | 79 |
2179290 | 2179290 | 2022-02-03 | Socorro | New Mexico | 35053 | 3606 | 79 |
2176038 | 2176038 | 2022-02-02 | Socorro | New Mexico | 35053 | 3581 | 79 |
2172785 | 2172785 | 2022-02-01 | Socorro | New Mexico | 35053 | 3551 | 79 |
2169532 | 2169532 | 2022-01-31 | Socorro | New Mexico | 35053 | 3545 | 79 |
2039450 | 2039450 | 2021-12-22 | Roosevelt | New Mexico | 35041 | 3411 | 79 |
1470891 | 1470891 | 2021-06-30 | Rio Arriba | New Mexico | 35039 | 3794 | 79 |
1467646 | 1467646 | 2021-06-29 | Rio Arriba | New Mexico | 35039 | 3793 | 79 |
1464401 | 1464401 | 2021-06-28 | Rio Arriba | New Mexico | 35039 | 3787 | 79 |
1461156 | 1461156 | 2021-06-27 | Rio Arriba | New Mexico | 35039 | 3772 | 79 |
1457911 | 1457911 | 2021-06-26 | Rio Arriba | New Mexico | 35039 | 3772 | 79 |
1454666 | 1454666 | 2021-06-25 | Rio Arriba | New Mexico | 35039 | 3772 | 79 |
1451421 | 1451421 | 2021-06-24 | Rio Arriba | New Mexico | 35039 | 3769 | 79 |
1448175 | 1448175 | 2021-06-23 | Rio Arriba | New Mexico | 35039 | 3766 | 79 |
1444930 | 1444930 | 2021-06-22 | Rio Arriba | New Mexico | 35039 | 3754 | 79 |
1441683 | 1441683 | 2021-06-21 | Otero | New Mexico | 35035 | 5221 | 79 |
1441685 | 1441685 | 2021-06-21 | Rio Arriba | New Mexico | 35039 | 3752 | 79 |
1438437 | 1438437 | 2021-06-20 | Otero | New Mexico | 35035 | 5213 | 79 |
1435190 | 1435190 | 2021-06-19 | Otero | New Mexico | 35035 | 5213 | 79 |
1431943 | 1431943 | 2021-06-18 | Otero | New Mexico | 35035 | 5213 | 79 |
1347543 | 1347543 | 2021-05-23 | Curry | New Mexico | 35009 | 5244 | 79 |
1344295 | 1344295 | 2021-05-22 | Curry | New Mexico | 35009 | 5244 | 79 |
1341047 | 1341047 | 2021-05-21 | Curry | New Mexico | 35009 | 5244 | 79 |
1337799 | 1337799 | 2021-05-20 | Curry | New Mexico | 35009 | 5240 | 79 |
1334552 | 1334552 | 2021-05-19 | Curry | New Mexico | 35009 | 5231 | 79 |
1331305 | 1331305 | 2021-05-18 | Curry | New Mexico | 35009 | 5230 | 79 |
1328058 | 1328058 | 2021-05-17 | Curry | New Mexico | 35009 | 5226 | 79 |
1324812 | 1324812 | 2021-05-16 | Curry | New Mexico | 35009 | 5203 | 79 |
1321566 | 1321566 | 2021-05-15 | Curry | New Mexico | 35009 | 5203 | 79 |
1318320 | 1318320 | 2021-05-14 | Curry | New Mexico | 35009 | 5203 | 79 |
1315072 | 1315072 | 2021-05-13 | Curry | New Mexico | 35009 | 5195 | 79 |
1311826 | 1311826 | 2021-05-12 | Curry | New Mexico | 35009 | 5185 | 79 |
1308579 | 1308579 | 2021-05-11 | Curry | New Mexico | 35009 | 5183 | 79 |
1305333 | 1305333 | 2021-05-10 | Curry | New Mexico | 35009 | 5177 | 79 |
1087790 | 1087790 | 2021-03-04 | Luna | New Mexico | 35029 | 3111 | 79 |
1084545 | 1084545 | 2021-03-03 | Luna | New Mexico | 35029 | 3109 | 79 |
967716 | 967716 | 2021-01-26 | Valencia | New Mexico | 35061 | 5979 | 79 |
964472 | 964472 | 2021-01-25 | Valencia | New Mexico | 35061 | 5967 | 79 |
961227 | 961227 | 2021-01-24 | Valencia | New Mexico | 35061 | 5955 | 79 |
912518 | 912518 | 2021-01-09 | Cibola | New Mexico | 35006 | 2964 | 79 |
899542 | 899542 | 2021-01-05 | Eddy | New Mexico | 35015 | 4813 | 79 |
850857 | 850857 | 2020-12-21 | Chaves | New Mexico | 35005 | 6433 | 79 |
847612 | 847612 | 2020-12-20 | Chaves | New Mexico | 35005 | 6406 | 79 |
776235 | 776235 | 2020-11-28 | Sandoval | New Mexico | 35043 | 4988 | 79 |
158941 | 158941 | 2020-05-19 | McKinley | New Mexico | 35031 | 1987 | 79 |
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);