johns_hopkins_csse_daily_reports

Table actions
⚠️ 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

22,322 rows where province_or_state = "Colorado" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state

  • Colorado · 22,322 ✖

country_or_region

  • US 22,322
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
953911 953911 2021-03-05 US Colorado Adams 8001 49045 615 0 48430 39.87432092 -104.3362578 2021-03-06 04:23:41 Adams, Colorado, US
953912 953912 2021-03-05 US Colorado Alamosa 8003 1308 29 0 1279 37.57250606 -105.7885451 2021-03-06 04:23:41 Alamosa, Colorado, US
953913 953913 2021-03-05 US Colorado Arapahoe 8005 49139 657 0 48482 39.64977461 -104.3353617 2021-03-06 04:23:41 Arapahoe, Colorado, US
953914 953914 2021-03-05 US Colorado Archuleta 8007 674 1 0 673 37.19474156 -107.0476867 2021-03-06 04:23:41 Archuleta, Colorado, US
953915 953915 2021-03-05 US Colorado Baca 8009 273 4 0 269 37.31940883 -102.5603223 2021-03-06 04:23:41 Baca, Colorado, US
953916 953916 2021-03-05 US Colorado Bent 8011 1481 21 0 1460 37.95474293 -103.0720195 2021-03-06 04:23:41 Bent, Colorado, US
953917 953917 2021-03-05 US Colorado Boulder 8013 19098 227 0 18871 40.09313619 -105.3546767 2021-03-06 04:23:41 Boulder, Colorado, US
953918 953918 2021-03-05 US Colorado Broomfield 8014 3839 74 0 3765 39.95998787 -105.0566324 2021-03-06 04:23:41 Broomfield, Colorado, US
953919 953919 2021-03-05 US Colorado Chaffee 8015 1463 24 0 1439 38.74745778 -106.19265729999998 2021-03-06 04:23:41 Chaffee, Colorado, US
953920 953920 2021-03-05 US Colorado Cheyenne 8017 125 5 0 120 38.82777431 -102.6032558 2021-03-06 04:23:41 Cheyenne, Colorado, US
953921 953921 2021-03-05 US Colorado Clear Creek 8019 368 2 0 366 39.68864463 -105.6463118 2021-03-06 04:23:41 Clear Creek, Colorado, US
953922 953922 2021-03-05 US Colorado Conejos 8021 446 9 0 437 37.201606 -106.19174879999998 2021-03-06 04:23:41 Conejos, Colorado, US
953923 953923 2021-03-05 US Colorado Costilla 8023 191 2 0 189 37.27732493 -105.4276548 2021-03-06 04:23:41 Costilla, Colorado, US
953924 953924 2021-03-05 US Colorado Crowley 8025 2072 14 0 2058 38.32608609 -103.7844965 2021-03-06 04:23:41 Crowley, Colorado, US
953925 953925 2021-03-05 US Colorado Custer 8027 164 1 0 163 38.10883162 -105.3683478 2021-03-06 04:23:41 Custer, Colorado, US
953926 953926 2021-03-05 US Colorado Delta 8029 2483 60 0 2423 38.86246243 -107.8631342 2021-03-06 04:23:41 Delta, Colorado, US
953927 953927 2021-03-05 US Colorado Denver 8031 60389 765 0 59624 39.76018276 -104.8725695 2021-03-06 04:23:41 Denver, Colorado, US
953928 953928 2021-03-05 US Colorado Dolores 8033 69 0 0 69 37.75208676 -108.5211585 2021-03-06 04:23:41 Dolores, Colorado, US
953929 953929 2021-03-05 US Colorado Douglas 8035 21786 223 0 21563 39.33133796 -104.930001 2021-03-06 04:23:41 Douglas, Colorado, US
953930 953930 2021-03-05 US Colorado Eagle 8037 5198 21 0 5177 39.62754308 -106.6933637 2021-03-06 04:23:41 Eagle, Colorado, US
953931 953931 2021-03-05 US Colorado El Paso 8041 52787 748 0 52039 38.83240149 -104.5251411 2021-03-06 04:23:41 El Paso, Colorado, US
953932 953932 2021-03-05 US Colorado Elbert 8039 1296 12 0 1284 39.28656773 -104.1358721 2021-03-06 04:23:41 Elbert, Colorado, US
953933 953933 2021-03-05 US Colorado Fremont 8043 5505 51 0 5454 38.47362326 -105.4399667 2021-03-06 04:23:41 Fremont, Colorado, US
953934 953934 2021-03-05 US Colorado Garfield 8045 5132 39 0 5093 39.59921777 -107.902708 2021-03-06 04:23:41 Garfield, Colorado, US
953935 953935 2021-03-05 US Colorado Gilpin 8047 170 3 0 167 39.85646523 -105.5252597 2021-03-06 04:23:41 Gilpin, Colorado, US
953936 953936 2021-03-05 US Colorado Grand 8049 1287 5 0 1282 40.10603347 -106.1178042 2021-03-06 04:23:41 Grand, Colorado, US
953937 953937 2021-03-05 US Colorado Gunnison 8051 1211 6 0 1205 38.66611652 -107.0320729 2021-03-06 04:23:41 Gunnison, Colorado, US
953938 953938 2021-03-05 US Colorado Hinsdale 8053 16 0 0 16 37.82247444 -107.3004345 2021-03-06 04:23:41 Hinsdale, Colorado, US
953939 953939 2021-03-05 US Colorado Huerfano 8055 314 16 0 298 37.68473101 -104.9612585 2021-03-06 04:23:41 Huerfano, Colorado, US
953940 953940 2021-03-05 US Colorado Jackson 8057 51 0 0 51 40.66593870000001 -106.3408905 2021-03-06 04:23:41 Jackson, Colorado, US
953941 953941 2021-03-05 US Colorado Jefferson 8059 37809 729 0 37080 39.58635604 -105.2517692 2021-03-06 04:23:41 Jefferson, Colorado, US
953942 953942 2021-03-05 US Colorado Kiowa 8061 91 3 0 88 38.43260896 -102.7392145 2021-03-06 04:23:41 Kiowa, Colorado, US
953943 953943 2021-03-05 US Colorado Kit Carson 8063 545 10 0 535 39.30497777 -102.6022199 2021-03-06 04:23:41 Kit Carson, Colorado, US
953944 953944 2021-03-05 US Colorado La Plata 8067 3016 37 0 2979 37.28632032 -107.8429014 2021-03-06 04:23:41 La Plata, Colorado, US
953945 953945 2021-03-05 US Colorado Lake 8065 661 0 0 661 39.20278823 -106.3555697 2021-03-06 04:23:41 Lake, Colorado, US
953946 953946 2021-03-05 US Colorado Larimer 8069 20441 225 0 20216 40.66671597 -105.4625784 2021-03-06 04:23:41 Larimer, Colorado, US
953947 953947 2021-03-05 US Colorado Las Animas 8071 1004 11 0 993 37.3153406 -104.0376458 2021-03-06 04:23:41 Las Animas, Colorado, US
953948 953948 2021-03-05 US Colorado Lincoln 8073 999 3 0 996 38.98749519 -103.5136649 2021-03-06 04:23:41 Lincoln, Colorado, US
953949 953949 2021-03-05 US Colorado Logan 8075 3751 65 0 3686 40.7249637 -103.110817 2021-03-06 04:23:41 Logan, Colorado, US
953950 953950 2021-03-05 US Colorado Mesa 8077 13443 200 0 13243 39.01787888 -108.469799 2021-03-06 04:23:41 Mesa, Colorado, US
953951 953951 2021-03-05 US Colorado Mineral 8079 69 1 0 68 37.66954283 -106.9281698 2021-03-06 04:23:41 Mineral, Colorado, US
953952 953952 2021-03-05 US Colorado Moffat 8081 681 22 0 659 40.61810999 -108.2070876 2021-03-06 04:23:41 Moffat, Colorado, US
953953 953953 2021-03-05 US Colorado Montezuma 8083 1735 22 0 1713 37.33859579 -108.5958857 2021-03-06 04:23:41 Montezuma, Colorado, US
953954 953954 2021-03-05 US Colorado Montrose 8085 3272 53 0 3219 38.40214114 -108.26390220000002 2021-03-06 04:23:41 Montrose, Colorado, US
953955 953955 2021-03-05 US Colorado Morgan 8087 2446 90 0 2356 40.26279810000001 -103.8093302 2021-03-06 04:23:41 Morgan, Colorado, US
953956 953956 2021-03-05 US Colorado Otero 8089 1864 63 0 1801 37.9014485 -103.7173385 2021-03-06 04:23:41 Otero, Colorado, US
953957 953957 2021-03-05 US Colorado Ouray 8091 260 3 0 257 38.14717457 -107.7675136 2021-03-06 04:23:41 Ouray, Colorado, US
953958 953958 2021-03-05 US Colorado Out of CO 80008 0 0 0 0 40.87595412 0.0 2021-03-06 04:23:41 Out of CO, Colorado, US
953959 953959 2021-03-05 US Colorado Park 8093 560 5 0 555 39.120926 -105.7182065 2021-03-06 04:23:41 Park, Colorado, US
953960 953960 2021-03-05 US Colorado Phillips 8095 340 12 0 328 40.59414277 -102.3577703 2021-03-06 04:23:41 Phillips, Colorado, US
953961 953961 2021-03-05 US Colorado Pitkin 8097 2071 4 0 2067 39.21720112 -106.9310027 2021-03-06 04:23:41 Pitkin, Colorado, US
953962 953962 2021-03-05 US Colorado Prowers 8099 1162 21 0 1141 37.95544985 -102.3926052 2021-03-06 04:23:41 Prowers, Colorado, US
953963 953963 2021-03-05 US Colorado Pueblo 8101 15167 363 0 14804 38.17359144 -104.5127437 2021-03-06 04:23:41 Pueblo, Colorado, US
953964 953964 2021-03-05 US Colorado Rio Blanco 8103 482 3 0 479 39.97913541 -108.2179009 2021-03-06 04:23:41 Rio Blanco, Colorado, US
953965 953965 2021-03-05 US Colorado Rio Grande 8105 715 13 0 702 37.5836865 -106.3847838 2021-03-06 04:23:41 Rio Grande, Colorado, US
953966 953966 2021-03-05 US Colorado Routt 8107 1923 19 0 1904 40.48596505 -106.9905548 2021-03-06 04:23:41 Routt, Colorado, US
953967 953967 2021-03-05 US Colorado Saguache 8109 326 4 0 322 38.08054629 -106.282466 2021-03-06 04:23:41 Saguache, Colorado, US
953968 953968 2021-03-05 US Colorado San Juan 8111 43 0 0 43 37.76248981 -107.67632890000002 2021-03-06 04:23:41 San Juan, Colorado, US
953969 953969 2021-03-05 US Colorado San Miguel 8113 824 0 0 824 38.00450883 -108.4020725 2021-03-06 04:23:41 San Miguel, Colorado, US
953970 953970 2021-03-05 US Colorado Sedgwick 8115 191 2 0 189 40.87595412 -102.3519227 2021-03-06 04:23:41 Sedgwick, Colorado, US
953971 953971 2021-03-05 US Colorado Summit 8117 3073 7 0 3066 39.63803232 -106.1150762 2021-03-06 04:23:41 Summit, Colorado, US
953972 953972 2021-03-05 US Colorado Teller 8119 1286 14 0 1272 38.88133511 -105.1614893 2021-03-06 04:23:41 Teller, Colorado, US
953973 953973 2021-03-05 US Colorado Unassigned 90008 51 0 0 51 40.87595412 0.0 2021-03-06 04:23:41 Unassigned, Colorado, US
953974 953974 2021-03-05 US Colorado Washington 8121 396 12 0 384 39.97015535 -103.202587 2021-03-06 04:23:41 Washington, Colorado, US
953975 953975 2021-03-05 US Colorado Weld 8123 25856 319 0 25537 40.55499405 -104.3929621 2021-03-06 04:23:41 Weld, Colorado, US
953976 953976 2021-03-05 US Colorado Yuma 8125 721 17 0 704 40.00346839 -102.4258673 2021-03-06 04:23:41 Yuma, Colorado, US
901271 901271 2021-03-04 US Colorado Adams 8001 48876 615 0 48261 39.87432092 -104.3362578 2021-03-05 05:26:29 Adams, Colorado, US
901272 901272 2021-03-04 US Colorado Alamosa 8003 1304 28 0 1276 37.57250606 -105.7885451 2021-03-05 05:26:29 Alamosa, Colorado, US
901273 901273 2021-03-04 US Colorado Arapahoe 8005 48927 654 0 48273 39.64977461 -104.3353617 2021-03-05 05:26:29 Arapahoe, Colorado, US
901274 901274 2021-03-04 US Colorado Archuleta 8007 668 1 0 667 37.19474156 -107.0476867 2021-03-05 05:26:29 Archuleta, Colorado, US
901275 901275 2021-03-04 US Colorado Baca 8009 273 4 0 269 37.31940883 -102.5603223 2021-03-05 05:26:29 Baca, Colorado, US
901276 901276 2021-03-04 US Colorado Bent 8011 1481 21 0 1460 37.95474293 -103.0720195 2021-03-05 05:26:29 Bent, Colorado, US
901277 901277 2021-03-04 US Colorado Boulder 8013 19039 225 0 18814 40.09313619 -105.3546767 2021-03-05 05:26:29 Boulder, Colorado, US
901278 901278 2021-03-04 US Colorado Broomfield 8014 3811 74 0 3737 39.95998787 -105.0566324 2021-03-05 05:26:29 Broomfield, Colorado, US
901279 901279 2021-03-04 US Colorado Chaffee 8015 1463 24 0 1439 38.74745778 -106.19265729999998 2021-03-05 05:26:29 Chaffee, Colorado, US
901280 901280 2021-03-04 US Colorado Cheyenne 8017 125 5 0 120 38.82777431 -102.6032558 2021-03-05 05:26:29 Cheyenne, Colorado, US
901281 901281 2021-03-04 US Colorado Clear Creek 8019 368 2 0 366 39.68864463 -105.6463118 2021-03-05 05:26:29 Clear Creek, Colorado, US
901282 901282 2021-03-04 US Colorado Conejos 8021 446 9 0 437 37.201606 -106.19174879999998 2021-03-05 05:26:29 Conejos, Colorado, US
901283 901283 2021-03-04 US Colorado Costilla 8023 191 2 0 189 37.27732493 -105.4276548 2021-03-05 05:26:29 Costilla, Colorado, US
901284 901284 2021-03-04 US Colorado Crowley 8025 2052 14 0 2038 38.32608609 -103.7844965 2021-03-05 05:26:29 Crowley, Colorado, US
901285 901285 2021-03-04 US Colorado Custer 8027 164 1 0 163 38.10883162 -105.3683478 2021-03-05 05:26:29 Custer, Colorado, US
901286 901286 2021-03-04 US Colorado Delta 8029 2480 60 0 2420 38.86246243 -107.8631342 2021-03-05 05:26:29 Delta, Colorado, US
901287 901287 2021-03-04 US Colorado Denver 8031 60121 765 0 59356 39.76018276 -104.8725695 2021-03-05 05:26:29 Denver, Colorado, US
901288 901288 2021-03-04 US Colorado Dolores 8033 69 0 0 69 37.75208676 -108.5211585 2021-03-05 05:26:29 Dolores, Colorado, US
901289 901289 2021-03-04 US Colorado Douglas 8035 21648 223 0 21425 39.33133796 -104.930001 2021-03-05 05:26:29 Douglas, Colorado, US
901290 901290 2021-03-04 US Colorado Eagle 8037 5167 21 0 5146 39.62754308 -106.6933637 2021-03-05 05:26:29 Eagle, Colorado, US
901291 901291 2021-03-04 US Colorado El Paso 8041 52619 747 0 51872 38.83240149 -104.5251411 2021-03-05 05:26:29 El Paso, Colorado, US
901292 901292 2021-03-04 US Colorado Elbert 8039 1295 12 0 1283 39.28656773 -104.1358721 2021-03-05 05:26:29 Elbert, Colorado, US
901293 901293 2021-03-04 US Colorado Fremont 8043 5498 50 0 5448 38.47362326 -105.4399667 2021-03-05 05:26:29 Fremont, Colorado, US
901294 901294 2021-03-04 US Colorado Garfield 8045 5131 38 0 5093 39.59921777 -107.902708 2021-03-05 05:26:29 Garfield, Colorado, US
901295 901295 2021-03-04 US Colorado Gilpin 8047 168 3 0 165 39.85646523 -105.5252597 2021-03-05 05:26:29 Gilpin, Colorado, US
901296 901296 2021-03-04 US Colorado Grand 8049 1288 5 0 1283 40.10603347 -106.1178042 2021-03-05 05:26:29 Grand, Colorado, US
901297 901297 2021-03-04 US Colorado Gunnison 8051 1211 6 0 1205 38.66611652 -107.0320729 2021-03-05 05:26:29 Gunnison, Colorado, US
901298 901298 2021-03-04 US Colorado Hinsdale 8053 16 0 0 16 37.82247444 -107.3004345 2021-03-05 05:26:29 Hinsdale, Colorado, US
901299 901299 2021-03-04 US Colorado Huerfano 8055 314 16 0 298 37.68473101 -104.9612585 2021-03-05 05:26:29 Huerfano, Colorado, US
901300 901300 2021-03-04 US Colorado Jackson 8057 51 0 0 51 40.66593870000001 -106.3408905 2021-03-05 05:26:29 Jackson, Colorado, US
901301 901301 2021-03-04 US Colorado Jefferson 8059 37583 727 0 36856 39.58635604 -105.2517692 2021-03-05 05:26:29 Jefferson, Colorado, US
901302 901302 2021-03-04 US Colorado Kiowa 8061 91 3 0 88 38.43260896 -102.7392145 2021-03-05 05:26:29 Kiowa, Colorado, US
901303 901303 2021-03-04 US Colorado Kit Carson 8063 543 10 0 533 39.30497777 -102.6022199 2021-03-05 05:26:29 Kit Carson, Colorado, US
901304 901304 2021-03-04 US Colorado La Plata 8067 3009 37 0 2972 37.28632032 -107.8429014 2021-03-05 05:26:29 La Plata, 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]);