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

37,634 rows where province_or_state = "Colorado" sorted by day descending

✎ View and edit SQL

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

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

province_or_state

  • Colorado · 37,634 ✖

country_or_region

  • US 37,634
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
32880 32880 2021-10-23 US Colorado Adams 8001 74660 829 0   39.87432092 -104.3362578 2021-10-24 04:21:22 Adams, Colorado, US
32881 32881 2021-10-23 US Colorado Alamosa 8003 2408 44 0   37.57250606 -105.7885451 2021-10-24 04:21:22 Alamosa, Colorado, US
32882 32882 2021-10-23 US Colorado Arapahoe 8005 78521 840 0   39.64977461 -104.3353617 2021-10-24 04:21:22 Arapahoe, Colorado, US
32883 32883 2021-10-23 US Colorado Archuleta 8007 1469 4 0   37.19474156 -107.04768670000001 2021-10-24 04:21:22 Archuleta, Colorado, US
32884 32884 2021-10-23 US Colorado Baca 8009 437 5 0   37.31940883 -102.5603223 2021-10-24 04:21:22 Baca, Colorado, US
32885 32885 2021-10-23 US Colorado Bent 8011 1704 26 0   37.95474293 -103.0720195 2021-10-24 04:21:22 Bent, Colorado, US
32886 32886 2021-10-23 US Colorado Boulder 8013 30369 250 0   40.09313619 -105.3546767 2021-10-24 04:21:22 Boulder, Colorado, US
32887 32887 2021-10-23 US Colorado Broomfield 8014 6584 81 0   39.95998787 -105.0566324 2021-10-24 04:21:22 Broomfield, Colorado, US
32888 32888 2021-10-23 US Colorado Chaffee 8015 2241 30 0   38.74745778 -106.19265729999998 2021-10-24 04:21:22 Chaffee, Colorado, US
32889 32889 2021-10-23 US Colorado Cheyenne 8017 181 7 0   38.82777431 -102.6032558 2021-10-24 04:21:22 Cheyenne, Colorado, US
32890 32890 2021-10-23 US Colorado Clear Creek 8019 762 5 0   39.68864463 -105.6463118 2021-10-24 04:21:22 Clear Creek, Colorado, US
32891 32891 2021-10-23 US Colorado Conejos 8021 983 33 0   37.201606 -106.19174879999998 2021-10-24 04:21:22 Conejos, Colorado, US
32892 32892 2021-10-23 US Colorado Costilla 8023 379 10 0   37.27732493 -105.4276548 2021-10-24 04:21:22 Costilla, Colorado, US
32893 32893 2021-10-23 US Colorado Crowley 8025 2378 22 0   38.32608609 -103.7844965 2021-10-24 04:21:22 Crowley, Colorado, US
32894 32894 2021-10-23 US Colorado Custer 8027 358 7 0   38.10883162 -105.3683478 2021-10-24 04:21:22 Custer, Colorado, US
32895 32895 2021-10-23 US Colorado Delta 8029 3907 82 0   38.86246243 -107.86313419999999 2021-10-24 04:21:22 Delta, Colorado, US
32896 32896 2021-10-23 US Colorado Denver 8031 90270 929 0   39.76018276 -104.87256950000001 2021-10-24 04:21:22 Denver, Colorado, US
32897 32897 2021-10-23 US Colorado Dolores 8033 235 2 0   37.75208676 -108.5211585 2021-10-24 04:21:22 Dolores, Colorado, US
32898 32898 2021-10-23 US Colorado Douglas 8035 39740 296 0   39.33133796 -104.930001 2021-10-24 04:21:22 Douglas, Colorado, US
32899 32899 2021-10-23 US Colorado Eagle 8037 8268 31 0   39.62754308 -106.6933637 2021-10-24 04:21:22 Eagle, Colorado, US
32900 32900 2021-10-23 US Colorado El Paso 8041 99562 1092 0   38.83240149 -104.5251411 2021-10-24 04:21:22 El Paso, Colorado, US
32901 32901 2021-10-23 US Colorado Elbert 8039 2684 23 0   39.28656773 -104.13587209999999 2021-10-24 04:21:22 Elbert, Colorado, US
32902 32902 2021-10-23 US Colorado Fremont 8043 8334 89 0   38.47362326 -105.43996670000001 2021-10-24 04:21:22 Fremont, Colorado, US
32903 32903 2021-10-23 US Colorado Garfield 8045 7800 60 0   39.59921777 -107.902708 2021-10-24 04:21:22 Garfield, Colorado, US
32904 32904 2021-10-23 US Colorado Gilpin 8047 432 3 0   39.85646523 -105.5252597 2021-10-24 04:21:22 Gilpin, Colorado, US
32905 32905 2021-10-23 US Colorado Grand 8049 2144 16 0   40.10603347 -106.11780420000001 2021-10-24 04:21:22 Grand, Colorado, US
32906 32906 2021-10-23 US Colorado Gunnison 8051 1817 12 0   38.66611652 -107.0320729 2021-10-24 04:21:22 Gunnison, Colorado, US
32907 32907 2021-10-23 US Colorado Hinsdale 8053 56 0 0   37.82247444 -107.3004345 2021-10-24 04:21:22 Hinsdale, Colorado, US
32908 32908 2021-10-23 US Colorado Huerfano 8055 622 19 0   37.68473101 -104.9612585 2021-10-24 04:21:22 Huerfano, Colorado, US
32909 32909 2021-10-23 US Colorado Jackson 8057 111 0 0   40.66593870000001 -106.3408905 2021-10-24 04:21:22 Jackson, Colorado, US
32910 32910 2021-10-23 US Colorado Jefferson 8059 62065 903 0   39.58635604 -105.2517692 2021-10-24 04:21:22 Jefferson, Colorado, US
32911 32911 2021-10-23 US Colorado Kiowa 8061 205 4 0   38.43260896 -102.7392145 2021-10-24 04:21:22 Kiowa, Colorado, US
32912 32912 2021-10-23 US Colorado Kit Carson 8063 974 15 0   39.30497777 -102.60221990000001 2021-10-24 04:21:22 Kit Carson, Colorado, US
32913 32913 2021-10-23 US Colorado La Plata 8067 5696 52 0   37.28632032 -107.8429014 2021-10-24 04:21:22 La Plata, Colorado, US
32914 32914 2021-10-23 US Colorado Lake 8065 1023 1 0   39.20278823 -106.35556969999999 2021-10-24 04:21:22 Lake, Colorado, US
32915 32915 2021-10-23 US Colorado Larimer 8069 38435 303 0   40.66671597 -105.4625784 2021-10-24 04:21:22 Larimer, Colorado, US
32916 32916 2021-10-23 US Colorado Las Animas 8071 1801 22 0   37.3153406 -104.03764579999999 2021-10-24 04:21:22 Las Animas, Colorado, US
32917 32917 2021-10-23 US Colorado Lincoln 8073 1311 8 0   38.98749519 -103.51366490000001 2021-10-24 04:21:22 Lincoln, Colorado, US
32918 32918 2021-10-23 US Colorado Logan 8075 4663 80 0   40.7249637 -103.110817 2021-10-24 04:21:22 Logan, Colorado, US
32919 32919 2021-10-23 US Colorado Mesa 8077 23575 324 0   39.01787888 -108.469799 2021-10-24 04:21:22 Mesa, Colorado, US
32920 32920 2021-10-23 US Colorado Mineral 8079 128 1 0   37.66954283 -106.92816979999999 2021-10-24 04:21:22 Mineral, Colorado, US
32921 32921 2021-10-23 US Colorado Moffat 8081 1948 40 0   40.61810999 -108.2070876 2021-10-24 04:21:22 Moffat, Colorado, US
32922 32922 2021-10-23 US Colorado Montezuma 8083 3095 37 0   37.33859579 -108.59588570000001 2021-10-24 04:21:22 Montezuma, Colorado, US
32923 32923 2021-10-23 US Colorado Montrose 8085 5319 84 0   38.40214114 -108.26390220000002 2021-10-24 04:21:22 Montrose, Colorado, US
32924 32924 2021-10-23 US Colorado Morgan 8087 3375 99 0   40.26279810000001 -103.8093302 2021-10-24 04:21:22 Morgan, Colorado, US
32925 32925 2021-10-23 US Colorado Otero 8089 2628 80 0   37.9014485 -103.7173385 2021-10-24 04:21:22 Otero, Colorado, US
32926 32926 2021-10-23 US Colorado Ouray 8091 444 5 0   38.14717457 -107.7675136 2021-10-24 04:21:22 Ouray, Colorado, US
32927 32927 2021-10-23 US Colorado Out of CO 80008 0 0 0   40.87595412 0.0 2021-10-24 04:21:22 Out of CO, Colorado, US
32928 32928 2021-10-23 US Colorado Park 8093 1385 8 0   39.120926000000004 -105.7182065 2021-10-24 04:21:22 Park, Colorado, US
32929 32929 2021-10-23 US Colorado Phillips 8095 516 14 0   40.59414277 -102.3577703 2021-10-24 04:21:22 Phillips, Colorado, US
32930 32930 2021-10-23 US Colorado Pitkin 8097 3111 5 0   39.21720112 -106.9310027 2021-10-24 04:21:22 Pitkin, Colorado, US
32931 32931 2021-10-23 US Colorado Prowers 8099 1628 30 0   37.95544985 -102.3926052 2021-10-24 04:21:22 Prowers, Colorado, US
32932 32932 2021-10-23 US Colorado Pueblo 8101 24665 483 0   38.17359144 -104.5127437 2021-10-24 04:21:22 Pueblo, Colorado, US
32933 32933 2021-10-23 US Colorado Rio Blanco 8103 969 8 0   39.97913541 -108.2179009 2021-10-24 04:21:22 Rio Blanco, Colorado, US
32934 32934 2021-10-23 US Colorado Rio Grande 8105 1477 22 0   37.5836865 -106.3847838 2021-10-24 04:21:22 Rio Grande, Colorado, US
32935 32935 2021-10-23 US Colorado Routt 8107 3322 23 0   40.48596505 -106.9905548 2021-10-24 04:21:22 Routt, Colorado, US
32936 32936 2021-10-23 US Colorado Saguache 8109 671 8 0   38.08054629 -106.28246599999999 2021-10-24 04:21:22 Saguache, Colorado, US
32937 32937 2021-10-23 US Colorado San Juan 8111 95 1 0   37.76248981 -107.67632890000002 2021-10-24 04:21:22 San Juan, Colorado, US
32938 32938 2021-10-23 US Colorado San Miguel 8113 1171 4 0   38.00450883 -108.4020725 2021-10-24 04:21:22 San Miguel, Colorado, US
32939 32939 2021-10-23 US Colorado Sedgwick 8115 314 4 0   40.87595412 -102.3519227 2021-10-24 04:21:22 Sedgwick, Colorado, US
32940 32940 2021-10-23 US Colorado Summit 8117 4747 11 0   39.63803232 -106.1150762 2021-10-24 04:21:22 Summit, Colorado, US
32941 32941 2021-10-23 US Colorado Teller 8119 2807 27 0   38.88133511 -105.16148929999999 2021-10-24 04:21:22 Teller, Colorado, US
32942 32942 2021-10-23 US Colorado Unassigned 90008 100 0 0   40.87595412 0.0 2021-10-24 04:21:22 Unassigned, Colorado, US
32943 32943 2021-10-23 US Colorado Washington 8121 655 18 0   39.97015535 -103.202587 2021-10-24 04:21:22 Washington, Colorado, US
32944 32944 2021-10-23 US Colorado Weld 8123 45666 440 0   40.55499405 -104.39296209999999 2021-10-24 04:21:22 Weld, Colorado, US
32945 32945 2021-10-23 US Colorado Yuma 8125 1220 18 0   40.00346839 -102.4258673 2021-10-24 04:21:22 Yuma, Colorado, US
313364 313364 2021-10-22 US Colorado Adams 8001 74660 829 0   39.87432092 -104.3362578 2021-10-23 04:21:32 Adams, Colorado, US
313365 313365 2021-10-22 US Colorado Alamosa 8003 2408 44 0   37.57250606 -105.7885451 2021-10-23 04:21:32 Alamosa, Colorado, US
313366 313366 2021-10-22 US Colorado Arapahoe 8005 78521 840 0   39.64977461 -104.3353617 2021-10-23 04:21:32 Arapahoe, Colorado, US
313367 313367 2021-10-22 US Colorado Archuleta 8007 1469 4 0   37.19474156 -107.04768670000001 2021-10-23 04:21:32 Archuleta, Colorado, US
313368 313368 2021-10-22 US Colorado Baca 8009 437 5 0   37.31940883 -102.5603223 2021-10-23 04:21:32 Baca, Colorado, US
313369 313369 2021-10-22 US Colorado Bent 8011 1704 26 0   37.95474293 -103.0720195 2021-10-23 04:21:32 Bent, Colorado, US
313370 313370 2021-10-22 US Colorado Boulder 8013 30369 250 0   40.09313619 -105.3546767 2021-10-23 04:21:32 Boulder, Colorado, US
313371 313371 2021-10-22 US Colorado Broomfield 8014 6584 81 0   39.95998787 -105.0566324 2021-10-23 04:21:32 Broomfield, Colorado, US
313372 313372 2021-10-22 US Colorado Chaffee 8015 2241 30 0   38.74745778 -106.19265729999998 2021-10-23 04:21:32 Chaffee, Colorado, US
313373 313373 2021-10-22 US Colorado Cheyenne 8017 181 7 0   38.82777431 -102.6032558 2021-10-23 04:21:32 Cheyenne, Colorado, US
313374 313374 2021-10-22 US Colorado Clear Creek 8019 762 5 0   39.68864463 -105.6463118 2021-10-23 04:21:32 Clear Creek, Colorado, US
313375 313375 2021-10-22 US Colorado Conejos 8021 983 33 0   37.201606 -106.19174879999998 2021-10-23 04:21:32 Conejos, Colorado, US
313376 313376 2021-10-22 US Colorado Costilla 8023 379 10 0   37.27732493 -105.4276548 2021-10-23 04:21:32 Costilla, Colorado, US
313377 313377 2021-10-22 US Colorado Crowley 8025 2378 22 0   38.32608609 -103.7844965 2021-10-23 04:21:32 Crowley, Colorado, US
313378 313378 2021-10-22 US Colorado Custer 8027 358 7 0   38.10883162 -105.3683478 2021-10-23 04:21:32 Custer, Colorado, US
313379 313379 2021-10-22 US Colorado Delta 8029 3907 82 0   38.86246243 -107.86313419999999 2021-10-23 04:21:32 Delta, Colorado, US
313380 313380 2021-10-22 US Colorado Denver 8031 90270 929 0   39.76018276 -104.87256950000001 2021-10-23 04:21:32 Denver, Colorado, US
313381 313381 2021-10-22 US Colorado Dolores 8033 235 2 0   37.75208676 -108.5211585 2021-10-23 04:21:32 Dolores, Colorado, US
313382 313382 2021-10-22 US Colorado Douglas 8035 39740 296 0   39.33133796 -104.930001 2021-10-23 04:21:32 Douglas, Colorado, US
313383 313383 2021-10-22 US Colorado Eagle 8037 8268 31 0   39.62754308 -106.6933637 2021-10-23 04:21:32 Eagle, Colorado, US
313384 313384 2021-10-22 US Colorado El Paso 8041 99562 1092 0   38.83240149 -104.5251411 2021-10-23 04:21:32 El Paso, Colorado, US
313385 313385 2021-10-22 US Colorado Elbert 8039 2684 23 0   39.28656773 -104.13587209999999 2021-10-23 04:21:32 Elbert, Colorado, US
313386 313386 2021-10-22 US Colorado Fremont 8043 8334 89 0   38.47362326 -105.43996670000001 2021-10-23 04:21:32 Fremont, Colorado, US
313387 313387 2021-10-22 US Colorado Garfield 8045 7800 60 0   39.59921777 -107.902708 2021-10-23 04:21:32 Garfield, Colorado, US
313388 313388 2021-10-22 US Colorado Gilpin 8047 432 3 0   39.85646523 -105.5252597 2021-10-23 04:21:32 Gilpin, Colorado, US
313389 313389 2021-10-22 US Colorado Grand 8049 2144 16 0   40.10603347 -106.11780420000001 2021-10-23 04:21:32 Grand, Colorado, US
313390 313390 2021-10-22 US Colorado Gunnison 8051 1817 12 0   38.66611652 -107.0320729 2021-10-23 04:21:32 Gunnison, Colorado, US
313391 313391 2021-10-22 US Colorado Hinsdale 8053 56 0 0   37.82247444 -107.3004345 2021-10-23 04:21:32 Hinsdale, Colorado, US
313392 313392 2021-10-22 US Colorado Huerfano 8055 622 19 0   37.68473101 -104.9612585 2021-10-23 04:21:32 Huerfano, Colorado, US
313393 313393 2021-10-22 US Colorado Jackson 8057 111 0 0   40.66593870000001 -106.3408905 2021-10-23 04:21:32 Jackson, Colorado, US
313394 313394 2021-10-22 US Colorado Jefferson 8059 62065 903 0   39.58635604 -105.2517692 2021-10-23 04:21:32 Jefferson, Colorado, US
313395 313395 2021-10-22 US Colorado Kiowa 8061 205 4 0   38.43260896 -102.7392145 2021-10-23 04:21:32 Kiowa, Colorado, US
313396 313396 2021-10-22 US Colorado Kit Carson 8063 974 15 0   39.30497777 -102.60221990000001 2021-10-23 04:21:32 Kit Carson, Colorado, US
313397 313397 2021-10-22 US Colorado La Plata 8067 5696 52 0   37.28632032 -107.8429014 2021-10-23 04:21:32 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]);