johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
193 rows where active = 1068 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2295378 | 2295378 | 2021-06-24 | Guinea | 23615 | 168 | 22379 | 1068 | 9.9456 | -9.6966 | 2021-06-25 04:21:33 | Guinea | |||
2887987 | 2887987 | 2021-06-20 | Ukraine | Cherkasy Oblast | 81555 | 1299 | 79188 | 1068 | 49.4444 | 32.0598 | 2021-06-21 04:21:41 | Cherkasy Oblast, Ukraine | ||
1563873 | 1563873 | 2021-06-14 | Chile | Antofagasta | 55534 | 1080 | 53386 | 1068 | -23.6509 | -70.3975 | 2021-06-15 04:22:22 | Antofagasta, Chile | ||
1736651 | 1736651 | 2021-06-12 | Pakistan | Balochistan | 26201 | 294 | 24839 | 1068 | 28.328492 | 65.898403 | 2021-06-13 04:22:44 | Balochistan, Pakistan | ||
1408827 | 1408827 | 2021-04-23 | Chile | Atacama | 17208 | 195 | 15945 | 1068 | -27.5661 | -70.0503 | 2021-04-24 04:20:38 | Atacama, Chile | ||
2575352 | 2575352 | 2021-04-13 | Malaysia | Johor | 42445 | 109 | 41268 | 1068 | 1.4854 | 103.7618 | 2021-04-14 04:20:41 | Johor, Malaysia | ||
1838194 | 1838194 | 2021-03-12 | Russia | Zabaykalsky Krai | 39759 | 562 | 38129 | 1068 | 52.248521 | 115.956325 | 2021-03-13 05:25:15 | Zabaykalsky Krai, Russia | ||
3669340 | 3669340 | 2021-03-06 | US | Minnesota | Kanabec | 27065 | 1088 | 20 | 0 | 1068 | 45.9459309 | -93.29275192 | 2021-03-07 05:21:54 | Kanabec, Minnesota, US |
3668808 | 3668808 | 2021-03-06 | US | Iowa | Guthrie | 19077 | 1096 | 28 | 0 | 1068 | 41.68378965 | -94.50111014 | 2021-03-07 05:21:54 | Guthrie, Iowa, US |
1617429 | 1617429 | 2021-03-05 | US | Iowa | Guthrie | 19077 | 1096 | 28 | 0 | 1068 | 41.68378965 | -94.50111014 | 2021-03-06 04:23:41 | Guthrie, Iowa, US |
1091497 | 1091497 | 2021-03-03 | US | Kentucky | Lewis | 21135 | 1099 | 31 | 0 | 1068 | 38.53184419 | -83.37735618 | 2021-03-04 05:24:24 | Lewis, Kentucky, US |
3256739 | 3256739 | 2021-03-02 | US | Oklahoma | Unassigned | 90040 | 1068 | 0 | 0 | 1068 | 36.83532655 | 0.0 | 2021-03-03 05:23:28 | Unassigned, Oklahoma, US |
3255569 | 3255569 | 2021-03-02 | US | Kentucky | Lewis | 21135 | 1099 | 31 | 0 | 1068 | 38.53184419 | -83.37735618 | 2021-03-03 05:23:28 | Lewis, Kentucky, US |
1001951 | 1001951 | 2021-03-01 | US | West Virginia | Wetzel | 54103 | 1087 | 19 | 0 | 1068 | 39.6065771 | -80.64016540000001 | 2021-03-02 05:23:30 | Wetzel, West Virginia, US |
283538 | 283538 | 2021-02-24 | US | Virginia | Lexington | 51678 | 1087 | 19 | 0 | 1068 | 37.78258621 | -79.44262866 | 2021-02-25 05:24:57 | Lexington, Virginia, US |
1937633 | 1937633 | 2021-02-23 | US | Iowa | Franklin | 19069 | 1087 | 19 | 0 | 1068 | 42.73270384 | -93.26256925 | 2021-02-24 05:29:16 | Franklin, Iowa, US |
1154661 | 1154661 | 2021-02-18 | US | Louisiana | West Feliciana | 22125 | 1099 | 31 | 0 | 1068 | 30.87882871 | -91.4148538 | 2021-02-19 05:24:16 | West Feliciana, Louisiana, US |
3600894 | 3600894 | 2021-02-17 | Colombia | Narino | 48136 | 1545 | 45523 | 1068 | 1.2892 | -77.3579 | 2021-02-18 05:22:58 | Narino, Colombia | ||
2680311 | 2680311 | 2021-02-13 | US | Ohio | Monroe | 39111 | 1108 | 40 | 0 | 1068 | 39.72984936 | -81.08464734 | 2021-02-14 05:23:43 | Monroe, Ohio, US |
2640423 | 2640423 | 2021-02-11 | US | Pennsylvania | Wyoming | 42131 | 1107 | 39 | 0 | 1068 | 41.51955538 | -76.01074915 | 2021-02-12 05:23:29 | Wyoming, Pennsylvania, US |
1673950 | 1673950 | 2021-02-07 | US | Louisiana | East Carroll | 22035 | 1090 | 22 | 0 | 1068 | 32.73926954 | -91.23425694 | 2021-02-08 05:22:39 | East Carroll, Louisiana, US |
1591669 | 1591669 | 2021-02-05 | US | West Virginia | Nicholas | 54067 | 1080 | 12 | 0 | 1068 | 38.29617706 | -80.79759588 | 2021-02-06 05:23:55 | Nicholas, West Virginia, US |
793745 | 793745 | 2021-02-04 | US | Virginia | Manassas Park | 51685 | 1076 | 8 | 0 | 1068 | 38.77058531 | -77.44399307 | 2021-02-05 05:22:38 | Manassas Park, Virginia, US |
793415 | 793415 | 2021-02-04 | US | Texas | Camp | 48063 | 1121 | 36 | 0 | 1068 | 32.97195142 | -94.97790104 | 2021-02-05 05:22:38 | Camp, Texas, US |
793001 | 793001 | 2021-02-04 | US | Oregon | Lincoln | 41041 | 1086 | 18 | 0 | 1068 | 44.64252874 | -123.869912 | 2021-02-05 05:22:38 | Lincoln, Oregon, US |
1678140 | 1678140 | 2021-02-01 | US | Michigan | Otsego | 26137 | 1093 | 25 | 0 | 1068 | 45.02085831 | -84.59898295 | 2021-02-02 05:22:49 | Otsego, Michigan, US |
1678026 | 1678026 | 2021-02-01 | US | Maine | Somerset | 23025 | 1093 | 25 | 0 | 1068 | 45.51229767 | -69.95995554 | 2021-02-02 05:22:49 | Somerset, Maine, US |
1677889 | 1677889 | 2021-02-01 | US | Kentucky | Lawrence | 21127 | 1079 | 11 | 0 | 1068 | 38.07136018 | -82.72882223 | 2021-02-02 05:22:49 | Lawrence, Kentucky, US |
2214809 | 2214809 | 2021-01-30 | US | Texas | Lampasas | 48281 | 1440 | 20 | 0 | 1068 | 31.19531316 | -98.24206613 | 2021-01-31 05:22:42 | Lampasas, Texas, US |
1900673 | 1900673 | 2021-01-29 | US | Wisconsin | Bayfield | 55007 | 1086 | 18 | 0 | 1068 | 46.52868768 | -91.19716729 | 2021-01-30 05:22:49 | Bayfield, Wisconsin, US |
1897006 | 1897006 | 2021-01-29 | Colombia | Meta | 40329 | 876 | 38385 | 1068 | 3.272 | -73.0877 | 2021-01-30 05:22:49 | Meta, Colombia | ||
2485489 | 2485489 | 2021-01-28 | US | Wisconsin | Bayfield | 55007 | 1086 | 18 | 0 | 1068 | 46.52868768 | -91.19716729 | 2021-01-29 05:22:23 | Bayfield, Wisconsin, US |
3156496 | 3156496 | 2021-01-27 | US | South Dakota | Roberts | 46109 | 1102 | 34 | 0 | 1068 | 45.62975048 | -96.94672673 | 2021-01-28 05:22:24 | Roberts, South Dakota, US |
1760835 | 1760835 | 2021-01-24 | US | Louisiana | West Carroll | 22123 | 1104 | 36 | 0 | 1068 | 32.78550125 | -91.461201 | 2021-01-25 05:22:16 | West Carroll, Louisiana, US |
1096718 | 1096718 | 2021-01-20 | US | Oregon | Wasco | 41065 | 1091 | 23 | 0 | 1068 | 45.16292781 | -121.1670954 | 2021-01-21 05:22:01 | Wasco, Oregon, US |
1094726 | 1094726 | 2021-01-20 | US | Colorado | Prowers | 8099 | 1112 | 21 | 0 | 1068 | 37.95544985 | -102.3926052 | 2021-01-21 05:22:01 | Prowers, Colorado, US |
910280 | 910280 | 2021-01-19 | US | Nebraska | Red Willow | 31145 | 1077 | 9 | 0 | 1068 | 40.17556879999999 | -100.476998 | 2021-01-20 05:21:54 | Red Willow, Nebraska, US |
239343 | 239343 | 2021-01-18 | US | Nebraska | Red Willow | 31145 | 1077 | 9 | 0 | 1068 | 40.17556879999999 | -100.476998 | 2021-01-19 05:22:15 | Red Willow, Nebraska, US |
3505460 | 3505460 | 2021-01-17 | US | Nebraska | Red Willow | 31145 | 1077 | 9 | 0 | 1068 | 40.17556879999999 | -100.476998 | 2021-01-18 05:22:34 | Red Willow, Nebraska, US |
3505151 | 3505151 | 2021-01-17 | US | Mississippi | Greene | 28041 | 1097 | 29 | 0 | 1068 | 31.21444233 | -88.63922281 | 2021-01-18 05:22:34 | Greene, Mississippi, US |
3503737 | 3503737 | 2021-01-17 | US | Alabama | Lowndes | 1085 | 1103 | 35 | 0 | 1068 | 32.1597283 | -86.65158371 | 2021-01-18 05:22:34 | Lowndes, Alabama, US |
3518428 | 3518428 | 2021-01-15 | US | Texas | Burleson | 48051 | 1514 | 21 | 0 | 1068 | 30.49273808 | -96.62158484 | 2021-01-16 05:22:40 | Burleson, Texas, US |
3516783 | 3516783 | 2021-01-15 | US | Kentucky | Clinton | 21053 | 1087 | 19 | 0 | 1068 | 36.72581156 | -85.13377529 | 2021-01-16 05:22:40 | Clinton, Kentucky, US |
3516581 | 3516581 | 2021-01-15 | US | Iowa | Emmet | 19063 | 1099 | 31 | 0 | 1068 | 43.37782951 | -94.67858943 | 2021-01-16 05:22:40 | Emmet, Iowa, US |
3516011 | 3516011 | 2021-01-15 | US | Colorado | Elbert | 8039 | 1168 | 12 | 0 | 1068 | 39.28656773 | -104.1358721 | 2021-01-16 05:22:40 | Elbert, Colorado, US |
3881330 | 3881330 | 2021-01-14 | US | Minnesota | Sibley | 27143 | 1075 | 7 | 0 | 1068 | 44.5796592 | -94.23164924 | 2021-01-15 05:22:24 | Sibley, Minnesota, US |
3880754 | 3880754 | 2021-01-14 | US | Iowa | Emmet | 19063 | 1099 | 31 | 0 | 1068 | 43.37782951 | -94.67858943 | 2021-01-15 05:22:24 | Emmet, Iowa, US |
3880184 | 3880184 | 2021-01-14 | US | Colorado | Elbert | 8039 | 1163 | 12 | 0 | 1068 | 39.28656773 | -104.1358721 | 2021-01-15 05:22:24 | Elbert, Colorado, US |
775316 | 775316 | 2021-01-12 | US | Illinois | De Witt | 17039 | 1086 | 18 | 0 | 1068 | 40.17514519 | -88.90959682 | 2021-01-13 05:22:15 | De Witt, Illinois, US |
191296 | 191296 | 2021-01-11 | US | Iowa | Sac | 19161 | 1082 | 14 | 0 | 1068 | 42.38624071 | -95.10547892 | 2021-01-12 05:22:15 | Sac, Iowa, US |
2628700 | 2628700 | 2021-01-10 | US | South Carolina | Saluda | 45081 | 1097 | 29 | 0 | 1068 | 34.00795823 | -81.72713237 | 2021-01-11 05:21:50 | Saluda, South Carolina, US |
2627725 | 2627725 | 2021-01-10 | US | Mississippi | Yalobusha | 28161 | 1102 | 34 | 0 | 1068 | 34.02824175 | -89.70762049999998 | 2021-01-11 05:21:50 | Yalobusha, Mississippi, US |
155666 | 155666 | 2021-01-08 | US | Michigan | Wexford | 26165 | 1088 | 20 | 0 | 1068 | 44.33853602 | -85.57712739 | 2021-01-09 05:22:18 | Wexford, Michigan, US |
155190 | 155190 | 2021-01-08 | US | Iowa | Madison | 19121 | 1077 | 9 | 0 | 1068 | 41.33081904 | -94.01554631 | 2021-01-09 05:22:18 | Madison, Iowa, US |
2544590 | 2544590 | 2021-01-07 | US | Texas | Parmer | 48369 | 1281 | 32 | 0 | 1068 | 34.52993409 | -102.7844668 | 2021-01-08 05:22:42 | Parmer, Texas, US |
2543321 | 2543321 | 2021-01-07 | US | Missouri | Livingston | 29117 | 1092 | 24 | 0 | 1068 | 39.78110272 | -93.54645978 | 2021-01-08 05:22:42 | Livingston, Missouri, US |
3034798 | 3034798 | 2021-01-05 | US | Arkansas | Madison | 5087 | 1081 | 13 | 0 | 1068 | 36.01038185 | -93.72524943 | 2021-01-06 05:22:16 | Madison, Arkansas, US |
3034677 | 3034677 | 2021-01-05 | US | Alabama | Lamar | 1075 | 1083 | 15 | 0 | 1068 | 33.77995024 | -88.09668032 | 2021-01-06 05:22:16 | Lamar, Alabama, US |
3034214 | 3034214 | 2021-01-05 | Germany | Bremen | 13803 | 208 | 12652 | 1068 | 53.0793 | 8.8017 | 2021-01-06 05:22:16 | Bremen, Germany | ||
1012303 | 1012303 | 2020-12-30 | US | Montana | Lincoln | 30053 | 1077 | 9 | 0 | 1068 | 48.54265777 | -115.4046155 | 2020-12-31 05:22:49 | Lincoln, Montana, US |
766838 | 766838 | 2020-12-29 | US | Arkansas | Sharp | 5135 | 1100 | 32 | 0 | 1068 | 36.16258158 | -91.47819342 | 2020-12-30 05:22:34 | Sharp, Arkansas, US |
3764736 | 3764736 | 2020-12-28 | US | Texas | Madison | 48313 | 1267 | 16 | 0 | 1068 | 30.96694679 | -95.93003775 | 2020-12-29 05:22:37 | Madison, Texas, US |
3781056 | 3781056 | 2020-12-27 | US | Texas | Madison | 48313 | 1260 | 16 | 0 | 1068 | 30.96694679 | -95.93003775 | 2020-12-28 05:22:06 | Madison, Texas, US |
3780470 | 3780470 | 2020-12-27 | US | Oklahoma | Murray | 40099 | 1076 | 8 | 0 | 1068 | 34.48116015 | -97.06826283 | 2020-12-28 05:22:06 | Murray, Oklahoma, US |
3779610 | 3779610 | 2020-12-27 | US | Minnesota | Fillmore | 27045 | 1068 | 0 | 0 | 1068 | 43.67394126 | -92.08980382 | 2020-12-28 05:22:06 | Fillmore, Minnesota, US |
2409902 | 2409902 | 2020-12-23 | US | Texas | Falls | 48145 | 1190 | 16 | 0 | 1068 | 31.25350609 | -96.93630086 | 2020-12-24 05:23:04 | Falls, Texas, US |
3772829 | 3772829 | 2020-12-22 | US | Tennessee | Lewis | 47101 | 1108 | 19 | 0 | 1068 | 35.52853208 | -87.49022694 | 2020-12-23 05:22:03 | Lewis, Tennessee, US |
927946 | 927946 | 2020-12-21 | Russia | Tyva Republic | 14213 | 157 | 12988 | 1068 | 51.4017149 | 93.8582593 | 2020-12-22 05:22:33 | Tyva Republic, Russia | ||
2121990 | 2121990 | 2020-12-20 | US | North Carolina | Ashe | 37009 | 1085 | 17 | 0 | 1068 | 36.43296207 | -81.49862729 | 2020-12-21 05:27:58 | Ashe, North Carolina, US |
2119726 | 2119726 | 2020-12-20 | Japan | Hyogo | 8201 | 133 | 7000 | 1068 | 35.039913 | 134.828057 | 2020-12-21 05:27:58 | Hyogo, Japan | ||
2932036 | 2932036 | 2020-12-19 | US | Georgia | Jeff Davis | 13161 | 1102 | 34 | 0 | 1068 | 31.80405727 | -82.63724870000001 | 2020-12-20 05:27:32 | Jeff Davis, Georgia, US |
2129106 | 2129106 | 2020-12-17 | US | Indiana | Owen | 18119 | 1089 | 21 | 0 | 1068 | 39.31145587 | -86.83900724 | 2020-12-18 05:28:18 | Owen, Indiana, US |
2128895 | 2128895 | 2020-12-17 | US | Hawaii | Maui | 15009 | 1085 | 17 | 0 | 1068 | 20.86399628 | -156.56890969999995 | 2020-12-18 05:28:18 | Maui, Hawaii, US |
3150967 | 3150967 | 2020-12-16 | US | Kentucky | Carter | 21043 | 1073 | 5 | 0 | 1068 | 38.31690743 | -83.05092385 | 2020-12-17 05:28:12 | Carter, Kentucky, US |
1034879 | 1034879 | 2020-12-15 | US | Arkansas | Phillips | 5107 | 1085 | 17 | 0 | 1068 | 34.43268455 | -90.84800154 | 2020-12-16 05:28:04 | Phillips, Arkansas, US |
1754349 | 1754349 | 2020-12-14 | US | Texas | Gaines | 48165 | 390 | 23 | 0 | 1068 | 32.74055318 | -102.6353295 | 2020-12-15 05:26:38 | Gaines, Texas, US |
1751466 | 1751466 | 2020-12-14 | Russia | Jewish Autonomous Okrug | 3346 | 55 | 2223 | 1068 | 48.57527615 | 132.66307460000002 | 2020-12-15 05:26:38 | Jewish Autonomous Okrug, Russia | ||
3850869 | 3850869 | 2020-12-13 | US | Texas | Gaines | 48165 | 387 | 23 | 0 | 1068 | 32.74055318 | -102.6353295 | 2020-12-14 05:26:27 | Gaines, Texas, US |
848651 | 848651 | 2020-12-12 | US | Texas | Gaines | 48165 | 387 | 23 | 0 | 1068 | 32.74055318 | -102.6353295 | 2020-12-13 05:27:20 | Gaines, Texas, US |
863713 | 863713 | 2020-12-11 | US | Texas | Childress | 48075 | 1131 | 3 | 0 | 1068 | 34.529304100000004 | -100.2077916 | 2020-12-12 05:26:19 | Childress, Texas, US |
1602619 | 1602619 | 2020-12-10 | US | North Dakota | McLean | 38055 | 1091 | 18 | 0 | 1068 | 47.60766714 | -101.3182418 | 2020-12-11 05:26:59 | McLean, North Dakota, US |
2348991 | 2348991 | 2020-12-07 | US | Maryland | Dorchester | 24019 | 1085 | 17 | 0 | 1068 | 38.45413522 | -76.02752426 | 2020-12-08 05:27:42 | Dorchester, Maryland, US |
2348261 | 2348261 | 2020-12-07 | US | Georgia | Monroe | 13207 | 1130 | 62 | 0 | 1068 | 33.014289 | -83.92097166 | 2020-12-08 05:27:42 | Monroe, Georgia, US |
2347817 | 2347817 | 2020-12-07 | US | Alabama | Randolph | 1111 | 1090 | 22 | 0 | 1068 | 33.29526734 | -85.45708831 | 2020-12-08 05:27:42 | Randolph, Alabama, US |
1007861 | 1007861 | 2020-12-06 | US | Maryland | Dorchester | 24019 | 1085 | 17 | 0 | 1068 | 38.45413522 | -76.02752426 | 2020-12-07 05:26:14 | Dorchester, Maryland, US |
75778 | 75778 | 2020-12-03 | US | Florida | Gulf | 12045 | 1088 | 20 | 0 | 1068 | 29.93543004 | -85.24270990000002 | 2020-12-04 05:27:27 | Gulf, Florida, US |
741231 | 741231 | 2020-12-02 | US | Tennessee | Grainger | 47057 | 1084 | 17 | 0 | 1068 | 36.27469206 | -83.51254721 | 2020-12-03 05:28:22 | Grainger, Tennessee, US |
2538276 | 2538276 | 2020-12-01 | US | Georgia | Union | 13291 | 1104 | 36 | 0 | 1068 | 34.82995757 | -83.98967069 | 2020-12-02 05:27:41 | Union, Georgia, US |
1585323 | 1585323 | 2020-11-30 | US | Iowa | Calhoun | 19025 | 1075 | 7 | 0 | 1068 | 42.38521079 | -94.64046046 | 2020-12-01 05:26:18 | Calhoun, Iowa, US |
1585245 | 1585245 | 2020-11-30 | US | Indiana | Greene | 18055 | 1122 | 54 | 0 | 1068 | 39.03630547 | -86.96223202 | 2020-12-01 05:26:18 | Greene, Indiana, US |
1585156 | 1585156 | 2020-11-30 | US | Illinois | Jo Daviess | 17085 | 1083 | 15 | 0 | 1068 | 42.36542373 | -90.21094405 | 2020-12-01 05:26:18 | Jo Daviess, Illinois, US |
393267 | 393267 | 2020-11-27 | US | Illinois | Saline | 17165 | 1090 | 22 | 0 | 1068 | 37.75332999 | -88.54119706 | 2020-11-28 05:25:50 | Saline, Illinois, US |
1975101 | 1975101 | 2020-11-25 | US | Ohio | Williams | 39171 | 1079 | 11 | 0 | 1068 | 41.56052014 | -84.58429552 | 2020-11-26 05:27:44 | Williams, Ohio, US |
1974705 | 1974705 | 2020-11-25 | US | Nebraska | Washington | 31177 | 1078 | 10 | 0 | 1068 | 41.52815707 | -96.22019892 | 2020-11-26 05:27:44 | Washington, Nebraska, US |
1973553 | 1973553 | 2020-11-25 | US | Illinois | Crawford | 17033 | 1077 | 9 | 0 | 1068 | 39.0032229 | -87.75954624 | 2020-11-26 05:27:44 | Crawford, Illinois, US |
678801 | 678801 | 2020-11-23 | US | Arkansas | Lawrence | 5075 | 1096 | 28 | 0 | 1068 | 36.04188196 | -91.10867198 | 2020-11-24 05:27:31 | Lawrence, Arkansas, US |
2704857 | 2704857 | 2020-11-20 | US | Virginia | James City | 51095 | 1090 | 22 | 0 | 1068 | 37.31156958 | -76.76950618 | 2020-11-21 05:25:51 | James City, Virginia, US |
3339951 | 3339951 | 2020-11-17 | US | Kentucky | Bell | 21013 | 1086 | 18 | 0 | 1068 | 36.73355174 | -83.67766671 | 2020-11-18 05:40:31 | Bell, Kentucky, US |
2786854 | 2786854 | 2020-11-13 | US | Mississippi | Wayne | 28153 | 1090 | 22 | 0 | 1068 | 31.64135687 | -88.69573913 | 2020-11-14 05:25:37 | Wayne, Mississippi, US |
2785975 | 2785975 | 2020-11-13 | US | Illinois | Douglas | 17041 | 1078 | 10 | 0 | 1068 | 39.76768052 | -88.21854195 | 2020-11-14 05:25:37 | Douglas, Illinois, 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]);