ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where deaths = 326 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Colorado · 14 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2057362 | 2057362 | 2021-12-28 | Boulder | Colorado | 8013 | 38785 | 326 |
1849391 | 1849391 | 2021-10-25 | Mesa | Colorado | 8077 | 23867 | 326 |
1190165 | 1190165 | 2021-04-05 | Weld | Colorado | 8123 | 27926 | 326 |
1186918 | 1186918 | 2021-04-04 | Weld | Colorado | 8123 | 27813 | 326 |
1183671 | 1183671 | 2021-04-03 | Weld | Colorado | 8123 | 27742 | 326 |
1180424 | 1180424 | 2021-04-02 | Weld | Colorado | 8123 | 27700 | 326 |
1177177 | 1177177 | 2021-04-01 | Weld | Colorado | 8123 | 27606 | 326 |
1173930 | 1173930 | 2021-03-31 | Weld | Colorado | 8123 | 27531 | 326 |
894772 | 894772 | 2021-01-04 | Pueblo | Colorado | 8101 | 13523 | 326 |
218660 | 218660 | 2020-06-08 | Arapahoe | Colorado | 8005 | 4663 | 326 |
215569 | 215569 | 2020-06-07 | Arapahoe | Colorado | 8005 | 4637 | 326 |
212482 | 212482 | 2020-06-06 | Arapahoe | Colorado | 8005 | 4626 | 326 |
209397 | 209397 | 2020-06-05 | Arapahoe | Colorado | 8005 | 4591 | 326 |
187899 | 187899 | 2020-05-29 | Denver | Colorado | 8031 | 5569 | 326 |
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);