home / covid

Menu
  • GraphQL API

johns_hopkins_csse_daily_reports

Table actions
  • GraphQL API for 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

57,368 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 1

  • Colorado · 57,368 ✖

country_or_region 1

  • US 57,368
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
648177 648177 2022-08-18 US Colorado Adams 8001 154515 1364 0   39.87432092 -104.3362578 2022-08-19 04:20:54 Adams, Colorado, US
648178 648178 2022-08-18 US Colorado Alamosa 8003 5253 62 0   37.57250606 -105.7885451 2022-08-19 04:20:54 Alamosa, Colorado, US
648179 648179 2022-08-18 US Colorado Arapahoe 8005 181899 1259 0   39.64977461 -104.3353617 2022-08-19 04:20:54 Arapahoe, Colorado, US
648180 648180 2022-08-18 US Colorado Archuleta 8007 3219 17 0   37.19474156 -107.0476867 2022-08-19 04:20:54 Archuleta, Colorado, US
648181 648181 2022-08-18 US Colorado Baca 8009 938 14 0   37.31940883 -102.5603223 2022-08-19 04:20:54 Baca, Colorado, US
648182 648182 2022-08-18 US Colorado Bent 8011 2705 47 0   37.95474293 -103.0720195 2022-08-19 04:20:54 Bent, Colorado, US
648183 648183 2022-08-18 US Colorado Boulder 8013 82253 394 0   40.09313619 -105.3546767 2022-08-19 04:20:54 Boulder, Colorado, US
648184 648184 2022-08-18 US Colorado Broomfield 8014 16742 122 0   39.95998787 -105.0566324 2022-08-19 04:20:54 Broomfield, Colorado, US
648185 648185 2022-08-18 US Colorado Chaffee 8015 5305 52 0   38.74745778 -106.1926573 2022-08-19 04:20:54 Chaffee, Colorado, US
648186 648186 2022-08-18 US Colorado Cheyenne 8017 349 9 0   38.82777431 -102.6032558 2022-08-19 04:20:54 Cheyenne, Colorado, US
648187 648187 2022-08-18 US Colorado Clear Creek 8019 1820 12 0   39.68864463 -105.6463118 2022-08-19 04:20:54 Clear Creek, Colorado, US
648188 648188 2022-08-18 US Colorado Conejos 8021 2083 57 0   37.201606 -106.1917488 2022-08-19 04:20:54 Conejos, Colorado, US
648189 648189 2022-08-18 US Colorado Costilla 8023 850 19 0   37.27732493 -105.4276548 2022-08-19 04:20:54 Costilla, Colorado, US
648190 648190 2022-08-18 US Colorado Crowley 8025 3450 31 0   38.32608609 -103.7844965 2022-08-19 04:20:54 Crowley, Colorado, US
648191 648191 2022-08-18 US Colorado Custer 8027 763 22 0   38.10883162 -105.3683478 2022-08-19 04:20:54 Custer, Colorado, US
648192 648192 2022-08-18 US Colorado Delta 8029 6711 144 0   38.86246243 -107.8631342 2022-08-19 04:20:54 Delta, Colorado, US
648193 648193 2022-08-18 US Colorado Denver 8031 206977 1422 0   39.76018276 -104.8725695 2022-08-19 04:20:54 Denver, Colorado, US
648194 648194 2022-08-18 US Colorado Dolores 8033 384 8 0   37.75208676 -108.5211585 2022-08-19 04:20:54 Dolores, Colorado, US
648195 648195 2022-08-18 US Colorado Douglas 8035 93700 459 0   39.33133796 -104.930001 2022-08-19 04:20:54 Douglas, Colorado, US
648196 648196 2022-08-18 US Colorado Eagle 8037 17877 37 0   39.62754308 -106.6933637 2022-08-19 04:20:54 Eagle, Colorado, US
648197 648197 2022-08-18 US Colorado El Paso 8041 216991 1776 0   38.83240149 -104.5251411 2022-08-19 04:20:54 El Paso, Colorado, US
648198 648198 2022-08-18 US Colorado Elbert 8039 5445 44 0   39.28656773 -104.1358721 2022-08-19 04:20:54 Elbert, Colorado, US
648199 648199 2022-08-18 US Colorado Fremont 8043 17096 193 0   38.47362326 -105.4399667 2022-08-19 04:20:54 Fremont, Colorado, US
648200 648200 2022-08-18 US Colorado Garfield 8045 16863 97 0   39.59921777 -107.902708 2022-08-19 04:20:54 Garfield, Colorado, US
648201 648201 2022-08-18 US Colorado Gilpin 8047 1108 5 0   39.85646523 -105.5252597 2022-08-19 04:20:54 Gilpin, Colorado, US
648202 648202 2022-08-18 US Colorado Grand 8049 3836 28 0   40.10603347 -106.1178042 2022-08-19 04:20:54 Grand, Colorado, US
648203 648203 2022-08-18 US Colorado Gunnison 8051 3727 14 0   38.66611652 -107.0320729 2022-08-19 04:20:54 Gunnison, Colorado, US
648204 648204 2022-08-18 US Colorado Hinsdale 8053 153 0 0   37.82247444 -107.3004345 2022-08-19 04:20:54 Hinsdale, Colorado, US
648205 648205 2022-08-18 US Colorado Huerfano 8055 1645 38 0   37.68473101 -104.9612585 2022-08-19 04:20:54 Huerfano, Colorado, US
648206 648206 2022-08-18 US Colorado Jackson 8057 192 0 0   40.6659387 -106.3408905 2022-08-19 04:20:54 Jackson, Colorado, US
648207 648207 2022-08-18 US Colorado Jefferson 8059 148324 1429 0   39.58635604 -105.2517692 2022-08-19 04:20:54 Jefferson, Colorado, US
648208 648208 2022-08-18 US Colorado Kiowa 8061 355 6 0   38.43260896 -102.7392145 2022-08-19 04:20:54 Kiowa, Colorado, US
648209 648209 2022-08-18 US Colorado Kit Carson 8063 1757 33 0   39.30497777 -102.6022199 2022-08-19 04:20:54 Kit Carson, Colorado, US
648210 648210 2022-08-18 US Colorado La Plata 8067 14549 90 0   37.28632032 -107.8429014 2022-08-19 04:20:54 La Plata, Colorado, US
648211 648211 2022-08-18 US Colorado Lake 8065 2086 2 0   39.20278823 -106.3555697 2022-08-19 04:20:54 Lake, Colorado, US
648212 648212 2022-08-18 US Colorado Larimer 8069 97552 541 0   40.66671597 -105.4625784 2022-08-19 04:20:54 Larimer, Colorado, US
648213 648213 2022-08-18 US Colorado Las Animas 8071 3923 45 0   37.3153406 -104.0376458 2022-08-19 04:20:54 Las Animas, Colorado, US
648214 648214 2022-08-18 US Colorado Lincoln 8073 2323 10 0   38.98749519 -103.5136649 2022-08-19 04:20:54 Lincoln, Colorado, US
648215 648215 2022-08-18 US Colorado Logan 8075 8049 113 0   40.7249637 -103.110817 2022-08-19 04:20:54 Logan, Colorado, US
648216 648216 2022-08-18 US Colorado Mesa 8077 47333 597 0   39.01787888 -108.469799 2022-08-19 04:20:54 Mesa, Colorado, US
648217 648217 2022-08-18 US Colorado Mineral 8079 283 3 0   37.66954283 -106.9281698 2022-08-19 04:20:54 Mineral, Colorado, US
648218 648218 2022-08-18 US Colorado Moffat 8081 3363 53 0   40.61810999 -108.2070876 2022-08-19 04:20:54 Moffat, Colorado, US
648219 648219 2022-08-18 US Colorado Montezuma 8083 6835 83 0   37.33859579 -108.5958857 2022-08-19 04:20:54 Montezuma, Colorado, US
648220 648220 2022-08-18 US Colorado Montrose 8085 10387 170 0   38.40214114 -108.2639022 2022-08-19 04:20:54 Montrose, Colorado, US
648221 648221 2022-08-18 US Colorado Morgan 8087 6374 138 0   40.2627981 -103.8093302 2022-08-19 04:20:54 Morgan, Colorado, US
648222 648222 2022-08-18 US Colorado Otero 8089 4823 132 0   37.9014485 -103.7173385 2022-08-19 04:20:54 Otero, Colorado, US
648223 648223 2022-08-18 US Colorado Ouray 8091 1036 6 0   38.14717457 -107.7675136 2022-08-19 04:20:54 Ouray, Colorado, US
648224 648224 2022-08-18 US Colorado Out of CO 80008 0 0 0   40.87595412 0.0 2022-08-19 04:20:54 Out of CO, Colorado, US
648225 648225 2022-08-18 US Colorado Park 8093 3257 22 0   39.120926 -105.7182065 2022-08-19 04:20:54 Park, Colorado, US
648226 648226 2022-08-18 US Colorado Phillips 8095 974 19 0   40.59414277 -102.3577703 2022-08-19 04:20:54 Phillips, Colorado, US
648227 648227 2022-08-18 US Colorado Pitkin 8097 7668 8 0   39.21720112 -106.9310027 2022-08-19 04:20:54 Pitkin, Colorado, US
648228 648228 2022-08-18 US Colorado Prowers 8099 2832 51 0   37.95544985 -102.3926052 2022-08-19 04:20:54 Prowers, Colorado, US
648229 648229 2022-08-18 US Colorado Pueblo 8101 55138 833 0   38.17359144 -104.5127437 2022-08-19 04:20:54 Pueblo, Colorado, US
648230 648230 2022-08-18 US Colorado Rio Blanco 8103 1976 13 0   39.97913541 -108.2179009 2022-08-19 04:20:54 Rio Blanco, Colorado, US
648231 648231 2022-08-18 US Colorado Rio Grande 8105 3259 46 0   37.5836865 -106.3847838 2022-08-19 04:20:54 Rio Grande, Colorado, US
648232 648232 2022-08-18 US Colorado Routt 8107 7374 30 0   40.48596505 -106.9905548 2022-08-19 04:20:54 Routt, Colorado, US
648233 648233 2022-08-18 US Colorado Saguache 8109 1383 12 0   38.08054629 -106.282466 2022-08-19 04:20:54 Saguache, Colorado, US
648234 648234 2022-08-18 US Colorado San Juan 8111 294 0 0   37.76248981 -107.6763289 2022-08-19 04:20:54 San Juan, Colorado, US
648235 648235 2022-08-18 US Colorado San Miguel 8113 2572 8 0   38.00450883 -108.4020725 2022-08-19 04:20:54 San Miguel, Colorado, US
648236 648236 2022-08-18 US Colorado Sedgwick 8115 517 10 0   40.87595412 -102.3519227 2022-08-19 04:20:54 Sedgwick, Colorado, US
648237 648237 2022-08-18 US Colorado Summit 8117 11382 14 0   39.63803232 -106.1150762 2022-08-19 04:20:54 Summit, Colorado, US
648238 648238 2022-08-18 US Colorado Teller 8119 5515 59 0   38.88133511 -105.1614893 2022-08-19 04:20:54 Teller, Colorado, US
648239 648239 2022-08-18 US Colorado Unassigned 90008 159 0 0   40.87595412 0.0 2022-08-19 04:20:54 Unassigned, Colorado, US
648240 648240 2022-08-18 US Colorado Washington 8121 1126 29 0   39.97015535 -103.202587 2022-08-19 04:20:54 Washington, Colorado, US
648241 648241 2022-08-18 US Colorado Weld 8123 97546 720 0   40.55499405 -104.3929621 2022-08-19 04:20:54 Weld, Colorado, US
648242 648242 2022-08-18 US Colorado Yuma 8125 2143 26 0   40.00346839 -102.4258673 2022-08-19 04:20:54 Yuma, Colorado, US
2706949 2706949 2022-08-17 US Colorado Adams 8001 154406 1364 0   39.87432092 -104.3362578 2022-08-18 04:21:11 Adams, Colorado, US
2706950 2706950 2022-08-17 US Colorado Alamosa 8003 5252 62 0   37.57250606 -105.7885451 2022-08-18 04:21:11 Alamosa, Colorado, US
2706951 2706951 2022-08-17 US Colorado Arapahoe 8005 181759 1258 0   39.64977461 -104.3353617 2022-08-18 04:21:11 Arapahoe, Colorado, US
2706952 2706952 2022-08-17 US Colorado Archuleta 8007 3218 17 0   37.19474156 -107.0476867 2022-08-18 04:21:11 Archuleta, Colorado, US
2706953 2706953 2022-08-17 US Colorado Baca 8009 935 14 0   37.31940883 -102.5603223 2022-08-18 04:21:11 Baca, Colorado, US
2706954 2706954 2022-08-17 US Colorado Bent 8011 2704 47 0   37.95474293 -103.0720195 2022-08-18 04:21:11 Bent, Colorado, US
2706955 2706955 2022-08-17 US Colorado Boulder 8013 82200 394 0   40.09313619 -105.3546767 2022-08-18 04:21:11 Boulder, Colorado, US
2706956 2706956 2022-08-17 US Colorado Broomfield 8014 16737 122 0   39.95998787 -105.0566324 2022-08-18 04:21:11 Broomfield, Colorado, US
2706957 2706957 2022-08-17 US Colorado Chaffee 8015 5303 52 0   38.74745778 -106.1926573 2022-08-18 04:21:11 Chaffee, Colorado, US
2706958 2706958 2022-08-17 US Colorado Cheyenne 8017 349 9 0   38.82777431 -102.6032558 2022-08-18 04:21:11 Cheyenne, Colorado, US
2706959 2706959 2022-08-17 US Colorado Clear Creek 8019 1819 12 0   39.68864463 -105.6463118 2022-08-18 04:21:11 Clear Creek, Colorado, US
2706960 2706960 2022-08-17 US Colorado Conejos 8021 2082 57 0   37.201606 -106.1917488 2022-08-18 04:21:11 Conejos, Colorado, US
2706961 2706961 2022-08-17 US Colorado Costilla 8023 850 19 0   37.27732493 -105.4276548 2022-08-18 04:21:11 Costilla, Colorado, US
2706962 2706962 2022-08-17 US Colorado Crowley 8025 3450 31 0   38.32608609 -103.7844965 2022-08-18 04:21:11 Crowley, Colorado, US
2706963 2706963 2022-08-17 US Colorado Custer 8027 762 22 0   38.10883162 -105.3683478 2022-08-18 04:21:11 Custer, Colorado, US
2706964 2706964 2022-08-17 US Colorado Delta 8029 6709 144 0   38.86246243 -107.8631342 2022-08-18 04:21:11 Delta, Colorado, US
2706965 2706965 2022-08-17 US Colorado Denver 8031 206844 1421 0   39.76018276 -104.8725695 2022-08-18 04:21:11 Denver, Colorado, US
2706966 2706966 2022-08-17 US Colorado Dolores 8033 384 8 0   37.75208676 -108.5211585 2022-08-18 04:21:11 Dolores, Colorado, US
2706967 2706967 2022-08-17 US Colorado Douglas 8035 93612 459 0   39.33133796 -104.930001 2022-08-18 04:21:11 Douglas, Colorado, US
2706968 2706968 2022-08-17 US Colorado Eagle 8037 17869 37 0   39.62754308 -106.6933637 2022-08-18 04:21:11 Eagle, Colorado, US
2706969 2706969 2022-08-17 US Colorado El Paso 8041 216816 1774 0   38.83240149 -104.5251411 2022-08-18 04:21:11 El Paso, Colorado, US
2706970 2706970 2022-08-17 US Colorado Elbert 8039 5445 44 0   39.28656773 -104.1358721 2022-08-18 04:21:11 Elbert, Colorado, US
2706971 2706971 2022-08-17 US Colorado Fremont 8043 17085 193 0   38.47362326 -105.4399667 2022-08-18 04:21:11 Fremont, Colorado, US
2706972 2706972 2022-08-17 US Colorado Garfield 8045 16847 97 0   39.59921777 -107.902708 2022-08-18 04:21:11 Garfield, Colorado, US
2706973 2706973 2022-08-17 US Colorado Gilpin 8047 1107 5 0   39.85646523 -105.5252597 2022-08-18 04:21:11 Gilpin, Colorado, US
2706974 2706974 2022-08-17 US Colorado Grand 8049 3835 28 0   40.10603347 -106.1178042 2022-08-18 04:21:11 Grand, Colorado, US
2706975 2706975 2022-08-17 US Colorado Gunnison 8051 3724 14 0   38.66611652 -107.0320729 2022-08-18 04:21:11 Gunnison, Colorado, US
2706976 2706976 2022-08-17 US Colorado Hinsdale 8053 149 0 0   37.82247444 -107.3004345 2022-08-18 04:21:11 Hinsdale, Colorado, US
2706977 2706977 2022-08-17 US Colorado Huerfano 8055 1645 38 0   37.68473101 -104.9612585 2022-08-18 04:21:11 Huerfano, Colorado, US
2706978 2706978 2022-08-17 US Colorado Jackson 8057 192 0 0   40.6659387 -106.3408905 2022-08-18 04:21:11 Jackson, Colorado, US
2706979 2706979 2022-08-17 US Colorado Jefferson 8059 148237 1429 0   39.58635604 -105.2517692 2022-08-18 04:21:11 Jefferson, Colorado, US
2706980 2706980 2022-08-17 US Colorado Kiowa 8061 356 6 0   38.43260896 -102.7392145 2022-08-18 04:21:11 Kiowa, Colorado, US
2706981 2706981 2022-08-17 US Colorado Kit Carson 8063 1756 33 0   39.30497777 -102.6022199 2022-08-18 04:21:11 Kit Carson, Colorado, US
2706982 2706982 2022-08-17 US Colorado La Plata 8067 14542 90 0   37.28632032 -107.8429014 2022-08-18 04:21:11 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]);
Powered by Datasette · Queries took 1045.764ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette