johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
215 rows where active = 1136 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2947304 | 2947304 | 2021-07-16 | India | Himachal Pradesh | 204224 | 3504 | 199584 | 1136 | 31.927213 | 77.233081 | 2021-07-17 04:22:22 | Himachal Pradesh, India | ||
2299131 | 2299131 | 2021-06-24 | Malaysia | Pulau Pinang | 33591 | 116 | 32339 | 1136 | 5.4141 | 100.3288 | 2021-06-25 04:21:33 | Pulau Pinang, Malaysia | ||
562945 | 562945 | 2021-06-22 | Italy | Abruzzo | 74635 | 2509 | 70990 | 1136 | 42.35122196 | 13.39843823 | 2021-06-23 04:21:46 | Abruzzo, Italy | ||
2339603 | 2339603 | 2021-06-15 | Russia | Karelia Republic | 48182 | 587 | 46459 | 1136 | 62.61940309999999 | 33.4920267 | 2021-06-16 04:22:32 | Karelia Republic, Russia | ||
825841 | 825841 | 2021-06-06 | Russia | Vladimir Oblast | 33834 | 1211 | 31487 | 1136 | 56.0503336 | 40.6561633 | 2021-06-07 04:22:51 | Vladimir Oblast, Russia | ||
3089680 | 3089680 | 2021-05-30 | Russia | Vladimir Oblast | 33494 | 1192 | 31166 | 1136 | 56.0503336 | 40.6561633 | 2021-05-31 03:08:59 | Vladimir Oblast, Russia | ||
726741 | 726741 | 2021-05-22 | Russia | Samara Oblast | 64036 | 1812 | 61088 | 1136 | 53.2128813 | 50.8914633 | 2021-05-23 04:20:51 | Samara Oblast, Russia | ||
1081706 | 1081706 | 2021-05-14 | Chile | Antofagasta | 50708 | 994 | 48578 | 1136 | -23.6509 | -70.3975 | 2021-05-15 04:20:58 | Antofagasta, Chile | ||
2450633 | 2450633 | 2021-05-02 | Colombia | Tolima | 69974 | 2230 | 66608 | 1136 | 4.0925 | -75.1545 | 2021-05-03 04:20:39 | Tolima, Colombia | ||
2410787 | 2410787 | 2021-04-19 | India | Dadra and Nagar Haveli and Daman and Diu | 5102 | 4 | 3962 | 1136 | 20.194742 | 73.080901 | 2021-04-20 04:20:41 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3421170 | 3421170 | 2021-03-19 | Russia | Tula Oblast | 35113 | 1439 | 32538 | 1136 | 53.9570701 | 37.3690909 | 2021-03-20 05:25:46 | Tula Oblast, Russia | ||
1090418 | 1090418 | 2021-03-03 | US | Alabama | Bullock | 1011 | 1172 | 36 | 0 | 1136 | 32.10030533 | -85.71265535 | 2021-03-04 05:24:24 | Bullock, Alabama, US |
1937090 | 1937090 | 2021-02-23 | US | Colorado | Prowers | 8099 | 1167 | 21 | 0 | 1136 | 37.95544985 | -102.3926052 | 2021-02-24 05:29:16 | Prowers, Colorado, US |
531345 | 531345 | 2021-02-22 | US | Colorado | Prowers | 8099 | 1167 | 21 | 0 | 1136 | 37.95544985 | -102.3926052 | 2021-02-23 05:23:41 | Prowers, Colorado, US |
182679 | 182679 | 2021-02-21 | US | Colorado | Prowers | 8099 | 1167 | 21 | 0 | 1136 | 37.95544985 | -102.3926052 | 2021-02-22 05:24:21 | Prowers, Colorado, US |
181893 | 181893 | 2021-02-21 | Colombia | Narino | 48440 | 1579 | 45725 | 1136 | 1.2892 | -77.3579 | 2021-02-22 05:24:21 | Narino, Colombia | ||
742953 | 742953 | 2021-02-20 | US | Colorado | Prowers | 8099 | 1166 | 21 | 0 | 1136 | 37.95544985 | -102.3926052 | 2021-02-21 05:24:33 | Prowers, Colorado, US |
472884 | 472884 | 2021-02-19 | US | Kentucky | Webster | 21233 | 1153 | 17 | 0 | 1136 | 37.52168356 | -87.67989953 | 2021-02-20 05:22:51 | Webster, Kentucky, US |
472789 | 472789 | 2021-02-19 | US | Kentucky | Casey | 21045 | 1169 | 33 | 0 | 1136 | 37.32533118 | -84.92726209 | 2021-02-20 05:22:51 | Casey, Kentucky, US |
1154950 | 1154950 | 2021-02-18 | US | Mississippi | Perry | 28111 | 1169 | 33 | 0 | 1136 | 31.17161885 | -88.99281835 | 2021-02-19 05:24:16 | Perry, Mississippi, US |
3051928 | 3051928 | 2021-02-16 | US | Minnesota | Rock | 27133 | 1148 | 12 | 0 | 1136 | 43.67482683 | -96.25296832 | 2021-02-17 05:23:10 | Rock, Minnesota, US |
1340027 | 1340027 | 2021-02-15 | US | Minnesota | Rock | 27133 | 1148 | 12 | 0 | 1136 | 43.67482683 | -96.25296832 | 2021-02-16 05:24:38 | Rock, Minnesota, US |
1339205 | 1339205 | 2021-02-15 | US | Idaho | Idaho | 16049 | 1153 | 17 | 0 | 1136 | 45.84721541 | -115.4634436 | 2021-02-16 05:24:38 | Idaho, Idaho, US |
2284356 | 2284356 | 2021-02-14 | US | Idaho | Idaho | 16049 | 1153 | 17 | 0 | 1136 | 45.84721541 | -115.4634436 | 2021-02-15 05:24:49 | Idaho, Idaho, US |
2283647 | 2283647 | 2021-02-14 | Russia | Mari El Republic | 11262 | 160 | 9966 | 1136 | 56.5767504 | 47.8817512 | 2021-02-15 05:24:49 | Mari El Republic, Russia | ||
2678756 | 2678756 | 2021-02-13 | US | Idaho | Idaho | 16049 | 1153 | 17 | 0 | 1136 | 45.84721541 | -115.4634436 | 2021-02-14 05:23:43 | Idaho, Idaho, US |
3542919 | 3542919 | 2021-02-12 | US | West Virginia | Barbour | 54001 | 1156 | 20 | 0 | 1136 | 39.1307219 | -80.00350858 | 2021-02-13 05:22:12 | Barbour, West Virginia, US |
3542795 | 3542795 | 2021-02-12 | US | Virginia | Goochland | 51075 | 1144 | 8 | 0 | 1136 | 37.71714806 | -77.90381514 | 2021-02-13 05:22:12 | Goochland, Virginia, US |
3540389 | 3540389 | 2021-02-12 | US | Idaho | Idaho | 16049 | 1153 | 17 | 0 | 1136 | 45.84721541 | -115.4634436 | 2021-02-13 05:22:12 | Idaho, Idaho, US |
2641022 | 2641022 | 2021-02-11 | US | Virginia | Brunswick | 51025 | 1146 | 10 | 0 | 1136 | 36.76366949 | -77.8593436 | 2021-02-12 05:23:29 | Brunswick, Virginia, US |
2639128 | 2639128 | 2021-02-11 | US | Kentucky | Henry | 21103 | 1142 | 6 | 0 | 1136 | 38.44942688 | -85.11587507 | 2021-02-12 05:23:29 | Henry, Kentucky, US |
2638950 | 2638950 | 2021-02-11 | US | Iowa | Sac | 19161 | 1153 | 17 | 0 | 1136 | 42.38624071 | -95.10547892 | 2021-02-12 05:23:29 | Sac, Iowa, US |
3979996 | 3979996 | 2021-02-10 | US | Kentucky | Lee | 21129 | 1154 | 18 | 0 | 1136 | 37.59645942 | -83.71513901 | 2021-02-11 05:23:55 | Lee, Kentucky, US |
3979805 | 3979805 | 2021-02-10 | US | Iowa | Sac | 19161 | 1153 | 17 | 0 | 1136 | 42.38624071 | -95.10547892 | 2021-02-11 05:23:55 | Sac, Iowa, US |
1529719 | 1529719 | 2021-02-09 | US | Mississippi | Montgomery | 28097 | 1172 | 36 | 0 | 1136 | 33.49419589 | -89.61729103 | 2021-02-10 05:22:41 | Montgomery, Mississippi, US |
615791 | 615791 | 2021-02-08 | US | Nebraska | Red Willow | 31145 | 1147 | 11 | 0 | 1136 | 40.17556879999999 | -100.476998 | 2021-02-09 05:23:30 | Red Willow, Nebraska, US |
1673234 | 1673234 | 2021-02-07 | US | Georgia | Dade | 13083 | 1145 | 9 | 0 | 1136 | 34.854916700000004 | -85.50490424 | 2021-02-08 05:22:39 | Dade, Georgia, US |
790232 | 790232 | 2021-02-04 | Colombia | Huila | 47200 | 1539 | 44525 | 1136 | 2.5359 | -75.5277 | 2021-02-05 05:22:38 | Huila, Colombia | ||
342378 | 342378 | 2021-02-03 | US | Nebraska | Red Willow | 31145 | 1146 | 10 | 0 | 1136 | 40.17556879999999 | -100.476998 | 2021-02-04 05:22:26 | Red Willow, Nebraska, US |
1678805 | 1678805 | 2021-02-01 | US | North Carolina | Mitchell | 37121 | 1149 | 13 | 0 | 1136 | 36.01059309 | -82.1582442 | 2021-02-02 05:22:49 | Mitchell, North Carolina, US |
1462390 | 1462390 | 2021-01-31 | US | Oregon | Wasco | 41065 | 1159 | 23 | 0 | 1136 | 45.16292781 | -121.1670954 | 2021-02-01 05:22:53 | Wasco, Oregon, US |
2214298 | 2214298 | 2021-01-30 | US | Oregon | Wasco | 41065 | 1159 | 23 | 0 | 1136 | 45.16292781 | -121.1670954 | 2021-01-31 05:22:42 | Wasco, Oregon, US |
2212829 | 2212829 | 2021-01-30 | US | Iowa | Cass | 19029 | 1180 | 44 | 0 | 1136 | 41.33149454 | -94.92792482 | 2021-01-31 05:22:42 | Cass, Iowa, US |
2485034 | 2485034 | 2021-01-28 | US | Texas | Dimmit | 48127 | 1251 | 18 | 0 | 1136 | 28.42270064 | -99.75645095 | 2021-01-29 05:22:23 | Dimmit, Texas, US |
3156007 | 3156007 | 2021-01-27 | US | North Dakota | McLean | 38055 | 1170 | 31 | 0 | 1136 | 47.60766714 | -101.3182418 | 2021-01-28 05:22:24 | McLean, North Dakota, US |
3154022 | 3154022 | 2021-01-27 | US | Alaska | Juneau | 2110 | 1141 | 5 | 0 | 1136 | 58.45031811 | -134.200436 | 2021-01-28 05:22:24 | Juneau, Alaska, US |
16018 | 16018 | 2021-01-26 | Malaysia | Negeri Sembilan | 11222 | 20 | 10066 | 1136 | 2.7258 | 101.9424 | 2021-01-27 05:23:41 | Negeri Sembilan, Malaysia | ||
15774 | 15774 | 2021-01-26 | US | Washington | Island | 53029 | 1158 | 22 | 0 | 1136 | 48.14713305 | -122.5216407 | 2021-01-27 05:23:41 | Island, Washington, US |
13614 | 13614 | 2021-01-26 | US | Kansas | Ellsworth | 20053 | 1154 | 18 | 0 | 1136 | 38.69677695 | -98.20462799 | 2021-01-27 05:23:41 | Ellsworth, Kansas, US |
13553 | 13553 | 2021-01-26 | US | Iowa | Mitchell | 19131 | 1173 | 37 | 0 | 1136 | 43.35638371 | -92.78887719 | 2021-01-27 05:23:41 | Mitchell, Iowa, US |
2570963 | 2570963 | 2021-01-25 | US | Virginia | Bristol | 51520 | 1160 | 24 | 0 | 1136 | 36.6163024 | -82.16359122 | 2021-01-26 05:22:02 | Bristol, Virginia, US |
2568938 | 2568938 | 2021-01-25 | US | Kansas | Ellsworth | 20053 | 1154 | 18 | 0 | 1136 | 38.69677695 | -98.20462799 | 2021-01-26 05:22:02 | Ellsworth, Kansas, US |
1762771 | 1762771 | 2021-01-24 | US | West Virginia | Hardy | 54031 | 1150 | 14 | 0 | 1136 | 39.00683177 | -78.85855301 | 2021-01-25 05:22:16 | Hardy, West Virginia, US |
2466999 | 2466999 | 2021-01-22 | Russia | Chuvashia Republic | 18609 | 769 | 16704 | 1136 | 55.4259922 | 47.0849429 | 2021-01-23 05:22:03 | Chuvashia Republic, Russia | ||
438695 | 438695 | 2021-01-21 | US | Virginia | Greensville | 51081 | 1153 | 17 | 0 | 1136 | 36.67878901 | -77.56351439 | 2021-01-22 05:22:10 | Greensville, Virginia, US |
239095 | 239095 | 2021-01-18 | US | Mississippi | Yalobusha | 28161 | 1170 | 34 | 0 | 1136 | 34.02824175 | -89.70762049999998 | 2021-01-19 05:22:15 | Yalobusha, Mississippi, US |
3518722 | 3518722 | 2021-01-15 | US | Virginia | Dinwiddie | 51053 | 1153 | 17 | 0 | 1136 | 37.07544585 | -77.63451754 | 2021-01-16 05:22:40 | Dinwiddie, Virginia, US |
3515760 | 3515760 | 2021-01-15 | US | Alabama | Crenshaw | 1041 | 1180 | 44 | 0 | 1136 | 31.72941803 | -86.31593104 | 2021-01-16 05:22:40 | Crenshaw, Alabama, US |
3881208 | 3881208 | 2021-01-14 | US | Michigan | Iosco | 26069 | 1192 | 56 | 0 | 1136 | 44.35486835 | -83.63484895 | 2021-01-15 05:22:24 | Iosco, Michigan, US |
3311564 | 3311564 | 2021-01-13 | US | Virginia | Martinsville | 51690 | 1164 | 28 | 0 | 1136 | 36.68212094 | -79.86352771 | 2021-01-14 05:22:32 | Martinsville, Virginia, US |
3309227 | 3309227 | 2021-01-13 | US | Illinois | Piatt | 17147 | 1146 | 10 | 0 | 1136 | 40.01360584 | -88.59319339 | 2021-01-14 05:22:32 | Piatt, Illinois, US |
774722 | 774722 | 2021-01-12 | US | Alabama | Lamar | 1075 | 1153 | 17 | 0 | 1136 | 33.77995024 | -88.09668032 | 2021-01-13 05:22:15 | Lamar, Alabama, US |
154976 | 154976 | 2021-01-08 | US | Illinois | Johnson | 17087 | 1145 | 9 | 0 | 1136 | 37.45939802 | -88.88165419 | 2021-01-09 05:22:18 | Johnson, Illinois, US |
2865308 | 2865308 | 2021-01-06 | US | Colorado | Bent | 8011 | 1231 | 20 | 0 | 1136 | 37.95474293 | -103.0720195 | 2021-01-07 05:22:03 | Bent, Colorado, US |
3037960 | 3037960 | 2021-01-05 | Uzbekistan | 77295 | 614 | 75545 | 1136 | 41.377491 | 64.585262 | 2021-01-06 05:22:16 | Uzbekistan | |||
1063267 | 1063267 | 2021-01-04 | US | Kentucky | Letcher | 21133 | 1140 | 4 | 0 | 1136 | 37.12306748 | -82.85346474 | 2021-01-05 05:21:49 | Letcher, Kentucky, US |
1062776 | 1062776 | 2021-01-04 | US | Idaho | Gooding | 16047 | 1154 | 18 | 0 | 1136 | 42.96927962 | -114.8108306 | 2021-01-05 05:21:49 | Gooding, Idaho, US |
3234019 | 3234019 | 2021-01-03 | US | Wisconsin | Rusk | 55107 | 1149 | 13 | 0 | 1136 | 45.47498854 | -91.1333012 | 2021-01-04 05:22:02 | Rusk, Wisconsin, US |
2228038 | 2228038 | 2021-01-02 | US | Arkansas | Sharp | 5135 | 1168 | 32 | 0 | 1136 | 36.16258158 | -91.47819342 | 2021-01-03 05:22:52 | Sharp, Arkansas, US |
1138238 | 1138238 | 2021-01-01 | US | Kentucky | Allen | 21003 | 1153 | 17 | 0 | 1136 | 36.75197631 | -86.19457544 | 2021-01-02 05:22:33 | Allen, Kentucky, US |
3696844 | 3696844 | 2020-12-31 | US | Kentucky | Allen | 21003 | 1153 | 17 | 0 | 1136 | 36.75197631 | -86.19457544 | 2021-01-01 05:23:07 | Allen, Kentucky, US |
3696310 | 3696310 | 2020-12-31 | US | Georgia | Lamar | 13171 | 1168 | 32 | 0 | 1136 | 33.07841647 | -84.14263877 | 2021-01-01 05:23:07 | Lamar, Georgia, US |
1013818 | 1013818 | 2020-12-30 | US | West Virginia | Wyoming | 54109 | 1155 | 19 | 0 | 1136 | 37.612327 | -81.54511071 | 2020-12-31 05:22:49 | Wyoming, West Virginia, US |
1011659 | 1011659 | 2020-12-30 | US | Kentucky | Allen | 21003 | 1153 | 17 | 0 | 1136 | 36.75197631 | -86.19457544 | 2020-12-31 05:22:49 | Allen, Kentucky, US |
3780131 | 3780131 | 2020-12-27 | US | New York | Greene | 36039 | 1154 | 18 | 0 | 1136 | 42.275797 | -74.12384884 | 2020-12-28 05:22:06 | Greene, New York, US |
3693341 | 3693341 | 2020-12-24 | US | Missouri | Benton | 29015 | 1152 | 16 | 0 | 1136 | 38.29503305 | -93.28756116 | 2020-12-25 05:22:48 | Benton, Missouri, US |
3692251 | 3692251 | 2020-12-24 | US | Georgia | Cook | 13075 | 1158 | 22 | 0 | 1136 | 31.16068491 | -83.42947229 | 2020-12-25 05:22:48 | Cook, Georgia, US |
2408056 | 2408056 | 2020-12-23 | US | Iowa | Poweshiek | 19157 | 1160 | 24 | 0 | 1136 | 41.68625425 | -92.53155731 | 2020-12-24 05:23:04 | Poweshiek, Iowa, US |
930258 | 930258 | 2020-12-21 | US | Oklahoma | McIntosh | 40091 | 1150 | 14 | 0 | 1136 | 35.37235506 | -95.66599306 | 2020-12-22 05:22:33 | McIntosh, Oklahoma, US |
928493 | 928493 | 2020-12-21 | US | Georgia | Grady | 13131 | 1168 | 32 | 0 | 1136 | 30.87454847 | -84.23418364 | 2020-12-22 05:22:33 | Grady, Georgia, US |
2122142 | 2122142 | 2020-12-20 | US | Ohio | Adams | 39001 | 1163 | 27 | 0 | 1136 | 38.84541072 | -83.4718964 | 2020-12-21 05:27:58 | Adams, Ohio, US |
2121253 | 2121253 | 2020-12-20 | US | Louisiana | Winn | 22127 | 1165 | 29 | 0 | 1136 | 31.94449367 | -92.63789413 | 2020-12-21 05:27:58 | Winn, Louisiana, US |
2119724 | 2119724 | 2020-12-20 | Japan | Hiroshima | 2300 | 15 | 1149 | 1136 | 34.605309000000005 | 132.788719 | 2020-12-21 05:27:58 | Hiroshima, Japan | ||
2119720 | 2119720 | 2020-12-20 | Japan | Fukuoka | 7366 | 114 | 6116 | 1136 | 33.526032 | 130.666949 | 2020-12-21 05:27:58 | Fukuoka, Japan | ||
2933740 | 2933740 | 2020-12-19 | US | Oklahoma | Atoka | 40005 | 1138 | 2 | 0 | 1136 | 34.37366573 | -96.03802487 | 2020-12-20 05:27:32 | Atoka, Oklahoma, US |
2932021 | 2932021 | 2020-12-19 | US | Georgia | Grady | 13131 | 1168 | 32 | 0 | 1136 | 30.87454847 | -84.23418364 | 2020-12-20 05:27:32 | Grady, Georgia, US |
2931436 | 2931436 | 2020-12-19 | Russia | Kurgan Oblast | 10723 | 139 | 9448 | 1136 | 55.7655302 | 64.5632681 | 2020-12-20 05:27:32 | Kurgan Oblast, Russia | ||
1902562 | 1902562 | 2020-12-18 | US | Kentucky | Grayson | 21085 | 1163 | 27 | 0 | 1136 | 37.46231118 | -86.34248968 | 2020-12-19 05:27:52 | Grayson, Kentucky, US |
2131029 | 2131029 | 2020-12-17 | US | Texas | Childress | 48075 | 1177 | 3 | 0 | 1136 | 34.529304100000004 | -100.2077916 | 2020-12-18 05:28:18 | Childress, Texas, US |
2128846 | 2128846 | 2020-12-17 | US | Georgia | Putnam | 13237 | 1166 | 30 | 0 | 1136 | 33.32056115 | -83.37552891 | 2020-12-18 05:28:18 | Putnam, Georgia, US |
3150373 | 3150373 | 2020-12-16 | US | Georgia | Dodge | 13091 | 1194 | 58 | 0 | 1136 | 32.17265114 | -83.16948926 | 2020-12-17 05:28:12 | Dodge, Georgia, US |
3149808 | 3149808 | 2020-12-16 | Russia | Kurgan Oblast | 10394 | 132 | 9126 | 1136 | 55.7655302 | 64.5632681 | 2020-12-17 05:28:12 | Kurgan Oblast, Russia | ||
1034589 | 1034589 | 2020-12-15 | Russia | Kurgan Oblast | 10287 | 127 | 9024 | 1136 | 55.7655302 | 64.5632681 | 2020-12-16 05:28:04 | Kurgan Oblast, Russia | ||
847318 | 847318 | 2020-12-12 | US | Minnesota | Renville | 27129 | 1169 | 33 | 0 | 1136 | 44.72836381 | -94.94553734 | 2020-12-13 05:27:20 | Renville, Minnesota, US |
1819675 | 1819675 | 2020-12-08 | US | Georgia | Washington | 13303 | 1171 | 35 | 0 | 1136 | 32.96711864 | -82.79357039 | 2020-12-09 05:28:01 | Washington, Georgia, US |
2349204 | 2349204 | 2020-12-07 | US | Mississippi | Chickasaw | 28017 | 1169 | 33 | 0 | 1136 | 33.91983202 | -88.9481545 | 2020-12-08 05:27:42 | Chickasaw, Mississippi, US |
3862050 | 3862050 | 2020-12-04 | US | New York | Cortland | 36023 | 1140 | 4 | 0 | 1136 | 42.59509207 | -76.07048931 | 2020-12-05 05:27:36 | Cortland, New York, US |
76180 | 76180 | 2020-12-03 | US | Indiana | Jay | 18075 | 1155 | 19 | 0 | 1136 | 40.43781032 | -85.00576229 | 2020-12-04 05:27:27 | Jay, Indiana, US |
75957 | 75957 | 2020-12-03 | US | Georgia | Tattnall | 13267 | 1164 | 28 | 0 | 1136 | 32.04785085 | -82.05539188 | 2020-12-04 05:27:27 | Tattnall, Georgia, US |
741815 | 741815 | 2020-12-02 | US | Wisconsin | Adams | 55001 | 1144 | 8 | 0 | 1136 | 43.96974651 | -89.76782777 | 2020-12-03 05:28:22 | Adams, Wisconsin, 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]);