ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 216 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
county 13
- Gunnison 4
- Dolores 3
- Costilla 2
- Gilpin 2
- Mineral 2
- Alamosa 1
- Montrose 1
- Phillips 1
- Rio Grande 1
- Saguache 1
- San Miguel 1
- Sedgwick 1
- Washington 1
state 1
- Colorado · 21 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174480 | 2174480 | 2022-02-02 | Mineral | Colorado | 8079 | 216 | 1 |
2171227 | 2171227 | 2022-02-01 | Mineral | Colorado | 8079 | 216 | 1 |
1800630 | 1800630 | 2021-10-10 | Dolores | Colorado | 8033 | 216 | 2 |
1797381 | 1797381 | 2021-10-09 | Dolores | Colorado | 8033 | 216 | 2 |
1794132 | 1794132 | 2021-10-08 | Dolores | Colorado | 8033 | 216 | 2 |
1313511 | 1313511 | 2021-05-13 | Costilla | Colorado | 8023 | 216 | 3 |
1310264 | 1310264 | 2021-05-12 | Costilla | Colorado | 8023 | 216 | 3 |
1287586 | 1287586 | 2021-05-05 | Sedgwick | Colorado | 8115 | 216 | 2 |
1251836 | 1251836 | 2021-04-24 | Gilpin | Colorado | 8047 | 216 | 3 |
1248589 | 1248589 | 2021-04-23 | Gilpin | Colorado | 8047 | 216 | 3 |
836354 | 836354 | 2020-12-17 | Phillips | Colorado | 8095 | 216 | 4 |
787680 | 787680 | 2020-12-02 | San Miguel | Colorado | 8113 | 216 | 0 |
777943 | 777943 | 2020-11-29 | Saguache | Colorado | 8109 | 216 | 2 |
774704 | 774704 | 2020-11-28 | Washington | Colorado | 8121 | 216 | 6 |
768206 | 768206 | 2020-11-26 | Rio Grande | Colorado | 8105 | 216 | 4 |
366921 | 366921 | 2020-07-25 | Gunnison | Colorado | 8051 | 216 | 6 |
363714 | 363714 | 2020-07-24 | Gunnison | Colorado | 8051 | 216 | 6 |
360482 | 360482 | 2020-07-23 | Alamosa | Colorado | 8003 | 216 | 7 |
360507 | 360507 | 2020-07-23 | Gunnison | Colorado | 8051 | 216 | 6 |
357302 | 357302 | 2020-07-22 | Gunnison | Colorado | 8051 | 216 | 6 |
318996 | 318996 | 2020-07-10 | Montrose | Colorado | 8085 | 216 | 12 |
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);