ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where date = "2020-09-02" 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 |
---|---|---|---|---|---|---|---|
492618 | 492618 | 2020-09-02 | Adams | Colorado | 8001 | 7689 | 198 |
492619 | 492619 | 2020-09-02 | Alamosa | Colorado | 8003 | 238 | 9 |
492620 | 492620 | 2020-09-02 | Arapahoe | Colorado | 8005 | 8320 | 370 |
492621 | 492621 | 2020-09-02 | Archuleta | Colorado | 8007 | 48 | 0 |
492622 | 492622 | 2020-09-02 | Baca | Colorado | 8009 | 18 | 0 |
492623 | 492623 | 2020-09-02 | Bent | Colorado | 8011 | 11 | 0 |
492624 | 492624 | 2020-09-02 | Boulder | Colorado | 8013 | 2344 | 79 |
492625 | 492625 | 2020-09-02 | Broomfield | Colorado | 8014 | 541 | 33 |
492626 | 492626 | 2020-09-02 | Chaffee | Colorado | 8015 | 316 | 19 |
492627 | 492627 | 2020-09-02 | Cheyenne | Colorado | 8017 | 9 | 0 |
492628 | 492628 | 2020-09-02 | Clear Creek | Colorado | 8019 | 35 | 1 |
492629 | 492629 | 2020-09-02 | Conejos | Colorado | 8021 | 31 | 0 |
492630 | 492630 | 2020-09-02 | Costilla | Colorado | 8023 | 32 | 1 |
492631 | 492631 | 2020-09-02 | Crowley | Colorado | 8025 | 73 | 1 |
492632 | 492632 | 2020-09-02 | Custer | Colorado | 8027 | 17 | 0 |
492633 | 492633 | 2020-09-02 | Delta | Colorado | 8029 | 166 | 2 |
492634 | 492634 | 2020-09-02 | Denver | Colorado | 8031 | 11339 | 434 |
492635 | 492635 | 2020-09-02 | Dolores | Colorado | 8033 | 2 | 0 |
492636 | 492636 | 2020-09-02 | Douglas | Colorado | 8035 | 2135 | 60 |
492637 | 492637 | 2020-09-02 | Eagle | Colorado | 8037 | 1185 | 9 |
492638 | 492638 | 2020-09-02 | El Paso | Colorado | 8041 | 6136 | 155 |
492639 | 492639 | 2020-09-02 | Elbert | Colorado | 8039 | 122 | 2 |
492640 | 492640 | 2020-09-02 | Fremont | Colorado | 8043 | 160 | 0 |
492641 | 492641 | 2020-09-02 | Garfield | Colorado | 8045 | 846 | 4 |
492642 | 492642 | 2020-09-02 | Gilpin | Colorado | 8047 | 18 | 0 |
492643 | 492643 | 2020-09-02 | Grand | Colorado | 8049 | 66 | 1 |
492644 | 492644 | 2020-09-02 | Gunnison | Colorado | 8051 | 292 | 7 |
492645 | 492645 | 2020-09-02 | Hinsdale | Colorado | 8053 | 3 | 0 |
492646 | 492646 | 2020-09-02 | Huerfano | Colorado | 8055 | 9 | 1 |
492647 | 492647 | 2020-09-02 | Jackson | Colorado | 8057 | 9 | 0 |
492648 | 492648 | 2020-09-02 | Jefferson | Colorado | 8059 | 4862 | 238 |
492649 | 492649 | 2020-09-02 | Kit Carson | Colorado | 8063 | 78 | 3 |
492650 | 492650 | 2020-09-02 | La Plata | Colorado | 8067 | 242 | 2 |
492651 | 492651 | 2020-09-02 | Lake | Colorado | 8065 | 81 | 0 |
492652 | 492652 | 2020-09-02 | Larimer | Colorado | 8069 | 1985 | 43 |
492653 | 492653 | 2020-09-02 | Las Animas | Colorado | 8071 | 20 | 0 |
492654 | 492654 | 2020-09-02 | Lincoln | Colorado | 8073 | 8 | 0 |
492655 | 492655 | 2020-09-02 | Logan | Colorado | 8075 | 691 | 5 |
492656 | 492656 | 2020-09-02 | Mesa | Colorado | 8077 | 419 | 5 |
492657 | 492657 | 2020-09-02 | Mineral | Colorado | 8079 | 19 | 0 |
492658 | 492658 | 2020-09-02 | Moffat | Colorado | 8081 | 34 | 1 |
492659 | 492659 | 2020-09-02 | Montezuma | Colorado | 8083 | 126 | 5 |
492660 | 492660 | 2020-09-02 | Montrose | Colorado | 8085 | 345 | 13 |
492661 | 492661 | 2020-09-02 | Morgan | Colorado | 8087 | 716 | 48 |
492662 | 492662 | 2020-09-02 | Otero | Colorado | 8089 | 82 | 6 |
492663 | 492663 | 2020-09-02 | Ouray | Colorado | 8091 | 25 | 1 |
492664 | 492664 | 2020-09-02 | Park | Colorado | 8093 | 43 | 1 |
492665 | 492665 | 2020-09-02 | Phillips | Colorado | 8095 | 19 | 0 |
492666 | 492666 | 2020-09-02 | Pitkin | Colorado | 8097 | 199 | 2 |
492667 | 492667 | 2020-09-02 | Prowers | Colorado | 8099 | 87 | 0 |
492668 | 492668 | 2020-09-02 | Pueblo | Colorado | 8101 | 886 | 34 |
492669 | 492669 | 2020-09-02 | Rio Blanco | Colorado | 8103 | 23 | 0 |
492670 | 492670 | 2020-09-02 | Rio Grande | Colorado | 8105 | 94 | 2 |
492671 | 492671 | 2020-09-02 | Routt | Colorado | 8107 | 134 | 8 |
492672 | 492672 | 2020-09-02 | Saguache | Colorado | 8109 | 111 | 2 |
492673 | 492673 | 2020-09-02 | San Juan | Colorado | 8111 | 6 | 0 |
492674 | 492674 | 2020-09-02 | San Miguel | Colorado | 8113 | 93 | 0 |
492675 | 492675 | 2020-09-02 | Sedgwick | Colorado | 8115 | 12 | 1 |
492676 | 492676 | 2020-09-02 | Summit | Colorado | 8117 | 365 | 4 |
492677 | 492677 | 2020-09-02 | Teller | Colorado | 8119 | 162 | 4 |
492678 | 492678 | 2020-09-02 | Washington | Colorado | 8121 | 53 | 0 |
492679 | 492679 | 2020-09-02 | Weld | Colorado | 8123 | 4098 | 146 |
492680 | 492680 | 2020-09-02 | Yuma | Colorado | 8125 | 64 | 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);