ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 260 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
state 1
- Colorado · 21 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1673942 | 1673942 | 2021-09-01 | Larimer | Colorado | 8069 | 31731 | 260 |
1670694 | 1670694 | 2021-08-31 | Larimer | Colorado | 8069 | 31620 | 260 |
1537523 | 1537523 | 2021-07-21 | Mesa | Colorado | 8077 | 17966 | 260 |
1534275 | 1534275 | 2021-07-20 | Mesa | Colorado | 8077 | 17879 | 260 |
1531028 | 1531028 | 2021-07-19 | Mesa | Colorado | 8077 | 17879 | 260 |
1527781 | 1527781 | 2021-07-18 | Mesa | Colorado | 8077 | 17800 | 260 |
1524534 | 1524534 | 2021-07-17 | Mesa | Colorado | 8077 | 17800 | 260 |
1521286 | 1521286 | 2021-07-16 | Mesa | Colorado | 8077 | 17800 | 260 |
1427118 | 1427118 | 2021-06-17 | Boulder | Colorado | 8013 | 23990 | 260 |
1423873 | 1423873 | 2021-06-16 | Boulder | Colorado | 8013 | 23973 | 260 |
1420625 | 1420625 | 2021-06-15 | Boulder | Colorado | 8013 | 23975 | 260 |
1417380 | 1417380 | 2021-06-14 | Boulder | Colorado | 8013 | 23893 | 260 |
1414134 | 1414134 | 2021-06-13 | Boulder | Colorado | 8013 | 23880 | 260 |
1410889 | 1410889 | 2021-06-12 | Boulder | Colorado | 8013 | 23880 | 260 |
1407644 | 1407644 | 2021-06-11 | Boulder | Colorado | 8013 | 23880 | 260 |
1394673 | 1394673 | 2021-06-07 | Douglas | Colorado | 8035 | 30424 | 260 |
1391428 | 1391428 | 2021-06-06 | Douglas | Colorado | 8035 | 30415 | 260 |
1388183 | 1388183 | 2021-06-05 | Douglas | Colorado | 8035 | 30368 | 260 |
1384938 | 1384938 | 2021-06-04 | Douglas | Colorado | 8035 | 30314 | 260 |
1381692 | 1381692 | 2021-06-03 | Douglas | Colorado | 8035 | 30245 | 260 |
674066 | 674066 | 2020-10-28 | Adams | Colorado | 8001 | 14173 | 260 |
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);