johns_hopkins_csse_daily_reports
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) >30 ✖
- 2022-04-13 132
- 2022-05-26 132
- 2020-08-23 66
- 2020-08-24 66
- 2020-08-25 66
- 2020-08-26 66
- 2020-08-27 66
- 2020-08-28 66
- 2020-08-29 66
- 2020-08-30 66
- 2020-08-31 66
- 2020-09-01 66
- 2020-09-02 66
- 2020-09-03 66
- 2020-09-04 66
- 2020-09-05 66
- 2020-09-06 66
- 2020-09-07 66
- 2020-09-08 66
- 2020-09-09 66
- 2020-09-10 66
- 2020-09-11 66
- 2020-09-12 66
- 2020-09-13 66
- 2020-09-14 66
- 2020-09-15 66
- 2020-09-16 66
- 2020-09-17 66
- 2020-09-18 66
- 2020-09-19 66
- …
province_or_state 1
- Colorado · 66,146 ✖
country_or_region 1
- US 66,146
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
955 | 955 | 2021-12-02 | US | Colorado | Hinsdale | 8053 | 67 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-12-03 04:23:05 | Hinsdale, Colorado, US | |
957 | 957 | 2021-12-02 | US | Colorado | Jackson | 8057 | 123 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-12-03 04:23:05 | Jackson, Colorado, US | |
975 | 975 | 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 | |
985 | 985 | 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 | |
990 | 990 | 2021-12-02 | US | Colorado | Unassigned | 90008 | 102 | 0 | 0 | 40.87595412 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Colorado, US | |
4970 | 4970 | 2021-10-28 | US | Colorado | Hinsdale | 8053 | 60 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-29 04:22:03 | Hinsdale, Colorado, US | |
4972 | 4972 | 2021-10-28 | US | Colorado | Jackson | 8057 | 114 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-10-29 04:22:03 | Jackson, Colorado, US | |
4990 | 4990 | 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 | |
5000 | 5000 | 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 | |
5005 | 5005 | 2021-10-28 | US | Colorado | Unassigned | 90008 | 100 | 0 | 0 | 40.87595412 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Colorado, US | |
8919 | 8919 | 2020-10-25 | US | Colorado | Archuleta | 8007 | 70 | 0 | 0 | 65 | 37.19474156 | -107.0476867 | 2020-10-26 04:25:02 | Archuleta, Colorado, US |
8920 | 8920 | 2020-10-25 | US | Colorado | Baca | 8009 | 47 | 0 | 0 | 30 | 37.31940883 | -102.5603223 | 2020-10-26 04:25:02 | Baca, Colorado, US |
8921 | 8921 | 2020-10-25 | US | Colorado | Bent | 8011 | 16 | 0 | 0 | 15 | 37.95474293 | -103.0720195 | 2020-10-26 04:25:02 | Bent, Colorado, US |
8925 | 8925 | 2020-10-25 | US | Colorado | Cheyenne | 8017 | 15 | 0 | 0 | 15 | 38.82777431 | -102.6032558 | 2020-10-26 04:25:02 | Cheyenne, Colorado, US |
8930 | 8930 | 2020-10-25 | US | Colorado | Custer | 8027 | 26 | 0 | 0 | 20 | 38.10883162 | -105.3683478 | 2020-10-26 04:25:02 | Custer, Colorado, US |
8933 | 8933 | 2020-10-25 | US | Colorado | Dolores | 8033 | 4 | 0 | 0 | 3 | 37.75208676 | -108.5211585 | 2020-10-26 04:25:02 | Dolores, Colorado, US |
8940 | 8940 | 2020-10-25 | US | Colorado | Gilpin | 8047 | 33 | 0 | 0 | 29 | 39.85646523 | -105.5252597 | 2020-10-26 04:25:02 | Gilpin, Colorado, US |
8943 | 8943 | 2020-10-25 | US | Colorado | Hinsdale | 8053 | 5 | 0 | 0 | 3 | 37.82247444 | -107.3004345 | 2020-10-26 04:25:02 | Hinsdale, Colorado, US |
8945 | 8945 | 2020-10-25 | US | Colorado | Jackson | 8057 | 11 | 0 | 0 | 9 | 40.66593870000001 | -106.3408905 | 2020-10-26 04:25:02 | Jackson, Colorado, US |
8947 | 8947 | 2020-10-25 | US | Colorado | Kiowa | 8061 | 5 | 0 | 0 | 4 | 38.43260896 | -102.7392145 | 2020-10-26 04:25:02 | Kiowa, Colorado, US |
8950 | 8950 | 2020-10-25 | US | Colorado | Lake | 8065 | 152 | 0 | 0 | 132 | 39.20278823 | -106.3555697 | 2020-10-26 04:25:02 | Lake, Colorado, US |
8952 | 8952 | 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 |
8953 | 8953 | 2020-10-25 | US | Colorado | Lincoln | 8073 | 28 | 0 | 0 | 24 | 38.98749519 | -103.5136649 | 2020-10-26 04:25:02 | Lincoln, Colorado, US |
8956 | 8956 | 2020-10-25 | US | Colorado | Mineral | 8079 | 21 | 0 | 0 | 21 | 37.66954283 | -106.9281698 | 2020-10-26 04:25:02 | Mineral, Colorado, US |
8963 | 8963 | 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 |
8965 | 8965 | 2020-10-25 | US | Colorado | Phillips | 8095 | 59 | 0 | 0 | 48 | 40.59414277 | -102.3577703 | 2020-10-26 04:25:02 | Phillips, Colorado, US |
8969 | 8969 | 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 |
8973 | 8973 | 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 |
8974 | 8974 | 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 |
8978 | 8978 | 2020-10-25 | US | Colorado | Unassigned | 90008 | 21 | 0 | 0 | 23 | 40.87595412 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Colorado, US |
12945 | 12945 | 2021-01-26 | US | Colorado | Dolores | 8033 | 67 | 0 | 0 | 62 | 37.75208676 | -108.5211585 | 2021-01-27 05:23:41 | Dolores, Colorado, US |
12955 | 12955 | 2021-01-26 | US | Colorado | Hinsdale | 8053 | 20 | 0 | 0 | 15 | 37.82247444 | -107.3004345 | 2021-01-27 05:23:41 | Hinsdale, Colorado, US |
12957 | 12957 | 2021-01-26 | US | Colorado | Jackson | 8057 | 49 | 0 | 0 | 44 | 40.66593870000001 | -106.3408905 | 2021-01-27 05:23:41 | Jackson, Colorado, US |
12962 | 12962 | 2021-01-26 | US | Colorado | Lake | 8065 | 523 | 0 | 0 | 495 | 39.20278823 | -106.3555697 | 2021-01-27 05:23:41 | Lake, Colorado, US |
12975 | 12975 | 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 |
12985 | 12985 | 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 |
12986 | 12986 | 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 |
12990 | 12990 | 2021-01-26 | US | Colorado | Unassigned | 90008 | 52 | 0 | 0 | 38 | 40.87595412 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Colorado, US |
16977 | 16977 | 2021-09-18 | US | Colorado | Hinsdale | 8053 | 53 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-09-19 04:21:34 | Hinsdale, Colorado, US | |
16979 | 16979 | 2021-09-18 | US | Colorado | Jackson | 8057 | 89 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-09-19 04:21:34 | Jackson, Colorado, US | |
16997 | 16997 | 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 | |
17007 | 17007 | 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 | |
17012 | 17012 | 2021-09-18 | US | Colorado | Unassigned | 90008 | 96 | 0 | 0 | 40.87595412 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Colorado, US | |
20988 | 20988 | 2021-05-28 | US | Colorado | Hinsdale | 8053 | 21 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-05-29 04:20:41 | Hinsdale, Colorado, US | |
20990 | 20990 | 2021-05-28 | US | Colorado | Jackson | 8057 | 65 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-05-29 04:20:41 | Jackson, Colorado, US | |
20995 | 20995 | 2021-05-28 | US | Colorado | Lake | 8065 | 824 | 0 | 0 | 39.20278823 | -106.3555697 | 2021-05-29 04:20:41 | Lake, Colorado, US | |
21008 | 21008 | 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 | |
21018 | 21018 | 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 | |
21023 | 21023 | 2021-05-28 | US | Colorado | Unassigned | 90008 | 76 | 0 | 0 | 40.87595412 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Colorado, US | |
25026 | 25026 | 2022-03-20 | US | Colorado | Hinsdale | 8053 | 131 | 0 | 0 | 37.82247444 | -107.3004345 | 2022-03-21 04:20:50 | Hinsdale, Colorado, US | |
25028 | 25028 | 2022-03-20 | US | Colorado | Jackson | 8057 | 166 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2022-03-21 04:20:50 | Jackson, Colorado, US | |
25046 | 25046 | 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 | |
25056 | 25056 | 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 | |
25061 | 25061 | 2022-03-20 | US | Colorado | Unassigned | 90008 | 137 | 0 | 0 | 40.87595412 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Colorado, US | |
29041 | 29041 | 2021-11-11 | US | Colorado | Hinsdale | 8053 | 65 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-11-12 04:22:01 | Hinsdale, Colorado, US | |
29043 | 29043 | 2021-11-11 | US | Colorado | Jackson | 8057 | 117 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-11-12 04:22:01 | Jackson, Colorado, US | |
29061 | 29061 | 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 | |
29071 | 29071 | 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 | |
29076 | 29076 | 2021-11-11 | US | Colorado | Unassigned | 90008 | 101 | 0 | 0 | 40.87595412 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Colorado, US | |
33037 | 33037 | 2021-08-25 | US | Colorado | Hinsdale | 8053 | 47 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-08-26 04:21:28 | Hinsdale, Colorado, US | |
33039 | 33039 | 2021-08-25 | US | Colorado | Jackson | 8057 | 69 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-08-26 04:21:28 | Jackson, Colorado, US | |
33057 | 33057 | 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 | |
33067 | 33067 | 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 | |
33072 | 33072 | 2021-08-25 | US | Colorado | Unassigned | 90008 | 91 | 0 | 0 | 40.87595412 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Colorado, US | |
37037 | 37037 | 2021-04-12 | US | Colorado | Dolores | 8033 | 79 | 0 | 0 | 37.75208676 | -108.5211585 | 2021-04-13 04:20:37 | Dolores, Colorado, US | |
37047 | 37047 | 2021-04-12 | US | Colorado | Hinsdale | 8053 | 21 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-04-13 04:20:37 | Hinsdale, Colorado, US | |
37049 | 37049 | 2021-04-12 | US | Colorado | Jackson | 8057 | 59 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-04-13 04:20:37 | Jackson, Colorado, US | |
37054 | 37054 | 2021-04-12 | US | Colorado | Lake | 8065 | 766 | 0 | 0 | 39.20278823 | -106.3555697 | 2021-04-13 04:20:37 | Lake, Colorado, US | |
37067 | 37067 | 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 | |
37077 | 37077 | 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 | |
37078 | 37078 | 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 | |
37082 | 37082 | 2021-04-12 | US | Colorado | Unassigned | 90008 | 71 | 0 | 0 | 40.87595412 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Colorado, US | |
40410 | 40410 | 2020-04-13 | US | Colorado | Archuleta | 8007 | 7 | 0 | 0 | 6 | 37.19474156 | -107.04768670000001 | 2020-04-13 23:07:54 | Archuleta, Colorado, US |
40439 | 40439 | 2020-04-13 | US | Colorado | Baca | 8009 | 10 | 0 | 0 | 10 | 37.31940883 | -102.5603223 | 2020-04-13 23:07:54 | Baca, Colorado, US |
40895 | 40895 | 2020-04-13 | US | Colorado | Costilla | 8023 | 3 | 0 | 0 | 3 | 37.27732493 | -105.4276548 | 2020-04-13 23:07:54 | Costilla, Colorado, US |
40946 | 40946 | 2020-04-13 | US | Colorado | Custer | 8027 | 2 | 0 | 0 | 2 | 38.10883162 | -105.3683478 | 2020-04-13 23:07:54 | Custer, Colorado, US |
41002 | 41002 | 2020-04-13 | US | Colorado | Delta | 8029 | 40 | 0 | 0 | 6 | 38.86246243 | -107.86313419999999 | 2020-04-13 23:07:54 | Delta, Colorado, US |
41188 | 41188 | 2020-04-13 | US | Colorado | Fremont | 8043 | 18 | 0 | 0 | 8 | 38.47362326 | -105.43996670000001 | 2020-04-13 23:07:54 | Fremont, Colorado, US |
41234 | 41234 | 2020-04-13 | US | Colorado | Gilpin | 8047 | 2 | 0 | 0 | 1 | 39.85646523 | -105.5252597 | 2020-04-13 23:07:54 | Gilpin, Colorado, US |
41258 | 41258 | 2020-04-13 | US | Colorado | Grand | 8049 | 5 | 0 | 0 | 4 | 40.10603347 | -106.11780420000001 | 2020-04-13 23:07:54 | Grand, Colorado, US |
41421 | 41421 | 2020-04-13 | US | Colorado | Hinsdale | 8053 | 3 | 0 | 0 | 2 | 37.82247444 | -107.3004345 | 2020-04-13 23:07:54 | Hinsdale, Colorado, US |
41450 | 41450 | 2020-04-13 | US | Colorado | Huerfano | 8055 | 2 | 0 | 0 | 1 | 37.68473101 | -104.9612585 | 2020-04-13 23:07:54 | Huerfano, Colorado, US |
41642 | 41642 | 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 |
41658 | 41658 | 2020-04-13 | US | Colorado | Lake | 8065 | 20 | 0 | 0 | 4 | 39.20278823 | -106.35556969999999 | 2020-04-13 23:07:54 | Lake, Colorado, US |
41684 | 41684 | 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 |
41748 | 41748 | 2020-04-13 | US | Colorado | Lincoln | 8073 | 3 | 0 | 0 | 2 | 38.98749519 | -103.51366490000001 | 2020-04-13 23:07:54 | Lincoln, Colorado, US |
41966 | 41966 | 2020-04-13 | US | Colorado | Mesa | 8077 | 41 | 0 | 0 | 35 | 39.01787888 | -108.469799 | 2020-04-13 23:07:54 | Mesa, Colorado, US |
41985 | 41985 | 2020-04-13 | US | Colorado | Mineral | 8079 | 2 | 0 | 0 | 2 | 37.66954283 | -106.92816979999999 | 2020-04-13 23:07:54 | Mineral, Colorado, US |
41999 | 41999 | 2020-04-13 | US | Colorado | Moffat | 8081 | 3 | 0 | 0 | 3 | 40.61810999 | -108.2070876 | 2020-04-13 23:07:54 | Moffat, Colorado, US |
42190 | 42190 | 2020-04-13 | US | Colorado | Otero | 8089 | 7 | 0 | 0 | 5 | 37.9014485 | -103.7173385 | 2020-04-13 23:07:54 | Otero, Colorado, US |
42221 | 42221 | 2020-04-13 | US | Colorado | Park | 8093 | 7 | 0 | 0 | 6 | 39.120926000000004 | -105.7182065 | 2020-04-13 23:07:54 | Park, Colorado, US |
42266 | 42266 | 2020-04-13 | US | Colorado | Phillips | 8095 | 5 | 0 | 0 | 4 | 40.59414277 | -102.3577703 | 2020-04-13 23:07:54 | Phillips, Colorado, US |
42351 | 42351 | 2020-04-13 | US | Colorado | Prowers | 8099 | 4 | 0 | 0 | 1 | 37.95544985 | -102.3926052 | 2020-04-13 23:07:54 | Prowers, Colorado, US |
42417 | 42417 | 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 |
42418 | 42418 | 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 |
42465 | 42465 | 2020-04-13 | US | Colorado | Saguache | 8109 | 3 | 0 | 0 | 3 | 38.08054629 | -106.28246599999999 | 2020-04-13 23:07:54 | Saguache, Colorado, US |
42487 | 42487 | 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 |
42778 | 42778 | 2020-04-13 | US | Colorado | Unassigned | 90008 | 12 | 0 | 0 | 145 | 40.87595412 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Colorado, US |
42907 | 42907 | 2020-04-13 | US | Colorado | Washington | 8121 | 8 | 0 | 0 | 2 | 39.97015535 | -103.202587 | 2020-04-13 23:07:54 | Washington, Colorado, US |
43070 | 43070 | 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 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] TEXT, [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]);