ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 431 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
county 9
- Huerfano 6
- Clear Creek 4
- Washington 2
- Chaffee 1
- Elbert 1
- La Plata 1
- Montrose 1
- Ouray 1
- San Miguel 1
state 1
- Colorado · 18 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1833150 | 1833150 | 2021-10-20 | Ouray | Colorado | 8091 | 431 | 5 |
1427140 | 1427140 | 2021-06-17 | Huerfano | Colorado | 8055 | 431 | 17 |
1423895 | 1423895 | 2021-06-16 | Huerfano | Colorado | 8055 | 431 | 17 |
1420647 | 1420647 | 2021-06-15 | Huerfano | Colorado | 8055 | 431 | 17 |
1417402 | 1417402 | 2021-06-14 | Huerfano | Colorado | 8055 | 431 | 17 |
1414156 | 1414156 | 2021-06-13 | Huerfano | Colorado | 8055 | 431 | 17 |
1410911 | 1410911 | 2021-06-12 | Huerfano | Colorado | 8055 | 431 | 17 |
1248575 | 1248575 | 2021-04-23 | Clear Creek | Colorado | 8019 | 431 | 3 |
1245328 | 1245328 | 2021-04-22 | Clear Creek | Colorado | 8019 | 431 | 3 |
1242081 | 1242081 | 2021-04-21 | Clear Creek | Colorado | 8019 | 431 | 3 |
1238834 | 1238834 | 2021-04-20 | Clear Creek | Colorado | 8019 | 431 | 3 |
1154443 | 1154443 | 2021-03-25 | Washington | Colorado | 8121 | 431 | 12 |
1151196 | 1151196 | 2021-03-24 | Washington | Colorado | 8121 | 431 | 12 |
914249 | 914249 | 2021-01-10 | San Miguel | Colorado | 8113 | 431 | 0 |
742206 | 742206 | 2020-11-18 | Elbert | Colorado | 8039 | 431 | 4 |
703289 | 703289 | 2020-11-06 | La Plata | Colorado | 8067 | 431 | 2 |
683803 | 683803 | 2020-10-31 | Chaffee | Colorado | 8015 | 431 | 20 |
654646 | 654646 | 2020-10-22 | Montrose | Colorado | 8085 | 431 | 13 |
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);