ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where "date" is on date 2020-06-18 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adams 1
- Alamosa 1
- Arapahoe 1
- Archuleta 1
- Baca 1
- Bent 1
- Boulder 1
- Broomfield 1
- Chaffee 1
- Cheyenne 1
- Clear Creek 1
- Conejos 1
- Costilla 1
- Crowley 1
- Custer 1
- Delta 1
- Denver 1
- Douglas 1
- Eagle 1
- El Paso 1
- Elbert 1
- Fremont 1
- Garfield 1
- Gilpin 1
- Grand 1
- Gunnison 1
- Hinsdale 1
- Huerfano 1
- Jefferson 1
- Kit Carson 1
- …
state 1
- Colorado · 60 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
249710 | 249710 | 2020-06-18 | Adams | Colorado | 8001 | 3819 | 149 |
249711 | 249711 | 2020-06-18 | Alamosa | Colorado | 8003 | 140 | 3 |
249712 | 249712 | 2020-06-18 | Arapahoe | Colorado | 8005 | 4885 | 340 |
249713 | 249713 | 2020-06-18 | Archuleta | Colorado | 8007 | 8 | 0 |
249714 | 249714 | 2020-06-18 | Baca | Colorado | 8009 | 12 | 0 |
249715 | 249715 | 2020-06-18 | Bent | Colorado | 8011 | 3 | 0 |
249716 | 249716 | 2020-06-18 | Boulder | Colorado | 8013 | 1173 | 70 |
249717 | 249717 | 2020-06-18 | Broomfield | Colorado | 8014 | 271 | 28 |
249718 | 249718 | 2020-06-18 | Chaffee | Colorado | 8015 | 78 | 20 |
249719 | 249719 | 2020-06-18 | Cheyenne | Colorado | 8017 | 5 | 0 |
249720 | 249720 | 2020-06-18 | Clear Creek | Colorado | 8019 | 18 | 1 |
249721 | 249721 | 2020-06-18 | Conejos | Colorado | 8021 | 7 | 0 |
249722 | 249722 | 2020-06-18 | Costilla | Colorado | 8023 | 17 | 0 |
249723 | 249723 | 2020-06-18 | Crowley | Colorado | 8025 | 68 | 1 |
249724 | 249724 | 2020-06-18 | Custer | Colorado | 8027 | 2 | 0 |
249725 | 249725 | 2020-06-18 | Delta | Colorado | 8029 | 80 | 1 |
249726 | 249726 | 2020-06-18 | Denver | Colorado | 8031 | 6493 | 366 |
249727 | 249727 | 2020-06-18 | Douglas | Colorado | 8035 | 825 | 50 |
249728 | 249728 | 2020-06-18 | Eagle | Colorado | 8037 | 633 | 8 |
249729 | 249729 | 2020-06-18 | El Paso | Colorado | 8041 | 2024 | 114 |
249730 | 249730 | 2020-06-18 | Elbert | Colorado | 8039 | 54 | 2 |
249731 | 249731 | 2020-06-18 | Fremont | Colorado | 8043 | 30 | 0 |
249732 | 249732 | 2020-06-18 | Garfield | Colorado | 8045 | 205 | 2 |
249733 | 249733 | 2020-06-18 | Gilpin | Colorado | 8047 | 6 | 0 |
249734 | 249734 | 2020-06-18 | Grand | Colorado | 8049 | 17 | 0 |
249735 | 249735 | 2020-06-18 | Gunnison | Colorado | 8051 | 181 | 6 |
249736 | 249736 | 2020-06-18 | Hinsdale | Colorado | 8053 | 3 | 0 |
249737 | 249737 | 2020-06-18 | Huerfano | Colorado | 8055 | 3 | 0 |
249738 | 249738 | 2020-06-18 | Jefferson | Colorado | 8059 | 2508 | 202 |
249739 | 249739 | 2020-06-18 | Kit Carson | Colorado | 8063 | 31 | 3 |
249740 | 249740 | 2020-06-18 | La Plata | Colorado | 8067 | 86 | 1 |
249741 | 249741 | 2020-06-18 | Lake | Colorado | 8065 | 42 | 0 |
249742 | 249742 | 2020-06-18 | Larimer | Colorado | 8069 | 661 | 29 |
249743 | 249743 | 2020-06-18 | Las Animas | Colorado | 8071 | 7 | 0 |
249744 | 249744 | 2020-06-18 | Lincoln | Colorado | 8073 | 3 | 0 |
249745 | 249745 | 2020-06-18 | Logan | Colorado | 8075 | 634 | 5 |
249746 | 249746 | 2020-06-18 | Mesa | Colorado | 8077 | 77 | 0 |
249747 | 249747 | 2020-06-18 | Mineral | Colorado | 8079 | 2 | 0 |
249748 | 249748 | 2020-06-18 | Moffat | Colorado | 8081 | 9 | 0 |
249749 | 249749 | 2020-06-18 | Montezuma | Colorado | 8083 | 66 | 3 |
249750 | 249750 | 2020-06-18 | Montrose | Colorado | 8085 | 198 | 12 |
249751 | 249751 | 2020-06-18 | Morgan | Colorado | 8087 | 647 | 46 |
249752 | 249752 | 2020-06-18 | Otero | Colorado | 8089 | 22 | 1 |
249753 | 249753 | 2020-06-18 | Ouray | Colorado | 8091 | 9 | 1 |
249754 | 249754 | 2020-06-18 | Park | Colorado | 8093 | 23 | 0 |
249755 | 249755 | 2020-06-18 | Phillips | Colorado | 8095 | 15 | 0 |
249756 | 249756 | 2020-06-18 | Pitkin | Colorado | 8097 | 78 | 2 |
249757 | 249757 | 2020-06-18 | Prowers | Colorado | 8099 | 16 | 0 |
249758 | 249758 | 2020-06-18 | Pueblo | Colorado | 8101 | 351 | 23 |
249759 | 249759 | 2020-06-18 | Rio Blanco | Colorado | 8103 | 2 | 0 |
249760 | 249760 | 2020-06-18 | Rio Grande | Colorado | 8105 | 57 | 0 |
249761 | 249761 | 2020-06-18 | Routt | Colorado | 8107 | 63 | 6 |
249762 | 249762 | 2020-06-18 | Saguache | Colorado | 8109 | 98 | 2 |
249763 | 249763 | 2020-06-18 | San Juan | Colorado | 8111 | 1 | 0 |
249764 | 249764 | 2020-06-18 | San Miguel | Colorado | 8113 | 28 | 0 |
249765 | 249765 | 2020-06-18 | Summit | Colorado | 8117 | 262 | 3 |
249766 | 249766 | 2020-06-18 | Teller | Colorado | 8119 | 39 | 2 |
249767 | 249767 | 2020-06-18 | Washington | Colorado | 8121 | 44 | 0 |
249768 | 249768 | 2020-06-18 | Weld | Colorado | 8123 | 2698 | 136 |
249769 | 249769 | 2020-06-18 | Yuma | Colorado | 8125 | 49 | 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);