johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
240 rows where active = 1085 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3904011 | 3904011 | 2021-07-31 | Japan | Shizuoka | 10885 | 157 | 9643 | 1085 | 34.916975 | 138.40778400000002 | 2021-08-01 04:21:50 | Shizuoka, Japan | ||
2764722 | 2764722 | 2021-07-01 | Chile | Los Rios | 45366 | 538 | 43743 | 1085 | -40.231 | -72.3311 | 2021-07-02 04:21:47 | Los Rios, Chile | ||
400476 | 400476 | 2021-06-29 | Russia | Khakassia Republic | 24885 | 584 | 23216 | 1085 | 53.72258845 | 91.44293627 | 2021-06-30 04:21:41 | Khakassia Republic, Russia | ||
3125741 | 3125741 | 2021-06-28 | Russia | Omsk Oblast | 50329 | 1498 | 47746 | 1085 | 56.09352629999999 | 73.5099936 | 2021-06-29 04:21:28 | Omsk Oblast, Russia | ||
2423082 | 2423082 | 2021-06-23 | Russia | Bryansk Oblast | 42628 | 425 | 41118 | 1085 | 52.8873315 | 33.41585300000001 | 2021-06-24 04:21:55 | Bryansk Oblast, Russia | ||
3358597 | 3358597 | 2021-06-21 | Guinea | 23535 | 168 | 22282 | 1085 | 9.9456 | -9.6966 | 2021-06-22 04:21:34 | Guinea | |||
1188538 | 1188538 | 2021-05-31 | Chile | Nuble | 30254 | 509 | 28660 | 1085 | -36.7226 | -71.7622 | 2021-06-01 04:23:09 | Nuble, Chile | ||
1952847 | 1952847 | 2021-05-21 | Togo | 13352 | 125 | 12142 | 1085 | 8.6195 | 0.8248 | 2021-05-22 04:20:45 | Togo | |||
1913001 | 1913001 | 2021-05-20 | Chile | Los Rios | 36778 | 416 | 35277 | 1085 | -40.231 | -72.3311 | 2021-05-21 04:20:43 | Los Rios, Chile | ||
170047 | 170047 | 2021-04-16 | Japan | Chiba | 31291 | 600 | 29606 | 1085 | 35.510141 | 140.198917 | 2021-04-17 04:20:40 | Chiba, Japan | ||
3085575 | 3085575 | 2021-04-05 | Sierra Leone | 3989 | 79 | 2825 | 1085 | 8.460555000000001 | -11.779889 | 2021-04-06 04:20:32 | Sierra Leone | |||
388498 | 388498 | 2021-04-04 | Sierra Leone | 3988 | 79 | 2824 | 1085 | 8.460555000000001 | -11.779889 | 2021-04-05 04:20:35 | Sierra Leone | |||
1203997 | 1203997 | 2021-03-22 | Russia | Buryatia Republic | 35485 | 761 | 33639 | 1085 | 52.7182426 | 109.492143 | 2021-03-23 05:26:18 | Buryatia Republic, Russia | ||
3663526 | 3663526 | 2021-03-09 | Germany | Saarland | 29598 | 893 | 27713 | 1085 | 49.3964 | 7.023 | 2021-03-10 05:24:35 | Saarland, Germany | ||
3663496 | 3663496 | 2021-03-09 | Eswatini | 17191 | 658 | 15448 | 1085 | -26.5225 | 31.4659 | 2021-03-10 05:24:35 | Eswatini | |||
3670375 | 3670375 | 2021-03-06 | US | Puerto Rico | Moca | 72099 | 1085 | 0 | 0 | 1085 | 18.377805 | -67.080952 | 2021-03-07 05:21:54 | Moca, Puerto Rico, US |
2210225 | 2210225 | 2021-03-04 | US | Oklahoma | Nowata | 40105 | 1101 | 16 | 0 | 1085 | 36.79843529 | -95.61902331 | 2021-03-05 05:26:29 | Nowata, Oklahoma, US |
1092646 | 1092646 | 2021-03-03 | US | Oklahoma | Nowata | 40105 | 1101 | 16 | 0 | 1085 | 36.79843529 | -95.61902331 | 2021-03-04 05:24:24 | Nowata, Oklahoma, US |
1091649 | 1091649 | 2021-03-03 | US | Maryland | Kent | 24029 | 1128 | 43 | 0 | 1085 | 39.24976208 | -76.04741541 | 2021-03-04 05:24:24 | Kent, Maryland, US |
1091021 | 1091021 | 2021-03-03 | US | Idaho | Teton | 16081 | 1089 | 4 | 0 | 1085 | 43.75303583 | -111.2056773 | 2021-03-04 05:24:24 | Teton, Idaho, US |
1089912 | 1089912 | 2021-03-03 | Colombia | Boyaca | 46407 | 1092 | 44230 | 1085 | 5.4545 | -73.362 | 2021-03-04 05:24:24 | Boyaca, Colombia | ||
1001165 | 1001165 | 2021-03-01 | US | Puerto Rico | Corozal | 72047 | 1085 | 0 | 0 | 1085 | 18.304264 | -66.327738 | 2021-03-02 05:23:30 | Corozal, Puerto Rico, US |
2370852 | 2370852 | 2021-02-28 | US | Virginia | Lexington | 51678 | 1108 | 23 | 0 | 1085 | 37.78258621 | -79.44262866 | 2021-03-01 05:23:01 | Lexington, Virginia, US |
3069354 | 3069354 | 2021-02-27 | US | Virginia | Lexington | 51678 | 1106 | 21 | 0 | 1085 | 37.78258621 | -79.44262866 | 2021-02-28 05:22:20 | Lexington, Virginia, US |
2186587 | 2186587 | 2021-02-26 | US | Texas | Aransas | 48007 | 1114 | 34 | 0 | 1085 | 28.10556197 | -96.9995047 | 2021-02-27 05:22:28 | Aransas, Texas, US |
1937441 | 1937441 | 2021-02-23 | US | Illinois | Jasper | 17079 | 1102 | 17 | 0 | 1085 | 39.01054275 | -88.15437049 | 2021-02-24 05:29:16 | Jasper, Illinois, US |
533736 | 533736 | 2021-02-22 | US | Texas | Callahan | 48059 | 1113 | 37 | 0 | 1085 | 32.29760619 | -99.37326312 | 2021-02-23 05:23:41 | Callahan, Texas, US |
185070 | 185070 | 2021-02-21 | US | Texas | Callahan | 48059 | 1113 | 37 | 0 | 1085 | 32.29760619 | -99.37326312 | 2021-02-22 05:24:21 | Callahan, Texas, US |
183030 | 183030 | 2021-02-21 | US | Illinois | Jasper | 17079 | 1102 | 17 | 0 | 1085 | 39.01054275 | -88.15437049 | 2021-02-22 05:24:21 | Jasper, Illinois, US |
745553 | 745553 | 2021-02-20 | US | Texas | Ward | 48475 | 1031 | 20 | 0 | 1085 | 31.50999644 | -103.0927909 | 2021-02-21 05:24:33 | Ward, Texas, US |
745344 | 745344 | 2021-02-20 | US | Texas | Callahan | 48059 | 1113 | 37 | 0 | 1085 | 32.29760619 | -99.37326312 | 2021-02-21 05:24:33 | Callahan, Texas, US |
743779 | 743779 | 2021-02-20 | US | Kentucky | Trigg | 21221 | 1093 | 8 | 0 | 1085 | 36.80767017 | -87.87333656 | 2021-02-21 05:24:33 | Trigg, Kentucky, US |
743304 | 743304 | 2021-02-20 | US | Illinois | Jasper | 17079 | 1102 | 17 | 0 | 1085 | 39.01054275 | -88.15437049 | 2021-02-21 05:24:33 | Jasper, Illinois, US |
1155877 | 1155877 | 2021-02-18 | US | Puerto Rico | Naranjito | 72105 | 1085 | 0 | 0 | 1085 | 18.288019 | -66.252703 | 2021-02-19 05:24:16 | Naranjito, Puerto Rico, US |
3603797 | 3603797 | 2021-02-17 | US | Puerto Rico | Naranjito | 72105 | 1085 | 0 | 0 | 1085 | 18.288019 | -66.252703 | 2021-02-18 05:22:58 | Naranjito, Puerto Rico, US |
3052932 | 3052932 | 2021-02-16 | US | Puerto Rico | Naranjito | 72105 | 1085 | 0 | 0 | 1085 | 18.288019 | -66.252703 | 2021-02-17 05:23:10 | Naranjito, Puerto Rico, US |
3542164 | 3542164 | 2021-02-12 | US | Puerto Rico | Aguadilla | 72005 | 1085 | 0 | 0 | 1085 | 18.459681 | -67.12081500000001 | 2021-02-13 05:22:12 | Aguadilla, Puerto Rico, US |
3541716 | 3541716 | 2021-02-12 | US | New York | Schoharie | 36095 | 1095 | 10 | 0 | 1085 | 42.58831742 | -74.44339029999998 | 2021-02-13 05:22:12 | Schoharie, New York, US |
2640427 | 2640427 | 2021-02-11 | US | Puerto Rico | Aguadilla | 72005 | 1085 | 0 | 0 | 1085 | 18.459681 | -67.12081500000001 | 2021-02-12 05:23:29 | Aguadilla, Puerto Rico, US |
2639395 | 2639395 | 2021-02-11 | US | Michigan | Roscommon | 26143 | 1116 | 31 | 0 | 1085 | 44.33473082 | -84.61067651 | 2021-02-12 05:23:29 | Roscommon, Michigan, US |
3981282 | 3981282 | 2021-02-10 | US | Puerto Rico | Aguadilla | 72005 | 1085 | 0 | 0 | 1085 | 18.459681 | -67.12081500000001 | 2021-02-11 05:23:55 | Aguadilla, Puerto Rico, US |
3980406 | 3980406 | 2021-02-10 | US | Mississippi | Perry | 28111 | 1117 | 32 | 0 | 1085 | 31.17161885 | -88.99281835 | 2021-02-11 05:23:55 | Perry, Mississippi, US |
3979770 | 3979770 | 2021-02-10 | US | Iowa | Humboldt | 19091 | 1107 | 22 | 0 | 1085 | 42.7764426 | -94.20722537 | 2021-02-11 05:23:55 | Humboldt, Iowa, US |
1528511 | 1528511 | 2021-02-09 | US | Colorado | Gunnison | 8051 | 1180 | 6 | 0 | 1085 | 38.66611652 | -107.0320729 | 2021-02-10 05:22:41 | Gunnison, Colorado, US |
1675950 | 1675950 | 2021-02-07 | US | West Virginia | Nicholas | 54067 | 1097 | 12 | 0 | 1085 | 38.29617706 | -80.79759588 | 2021-02-08 05:22:39 | Nicholas, West Virginia, US |
1589411 | 1589411 | 2021-02-05 | US | Iowa | Unassigned | 90019 | 1085 | 0 | 0 | 1085 | 43.38107862 | 0.0 | 2021-02-06 05:23:55 | Unassigned, Iowa, US |
793902 | 793902 | 2021-02-04 | US | Wisconsin | Bayfield | 55007 | 1103 | 18 | 0 | 1085 | 46.52868768 | -91.19716729 | 2021-02-05 05:22:38 | Bayfield, Wisconsin, US |
1686705 | 1686705 | 2021-02-02 | US | New Mexico | Socorro | 35053 | 1132 | 47 | 0 | 1085 | 34.00715494 | -106.9298354 | 2021-02-03 05:22:52 | Socorro, New Mexico, US |
1685907 | 1685907 | 2021-02-02 | US | Kentucky | Henry | 21103 | 1091 | 6 | 0 | 1085 | 38.44942688 | -85.11587507 | 2021-02-03 05:22:52 | Henry, Kentucky, US |
1679771 | 1679771 | 2021-02-01 | US | Virginia | Brunswick | 51025 | 1094 | 9 | 0 | 1085 | 36.76366949 | -77.8593436 | 2021-02-02 05:22:49 | Brunswick, Virginia, US |
2214956 | 2214956 | 2021-01-30 | US | Virginia | Alleghany | 51005 | 1116 | 31 | 0 | 1085 | 37.78636074 | -80.00222498 | 2021-01-31 05:22:42 | Alleghany, Virginia, US |
2214436 | 2214436 | 2021-01-30 | US | Puerto Rico | San Lorenzo | 72129 | 1085 | 0 | 0 | 1085 | 18.147987 | -65.976392 | 2021-01-31 05:22:42 | San Lorenzo, Puerto Rico, US |
15936 | 15936 | 2021-01-26 | US | Wyoming | Goshen | 56015 | 1105 | 20 | 0 | 1085 | 42.08798185 | -104.3534743 | 2021-01-27 05:23:41 | Goshen, Wyoming, US |
14486 | 14486 | 2021-01-26 | US | New Hampshire | Coos | 33007 | 1109 | 24 | 0 | 1085 | 44.69063265 | -71.30633239 | 2021-01-27 05:23:41 | Coos, New Hampshire, US |
12534 | 12534 | 2021-01-26 | Russia | Chuvashia Republic | 19009 | 819 | 17105 | 1085 | 55.4259922 | 47.0849429 | 2021-01-27 05:23:41 | Chuvashia Republic, Russia | ||
2569371 | 2569371 | 2021-01-25 | US | Minnesota | Faribault | 27043 | 1101 | 16 | 0 | 1085 | 43.67381499 | -93.94787458 | 2021-01-26 05:22:02 | Faribault, Minnesota, US |
1760736 | 1760736 | 2021-01-24 | US | Kentucky | Monroe | 21171 | 1118 | 33 | 0 | 1085 | 36.71225341 | -85.71596443 | 2021-01-25 05:22:16 | Monroe, Kentucky, US |
2469153 | 2469153 | 2021-01-22 | US | North Carolina | Polk | 37149 | 1101 | 16 | 0 | 1085 | 35.27820615 | -82.16812354 | 2021-01-23 05:22:03 | Polk, North Carolina, US |
436324 | 436324 | 2021-01-21 | US | Illinois | Cumberland | 17035 | 1100 | 15 | 0 | 1085 | 39.27432424 | -88.2401158 | 2021-01-22 05:22:10 | Cumberland, Illinois, US |
1097521 | 1097521 | 2021-01-20 | US | Washington | Island | 53029 | 1107 | 22 | 0 | 1085 | 48.14713305 | -122.5216407 | 2021-01-21 05:22:01 | Island, Washington, US |
237229 | 237229 | 2021-01-18 | Italy | Molise | 7586 | 233 | 6268 | 1085 | 41.55774754 | 14.65916051 | 2021-01-19 05:22:15 | Molise, Italy | ||
3505910 | 3505910 | 2021-01-17 | US | Oklahoma | Johnston | 40069 | 1097 | 12 | 0 | 1085 | 34.31440473 | -96.66011537 | 2021-01-18 05:22:34 | Johnston, Oklahoma, US |
3505109 | 3505109 | 2021-01-17 | US | Minnesota | Rock | 27133 | 1097 | 12 | 0 | 1085 | 43.67482683 | -96.25296832 | 2021-01-18 05:22:34 | Rock, Minnesota, US |
3504519 | 3504519 | 2021-01-17 | US | Iowa | Cass | 19029 | 1126 | 41 | 0 | 1085 | 41.33149454 | -94.92792482 | 2021-01-18 05:22:34 | Cass, Iowa, US |
3101994 | 3101994 | 2021-01-16 | US | California | Mono | 6051 | 1091 | 3 | 0 | 1085 | 37.93899289 | -118.8872409 | 2021-01-17 05:22:17 | Mono, California, US |
3518154 | 3518154 | 2021-01-15 | US | Puerto Rico | Mayaguez | 72097 | 1085 | 0 | 0 | 1085 | 18.2013 | -67.1452 | 2021-01-16 05:22:40 | Mayaguez, Puerto Rico, US |
3880692 | 3880692 | 2021-01-14 | US | Indiana | Pike | 18125 | 1113 | 28 | 0 | 1085 | 38.40112197 | -87.23574907 | 2021-01-15 05:22:24 | Pike, Indiana, US |
777176 | 777176 | 2021-01-12 | US | South Carolina | Saluda | 45081 | 1114 | 29 | 0 | 1085 | 34.00795823 | -81.72713237 | 2021-01-13 05:22:15 | Saluda, South Carolina, US |
775740 | 775740 | 2021-01-12 | US | Kentucky | Garrard | 21079 | 1089 | 4 | 0 | 1085 | 37.6388668 | -84.53289319 | 2021-01-13 05:22:15 | Garrard, Kentucky, US |
2626229 | 2626229 | 2021-01-10 | US | Alabama | Crenshaw | 1041 | 1123 | 38 | 0 | 1085 | 31.72941803 | -86.31593104 | 2021-01-11 05:21:50 | Crenshaw, Alabama, US |
157502 | 157502 | 2021-01-08 | US | Wisconsin | Buffalo | 55011 | 1092 | 7 | 0 | 1085 | 44.37835084 | -91.75332578 | 2021-01-09 05:22:18 | Buffalo, Wisconsin, US |
2544781 | 2544781 | 2021-01-07 | US | Virginia | Orange | 51137 | 1099 | 14 | 0 | 1085 | 38.24530219 | -78.01560400000002 | 2021-01-08 05:22:42 | Orange, Virginia, US |
2868373 | 2868373 | 2021-01-06 | Uzbekistan | 77350 | 615 | 75650 | 1085 | 41.377491 | 64.585262 | 2021-01-07 05:22:03 | Uzbekistan | |||
2864909 | 2864909 | 2021-01-06 | Russia | Chuvashia Republic | 16997 | 591 | 15321 | 1085 | 55.4259922 | 47.0849429 | 2021-01-07 05:22:03 | Chuvashia Republic, Russia | ||
1137864 | 1137864 | 2021-01-01 | US | Illinois | Greene | 17061 | 1115 | 30 | 0 | 1085 | 39.35907414 | -90.388865 | 2021-01-02 05:22:33 | Greene, Illinois, US |
3696470 | 3696470 | 2020-12-31 | US | Illinois | Greene | 17061 | 1115 | 30 | 0 | 1085 | 39.35907414 | -90.388865 | 2021-01-01 05:23:07 | Greene, Illinois, US |
768881 | 768881 | 2020-12-29 | US | Oklahoma | Marshall | 40095 | 1091 | 6 | 0 | 1085 | 34.02311222 | -96.76855464 | 2020-12-30 05:22:34 | Marshall, Oklahoma, US |
767139 | 767139 | 2020-12-29 | US | Georgia | Jones | 13169 | 1109 | 24 | 0 | 1085 | 33.02512137 | -83.56019163 | 2020-12-30 05:22:34 | Jones, Georgia, US |
3781303 | 3781303 | 2020-12-27 | US | Virginia | Southampton | 51175 | 1127 | 42 | 0 | 1085 | 36.72231125 | -77.10642712 | 2020-12-28 05:22:06 | Southampton, Virginia, US |
202719 | 202719 | 2020-12-25 | US | Arkansas | Cleburne | 5023 | 1120 | 35 | 0 | 1085 | 35.53864922 | -92.02640019 | 2020-12-26 05:22:28 | Cleburne, Arkansas, US |
3771378 | 3771378 | 2020-12-22 | US | Louisiana | LaSalle | 22059 | 1108 | 23 | 0 | 1085 | 31.67884782 | -92.15907765 | 2020-12-23 05:22:03 | LaSalle, Louisiana, US |
931261 | 931261 | 2020-12-21 | US | Wisconsin | Rusk | 55107 | 1096 | 11 | 0 | 1085 | 45.47498854 | -91.1333012 | 2020-12-22 05:22:33 | Rusk, Wisconsin, US |
928508 | 928508 | 2020-12-21 | US | Georgia | Jeff Davis | 13161 | 1119 | 34 | 0 | 1085 | 31.80405727 | -82.63724870000001 | 2020-12-22 05:22:33 | Jeff Davis, Georgia, US |
928159 | 928159 | 2020-12-21 | US | Arkansas | Conway | 5029 | 1095 | 10 | 0 | 1085 | 35.26205537 | -92.70506566 | 2020-12-22 05:22:33 | Conway, Arkansas, US |
928063 | 928063 | 2020-12-21 | US | Alabama | Henry | 1067 | 1093 | 8 | 0 | 1085 | 31.51148016 | -85.24267944 | 2020-12-22 05:22:33 | Henry, Alabama, US |
2933947 | 2933947 | 2020-12-19 | US | Puerto Rico | Dorado | 72051 | 1085 | 0 | 0 | 1085 | 18.436115 | -66.278669 | 2020-12-20 05:27:32 | Dorado, Puerto Rico, US |
1037071 | 1037071 | 2020-12-15 | US | Pennsylvania | Wayne | 42127 | 1100 | 15 | 0 | 1085 | 41.64938475 | -75.29956506 | 2020-12-16 05:28:04 | Wayne, Pennsylvania, US |
1754670 | 1754670 | 2020-12-14 | US | Virginia | Staunton | 51790 | 1103 | 18 | 0 | 1085 | 38.15965544 | -79.05979937 | 2020-12-15 05:26:38 | Staunton, Virginia, US |
1752100 | 1752100 | 2020-12-14 | US | Georgia | McDuffie | 13189 | 1108 | 23 | 0 | 1085 | 33.47851918 | -82.48252774 | 2020-12-15 05:26:38 | McDuffie, Georgia, US |
3850576 | 3850576 | 2020-12-13 | US | South Carolina | Abbeville | 45001 | 1108 | 23 | 0 | 1085 | 34.22333378 | -82.46170658 | 2020-12-14 05:26:27 | Abbeville, South Carolina, US |
3847981 | 3847981 | 2020-12-13 | Russia | Chuvashia Republic | 14177 | 370 | 12722 | 1085 | 55.4259922 | 47.0849429 | 2020-12-14 05:26:27 | Chuvashia Republic, Russia | ||
862079 | 862079 | 2020-12-11 | US | Kentucky | Hart | 21099 | 1090 | 5 | 0 | 1085 | 37.29943898 | -85.88461055 | 2020-12-12 05:26:19 | Hart, Kentucky, US |
1601919 | 1601919 | 2020-12-10 | US | Minnesota | Cottonwood | 27033 | 1090 | 5 | 0 | 1085 | 44.00715262 | -95.18138802 | 2020-12-11 05:26:59 | Cottonwood, Minnesota, US |
2977878 | 2977878 | 2020-12-09 | US | Pennsylvania | Clinton | 42035 | 1098 | 13 | 0 | 1085 | 41.23255967 | -77.63785995 | 2020-12-10 05:26:19 | Clinton, Pennsylvania, US |
1819532 | 1819532 | 2020-12-08 | US | Georgia | Ben Hill | 13017 | 1125 | 40 | 0 | 1085 | 31.76095874 | -83.22145359 | 2020-12-09 05:28:01 | Ben Hill, Georgia, US |
1819281 | 1819281 | 2020-12-08 | US | Arkansas | Logan | 5083 | 1092 | 7 | 0 | 1085 | 35.21413234 | -93.71951016 | 2020-12-09 05:28:01 | Logan, Arkansas, US |
2349994 | 2349994 | 2020-12-07 | US | Oklahoma | Okfuskee | 40107 | 1100 | 15 | 0 | 1085 | 35.46485198 | -96.32639984 | 2020-12-08 05:27:42 | Okfuskee, Oklahoma, US |
1006146 | 1006146 | 2020-12-06 | Colombia | Magdalena | 21212 | 993 | 19134 | 1085 | 10.4113 | -74.4057 | 2020-12-07 05:26:14 | Magdalena, Colombia | ||
1633230 | 1633230 | 2020-12-05 | US | Idaho | Gem | 16045 | 1091 | 6 | 0 | 1085 | 44.06482372 | -116.398376 | 2020-12-06 05:26:18 | Gem, Idaho, US |
77737 | 77737 | 2020-12-03 | US | Pennsylvania | Clarion | 42031 | 1096 | 11 | 0 | 1085 | 41.19265812 | -79.42413524 | 2020-12-04 05:27:27 | Clarion, Pennsylvania, 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]);