ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 24 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426523 | 2426523 | 2022-04-20 | Unknown | New Mexico | 24 | 0 | |
737267 | 737267 | 2020-11-16 | De Baca | New Mexico | 35011 | 24 | 0 |
532996 | 532996 | 2020-09-14 | Colfax | New Mexico | 35007 | 24 | 1 |
510349 | 510349 | 2020-09-07 | Colfax | New Mexico | 35007 | 24 | 1 |
507116 | 507116 | 2020-09-06 | Colfax | New Mexico | 35007 | 24 | 1 |
503884 | 503884 | 2020-09-05 | Colfax | New Mexico | 35007 | 24 | 1 |
471558 | 471558 | 2020-08-26 | Los Alamos | New Mexico | 35028 | 24 | 0 |
468326 | 468326 | 2020-08-25 | Los Alamos | New Mexico | 35028 | 24 | 0 |
465098 | 465098 | 2020-08-24 | Los Alamos | New Mexico | 35028 | 24 | 0 |
461868 | 461868 | 2020-08-23 | Los Alamos | New Mexico | 35028 | 24 | 0 |
458640 | 458640 | 2020-08-22 | Los Alamos | New Mexico | 35028 | 24 | 0 |
455413 | 455413 | 2020-08-21 | Los Alamos | New Mexico | 35028 | 24 | 0 |
452185 | 452185 | 2020-08-20 | Los Alamos | New Mexico | 35028 | 24 | 0 |
448956 | 448956 | 2020-08-19 | Los Alamos | New Mexico | 35028 | 24 | 0 |
442503 | 442503 | 2020-08-17 | Los Alamos | New Mexico | 35028 | 24 | 0 |
439276 | 439276 | 2020-08-16 | Los Alamos | New Mexico | 35028 | 24 | 0 |
436051 | 436051 | 2020-08-15 | Los Alamos | New Mexico | 35028 | 24 | 0 |
432825 | 432825 | 2020-08-14 | Los Alamos | New Mexico | 35028 | 24 | 0 |
429598 | 429598 | 2020-08-13 | Los Alamos | New Mexico | 35028 | 24 | 0 |
426374 | 426374 | 2020-08-12 | Los Alamos | New Mexico | 35028 | 24 | 0 |
374893 | 374893 | 2020-07-27 | Union | New Mexico | 35059 | 24 | 0 |
371681 | 371681 | 2020-07-26 | Union | New Mexico | 35059 | 24 | 0 |
352420 | 352420 | 2020-07-20 | Guadalupe | New Mexico | 35019 | 24 | 0 |
352430 | 352430 | 2020-07-20 | Quay | New Mexico | 35037 | 24 | 1 |
349217 | 349217 | 2020-07-19 | Guadalupe | New Mexico | 35019 | 24 | 0 |
346016 | 346016 | 2020-07-18 | Guadalupe | New Mexico | 35019 | 24 | 0 |
342817 | 342817 | 2020-07-17 | Guadalupe | New Mexico | 35019 | 24 | 0 |
339619 | 339619 | 2020-07-16 | Guadalupe | New Mexico | 35019 | 24 | 0 |
330043 | 330043 | 2020-07-13 | Lincoln | New Mexico | 35027 | 24 | 0 |
326856 | 326856 | 2020-07-12 | Lincoln | New Mexico | 35027 | 24 | 0 |
310966 | 310966 | 2020-07-07 | Grant | New Mexico | 35017 | 24 | 0 |
307798 | 307798 | 2020-07-06 | Grant | New Mexico | 35017 | 24 | 0 |
304631 | 304631 | 2020-07-05 | Grant | New Mexico | 35017 | 24 | 0 |
198563 | 198563 | 2020-06-01 | Eddy | New Mexico | 35015 | 24 | 1 |
195510 | 195510 | 2020-05-31 | Taos | New Mexico | 35055 | 24 | 0 |
186301 | 186301 | 2020-05-28 | Lea | New Mexico | 35025 | 24 | 0 |
186316 | 186316 | 2020-05-28 | Taos | New Mexico | 35055 | 24 | 0 |
183244 | 183244 | 2020-05-27 | Lea | New Mexico | 35025 | 24 | 0 |
183259 | 183259 | 2020-05-27 | Taos | New Mexico | 35055 | 24 | 0 |
180196 | 180196 | 2020-05-26 | Lea | New Mexico | 35025 | 24 | 0 |
180211 | 180211 | 2020-05-26 | Taos | New Mexico | 35055 | 24 | 0 |
177152 | 177152 | 2020-05-25 | Lea | New Mexico | 35025 | 24 | 0 |
177167 | 177167 | 2020-05-25 | Taos | New Mexico | 35055 | 24 | 0 |
174124 | 174124 | 2020-05-24 | Taos | New Mexico | 35055 | 24 | 0 |
165010 | 165010 | 2020-05-21 | Unknown | New Mexico | 24 | 0 | |
119983 | 119983 | 2020-05-06 | Rio Arriba | New Mexico | 35039 | 24 | 0 |
117022 | 117022 | 2020-05-05 | Rio Arriba | New Mexico | 35039 | 24 | 0 |
114125 | 114125 | 2020-05-04 | Chaves | New Mexico | 35005 | 24 | 1 |
114141 | 114141 | 2020-05-04 | Rio Arriba | New Mexico | 35039 | 24 | 0 |
111260 | 111260 | 2020-05-03 | Rio Arriba | New Mexico | 35039 | 24 | 0 |
63468 | 63468 | 2020-04-16 | Valencia | New Mexico | 35061 | 24 | 0 |
47296 | 47296 | 2020-04-10 | Cibola | New Mexico | 35006 | 24 | 0 |
27427 | 27427 | 2020-04-02 | McKinley | New Mexico | 35031 | 24 | 0 |
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);