johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

8,658 rows where province_or_state = "Colorado" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Colorado · 8,658

country_or_region

  • US 8,658
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
496646 2020-08-11 US Colorado Fremont 8043 128 0 0 128 38.47362326 -105.4399667 2020-08-12 04:27:29 Fremont, Colorado, US
496647 2020-08-11 US Colorado Moffat 8081 32 1 0 31 40.61810999 -108.2070876 2020-08-12 04:27:29 Moffat, Colorado, US
496648 2020-08-11 US Colorado Morgan 8087 687 46 0 641 40.26279810000001 -103.8093302 2020-08-12 04:27:29 Morgan, Colorado, US
496649 2020-08-11 US Colorado Otero 8089 76 6 0 70 37.9014485 -103.7173385 2020-08-12 04:27:29 Otero, Colorado, US
496650 2020-08-11 US Colorado Pitkin 8097 188 2 0 186 39.21720112 -106.9310027 2020-08-12 04:27:29 Pitkin, Colorado, US
496651 2020-08-11 US Colorado Prowers 8099 54 0 0 54 37.95544985 -102.3926052 2020-08-12 04:27:29 Prowers, Colorado, US
496652 2020-08-11 US Colorado Washington 8121 49 0 0 49 39.97015535 -103.202587 2020-08-12 04:27:29 Washington, Colorado, US
497136 2020-08-11 US Colorado Adams 8001 6581 177 0 6404 39.87432092 -104.3362578 2020-08-12 04:27:29 Adams, Colorado, US
497137 2020-08-11 US Colorado Boulder 8013 2086 76 0 2010 40.09313619 -105.3546767 2020-08-12 04:27:29 Boulder, Colorado, US
497138 2020-08-11 US Colorado Clear Creek 8019 30 1 0 29 39.68864463 -105.6463118 2020-08-12 04:27:29 Clear Creek, Colorado, US
497139 2020-08-11 US Colorado Dolores 8033 1 0 0 1 37.75208676 -108.5211585 2020-08-12 04:27:29 Dolores, Colorado, US
497140 2020-08-11 US Colorado Gilpin 8047 16 0 0 16 39.85646523 -105.5252597 2020-08-12 04:27:29 Gilpin, Colorado, US
497141 2020-08-11 US Colorado Gunnison 8051 274 6 0 268 38.66611652 -107.0320729 2020-08-12 04:27:29 Gunnison, Colorado, US
497142 2020-08-11 US Colorado Huerfano 8055 8 1 0 7 37.68473101 -104.9612585 2020-08-12 04:27:29 Huerfano, Colorado, US
497143 2020-08-11 US Colorado Jackson 8057 9 0 0 9 40.66593870000001 -106.3408905 2020-08-12 04:27:29 Jackson, Colorado, US
497144 2020-08-11 US Colorado Montezuma 8083 112 4 0 108 37.33859579 -108.5958857 2020-08-12 04:27:29 Montezuma, Colorado, US
497145 2020-08-11 US Colorado Phillips 8095 19 0 0 19 40.59414277 -102.3577703 2020-08-12 04:27:29 Phillips, Colorado, US
497146 2020-08-11 US Colorado Yuma 8125 63 0 0 63 40.00346839 -102.4258673 2020-08-12 04:27:29 Yuma, Colorado, US
497618 2020-08-11 US Colorado Arapahoe 8005 7377 362 0 7015 39.64977461 -104.3353617 2020-08-12 04:27:29 Arapahoe, Colorado, US
497619 2020-08-11 US Colorado Conejos 8021 23 0 0 23 37.201606 -106.19174879999998 2020-08-12 04:27:29 Conejos, Colorado, US
497620 2020-08-11 US Colorado Denver 8031 10319 417 0 9902 39.76018276 -104.8725695 2020-08-12 04:27:29 Denver, Colorado, US
497621 2020-08-11 US Colorado Eagle 8037 1126 9 0 1117 39.62754308 -106.6933637 2020-08-12 04:27:29 Eagle, Colorado, US
497622 2020-08-11 US Colorado Logan 8075 655 5 0 650 40.7249637 -103.110817 2020-08-12 04:27:29 Logan, Colorado, US
497623 2020-08-11 US Colorado Mesa 8077 329 4 0 325 39.01787888 -108.469799 2020-08-12 04:27:29 Mesa, Colorado, US
497624 2020-08-11 US Colorado San Juan 8111 2 0 0 2 37.76248981 -107.67632890000002 2020-08-12 04:27:29 San Juan, Colorado, US
497625 2020-08-11 US Colorado Sedgwick 8115 11 1 0 10 40.87595412 -102.3519227 2020-08-12 04:27:29 Sedgwick, Colorado, US
497626 2020-08-11 US Colorado Weld 8123 3742 145 0 3597 40.55499405 -104.3929621 2020-08-12 04:27:29 Weld, Colorado, US
498078 2020-08-11 US Colorado Archuleta 8007 36 0 0 36 37.19474156 -107.0476867 2020-08-12 04:27:29 Archuleta, Colorado, US
498079 2020-08-11 US Colorado Crowley 8025 72 1 0 71 38.32608609 -103.7844965 2020-08-12 04:27:29 Crowley, Colorado, US
498080 2020-08-11 US Colorado Kit Carson 8063 56 3 0 53 39.30497777 -102.6022199 2020-08-12 04:27:29 Kit Carson, Colorado, US
498081 2020-08-11 US Colorado Mineral 8079 18 0 0 18 37.66954283 -106.9281698 2020-08-12 04:27:29 Mineral, Colorado, US
498082 2020-08-11 US Colorado Rio Grande 8105 89 2 0 87 37.5836865 -106.3847838 2020-08-12 04:27:29 Rio Grande, Colorado, US
498083 2020-08-11 US Colorado Summit 8117 338 4 0 334 39.63803232 -106.1150762 2020-08-12 04:27:29 Summit, Colorado, US
498084 2020-08-11 US Colorado Unassigned 90008 0 0 0 0 40.87595412 0.0 2020-08-12 04:27:29 Unassigned, Colorado, US
498588 2020-08-11 US Colorado Cheyenne 8017 9 0 0 9 38.82777431 -102.6032558 2020-08-12 04:27:29 Cheyenne, Colorado, US
498589 2020-08-11 US Colorado Garfield 8045 773 4 0 769 39.59921777 -107.902708 2020-08-12 04:27:29 Garfield, Colorado, US
498590 2020-08-11 US Colorado Jefferson 8059 4258 233 0 4025 39.58635604 -105.2517692 2020-08-12 04:27:29 Jefferson, Colorado, US
498591 2020-08-11 US Colorado Lake 8065 79 0 0 79 39.20278823 -106.3555697 2020-08-12 04:27:29 Lake, Colorado, US
498592 2020-08-11 US Colorado Larimer 8069 1590 37 0 1553 40.66671597 -105.4625784 2020-08-12 04:27:29 Larimer, Colorado, US
498593 2020-08-11 US Colorado Lincoln 8073 8 0 0 8 38.98749519 -103.5136649 2020-08-12 04:27:29 Lincoln, Colorado, US
498594 2020-08-11 US Colorado Saguache 8109 106 2 0 104 38.08054629 -106.282466 2020-08-12 04:27:29 Saguache, Colorado, US
498595 2020-08-11 US Colorado San Miguel 8113 90 0 0 90 38.00450883 -108.4020725 2020-08-12 04:27:29 San Miguel, Colorado, US
498596 2020-08-11 US Colorado Out of CO 80008 0 0 0 0 40.87595412 0.0 2020-08-12 04:27:29 Out of CO, Colorado, US
499078 2020-08-11 US Colorado Bent 8011 9 0 0 9 37.95474293 -103.0720195 2020-08-12 04:27:29 Bent, Colorado, US
499079 2020-08-11 US Colorado El Paso 8041 5183 140 0 5043 38.83240149 -104.5251411 2020-08-12 04:27:29 El Paso, Colorado, US
499080 2020-08-11 US Colorado Las Animas 8071 18 0 0 18 37.3153406 -104.0376458 2020-08-12 04:27:29 Las Animas, Colorado, US
499570 2020-08-11 US Colorado Alamosa 8003 231 9 0 222 37.57250606 -105.7885451 2020-08-12 04:27:29 Alamosa, Colorado, US
499571 2020-08-11 US Colorado Baca 8009 15 0 0 15 37.31940883 -102.5603223 2020-08-12 04:27:29 Baca, Colorado, US
499572 2020-08-11 US Colorado Chaffee 8015 304 19 0 285 38.74745778 -106.19265729999998 2020-08-12 04:27:29 Chaffee, Colorado, US
499573 2020-08-11 US Colorado Elbert 8039 107 2 0 105 39.28656773 -104.1358721 2020-08-12 04:27:29 Elbert, Colorado, US
499574 2020-08-11 US Colorado La Plata 8067 222 2 0 220 37.28632032 -107.8429014 2020-08-12 04:27:29 La Plata, Colorado, US
499575 2020-08-11 US Colorado Ouray 8091 13 1 0 12 38.14717457 -107.7675136 2020-08-12 04:27:29 Ouray, Colorado, US
499576 2020-08-11 US Colorado Pueblo 8101 709 34 0 675 38.17359144 -104.5127437 2020-08-12 04:27:29 Pueblo, Colorado, US
499577 2020-08-11 US Colorado Rio Blanco 8103 20 0 0 20 39.97913541 -108.2179009 2020-08-12 04:27:29 Rio Blanco, Colorado, US
499578 2020-08-11 US Colorado Routt 8107 125 8 0 117 40.48596505 -106.9905548 2020-08-12 04:27:29 Routt, Colorado, US
499579 2020-08-11 US Colorado Teller 8119 136 3 0 133 38.88133511 -105.1614893 2020-08-12 04:27:29 Teller, Colorado, US
499862 2020-08-11 US Colorado Broomfield 8014 482 32 0 450 39.95998787 -105.0566324 2020-08-12 04:27:29 Broomfield, Colorado, US
499863 2020-08-11 US Colorado Costilla 8023 23 0 0 23 37.27732493 -105.4276548 2020-08-12 04:27:29 Costilla, Colorado, US
499864 2020-08-11 US Colorado Custer 8027 11 0 0 11 38.10883162 -105.3683478 2020-08-12 04:27:29 Custer, Colorado, US
499865 2020-08-11 US Colorado Delta 8029 128 1 0 127 38.86246243 -107.8631342 2020-08-12 04:27:29 Delta, Colorado, US
499866 2020-08-11 US Colorado Douglas 8035 1759 59 0 1700 39.33133796 -104.930001 2020-08-12 04:27:29 Douglas, Colorado, US
499867 2020-08-11 US Colorado Grand 8049 51 1 0 50 40.10603347 -106.1178042 2020-08-12 04:27:29 Grand, Colorado, US
499868 2020-08-11 US Colorado Hinsdale 8053 3 0 0 3 37.82247444 -107.3004345 2020-08-12 04:27:29 Hinsdale, Colorado, US
499869 2020-08-11 US Colorado Montrose 8085 312 13 0 299 38.40214114 -108.26390220000002 2020-08-12 04:27:29 Montrose, Colorado, US
499870 2020-08-11 US Colorado Park 8093 42 1 0 41 39.120926 -105.7182065 2020-08-12 04:27:29 Park, Colorado, US
274086 2020-08-10 US Colorado Adams 8001 6529 176 0 6353 39.87432092 -104.3362578 2020-08-11 04:35:08 Adams, Colorado, US
274109 2020-08-10 US Colorado Alamosa 8003 230 9 0 221 37.57250606 -105.7885451 2020-08-11 04:35:08 Alamosa, Colorado, US
274162 2020-08-10 US Colorado Arapahoe 8005 7340 364 0 6976 39.64977461 -104.3353617 2020-08-11 04:35:08 Arapahoe, Colorado, US
274164 2020-08-10 US Colorado Archuleta 8007 36 0 0 36 37.19474156 -107.04768670000001 2020-08-11 04:35:08 Archuleta, Colorado, US
274199 2020-08-10 US Colorado Baca 8009 15 0 0 15 37.31940883 -102.5603223 2020-08-11 04:35:08 Baca, Colorado, US
274268 2020-08-10 US Colorado Bent 8011 9 0 0 9 37.95474293 -103.0720195 2020-08-11 04:35:08 Bent, Colorado, US
274333 2020-08-10 US Colorado Boulder 8013 2059 74 0 1985 40.09313619 -105.3546767 2020-08-11 04:35:08 Boulder, Colorado, US
274369 2020-08-10 US Colorado Broomfield 8014 475 32 0 443 39.95998787 -105.0566324 2020-08-11 04:35:08 Broomfield, Colorado, US
274534 2020-08-10 US Colorado Chaffee 8015 303 19 0 284 38.74745778 -106.19265729999998 2020-08-11 04:35:08 Chaffee, Colorado, US
274579 2020-08-10 US Colorado Cheyenne 8017 9 0 0 9 38.82777431 -102.6032558 2020-08-11 04:35:08 Cheyenne, Colorado, US
274652 2020-08-10 US Colorado Clear Creek 8019 30 1 0 29 39.68864463 -105.6463118 2020-08-11 04:35:08 Clear Creek, Colorado, US
274719 2020-08-10 US Colorado Conejos 8021 23 0 0 23 37.201606 -106.19174879999998 2020-08-11 04:35:08 Conejos, Colorado, US
274737 2020-08-10 US Colorado Costilla 8023 23 0 0 23 37.27732493 -105.4276548 2020-08-11 04:35:08 Costilla, Colorado, US
274775 2020-08-10 US Colorado Crowley 8025 72 1 0 71 38.32608609 -103.7844965 2020-08-11 04:35:08 Crowley, Colorado, US
274792 2020-08-10 US Colorado Custer 8027 11 0 0 11 38.10883162 -105.3683478 2020-08-11 04:35:08 Custer, Colorado, US
274860 2020-08-10 US Colorado Delta 8029 125 1 0 124 38.86246243 -107.86313419999999 2020-08-11 04:35:08 Delta, Colorado, US
274866 2020-08-10 US Colorado Denver 8031 10263 415 0 9848 39.76018276 -104.87256950000001 2020-08-11 04:35:08 Denver, Colorado, US
274894 2020-08-10 US Colorado Dolores 8033 1 0 0 1 37.75208676 -108.5211585 2020-08-11 04:35:08 Dolores, Colorado, US
274904 2020-08-10 US Colorado Douglas 8035 1744 59 0 1685 39.33133796 -104.930001 2020-08-11 04:35:08 Douglas, Colorado, US
274931 2020-08-10 US Colorado Eagle 8037 1124 9 0 1115 39.62754308 -106.6933637 2020-08-11 04:35:08 Eagle, Colorado, US
274954 2020-08-10 US Colorado El Paso 8041 5134 138 0 4996 38.83240149 -104.5251411 2020-08-11 04:35:08 El Paso, Colorado, US
274956 2020-08-10 US Colorado Elbert 8039 105 2 0 103 39.28656773 -104.13587209999999 2020-08-11 04:35:08 Elbert, Colorado, US
275083 2020-08-10 US Colorado Fremont 8043 125 0 0 125 38.47362326 -105.43996670000001 2020-08-11 04:35:08 Fremont, Colorado, US
275109 2020-08-10 US Colorado Garfield 8045 768 4 0 764 39.59921777 -107.902708 2020-08-11 04:35:08 Garfield, Colorado, US
275141 2020-08-10 US Colorado Gilpin 8047 16 0 0 16 39.85646523 -105.5252597 2020-08-11 04:35:08 Gilpin, Colorado, US
275170 2020-08-10 US Colorado Grand 8049 46 1 0 45 40.10603347 -106.11780420000001 2020-08-11 04:35:08 Grand, Colorado, US
275244 2020-08-10 US Colorado Gunnison 8051 273 6 0 267 38.66611652 -107.0320729 2020-08-11 04:35:08 Gunnison, Colorado, US
275375 2020-08-10 US Colorado Hinsdale 8053 3 0 0 3 37.82247444 -107.3004345 2020-08-11 04:35:08 Hinsdale, Colorado, US
275414 2020-08-10 US Colorado Huerfano 8055 8 1 0 7 37.68473101 -104.9612585 2020-08-11 04:35:08 Huerfano, Colorado, US
275466 2020-08-10 US Colorado Jackson 8057 9 0 0 9 40.66593870000001 -106.3408905 2020-08-11 04:35:08 Jackson, Colorado, US
275503 2020-08-10 US Colorado Jefferson 8059 4210 228 0 3982 39.58635604 -105.2517692 2020-08-11 04:35:08 Jefferson, Colorado, US
275617 2020-08-10 US Colorado Kit Carson 8063 56 3 0 53 39.30497777 -102.60221990000001 2020-08-11 04:35:08 Kit Carson, Colorado, US
275642 2020-08-10 US Colorado La Plata 8067 219 2 0 217 37.28632032 -107.8429014 2020-08-11 04:35:08 La Plata, Colorado, US
275662 2020-08-10 US Colorado Lake 8065 79 0 0 79 39.20278823 -106.35556969999999 2020-08-11 04:35:08 Lake, Colorado, US
275693 2020-08-10 US Colorado Larimer 8069 1575 35 0 1540 40.66671597 -105.4625784 2020-08-11 04:35:08 Larimer, Colorado, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
                ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
                ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
                ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
                ON [johns_hopkins_csse_daily_reports] ([combined_key]);
Powered by Datasette · Query took 1922.836ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette