ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where "date" is on date 2021-11-05 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1885091 | 1885091 | 2021-11-05 | Adams | Colorado | 8001 | 79531 | 911 |
1885092 | 1885092 | 2021-11-05 | Alamosa | Colorado | 8003 | 2586 | 44 |
1885093 | 1885093 | 2021-11-05 | Arapahoe | Colorado | 8005 | 83712 | 950 |
1885094 | 1885094 | 2021-11-05 | Archuleta | Colorado | 8007 | 1577 | 4 |
1885095 | 1885095 | 2021-11-05 | Baca | Colorado | 8009 | 499 | 5 |
1885096 | 1885096 | 2021-11-05 | Bent | Colorado | 8011 | 1771 | 27 |
1885097 | 1885097 | 2021-11-05 | Boulder | Colorado | 8013 | 32123 | 287 |
1885098 | 1885098 | 2021-11-05 | Broomfield | Colorado | 8014 | 6928 | 83 |
1885099 | 1885099 | 2021-11-05 | Chaffee | Colorado | 8015 | 2393 | 31 |
1885100 | 1885100 | 2021-11-05 | Cheyenne | Colorado | 8017 | 189 | 7 |
1885101 | 1885101 | 2021-11-05 | Clear Creek | Colorado | 8019 | 804 | 5 |
1885102 | 1885102 | 2021-11-05 | Conejos | Colorado | 8021 | 1049 | 37 |
1885103 | 1885103 | 2021-11-05 | Costilla | Colorado | 8023 | 398 | 12 |
1885104 | 1885104 | 2021-11-05 | Crowley | Colorado | 8025 | 2407 | 24 |
1885105 | 1885105 | 2021-11-05 | Custer | Colorado | 8027 | 409 | 7 |
1885106 | 1885106 | 2021-11-05 | Delta | Colorado | 8029 | 4208 | 87 |
1885107 | 1885107 | 2021-11-05 | Denver | Colorado | 8031 | 94189 | 957 |
1885108 | 1885108 | 2021-11-05 | Dolores | Colorado | 8033 | 242 | 4 |
1885109 | 1885109 | 2021-11-05 | Douglas | Colorado | 8035 | 42600 | 328 |
1885110 | 1885110 | 2021-11-05 | Eagle | Colorado | 8037 | 8614 | 31 |
1885111 | 1885111 | 2021-11-05 | El Paso | Colorado | 8041 | 105341 | 1154 |
1885112 | 1885112 | 2021-11-05 | Elbert | Colorado | 8039 | 2814 | 23 |
1885113 | 1885113 | 2021-11-05 | Fremont | Colorado | 8043 | 8994 | 101 |
1885114 | 1885114 | 2021-11-05 | Garfield | Colorado | 8045 | 8184 | 65 |
1885115 | 1885115 | 2021-11-05 | Gilpin | Colorado | 8047 | 480 | 3 |
1885116 | 1885116 | 2021-11-05 | Grand | Colorado | 8049 | 2188 | 16 |
1885117 | 1885117 | 2021-11-05 | Gunnison | Colorado | 8051 | 1863 | 12 |
1885118 | 1885118 | 2021-11-05 | Hinsdale | Colorado | 8053 | 61 | 0 |
1885119 | 1885119 | 2021-11-05 | Huerfano | Colorado | 8055 | 711 | 19 |
1885120 | 1885120 | 2021-11-05 | Jackson | Colorado | 8057 | 115 | 0 |
1885121 | 1885121 | 2021-11-05 | Jefferson | Colorado | 8059 | 65802 | 933 |
1885122 | 1885122 | 2021-11-05 | Kiowa | Colorado | 8061 | 237 | 4 |
1885123 | 1885123 | 2021-11-05 | Kit Carson | Colorado | 8063 | 1014 | 20 |
1885124 | 1885124 | 2021-11-05 | La Plata | Colorado | 8067 | 6141 | 55 |
1885125 | 1885125 | 2021-11-05 | Lake | Colorado | 8065 | 1063 | 1 |
1885126 | 1885126 | 2021-11-05 | Larimer | Colorado | 8069 | 41147 | 319 |
1885127 | 1885127 | 2021-11-05 | Las Animas | Colorado | 8071 | 1922 | 24 |
1885128 | 1885128 | 2021-11-05 | Lincoln | Colorado | 8073 | 1332 | 8 |
1885129 | 1885129 | 2021-11-05 | Logan | Colorado | 8075 | 4831 | 87 |
1885130 | 1885130 | 2021-11-05 | Mesa | Colorado | 8077 | 25151 | 346 |
1885131 | 1885131 | 2021-11-05 | Mineral | Colorado | 8079 | 133 | 1 |
1885132 | 1885132 | 2021-11-05 | Moffat | Colorado | 8081 | 2020 | 44 |
1885133 | 1885133 | 2021-11-05 | Montezuma | Colorado | 8083 | 3477 | 37 |
1885134 | 1885134 | 2021-11-05 | Montrose | Colorado | 8085 | 5928 | 89 |
1885135 | 1885135 | 2021-11-05 | Morgan | Colorado | 8087 | 3586 | 99 |
1885136 | 1885136 | 2021-11-05 | Otero | Colorado | 8089 | 2790 | 84 |
1885137 | 1885137 | 2021-11-05 | Ouray | Colorado | 8091 | 476 | 5 |
1885138 | 1885138 | 2021-11-05 | Park | Colorado | 8093 | 1509 | 10 |
1885139 | 1885139 | 2021-11-05 | Phillips | Colorado | 8095 | 537 | 14 |
1885140 | 1885140 | 2021-11-05 | Pitkin | Colorado | 8097 | 3176 | 5 |
1885141 | 1885141 | 2021-11-05 | Prowers | Colorado | 8099 | 1760 | 32 |
1885142 | 1885142 | 2021-11-05 | Pueblo | Colorado | 8101 | 26736 | 512 |
1885143 | 1885143 | 2021-11-05 | Rio Blanco | Colorado | 8103 | 1088 | 9 |
1885144 | 1885144 | 2021-11-05 | Rio Grande | Colorado | 8105 | 1582 | 23 |
1885145 | 1885145 | 2021-11-05 | Routt | Colorado | 8107 | 3530 | 23 |
1885146 | 1885146 | 2021-11-05 | Saguache | Colorado | 8109 | 712 | 8 |
1885147 | 1885147 | 2021-11-05 | San Juan | Colorado | 8111 | 97 | 0 |
1885148 | 1885148 | 2021-11-05 | San Miguel | Colorado | 8113 | 1201 | 5 |
1885149 | 1885149 | 2021-11-05 | Sedgwick | Colorado | 8115 | 335 | 5 |
1885150 | 1885150 | 2021-11-05 | Summit | Colorado | 8117 | 4916 | 11 |
1885151 | 1885151 | 2021-11-05 | Teller | Colorado | 8119 | 3006 | 36 |
1885152 | 1885152 | 2021-11-05 | Washington | Colorado | 8121 | 700 | 20 |
1885153 | 1885153 | 2021-11-05 | Weld | Colorado | 8123 | 48612 | 473 |
1885154 | 1885154 | 2021-11-05 | Yuma | Colorado | 8125 | 1289 | 18 |
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);