ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where deaths = 110, fips = 35029 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2156501 | 2156501 | 2022-01-27 | Luna | New Mexico | 35029 | 6025 | 110 |
2153248 | 2153248 | 2022-01-26 | Luna | New Mexico | 35029 | 5907 | 110 |
2149996 | 2149996 | 2022-01-25 | Luna | New Mexico | 35029 | 5849 | 110 |
2146744 | 2146744 | 2022-01-24 | Luna | New Mexico | 35029 | 5825 | 110 |
2143489 | 2143489 | 2022-01-23 | Luna | New Mexico | 35029 | 5663 | 110 |
2140234 | 2140234 | 2022-01-22 | Luna | New Mexico | 35029 | 5663 | 110 |
2136978 | 2136978 | 2022-01-21 | Luna | New Mexico | 35029 | 5663 | 110 |
2133726 | 2133726 | 2022-01-20 | Luna | New Mexico | 35029 | 5582 | 110 |
2130473 | 2130473 | 2022-01-19 | Luna | New Mexico | 35029 | 5509 | 110 |
2127219 | 2127219 | 2022-01-18 | Luna | New Mexico | 35029 | 5469 | 110 |
2123967 | 2123967 | 2022-01-17 | Luna | New Mexico | 35029 | 5294 | 110 |
2120715 | 2120715 | 2022-01-16 | Luna | New Mexico | 35029 | 5294 | 110 |
2117463 | 2117463 | 2022-01-15 | Luna | New Mexico | 35029 | 5294 | 110 |
2114212 | 2114212 | 2022-01-14 | Luna | New Mexico | 35029 | 5294 | 110 |
2110960 | 2110960 | 2022-01-13 | Luna | New Mexico | 35029 | 5237 | 110 |
2107709 | 2107709 | 2022-01-12 | Luna | New Mexico | 35029 | 5195 | 110 |
2104458 | 2104458 | 2022-01-11 | Luna | New Mexico | 35029 | 5159 | 110 |
2101207 | 2101207 | 2022-01-10 | Luna | New Mexico | 35029 | 5132 | 110 |
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);