ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 127 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
state 1
- Colorado · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464034 | 2464034 | 2022-05-02 | Otero | Colorado | 8089 | 4299 | 127 |
2460778 | 2460778 | 2022-05-01 | Otero | Colorado | 8089 | 4299 | 127 |
2457522 | 2457522 | 2022-04-30 | Otero | Colorado | 8089 | 4299 | 127 |
2454266 | 2454266 | 2022-04-29 | Otero | Colorado | 8089 | 4299 | 127 |
2451010 | 2451010 | 2022-04-28 | Otero | Colorado | 8089 | 4298 | 127 |
2447754 | 2447754 | 2022-04-27 | Otero | Colorado | 8089 | 4298 | 127 |
2444498 | 2444498 | 2022-04-26 | Otero | Colorado | 8089 | 4296 | 127 |
2441242 | 2441242 | 2022-04-25 | Otero | Colorado | 8089 | 4295 | 127 |
2437986 | 2437986 | 2022-04-24 | Otero | Colorado | 8089 | 4295 | 127 |
2434730 | 2434730 | 2022-04-23 | Otero | Colorado | 8089 | 4295 | 127 |
2431474 | 2431474 | 2022-04-22 | Otero | Colorado | 8089 | 4295 | 127 |
2428218 | 2428218 | 2022-04-21 | Otero | Colorado | 8089 | 4292 | 127 |
2424962 | 2424962 | 2022-04-20 | Otero | Colorado | 8089 | 4290 | 127 |
2421706 | 2421706 | 2022-04-19 | Otero | Colorado | 8089 | 4289 | 127 |
2418450 | 2418450 | 2022-04-18 | Otero | Colorado | 8089 | 4283 | 127 |
2197225 | 2197225 | 2022-02-09 | Delta | Colorado | 8029 | 5692 | 127 |
2106167 | 2106167 | 2022-01-12 | Morgan | Colorado | 8087 | 4539 | 127 |
2102916 | 2102916 | 2022-01-11 | Morgan | Colorado | 8087 | 4506 | 127 |
2099665 | 2099665 | 2022-01-10 | Morgan | Colorado | 8087 | 4472 | 127 |
2096414 | 2096414 | 2022-01-09 | Morgan | Colorado | 8087 | 4360 | 127 |
2093162 | 2093162 | 2022-01-08 | Morgan | Colorado | 8087 | 4360 | 127 |
2089910 | 2089910 | 2022-01-07 | Morgan | Colorado | 8087 | 4360 | 127 |
1946863 | 1946863 | 2021-11-24 | Fremont | Colorado | 8043 | 9834 | 127 |
872041 | 872041 | 2020-12-28 | Mesa | Colorado | 8077 | 8869 | 127 |
868796 | 868796 | 2020-12-27 | Mesa | Colorado | 8077 | 8801 | 127 |
865551 | 865551 | 2020-12-26 | Mesa | Colorado | 8077 | 8760 | 127 |
862306 | 862306 | 2020-12-25 | Mesa | Colorado | 8077 | 8685 | 127 |
859061 | 859061 | 2020-12-24 | Mesa | Colorado | 8077 | 8618 | 127 |
203234 | 203234 | 2020-06-03 | Adams | Colorado | 8001 | 3379 | 127 |
178787 | 178787 | 2020-05-26 | Weld | Colorado | 8123 | 2423 | 127 |
89897 | 89897 | 2020-04-26 | Arapahoe | Colorado | 8005 | 2160 | 127 |
87080 | 87080 | 2020-04-25 | Arapahoe | Colorado | 8005 | 2083 | 127 |
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);