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-05-30 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
192413 | 192413 | 2020-05-30 | Bernalillo | New Mexico | 35001 | 1464 | 71 |
192414 | 192414 | 2020-05-30 | Catron | New Mexico | 35003 | 2 | 1 |
192415 | 192415 | 2020-05-30 | Chaves | New Mexico | 35005 | 45 | 2 |
192416 | 192416 | 2020-05-30 | Cibola | New Mexico | 35006 | 143 | 5 |
192417 | 192417 | 2020-05-30 | Colfax | New Mexico | 35007 | 5 | 0 |
192418 | 192418 | 2020-05-30 | Curry | New Mexico | 35009 | 51 | 0 |
192419 | 192419 | 2020-05-30 | Doña Ana | New Mexico | 35013 | 471 | 3 |
192420 | 192420 | 2020-05-30 | Eddy | New Mexico | 35015 | 20 | 1 |
192421 | 192421 | 2020-05-30 | Grant | New Mexico | 35017 | 15 | 0 |
192422 | 192422 | 2020-05-30 | Guadalupe | New Mexico | 35019 | 20 | 0 |
192423 | 192423 | 2020-05-30 | Harding | New Mexico | 35021 | 1 | 0 |
192424 | 192424 | 2020-05-30 | Hidalgo | New Mexico | 35023 | 1 | 0 |
192425 | 192425 | 2020-05-30 | Lea | New Mexico | 35025 | 26 | 0 |
192426 | 192426 | 2020-05-30 | Lincoln | New Mexico | 35027 | 2 | 0 |
192427 | 192427 | 2020-05-30 | Los Alamos | New Mexico | 35028 | 6 | 0 |
192428 | 192428 | 2020-05-30 | Luna | New Mexico | 35029 | 8 | 1 |
192429 | 192429 | 2020-05-30 | McKinley | New Mexico | 35031 | 2406 | 109 |
192430 | 192430 | 2020-05-30 | Otero | New Mexico | 35035 | 211 | 2 |
192431 | 192431 | 2020-05-30 | Quay | New Mexico | 35037 | 5 | 1 |
192432 | 192432 | 2020-05-30 | Rio Arriba | New Mexico | 35039 | 44 | 1 |
192433 | 192433 | 2020-05-30 | Roosevelt | New Mexico | 35041 | 38 | 0 |
192434 | 192434 | 2020-05-30 | San Juan | New Mexico | 35045 | 1715 | 117 |
192435 | 192435 | 2020-05-30 | San Miguel | New Mexico | 35047 | 15 | 0 |
192436 | 192436 | 2020-05-30 | Sandoval | New Mexico | 35043 | 566 | 27 |
192437 | 192437 | 2020-05-30 | Santa Fe | New Mexico | 35049 | 140 | 3 |
192438 | 192438 | 2020-05-30 | Sierra | New Mexico | 35051 | 1 | 0 |
192439 | 192439 | 2020-05-30 | Socorro | New Mexico | 35053 | 50 | 4 |
192440 | 192440 | 2020-05-30 | Taos | New Mexico | 35055 | 25 | 0 |
192441 | 192441 | 2020-05-30 | Torrance | New Mexico | 35057 | 50 | 1 |
192442 | 192442 | 2020-05-30 | Union | New Mexico | 35059 | 4 | 0 |
192443 | 192443 | 2020-05-30 | Valencia | New Mexico | 35061 | 74 | 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);