johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
214 rows where active = 1175 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408146 | 408146 | 2021-07-28 | Colombia | Meta | 84920 | 2081 | 81664 | 1175 | 3.272 | -73.0877 | 2021-07-29 04:21:33 | Meta, Colombia | ||
2884577 | 2884577 | 2021-06-20 | Russia | Karelia Republic | 48562 | 599 | 46788 | 1175 | 62.61940309999999 | 33.4920267 | 2021-06-21 04:21:41 | Karelia Republic, Russia | ||
3472309 | 3472309 | 2021-06-08 | Japan | Hyogo | 40285 | 1237 | 37873 | 1175 | 35.039913 | 134.828057 | 2021-06-09 04:23:31 | Hyogo, Japan | ||
3145374 | 3145374 | 2021-06-07 | Chile | Nuble | 31444 | 524 | 29745 | 1175 | -36.7226 | -71.7622 | 2021-06-08 04:22:35 | Nuble, Chile | ||
82884 | 82884 | 2021-05-25 | Chile | Los Rios | 37634 | 427 | 36032 | 1175 | -40.231 | -72.3311 | 2021-05-26 04:20:35 | Los Rios, Chile | ||
2939543 | 2939543 | 2021-05-16 | Russia | Kursk Oblast | 37501 | 763 | 35563 | 1175 | 51.6568453 | 36.4852695 | 2021-05-17 04:20:34 | Kursk Oblast, Russia | ||
3054304 | 3054304 | 2021-05-13 | Mozambique | 70315 | 826 | 68314 | 1175 | -18.665695 | 35.529562 | 2021-05-14 04:20:41 | Mozambique | |||
2004515 | 2004515 | 2021-05-12 | Colombia | Norte de Santander | 56782 | 2901 | 52706 | 1175 | 7.9463 | -72.8988 | 2021-05-13 04:20:51 | Norte de Santander, Colombia | ||
3113462 | 3113462 | 2021-05-06 | Israel | 838828 | 6374 | 831279 | 1175 | 31.046051 | 34.851612 | 2021-05-07 04:20:40 | Israel | |||
1409296 | 1409296 | 2021-04-23 | Russia | Tyumen Oblast | 34793 | 451 | 33167 | 1175 | 58.8206488 | 70.36588370000001 | 2021-04-24 04:20:38 | Tyumen Oblast, Russia | ||
1980566 | 1980566 | 2021-03-25 | India | Jharkhand | 121973 | 1100 | 119698 | 1175 | 23.654536 | 85.557631 | 2021-03-26 05:26:55 | Jharkhand, India | ||
1580402 | 1580402 | 2021-03-13 | Russia | Tomsk Oblast | 30785 | 329 | 29281 | 1175 | 58.6124279 | 82.04753149999998 | 2021-03-14 05:25:37 | Tomsk Oblast, Russia | ||
2210250 | 2210250 | 2021-03-04 | US | Oklahoma | Woods | 40151 | 1186 | 11 | 0 | 1175 | 36.76705782 | -98.86573064 | 2021-03-05 05:26:29 | Woods, Oklahoma, US |
3256916 | 3256916 | 2021-03-02 | US | Puerto Rico | San Lorenzo | 72129 | 1175 | 0 | 0 | 1175 | 18.147987 | -65.976392 | 2021-03-03 05:23:28 | San Lorenzo, Puerto Rico, US |
1001314 | 1001314 | 2021-03-01 | US | South Dakota | Lake | 46079 | 1192 | 17 | 0 | 1175 | 44.02193107 | -97.12926365 | 2021-03-02 05:23:30 | Lake, South Dakota, US |
1001208 | 1001208 | 2021-03-01 | US | Puerto Rico | San Lorenzo | 72129 | 1175 | 0 | 0 | 1175 | 18.147987 | -65.976392 | 2021-03-02 05:23:30 | San Lorenzo, Puerto Rico, US |
999858 | 999858 | 2021-03-01 | US | Kentucky | Lee | 21129 | 1194 | 19 | 0 | 1175 | 37.59645942 | -83.71513901 | 2021-03-02 05:23:30 | Lee, Kentucky, US |
3067811 | 3067811 | 2021-02-27 | US | Mississippi | Lawrence | 28077 | 1196 | 21 | 0 | 1175 | 31.55147224 | -90.10841127 | 2021-02-28 05:22:20 | Lawrence, Mississippi, US |
3067408 | 3067408 | 2021-02-27 | US | Kentucky | Jackson | 21109 | 1204 | 29 | 0 | 1175 | 37.41866422 | -83.99825483 | 2021-02-28 05:22:20 | Jackson, Kentucky, US |
2186883 | 2186883 | 2021-02-26 | US | Virginia | Brunswick | 51025 | 1189 | 14 | 0 | 1175 | 36.76366949 | -77.8593436 | 2021-02-27 05:22:28 | Brunswick, Virginia, US |
2185840 | 2185840 | 2021-02-26 | US | New York | Schoharie | 36095 | 1187 | 12 | 0 | 1175 | 42.58831742 | -74.44339029999998 | 2021-02-27 05:22:28 | Schoharie, New York, US |
2185405 | 2185405 | 2021-02-26 | US | Mississippi | Montgomery | 28097 | 1213 | 38 | 0 | 1175 | 33.49419589 | -89.61729103 | 2021-02-27 05:22:28 | Montgomery, Mississippi, US |
1860407 | 1860407 | 2021-02-25 | US | North Dakota | McLean | 38055 | 1207 | 31 | 0 | 1175 | 47.60766714 | -101.3182418 | 2021-02-26 05:22:40 | McLean, North Dakota, US |
1859827 | 1859827 | 2021-02-25 | US | Mississippi | Montgomery | 28097 | 1212 | 37 | 0 | 1175 | 33.49419589 | -89.61729103 | 2021-02-26 05:22:40 | Montgomery, Mississippi, US |
283483 | 283483 | 2021-02-24 | US | Virginia | Brunswick | 51025 | 1187 | 12 | 0 | 1175 | 36.76366949 | -77.8593436 | 2021-02-25 05:24:57 | Brunswick, Virginia, US |
282585 | 282585 | 2021-02-24 | US | North Dakota | McLean | 38055 | 1206 | 31 | 0 | 1175 | 47.60766714 | -101.3182418 | 2021-02-25 05:24:57 | McLean, North Dakota, US |
282012 | 282012 | 2021-02-24 | US | Mississippi | Perry | 28111 | 1209 | 34 | 0 | 1175 | 31.17161885 | -88.99281835 | 2021-02-25 05:24:57 | Perry, Mississippi, US |
182654 | 182654 | 2021-02-21 | US | Colorado | Gunnison | 8051 | 1204 | 6 | 0 | 1175 | 38.66611652 | -107.0320729 | 2021-02-22 05:24:21 | Gunnison, Colorado, US |
742719 | 742719 | 2021-02-20 | US | Alabama | Wilcox | 1131 | 1200 | 25 | 0 | 1175 | 31.98773215 | -87.30891118 | 2021-02-21 05:24:33 | Wilcox, Alabama, US |
472026 | 472026 | 2021-02-19 | US | Colorado | Gunnison | 8051 | 1201 | 6 | 0 | 1175 | 38.66611652 | -107.0320729 | 2021-02-20 05:22:51 | Gunnison, Colorado, US |
3601912 | 3601912 | 2021-02-17 | US | Georgia | Telfair | 13271 | 1224 | 49 | 0 | 1175 | 31.92829517 | -82.93491155 | 2021-02-18 05:22:58 | Telfair, Georgia, US |
1341013 | 1341013 | 2021-02-15 | US | Puerto Rico | Humacao | 72069 | 1175 | 0 | 0 | 1175 | 18.145211 | -65.810174 | 2021-02-16 05:24:38 | Humacao, Puerto Rico, US |
1338696 | 1338696 | 2021-02-15 | US | Alaska | Kusilvak | 2158 | 1178 | 3 | 0 | 1175 | 62.15429159999999 | -163.39678830000003 | 2021-02-16 05:24:38 | Kusilvak, Alaska, US |
2283847 | 2283847 | 2021-02-14 | US | Alaska | Kusilvak | 2158 | 1178 | 3 | 0 | 1175 | 62.15429159999999 | -163.39678830000003 | 2021-02-15 05:24:49 | Kusilvak, Alaska, US |
2678247 | 2678247 | 2021-02-13 | US | Alaska | Kusilvak | 2158 | 1178 | 3 | 0 | 1175 | 62.15429159999999 | -163.39678830000003 | 2021-02-14 05:23:43 | Kusilvak, Alaska, US |
3542008 | 3542008 | 2021-02-12 | US | Oklahoma | Haskell | 40061 | 1184 | 9 | 0 | 1175 | 35.22257600000001 | -95.11513306 | 2021-02-13 05:22:12 | Haskell, Oklahoma, US |
3539880 | 3539880 | 2021-02-12 | US | Alaska | Kusilvak | 2158 | 1178 | 3 | 0 | 1175 | 62.15429159999999 | -163.39678830000003 | 2021-02-13 05:22:12 | Kusilvak, Alaska, US |
2640271 | 2640271 | 2021-02-11 | US | Oklahoma | Haskell | 40061 | 1184 | 9 | 0 | 1175 | 35.22257600000001 | -95.11513306 | 2021-02-12 05:23:29 | Haskell, Oklahoma, US |
3980494 | 3980494 | 2021-02-10 | US | Missouri | Macon | 29121 | 1187 | 12 | 0 | 1175 | 39.83049768 | -92.56453089 | 2021-02-11 05:23:55 | Macon, Missouri, US |
1530944 | 1530944 | 2021-02-09 | US | Texas | Comanche | 48093 | 1275 | 44 | 0 | 1175 | 31.94854689 | -98.55876441 | 2021-02-10 05:22:41 | Comanche, Texas, US |
617016 | 617016 | 2021-02-08 | US | Virginia | Fluvanna | 51065 | 1188 | 13 | 0 | 1175 | 37.84157909 | -78.27715475 | 2021-02-09 05:23:30 | Fluvanna, Virginia, US |
1588785 | 1588785 | 2021-02-05 | US | Colorado | Elbert | 8039 | 1279 | 12 | 0 | 1175 | 39.28656773 | -104.1358721 | 2021-02-06 05:23:55 | Elbert, Colorado, US |
1588765 | 1588765 | 2021-02-05 | US | Colorado | Alamosa | 8003 | 1263 | 29 | 0 | 1175 | 37.57250606 | -105.7885451 | 2021-02-06 05:23:55 | Alamosa, Colorado, US |
1459730 | 1459730 | 2021-01-31 | India | Uttarakhand | 96129 | 1644 | 93310 | 1175 | 30.156447 | 79.197608 | 2021-02-01 05:22:53 | Uttarakhand, India | ||
1899250 | 1899250 | 2021-01-29 | US | Nebraska | Otoe | 31131 | 1179 | 4 | 0 | 1175 | 40.64843556 | -96.13374142 | 2021-01-30 05:22:49 | Otoe, Nebraska, US |
2484066 | 2484066 | 2021-01-28 | US | Nebraska | Otoe | 31131 | 1179 | 4 | 0 | 1175 | 40.64843556 | -96.13374142 | 2021-01-29 05:22:23 | Otoe, Nebraska, US |
2482658 | 2482658 | 2021-01-28 | US | Florida | Gilchrist | 12041 | 1203 | 28 | 0 | 1175 | 29.72856978 | -82.79880657 | 2021-01-29 05:22:23 | Gilchrist, Florida, US |
3154574 | 3154574 | 2021-01-27 | US | Illinois | De Witt | 17039 | 1197 | 22 | 0 | 1175 | 40.17514519 | -88.90959682 | 2021-01-28 05:22:24 | De Witt, Illinois, US |
15632 | 15632 | 2021-01-26 | US | Virginia | Appomattox | 51011 | 1183 | 8 | 0 | 1175 | 37.37569884 | -78.81340003 | 2021-01-27 05:23:41 | Appomattox, Virginia, US |
1762782 | 1762782 | 2021-01-24 | US | West Virginia | McDowell | 54047 | 1186 | 11 | 0 | 1175 | 37.38002939 | -81.65083669 | 2021-01-25 05:22:16 | McDowell, West Virginia, US |
1762260 | 1762260 | 2021-01-24 | US | Tennessee | Meigs | 47121 | 1164 | 16 | 0 | 1175 | 35.51558739 | -84.81482914 | 2021-01-25 05:22:16 | Meigs, Tennessee, US |
1760056 | 1760056 | 2021-01-24 | US | Georgia | Charlton | 13049 | 1198 | 23 | 0 | 1175 | 30.78371028 | -82.13951596 | 2021-01-25 05:22:16 | Charlton, Georgia, US |
2428827 | 2428827 | 2021-01-23 | US | Missouri | Mississippi | 29133 | 1195 | 20 | 0 | 1175 | 36.82516239 | -89.29505753 | 2021-01-24 05:22:35 | Mississippi, Missouri, US |
435731 | 435731 | 2021-01-21 | US | Alabama | Lamar | 1075 | 1196 | 21 | 0 | 1175 | 33.77995024 | -88.09668032 | 2021-01-22 05:22:10 | Lamar, Alabama, US |
435395 | 435395 | 2021-01-21 | Japan | Tochigi | 3433 | 29 | 2229 | 1175 | 36.689912 | 139.819213 | 2021-01-22 05:22:10 | Tochigi, Japan | ||
1096003 | 1096003 | 2021-01-20 | US | Missouri | Livingston | 29117 | 1200 | 25 | 0 | 1175 | 39.78110272 | -93.54645978 | 2021-01-21 05:22:01 | Livingston, Missouri, US |
237940 | 237940 | 2021-01-18 | US | Florida | Jefferson | 12065 | 1193 | 18 | 0 | 1175 | 30.43669112 | -83.89442308 | 2021-01-19 05:22:15 | Jefferson, Florida, US |
3515898 | 3515898 | 2021-01-15 | US | Arkansas | Madison | 5087 | 1190 | 15 | 0 | 1175 | 36.01038185 | -93.72524943 | 2021-01-16 05:22:40 | Madison, Arkansas, US |
3311246 | 3311246 | 2021-01-13 | US | Texas | Colorado | 48089 | 1218 | 16 | 0 | 1175 | 29.622098 | -96.5273805 | 2021-01-14 05:22:32 | Colorado, Texas, US |
192759 | 192759 | 2021-01-11 | US | Pennsylvania | Susquehanna | 42115 | 1216 | 41 | 0 | 1175 | 41.82147784 | -75.80071959 | 2021-01-12 05:22:15 | Susquehanna, Pennsylvania, US |
192428 | 192428 | 2021-01-11 | US | North Carolina | Transylvania | 37175 | 1186 | 11 | 0 | 1175 | 35.20383864 | -82.79638423 | 2021-01-12 05:22:15 | Transylvania, North Carolina, US |
2628684 | 2628684 | 2021-01-10 | US | South Carolina | Hampton | 45049 | 1213 | 38 | 0 | 1175 | 32.77419582 | -81.13845571 | 2021-01-11 05:21:50 | Hampton, South Carolina, US |
2626852 | 2626852 | 2021-01-10 | US | Illinois | Greene | 17061 | 1205 | 30 | 0 | 1175 | 39.35907414 | -90.388865 | 2021-01-11 05:21:50 | Greene, Illinois, US |
3903212 | 3903212 | 2021-01-09 | US | Texas | Zapata | 48505 | 1426 | 13 | 0 | 1175 | 27.00156391 | -99.16987152 | 2021-01-10 05:22:12 | Zapata, Texas, US |
2543610 | 2543610 | 2021-01-07 | US | New Mexico | Taos | 35055 | 1216 | 41 | 0 | 1175 | 36.58006022 | -105.6310198 | 2021-01-08 05:22:42 | Taos, New Mexico, US |
2867668 | 2867668 | 2021-01-06 | US | Tennessee | Lewis | 47101 | 1234 | 20 | 0 | 1175 | 35.52853208 | -87.49022694 | 2021-01-07 05:22:03 | Lewis, Tennessee, US |
3231565 | 3231565 | 2021-01-03 | US | Indiana | Parke | 18121 | 1187 | 12 | 0 | 1175 | 39.77202286 | -87.20375833 | 2021-01-04 05:22:02 | Parke, Indiana, US |
2230995 | 2230995 | 2021-01-02 | US | West Virginia | Jackson | 54035 | 1205 | 30 | 0 | 1175 | 38.84263974 | -81.68148753 | 2021-01-03 05:22:52 | Jackson, West Virginia, US |
1137287 | 1137287 | 2021-01-01 | US | Alabama | Washington | 1129 | 1199 | 24 | 0 | 1175 | 31.4092794 | -88.20689944 | 2021-01-02 05:22:33 | Washington, Alabama, US |
769401 | 769401 | 2020-12-29 | US | Texas | Gaines | 48165 | 448 | 26 | 0 | 1175 | 32.74055318 | -102.6353295 | 2020-12-30 05:22:34 | Gaines, Texas, US |
3764665 | 3764665 | 2020-12-28 | US | Texas | Gaines | 48165 | 446 | 26 | 0 | 1175 | 32.74055318 | -102.6353295 | 2020-12-29 05:22:37 | Gaines, Texas, US |
3764574 | 3764574 | 2020-12-28 | US | Tennessee | Union | 47173 | 1230 | 14 | 0 | 1175 | 36.28590426 | -83.83651902 | 2020-12-29 05:22:37 | Union, Tennessee, US |
3780985 | 3780985 | 2020-12-27 | US | Texas | Gaines | 48165 | 441 | 26 | 0 | 1175 | 32.74055318 | -102.6353295 | 2020-12-28 05:22:06 | Gaines, Texas, US |
2226590 | 2226590 | 2020-12-26 | US | Texas | Gaines | 48165 | 441 | 26 | 0 | 1175 | 32.74055318 | -102.6353295 | 2020-12-27 05:22:55 | Gaines, Texas, US |
2224138 | 2224138 | 2020-12-26 | US | Colorado | Montezuma | 8083 | 1275 | 18 | 0 | 1175 | 37.33859579 | -108.5958857 | 2020-12-27 05:22:55 | Montezuma, Colorado, US |
2223724 | 2223724 | 2020-12-26 | Russia | Kurgan Oblast | 11472 | 161 | 10136 | 1175 | 55.7655302 | 64.5632681 | 2020-12-27 05:22:55 | Kurgan Oblast, Russia | ||
205337 | 205337 | 2020-12-25 | US | Texas | Gaines | 48165 | 439 | 26 | 0 | 1175 | 32.74055318 | -102.6353295 | 2020-12-26 05:22:28 | Gaines, Texas, US |
3694560 | 3694560 | 2020-12-24 | US | Texas | Gaines | 48165 | 439 | 26 | 0 | 1175 | 32.74055318 | -102.6353295 | 2020-12-25 05:22:48 | Gaines, Texas, US |
2409912 | 2409912 | 2020-12-23 | US | Texas | Gaines | 48165 | 434 | 26 | 0 | 1175 | 32.74055318 | -102.6353295 | 2020-12-24 05:23:04 | Gaines, Texas, US |
2407647 | 2407647 | 2020-12-23 | US | Georgia | Jefferson | 13163 | 1215 | 40 | 0 | 1175 | 33.05867328 | -82.41609057 | 2020-12-24 05:23:04 | Jefferson, Georgia, US |
3773120 | 3773120 | 2020-12-22 | US | Texas | Wilbarger | 48487 | 1332 | 26 | 0 | 1175 | 34.07945812 | -99.24178437 | 2020-12-23 05:22:03 | Wilbarger, Texas, US |
3770382 | 3770382 | 2020-12-22 | US | Arkansas | Phillips | 5107 | 1195 | 20 | 0 | 1175 | 34.43268455 | -90.84800154 | 2020-12-23 05:22:03 | Phillips, Arkansas, US |
2934606 | 2934606 | 2020-12-19 | US | Virginia | Pulaski | 51155 | 1202 | 27 | 0 | 1175 | 37.06474963 | -80.71229738 | 2020-12-20 05:27:32 | Pulaski, Virginia, US |
2933538 | 2933538 | 2020-12-19 | US | North Carolina | Hertford | 37091 | 1219 | 44 | 0 | 1175 | 36.3607755 | -76.98104134 | 2020-12-20 05:27:32 | Hertford, North Carolina, US |
2931910 | 2931910 | 2020-12-19 | US | Florida | Gulf | 12045 | 1200 | 25 | 0 | 1175 | 29.93543004 | -85.24270990000002 | 2020-12-20 05:27:32 | Gulf, Florida, US |
2931823 | 2931823 | 2020-12-19 | US | Colorado | Delta | 8029 | 1494 | 29 | 0 | 1175 | 38.86246243 | -107.8631342 | 2020-12-20 05:27:32 | Delta, Colorado, US |
2931691 | 2931691 | 2020-12-19 | US | Arkansas | Cross | 5037 | 1207 | 32 | 0 | 1175 | 35.29631396 | -90.77185818 | 2020-12-20 05:27:32 | Cross, Arkansas, US |
2931682 | 2931682 | 2020-12-19 | US | Arkansas | Clark | 5019 | 1193 | 18 | 0 | 1175 | 34.04613432 | -93.17484713 | 2020-12-20 05:27:32 | Clark, Arkansas, US |
1904456 | 1904456 | 2020-12-18 | US | Virginia | Amherst | 51009 | 1183 | 8 | 0 | 1175 | 37.60308293 | -79.14548696 | 2020-12-19 05:27:52 | Amherst, Virginia, US |
1902862 | 1902862 | 2020-12-18 | US | Minnesota | Chippewa | 27023 | 1194 | 19 | 0 | 1175 | 45.02343421 | -95.56403693 | 2020-12-19 05:27:52 | Chippewa, Minnesota, US |
2130959 | 2130959 | 2020-12-17 | US | Tennessee | Morgan | 47129 | 1321 | 11 | 0 | 1175 | 36.13248031 | -84.64880098 | 2020-12-18 05:28:18 | Morgan, Tennessee, US |
2129741 | 2129741 | 2020-12-17 | US | Minnesota | Renville | 27129 | 1210 | 35 | 0 | 1175 | 44.72836381 | -94.94553734 | 2020-12-18 05:28:18 | Renville, Minnesota, US |
1035399 | 1035399 | 2020-12-15 | US | Illinois | Pike | 17149 | 1208 | 33 | 0 | 1175 | 39.62265059 | -90.8877017 | 2020-12-16 05:28:04 | Pike, Illinois, US |
1752707 | 1752707 | 2020-12-14 | US | Kentucky | Montgomery | 21173 | 1187 | 12 | 0 | 1175 | 38.03253032 | -83.9145241 | 2020-12-15 05:26:38 | Montgomery, Kentucky, US |
1752012 | 1752012 | 2020-12-14 | US | Georgia | Ben Hill | 13017 | 1215 | 40 | 0 | 1175 | 31.76095874 | -83.22145359 | 2020-12-15 05:26:38 | Ben Hill, Georgia, US |
3849721 | 3849721 | 2020-12-13 | US | Missouri | Pemiscot | 29155 | 1194 | 19 | 0 | 1175 | 36.2130572 | -89.78742322 | 2020-12-14 05:26:27 | Pemiscot, Missouri, US |
847503 | 847503 | 2020-12-12 | US | Missouri | Pemiscot | 29155 | 1194 | 19 | 0 | 1175 | 36.2130572 | -89.78742322 | 2020-12-13 05:27:20 | Pemiscot, Missouri, US |
2976689 | 2976689 | 2020-12-09 | US | Kentucky | Taylor | 21217 | 1182 | 7 | 0 | 1175 | 37.3677562 | -85.3329931 | 2020-12-10 05:26:19 | Taylor, Kentucky, US |
1820610 | 1820610 | 2020-12-08 | US | Mississippi | Newton | 28101 | 1204 | 29 | 0 | 1175 | 32.40021118 | -89.11843336 | 2020-12-09 05:28:01 | Newton, Mississippi, US |
2348586 | 2348586 | 2020-12-07 | US | Iowa | Cedar | 19031 | 1190 | 15 | 0 | 1175 | 41.77233777 | -91.13246684 | 2020-12-08 05:27:42 | Cedar, Iowa, 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]);