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 last_update descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3624790 | 3624790 | 2020-04-06 | US | Colorado | Adams | 8001 | 841 | 58 | 0 | 355 | 39.87432092 | -104.3362578 | 4/6/20 23:22 | Adams, Colorado, US |
3624805 | 3624805 | 2020-04-06 | US | Colorado | Alamosa | 8003 | 10 | 2 | 0 | 4 | 37.57250606 | -105.7885451 | 4/6/20 23:22 | Alamosa, Colorado, US |
3624848 | 3624848 | 2020-04-06 | US | Colorado | Arapahoe | 8005 | 1482 | 120 | 0 | 637 | 39.64977461 | -104.3353617 | 4/6/20 23:22 | Arapahoe, Colorado, US |
3624849 | 3624849 | 2020-04-06 | US | Colorado | Archuleta | 8007 | 6 | 0 | 0 | 6 | 37.19474156 | -107.0476867 | 4/6/20 23:22 | Archuleta, Colorado, US |
3624877 | 3624877 | 2020-04-06 | US | Colorado | Baca | 8009 | 10 | 0 | 0 | 9 | 37.31940883 | -102.5603223 | 4/6/20 23:22 | Baca, Colorado, US |
3624976 | 3624976 | 2020-04-06 | US | Colorado | Boulder | 8013 | 359 | 24 | 0 | 186 | 40.09313619 | -105.3546767 | 4/6/20 23:22 | Boulder, Colorado, US |
3625003 | 3625003 | 2020-04-06 | US | Colorado | Broomfield | 8014 | 102 | 3 | 0 | 48 | 39.95998787 | -105.0566324 | 4/6/20 23:22 | Broomfield, Colorado, US |
3625137 | 3625137 | 2020-04-06 | US | Colorado | Chaffee | 8015 | 52 | 8 | 0 | 20 | 38.74745778 | -106.1926573 | 4/6/20 23:22 | Chaffee, Colorado, US |
3625236 | 3625236 | 2020-04-06 | US | Colorado | Clear Creek | 8019 | 13 | 1 | 0 | 6 | 39.68864463 | -105.6463118 | 4/6/20 23:22 | Clear Creek, Colorado, US |
3625303 | 3625303 | 2020-04-06 | US | Colorado | Costilla | 8023 | 3 | 0 | 0 | 3 | 37.27732493 | -105.4276548 | 4/6/20 23:22 | Costilla, Colorado, US |
3625338 | 3625338 | 2020-04-06 | US | Colorado | Crowley | 8025 | 1 | 1 | 0 | 0 | 38.32608609 | -103.7844965 | 4/6/20 23:22 | Crowley, Colorado, US |
3625352 | 3625352 | 2020-04-06 | US | Colorado | Custer | 8027 | 2 | 0 | 0 | 2 | 38.10883162 | -105.3683478 | 4/6/20 23:22 | Custer, Colorado, US |
3625407 | 3625407 | 2020-04-06 | US | Colorado | Delta | 8029 | 21 | 0 | 0 | 5 | 38.86246243 | -107.8631342 | 4/6/20 23:22 | Delta, Colorado, US |
3625410 | 3625410 | 2020-04-06 | US | Colorado | Denver | 8031 | 1697 | 112 | 0 | 832 | 39.76018276 | -104.8725695 | 4/6/20 23:22 | Denver, Colorado, US |
3625436 | 3625436 | 2020-04-06 | US | Colorado | Douglas | 8035 | 381 | 20 | 0 | 224 | 39.33133796 | -104.930001 | 4/6/20 23:22 | Douglas, Colorado, US |
3625460 | 3625460 | 2020-04-06 | US | Colorado | Eagle | 8037 | 473 | 7 | 0 | 350 | 39.62754308 | -106.6933637 | 4/6/20 23:22 | Eagle, Colorado, US |
3625477 | 3625477 | 2020-04-06 | US | Colorado | El Paso | 8041 | 839 | 61 | 0 | 413 | 38.83240149 | -104.5251411 | 4/6/20 23:22 | El Paso, Colorado, US |
3625479 | 3625479 | 2020-04-06 | US | Colorado | Elbert | 8039 | 16 | 1 | 0 | 8 | 39.28656773 | -104.1358721 | 4/6/20 23:22 | Elbert, Colorado, US |
3625577 | 3625577 | 2020-04-06 | US | Colorado | Fremont | 8043 | 14 | 0 | 0 | 3 | 38.47362326 | -105.4399667 | 4/6/20 23:22 | Fremont, Colorado, US |
3625594 | 3625594 | 2020-04-06 | US | Colorado | Garfield | 8045 | 102 | 2 | 0 | 46 | 39.59921777 | -107.902708 | 4/6/20 23:22 | Garfield, Colorado, US |
3625640 | 3625640 | 2020-04-06 | US | Colorado | Grand | 8049 | 4 | 0 | 0 | 4 | 40.10603347 | -106.1178042 | 4/6/20 23:22 | Grand, Colorado, US |
3625693 | 3625693 | 2020-04-06 | US | Colorado | Gunnison | 8051 | 149 | 4 | 0 | 94 | 38.66611652 | -107.0320729 | 4/6/20 23:22 | Gunnison, Colorado, US |
3625789 | 3625789 | 2020-04-06 | US | Colorado | Hinsdale | 8053 | 3 | 0 | 0 | 1 | 37.82247444 | -107.3004345 | 4/6/20 23:22 | Hinsdale, Colorado, US |
3625814 | 3625814 | 2020-04-06 | US | Colorado | Huerfano | 8055 | 2 | 0 | 0 | 1 | 37.68473101 | -104.9612585 | 4/6/20 23:22 | Huerfano, Colorado, US |
3625884 | 3625884 | 2020-04-06 | US | Colorado | Jefferson | 8059 | 978 | 51 | 0 | 522 | 39.58635604 | -105.2517692 | 4/6/20 23:22 | Jefferson, Colorado, US |
3625971 | 3625971 | 2020-04-06 | US | Colorado | Kit Carson | 8063 | 8 | 1 | 0 | 5 | 39.30497777 | -102.6022199 | 4/6/20 23:22 | Kit Carson, Colorado, US |
3625989 | 3625989 | 2020-04-06 | US | Colorado | La Plata | 8067 | 59 | 0 | 0 | 32 | 37.28632032 | -107.8429014 | 4/6/20 23:22 | La Plata, Colorado, US |
3626003 | 3626003 | 2020-04-06 | US | Colorado | Lake | 8065 | 17 | 0 | 0 | 3 | 39.20278823 | -106.3555697 | 4/6/20 23:22 | Lake, Colorado, US |
3626026 | 3626026 | 2020-04-06 | US | Colorado | Larimer | 8069 | 231 | 16 | 0 | 150 | 40.66671597 | -105.4625784 | 4/6/20 23:22 | Larimer, Colorado, US |
3626028 | 3626028 | 2020-04-06 | US | Colorado | Las Animas | 8071 | 3 | 0 | 0 | 1 | 37.3153406 | -104.0376458 | 4/6/20 23:22 | Las Animas, Colorado, US |
3626088 | 3626088 | 2020-04-06 | US | Colorado | Lincoln | 8073 | 1 | 0 | 0 | 1 | 38.98749519 | -103.5136649 | 4/6/20 23:22 | Lincoln, Colorado, US |
3626118 | 3626118 | 2020-04-06 | US | Colorado | Logan | 8075 | 14 | 1 | 0 | 11 | 40.7249637 | -103.110817 | 4/6/20 23:22 | Logan, Colorado, US |
3626292 | 3626292 | 2020-04-06 | US | Colorado | Mesa | 8077 | 38 | 0 | 0 | 25 | 39.01787888 | -108.469799 | 4/6/20 23:22 | Mesa, Colorado, US |
3626309 | 3626309 | 2020-04-06 | US | Colorado | Mineral | 8079 | 2 | 0 | 0 | 2 | 37.66954283 | -106.9281698 | 4/6/20 23:22 | Mineral, Colorado, US |
3626321 | 3626321 | 2020-04-06 | US | Colorado | Moffat | 8081 | 3 | 0 | 0 | 3 | 40.61810999 | -108.2070876 | 4/6/20 23:22 | Moffat, Colorado, US |
3626344 | 3626344 | 2020-04-06 | US | Colorado | Montezuma | 8083 | 12 | 2 | 0 | 7 | 37.33859579 | -108.5958857 | 4/6/20 23:22 | Montezuma, Colorado, US |
3626362 | 3626362 | 2020-04-06 | US | Colorado | Montrose | 8085 | 75 | 12 | 0 | 32 | 38.40214114 | -108.2639022 | 4/6/20 23:22 | Montrose, Colorado, US |
3626368 | 3626368 | 2020-04-06 | US | Colorado | Morgan | 8087 | 94 | 6 | 0 | 19 | 40.2627981 | -103.8093302 | 4/6/20 23:22 | Morgan, Colorado, US |
3626499 | 3626499 | 2020-04-06 | US | Colorado | Otero | 8089 | 6 | 0 | 0 | 4 | 37.9014485 | -103.7173385 | 4/6/20 23:22 | Otero, Colorado, US |
3626511 | 3626511 | 2020-04-06 | US | Colorado | Ouray | 8091 | 5 | 1 | 0 | 2 | 38.14717457 | -107.7675136 | 4/6/20 23:22 | Ouray, Colorado, US |
3626512 | 3626512 | 2020-04-06 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 0 | 40.87595412 | 0.0 | 4/6/20 23:22 | Out of CO,Colorado,US |
3626530 | 3626530 | 2020-04-06 | US | Colorado | Park | 8093 | 7 | 0 | 0 | 5 | 39.120926 | -105.7182065 | 4/6/20 23:22 | Park, Colorado, US |
3626573 | 3626573 | 2020-04-06 | US | Colorado | Phillips | 8095 | 4 | 0 | 0 | 3 | 40.59414277 | -102.3577703 | 4/6/20 23:22 | Phillips, Colorado, US |
3626597 | 3626597 | 2020-04-06 | US | Colorado | Pitkin | 8097 | 51 | 2 | 0 | 37 | 39.21720112 | -106.9310027 | 4/6/20 23:22 | Pitkin, Colorado, US |
3626648 | 3626648 | 2020-04-06 | US | Colorado | Pueblo | 8101 | 77 | 7 | 0 | 40 | 38.17359144 | -104.5127437 | 4/6/20 23:22 | Pueblo, Colorado, US |
3626705 | 3626705 | 2020-04-06 | US | Colorado | Rio Blanco | 8103 | 1 | 0 | 0 | 1 | 39.97913541 | -108.2179009 | 4/6/20 23:22 | Rio Blanco, Colorado, US |
3626706 | 3626706 | 2020-04-06 | US | Colorado | Rio Grande | 8105 | 7 | 0 | 0 | 5 | 37.5836865 | -106.3847838 | 4/6/20 23:22 | Rio Grande, Colorado, US |
3626734 | 3626734 | 2020-04-06 | US | Colorado | Routt | 8107 | 35 | 3 | 0 | 29 | 40.48596505 | -106.9905548 | 4/6/20 23:22 | Routt, Colorado, US |
3626749 | 3626749 | 2020-04-06 | US | Colorado | Saguache | 8109 | 3 | 0 | 0 | 3 | 38.08054629 | -106.282466 | 4/6/20 23:22 | Saguache, Colorado, US |
3626771 | 3626771 | 2020-04-06 | US | Colorado | San Miguel | 8113 | 12 | 0 | 0 | 10 | 38.00450883 | -108.4020725 | 4/6/20 23:22 | San Miguel, Colorado, US |
3626935 | 3626935 | 2020-04-06 | US | Colorado | Summit | 8117 | 74 | 2 | 0 | 58 | 39.63803232 | -106.1150762 | 4/6/20 23:22 | Summit, Colorado, US |
3626978 | 3626978 | 2020-04-06 | US | Colorado | Teller | 8119 | 27 | 2 | 0 | 10 | 38.88133511 | -105.1614893 | 4/6/20 23:22 | Teller, Colorado, US |
3627038 | 3627038 | 2020-04-06 | US | Colorado | Unassigned | 90008 | 12 | 0 | 0 | 276 | 40.87595412 | 0.0 | 4/6/20 23:22 | Unassigned, Colorado, US |
3627161 | 3627161 | 2020-04-06 | US | Colorado | Washington | 8121 | 3 | 0 | 0 | 1 | 39.97015535 | -103.202587 | 4/6/20 23:22 | Washington, Colorado, US |
3627217 | 3627217 | 2020-04-06 | US | Colorado | Weld | 8123 | 1027 | 76 | 0 | 478 | 40.55499405 | -104.3929621 | 4/6/20 23:22 | Weld, Colorado, US |
3627318 | 3627318 | 2020-04-06 | US | Colorado | Yuma | 8125 | 3 | 0 | 0 | 2 | 40.00346839 | -102.4258673 | 4/6/20 23:22 | Yuma, Colorado, US |
1748248 | 1748248 | 2020-04-04 | US | Colorado | Adams | 8001 | 750 | 51 | 0 | 285 | 39.87432092 | -104.3362578 | 4/4/20 23:34 | Adams, Colorado, US |
1748263 | 1748263 | 2020-04-04 | US | Colorado | Alamosa | 8003 | 10 | 2 | 0 | 4 | 37.57250606 | -105.7885451 | 4/4/20 23:34 | Alamosa, Colorado, US |
1748303 | 1748303 | 2020-04-04 | US | Colorado | Arapahoe | 8005 | 1337 | 101 | 0 | 490 | 39.64977461 | -104.3353617 | 4/4/20 23:34 | Arapahoe, Colorado, US |
1748304 | 1748304 | 2020-04-04 | US | Colorado | Archuleta | 8007 | 6 | 0 | 0 | 1 | 37.19474156 | -107.0476867 | 4/4/20 23:34 | Archuleta, Colorado, US |
1748332 | 1748332 | 2020-04-04 | US | Colorado | Baca | 8009 | 9 | 0 | 0 | 9 | 37.31940883 | -102.5603223 | 4/4/20 23:34 | Baca, Colorado, US |
1748426 | 1748426 | 2020-04-04 | US | Colorado | Boulder | 8013 | 341 | 23 | 0 | 141 | 40.09313619 | -105.3546767 | 4/4/20 23:34 | Boulder, Colorado, US |
1748451 | 1748451 | 2020-04-04 | US | Colorado | Broomfield | 8014 | 96 | 3 | 0 | 34 | 39.95998787 | -105.0566324 | 4/4/20 23:34 | Broomfield, Colorado, US |
1748581 | 1748581 | 2020-04-04 | US | Colorado | Chaffee | 8015 | 46 | 7 | 0 | 17 | 38.74745778 | -106.1926573 | 4/4/20 23:34 | Chaffee, Colorado, US |
1748677 | 1748677 | 2020-04-04 | US | Colorado | Clear Creek | 8019 | 11 | 0 | 0 | 6 | 39.68864463 | -105.6463118 | 4/4/20 23:34 | Clear Creek, Colorado, US |
1748743 | 1748743 | 2020-04-04 | US | Colorado | Costilla | 8023 | 3 | 0 | 0 | 3 | 37.27732493 | -105.4276548 | 4/4/20 23:34 | Costilla, Colorado, US |
1748774 | 1748774 | 2020-04-04 | US | Colorado | Crowley | 8025 | 1 | 1 | 0 | 0 | 38.32608609 | -103.7844965 | 4/4/20 23:34 | Crowley, Colorado, US |
1748788 | 1748788 | 2020-04-04 | US | Colorado | Custer | 8027 | 2 | 0 | 0 | 2 | 38.10883162 | -105.3683478 | 4/4/20 23:34 | Custer, Colorado, US |
1748836 | 1748836 | 2020-04-04 | US | Colorado | Delta | 8029 | 15 | 0 | 0 | 4 | 38.86246243 | -107.8631342 | 4/4/20 23:34 | Delta, Colorado, US |
1748839 | 1748839 | 2020-04-04 | US | Colorado | Denver | 8031 | 1525 | 95 | 0 | 702 | 39.76018276 | -104.8725695 | 4/4/20 23:34 | Denver, Colorado, US |
1748863 | 1748863 | 2020-04-04 | US | Colorado | Douglas | 8035 | 363 | 19 | 0 | 192 | 39.33133796 | -104.930001 | 4/4/20 23:34 | Douglas, Colorado, US |
1748887 | 1748887 | 2020-04-04 | US | Colorado | Eagle | 8037 | 467 | 7 | 0 | 328 | 39.62754308 | -106.6933637 | 4/4/20 23:34 | Eagle, Colorado, US |
1748904 | 1748904 | 2020-04-04 | US | Colorado | El Paso | 8041 | 796 | 58 | 0 | 356 | 38.83240149 | -104.5251411 | 4/4/20 23:34 | El Paso, Colorado, US |
1748906 | 1748906 | 2020-04-04 | US | Colorado | Elbert | 8039 | 11 | 1 | 0 | 6 | 39.28656773 | -104.1358721 | 4/4/20 23:34 | Elbert, Colorado, US |
1748997 | 1748997 | 2020-04-04 | US | Colorado | Fremont | 8043 | 11 | 0 | 0 | 2 | 38.47362326 | -105.4399667 | 4/4/20 23:34 | Fremont, Colorado, US |
1749012 | 1749012 | 2020-04-04 | US | Colorado | Garfield | 8045 | 99 | 2 | 0 | 44 | 39.59921777 | -107.902708 | 4/4/20 23:34 | Garfield, Colorado, US |
1749055 | 1749055 | 2020-04-04 | US | Colorado | Grand | 8049 | 4 | 0 | 0 | 4 | 40.10603347 | -106.1178042 | 4/4/20 23:34 | Grand, Colorado, US |
1749106 | 1749106 | 2020-04-04 | US | Colorado | Gunnison | 8051 | 142 | 4 | 0 | 87 | 38.66611652 | -107.0320729 | 4/4/20 23:34 | Gunnison, Colorado, US |
1749196 | 1749196 | 2020-04-04 | US | Colorado | Hinsdale | 8053 | 3 | 0 | 0 | 1 | 37.82247444 | -107.3004345 | 4/4/20 23:34 | Hinsdale, Colorado, US |
1749220 | 1749220 | 2020-04-04 | US | Colorado | Huerfano | 8055 | 2 | 0 | 0 | 1 | 37.68473101 | -104.9612585 | 4/4/20 23:34 | Huerfano, Colorado, US |
1749289 | 1749289 | 2020-04-04 | US | Colorado | Jefferson | 8059 | 918 | 47 | 0 | 427 | 39.58635604 | -105.2517692 | 4/4/20 23:34 | Jefferson, Colorado, US |
1749372 | 1749372 | 2020-04-04 | US | Colorado | Kit Carson | 8063 | 8 | 1 | 0 | 4 | 39.30497777 | -102.6022199 | 4/4/20 23:34 | Kit Carson, Colorado, US |
1749390 | 1749390 | 2020-04-04 | US | Colorado | La Plata | 8067 | 57 | 0 | 0 | 25 | 37.28632032 | -107.8429014 | 4/4/20 23:34 | La Plata, Colorado, US |
1749403 | 1749403 | 2020-04-04 | US | Colorado | Lake | 8065 | 16 | 0 | 0 | 3 | 39.20278823 | -106.3555697 | 4/4/20 23:34 | Lake, Colorado, US |
1749425 | 1749425 | 2020-04-04 | US | Colorado | Larimer | 8069 | 217 | 15 | 0 | 127 | 40.66671597 | -105.4625784 | 4/4/20 23:34 | Larimer, Colorado, US |
1749427 | 1749427 | 2020-04-04 | US | Colorado | Las Animas | 8071 | 2 | 0 | 0 | 1 | 37.3153406 | -104.0376458 | 4/4/20 23:34 | Las Animas, Colorado, US |
1749486 | 1749486 | 2020-04-04 | US | Colorado | Lincoln | 8073 | 1 | 0 | 0 | 1 | 38.98749519 | -103.5136649 | 4/4/20 23:34 | Lincoln, Colorado, US |
1749514 | 1749514 | 2020-04-04 | US | Colorado | Logan | 8075 | 14 | 1 | 0 | 7 | 40.7249637 | -103.110817 | 4/4/20 23:34 | Logan, Colorado, US |
1749680 | 1749680 | 2020-04-04 | US | Colorado | Mesa | 8077 | 38 | 0 | 0 | 20 | 39.01787888 | -108.469799 | 4/4/20 23:34 | Mesa, Colorado, US |
1749696 | 1749696 | 2020-04-04 | US | Colorado | Mineral | 8079 | 2 | 0 | 0 | 2 | 37.66954283 | -106.9281698 | 4/4/20 23:34 | Mineral, Colorado, US |
1749708 | 1749708 | 2020-04-04 | US | Colorado | Moffat | 8081 | 3 | 0 | 0 | 3 | 40.61810999 | -108.2070876 | 4/4/20 23:34 | Moffat, Colorado, US |
1749730 | 1749730 | 2020-04-04 | US | Colorado | Montezuma | 8083 | 12 | 2 | 0 | 2 | 37.33859579 | -108.5958857 | 4/4/20 23:34 | Montezuma, Colorado, US |
1749748 | 1749748 | 2020-04-04 | US | Colorado | Montrose | 8085 | 67 | 11 | 0 | 25 | 38.40214114 | -108.2639022 | 4/4/20 23:34 | Montrose, Colorado, US |
1749753 | 1749753 | 2020-04-04 | US | Colorado | Morgan | 8087 | 67 | 2 | 0 | 7 | 40.2627981 | -103.8093302 | 4/4/20 23:34 | Morgan, Colorado, US |
1749878 | 1749878 | 2020-04-04 | US | Colorado | Otero | 8089 | 5 | 0 | 0 | 3 | 37.9014485 | -103.7173385 | 4/4/20 23:34 | Otero, Colorado, US |
1749890 | 1749890 | 2020-04-04 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 0 | 40.87595412 | 0.0 | 4/4/20 23:34 | Out of CO,Colorado,US |
1749908 | 1749908 | 2020-04-04 | US | Colorado | Park | 8093 | 7 | 0 | 0 | 5 | 39.120926 | -105.7182065 | 4/4/20 23:34 | Park, Colorado, US |
1749944 | 1749944 | 2020-04-04 | US | Colorado | Phillips | 8095 | 4 | 0 | 0 | 2 | 40.59414277 | -102.3577703 | 4/4/20 23:34 | Phillips, Colorado, US |
1749966 | 1749966 | 2020-04-04 | US | Colorado | Pitkin | 8097 | 50 | 2 | 0 | 36 | 39.21720112 | -106.9310027 | 4/4/20 23:34 | Pitkin, Colorado, US |
1750016 | 1750016 | 2020-04-04 | US | Colorado | Pueblo | 8101 | 71 | 7 | 0 | 29 | 38.17359144 | -104.5127437 | 4/4/20 23:34 | Pueblo, 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]);