ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

24 rows where deaths = 133 and state = "New Mexico" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date

fips 10

state 1

  • New Mexico · 24 ✖
Link rowid date ▲ county state fips cases deaths
2449304 2449304 2022-04-27 Rio Arriba New Mexico 35039 9836 133
2446047 2446047 2022-04-26 Rio Arriba New Mexico 35039 9836 133
2442792 2442792 2022-04-25 Rio Arriba New Mexico 35039 9836 133
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
2016679 2016679 2021-12-15 Curry New Mexico 35009 8418 133
1766445 1766445 2021-09-29 Cibola New Mexico 35006 3986 133
1763196 1763196 2021-09-28 Cibola New Mexico 35006 3970 133
1759947 1759947 2021-09-27 Cibola New Mexico 35006 3955 133
1756699 1756699 2021-09-26 Cibola New Mexico 35006 3929 133
1753451 1753451 2021-09-25 Cibola New Mexico 35006 3929 133
1750203 1750203 2021-09-24 Cibola New Mexico 35006 3929 133
1746953 1746953 2021-09-23 Cibola New Mexico 35006 3918 133
1743704 1743704 2021-09-22 Cibola New Mexico 35006 3904 133
1740455 1740455 2021-09-21 Cibola New Mexico 35006 3890 133
1740484 1740484 2021-09-21 Valencia New Mexico 35061 8563 133
1048851 1048851 2021-02-20 Santa Fe New Mexico 35049 9725 133
1022874 1022874 2021-02-12 Lea New Mexico 35025 8373 133
993653 993653 2021-02-03 Chaves New Mexico 35005 8507 133
990407 990407 2021-02-02 Chaves New Mexico 35005 8469 133
886575 886575 2021-01-01 Sandoval New Mexico 35043 8269 133
220151 220151 2020-06-08 McKinley New Mexico 35031 2746 133

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);