ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where "date" is on date 2021-11-12 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 |
---|---|---|---|---|---|---|---|
1909409 | 1909409 | 2021-11-12 | Bernalillo | New Mexico | 35001 | 80823 | 1140 |
1909410 | 1909410 | 2021-11-12 | Catron | New Mexico | 35003 | 248 | 7 |
1909411 | 1909411 | 2021-11-12 | Chaves | New Mexico | 35005 | 13451 | 210 |
1909412 | 1909412 | 2021-11-12 | Cibola | New Mexico | 35006 | 4581 | 145 |
1909413 | 1909413 | 2021-11-12 | Colfax | New Mexico | 35007 | 1652 | 50 |
1909414 | 1909414 | 2021-11-12 | Curry | New Mexico | 35009 | 7588 | 125 |
1909415 | 1909415 | 2021-11-12 | De Baca | New Mexico | 35011 | 289 | 3 |
1909416 | 1909416 | 2021-11-12 | Doña Ana | New Mexico | 35013 | 32966 | 542 |
1909417 | 1909417 | 2021-11-12 | Eddy | New Mexico | 35015 | 11266 | 211 |
1909418 | 1909418 | 2021-11-12 | Grant | New Mexico | 35017 | 3288 | 54 |
1909419 | 1909419 | 2021-11-12 | Guadalupe | New Mexico | 35019 | 887 | 15 |
1909420 | 1909420 | 2021-11-12 | Harding | New Mexico | 35021 | 47 | 3 |
1909421 | 1909421 | 2021-11-12 | Hidalgo | New Mexico | 35023 | 616 | 11 |
1909422 | 1909422 | 2021-11-12 | Lea | New Mexico | 35025 | 14596 | 278 |
1909423 | 1909423 | 2021-11-12 | Lincoln | New Mexico | 35027 | 3230 | 37 |
1909424 | 1909424 | 2021-11-12 | Los Alamos | New Mexico | 35028 | 845 | 9 |
1909425 | 1909425 | 2021-11-12 | Luna | New Mexico | 35029 | 4258 | 96 |
1909426 | 1909426 | 2021-11-12 | McKinley | New Mexico | 35031 | 15895 | 516 |
1909427 | 1909427 | 2021-11-12 | Mora | New Mexico | 35033 | 384 | 11 |
1909428 | 1909428 | 2021-11-12 | Otero | New Mexico | 35035 | 9117 | 111 |
1909429 | 1909429 | 2021-11-12 | Quay | New Mexico | 35037 | 1116 | 23 |
1909430 | 1909430 | 2021-11-12 | Rio Arriba | New Mexico | 35039 | 5342 | 86 |
1909431 | 1909431 | 2021-11-12 | Roosevelt | New Mexico | 35041 | 2852 | 70 |
1909432 | 1909432 | 2021-11-12 | San Juan | New Mexico | 35045 | 24357 | 570 |
1909433 | 1909433 | 2021-11-12 | San Miguel | New Mexico | 35047 | 2789 | 28 |
1909434 | 1909434 | 2021-11-12 | Sandoval | New Mexico | 35043 | 17073 | 280 |
1909435 | 1909435 | 2021-11-12 | Santa Fe | New Mexico | 35049 | 14148 | 175 |
1909436 | 1909436 | 2021-11-12 | Sierra | New Mexico | 35051 | 1161 | 57 |
1909437 | 1909437 | 2021-11-12 | Socorro | New Mexico | 35053 | 1861 | 64 |
1909438 | 1909438 | 2021-11-12 | Taos | New Mexico | 35055 | 2674 | 66 |
1909439 | 1909439 | 2021-11-12 | Torrance | New Mexico | 35057 | 1875 | 20 |
1909440 | 1909440 | 2021-11-12 | Union | New Mexico | 35059 | 577 | 12 |
1909441 | 1909441 | 2021-11-12 | Valencia | New Mexico | 35061 | 10226 | 146 |
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);