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-04-09 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1203098 | 1203098 | 2021-04-09 | Adams | Colorado | 8001 | 53538 | 644 |
1203099 | 1203099 | 2021-04-09 | Alamosa | Colorado | 8003 | 1380 | 29 |
1203100 | 1203100 | 2021-04-09 | Arapahoe | Colorado | 8005 | 54453 | 717 |
1203101 | 1203101 | 2021-04-09 | Archuleta | Colorado | 8007 | 784 | 1 |
1203102 | 1203102 | 2021-04-09 | Baca | Colorado | 8009 | 278 | 4 |
1203103 | 1203103 | 2021-04-09 | Bent | Colorado | 8011 | 1485 | 21 |
1203104 | 1203104 | 2021-04-09 | Boulder | Colorado | 8013 | 21495 | 250 |
1203105 | 1203105 | 2021-04-09 | Broomfield | Colorado | 8014 | 4328 | 74 |
1203106 | 1203106 | 2021-04-09 | Chaffee | Colorado | 8015 | 1532 | 24 |
1203107 | 1203107 | 2021-04-09 | Cheyenne | Colorado | 8017 | 126 | 6 |
1203108 | 1203108 | 2021-04-09 | Clear Creek | Colorado | 8019 | 417 | 3 |
1203109 | 1203109 | 2021-04-09 | Conejos | Colorado | 8021 | 467 | 10 |
1203110 | 1203110 | 2021-04-09 | Costilla | Colorado | 8023 | 205 | 2 |
1203111 | 1203111 | 2021-04-09 | Crowley | Colorado | 8025 | 2148 | 14 |
1203112 | 1203112 | 2021-04-09 | Custer | Colorado | 8027 | 176 | 1 |
1203113 | 1203113 | 2021-04-09 | Delta | Colorado | 8029 | 2593 | 61 |
1203114 | 1203114 | 2021-04-09 | Denver | Colorado | 8031 | 66166 | 793 |
1203115 | 1203115 | 2021-04-09 | Dolores | Colorado | 8033 | 67 | 0 |
1203116 | 1203116 | 2021-04-09 | Douglas | Colorado | 8035 | 25418 | 235 |
1203117 | 1203117 | 2021-04-09 | Eagle | Colorado | 8037 | 5910 | 22 |
1203118 | 1203118 | 2021-04-09 | El Paso | Colorado | 8041 | 58702 | 763 |
1203119 | 1203119 | 2021-04-09 | Elbert | Colorado | 8039 | 1478 | 12 |
1203120 | 1203120 | 2021-04-09 | Fremont | Colorado | 8043 | 5708 | 53 |
1203121 | 1203121 | 2021-04-09 | Garfield | Colorado | 8045 | 5561 | 38 |
1203122 | 1203122 | 2021-04-09 | Gilpin | Colorado | 8047 | 201 | 3 |
1203123 | 1203123 | 2021-04-09 | Grand | Colorado | 8049 | 1370 | 6 |
1203124 | 1203124 | 2021-04-09 | Gunnison | Colorado | 8051 | 1272 | 6 |
1203125 | 1203125 | 2021-04-09 | Hinsdale | Colorado | 8053 | 17 | 0 |
1203126 | 1203126 | 2021-04-09 | Huerfano | Colorado | 8055 | 338 | 16 |
1203127 | 1203127 | 2021-04-09 | Jackson | Colorado | 8057 | 53 | 0 |
1203128 | 1203128 | 2021-04-09 | Jefferson | Colorado | 8059 | 41687 | 733 |
1203129 | 1203129 | 2021-04-09 | Kiowa | Colorado | 8061 | 93 | 3 |
1203130 | 1203130 | 2021-04-09 | Kit Carson | Colorado | 8063 | 592 | 11 |
1203131 | 1203131 | 2021-04-09 | La Plata | Colorado | 8067 | 3504 | 37 |
1203132 | 1203132 | 2021-04-09 | Lake | Colorado | 8065 | 714 | 0 |
1203133 | 1203133 | 2021-04-09 | Larimer | Colorado | 8069 | 23307 | 230 |
1203134 | 1203134 | 2021-04-09 | Las Animas | Colorado | 8071 | 1058 | 11 |
1203135 | 1203135 | 2021-04-09 | Lincoln | Colorado | 8073 | 1008 | 4 |
1203136 | 1203136 | 2021-04-09 | Logan | Colorado | 8075 | 3859 | 65 |
1203137 | 1203137 | 2021-04-09 | Mesa | Colorado | 8077 | 13818 | 209 |
1203138 | 1203138 | 2021-04-09 | Mineral | Colorado | 8079 | 86 | 1 |
1203139 | 1203139 | 2021-04-09 | Moffat | Colorado | 8081 | 715 | 22 |
1203140 | 1203140 | 2021-04-09 | Montezuma | Colorado | 8083 | 1835 | 23 |
1203141 | 1203141 | 2021-04-09 | Montrose | Colorado | 8085 | 3346 | 57 |
1203142 | 1203142 | 2021-04-09 | Morgan | Colorado | 8087 | 2553 | 93 |
1203143 | 1203143 | 2021-04-09 | Otero | Colorado | 8089 | 1897 | 63 |
1203144 | 1203144 | 2021-04-09 | Ouray | Colorado | 8091 | 277 | 3 |
1203145 | 1203145 | 2021-04-09 | Park | Colorado | 8093 | 633 | 5 |
1203146 | 1203146 | 2021-04-09 | Phillips | Colorado | 8095 | 353 | 13 |
1203147 | 1203147 | 2021-04-09 | Pitkin | Colorado | 8097 | 2525 | 4 |
1203148 | 1203148 | 2021-04-09 | Prowers | Colorado | 8099 | 1174 | 21 |
1203149 | 1203149 | 2021-04-09 | Pueblo | Colorado | 8101 | 16263 | 366 |
1203150 | 1203150 | 2021-04-09 | Rio Blanco | Colorado | 8103 | 541 | 4 |
1203151 | 1203151 | 2021-04-09 | Rio Grande | Colorado | 8105 | 765 | 14 |
1203152 | 1203152 | 2021-04-09 | Routt | Colorado | 8107 | 2127 | 20 |
1203153 | 1203153 | 2021-04-09 | Saguache | Colorado | 8109 | 340 | 4 |
1203154 | 1203154 | 2021-04-09 | San Juan | Colorado | 8111 | 46 | 0 |
1203155 | 1203155 | 2021-04-09 | San Miguel | Colorado | 8113 | 858 | 0 |
1203156 | 1203156 | 2021-04-09 | Sedgwick | Colorado | 8115 | 201 | 2 |
1203157 | 1203157 | 2021-04-09 | Summit | Colorado | 8117 | 3546 | 7 |
1203158 | 1203158 | 2021-04-09 | Teller | Colorado | 8119 | 1498 | 14 |
1203159 | 1203159 | 2021-04-09 | Washington | Colorado | 8121 | 437 | 12 |
1203160 | 1203160 | 2021-04-09 | Weld | Colorado | 8123 | 28365 | 327 |
1203161 | 1203161 | 2021-04-09 | Yuma | Colorado | 8125 | 848 | 17 |
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);