ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635140 | 635140 | 2020-10-16 | Conejos | Colorado | 8021 | 48 | 0 |
635141 | 635141 | 2020-10-16 | Costilla | Colorado | 8023 | 34 | 1 |
635142 | 635142 | 2020-10-16 | Crowley | Colorado | 8025 | 80 | 1 |
635143 | 635143 | 2020-10-16 | Custer | Colorado | 8027 | 19 | 0 |
635144 | 635144 | 2020-10-16 | Delta | Colorado | 8029 | 195 | 4 |
635145 | 635145 | 2020-10-16 | Denver | Colorado | 8031 | 15645 | 449 |
635146 | 635146 | 2020-10-16 | Dolores | Colorado | 8033 | 3 | 0 |
635147 | 635147 | 2020-10-16 | Douglas | Colorado | 8035 | 3335 | 63 |
635148 | 635148 | 2020-10-16 | Eagle | Colorado | 8037 | 1338 | 10 |
635149 | 635149 | 2020-10-16 | El Paso | Colorado | 8041 | 8352 | 188 |
635150 | 635150 | 2020-10-16 | Elbert | Colorado | 8039 | 179 | 3 |
635151 | 635151 | 2020-10-16 | Fremont | Colorado | 8043 | 453 | 1 |
635152 | 635152 | 2020-10-16 | Garfield | Colorado | 8045 | 1053 | 5 |
635153 | 635153 | 2020-10-16 | Gilpin | Colorado | 8047 | 21 | 0 |
635154 | 635154 | 2020-10-16 | Grand | Colorado | 8049 | 127 | 1 |
635155 | 635155 | 2020-10-16 | Gunnison | Colorado | 8051 | 296 | 7 |
635156 | 635156 | 2020-10-16 | Hinsdale | Colorado | 8053 | 3 | 0 |
635157 | 635157 | 2020-10-16 | Huerfano | Colorado | 8055 | 28 | 2 |
635158 | 635158 | 2020-10-16 | Jackson | Colorado | 8057 | 9 | 0 |
635159 | 635159 | 2020-10-16 | Jefferson | Colorado | 8059 | 6991 | 298 |
635160 | 635160 | 2020-10-16 | Kiowa | Colorado | 8061 | 2 | 0 |
635161 | 635161 | 2020-10-16 | Kit Carson | Colorado | 8063 | 98 | 3 |
635162 | 635162 | 2020-10-16 | La Plata | Colorado | 8067 | 318 | 2 |
635163 | 635163 | 2020-10-16 | Lake | Colorado | 8065 | 116 | 0 |
635164 | 635164 | 2020-10-16 | Larimer | Colorado | 8069 | 3390 | 55 |
635165 | 635165 | 2020-10-16 | Las Animas | Colorado | 8071 | 33 | 1 |
635166 | 635166 | 2020-10-16 | Lincoln | Colorado | 8073 | 24 | 0 |
635167 | 635167 | 2020-10-16 | Logan | Colorado | 8075 | 1051 | 10 |
635168 | 635168 | 2020-10-16 | Mesa | Colorado | 8077 | 956 | 8 |
635169 | 635169 | 2020-10-16 | Mineral | Colorado | 8079 | 21 | 0 |
635170 | 635170 | 2020-10-16 | Moffat | Colorado | 8081 | 49 | 1 |
635171 | 635171 | 2020-10-16 | Montezuma | Colorado | 8083 | 173 | 5 |
635172 | 635172 | 2020-10-16 | Montrose | Colorado | 8085 | 412 | 13 |
635173 | 635173 | 2020-10-16 | Morgan | Colorado | 8087 | 804 | 48 |
635174 | 635174 | 2020-10-16 | Otero | Colorado | 8089 | 114 | 6 |
635175 | 635175 | 2020-10-16 | Ouray | Colorado | 8091 | 32 | 1 |
635176 | 635176 | 2020-10-16 | Park | Colorado | 8093 | 69 | 1 |
635177 | 635177 | 2020-10-16 | Phillips | Colorado | 8095 | 36 | 0 |
635178 | 635178 | 2020-10-16 | Pitkin | Colorado | 8097 | 255 | 2 |
635179 | 635179 | 2020-10-16 | Prowers | Colorado | 8099 | 104 | 0 |
635180 | 635180 | 2020-10-16 | Pueblo | Colorado | 8101 | 1514 | 40 |
635181 | 635181 | 2020-10-16 | Rio Blanco | Colorado | 8103 | 25 | 0 |
635182 | 635182 | 2020-10-16 | Rio Grande | Colorado | 8105 | 112 | 2 |
635183 | 635183 | 2020-10-16 | Routt | Colorado | 8107 | 180 | 8 |
635184 | 635184 | 2020-10-16 | Saguache | Colorado | 8109 | 118 | 2 |
635185 | 635185 | 2020-10-16 | San Juan | Colorado | 8111 | 6 | 0 |
635186 | 635186 | 2020-10-16 | San Miguel | Colorado | 8113 | 99 | 0 |
635187 | 635187 | 2020-10-16 | Sedgwick | Colorado | 8115 | 16 | 1 |
635188 | 635188 | 2020-10-16 | Summit | Colorado | 8117 | 540 | 4 |
635189 | 635189 | 2020-10-16 | Teller | Colorado | 8119 | 187 | 4 |
635190 | 635190 | 2020-10-16 | Washington | Colorado | 8121 | 78 | 0 |
635191 | 635191 | 2020-10-16 | Weld | Colorado | 8123 | 5307 | 155 |
635192 | 635192 | 2020-10-16 | Yuma | Colorado | 8125 | 176 | 1 |
635193 | 635193 | 2020-10-16 | Fairfield | Connecticut | 9001 | 21368 | 1427 |
635194 | 635194 | 2020-10-16 | Hartford | Connecticut | 9003 | 16273 | 1445 |
635195 | 635195 | 2020-10-16 | Litchfield | Connecticut | 9005 | 1991 | 143 |
635196 | 635196 | 2020-10-16 | Middlesex | Connecticut | 9007 | 1754 | 194 |
635197 | 635197 | 2020-10-16 | New Haven | Connecticut | 9009 | 15455 | 1119 |
635198 | 635198 | 2020-10-16 | New London | Connecticut | 9011 | 3083 | 130 |
635199 | 635199 | 2020-10-16 | Tolland | Connecticut | 9013 | 1565 | 67 |
635200 | 635200 | 2020-10-16 | Unknown | Connecticut | 125 | 0 | |
635201 | 635201 | 2020-10-16 | Windham | Connecticut | 9015 | 1216 | 17 |
635202 | 635202 | 2020-10-16 | Kent | Delaware | 10001 | 3285 | 119 |
635203 | 635203 | 2020-10-16 | New Castle | Delaware | 10003 | 11958 | 330 |
635204 | 635204 | 2020-10-16 | Sussex | Delaware | 10005 | 7390 | 213 |
635205 | 635205 | 2020-10-16 | Unknown | Delaware | 91 | 0 | |
635206 | 635206 | 2020-10-16 | District of Columbia | District of Columbia | 11001 | 16255 | 641 |
635207 | 635207 | 2020-10-16 | Alachua | Florida | 12001 | 9307 | 70 |
635208 | 635208 | 2020-10-16 | Baker | Florida | 12003 | 1672 | 17 |
635209 | 635209 | 2020-10-16 | Bay | Florida | 12005 | 6408 | 125 |
635210 | 635210 | 2020-10-16 | Bradford | Florida | 12007 | 1197 | 11 |
635211 | 635211 | 2020-10-16 | Brevard | Florida | 12009 | 10268 | 342 |
635212 | 635212 | 2020-10-16 | Broward | Florida | 12011 | 80443 | 1500 |
635213 | 635213 | 2020-10-16 | Calhoun | Florida | 12013 | 663 | 14 |
635214 | 635214 | 2020-10-16 | Charlotte | Florida | 12015 | 3332 | 152 |
635215 | 635215 | 2020-10-16 | Citrus | Florida | 12017 | 3000 | 125 |
635216 | 635216 | 2020-10-16 | Clay | Florida | 12019 | 5627 | 114 |
635217 | 635217 | 2020-10-16 | Collier | Florida | 12021 | 13492 | 243 |
635218 | 635218 | 2020-10-16 | Columbia | Florida | 12023 | 4083 | 70 |
635219 | 635219 | 2020-10-16 | DeSoto | Florida | 12027 | 1612 | 27 |
635220 | 635220 | 2020-10-16 | Dixie | Florida | 12029 | 863 | 11 |
635221 | 635221 | 2020-10-16 | Duval | Florida | 12031 | 32625 | 505 |
635222 | 635222 | 2020-10-16 | Escambia | Florida | 12033 | 12883 | 268 |
635223 | 635223 | 2020-10-16 | Flagler | Florida | 12035 | 1927 | 35 |
635224 | 635224 | 2020-10-16 | Franklin | Florida | 12037 | 687 | 4 |
635225 | 635225 | 2020-10-16 | Gadsden | Florida | 12039 | 3014 | 51 |
635226 | 635226 | 2020-10-16 | Gilchrist | Florida | 12041 | 540 | 17 |
635227 | 635227 | 2020-10-16 | Glades | Florida | 12043 | 587 | 6 |
635228 | 635228 | 2020-10-16 | Gulf | Florida | 12045 | 920 | 15 |
635229 | 635229 | 2020-10-16 | Hamilton | Florida | 12047 | 888 | 9 |
635230 | 635230 | 2020-10-16 | Hardee | Florida | 12049 | 1519 | 11 |
635231 | 635231 | 2020-10-16 | Hendry | Florida | 12051 | 2143 | 43 |
635232 | 635232 | 2020-10-16 | Hernando | Florida | 12053 | 3385 | 153 |
635233 | 635233 | 2020-10-16 | Highlands | Florida | 12055 | 2416 | 101 |
635234 | 635234 | 2020-10-16 | Hillsborough | Florida | 12057 | 44999 | 738 |
635235 | 635235 | 2020-10-16 | Holmes | Florida | 12059 | 818 | 10 |
635236 | 635236 | 2020-10-16 | Indian River | Florida | 12061 | 3495 | 122 |
635237 | 635237 | 2020-10-16 | Jackson | Florida | 12063 | 3018 | 83 |
635238 | 635238 | 2020-10-16 | Jefferson | Florida | 12065 | 611 | 9 |
635239 | 635239 | 2020-10-16 | Lafayette | Florida | 12067 | 1258 | 15 |
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);