ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49,527 rows where state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Douglas 116
- Jefferson 116
- Denver 115
- Eagle 115
- El Paso 115
- Arapahoe 112
- Larimer 112
- Gunnison 111
- Pitkin 110
- Adams 109
- Clear Creek 108
- Pueblo 108
- Routt 108
- Summit 108
- Weld 108
- Boulder 107
- Mesa 107
- Garfield 106
- Yuma 103
- Crowley 102
- Grand 102
- Morgan 102
- Broomfield 101
- Park 101
- San Miguel 101
- Chaffee 100
- Elbert 100
- Hinsdale 100
- Montrose 100
- La Plata 98
- …
state 1
- Colorado · 5,871 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281026 | 281026 | 2020-06-28 | Adams | Colorado | 8001 | 4148 | 154 |
281027 | 281027 | 2020-06-28 | Alamosa | Colorado | 8003 | 187 | 3 |
281028 | 281028 | 2020-06-28 | Arapahoe | Colorado | 8005 | 5157 | 342 |
281029 | 281029 | 2020-06-28 | Archuleta | Colorado | 8007 | 8 | 0 |
281030 | 281030 | 2020-06-28 | Baca | Colorado | 8009 | 13 | 0 |
281031 | 281031 | 2020-06-28 | Bent | Colorado | 8011 | 4 | 0 |
281032 | 281032 | 2020-06-28 | Boulder | Colorado | 8013 | 1360 | 71 |
281033 | 281033 | 2020-06-28 | Broomfield | Colorado | 8014 | 295 | 29 |
281034 | 281034 | 2020-06-28 | Chaffee | Colorado | 8015 | 78 | 19 |
281035 | 281035 | 2020-06-28 | Cheyenne | Colorado | 8017 | 5 | 0 |
281036 | 281036 | 2020-06-28 | Clear Creek | Colorado | 8019 | 18 | 1 |
281037 | 281037 | 2020-06-28 | Conejos | Colorado | 8021 | 13 | 0 |
281038 | 281038 | 2020-06-28 | Costilla | Colorado | 8023 | 20 | 0 |
281039 | 281039 | 2020-06-28 | Crowley | Colorado | 8025 | 70 | 1 |
281040 | 281040 | 2020-06-28 | Custer | Colorado | 8027 | 2 | 0 |
281041 | 281041 | 2020-06-28 | Delta | Colorado | 8029 | 82 | 1 |
281042 | 281042 | 2020-06-28 | Denver | Colorado | 8031 | 7007 | 375 |
281043 | 281043 | 2020-06-28 | Douglas | Colorado | 8035 | 939 | 52 |
281044 | 281044 | 2020-06-28 | Eagle | Colorado | 8037 | 686 | 8 |
281045 | 281045 | 2020-06-28 | El Paso | Colorado | 8041 | 2327 | 119 |
281046 | 281046 | 2020-06-28 | Elbert | Colorado | 8039 | 57 | 2 |
281047 | 281047 | 2020-06-28 | Fremont | Colorado | 8043 | 36 | 0 |
281048 | 281048 | 2020-06-28 | Garfield | Colorado | 8045 | 273 | 2 |
281049 | 281049 | 2020-06-28 | Gilpin | Colorado | 8047 | 7 | 0 |
281050 | 281050 | 2020-06-28 | Grand | Colorado | 8049 | 19 | 0 |
281051 | 281051 | 2020-06-28 | Gunnison | Colorado | 8051 | 186 | 6 |
281052 | 281052 | 2020-06-28 | Hinsdale | Colorado | 8053 | 3 | 0 |
281053 | 281053 | 2020-06-28 | Huerfano | Colorado | 8055 | 4 | 0 |
281054 | 281054 | 2020-06-28 | Jackson | Colorado | 8057 | 1 | 0 |
281055 | 281055 | 2020-06-28 | Jefferson | Colorado | 8059 | 2656 | 208 |
281056 | 281056 | 2020-06-28 | Kit Carson | Colorado | 8063 | 31 | 3 |
281057 | 281057 | 2020-06-28 | La Plata | Colorado | 8067 | 101 | 1 |
281058 | 281058 | 2020-06-28 | Lake | Colorado | 8065 | 51 | 0 |
281059 | 281059 | 2020-06-28 | Larimer | Colorado | 8069 | 718 | 29 |
281060 | 281060 | 2020-06-28 | Las Animas | Colorado | 8071 | 7 | 0 |
281061 | 281061 | 2020-06-28 | Lincoln | Colorado | 8073 | 4 | 0 |
281062 | 281062 | 2020-06-28 | Logan | Colorado | 8075 | 637 | 5 |
281063 | 281063 | 2020-06-28 | Mesa | Colorado | 8077 | 89 | 0 |
281064 | 281064 | 2020-06-28 | Mineral | Colorado | 8079 | 5 | 0 |
281065 | 281065 | 2020-06-28 | Moffat | Colorado | 8081 | 10 | 0 |
281066 | 281066 | 2020-06-28 | Montezuma | Colorado | 8083 | 70 | 3 |
281067 | 281067 | 2020-06-28 | Montrose | Colorado | 8085 | 204 | 12 |
281068 | 281068 | 2020-06-28 | Morgan | Colorado | 8087 | 652 | 46 |
281069 | 281069 | 2020-06-28 | Otero | Colorado | 8089 | 22 | 1 |
281070 | 281070 | 2020-06-28 | Ouray | Colorado | 8091 | 10 | 1 |
281071 | 281071 | 2020-06-28 | Park | Colorado | 8093 | 27 | 0 |
281072 | 281072 | 2020-06-28 | Phillips | Colorado | 8095 | 16 | 0 |
281073 | 281073 | 2020-06-28 | Pitkin | Colorado | 8097 | 93 | 2 |
281074 | 281074 | 2020-06-28 | Prowers | Colorado | 8099 | 19 | 0 |
281075 | 281075 | 2020-06-28 | Pueblo | Colorado | 8101 | 383 | 28 |
281076 | 281076 | 2020-06-28 | Rio Blanco | Colorado | 8103 | 3 | 0 |
281077 | 281077 | 2020-06-28 | Rio Grande | Colorado | 8105 | 73 | 2 |
281078 | 281078 | 2020-06-28 | Routt | Colorado | 8107 | 72 | 6 |
281079 | 281079 | 2020-06-28 | Saguache | Colorado | 8109 | 102 | 2 |
281080 | 281080 | 2020-06-28 | San Juan | Colorado | 8111 | 1 | 0 |
281081 | 281081 | 2020-06-28 | San Miguel | Colorado | 8113 | 36 | 0 |
281082 | 281082 | 2020-06-28 | Summit | Colorado | 8117 | 269 | 3 |
281083 | 281083 | 2020-06-28 | Teller | Colorado | 8119 | 41 | 2 |
281084 | 281084 | 2020-06-28 | Washington | Colorado | 8121 | 44 | 0 |
281085 | 281085 | 2020-06-28 | Weld | Colorado | 8123 | 2788 | 137 |
281086 | 281086 | 2020-06-28 | Yuma | Colorado | 8125 | 51 | 0 |
277879 | 277879 | 2020-06-27 | Adams | Colorado | 8001 | 4093 | 154 |
277880 | 277880 | 2020-06-27 | Alamosa | Colorado | 8003 | 184 | 3 |
277881 | 277881 | 2020-06-27 | Arapahoe | Colorado | 8005 | 5127 | 342 |
277882 | 277882 | 2020-06-27 | Archuleta | Colorado | 8007 | 8 | 0 |
277883 | 277883 | 2020-06-27 | Baca | Colorado | 8009 | 13 | 0 |
277884 | 277884 | 2020-06-27 | Bent | Colorado | 8011 | 4 | 0 |
277885 | 277885 | 2020-06-27 | Boulder | Colorado | 8013 | 1347 | 71 |
277886 | 277886 | 2020-06-27 | Broomfield | Colorado | 8014 | 291 | 29 |
277887 | 277887 | 2020-06-27 | Chaffee | Colorado | 8015 | 77 | 19 |
277888 | 277888 | 2020-06-27 | Cheyenne | Colorado | 8017 | 5 | 0 |
277889 | 277889 | 2020-06-27 | Clear Creek | Colorado | 8019 | 18 | 1 |
277890 | 277890 | 2020-06-27 | Conejos | Colorado | 8021 | 13 | 0 |
277891 | 277891 | 2020-06-27 | Costilla | Colorado | 8023 | 20 | 0 |
277892 | 277892 | 2020-06-27 | Crowley | Colorado | 8025 | 70 | 1 |
277893 | 277893 | 2020-06-27 | Custer | Colorado | 8027 | 2 | 0 |
277894 | 277894 | 2020-06-27 | Delta | Colorado | 8029 | 82 | 1 |
277895 | 277895 | 2020-06-27 | Denver | Colorado | 8031 | 6947 | 374 |
277896 | 277896 | 2020-06-27 | Douglas | Colorado | 8035 | 922 | 52 |
277897 | 277897 | 2020-06-27 | Eagle | Colorado | 8037 | 685 | 8 |
277898 | 277898 | 2020-06-27 | El Paso | Colorado | 8041 | 2296 | 119 |
277899 | 277899 | 2020-06-27 | Elbert | Colorado | 8039 | 56 | 2 |
277900 | 277900 | 2020-06-27 | Fremont | Colorado | 8043 | 34 | 0 |
277901 | 277901 | 2020-06-27 | Garfield | Colorado | 8045 | 266 | 2 |
277902 | 277902 | 2020-06-27 | Gilpin | Colorado | 8047 | 7 | 0 |
277903 | 277903 | 2020-06-27 | Grand | Colorado | 8049 | 18 | 0 |
277904 | 277904 | 2020-06-27 | Gunnison | Colorado | 8051 | 186 | 6 |
277905 | 277905 | 2020-06-27 | Hinsdale | Colorado | 8053 | 3 | 0 |
277906 | 277906 | 2020-06-27 | Huerfano | Colorado | 8055 | 4 | 0 |
277907 | 277907 | 2020-06-27 | Jackson | Colorado | 8057 | 1 | 0 |
277908 | 277908 | 2020-06-27 | Jefferson | Colorado | 8059 | 2633 | 208 |
277909 | 277909 | 2020-06-27 | Kit Carson | Colorado | 8063 | 31 | 3 |
277910 | 277910 | 2020-06-27 | La Plata | Colorado | 8067 | 94 | 1 |
277911 | 277911 | 2020-06-27 | Lake | Colorado | 8065 | 50 | 0 |
277912 | 277912 | 2020-06-27 | Larimer | Colorado | 8069 | 713 | 29 |
277913 | 277913 | 2020-06-27 | Las Animas | Colorado | 8071 | 7 | 0 |
277914 | 277914 | 2020-06-27 | Lincoln | Colorado | 8073 | 4 | 0 |
277915 | 277915 | 2020-06-27 | Logan | Colorado | 8075 | 636 | 5 |
277916 | 277916 | 2020-06-27 | Mesa | Colorado | 8077 | 89 | 0 |
277917 | 277917 | 2020-06-27 | Mineral | Colorado | 8079 | 5 | 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);