ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where date = "2020-08-24" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
463527 | 463527 | 2020-08-24 | Adams | Colorado | 8001 | 7257 | 194 |
463528 | 463528 | 2020-08-24 | Alamosa | Colorado | 8003 | 236 | 9 |
463529 | 463529 | 2020-08-24 | Arapahoe | Colorado | 8005 | 7990 | 366 |
463530 | 463530 | 2020-08-24 | Archuleta | Colorado | 8007 | 45 | 0 |
463531 | 463531 | 2020-08-24 | Baca | Colorado | 8009 | 15 | 0 |
463532 | 463532 | 2020-08-24 | Bent | Colorado | 8011 | 11 | 0 |
463533 | 463533 | 2020-08-24 | Boulder | Colorado | 8013 | 2239 | 79 |
463534 | 463534 | 2020-08-24 | Broomfield | Colorado | 8014 | 515 | 32 |
463535 | 463535 | 2020-08-24 | Chaffee | Colorado | 8015 | 311 | 19 |
463536 | 463536 | 2020-08-24 | Cheyenne | Colorado | 8017 | 9 | 0 |
463537 | 463537 | 2020-08-24 | Clear Creek | Colorado | 8019 | 34 | 1 |
463538 | 463538 | 2020-08-24 | Conejos | Colorado | 8021 | 31 | 0 |
463539 | 463539 | 2020-08-24 | Costilla | Colorado | 8023 | 27 | 0 |
463540 | 463540 | 2020-08-24 | Crowley | Colorado | 8025 | 73 | 1 |
463541 | 463541 | 2020-08-24 | Custer | Colorado | 8027 | 13 | 0 |
463542 | 463542 | 2020-08-24 | Delta | Colorado | 8029 | 140 | 1 |
463543 | 463543 | 2020-08-24 | Denver | Colorado | 8031 | 10931 | 426 |
463544 | 463544 | 2020-08-24 | Dolores | Colorado | 8033 | 2 | 0 |
463545 | 463545 | 2020-08-24 | Douglas | Colorado | 8035 | 2011 | 59 |
463546 | 463546 | 2020-08-24 | Eagle | Colorado | 8037 | 1166 | 10 |
463547 | 463547 | 2020-08-24 | El Paso | Colorado | 8041 | 5811 | 151 |
463548 | 463548 | 2020-08-24 | Elbert | Colorado | 8039 | 117 | 2 |
463549 | 463549 | 2020-08-24 | Fremont | Colorado | 8043 | 146 | 0 |
463550 | 463550 | 2020-08-24 | Garfield | Colorado | 8045 | 818 | 4 |
463551 | 463551 | 2020-08-24 | Gilpin | Colorado | 8047 | 17 | 0 |
463552 | 463552 | 2020-08-24 | Grand | Colorado | 8049 | 56 | 1 |
463553 | 463553 | 2020-08-24 | Gunnison | Colorado | 8051 | 286 | 7 |
463554 | 463554 | 2020-08-24 | Hinsdale | Colorado | 8053 | 3 | 0 |
463555 | 463555 | 2020-08-24 | Huerfano | Colorado | 8055 | 8 | 1 |
463556 | 463556 | 2020-08-24 | Jackson | Colorado | 8057 | 9 | 0 |
463557 | 463557 | 2020-08-24 | Jefferson | Colorado | 8059 | 4605 | 235 |
463558 | 463558 | 2020-08-24 | Kit Carson | Colorado | 8063 | 69 | 3 |
463559 | 463559 | 2020-08-24 | La Plata | Colorado | 8067 | 232 | 2 |
463560 | 463560 | 2020-08-24 | Lake | Colorado | 8065 | 80 | 0 |
463561 | 463561 | 2020-08-24 | Larimer | Colorado | 8069 | 1817 | 37 |
463562 | 463562 | 2020-08-24 | Las Animas | Colorado | 8071 | 19 | 0 |
463563 | 463563 | 2020-08-24 | Lincoln | Colorado | 8073 | 8 | 0 |
463564 | 463564 | 2020-08-24 | Logan | Colorado | 8075 | 665 | 5 |
463565 | 463565 | 2020-08-24 | Mesa | Colorado | 8077 | 388 | 5 |
463566 | 463566 | 2020-08-24 | Mineral | Colorado | 8079 | 19 | 0 |
463567 | 463567 | 2020-08-24 | Moffat | Colorado | 8081 | 33 | 1 |
463568 | 463568 | 2020-08-24 | Montezuma | Colorado | 8083 | 121 | 5 |
463569 | 463569 | 2020-08-24 | Montrose | Colorado | 8085 | 336 | 13 |
463570 | 463570 | 2020-08-24 | Morgan | Colorado | 8087 | 706 | 47 |
463571 | 463571 | 2020-08-24 | Otero | Colorado | 8089 | 81 | 6 |
463572 | 463572 | 2020-08-24 | Ouray | Colorado | 8091 | 20 | 1 |
463573 | 463573 | 2020-08-24 | Park | Colorado | 8093 | 43 | 1 |
463574 | 463574 | 2020-08-24 | Phillips | Colorado | 8095 | 19 | 0 |
463575 | 463575 | 2020-08-24 | Pitkin | Colorado | 8097 | 193 | 2 |
463576 | 463576 | 2020-08-24 | Prowers | Colorado | 8099 | 78 | 0 |
463577 | 463577 | 2020-08-24 | Pueblo | Colorado | 8101 | 802 | 34 |
463578 | 463578 | 2020-08-24 | Rio Blanco | Colorado | 8103 | 21 | 0 |
463579 | 463579 | 2020-08-24 | Rio Grande | Colorado | 8105 | 94 | 2 |
463580 | 463580 | 2020-08-24 | Routt | Colorado | 8107 | 131 | 8 |
463581 | 463581 | 2020-08-24 | Saguache | Colorado | 8109 | 108 | 2 |
463582 | 463582 | 2020-08-24 | San Juan | Colorado | 8111 | 2 | 0 |
463583 | 463583 | 2020-08-24 | San Miguel | Colorado | 8113 | 93 | 0 |
463584 | 463584 | 2020-08-24 | Sedgwick | Colorado | 8115 | 12 | 1 |
463585 | 463585 | 2020-08-24 | Summit | Colorado | 8117 | 352 | 4 |
463586 | 463586 | 2020-08-24 | Teller | Colorado | 8119 | 155 | 3 |
463587 | 463587 | 2020-08-24 | Washington | Colorado | 8121 | 52 | 0 |
463588 | 463588 | 2020-08-24 | Weld | Colorado | 8123 | 3956 | 146 |
463589 | 463589 | 2020-08-24 | Yuma | Colorado | 8125 | 63 | 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);