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 2020-10-22 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
654603 | 654603 | 2020-10-22 | Adams | Colorado | 8001 | 12677 | 250 |
654604 | 654604 | 2020-10-22 | Alamosa | Colorado | 8003 | 292 | 9 |
654605 | 654605 | 2020-10-22 | Arapahoe | Colorado | 8005 | 11743 | 394 |
654606 | 654606 | 2020-10-22 | Archuleta | Colorado | 8007 | 61 | 0 |
654607 | 654607 | 2020-10-22 | Baca | Colorado | 8009 | 27 | 0 |
654608 | 654608 | 2020-10-22 | Bent | Colorado | 8011 | 13 | 0 |
654609 | 654609 | 2020-10-22 | Boulder | Colorado | 8013 | 5229 | 85 |
654610 | 654610 | 2020-10-22 | Broomfield | Colorado | 8014 | 862 | 41 |
654611 | 654611 | 2020-10-22 | Chaffee | Colorado | 8015 | 375 | 20 |
654612 | 654612 | 2020-10-22 | Cheyenne | Colorado | 8017 | 14 | 0 |
654613 | 654613 | 2020-10-22 | Clear Creek | Colorado | 8019 | 64 | 1 |
654614 | 654614 | 2020-10-22 | Conejos | Colorado | 8021 | 62 | 0 |
654615 | 654615 | 2020-10-22 | Costilla | Colorado | 8023 | 35 | 1 |
654616 | 654616 | 2020-10-22 | Crowley | Colorado | 8025 | 83 | 1 |
654617 | 654617 | 2020-10-22 | Custer | Colorado | 8027 | 19 | 0 |
654618 | 654618 | 2020-10-22 | Delta | Colorado | 8029 | 198 | 4 |
654619 | 654619 | 2020-10-22 | Denver | Colorado | 8031 | 16666 | 450 |
654620 | 654620 | 2020-10-22 | Dolores | Colorado | 8033 | 3 | 0 |
654621 | 654621 | 2020-10-22 | Douglas | Colorado | 8035 | 3554 | 64 |
654622 | 654622 | 2020-10-22 | Eagle | Colorado | 8037 | 1379 | 10 |
654623 | 654623 | 2020-10-22 | El Paso | Colorado | 8041 | 9342 | 195 |
654624 | 654624 | 2020-10-22 | Elbert | Colorado | 8039 | 191 | 3 |
654625 | 654625 | 2020-10-22 | Fremont | Colorado | 8043 | 602 | 1 |
654626 | 654626 | 2020-10-22 | Garfield | Colorado | 8045 | 1107 | 5 |
654627 | 654627 | 2020-10-22 | Gilpin | Colorado | 8047 | 27 | 0 |
654628 | 654628 | 2020-10-22 | Grand | Colorado | 8049 | 142 | 1 |
654629 | 654629 | 2020-10-22 | Gunnison | Colorado | 8051 | 305 | 7 |
654630 | 654630 | 2020-10-22 | Hinsdale | Colorado | 8053 | 3 | 0 |
654631 | 654631 | 2020-10-22 | Huerfano | Colorado | 8055 | 29 | 2 |
654632 | 654632 | 2020-10-22 | Jackson | Colorado | 8057 | 9 | 0 |
654633 | 654633 | 2020-10-22 | Jefferson | Colorado | 8059 | 7599 | 301 |
654634 | 654634 | 2020-10-22 | Kiowa | Colorado | 8061 | 3 | 0 |
654635 | 654635 | 2020-10-22 | Kit Carson | Colorado | 8063 | 114 | 3 |
654636 | 654636 | 2020-10-22 | La Plata | Colorado | 8067 | 331 | 2 |
654637 | 654637 | 2020-10-22 | Lake | Colorado | 8065 | 122 | 0 |
654638 | 654638 | 2020-10-22 | Larimer | Colorado | 8069 | 3718 | 55 |
654639 | 654639 | 2020-10-22 | Las Animas | Colorado | 8071 | 65 | 1 |
654640 | 654640 | 2020-10-22 | Lincoln | Colorado | 8073 | 24 | 0 |
654641 | 654641 | 2020-10-22 | Logan | Colorado | 8075 | 1129 | 10 |
654642 | 654642 | 2020-10-22 | Mesa | Colorado | 8077 | 1117 | 8 |
654643 | 654643 | 2020-10-22 | Mineral | Colorado | 8079 | 21 | 0 |
654644 | 654644 | 2020-10-22 | Moffat | Colorado | 8081 | 56 | 1 |
654645 | 654645 | 2020-10-22 | Montezuma | Colorado | 8083 | 187 | 5 |
654646 | 654646 | 2020-10-22 | Montrose | Colorado | 8085 | 431 | 13 |
654647 | 654647 | 2020-10-22 | Morgan | Colorado | 8087 | 829 | 48 |
654648 | 654648 | 2020-10-22 | Otero | Colorado | 8089 | 122 | 6 |
654649 | 654649 | 2020-10-22 | Ouray | Colorado | 8091 | 34 | 2 |
654650 | 654650 | 2020-10-22 | Park | Colorado | 8093 | 88 | 1 |
654651 | 654651 | 2020-10-22 | Phillips | Colorado | 8095 | 42 | 0 |
654652 | 654652 | 2020-10-22 | Pitkin | Colorado | 8097 | 271 | 2 |
654653 | 654653 | 2020-10-22 | Prowers | Colorado | 8099 | 138 | 0 |
654654 | 654654 | 2020-10-22 | Pueblo | Colorado | 8101 | 1725 | 40 |
654655 | 654655 | 2020-10-22 | Rio Blanco | Colorado | 8103 | 27 | 0 |
654656 | 654656 | 2020-10-22 | Rio Grande | Colorado | 8105 | 115 | 3 |
654657 | 654657 | 2020-10-22 | Routt | Colorado | 8107 | 197 | 8 |
654658 | 654658 | 2020-10-22 | Saguache | Colorado | 8109 | 128 | 2 |
654659 | 654659 | 2020-10-22 | San Juan | Colorado | 8111 | 7 | 0 |
654660 | 654660 | 2020-10-22 | San Miguel | Colorado | 8113 | 100 | 0 |
654661 | 654661 | 2020-10-22 | Sedgwick | Colorado | 8115 | 38 | 1 |
654662 | 654662 | 2020-10-22 | Summit | Colorado | 8117 | 621 | 4 |
654663 | 654663 | 2020-10-22 | Teller | Colorado | 8119 | 201 | 4 |
654664 | 654664 | 2020-10-22 | Washington | Colorado | 8121 | 83 | 0 |
654665 | 654665 | 2020-10-22 | Weld | Colorado | 8123 | 5639 | 159 |
654666 | 654666 | 2020-10-22 | Yuma | Colorado | 8125 | 204 | 1 |
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);