ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where "date" is on date 2020-06-01 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
198556 | 198556 | 2020-06-01 | Bernalillo | New Mexico | 35001 | 1486 | 71 |
198557 | 198557 | 2020-06-01 | Catron | New Mexico | 35003 | 2 | 1 |
198558 | 198558 | 2020-06-01 | Chaves | New Mexico | 35005 | 50 | 2 |
198559 | 198559 | 2020-06-01 | Cibola | New Mexico | 35006 | 145 | 5 |
198560 | 198560 | 2020-06-01 | Colfax | New Mexico | 35007 | 5 | 0 |
198561 | 198561 | 2020-06-01 | Curry | New Mexico | 35009 | 53 | 0 |
198562 | 198562 | 2020-06-01 | Doña Ana | New Mexico | 35013 | 487 | 3 |
198563 | 198563 | 2020-06-01 | Eddy | New Mexico | 35015 | 24 | 1 |
198564 | 198564 | 2020-06-01 | Grant | New Mexico | 35017 | 15 | 0 |
198565 | 198565 | 2020-06-01 | Guadalupe | New Mexico | 35019 | 20 | 0 |
198566 | 198566 | 2020-06-01 | Harding | New Mexico | 35021 | 1 | 0 |
198567 | 198567 | 2020-06-01 | Hidalgo | New Mexico | 35023 | 1 | 0 |
198568 | 198568 | 2020-06-01 | Lea | New Mexico | 35025 | 26 | 0 |
198569 | 198569 | 2020-06-01 | Lincoln | New Mexico | 35027 | 2 | 0 |
198570 | 198570 | 2020-06-01 | Los Alamos | New Mexico | 35028 | 6 | 0 |
198571 | 198571 | 2020-06-01 | Luna | New Mexico | 35029 | 8 | 1 |
198572 | 198572 | 2020-06-01 | McKinley | New Mexico | 35031 | 2451 | 112 |
198573 | 198573 | 2020-06-01 | Otero | New Mexico | 35035 | 215 | 3 |
198574 | 198574 | 2020-06-01 | Quay | New Mexico | 35037 | 5 | 1 |
198575 | 198575 | 2020-06-01 | Rio Arriba | New Mexico | 35039 | 48 | 1 |
198576 | 198576 | 2020-06-01 | Roosevelt | New Mexico | 35041 | 42 | 0 |
198577 | 198577 | 2020-06-01 | San Juan | New Mexico | 35045 | 1771 | 123 |
198578 | 198578 | 2020-06-01 | San Miguel | New Mexico | 35047 | 15 | 0 |
198579 | 198579 | 2020-06-01 | Sandoval | New Mexico | 35043 | 568 | 27 |
198580 | 198580 | 2020-06-01 | Santa Fe | New Mexico | 35049 | 144 | 3 |
198581 | 198581 | 2020-06-01 | Sierra | New Mexico | 35051 | 1 | 0 |
198582 | 198582 | 2020-06-01 | Socorro | New Mexico | 35053 | 51 | 5 |
198583 | 198583 | 2020-06-01 | Taos | New Mexico | 35055 | 29 | 0 |
198584 | 198584 | 2020-06-01 | Torrance | New Mexico | 35057 | 50 | 1 |
198585 | 198585 | 2020-06-01 | Union | New Mexico | 35059 | 4 | 0 |
198586 | 198586 | 2020-06-01 | Valencia | New Mexico | 35061 | 75 | 2 |
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);