ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where "date" is on date 2020-09-18 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
544376 | 544376 | 2020-09-18 | Adams | Colorado | 8001 | 8418 | 218 |
544377 | 544377 | 2020-09-18 | Alamosa | Colorado | 8003 | 241 | 9 |
544378 | 544378 | 2020-09-18 | Arapahoe | Colorado | 8005 | 8937 | 370 |
544379 | 544379 | 2020-09-18 | Archuleta | Colorado | 8007 | 48 | 0 |
544380 | 544380 | 2020-09-18 | Baca | Colorado | 8009 | 17 | 0 |
544381 | 544381 | 2020-09-18 | Bent | Colorado | 8011 | 11 | 0 |
544382 | 544382 | 2020-09-18 | Boulder | Colorado | 8013 | 3309 | 79 |
544383 | 544383 | 2020-09-18 | Broomfield | Colorado | 8014 | 588 | 33 |
544384 | 544384 | 2020-09-18 | Chaffee | Colorado | 8015 | 320 | 19 |
544385 | 544385 | 2020-09-18 | Cheyenne | Colorado | 8017 | 12 | 0 |
544386 | 544386 | 2020-09-18 | Clear Creek | Colorado | 8019 | 36 | 1 |
544387 | 544387 | 2020-09-18 | Conejos | Colorado | 8021 | 31 | 0 |
544388 | 544388 | 2020-09-18 | Costilla | Colorado | 8023 | 32 | 1 |
544389 | 544389 | 2020-09-18 | Crowley | Colorado | 8025 | 73 | 1 |
544390 | 544390 | 2020-09-18 | Custer | Colorado | 8027 | 17 | 0 |
544391 | 544391 | 2020-09-18 | Delta | Colorado | 8029 | 179 | 3 |
544392 | 544392 | 2020-09-18 | Denver | Colorado | 8031 | 12239 | 438 |
544393 | 544393 | 2020-09-18 | Dolores | Colorado | 8033 | 3 | 0 |
544394 | 544394 | 2020-09-18 | Douglas | Colorado | 8035 | 2453 | 60 |
544395 | 544395 | 2020-09-18 | Eagle | Colorado | 8037 | 1227 | 9 |
544396 | 544396 | 2020-09-18 | El Paso | Colorado | 8041 | 6639 | 168 |
544397 | 544397 | 2020-09-18 | Elbert | Colorado | 8039 | 144 | 3 |
544398 | 544398 | 2020-09-18 | Fremont | Colorado | 8043 | 167 | 1 |
544399 | 544399 | 2020-09-18 | Garfield | Colorado | 8045 | 916 | 5 |
544400 | 544400 | 2020-09-18 | Gilpin | Colorado | 8047 | 18 | 0 |
544401 | 544401 | 2020-09-18 | Grand | Colorado | 8049 | 71 | 1 |
544402 | 544402 | 2020-09-18 | Gunnison | Colorado | 8051 | 296 | 7 |
544403 | 544403 | 2020-09-18 | Hinsdale | Colorado | 8053 | 3 | 0 |
544404 | 544404 | 2020-09-18 | Huerfano | Colorado | 8055 | 13 | 1 |
544405 | 544405 | 2020-09-18 | Jackson | Colorado | 8057 | 9 | 0 |
544406 | 544406 | 2020-09-18 | Jefferson | Colorado | 8059 | 5267 | 247 |
544407 | 544407 | 2020-09-18 | Kit Carson | Colorado | 8063 | 78 | 3 |
544408 | 544408 | 2020-09-18 | La Plata | Colorado | 8067 | 247 | 2 |
544409 | 544409 | 2020-09-18 | Lake | Colorado | 8065 | 89 | 0 |
544410 | 544410 | 2020-09-18 | Larimer | Colorado | 8069 | 2308 | 49 |
544411 | 544411 | 2020-09-18 | Las Animas | Colorado | 8071 | 21 | 0 |
544412 | 544412 | 2020-09-18 | Lincoln | Colorado | 8073 | 9 | 0 |
544413 | 544413 | 2020-09-18 | Logan | Colorado | 8075 | 815 | 5 |
544414 | 544414 | 2020-09-18 | Mesa | Colorado | 8077 | 521 | 6 |
544415 | 544415 | 2020-09-18 | Mineral | Colorado | 8079 | 20 | 0 |
544416 | 544416 | 2020-09-18 | Moffat | Colorado | 8081 | 38 | 1 |
544417 | 544417 | 2020-09-18 | Montezuma | Colorado | 8083 | 129 | 5 |
544418 | 544418 | 2020-09-18 | Montrose | Colorado | 8085 | 365 | 13 |
544419 | 544419 | 2020-09-18 | Morgan | Colorado | 8087 | 731 | 48 |
544420 | 544420 | 2020-09-18 | Otero | Colorado | 8089 | 87 | 6 |
544421 | 544421 | 2020-09-18 | Ouray | Colorado | 8091 | 25 | 1 |
544422 | 544422 | 2020-09-18 | Park | Colorado | 8093 | 49 | 1 |
544423 | 544423 | 2020-09-18 | Phillips | Colorado | 8095 | 33 | 0 |
544424 | 544424 | 2020-09-18 | Pitkin | Colorado | 8097 | 217 | 2 |
544425 | 544425 | 2020-09-18 | Prowers | Colorado | 8099 | 92 | 0 |
544426 | 544426 | 2020-09-18 | Pueblo | Colorado | 8101 | 1014 | 34 |
544427 | 544427 | 2020-09-18 | Rio Blanco | Colorado | 8103 | 24 | 0 |
544428 | 544428 | 2020-09-18 | Rio Grande | Colorado | 8105 | 95 | 2 |
544429 | 544429 | 2020-09-18 | Routt | Colorado | 8107 | 141 | 8 |
544430 | 544430 | 2020-09-18 | Saguache | Colorado | 8109 | 111 | 2 |
544431 | 544431 | 2020-09-18 | San Juan | Colorado | 8111 | 6 | 0 |
544432 | 544432 | 2020-09-18 | San Miguel | Colorado | 8113 | 95 | 0 |
544433 | 544433 | 2020-09-18 | Sedgwick | Colorado | 8115 | 12 | 1 |
544434 | 544434 | 2020-09-18 | Summit | Colorado | 8117 | 408 | 4 |
544435 | 544435 | 2020-09-18 | Teller | Colorado | 8119 | 171 | 4 |
544436 | 544436 | 2020-09-18 | Washington | Colorado | 8121 | 57 | 0 |
544437 | 544437 | 2020-09-18 | Weld | Colorado | 8123 | 4451 | 149 |
544438 | 544438 | 2020-09-18 | Yuma | Colorado | 8125 | 84 | 0 |
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);