ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 628 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- New Mexico · 23 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2153250 | 2153250 | 2022-01-26 | Mora | New Mexico | 35033 | 628 | 16 |
1961446 | 1961446 | 2021-11-28 | Union | New Mexico | 35059 | 628 | 12 |
1958195 | 1958195 | 2021-11-27 | Union | New Mexico | 35059 | 628 | 12 |
1954944 | 1954944 | 2021-11-26 | Union | New Mexico | 35059 | 628 | 12 |
1951693 | 1951693 | 2021-11-25 | Union | New Mexico | 35059 | 628 | 12 |
1948442 | 1948442 | 2021-11-24 | Union | New Mexico | 35059 | 628 | 12 |
1620278 | 1620278 | 2021-08-15 | Quay | New Mexico | 35037 | 628 | 11 |
1617030 | 1617030 | 2021-08-14 | Quay | New Mexico | 35037 | 628 | 11 |
1613782 | 1613782 | 2021-08-13 | Quay | New Mexico | 35037 | 628 | 11 |
1269626 | 1269626 | 2021-04-29 | Guadalupe | New Mexico | 35019 | 628 | 9 |
1266379 | 1266379 | 2021-04-28 | Guadalupe | New Mexico | 35019 | 628 | 9 |
1263132 | 1263132 | 2021-04-27 | Guadalupe | New Mexico | 35019 | 628 | 9 |
1191683 | 1191683 | 2021-04-05 | Guadalupe | New Mexico | 35019 | 628 | 9 |
1188435 | 1188435 | 2021-04-04 | Guadalupe | New Mexico | 35019 | 628 | 9 |
1185188 | 1185188 | 2021-04-03 | Guadalupe | New Mexico | 35019 | 628 | 9 |
1181941 | 1181941 | 2021-04-02 | Guadalupe | New Mexico | 35019 | 628 | 9 |
1178694 | 1178694 | 2021-04-01 | Guadalupe | New Mexico | 35019 | 628 | 9 |
1175447 | 1175447 | 2021-03-31 | Guadalupe | New Mexico | 35019 | 628 | 9 |
1172200 | 1172200 | 2021-03-30 | Guadalupe | New Mexico | 35019 | 628 | 9 |
974204 | 974204 | 2021-01-28 | Torrance | New Mexico | 35057 | 628 | 11 |
922277 | 922277 | 2021-01-12 | Sierra | New Mexico | 35051 | 628 | 39 |
831405 | 831405 | 2020-12-15 | San Miguel | New Mexico | 35047 | 628 | 2 |
714576 | 714576 | 2020-11-09 | Roosevelt | New Mexico | 35041 | 628 | 10 |
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);