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-06 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
602700 | 602700 | 2020-10-06 | Adams | Colorado | 8001 | 10001 | 232 |
602701 | 602701 | 2020-10-06 | Alamosa | Colorado | 8003 | 254 | 9 |
602702 | 602702 | 2020-10-06 | Arapahoe | Colorado | 8005 | 9985 | 374 |
602703 | 602703 | 2020-10-06 | Archuleta | Colorado | 8007 | 54 | 0 |
602704 | 602704 | 2020-10-06 | Baca | Colorado | 8009 | 18 | 0 |
602705 | 602705 | 2020-10-06 | Bent | Colorado | 8011 | 11 | 0 |
602706 | 602706 | 2020-10-06 | Boulder | Colorado | 8013 | 4675 | 81 |
602707 | 602707 | 2020-10-06 | Broomfield | Colorado | 8014 | 701 | 37 |
602708 | 602708 | 2020-10-06 | Chaffee | Colorado | 8015 | 340 | 20 |
602709 | 602709 | 2020-10-06 | Cheyenne | Colorado | 8017 | 14 | 0 |
602710 | 602710 | 2020-10-06 | Clear Creek | Colorado | 8019 | 47 | 1 |
602711 | 602711 | 2020-10-06 | Conejos | Colorado | 8021 | 36 | 0 |
602712 | 602712 | 2020-10-06 | Costilla | Colorado | 8023 | 33 | 1 |
602713 | 602713 | 2020-10-06 | Crowley | Colorado | 8025 | 74 | 1 |
602714 | 602714 | 2020-10-06 | Custer | Colorado | 8027 | 18 | 0 |
602715 | 602715 | 2020-10-06 | Delta | Colorado | 8029 | 191 | 3 |
602716 | 602716 | 2020-10-06 | Denver | Colorado | 8031 | 14036 | 447 |
602717 | 602717 | 2020-10-06 | Dolores | Colorado | 8033 | 3 | 0 |
602718 | 602718 | 2020-10-06 | Douglas | Colorado | 8035 | 2971 | 61 |
602719 | 602719 | 2020-10-06 | Eagle | Colorado | 8037 | 1281 | 10 |
602720 | 602720 | 2020-10-06 | El Paso | Colorado | 8041 | 7331 | 182 |
602721 | 602721 | 2020-10-06 | Elbert | Colorado | 8039 | 170 | 3 |
602722 | 602722 | 2020-10-06 | Fremont | Colorado | 8043 | 189 | 1 |
602723 | 602723 | 2020-10-06 | Garfield | Colorado | 8045 | 982 | 5 |
602724 | 602724 | 2020-10-06 | Gilpin | Colorado | 8047 | 19 | 0 |
602725 | 602725 | 2020-10-06 | Grand | Colorado | 8049 | 100 | 1 |
602726 | 602726 | 2020-10-06 | Gunnison | Colorado | 8051 | 297 | 7 |
602727 | 602727 | 2020-10-06 | Hinsdale | Colorado | 8053 | 3 | 0 |
602728 | 602728 | 2020-10-06 | Huerfano | Colorado | 8055 | 25 | 1 |
602729 | 602729 | 2020-10-06 | Jackson | Colorado | 8057 | 9 | 0 |
602730 | 602730 | 2020-10-06 | Jefferson | Colorado | 8059 | 6158 | 257 |
602731 | 602731 | 2020-10-06 | Kiowa | Colorado | 8061 | 1 | 0 |
602732 | 602732 | 2020-10-06 | Kit Carson | Colorado | 8063 | 81 | 3 |
602733 | 602733 | 2020-10-06 | La Plata | Colorado | 8067 | 269 | 2 |
602734 | 602734 | 2020-10-06 | Lake | Colorado | 8065 | 99 | 0 |
602735 | 602735 | 2020-10-06 | Larimer | Colorado | 8069 | 2815 | 55 |
602736 | 602736 | 2020-10-06 | Las Animas | Colorado | 8071 | 25 | 0 |
602737 | 602737 | 2020-10-06 | Lincoln | Colorado | 8073 | 21 | 0 |
602738 | 602738 | 2020-10-06 | Logan | Colorado | 8075 | 958 | 6 |
602739 | 602739 | 2020-10-06 | Mesa | Colorado | 8077 | 716 | 7 |
602740 | 602740 | 2020-10-06 | Mineral | Colorado | 8079 | 20 | 0 |
602741 | 602741 | 2020-10-06 | Moffat | Colorado | 8081 | 45 | 1 |
602742 | 602742 | 2020-10-06 | Montezuma | Colorado | 8083 | 150 | 5 |
602743 | 602743 | 2020-10-06 | Montrose | Colorado | 8085 | 388 | 13 |
602744 | 602744 | 2020-10-06 | Morgan | Colorado | 8087 | 765 | 48 |
602745 | 602745 | 2020-10-06 | Otero | Colorado | 8089 | 107 | 6 |
602746 | 602746 | 2020-10-06 | Ouray | Colorado | 8091 | 29 | 1 |
602747 | 602747 | 2020-10-06 | Park | Colorado | 8093 | 59 | 1 |
602748 | 602748 | 2020-10-06 | Phillips | Colorado | 8095 | 33 | 0 |
602749 | 602749 | 2020-10-06 | Pitkin | Colorado | 8097 | 229 | 2 |
602750 | 602750 | 2020-10-06 | Prowers | Colorado | 8099 | 95 | 0 |
602751 | 602751 | 2020-10-06 | Pueblo | Colorado | 8101 | 1217 | 37 |
602752 | 602752 | 2020-10-06 | Rio Blanco | Colorado | 8103 | 26 | 0 |
602753 | 602753 | 2020-10-06 | Rio Grande | Colorado | 8105 | 99 | 2 |
602754 | 602754 | 2020-10-06 | Routt | Colorado | 8107 | 164 | 8 |
602755 | 602755 | 2020-10-06 | Saguache | Colorado | 8109 | 112 | 2 |
602756 | 602756 | 2020-10-06 | San Juan | Colorado | 8111 | 6 | 0 |
602757 | 602757 | 2020-10-06 | San Miguel | Colorado | 8113 | 95 | 0 |
602758 | 602758 | 2020-10-06 | Sedgwick | Colorado | 8115 | 15 | 1 |
602759 | 602759 | 2020-10-06 | Summit | Colorado | 8117 | 492 | 4 |
602760 | 602760 | 2020-10-06 | Teller | Colorado | 8119 | 179 | 4 |
602761 | 602761 | 2020-10-06 | Washington | Colorado | 8121 | 69 | 0 |
602762 | 602762 | 2020-10-06 | Weld | Colorado | 8123 | 4987 | 151 |
602763 | 602763 | 2020-10-06 | Yuma | Colorado | 8125 | 143 | 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);