johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
226 rows where active = 1040 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3632176 | 3632176 | 2021-07-14 | Russia | Kurgan Oblast | 23671 | 471 | 22160 | 1040 | 55.7655302 | 64.5632681 | 2021-07-15 04:21:48 | Kurgan Oblast, Russia | ||
2072181 | 2072181 | 2021-07-02 | Russia | Yamalo-Nenets Autonomous Okrug | 40258 | 432 | 38786 | 1040 | 67.1471631 | 74.3415488 | 2021-07-03 04:21:37 | Yamalo-Nenets Autonomous Okrug, Russia | ||
107699 | 107699 | 2021-06-19 | Russia | Smolensk Oblast | 32725 | 1077 | 30608 | 1040 | 55.03434960000001 | 33.0192065 | 2021-06-20 04:21:48 | Smolensk Oblast, Russia | ||
2315444 | 2315444 | 2021-06-04 | Pakistan | Balochistan | 25589 | 287 | 24262 | 1040 | 28.328492 | 65.898403 | 2021-06-05 04:23:03 | Balochistan, Pakistan | ||
2104114 | 2104114 | 2021-06-01 | Italy | Liguria | 102780 | 4324 | 97416 | 1040 | 44.41149315 | 8.9326992 | 2021-06-02 04:24:34 | Liguria, Italy | ||
2008340 | 2008340 | 2021-05-12 | Malaysia | Perak | 16033 | 55 | 14938 | 1040 | 4.5921 | 101.0901 | 2021-05-13 04:20:51 | Perak, Malaysia | ||
3397077 | 3397077 | 2021-04-28 | Malaysia | Sabah | 57917 | 434 | 56443 | 1040 | 5.9788 | 116.0753 | 2021-04-29 04:20:55 | Sabah, Malaysia | ||
2645610 | 2645610 | 2021-04-08 | Colombia | Risaralda | 50478 | 1235 | 48203 | 1040 | 5.3158 | -75.9928 | 2021-04-09 04:21:13 | Risaralda, Colombia | ||
3670539 | 3670539 | 2021-03-06 | US | Tennessee | Clay | 47027 | 1086 | 31 | 0 | 1040 | 36.55151008 | -85.53930419 | 2021-03-07 05:21:54 | Clay, Tennessee, US |
1619160 | 1619160 | 2021-03-05 | US | Tennessee | Clay | 47027 | 1086 | 31 | 0 | 1040 | 36.55151008 | -85.53930419 | 2021-03-06 04:23:41 | Clay, Tennessee, US |
1092686 | 1092686 | 2021-03-03 | US | Oregon | Hood River | 41027 | 1069 | 29 | 0 | 1040 | 45.51872811 | -121.65520359999998 | 2021-03-04 05:24:24 | Hood River, Oregon, US |
3256758 | 3256758 | 2021-03-02 | US | Oregon | Hood River | 41027 | 1069 | 29 | 0 | 1040 | 45.51872811 | -121.65520359999998 | 2021-03-03 05:23:28 | Hood River, Oregon, US |
1001050 | 1001050 | 2021-03-01 | US | Oregon | Hood River | 41027 | 1069 | 29 | 0 | 1040 | 45.51872811 | -121.65520359999998 | 2021-03-02 05:23:30 | Hood River, Oregon, US |
2370108 | 2370108 | 2021-02-28 | US | Oregon | Hood River | 41027 | 1069 | 29 | 0 | 1040 | 45.51872811 | -121.65520359999998 | 2021-03-01 05:23:01 | Hood River, Oregon, US |
2368825 | 2368825 | 2021-02-28 | US | Kansas | Rice | 20159 | 1052 | 12 | 0 | 1040 | 38.34616184 | -98.19992118 | 2021-03-01 05:23:01 | Rice, Kansas, US |
3069681 | 3069681 | 2021-02-27 | Malaysia | Sabah | 52753 | 373 | 51340 | 1040 | 5.9788 | 116.0753 | 2021-02-28 05:22:20 | Sabah, Malaysia | ||
3067864 | 3067864 | 2021-02-27 | US | Missouri | Bollinger | 29017 | 1052 | 12 | 0 | 1040 | 37.32449052 | -90.02725304 | 2021-02-28 05:22:20 | Bollinger, Missouri, US |
3067327 | 3067327 | 2021-02-27 | US | Kansas | Rice | 20159 | 1052 | 12 | 0 | 1040 | 38.34616184 | -98.19992118 | 2021-02-28 05:22:20 | Rice, Kansas, US |
2184911 | 2184911 | 2021-02-26 | US | Kansas | Rice | 20159 | 1052 | 12 | 0 | 1040 | 38.34616184 | -98.19992118 | 2021-02-27 05:22:28 | Rice, Kansas, US |
1861412 | 1861412 | 2021-02-25 | US | Virginia | Sussex | 51183 | 1056 | 16 | 0 | 1040 | 36.92432914 | -77.25791182 | 2021-02-26 05:22:40 | Sussex, Virginia, US |
282198 | 282198 | 2021-02-24 | US | Montana | Richland | 30083 | 1054 | 14 | 0 | 1040 | 47.78668011 | -104.5610786 | 2021-02-25 05:24:57 | Richland, Montana, US |
1938466 | 1938466 | 2021-02-23 | US | Montana | Richland | 30083 | 1054 | 14 | 0 | 1040 | 47.78668011 | -104.5610786 | 2021-02-24 05:29:16 | Richland, Montana, US |
744909 | 744909 | 2021-02-20 | US | Oklahoma | Washita | 40149 | 1048 | 8 | 0 | 1040 | 35.29071824 | -98.99180434 | 2021-02-21 05:24:33 | Washita, Oklahoma, US |
743712 | 743712 | 2021-02-20 | US | Kentucky | Green | 21087 | 1053 | 13 | 0 | 1040 | 37.26484328 | -85.5540745 | 2021-02-21 05:24:33 | Green, Kentucky, US |
473565 | 473565 | 2021-02-19 | US | New Hampshire | Unassigned | 90033 | 1045 | 5 | 0 | 1040 | 44.69063265 | 0.0 | 2021-02-20 05:22:51 | Unassigned, New Hampshire, US |
471767 | 471767 | 2021-02-19 | US | Alabama | Conecuh | 1035 | 1063 | 23 | 0 | 1040 | 31.43401703 | -86.99320044 | 2021-02-20 05:22:51 | Conecuh, Alabama, US |
1154543 | 1154543 | 2021-02-18 | US | Kentucky | Lewis | 21135 | 1070 | 30 | 0 | 1040 | 38.53184419 | -83.37735618 | 2021-02-19 05:24:16 | Lewis, Kentucky, US |
1153476 | 1153476 | 2021-02-18 | US | Alabama | Conecuh | 1035 | 1063 | 23 | 0 | 1040 | 31.43401703 | -86.99320044 | 2021-02-19 05:24:16 | Conecuh, Alabama, US |
3603795 | 3603795 | 2021-02-17 | US | Puerto Rico | Morovis | 72101 | 1040 | 0 | 0 | 1040 | 18.316963 | -66.420383 | 2021-02-18 05:22:58 | Morovis, Puerto Rico, US |
3602463 | 3602463 | 2021-02-17 | US | Kentucky | Lewis | 21135 | 1070 | 30 | 0 | 1040 | 38.53184419 | -83.37735618 | 2021-02-18 05:22:58 | Lewis, Kentucky, US |
3050080 | 3050080 | 2021-02-16 | Gabon | 12865 | 75 | 11750 | 1040 | -0.8037 | 11.6094 | 2021-02-17 05:23:10 | Gabon | |||
1338179 | 1338179 | 2021-02-15 | Gabon | 12865 | 75 | 11750 | 1040 | -0.8037 | 11.6094 | 2021-02-16 05:24:38 | Gabon | |||
3541322 | 3541322 | 2021-02-12 | US | Missouri | Bates | 29013 | 1060 | 20 | 0 | 1040 | 38.25271289 | -94.34113157 | 2021-02-13 05:22:12 | Bates, Missouri, US |
3540848 | 3540848 | 2021-02-12 | US | Kentucky | Fleming | 21069 | 1054 | 14 | 0 | 1040 | 38.36758311 | -83.69657514 | 2021-02-13 05:22:12 | Fleming, Kentucky, US |
2637576 | 2637576 | 2021-02-11 | Colombia | Norte de Santander | 49753 | 2628 | 46085 | 1040 | 7.9463 | -72.8988 | 2021-02-12 05:23:29 | Norte de Santander, Colombia | ||
3981991 | 3981991 | 2021-02-10 | US | Virginia | Westmoreland | 51193 | 1056 | 16 | 0 | 1040 | 38.11021557 | -76.80213247 | 2021-02-11 05:23:55 | Westmoreland, Virginia, US |
3980063 | 3980063 | 2021-02-10 | US | Louisiana | Caldwell | 22021 | 1065 | 25 | 0 | 1040 | 32.0902519 | -92.11752148 | 2021-02-11 05:23:55 | Caldwell, Louisiana, US |
3979763 | 3979763 | 2021-02-10 | US | Iowa | Guthrie | 19077 | 1067 | 27 | 0 | 1040 | 41.68378965 | -94.50111014 | 2021-02-11 05:23:55 | Guthrie, Iowa, US |
975125 | 975125 | 2021-02-06 | Russia | Kemerovo Oblast | 29932 | 534 | 28358 | 1040 | 54.53357809999999 | 87.342861 | 2021-02-07 05:23:00 | Kemerovo Oblast, Russia | ||
342051 | 342051 | 2021-02-03 | US | Mississippi | Amite | 28005 | 1070 | 30 | 0 | 1040 | 31.17467303 | -90.80501621 | 2021-02-04 05:22:26 | Amite, Mississippi, US |
1687879 | 1687879 | 2021-02-02 | US | Virginia | Patrick | 51141 | 1069 | 29 | 0 | 1040 | 36.6801638 | -80.2865648 | 2021-02-03 05:22:52 | Patrick, Virginia, US |
1686986 | 1686986 | 2021-02-02 | US | Ohio | Monroe | 39111 | 1080 | 40 | 0 | 1040 | 39.72984936 | -81.08464734 | 2021-02-03 05:22:52 | Monroe, Ohio, US |
1679224 | 1679224 | 2021-02-01 | US | Puerto Rico | Moca | 72099 | 1040 | 0 | 0 | 1040 | 18.377805 | -67.080952 | 2021-02-02 05:22:49 | Moca, Puerto Rico, US |
2214938 | 2214938 | 2021-01-30 | US | Vermont | Bennington | 50003 | 1044 | 4 | 0 | 1040 | 43.03519828 | -73.09048868 | 2021-01-31 05:22:42 | Bennington, Vermont, US |
3156331 | 3156331 | 2021-01-27 | US | Puerto Rico | Corozal | 72047 | 1040 | 0 | 0 | 1040 | 18.304264 | -66.327738 | 2021-01-28 05:22:24 | Corozal, Puerto Rico, US |
15066 | 15066 | 2021-01-26 | US | Puerto Rico | Corozal | 72047 | 1040 | 0 | 0 | 1040 | 18.304264 | -66.327738 | 2021-01-27 05:23:41 | Corozal, Puerto Rico, US |
14743 | 14743 | 2021-01-26 | US | North Dakota | Mercer | 38057 | 1040 | 9 | 0 | 1040 | 47.31213126 | -101.8318399 | 2021-01-27 05:23:41 | Mercer, North Dakota, US |
1761500 | 1761500 | 2021-01-24 | US | New Mexico | Socorro | 35053 | 1086 | 46 | 0 | 1040 | 34.00715494 | -106.9298354 | 2021-01-25 05:22:16 | Socorro, New Mexico, US |
2469027 | 2469027 | 2021-01-22 | US | New York | Delaware | 36025 | 1067 | 27 | 0 | 1040 | 42.19837623 | -74.96709306 | 2021-01-23 05:22:03 | Delaware, New York, US |
437838 | 437838 | 2021-01-21 | US | Ohio | Meigs | 39105 | 1068 | 28 | 0 | 1040 | 39.09224872 | -82.0305041 | 2021-01-22 05:22:10 | Meigs, Ohio, US |
1097606 | 1097606 | 2021-01-20 | US | Wisconsin | Bayfield | 55007 | 1058 | 18 | 0 | 1040 | 46.52868768 | -91.19716729 | 2021-01-21 05:22:01 | Bayfield, Wisconsin, US |
1097369 | 1097369 | 2021-01-20 | US | Vermont | Washington | 50023 | 1051 | 11 | 0 | 1040 | 44.27343241 | -72.61604978 | 2021-01-21 05:22:01 | Washington, Vermont, US |
1096381 | 1096381 | 2021-01-20 | US | North Carolina | Chowan | 37041 | 1060 | 20 | 0 | 1040 | 36.12908077 | -76.60118385 | 2021-01-21 05:22:01 | Chowan, North Carolina, US |
911658 | 911658 | 2021-01-19 | US | West Virginia | Lincoln | 54043 | 1049 | 9 | 0 | 1040 | 38.172154 | -82.07017953 | 2021-01-20 05:21:54 | Lincoln, West Virginia, US |
3104071 | 3104071 | 2021-01-16 | US | Oregon | Wasco | 41065 | 1063 | 23 | 0 | 1040 | 45.16292781 | -121.1670954 | 2021-01-17 05:22:17 | Wasco, Oregon, US |
3518293 | 3518293 | 2021-01-15 | US | South Dakota | Roberts | 46109 | 1072 | 32 | 0 | 1040 | 45.62975048 | -96.94672673 | 2021-01-16 05:22:40 | Roberts, South Dakota, US |
3882465 | 3882465 | 2021-01-14 | US | South Dakota | Roberts | 46109 | 1072 | 32 | 0 | 1040 | 45.62975048 | -96.94672673 | 2021-01-15 05:22:24 | Roberts, South Dakota, US |
3311401 | 3311401 | 2021-01-13 | US | Texas | Runnels | 48399 | 1061 | 23 | 0 | 1040 | 31.8314342 | -99.97616148 | 2021-01-14 05:22:32 | Runnels, Texas, US |
3308952 | 3308952 | 2021-01-13 | US | Georgia | Brooks | 13027 | 1073 | 33 | 0 | 1040 | 30.83922642 | -83.58303423 | 2021-01-14 05:22:32 | Brooks, Georgia, US |
3308582 | 3308582 | 2021-01-13 | US | Alabama | Lowndes | 1085 | 1076 | 36 | 0 | 1040 | 32.1597283 | -86.65158371 | 2021-01-14 05:22:32 | Lowndes, Alabama, US |
774986 | 774986 | 2021-01-12 | US | Colorado | Prowers | 8099 | 1083 | 21 | 0 | 1040 | 37.95544985 | -102.3926052 | 2021-01-13 05:22:15 | Prowers, Colorado, US |
191018 | 191018 | 2021-01-11 | US | Idaho | Washington | 16087 | 1056 | 16 | 0 | 1040 | 44.45275475 | -116.7847688 | 2021-01-12 05:22:15 | Washington, Idaho, US |
2629169 | 2629169 | 2021-01-10 | US | Virginia | Bristol | 51520 | 1048 | 8 | 0 | 1040 | 36.6163024 | -82.16359122 | 2021-01-11 05:21:50 | Bristol, Virginia, US |
2543157 | 2543157 | 2021-01-07 | US | Minnesota | Rock | 27133 | 1050 | 10 | 0 | 1040 | 43.67482683 | -96.25296832 | 2021-01-08 05:22:42 | Rock, Minnesota, US |
2866630 | 2866630 | 2021-01-06 | US | Missouri | Livingston | 29117 | 1064 | 24 | 0 | 1040 | 39.78110272 | -93.54645978 | 2021-01-07 05:22:03 | Livingston, Missouri, US |
1063075 | 1063075 | 2021-01-04 | US | Iowa | Sac | 19161 | 1054 | 14 | 0 | 1040 | 42.38624071 | -95.10547892 | 2021-01-05 05:21:49 | Sac, Iowa, US |
3230234 | 3230234 | 2021-01-03 | Chile | Araucania | 23556 | 316 | 22200 | 1040 | -38.9489 | -72.3311 | 2021-01-04 05:22:02 | Araucania, Chile | ||
1137526 | 1137526 | 2021-01-01 | US | Colorado | Routt | 8107 | 1111 | 19 | 0 | 1040 | 40.48596505 | -106.9905548 | 2021-01-02 05:22:33 | Routt, Colorado, US |
3779902 | 3779902 | 2020-12-27 | US | Montana | Lincoln | 30053 | 1049 | 9 | 0 | 1040 | 48.54265777 | -115.4046155 | 2020-12-28 05:22:06 | Lincoln, Montana, US |
204822 | 204822 | 2020-12-25 | US | Oklahoma | Murray | 40099 | 1047 | 7 | 0 | 1040 | 34.48116015 | -97.06826283 | 2020-12-26 05:22:28 | Murray, Oklahoma, US |
203962 | 203962 | 2020-12-25 | US | Minnesota | Fillmore | 27045 | 1040 | 0 | 0 | 1040 | 43.67394126 | -92.08980382 | 2020-12-26 05:22:28 | Fillmore, Minnesota, US |
3694045 | 3694045 | 2020-12-24 | US | Oklahoma | Murray | 40099 | 1047 | 7 | 0 | 1040 | 34.48116015 | -97.06826283 | 2020-12-25 05:22:48 | Murray, Oklahoma, US |
3693185 | 3693185 | 2020-12-24 | US | Minnesota | Fillmore | 27045 | 1040 | 0 | 0 | 1040 | 43.67394126 | -92.08980382 | 2020-12-25 05:22:48 | Fillmore, Minnesota, US |
3772849 | 3772849 | 2020-12-22 | US | Tennessee | Polk | 47139 | 1038 | 15 | 0 | 1040 | 35.12245443 | -84.52075859 | 2020-12-23 05:22:03 | Polk, Tennessee, US |
930511 | 930511 | 2020-12-21 | US | South Carolina | Lee | 45061 | 1081 | 41 | 0 | 1040 | 34.16393091 | -80.25690731 | 2020-12-22 05:22:33 | Lee, South Carolina, US |
2121314 | 2121314 | 2020-12-20 | US | Michigan | Alpena | 26007 | 1063 | 23 | 0 | 1040 | 45.03477666 | -83.62212411 | 2020-12-21 05:27:58 | Alpena, Michigan, US |
2932821 | 2932821 | 2020-12-19 | US | Michigan | Alpena | 26007 | 1063 | 23 | 0 | 1040 | 45.03477666 | -83.62212411 | 2020-12-20 05:27:32 | Alpena, Michigan, US |
3150073 | 3150073 | 2020-12-16 | US | Arkansas | Hempstead | 5057 | 1049 | 9 | 0 | 1040 | 33.73325583 | -93.66935133 | 2020-12-17 05:28:12 | Hempstead, Arkansas, US |
1036893 | 1036893 | 2020-12-15 | US | Oklahoma | Atoka | 40005 | 1042 | 2 | 0 | 1040 | 34.37366573 | -96.03802487 | 2020-12-16 05:28:04 | Atoka, Oklahoma, US |
1752170 | 1752170 | 2020-12-14 | US | Hawaii | Maui | 15009 | 1057 | 17 | 0 | 1040 | 20.86399628 | -156.56890969999995 | 2020-12-15 05:26:38 | Maui, Hawaii, US |
3851460 | 3851460 | 2020-12-13 | Malaysia | Johor | 2573 | 30 | 1503 | 1040 | 1.4854 | 103.7618 | 2020-12-14 05:26:27 | Johor, Malaysia | ||
863920 | 863920 | 2020-12-11 | US | Texas | Wilbarger | 48487 | 1212 | 21 | 0 | 1040 | 34.07945812 | -99.24178437 | 2020-12-12 05:26:19 | Wilbarger, Texas, US |
861639 | 861639 | 2020-12-11 | US | Illinois | Clay | 17025 | 1065 | 25 | 0 | 1040 | 38.75388572 | -88.48914513 | 2020-12-12 05:26:19 | Clay, Illinois, US |
1603582 | 1603582 | 2020-12-10 | US | Virginia | Mecklenburg | 51117 | 1077 | 37 | 0 | 1040 | 36.67882005 | -78.36131056 | 2020-12-11 05:26:59 | Mecklenburg, Virginia, US |
1601714 | 1601714 | 2020-12-10 | US | Louisiana | Grant | 22043 | 1072 | 32 | 0 | 1040 | 31.59882456 | -92.56124347 | 2020-12-11 05:26:59 | Grant, Louisiana, US |
1601051 | 1601051 | 2020-12-10 | US | Georgia | McDuffie | 13189 | 1063 | 23 | 0 | 1040 | 33.47851918 | -82.48252774 | 2020-12-11 05:26:59 | McDuffie, Georgia, US |
1601035 | 1601035 | 2020-12-10 | US | Georgia | Jefferson | 13163 | 1080 | 40 | 0 | 1040 | 33.05867328 | -82.41609057 | 2020-12-11 05:26:59 | Jefferson, Georgia, US |
2977165 | 2977165 | 2020-12-09 | US | Missouri | Pike | 29163 | 1051 | 11 | 0 | 1040 | 39.34310674 | -91.16980779 | 2020-12-10 05:26:19 | Pike, Missouri, US |
1821188 | 1821188 | 2020-12-08 | US | North Dakota | McLean | 38055 | 1073 | 17 | 0 | 1040 | 47.60766714 | -101.3182418 | 2020-12-09 05:28:01 | McLean, North Dakota, US |
2349824 | 2349824 | 2020-12-07 | US | North Dakota | McLean | 38055 | 1066 | 17 | 0 | 1040 | 47.60766714 | -101.3182418 | 2020-12-08 05:27:42 | McLean, North Dakota, US |
78215 | 78215 | 2020-12-03 | US | Texas | Karnes | 48255 | 1026 | 18 | 0 | 1040 | 28.90705334 | -97.85960149 | 2020-12-04 05:27:27 | Karnes, Texas, US |
741559 | 741559 | 2020-12-02 | US | Utah | San Juan | 49037 | 1071 | 31 | 0 | 1040 | 37.62762978 | -109.80337140000002 | 2020-12-03 05:28:22 | San Juan, Utah, US |
2538553 | 2538553 | 2020-12-01 | US | Iowa | Butler | 19023 | 1046 | 6 | 0 | 1040 | 42.73172833 | -92.79015971 | 2020-12-02 05:27:41 | Butler, Iowa, US |
1586280 | 1586280 | 2020-11-30 | US | Nebraska | Unassigned | 90031 | 1043 | 3 | 0 | 1040 | 42.8997274 | 0.0 | 2020-12-01 05:26:18 | Unassigned, Nebraska, US |
1585116 | 1585116 | 2020-11-30 | US | Illinois | Bond | 17005 | 1050 | 10 | 0 | 1040 | 38.88829622 | -89.43534887 | 2020-12-01 05:26:18 | Bond, Illinois, US |
3569973 | 3569973 | 2020-11-29 | US | Virginia | Tazewell | 51185 | 1047 | 7 | 0 | 1040 | 37.12191123 | -81.56685568 | 2020-11-30 05:26:13 | Tazewell, Virginia, US |
3569029 | 3569029 | 2020-11-29 | US | Ohio | Henry | 39069 | 1076 | 36 | 0 | 1040 | 41.3339642 | -84.06830637 | 2020-11-30 05:26:13 | Henry, Ohio, US |
2938638 | 2938638 | 2020-11-28 | US | Virginia | Tazewell | 51185 | 1047 | 7 | 0 | 1040 | 37.12191123 | -81.56685568 | 2020-11-29 05:25:55 | Tazewell, Virginia, US |
2936738 | 2936738 | 2020-11-28 | US | Louisiana | Madison | 22065 | 1053 | 13 | 0 | 1040 | 32.36918118 | -91.23973355 | 2020-11-29 05:25:55 | Madison, Louisiana, US |
2935921 | 2935921 | 2020-11-28 | US | Florida | Gulf | 12045 | 1059 | 19 | 0 | 1040 | 29.93543004 | -85.24270990000002 | 2020-11-29 05:25:55 | Gulf, Florida, 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]);