ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

25,445 rows where state = "New Mexico" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • New Mexico · 25,445 ✖
Link rowid date ▲ county state fips cases deaths
2501394 2501394 2022-05-13 Bernalillo New Mexico 35001 149543 1854
2501395 2501395 2022-05-13 Catron New Mexico 35003 420 14
2501396 2501396 2022-05-13 Chaves New Mexico 35005 21774 328
2501397 2501397 2022-05-13 Cibola New Mexico 35006 8048 189
2501398 2501398 2022-05-13 Colfax New Mexico 35007 2708 65
2501399 2501399 2022-05-13 Curry New Mexico 35009 12797 198
2501400 2501400 2022-05-13 De Baca New Mexico 35011 589 6
2501401 2501401 2022-05-13 Doña Ana New Mexico 35013 63972 773
2501402 2501402 2022-05-13 Eddy New Mexico 35015 17069 282
2501403 2501403 2022-05-13 Grant New Mexico 35017 6748 90
2501404 2501404 2022-05-13 Guadalupe New Mexico 35019 1482 17
2501405 2501405 2022-05-13 Harding New Mexico 35021 85 4
2501406 2501406 2022-05-13 Hidalgo New Mexico 35023 1104 15
2501407 2501407 2022-05-13 Lea New Mexico 35025 20174 342
2501408 2501408 2022-05-13 Lincoln New Mexico 35027 5296 67
2501409 2501409 2022-05-13 Los Alamos New Mexico 35028 2880 16
2501410 2501410 2022-05-13 Luna New Mexico 35029 6725 129
2501411 2501411 2022-05-13 McKinley New Mexico 35031 26007 589
2501412 2501412 2022-05-13 Mora New Mexico 35033 772 18
2501413 2501413 2022-05-13 Otero New Mexico 35035 15613 187
2501414 2501414 2022-05-13 Quay New Mexico 35037 2006 54
2501415 2501415 2022-05-13 Rio Arriba New Mexico 35039 10047 135
2501416 2501416 2022-05-13 Roosevelt New Mexico 35041 5023 97
2501417 2501417 2022-05-13 San Juan New Mexico 35045 40943 755
2501418 2501418 2022-05-13 San Miguel New Mexico 35047 5926 63
2501419 2501419 2022-05-13 Sandoval New Mexico 35043 34112 436
2501420 2501420 2022-05-13 Santa Fe New Mexico 35049 29503 287
2501421 2501421 2022-05-13 Sierra New Mexico 35051 2048 73
2501422 2501422 2022-05-13 Socorro New Mexico 35053 3834 88
2501423 2501423 2022-05-13 Taos New Mexico 35055 5425 90
2501424 2501424 2022-05-13 Torrance New Mexico 35057 3152 56
2501425 2501425 2022-05-13 Union New Mexico 35059 1007 16
2501426 2501426 2022-05-13 Unknown New Mexico   67 0
2501427 2501427 2022-05-13 Valencia New Mexico 35061 19238 276
2498136 2498136 2022-05-12 Bernalillo New Mexico 35001 149415 1851
2498137 2498137 2022-05-12 Catron New Mexico 35003 420 14
2498138 2498138 2022-05-12 Chaves New Mexico 35005 21769 327
2498139 2498139 2022-05-12 Cibola New Mexico 35006 8044 189
2498140 2498140 2022-05-12 Colfax New Mexico 35007 2707 65
2498141 2498141 2022-05-12 Curry New Mexico 35009 12789 198
2498142 2498142 2022-05-12 De Baca New Mexico 35011 588 6
2498143 2498143 2022-05-12 Doña Ana New Mexico 35013 63921 773
2498144 2498144 2022-05-12 Eddy New Mexico 35015 17063 282
2498145 2498145 2022-05-12 Grant New Mexico 35017 6736 90
2498146 2498146 2022-05-12 Guadalupe New Mexico 35019 1481 17
2498147 2498147 2022-05-12 Harding New Mexico 35021 85 4
2498148 2498148 2022-05-12 Hidalgo New Mexico 35023 1104 15
2498149 2498149 2022-05-12 Lea New Mexico 35025 20173 341
2498150 2498150 2022-05-12 Lincoln New Mexico 35027 5295 67
2498151 2498151 2022-05-12 Los Alamos New Mexico 35028 2880 16
2498152 2498152 2022-05-12 Luna New Mexico 35029 6723 129
2498153 2498153 2022-05-12 McKinley New Mexico 35031 26001 589
2498154 2498154 2022-05-12 Mora New Mexico 35033 772 18
2498155 2498155 2022-05-12 Otero New Mexico 35035 15595 187
2498156 2498156 2022-05-12 Quay New Mexico 35037 2006 54
2498157 2498157 2022-05-12 Rio Arriba New Mexico 35039 10028 135
2498158 2498158 2022-05-12 Roosevelt New Mexico 35041 5023 97
2498159 2498159 2022-05-12 San Juan New Mexico 35045 40932 754
2498160 2498160 2022-05-12 San Miguel New Mexico 35047 5925 63
2498161 2498161 2022-05-12 Sandoval New Mexico 35043 34085 436
2498162 2498162 2022-05-12 Santa Fe New Mexico 35049 29446 286
2498163 2498163 2022-05-12 Sierra New Mexico 35051 2046 73
2498164 2498164 2022-05-12 Socorro New Mexico 35053 3831 88
2498165 2498165 2022-05-12 Taos New Mexico 35055 5422 90
2498166 2498166 2022-05-12 Torrance New Mexico 35057 3151 56
2498167 2498167 2022-05-12 Union New Mexico 35059 1007 16
2498168 2498168 2022-05-12 Unknown New Mexico   65 0
2498169 2498169 2022-05-12 Valencia New Mexico 35061 19223 276
2494878 2494878 2022-05-11 Bernalillo New Mexico 35001 149232 1850
2494879 2494879 2022-05-11 Catron New Mexico 35003 420 14
2494880 2494880 2022-05-11 Chaves New Mexico 35005 21758 327
2494881 2494881 2022-05-11 Cibola New Mexico 35006 8034 189
2494882 2494882 2022-05-11 Colfax New Mexico 35007 2707 65
2494883 2494883 2022-05-11 Curry New Mexico 35009 12782 197
2494884 2494884 2022-05-11 De Baca New Mexico 35011 588 6
2494885 2494885 2022-05-11 Doña Ana New Mexico 35013 63890 772
2494886 2494886 2022-05-11 Eddy New Mexico 35015 17061 281
2494887 2494887 2022-05-11 Grant New Mexico 35017 6731 90
2494888 2494888 2022-05-11 Guadalupe New Mexico 35019 1481 17
2494889 2494889 2022-05-11 Harding New Mexico 35021 85 4
2494890 2494890 2022-05-11 Hidalgo New Mexico 35023 1103 15
2494891 2494891 2022-05-11 Lea New Mexico 35025 20169 341
2494892 2494892 2022-05-11 Lincoln New Mexico 35027 5292 67
2494893 2494893 2022-05-11 Los Alamos New Mexico 35028 2869 16
2494894 2494894 2022-05-11 Luna New Mexico 35029 6722 129
2494895 2494895 2022-05-11 McKinley New Mexico 35031 25986 589
2494896 2494896 2022-05-11 Mora New Mexico 35033 772 18
2494897 2494897 2022-05-11 Otero New Mexico 35035 15594 187
2494898 2494898 2022-05-11 Quay New Mexico 35037 2005 54
2494899 2494899 2022-05-11 Rio Arriba New Mexico 35039 9956 135
2494900 2494900 2022-05-11 Roosevelt New Mexico 35041 5023 97
2494901 2494901 2022-05-11 San Juan New Mexico 35045 40924 754
2494902 2494902 2022-05-11 San Miguel New Mexico 35047 5917 63
2494903 2494903 2022-05-11 Sandoval New Mexico 35043 34055 435
2494904 2494904 2022-05-11 Santa Fe New Mexico 35049 29388 286
2494905 2494905 2022-05-11 Sierra New Mexico 35051 2041 73
2494906 2494906 2022-05-11 Socorro New Mexico 35053 3826 88
2494907 2494907 2022-05-11 Taos New Mexico 35055 5417 90
2494908 2494908 2022-05-11 Torrance New Mexico 35057 3148 55
2494909 2494909 2022-05-11 Union New Mexico 35059 1008 16

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);