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-12-24 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2044357 | 2044357 | 2021-12-24 | Adams | Colorado | 8001 | 91373 | 1076 |
2044358 | 2044358 | 2021-12-24 | Alamosa | Colorado | 8003 | 3055 | 54 |
2044359 | 2044359 | 2021-12-24 | Arapahoe | Colorado | 8005 | 97089 | 1058 |
2044360 | 2044360 | 2021-12-24 | Archuleta | Colorado | 8007 | 2027 | 9 |
2044361 | 2044361 | 2021-12-24 | Baca | Colorado | 8009 | 589 | 7 |
2044362 | 2044362 | 2021-12-24 | Bent | Colorado | 8011 | 1947 | 41 |
2044363 | 2044363 | 2021-12-24 | Boulder | Colorado | 8013 | 37292 | 323 |
2044364 | 2044364 | 2021-12-24 | Broomfield | Colorado | 8014 | 8188 | 94 |
2044365 | 2044365 | 2021-12-24 | Chaffee | Colorado | 8015 | 2805 | 38 |
2044366 | 2044366 | 2021-12-24 | Cheyenne | Colorado | 8017 | 245 | 8 |
2044367 | 2044367 | 2021-12-24 | Clear Creek | Colorado | 8019 | 954 | 7 |
2044368 | 2044368 | 2021-12-24 | Conejos | Colorado | 8021 | 1182 | 44 |
2044369 | 2044369 | 2021-12-24 | Costilla | Colorado | 8023 | 438 | 13 |
2044370 | 2044370 | 2021-12-24 | Crowley | Colorado | 8025 | 2492 | 27 |
2044371 | 2044371 | 2021-12-24 | Custer | Colorado | 8027 | 488 | 15 |
2044372 | 2044372 | 2021-12-24 | Delta | Colorado | 8029 | 4757 | 120 |
2044373 | 2044373 | 2021-12-24 | Denver | Colorado | 8031 | 109975 | 1085 |
2044374 | 2044374 | 2021-12-24 | Dolores | Colorado | 8033 | 283 | 5 |
2044375 | 2044375 | 2021-12-24 | Douglas | Colorado | 8035 | 49287 | 367 |
2044376 | 2044376 | 2021-12-24 | Eagle | Colorado | 8037 | 10385 | 32 |
2044377 | 2044377 | 2021-12-24 | El Paso | Colorado | 8041 | 121281 | 1379 |
2044378 | 2044378 | 2021-12-24 | Elbert | Colorado | 8039 | 3205 | 30 |
2044379 | 2044379 | 2021-12-24 | Fremont | Colorado | 8043 | 10502 | 155 |
2044380 | 2044380 | 2021-12-24 | Garfield | Colorado | 8045 | 9429 | 77 |
2044381 | 2044381 | 2021-12-24 | Gilpin | Colorado | 8047 | 575 | 3 |
2044382 | 2044382 | 2021-12-24 | Grand | Colorado | 8049 | 2424 | 20 |
2044383 | 2044383 | 2021-12-24 | Gunnison | Colorado | 8051 | 2099 | 13 |
2044384 | 2044384 | 2021-12-24 | Hinsdale | Colorado | 8053 | 69 | 0 |
2044385 | 2044385 | 2021-12-24 | Huerfano | Colorado | 8055 | 911 | 26 |
2044386 | 2044386 | 2021-12-24 | Jackson | Colorado | 8057 | 126 | 0 |
2044387 | 2044387 | 2021-12-24 | Jefferson | Colorado | 8059 | 78155 | 1073 |
2044388 | 2044388 | 2021-12-24 | Kiowa | Colorado | 8061 | 278 | 4 |
2044389 | 2044389 | 2021-12-24 | Kit Carson | Colorado | 8063 | 1256 | 25 |
2044390 | 2044390 | 2021-12-24 | La Plata | Colorado | 8067 | 7428 | 67 |
2044391 | 2044391 | 2021-12-24 | Lake | Colorado | 8065 | 1245 | 2 |
2044392 | 2044392 | 2021-12-24 | Larimer | Colorado | 8069 | 48130 | 396 |
2044393 | 2044393 | 2021-12-24 | Las Animas | Colorado | 8071 | 2336 | 30 |
2044394 | 2044394 | 2021-12-24 | Lincoln | Colorado | 8073 | 1427 | 8 |
2044395 | 2044395 | 2021-12-24 | Logan | Colorado | 8075 | 5259 | 95 |
2044396 | 2044396 | 2021-12-24 | Mesa | Colorado | 8077 | 29871 | 453 |
2044397 | 2044397 | 2021-12-24 | Mineral | Colorado | 8079 | 150 | 1 |
2044398 | 2044398 | 2021-12-24 | Moffat | Colorado | 8081 | 2256 | 48 |
2044399 | 2044399 | 2021-12-24 | Montezuma | Colorado | 8083 | 4184 | 52 |
2044400 | 2044400 | 2021-12-24 | Montrose | Colorado | 8085 | 6962 | 138 |
2044401 | 2044401 | 2021-12-24 | Morgan | Colorado | 8087 | 4183 | 125 |
2044402 | 2044402 | 2021-12-24 | Otero | Colorado | 8089 | 3323 | 115 |
2044403 | 2044403 | 2021-12-24 | Ouray | Colorado | 8091 | 553 | 6 |
2044404 | 2044404 | 2021-12-24 | Park | Colorado | 8093 | 1871 | 14 |
2044405 | 2044405 | 2021-12-24 | Phillips | Colorado | 8095 | 607 | 15 |
2044406 | 2044406 | 2021-12-24 | Pitkin | Colorado | 8097 | 3647 | 6 |
2044407 | 2044407 | 2021-12-24 | Prowers | Colorado | 8099 | 2032 | 42 |
2044408 | 2044408 | 2021-12-24 | Pueblo | Colorado | 8101 | 30980 | 652 |
2044409 | 2044409 | 2021-12-24 | Rio Blanco | Colorado | 8103 | 1275 | 11 |
2044410 | 2044410 | 2021-12-24 | Rio Grande | Colorado | 8105 | 1944 | 40 |
2044411 | 2044411 | 2021-12-24 | Routt | Colorado | 8107 | 4009 | 24 |
2044412 | 2044412 | 2021-12-24 | Saguache | Colorado | 8109 | 835 | 9 |
2044413 | 2044413 | 2021-12-24 | San Juan | Colorado | 8111 | 113 | 0 |
2044414 | 2044414 | 2021-12-24 | San Miguel | Colorado | 8113 | 1459 | 7 |
2044415 | 2044415 | 2021-12-24 | Sedgwick | Colorado | 8115 | 364 | 6 |
2044416 | 2044416 | 2021-12-24 | Summit | Colorado | 8117 | 5984 | 12 |
2044417 | 2044417 | 2021-12-24 | Teller | Colorado | 8119 | 3496 | 50 |
2044418 | 2044418 | 2021-12-24 | Washington | Colorado | 8121 | 767 | 24 |
2044419 | 2044419 | 2021-12-24 | Weld | Colorado | 8123 | 56156 | 580 |
2044420 | 2044420 | 2021-12-24 | Yuma | Colorado | 8125 | 1458 | 21 |
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);