ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 66 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 17
county 17
- Crowley 9
- Chaffee 6
- Grand 6
- Conejos 5
- La Plata 4
- Dolores 2
- Mesa 2
- Archuleta 1
- Boulder 1
- Gunnison 1
- Huerfano 1
- Kit Carson 1
- Las Animas 1
- Montezuma 1
- Rio Grande 1
- San Miguel 1
- Teller 1
state 1
- Colorado · 44 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1044028 | 1044028 | 2021-02-19 | Dolores | Colorado | 8033 | 66 | 0 |
1040783 | 1040783 | 2021-02-18 | Dolores | Colorado | 8033 | 66 | 0 |
719502 | 719502 | 2020-11-11 | Huerfano | Colorado | 8055 | 66 | 3 |
674077 | 674077 | 2020-10-28 | Conejos | Colorado | 8021 | 66 | 0 |
670835 | 670835 | 2020-10-27 | Conejos | Colorado | 8021 | 66 | 0 |
667584 | 667584 | 2020-10-26 | Archuleta | Colorado | 8007 | 66 | 0 |
667592 | 667592 | 2020-10-26 | Conejos | Colorado | 8021 | 66 | 0 |
664347 | 664347 | 2020-10-25 | Conejos | Colorado | 8021 | 66 | 0 |
661103 | 661103 | 2020-10-24 | Conejos | Colorado | 8021 | 66 | 0 |
657884 | 657884 | 2020-10-23 | Las Animas | Colorado | 8071 | 66 | 1 |
505578 | 505578 | 2020-09-06 | Grand | Colorado | 8049 | 66 | 1 |
502344 | 502344 | 2020-09-05 | Grand | Colorado | 8049 | 66 | 1 |
499110 | 499110 | 2020-09-04 | Grand | Colorado | 8049 | 66 | 1 |
495877 | 495877 | 2020-09-03 | Grand | Colorado | 8049 | 66 | 1 |
492643 | 492643 | 2020-09-02 | Grand | Colorado | 8049 | 66 | 1 |
489410 | 489410 | 2020-09-01 | Grand | Colorado | 8049 | 66 | 1 |
424836 | 424836 | 2020-08-12 | Kit Carson | Colorado | 8063 | 66 | 3 |
347726 | 347726 | 2020-07-19 | San Miguel | Colorado | 8113 | 66 | 0 |
338133 | 338133 | 2020-07-16 | Teller | Colorado | 8119 | 66 | 2 |
265376 | 265376 | 2020-06-23 | Rio Grande | Colorado | 8105 | 66 | 1 |
249749 | 249749 | 2020-06-18 | Montezuma | Colorado | 8083 | 66 | 3 |
234172 | 234172 | 2020-06-13 | Crowley | Colorado | 8025 | 66 | 1 |
234195 | 234195 | 2020-06-13 | Mesa | Colorado | 8077 | 66 | 0 |
231066 | 231066 | 2020-06-12 | Crowley | Colorado | 8025 | 66 | 1 |
231089 | 231089 | 2020-06-12 | Mesa | Colorado | 8077 | 66 | 0 |
227963 | 227963 | 2020-06-11 | Crowley | Colorado | 8025 | 66 | 1 |
224861 | 224861 | 2020-06-10 | Crowley | Colorado | 8025 | 66 | 1 |
221766 | 221766 | 2020-06-09 | Crowley | Colorado | 8025 | 66 | 1 |
218671 | 218671 | 2020-06-08 | Crowley | Colorado | 8025 | 66 | 1 |
215580 | 215580 | 2020-06-07 | Crowley | Colorado | 8025 | 66 | 1 |
212493 | 212493 | 2020-06-06 | Crowley | Colorado | 8025 | 66 | 1 |
209408 | 209408 | 2020-06-05 | Crowley | Colorado | 8025 | 66 | 1 |
145466 | 145466 | 2020-05-15 | La Plata | Colorado | 8067 | 66 | 1 |
142466 | 142466 | 2020-05-14 | La Plata | Colorado | 8067 | 66 | 1 |
139470 | 139470 | 2020-05-13 | La Plata | Colorado | 8067 | 66 | 1 |
136479 | 136479 | 2020-05-12 | La Plata | Colorado | 8067 | 66 | 1 |
101247 | 101247 | 2020-04-30 | Chaffee | Colorado | 8015 | 66 | 15 |
98397 | 98397 | 2020-04-29 | Chaffee | Colorado | 8015 | 66 | 15 |
95552 | 95552 | 2020-04-28 | Chaffee | Colorado | 8015 | 66 | 13 |
92720 | 92720 | 2020-04-27 | Chaffee | Colorado | 8015 | 66 | 12 |
89902 | 89902 | 2020-04-26 | Chaffee | Colorado | 8015 | 66 | 12 |
84277 | 84277 | 2020-04-24 | Chaffee | Colorado | 8015 | 66 | 13 |
14207 | 14207 | 2020-03-27 | Gunnison | Colorado | 8051 | 66 | 1 |
12525 | 12525 | 2020-03-26 | Boulder | Colorado | 8013 | 66 | 0 |
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);