ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 97 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
state 1
- New Mexico · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501416 | 2501416 | 2022-05-13 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2498158 | 2498158 | 2022-05-12 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2494900 | 2494900 | 2022-05-11 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2491642 | 2491642 | 2022-05-10 | Roosevelt | New Mexico | 35041 | 5022 | 97 |
2488384 | 2488384 | 2022-05-09 | Roosevelt | New Mexico | 35041 | 5019 | 97 |
2485127 | 2485127 | 2022-05-08 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2481869 | 2481869 | 2022-05-07 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2478611 | 2478611 | 2022-05-06 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
1984183 | 1984183 | 2021-12-05 | Luna | New Mexico | 35029 | 4580 | 97 |
1980933 | 1980933 | 2021-12-04 | Luna | New Mexico | 35029 | 4580 | 97 |
1977683 | 1977683 | 2021-12-03 | Luna | New Mexico | 35029 | 4580 | 97 |
1974433 | 1974433 | 2021-12-02 | Luna | New Mexico | 35029 | 4567 | 97 |
1971184 | 1971184 | 2021-12-01 | Luna | New Mexico | 35029 | 4547 | 97 |
1967934 | 1967934 | 2021-11-30 | Luna | New Mexico | 35029 | 4535 | 97 |
1964682 | 1964682 | 2021-11-29 | Luna | New Mexico | 35029 | 4523 | 97 |
1961431 | 1961431 | 2021-11-28 | Luna | New Mexico | 35029 | 4464 | 97 |
1958180 | 1958180 | 2021-11-27 | Luna | New Mexico | 35029 | 4464 | 97 |
1954929 | 1954929 | 2021-11-26 | Luna | New Mexico | 35029 | 4464 | 97 |
1951678 | 1951678 | 2021-11-25 | Luna | New Mexico | 35029 | 4464 | 97 |
1948427 | 1948427 | 2021-11-24 | Luna | New Mexico | 35029 | 4464 | 97 |
1945176 | 1945176 | 2021-11-23 | Luna | New Mexico | 35029 | 4449 | 97 |
1831444 | 1831444 | 2021-10-19 | Otero | New Mexico | 35035 | 7895 | 97 |
1828195 | 1828195 | 2021-10-18 | Otero | New Mexico | 35035 | 7874 | 97 |
1824946 | 1824946 | 2021-10-17 | Otero | New Mexico | 35035 | 7742 | 97 |
1821697 | 1821697 | 2021-10-16 | Otero | New Mexico | 35035 | 7742 | 97 |
1818448 | 1818448 | 2021-10-15 | Otero | New Mexico | 35035 | 7742 | 97 |
1815199 | 1815199 | 2021-10-14 | Otero | New Mexico | 35035 | 7672 | 97 |
1811951 | 1811951 | 2021-10-13 | Otero | New Mexico | 35035 | 7635 | 97 |
1808702 | 1808702 | 2021-10-12 | Otero | New Mexico | 35035 | 7612 | 97 |
1805451 | 1805451 | 2021-10-11 | Otero | New Mexico | 35035 | 7401 | 97 |
1802202 | 1802202 | 2021-10-10 | Otero | New Mexico | 35035 | 7401 | 97 |
1798953 | 1798953 | 2021-10-09 | Otero | New Mexico | 35035 | 7401 | 97 |
1795704 | 1795704 | 2021-10-08 | Otero | New Mexico | 35035 | 7401 | 97 |
1792455 | 1792455 | 2021-10-07 | Otero | New Mexico | 35035 | 7343 | 97 |
1789206 | 1789206 | 2021-10-06 | Otero | New Mexico | 35035 | 7287 | 97 |
1084561 | 1084561 | 2021-03-03 | Valencia | New Mexico | 35061 | 6465 | 97 |
1081315 | 1081315 | 2021-03-02 | Valencia | New Mexico | 35061 | 6453 | 97 |
970937 | 970937 | 2021-01-27 | Eddy | New Mexico | 35015 | 5874 | 97 |
967692 | 967692 | 2021-01-26 | Eddy | New Mexico | 35015 | 5824 | 97 |
899536 | 899536 | 2021-01-05 | Chaves | New Mexico | 35005 | 7415 | 97 |
701587 | 701587 | 2020-11-05 | Doña Ana | New Mexico | 35013 | 7693 | 97 |
333220 | 333220 | 2020-07-14 | Bernalillo | New Mexico | 35001 | 3200 | 97 |
183248 | 183248 | 2020-05-27 | McKinley | New Mexico | 35031 | 2270 | 97 |
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);