daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66,146 rows where province_or_state = "Colorado" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | US | Colorado | Hinsdale | 8053 | 67 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-12-03 04:23:05 | Hinsdale, Colorado, US | |
2021-12-02 | US | Colorado | Jackson | 8057 | 123 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-12-03 04:23:05 | Jackson, Colorado, US | |
2021-12-02 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-12-03 04:23:05 | Out of CO, Colorado, US | |
2021-12-02 | US | Colorado | San Juan | 8111 | 103 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-12-03 04:23:05 | San Juan, Colorado, US | |
2021-12-02 | US | Colorado | Unassigned | 90008 | 102 | 0 | 0 | 40.87595412 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Colorado, US | |
2021-10-28 | US | Colorado | Hinsdale | 8053 | 60 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-29 04:22:03 | Hinsdale, Colorado, US | |
2021-10-28 | US | Colorado | Jackson | 8057 | 114 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-10-29 04:22:03 | Jackson, Colorado, US | |
2021-10-28 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-10-29 04:22:03 | Out of CO, Colorado, US | |
2021-10-28 | US | Colorado | San Juan | 8111 | 93 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-10-29 04:22:03 | San Juan, Colorado, US | |
2021-10-28 | US | Colorado | Unassigned | 90008 | 100 | 0 | 0 | 40.87595412 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Colorado, US | |
2020-10-25 | US | Colorado | Archuleta | 8007 | 70 | 0 | 0 | 65 | 37.19474156 | -107.0476867 | 2020-10-26 04:25:02 | Archuleta, Colorado, US |
2020-10-25 | US | Colorado | Baca | 8009 | 47 | 0 | 0 | 30 | 37.31940883 | -102.5603223 | 2020-10-26 04:25:02 | Baca, Colorado, US |
2020-10-25 | US | Colorado | Bent | 8011 | 16 | 0 | 0 | 15 | 37.95474293 | -103.0720195 | 2020-10-26 04:25:02 | Bent, Colorado, US |
2020-10-25 | US | Colorado | Cheyenne | 8017 | 15 | 0 | 0 | 15 | 38.82777431 | -102.6032558 | 2020-10-26 04:25:02 | Cheyenne, Colorado, US |
2020-10-25 | US | Colorado | Custer | 8027 | 26 | 0 | 0 | 20 | 38.10883162 | -105.3683478 | 2020-10-26 04:25:02 | Custer, Colorado, US |
2020-10-25 | US | Colorado | Dolores | 8033 | 4 | 0 | 0 | 3 | 37.75208676 | -108.5211585 | 2020-10-26 04:25:02 | Dolores, Colorado, US |
2020-10-25 | US | Colorado | Gilpin | 8047 | 33 | 0 | 0 | 29 | 39.85646523 | -105.5252597 | 2020-10-26 04:25:02 | Gilpin, Colorado, US |
2020-10-25 | US | Colorado | Hinsdale | 8053 | 5 | 0 | 0 | 3 | 37.82247444 | -107.3004345 | 2020-10-26 04:25:02 | Hinsdale, Colorado, US |
2020-10-25 | US | Colorado | Jackson | 8057 | 11 | 0 | 0 | 9 | 40.66593870000001 | -106.3408905 | 2020-10-26 04:25:02 | Jackson, Colorado, US |
2020-10-25 | US | Colorado | Kiowa | 8061 | 5 | 0 | 0 | 4 | 38.43260896 | -102.7392145 | 2020-10-26 04:25:02 | Kiowa, Colorado, US |
2020-10-25 | US | Colorado | Lake | 8065 | 152 | 0 | 0 | 132 | 39.20278823 | -106.3555697 | 2020-10-26 04:25:02 | Lake, Colorado, US |
2020-10-25 | US | Colorado | Las Animas | 8071 | 86 | 0 | 0 | 68 | 37.3153406 | -104.0376458 | 2020-10-26 04:25:02 | Las Animas, Colorado, US |
2020-10-25 | US | Colorado | Lincoln | 8073 | 28 | 0 | 0 | 24 | 38.98749519 | -103.5136649 | 2020-10-26 04:25:02 | Lincoln, Colorado, US |
2020-10-25 | US | Colorado | Mineral | 8079 | 21 | 0 | 0 | 21 | 37.66954283 | -106.9281698 | 2020-10-26 04:25:02 | Mineral, Colorado, US |
2020-10-25 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2020-10-26 04:25:02 | Out of CO, Colorado, US |
2020-10-25 | US | Colorado | Phillips | 8095 | 59 | 0 | 0 | 48 | 40.59414277 | -102.3577703 | 2020-10-26 04:25:02 | Phillips, Colorado, US |
2020-10-25 | US | Colorado | Rio Blanco | 8103 | 34 | 0 | 0 | 27 | 39.97913541 | -108.2179009 | 2020-10-26 04:25:02 | Rio Blanco, Colorado, US |
2020-10-25 | US | Colorado | San Juan | 8111 | 11 | 0 | 0 | 11 | 37.76248981 | -107.67632890000002 | 2020-10-26 04:25:02 | San Juan, Colorado, US |
2020-10-25 | US | Colorado | San Miguel | 8113 | 108 | 0 | 0 | 101 | 38.00450883 | -108.4020725 | 2020-10-26 04:25:02 | San Miguel, Colorado, US |
2020-10-25 | US | Colorado | Unassigned | 90008 | 21 | 0 | 0 | 23 | 40.87595412 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Colorado, US |
2021-01-26 | US | Colorado | Dolores | 8033 | 67 | 0 | 0 | 62 | 37.75208676 | -108.5211585 | 2021-01-27 05:23:41 | Dolores, Colorado, US |
2021-01-26 | US | Colorado | Hinsdale | 8053 | 20 | 0 | 0 | 15 | 37.82247444 | -107.3004345 | 2021-01-27 05:23:41 | Hinsdale, Colorado, US |
2021-01-26 | US | Colorado | Jackson | 8057 | 49 | 0 | 0 | 44 | 40.66593870000001 | -106.3408905 | 2021-01-27 05:23:41 | Jackson, Colorado, US |
2021-01-26 | US | Colorado | Lake | 8065 | 523 | 0 | 0 | 495 | 39.20278823 | -106.3555697 | 2021-01-27 05:23:41 | Lake, Colorado, US |
2021-01-26 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-01-27 05:23:41 | Out of CO, Colorado, US |
2021-01-26 | US | Colorado | San Juan | 8111 | 44 | 0 | 0 | 42 | 37.76248981 | -107.67632890000002 | 2021-01-27 05:23:41 | San Juan, Colorado, US |
2021-01-26 | US | Colorado | San Miguel | 8113 | 692 | 0 | 0 | 611 | 38.00450883 | -108.4020725 | 2021-01-27 05:23:41 | San Miguel, Colorado, US |
2021-01-26 | US | Colorado | Unassigned | 90008 | 52 | 0 | 0 | 38 | 40.87595412 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Colorado, US |
2021-09-18 | US | Colorado | Hinsdale | 8053 | 53 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-09-19 04:21:34 | Hinsdale, Colorado, US | |
2021-09-18 | US | Colorado | Jackson | 8057 | 89 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-09-19 04:21:34 | Jackson, Colorado, US | |
2021-09-18 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-09-19 04:21:34 | Out of CO, Colorado, US | |
2021-09-18 | US | Colorado | San Juan | 8111 | 85 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-09-19 04:21:34 | San Juan, Colorado, US | |
2021-09-18 | US | Colorado | Unassigned | 90008 | 96 | 0 | 0 | 40.87595412 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Colorado, US | |
2021-05-28 | US | Colorado | Hinsdale | 8053 | 21 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-05-29 04:20:41 | Hinsdale, Colorado, US | |
2021-05-28 | US | Colorado | Jackson | 8057 | 65 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-05-29 04:20:41 | Jackson, Colorado, US | |
2021-05-28 | US | Colorado | Lake | 8065 | 824 | 0 | 0 | 39.20278823 | -106.3555697 | 2021-05-29 04:20:41 | Lake, Colorado, US | |
2021-05-28 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-05-29 04:20:41 | Out of CO, Colorado, US | |
2021-05-28 | US | Colorado | San Juan | 8111 | 48 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-05-29 04:20:41 | San Juan, Colorado, US | |
2021-05-28 | US | Colorado | Unassigned | 90008 | 76 | 0 | 0 | 40.87595412 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Colorado, US | |
2022-03-20 | US | Colorado | Hinsdale | 8053 | 131 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-03-21 04:20:50 | Hinsdale, Colorado, US | |
2022-03-20 | US | Colorado | Jackson | 8057 | 166 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2022-03-21 04:20:50 | Jackson, Colorado, US | |
2022-03-20 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2022-03-21 04:20:50 | Out of CO, Colorado, US | |
2022-03-20 | US | Colorado | San Juan | 8111 | 199 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2022-03-21 04:20:50 | San Juan, Colorado, US | |
2022-03-20 | US | Colorado | Unassigned | 90008 | 137 | 0 | 0 | 40.87595412 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Colorado, US | |
2021-11-11 | US | Colorado | Hinsdale | 8053 | 65 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-11-12 04:22:01 | Hinsdale, Colorado, US | |
2021-11-11 | US | Colorado | Jackson | 8057 | 117 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-11-12 04:22:01 | Jackson, Colorado, US | |
2021-11-11 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-11-12 04:22:01 | Out of CO, Colorado, US | |
2021-11-11 | US | Colorado | San Juan | 8111 | 102 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-11-12 04:22:01 | San Juan, Colorado, US | |
2021-11-11 | US | Colorado | Unassigned | 90008 | 101 | 0 | 0 | 40.87595412 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Colorado, US | |
2021-08-25 | US | Colorado | Hinsdale | 8053 | 47 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-08-26 04:21:28 | Hinsdale, Colorado, US | |
2021-08-25 | US | Colorado | Jackson | 8057 | 69 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-08-26 04:21:28 | Jackson, Colorado, US | |
2021-08-25 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-08-26 04:21:28 | Out of CO, Colorado, US | |
2021-08-25 | US | Colorado | San Juan | 8111 | 85 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-08-26 04:21:28 | San Juan, Colorado, US | |
2021-08-25 | US | Colorado | Unassigned | 90008 | 91 | 0 | 0 | 40.87595412 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Colorado, US | |
2021-04-12 | US | Colorado | Dolores | 8033 | 79 | 0 | 0 | 37.75208676 | -108.5211585 | 2021-04-13 04:20:37 | Dolores, Colorado, US | |
2021-04-12 | US | Colorado | Hinsdale | 8053 | 21 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-04-13 04:20:37 | Hinsdale, Colorado, US | |
2021-04-12 | US | Colorado | Jackson | 8057 | 59 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-04-13 04:20:37 | Jackson, Colorado, US | |
2021-04-12 | US | Colorado | Lake | 8065 | 766 | 0 | 0 | 39.20278823 | -106.3555697 | 2021-04-13 04:20:37 | Lake, Colorado, US | |
2021-04-12 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-04-13 04:20:37 | Out of CO, Colorado, US | |
2021-04-12 | US | Colorado | San Juan | 8111 | 46 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-04-13 04:20:37 | San Juan, Colorado, US | |
2021-04-12 | US | Colorado | San Miguel | 8113 | 864 | 0 | 0 | 38.00450883 | -108.4020725 | 2021-04-13 04:20:37 | San Miguel, Colorado, US | |
2021-04-12 | US | Colorado | Unassigned | 90008 | 71 | 0 | 0 | 40.87595412 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Colorado, US | |
2020-04-13 | US | Colorado | Archuleta | 8007 | 7 | 0 | 0 | 6 | 37.19474156 | -107.04768670000001 | 2020-04-13 23:07:54 | Archuleta, Colorado, US |
2020-04-13 | US | Colorado | Baca | 8009 | 10 | 0 | 0 | 10 | 37.31940883 | -102.5603223 | 2020-04-13 23:07:54 | Baca, Colorado, US |
2020-04-13 | US | Colorado | Costilla | 8023 | 3 | 0 | 0 | 3 | 37.27732493 | -105.4276548 | 2020-04-13 23:07:54 | Costilla, Colorado, US |
2020-04-13 | US | Colorado | Custer | 8027 | 2 | 0 | 0 | 2 | 38.10883162 | -105.3683478 | 2020-04-13 23:07:54 | Custer, Colorado, US |
2020-04-13 | US | Colorado | Delta | 8029 | 40 | 0 | 0 | 6 | 38.86246243 | -107.86313419999999 | 2020-04-13 23:07:54 | Delta, Colorado, US |
2020-04-13 | US | Colorado | Fremont | 8043 | 18 | 0 | 0 | 8 | 38.47362326 | -105.43996670000001 | 2020-04-13 23:07:54 | Fremont, Colorado, US |
2020-04-13 | US | Colorado | Gilpin | 8047 | 2 | 0 | 0 | 1 | 39.85646523 | -105.5252597 | 2020-04-13 23:07:54 | Gilpin, Colorado, US |
2020-04-13 | US | Colorado | Grand | 8049 | 5 | 0 | 0 | 4 | 40.10603347 | -106.11780420000001 | 2020-04-13 23:07:54 | Grand, Colorado, US |
2020-04-13 | US | Colorado | Hinsdale | 8053 | 3 | 0 | 0 | 2 | 37.82247444 | -107.3004345 | 2020-04-13 23:07:54 | Hinsdale, Colorado, US |
2020-04-13 | US | Colorado | Huerfano | 8055 | 2 | 0 | 0 | 1 | 37.68473101 | -104.9612585 | 2020-04-13 23:07:54 | Huerfano, Colorado, US |
2020-04-13 | US | Colorado | La Plata | 8067 | 63 | 0 | 0 | 44 | 37.28632032 | -107.8429014 | 2020-04-13 23:07:54 | La Plata, Colorado, US |
2020-04-13 | US | Colorado | Lake | 8065 | 20 | 0 | 0 | 4 | 39.20278823 | -106.35556969999999 | 2020-04-13 23:07:54 | Lake, Colorado, US |
2020-04-13 | US | Colorado | Las Animas | 8071 | 4 | 0 | 0 | 2 | 37.3153406 | -104.03764579999999 | 2020-04-13 23:07:54 | Las Animas, Colorado, US |
2020-04-13 | US | Colorado | Lincoln | 8073 | 3 | 0 | 0 | 2 | 38.98749519 | -103.51366490000001 | 2020-04-13 23:07:54 | Lincoln, Colorado, US |
2020-04-13 | US | Colorado | Mesa | 8077 | 41 | 0 | 0 | 35 | 39.01787888 | -108.469799 | 2020-04-13 23:07:54 | Mesa, Colorado, US |
2020-04-13 | US | Colorado | Mineral | 8079 | 2 | 0 | 0 | 2 | 37.66954283 | -106.92816979999999 | 2020-04-13 23:07:54 | Mineral, Colorado, US |
2020-04-13 | US | Colorado | Moffat | 8081 | 3 | 0 | 0 | 3 | 40.61810999 | -108.2070876 | 2020-04-13 23:07:54 | Moffat, Colorado, US |
2020-04-13 | US | Colorado | Otero | 8089 | 7 | 0 | 0 | 5 | 37.9014485 | -103.7173385 | 2020-04-13 23:07:54 | Otero, Colorado, US |
2020-04-13 | US | Colorado | Park | 8093 | 7 | 0 | 0 | 6 | 39.120926000000004 | -105.7182065 | 2020-04-13 23:07:54 | Park, Colorado, US |
2020-04-13 | US | Colorado | Phillips | 8095 | 5 | 0 | 0 | 4 | 40.59414277 | -102.3577703 | 2020-04-13 23:07:54 | Phillips, Colorado, US |
2020-04-13 | US | Colorado | Prowers | 8099 | 4 | 0 | 0 | 1 | 37.95544985 | -102.3926052 | 2020-04-13 23:07:54 | Prowers, Colorado, US |
2020-04-13 | US | Colorado | Rio Blanco | 8103 | 1 | 0 | 0 | 1 | 39.97913541 | -108.2179009 | 2020-04-13 23:07:54 | Rio Blanco, Colorado, US |
2020-04-13 | US | Colorado | Rio Grande | 8105 | 7 | 0 | 0 | 5 | 37.5836865 | -106.3847838 | 2020-04-13 23:07:54 | Rio Grande, Colorado, US |
2020-04-13 | US | Colorado | Saguache | 8109 | 3 | 0 | 0 | 3 | 38.08054629 | -106.28246599999999 | 2020-04-13 23:07:54 | Saguache, Colorado, US |
2020-04-13 | US | Colorado | San Miguel | 8113 | 14 | 0 | 0 | 12 | 38.00450883 | -108.4020725 | 2020-04-13 23:07:54 | San Miguel, Colorado, US |
2020-04-13 | US | Colorado | Unassigned | 90008 | 12 | 0 | 0 | 145 | 40.87595412 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Colorado, US |
2020-04-13 | US | Colorado | Washington | 8121 | 8 | 0 | 0 | 2 | 39.97015535 | -103.202587 | 2020-04-13 23:07:54 | Washington, Colorado, US |
2020-04-13 | US | Colorado | Yuma | 8125 | 5 | 0 | 0 | 2 | 40.00346839 | -102.4258673 | 2020-04-13 23:07:54 | Yuma, Colorado, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;