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-01-30 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
979096 | 979096 | 2021-01-30 | Adams | Colorado | 8001 | 46268 | 603 |
979097 | 979097 | 2021-01-30 | Alamosa | Colorado | 8003 | 1148 | 28 |
979098 | 979098 | 2021-01-30 | Arapahoe | Colorado | 8005 | 45528 | 649 |
979099 | 979099 | 2021-01-30 | Archuleta | Colorado | 8007 | 602 | 1 |
979100 | 979100 | 2021-01-30 | Baca | Colorado | 8009 | 264 | 3 |
979101 | 979101 | 2021-01-30 | Bent | Colorado | 8011 | 1287 | 20 |
979102 | 979102 | 2021-01-30 | Boulder | Colorado | 8013 | 17279 | 232 |
979103 | 979103 | 2021-01-30 | Broomfield | Colorado | 8014 | 3391 | 69 |
979104 | 979104 | 2021-01-30 | Chaffee | Colorado | 8015 | 1299 | 23 |
979105 | 979105 | 2021-01-30 | Cheyenne | Colorado | 8017 | 117 | 5 |
979106 | 979106 | 2021-01-30 | Clear Creek | Colorado | 8019 | 343 | 2 |
979107 | 979107 | 2021-01-30 | Conejos | Colorado | 8021 | 403 | 4 |
979108 | 979108 | 2021-01-30 | Costilla | Colorado | 8023 | 179 | 2 |
979109 | 979109 | 2021-01-30 | Crowley | Colorado | 8025 | 1803 | 14 |
979110 | 979110 | 2021-01-30 | Custer | Colorado | 8027 | 160 | 1 |
979111 | 979111 | 2021-01-30 | Delta | Colorado | 8029 | 2310 | 50 |
979112 | 979112 | 2021-01-30 | Denver | Colorado | 8031 | 55640 | 743 |
979113 | 979113 | 2021-01-30 | Dolores | Colorado | 8033 | 62 | 0 |
979114 | 979114 | 2021-01-30 | Douglas | Colorado | 8035 | 19212 | 227 |
979115 | 979115 | 2021-01-30 | Eagle | Colorado | 8037 | 4342 | 17 |
979116 | 979116 | 2021-01-30 | El Paso | Colorado | 8041 | 47732 | 696 |
979117 | 979117 | 2021-01-30 | Elbert | Colorado | 8039 | 1141 | 12 |
979118 | 979118 | 2021-01-30 | Fremont | Colorado | 8043 | 5133 | 36 |
979119 | 979119 | 2021-01-30 | Garfield | Colorado | 8045 | 4783 | 38 |
979120 | 979120 | 2021-01-30 | Gilpin | Colorado | 8047 | 148 | 2 |
979121 | 979121 | 2021-01-30 | Grand | Colorado | 8049 | 930 | 5 |
979122 | 979122 | 2021-01-30 | Gunnison | Colorado | 8051 | 1042 | 6 |
979123 | 979123 | 2021-01-30 | Hinsdale | Colorado | 8053 | 16 | 0 |
979124 | 979124 | 2021-01-30 | Huerfano | Colorado | 8055 | 292 | 17 |
979125 | 979125 | 2021-01-30 | Jackson | Colorado | 8057 | 45 | 0 |
979126 | 979126 | 2021-01-30 | Jefferson | Colorado | 8059 | 34364 | 683 |
979127 | 979127 | 2021-01-30 | Kiowa | Colorado | 8061 | 88 | 3 |
979128 | 979128 | 2021-01-30 | Kit Carson | Colorado | 8063 | 502 | 10 |
979129 | 979129 | 2021-01-30 | La Plata | Colorado | 8067 | 2693 | 34 |
979130 | 979130 | 2021-01-30 | Lake | Colorado | 8065 | 514 | 0 |
979131 | 979131 | 2021-01-30 | Larimer | Colorado | 8069 | 17914 | 192 |
979132 | 979132 | 2021-01-30 | Las Animas | Colorado | 8071 | 911 | 11 |
979133 | 979133 | 2021-01-30 | Lincoln | Colorado | 8073 | 888 | 3 |
979134 | 979134 | 2021-01-30 | Logan | Colorado | 8075 | 3615 | 59 |
979135 | 979135 | 2021-01-30 | Mesa | Colorado | 8077 | 11950 | 169 |
979136 | 979136 | 2021-01-30 | Mineral | Colorado | 8079 | 59 | 1 |
979137 | 979137 | 2021-01-30 | Moffat | Colorado | 8081 | 617 | 22 |
979138 | 979138 | 2021-01-30 | Montezuma | Colorado | 8083 | 1619 | 21 |
979139 | 979139 | 2021-01-30 | Montrose | Colorado | 8085 | 2976 | 45 |
979140 | 979140 | 2021-01-30 | Morgan | Colorado | 8087 | 2354 | 88 |
979141 | 979141 | 2021-01-30 | Otero | Colorado | 8089 | 1787 | 59 |
979142 | 979142 | 2021-01-30 | Ouray | Colorado | 8091 | 204 | 3 |
979143 | 979143 | 2021-01-30 | Park | Colorado | 8093 | 484 | 5 |
979144 | 979144 | 2021-01-30 | Phillips | Colorado | 8095 | 325 | 11 |
979145 | 979145 | 2021-01-30 | Pitkin | Colorado | 8097 | 1818 | 4 |
979146 | 979146 | 2021-01-30 | Prowers | Colorado | 8099 | 1116 | 21 |
979147 | 979147 | 2021-01-30 | Pueblo | Colorado | 8101 | 14302 | 356 |
979148 | 979148 | 2021-01-30 | Rio Blanco | Colorado | 8103 | 395 | 3 |
979149 | 979149 | 2021-01-30 | Rio Grande | Colorado | 8105 | 621 | 10 |
979150 | 979150 | 2021-01-30 | Routt | Colorado | 8107 | 1582 | 19 |
979151 | 979151 | 2021-01-30 | Saguache | Colorado | 8109 | 293 | 4 |
979152 | 979152 | 2021-01-30 | San Juan | Colorado | 8111 | 43 | 0 |
979153 | 979153 | 2021-01-30 | San Miguel | Colorado | 8113 | 667 | 0 |
979154 | 979154 | 2021-01-30 | Sedgwick | Colorado | 8115 | 189 | 2 |
979155 | 979155 | 2021-01-30 | Summit | Colorado | 8117 | 2623 | 5 |
979156 | 979156 | 2021-01-30 | Teller | Colorado | 8119 | 1169 | 14 |
979157 | 979157 | 2021-01-30 | Washington | Colorado | 8121 | 365 | 12 |
979158 | 979158 | 2021-01-30 | Weld | Colorado | 8123 | 23516 | 306 |
979159 | 979159 | 2021-01-30 | Yuma | Colorado | 8125 | 658 | 16 |
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);