ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 28 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1514779 | 1514779 | 2021-07-14 | Hinsdale | Colorado | 8053 | 28 | 0 |
878548 | 878548 | 2020-12-30 | San Juan | Colorado | 8111 | 28 | 0 |
852588 | 852588 | 2020-12-22 | San Juan | Colorado | 8111 | 28 | 0 |
849343 | 849343 | 2020-12-21 | San Juan | Colorado | 8111 | 28 | 0 |
846098 | 846098 | 2020-12-20 | San Juan | Colorado | 8111 | 28 | 0 |
842852 | 842852 | 2020-12-19 | San Juan | Colorado | 8111 | 28 | 0 |
829842 | 829842 | 2020-12-15 | Jackson | Colorado | 8057 | 28 | 0 |
719479 | 719479 | 2020-11-11 | Bent | Colorado | 8011 | 28 | 0 |
674090 | 674090 | 2020-10-28 | Gilpin | Colorado | 8047 | 28 | 0 |
670848 | 670848 | 2020-10-27 | Gilpin | Colorado | 8047 | 28 | 0 |
670876 | 670876 | 2020-10-27 | Rio Blanco | Colorado | 8103 | 28 | 0 |
667605 | 667605 | 2020-10-26 | Gilpin | Colorado | 8047 | 28 | 0 |
667633 | 667633 | 2020-10-26 | Rio Blanco | Colorado | 8103 | 28 | 0 |
644897 | 644897 | 2020-10-19 | Huerfano | Colorado | 8055 | 28 | 2 |
638402 | 638402 | 2020-10-17 | Huerfano | Colorado | 8055 | 28 | 2 |
635157 | 635157 | 2020-10-16 | Huerfano | Colorado | 8055 | 28 | 2 |
625432 | 625432 | 2020-10-13 | Las Animas | Colorado | 8071 | 28 | 0 |
622189 | 622189 | 2020-10-12 | Las Animas | Colorado | 8071 | 28 | 0 |
618946 | 618946 | 2020-10-11 | Las Animas | Colorado | 8071 | 28 | 0 |
615704 | 615704 | 2020-10-10 | Las Animas | Colorado | 8071 | 28 | 0 |
612463 | 612463 | 2020-10-09 | Las Animas | Colorado | 8071 | 28 | 0 |
599503 | 599503 | 2020-10-05 | Ouray | Colorado | 8091 | 28 | 1 |
596260 | 596260 | 2020-10-04 | Ouray | Colorado | 8091 | 28 | 1 |
593018 | 593018 | 2020-10-03 | Ouray | Colorado | 8091 | 28 | 1 |
589778 | 589778 | 2020-10-02 | Ouray | Colorado | 8091 | 28 | 1 |
586537 | 586537 | 2020-10-01 | Ouray | Colorado | 8091 | 28 | 1 |
515298 | 515298 | 2020-09-09 | Phillips | Colorado | 8095 | 28 | 0 |
402275 | 402275 | 2020-08-05 | Clear Creek | Colorado | 8019 | 28 | 1 |
399059 | 399059 | 2020-08-04 | Clear Creek | Colorado | 8019 | 28 | 1 |
373320 | 373320 | 2020-07-27 | Archuleta | Colorado | 8007 | 28 | 0 |
325339 | 325339 | 2020-07-12 | Grand | Colorado | 8049 | 28 | 1 |
309482 | 309482 | 2020-07-07 | Park | Colorado | 8093 | 28 | 0 |
306314 | 306314 | 2020-07-06 | Park | Colorado | 8093 | 28 | 0 |
262252 | 262252 | 2020-06-22 | San Miguel | Colorado | 8113 | 28 | 0 |
259125 | 259125 | 2020-06-21 | San Miguel | Colorado | 8113 | 28 | 0 |
255998 | 255998 | 2020-06-20 | San Miguel | Colorado | 8113 | 28 | 0 |
252879 | 252879 | 2020-06-19 | San Miguel | Colorado | 8113 | 28 | 0 |
249764 | 249764 | 2020-06-18 | San Miguel | Colorado | 8113 | 28 | 0 |
112756 | 112756 | 2020-05-04 | Teller | Colorado | 8119 | 28 | 2 |
109881 | 109881 | 2020-05-03 | Teller | Colorado | 8119 | 28 | 2 |
107012 | 107012 | 2020-05-02 | Teller | Colorado | 8119 | 28 | 2 |
104147 | 104147 | 2020-05-01 | Teller | Colorado | 8119 | 28 | 2 |
101292 | 101292 | 2020-04-30 | Teller | Colorado | 8119 | 28 | 2 |
98407 | 98407 | 2020-04-29 | Elbert | Colorado | 8039 | 28 | 1 |
98442 | 98442 | 2020-04-29 | Teller | Colorado | 8119 | 28 | 2 |
95597 | 95597 | 2020-04-28 | Teller | Colorado | 8119 | 28 | 2 |
56684 | 56684 | 2020-04-14 | Chaffee | Colorado | 8015 | 28 | 4 |
53992 | 53992 | 2020-04-13 | Chaffee | Colorado | 8015 | 28 | 4 |
51313 | 51313 | 2020-04-12 | Chaffee | Colorado | 8015 | 28 | 3 |
48651 | 48651 | 2020-04-11 | Chaffee | Colorado | 8015 | 28 | 3 |
28646 | 28646 | 2020-04-03 | Routt | Colorado | 8107 | 28 | 0 |
26342 | 26342 | 2020-04-02 | Pueblo | Colorado | 8101 | 28 | 2 |
24112 | 24112 | 2020-04-01 | Pueblo | Colorado | 8101 | 28 | 2 |
8377 | 8377 | 2020-03-23 | Gunnison | Colorado | 8051 | 28 | 1 |
2795 | 2795 | 2020-03-16 | Denver | Colorado | 8031 | 28 | 0 |
2360 | 2360 | 2020-03-15 | Denver | Colorado | 8031 | 28 | 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);