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 2020-12-16 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
833060 | 833060 | 2020-12-16 | Adams | Colorado | 8001 | 36306 | 443 |
833061 | 833061 | 2020-12-16 | Alamosa | Colorado | 8003 | 833 | 21 |
833062 | 833062 | 2020-12-16 | Arapahoe | Colorado | 8005 | 34302 | 528 |
833063 | 833063 | 2020-12-16 | Archuleta | Colorado | 8007 | 422 | 0 |
833064 | 833064 | 2020-12-16 | Baca | Colorado | 8009 | 159 | 0 |
833065 | 833065 | 2020-12-16 | Bent | Colorado | 8011 | 701 | 4 |
833066 | 833066 | 2020-12-16 | Boulder | Colorado | 8013 | 13378 | 160 |
833067 | 833067 | 2020-12-16 | Broomfield | Colorado | 8014 | 2511 | 61 |
833068 | 833068 | 2020-12-16 | Chaffee | Colorado | 8015 | 852 | 22 |
833069 | 833069 | 2020-12-16 | Cheyenne | Colorado | 8017 | 85 | 3 |
833070 | 833070 | 2020-12-16 | Clear Creek | Colorado | 8019 | 235 | 2 |
833071 | 833071 | 2020-12-16 | Conejos | Colorado | 8021 | 268 | 4 |
833072 | 833072 | 2020-12-16 | Costilla | Colorado | 8023 | 146 | 2 |
833073 | 833073 | 2020-12-16 | Crowley | Colorado | 8025 | 1466 | 10 |
833074 | 833074 | 2020-12-16 | Custer | Colorado | 8027 | 133 | 0 |
833075 | 833075 | 2020-12-16 | Delta | Colorado | 8029 | 1179 | 18 |
833076 | 833076 | 2020-12-16 | Denver | Colorado | 8031 | 43591 | 635 |
833077 | 833077 | 2020-12-16 | Dolores | Colorado | 8033 | 45 | 0 |
833078 | 833078 | 2020-12-16 | Douglas | Colorado | 8035 | 14168 | 150 |
833079 | 833079 | 2020-12-16 | Eagle | Colorado | 8037 | 2961 | 12 |
833080 | 833080 | 2020-12-16 | El Paso | Colorado | 8041 | 36606 | 459 |
833081 | 833081 | 2020-12-16 | Elbert | Colorado | 8039 | 841 | 5 |
833082 | 833082 | 2020-12-16 | Fremont | Colorado | 8043 | 3864 | 12 |
833083 | 833083 | 2020-12-16 | Garfield | Colorado | 8045 | 3197 | 24 |
833084 | 833084 | 2020-12-16 | Gilpin | Colorado | 8047 | 105 | 1 |
833085 | 833085 | 2020-12-16 | Grand | Colorado | 8049 | 560 | 5 |
833086 | 833086 | 2020-12-16 | Gunnison | Colorado | 8051 | 561 | 7 |
833087 | 833087 | 2020-12-16 | Hinsdale | Colorado | 8053 | 12 | 0 |
833088 | 833088 | 2020-12-16 | Huerfano | Colorado | 8055 | 244 | 12 |
833089 | 833089 | 2020-12-16 | Jackson | Colorado | 8057 | 29 | 0 |
833090 | 833090 | 2020-12-16 | Jefferson | Colorado | 8059 | 26471 | 585 |
833091 | 833091 | 2020-12-16 | Kiowa | Colorado | 8061 | 56 | 1 |
833092 | 833092 | 2020-12-16 | Kit Carson | Colorado | 8063 | 402 | 8 |
833093 | 833093 | 2020-12-16 | La Plata | Colorado | 8067 | 1920 | 15 |
833094 | 833094 | 2020-12-16 | Lake | Colorado | 8065 | 378 | 0 |
833095 | 833095 | 2020-12-16 | Larimer | Colorado | 8069 | 13465 | 101 |
833096 | 833096 | 2020-12-16 | Las Animas | Colorado | 8071 | 389 | 3 |
833097 | 833097 | 2020-12-16 | Lincoln | Colorado | 8073 | 701 | 1 |
833098 | 833098 | 2020-12-16 | Logan | Colorado | 8075 | 2884 | 49 |
833099 | 833099 | 2020-12-16 | Mesa | Colorado | 8077 | 7759 | 110 |
833100 | 833100 | 2020-12-16 | Mineral | Colorado | 8079 | 38 | 1 |
833101 | 833101 | 2020-12-16 | Moffat | Colorado | 8081 | 466 | 18 |
833102 | 833102 | 2020-12-16 | Montezuma | Colorado | 8083 | 1034 | 11 |
833103 | 833103 | 2020-12-16 | Montrose | Colorado | 8085 | 1712 | 25 |
833104 | 833104 | 2020-12-16 | Morgan | Colorado | 8087 | 1937 | 64 |
833105 | 833105 | 2020-12-16 | Otero | Colorado | 8089 | 1390 | 19 |
833106 | 833106 | 2020-12-16 | Ouray | Colorado | 8091 | 138 | 3 |
833107 | 833107 | 2020-12-16 | Park | Colorado | 8093 | 320 | 4 |
833108 | 833108 | 2020-12-16 | Phillips | Colorado | 8095 | 214 | 4 |
833109 | 833109 | 2020-12-16 | Pitkin | Colorado | 8097 | 726 | 2 |
833110 | 833110 | 2020-12-16 | Prowers | Colorado | 8099 | 893 | 19 |
833111 | 833111 | 2020-12-16 | Pueblo | Colorado | 8101 | 11869 | 241 |
833112 | 833112 | 2020-12-16 | Rio Blanco | Colorado | 8103 | 237 | 2 |
833113 | 833113 | 2020-12-16 | Rio Grande | Colorado | 8105 | 301 | 5 |
833114 | 833114 | 2020-12-16 | Routt | Colorado | 8107 | 928 | 16 |
833115 | 833115 | 2020-12-16 | Saguache | Colorado | 8109 | 240 | 4 |
833116 | 833116 | 2020-12-16 | San Juan | Colorado | 8111 | 25 | 0 |
833117 | 833117 | 2020-12-16 | San Miguel | Colorado | 8113 | 302 | 0 |
833118 | 833118 | 2020-12-16 | Sedgwick | Colorado | 8115 | 118 | 2 |
833119 | 833119 | 2020-12-16 | Summit | Colorado | 8117 | 1882 | 5 |
833120 | 833120 | 2020-12-16 | Teller | Colorado | 8119 | 881 | 7 |
833121 | 833121 | 2020-12-16 | Washington | Colorado | 8121 | 302 | 10 |
833122 | 833122 | 2020-12-16 | Weld | Colorado | 8123 | 17890 | 253 |
833123 | 833123 | 2020-12-16 | Yuma | Colorado | 8125 | 464 | 4 |
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);