ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2020-12-24" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
859022 | 859022 | 2020-12-24 | Adams | Colorado | 8001 | 38517 | 499 |
859023 | 859023 | 2020-12-24 | Alamosa | Colorado | 8003 | 899 | 21 |
859024 | 859024 | 2020-12-24 | Arapahoe | Colorado | 8005 | 36722 | 565 |
859025 | 859025 | 2020-12-24 | Archuleta | Colorado | 8007 | 451 | 0 |
859026 | 859026 | 2020-12-24 | Baca | Colorado | 8009 | 166 | 1 |
859027 | 859027 | 2020-12-24 | Bent | Colorado | 8011 | 935 | 13 |
859028 | 859028 | 2020-12-24 | Boulder | Colorado | 8013 | 14110 | 174 |
859029 | 859029 | 2020-12-24 | Broomfield | Colorado | 8014 | 2687 | 63 |
859030 | 859030 | 2020-12-24 | Chaffee | Colorado | 8015 | 976 | 20 |
859031 | 859031 | 2020-12-24 | Cheyenne | Colorado | 8017 | 86 | 3 |
859032 | 859032 | 2020-12-24 | Clear Creek | Colorado | 8019 | 262 | 2 |
859033 | 859033 | 2020-12-24 | Conejos | Colorado | 8021 | 298 | 3 |
859034 | 859034 | 2020-12-24 | Costilla | Colorado | 8023 | 155 | 2 |
859035 | 859035 | 2020-12-24 | Crowley | Colorado | 8025 | 1604 | 12 |
859036 | 859036 | 2020-12-24 | Custer | Colorado | 8027 | 146 | 0 |
859037 | 859037 | 2020-12-24 | Delta | Colorado | 8029 | 1426 | 21 |
859038 | 859038 | 2020-12-24 | Denver | Colorado | 8031 | 45920 | 654 |
859039 | 859039 | 2020-12-24 | Dolores | Colorado | 8033 | 49 | 0 |
859040 | 859040 | 2020-12-24 | Douglas | Colorado | 8035 | 15196 | 181 |
859041 | 859041 | 2020-12-24 | Eagle | Colorado | 8037 | 3167 | 14 |
859042 | 859042 | 2020-12-24 | El Paso | Colorado | 8041 | 39542 | 526 |
859043 | 859043 | 2020-12-24 | Elbert | Colorado | 8039 | 942 | 8 |
859044 | 859044 | 2020-12-24 | Fremont | Colorado | 8043 | 4403 | 15 |
859045 | 859045 | 2020-12-24 | Garfield | Colorado | 8045 | 3635 | 25 |
859046 | 859046 | 2020-12-24 | Gilpin | Colorado | 8047 | 118 | 1 |
859047 | 859047 | 2020-12-24 | Grand | Colorado | 8049 | 613 | 4 |
859048 | 859048 | 2020-12-24 | Gunnison | Colorado | 8051 | 652 | 5 |
859049 | 859049 | 2020-12-24 | Hinsdale | Colorado | 8053 | 12 | 0 |
859050 | 859050 | 2020-12-24 | Huerfano | Colorado | 8055 | 269 | 17 |
859051 | 859051 | 2020-12-24 | Jackson | Colorado | 8057 | 31 | 0 |
859052 | 859052 | 2020-12-24 | Jefferson | Colorado | 8059 | 28357 | 591 |
859053 | 859053 | 2020-12-24 | Kiowa | Colorado | 8061 | 72 | 2 |
859054 | 859054 | 2020-12-24 | Kit Carson | Colorado | 8063 | 428 | 8 |
859055 | 859055 | 2020-12-24 | La Plata | Colorado | 8067 | 2134 | 27 |
859056 | 859056 | 2020-12-24 | Lake | Colorado | 8065 | 400 | 0 |
859057 | 859057 | 2020-12-24 | Larimer | Colorado | 8069 | 14468 | 125 |
859058 | 859058 | 2020-12-24 | Las Animas | Colorado | 8071 | 461 | 3 |
859059 | 859059 | 2020-12-24 | Lincoln | Colorado | 8073 | 770 | 3 |
859060 | 859060 | 2020-12-24 | Logan | Colorado | 8075 | 3175 | 53 |
859061 | 859061 | 2020-12-24 | Mesa | Colorado | 8077 | 8618 | 127 |
859062 | 859062 | 2020-12-24 | Mineral | Colorado | 8079 | 41 | 1 |
859063 | 859063 | 2020-12-24 | Moffat | Colorado | 8081 | 521 | 19 |
859064 | 859064 | 2020-12-24 | Montezuma | Colorado | 8083 | 1158 | 14 |
859065 | 859065 | 2020-12-24 | Montrose | Colorado | 8085 | 1932 | 29 |
859066 | 859066 | 2020-12-24 | Morgan | Colorado | 8087 | 2067 | 72 |
859067 | 859067 | 2020-12-24 | Otero | Colorado | 8089 | 1551 | 33 |
859068 | 859068 | 2020-12-24 | Ouray | Colorado | 8091 | 148 | 3 |
859069 | 859069 | 2020-12-24 | Park | Colorado | 8093 | 363 | 4 |
859070 | 859070 | 2020-12-24 | Phillips | Colorado | 8095 | 238 | 6 |
859071 | 859071 | 2020-12-24 | Pitkin | Colorado | 8097 | 906 | 3 |
859072 | 859072 | 2020-12-24 | Prowers | Colorado | 8099 | 958 | 20 |
859073 | 859073 | 2020-12-24 | Pueblo | Colorado | 8101 | 12744 | 286 |
859074 | 859074 | 2020-12-24 | Rio Blanco | Colorado | 8103 | 260 | 2 |
859075 | 859075 | 2020-12-24 | Rio Grande | Colorado | 8105 | 370 | 5 |
859076 | 859076 | 2020-12-24 | Routt | Colorado | 8107 | 988 | 18 |
859077 | 859077 | 2020-12-24 | Saguache | Colorado | 8109 | 250 | 4 |
859078 | 859078 | 2020-12-24 | San Juan | Colorado | 8111 | 29 | 0 |
859079 | 859079 | 2020-12-24 | San Miguel | Colorado | 8113 | 383 | 0 |
859080 | 859080 | 2020-12-24 | Sedgwick | Colorado | 8115 | 124 | 2 |
859081 | 859081 | 2020-12-24 | Summit | Colorado | 8117 | 2039 | 5 |
859082 | 859082 | 2020-12-24 | Teller | Colorado | 8119 | 937 | 7 |
859083 | 859083 | 2020-12-24 | Washington | Colorado | 8121 | 339 | 10 |
859084 | 859084 | 2020-12-24 | Weld | Colorado | 8123 | 18985 | 271 |
859085 | 859085 | 2020-12-24 | Yuma | Colorado | 8125 | 511 | 8 |
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);