ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where deaths = 23 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 |
---|---|---|---|---|---|---|---|
1974447 | 1974447 | 2021-12-02 | Torrance | New Mexico | 35057 | 2056 | 23 |
1922429 | 1922429 | 2021-11-16 | Quay | New Mexico | 35037 | 1162 | 23 |
1919179 | 1919179 | 2021-11-15 | Quay | New Mexico | 35037 | 1133 | 23 |
1915929 | 1915929 | 2021-11-14 | Quay | New Mexico | 35037 | 1116 | 23 |
1912679 | 1912679 | 2021-11-13 | Quay | New Mexico | 35037 | 1116 | 23 |
1909429 | 1909429 | 2021-11-12 | Quay | New Mexico | 35037 | 1116 | 23 |
1906180 | 1906180 | 2021-11-11 | Quay | New Mexico | 35037 | 1078 | 23 |
1902931 | 1902931 | 2021-11-10 | Quay | New Mexico | 35037 | 1078 | 23 |
1899681 | 1899681 | 2021-11-09 | Quay | New Mexico | 35037 | 1067 | 23 |
1896431 | 1896431 | 2021-11-08 | Quay | New Mexico | 35037 | 1064 | 23 |
1893181 | 1893181 | 2021-11-07 | Quay | New Mexico | 35037 | 1056 | 23 |
1889931 | 1889931 | 2021-11-06 | Quay | New Mexico | 35037 | 1056 | 23 |
1886681 | 1886681 | 2021-11-05 | Quay | New Mexico | 35037 | 1056 | 23 |
1883432 | 1883432 | 2021-11-04 | Quay | New Mexico | 35037 | 1054 | 23 |
1880183 | 1880183 | 2021-11-03 | Quay | New Mexico | 35037 | 1052 | 23 |
1876934 | 1876934 | 2021-11-02 | Quay | New Mexico | 35037 | 1050 | 23 |
1873685 | 1873685 | 2021-11-01 | Quay | New Mexico | 35037 | 1047 | 23 |
1870436 | 1870436 | 2021-10-31 | Quay | New Mexico | 35037 | 1036 | 23 |
1867187 | 1867187 | 2021-10-30 | Quay | New Mexico | 35037 | 1036 | 23 |
1863938 | 1863938 | 2021-10-29 | Quay | New Mexico | 35037 | 1036 | 23 |
1860689 | 1860689 | 2021-10-28 | Quay | New Mexico | 35037 | 1032 | 23 |
1857440 | 1857440 | 2021-10-27 | Quay | New Mexico | 35037 | 1030 | 23 |
1854191 | 1854191 | 2021-10-26 | Quay | New Mexico | 35037 | 1020 | 23 |
1850942 | 1850942 | 2021-10-25 | Quay | New Mexico | 35037 | 1015 | 23 |
1847692 | 1847692 | 2021-10-24 | Quay | New Mexico | 35037 | 1008 | 23 |
1847696 | 1847696 | 2021-10-24 | San Miguel | New Mexico | 35047 | 2566 | 23 |
1844442 | 1844442 | 2021-10-23 | Quay | New Mexico | 35037 | 1008 | 23 |
1844446 | 1844446 | 2021-10-23 | San Miguel | New Mexico | 35047 | 2566 | 23 |
1841192 | 1841192 | 2021-10-22 | Quay | New Mexico | 35037 | 1008 | 23 |
1841196 | 1841196 | 2021-10-22 | San Miguel | New Mexico | 35047 | 2566 | 23 |
1837947 | 1837947 | 2021-10-21 | San Miguel | New Mexico | 35047 | 2563 | 23 |
1698234 | 1698234 | 2021-09-08 | Lincoln | New Mexico | 35027 | 2381 | 23 |
951468 | 951468 | 2021-01-21 | Grant | New Mexico | 35017 | 1212 | 23 |
948222 | 948222 | 2021-01-20 | Grant | New Mexico | 35017 | 1206 | 23 |
876837 | 876837 | 2020-12-29 | Roosevelt | New Mexico | 35041 | 1481 | 23 |
789219 | 789219 | 2020-12-02 | Taos | New Mexico | 35055 | 853 | 23 |
785966 | 785966 | 2020-12-01 | Rio Arriba | New Mexico | 35039 | 1364 | 23 |
785974 | 785974 | 2020-12-01 | Taos | New Mexico | 35055 | 851 | 23 |
782722 | 782722 | 2020-11-30 | Rio Arriba | New Mexico | 35039 | 1325 | 23 |
782730 | 782730 | 2020-11-30 | Taos | New Mexico | 35055 | 841 | 23 |
779484 | 779484 | 2020-11-29 | Taos | New Mexico | 35055 | 816 | 23 |
769739 | 769739 | 2020-11-26 | Otero | New Mexico | 35035 | 2408 | 23 |
766493 | 766493 | 2020-11-25 | Otero | New Mexico | 35035 | 2391 | 23 |
763248 | 763248 | 2020-11-24 | Otero | New Mexico | 35035 | 2363 | 23 |
763261 | 763261 | 2020-11-24 | Valencia | New Mexico | 35061 | 2743 | 23 |
760003 | 760003 | 2020-11-23 | Otero | New Mexico | 35035 | 2315 | 23 |
756754 | 756754 | 2020-11-22 | Luna | New Mexico | 35029 | 1794 | 23 |
756757 | 756757 | 2020-11-22 | Otero | New Mexico | 35035 | 2301 | 23 |
753507 | 753507 | 2020-11-21 | Luna | New Mexico | 35029 | 1745 | 23 |
753510 | 753510 | 2020-11-21 | Otero | New Mexico | 35035 | 2246 | 23 |
750264 | 750264 | 2020-11-20 | Otero | New Mexico | 35035 | 2221 | 23 |
737287 | 737287 | 2020-11-16 | Santa Fe | New Mexico | 35049 | 3278 | 23 |
688610 | 688610 | 2020-11-01 | Cibola | New Mexico | 35006 | 1011 | 23 |
685365 | 685365 | 2020-10-31 | Cibola | New Mexico | 35006 | 1002 | 23 |
682122 | 682122 | 2020-10-30 | Cibola | New Mexico | 35006 | 988 | 23 |
678884 | 678884 | 2020-10-29 | Eddy | New Mexico | 35015 | 1505 | 23 |
675641 | 675641 | 2020-10-28 | Eddy | New Mexico | 35015 | 1481 | 23 |
394170 | 394170 | 2020-08-02 | Doña Ana | New Mexico | 35013 | 2225 | 23 |
390953 | 390953 | 2020-08-01 | Doña Ana | New Mexico | 35013 | 2189 | 23 |
149903 | 149903 | 2020-05-16 | Sandoval | New Mexico | 35043 | 488 | 23 |
68941 | 68941 | 2020-04-18 | Bernalillo | New Mexico | 35001 | 527 | 23 |
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);