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

33 rows where "date" is on date 2022-01-06 and state = "New Mexico" sorted by date descending

✎ View and edit SQL

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

state 1

  • New Mexico · 33 ✖
Link rowid date ▲ county state fips cases deaths
2088185 2088185 2022-01-06 Bernalillo New Mexico 35001 103687 1371
2088186 2088186 2022-01-06 Catron New Mexico 35003 301 11
2088187 2088187 2022-01-06 Chaves New Mexico 35005 16065 238
2088188 2088188 2022-01-06 Cibola New Mexico 35006 5271 159
2088189 2088189 2022-01-06 Colfax New Mexico 35007 2047 56
2088190 2088190 2022-01-06 Curry New Mexico 35009 9319 137
2088191 2088191 2022-01-06 De Baca New Mexico 35011 423 3
2088192 2088192 2022-01-06 Doña Ana New Mexico 35013 42566 613
2088193 2088193 2022-01-06 Eddy New Mexico 35015 12942 232
2088194 2088194 2022-01-06 Grant New Mexico 35017 4667 65
2088195 2088195 2022-01-06 Guadalupe New Mexico 35019 979 15
2088196 2088196 2022-01-06 Harding New Mexico 35021 59 4
2088197 2088197 2022-01-06 Hidalgo New Mexico 35023 756 12
2088198 2088198 2022-01-06 Lea New Mexico 35025 16234 291
2088199 2088199 2022-01-06 Lincoln New Mexico 35027 3850 49
2088200 2088200 2022-01-06 Los Alamos New Mexico 35028 1167 11
2088201 2088201 2022-01-06 Luna New Mexico 35029 5003 109
2088202 2088202 2022-01-06 McKinley New Mexico 35031 18136 536
2088203 2088203 2022-01-06 Mora New Mexico 35033 501 14
2088204 2088204 2022-01-06 Otero New Mexico 35035 11286 148
2088205 2088205 2022-01-06 Quay New Mexico 35037 1614 31
2088206 2088206 2022-01-06 Rio Arriba New Mexico 35039 6616 102
2088207 2088207 2022-01-06 Roosevelt New Mexico 35041 3648 83
2088208 2088208 2022-01-06 San Juan New Mexico 35045 29146 661
2088209 2088209 2022-01-06 San Miguel New Mexico 35047 3636 38
2088210 2088210 2022-01-06 Sandoval New Mexico 35043 22251 314
2088211 2088211 2022-01-06 Santa Fe New Mexico 35049 18341 209
2088212 2088212 2022-01-06 Sierra New Mexico 35051 1536 65
2088213 2088213 2022-01-06 Socorro New Mexico 35053 2655 70
2088214 2088214 2022-01-06 Taos New Mexico 35055 3431 74
2088215 2088215 2022-01-06 Torrance New Mexico 35057 2364 37
2088216 2088216 2022-01-06 Union New Mexico 35059 777 12
2088217 2088217 2022-01-06 Valencia New Mexico 35061 13587 201

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