johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
217 rows where active = 1184 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
626155 | 626155 | 2021-07-10 | Seychelles | 16793 | 68 | 15541 | 1184 | -4.6796 | 55.492 | 2021-07-11 04:21:43 | Seychelles | |||
1712275 | 1712275 | 2021-06-25 | India | Jharkhand | 345161 | 5107 | 338870 | 1184 | 23.654536 | 85.557631 | 2021-06-26 04:21:43 | Jharkhand, India | ||
1129272 | 1129272 | 2021-06-18 | Malaysia | Pahang | 11900 | 85 | 10631 | 1184 | 3.8126 | 103.3256 | 2021-06-19 04:22:33 | Pahang, Malaysia | ||
2104050 | 2104050 | 2021-06-01 | Germany | Schleswig-Holstein | 63100 | 1595 | 60400 | 1184 | 54.2194 | 9.6961 | 2021-06-02 04:24:34 | Schleswig-Holstein, Germany | ||
2571931 | 2571931 | 2021-04-13 | Russia | Tver Oblast | 38611 | 782 | 36645 | 1184 | 57.1134475 | 35.174442799999994 | 2021-04-14 04:20:41 | Tver Oblast, Russia | ||
3671115 | 3671115 | 2021-03-06 | US | West Virginia | Nicholas | 54067 | 1196 | 12 | 0 | 1184 | 38.29617706 | -80.79759588 | 2021-03-07 05:21:54 | Nicholas, West Virginia, US |
3668788 | 3668788 | 2021-03-06 | US | Iowa | Chickasaw | 19037 | 1199 | 15 | 0 | 1184 | 43.06001295 | -92.31773347 | 2021-03-07 05:21:54 | Chickasaw, Iowa, US |
1618645 | 1618645 | 2021-03-05 | US | North Dakota | McLean | 38055 | 1213 | 31 | 0 | 1184 | 47.60766714 | -101.3182418 | 2021-03-06 04:23:41 | McLean, North Dakota, US |
1617662 | 1617662 | 2021-03-05 | US | Kentucky | Lee | 21129 | 1203 | 19 | 0 | 1184 | 37.59645942 | -83.71513901 | 2021-03-06 04:23:41 | Lee, Kentucky, US |
1617409 | 1617409 | 2021-03-05 | US | Iowa | Chickasaw | 19037 | 1199 | 15 | 0 | 1184 | 43.06001295 | -92.31773347 | 2021-03-06 04:23:41 | Chickasaw, Iowa, US |
1090599 | 1090599 | 2021-03-03 | US | Arkansas | Van Buren | 5141 | 1203 | 19 | 0 | 1184 | 35.58095779 | -92.51295036 | 2021-03-04 05:24:24 | Van Buren, Arkansas, US |
3255556 | 3255556 | 2021-03-02 | US | Kentucky | Jackson | 21109 | 1213 | 29 | 0 | 1184 | 37.41866422 | -83.99825483 | 2021-03-03 05:23:28 | Jackson, Kentucky, US |
3255421 | 3255421 | 2021-03-02 | US | Kansas | Ellsworth | 20053 | 1208 | 24 | 0 | 1184 | 38.69677695 | -98.20462799 | 2021-03-03 05:23:28 | Ellsworth, Kansas, US |
1001739 | 1001739 | 2021-03-01 | US | Virginia | Brunswick | 51025 | 1200 | 16 | 0 | 1184 | 36.76366949 | -77.8593436 | 2021-03-02 05:23:30 | Brunswick, Virginia, US |
999713 | 999713 | 2021-03-01 | US | Kansas | Ellsworth | 20053 | 1208 | 24 | 0 | 1184 | 38.69677695 | -98.20462799 | 2021-03-02 05:23:30 | Ellsworth, Kansas, US |
998233 | 998233 | 2021-03-01 | Chile | OHiggins | 30537 | 769 | 28584 | 1184 | -34.5755 | -71.0022 | 2021-03-02 05:23:30 | OHiggins, Chile | ||
2369319 | 2369319 | 2021-02-28 | US | Mississippi | Montgomery | 28097 | 1222 | 38 | 0 | 1184 | 33.49419589 | -89.61729103 | 2021-03-01 05:23:01 | Montgomery, Mississippi, US |
283482 | 283482 | 2021-02-24 | US | Virginia | Bristol | 51520 | 1211 | 27 | 0 | 1184 | 36.6163024 | -82.16359122 | 2021-02-25 05:24:57 | Bristol, Virginia, US |
1939750 | 1939750 | 2021-02-23 | US | Virginia | Bristol | 51520 | 1211 | 27 | 0 | 1184 | 36.6163024 | -82.16359122 | 2021-02-24 05:29:16 | Bristol, Virginia, US |
532124 | 532124 | 2021-02-22 | US | Kentucky | Lawrence | 21127 | 1202 | 18 | 0 | 1184 | 38.07136018 | -82.72882223 | 2021-02-23 05:23:41 | Lawrence, Kentucky, US |
185339 | 185339 | 2021-02-21 | US | Virginia | Bristol | 51520 | 1211 | 27 | 0 | 1184 | 36.6163024 | -82.16359122 | 2021-02-22 05:24:21 | Bristol, Virginia, US |
475089 | 475089 | 2021-02-19 | Malaysia | Negeri Sembilan | 13774 | 29 | 12561 | 1184 | 2.7258 | 101.9424 | 2021-02-20 05:22:51 | Negeri Sembilan, Malaysia | ||
472818 | 472818 | 2021-02-19 | US | Kentucky | Henry | 21103 | 1191 | 7 | 0 | 1184 | 38.44942688 | -85.11587507 | 2021-02-20 05:22:51 | Henry, Kentucky, US |
1156420 | 1156420 | 2021-02-18 | US | Virginia | Bristol | 51520 | 1211 | 27 | 0 | 1184 | 36.6163024 | -82.16359122 | 2021-02-19 05:24:16 | Bristol, Virginia, US |
3603779 | 3603779 | 2021-02-17 | US | Puerto Rico | Humacao | 72069 | 1184 | 0 | 0 | 1184 | 18.145211 | -65.810174 | 2021-02-18 05:22:58 | Humacao, Puerto Rico, US |
3602958 | 3602958 | 2021-02-17 | US | Missouri | Macon | 29121 | 1196 | 12 | 0 | 1184 | 39.83049768 | -92.56453089 | 2021-02-18 05:22:58 | Macon, Missouri, US |
3052001 | 3052001 | 2021-02-16 | US | Mississippi | Noxubee | 28103 | 1213 | 29 | 0 | 1184 | 33.11009499 | -88.56949061 | 2021-02-17 05:23:10 | Noxubee, Mississippi, US |
2284981 | 2284981 | 2021-02-14 | US | Maine | Somerset | 23025 | 1210 | 26 | 0 | 1184 | 45.51229767 | -69.95995554 | 2021-02-15 05:24:49 | Somerset, Maine, US |
2284969 | 2284969 | 2021-02-14 | US | Maine | Aroostook | 23003 | 1227 | 43 | 0 | 1184 | 46.65926321 | -68.59841248 | 2021-02-15 05:24:49 | Aroostook, Maine, US |
2284588 | 2284588 | 2021-02-14 | US | Iowa | Cass | 19029 | 1231 | 47 | 0 | 1184 | 41.33149454 | -94.92792482 | 2021-02-15 05:24:49 | Cass, Iowa, US |
2678988 | 2678988 | 2021-02-13 | US | Iowa | Cass | 19029 | 1231 | 47 | 0 | 1184 | 41.33149454 | -94.92792482 | 2021-02-14 05:23:43 | Cass, Iowa, US |
2640353 | 2640353 | 2021-02-11 | US | Oregon | Wasco | 41065 | 1208 | 24 | 0 | 1184 | 45.16292781 | -121.1670954 | 2021-02-12 05:23:29 | Wasco, Oregon, US |
1529549 | 1529549 | 2021-02-09 | US | Michigan | Mason | 26105 | 1210 | 26 | 0 | 1184 | 43.99509218 | -86.24988902 | 2021-02-10 05:22:41 | Mason, Michigan, US |
615340 | 615340 | 2021-02-08 | US | Michigan | Mason | 26105 | 1210 | 26 | 0 | 1184 | 43.99509218 | -86.24988902 | 2021-02-09 05:23:30 | Mason, Michigan, US |
978189 | 978189 | 2021-02-06 | US | Vermont | Bennington | 50003 | 1189 | 5 | 0 | 1184 | 43.03519828 | -73.09048868 | 2021-02-07 05:23:00 | Bennington, Vermont, US |
975527 | 975527 | 2021-02-06 | US | Colorado | Elbert | 8039 | 1282 | 12 | 0 | 1184 | 39.28656773 | -104.1358721 | 2021-02-07 05:23:00 | Elbert, Colorado, US |
343709 | 343709 | 2021-02-03 | US | Washington | Island | 53029 | 1206 | 22 | 0 | 1184 | 48.14713305 | -122.5216407 | 2021-02-04 05:22:26 | Island, Washington, US |
340496 | 340496 | 2021-02-03 | Russia | Mari El Republic | 10793 | 156 | 9453 | 1184 | 56.5767504 | 47.8817512 | 2021-02-04 05:22:26 | Mari El Republic, Russia | ||
1463325 | 1463325 | 2021-01-31 | US | Wisconsin | Price | 55099 | 1191 | 7 | 0 | 1184 | 45.68051754 | -90.3609888 | 2021-02-01 05:22:53 | Price, Wisconsin, US |
2213135 | 2213135 | 2021-01-30 | US | Kentucky | Union | 21225 | 1195 | 11 | 0 | 1184 | 37.66166713 | -87.94300009 | 2021-01-31 05:22:42 | Union, Kentucky, US |
1900671 | 1900671 | 2021-01-29 | US | Wisconsin | Ashland | 55003 | 1200 | 16 | 0 | 1184 | 46.31956891 | -90.67837132 | 2021-01-30 05:22:49 | Ashland, Wisconsin, US |
2484460 | 2484460 | 2021-01-28 | US | Ohio | Noble | 39121 | 1221 | 37 | 0 | 1184 | 39.76818851 | -81.45937183 | 2021-01-29 05:22:23 | Noble, Ohio, US |
2482191 | 2482191 | 2021-01-28 | Russia | Mari El Republic | 10533 | 152 | 9197 | 1184 | 56.5767504 | 47.8817512 | 2021-01-29 05:22:23 | Mari El Republic, Russia | ||
3156569 | 3156569 | 2021-01-27 | US | Tennessee | Meigs | 47121 | 1177 | 17 | 0 | 1184 | 35.51558739 | -84.81482914 | 2021-01-28 05:22:24 | Meigs, Tennessee, US |
3156501 | 3156501 | 2021-01-27 | US | South Dakota | Todd | 46121 | 1208 | 24 | 0 | 1184 | 43.19338568 | -100.7195503 | 2021-01-28 05:22:24 | Todd, South Dakota, US |
3153826 | 3153826 | 2021-01-27 | Russia | Mari El Republic | 10489 | 151 | 9154 | 1184 | 56.5767504 | 47.8817512 | 2021-01-28 05:22:24 | Mari El Republic, Russia | ||
13026 | 13026 | 2021-01-26 | US | Florida | Franklin | 12037 | 1194 | 10 | 0 | 1184 | 29.83791238 | -84.82731662 | 2021-01-27 05:23:41 | Franklin, Florida, US |
2568039 | 2568039 | 2021-01-25 | US | Alabama | Lamar | 1075 | 1206 | 22 | 0 | 1184 | 33.77995024 | -88.09668032 | 2021-01-26 05:22:02 | Lamar, Alabama, US |
1762717 | 1762717 | 2021-01-24 | US | Washington | Asotin | 53003 | 1210 | 26 | 0 | 1184 | 46.18894415 | -117.2022851 | 2021-01-25 05:22:16 | Asotin, Washington, US |
2430324 | 2430324 | 2021-01-23 | US | Washington | Asotin | 53003 | 1210 | 26 | 0 | 1184 | 46.18894415 | -117.2022851 | 2021-01-24 05:22:35 | Asotin, Washington, US |
2428669 | 2428669 | 2021-01-23 | US | Minnesota | Wadena | 27159 | 1202 | 18 | 0 | 1184 | 46.58589171 | -94.96968506 | 2021-01-24 05:22:35 | Wadena, Minnesota, US |
438203 | 438203 | 2021-01-21 | US | South Dakota | Charles Mix | 46023 | 1198 | 14 | 0 | 1184 | 43.20660134 | -98.58856175 | 2021-01-22 05:22:10 | Charles Mix, South Dakota, US |
437272 | 437272 | 2021-01-21 | US | Missouri | Livingston | 29117 | 1209 | 25 | 0 | 1184 | 39.78110272 | -93.54645978 | 2021-01-22 05:22:10 | Livingston, Missouri, US |
1097766 | 1097766 | 2021-01-20 | Malaysia | Pahang | 2373 | 9 | 1180 | 1184 | 3.8126 | 103.3256 | 2021-01-21 05:22:01 | Pahang, Malaysia | ||
1095853 | 1095853 | 2021-01-20 | US | Minnesota | Wadena | 27159 | 1201 | 17 | 0 | 1184 | 46.58589171 | -94.96968506 | 2021-01-21 05:22:01 | Wadena, Minnesota, US |
910941 | 910941 | 2021-01-19 | US | Puerto Rico | Rio Grande | 72119 | 1184 | 0 | 0 | 1184 | 18.346329 | -65.813742 | 2021-01-20 05:21:54 | Rio Grande, Puerto Rico, US |
3504647 | 3504647 | 2021-01-17 | US | Kansas | Jackson | 20085 | 1194 | 10 | 0 | 1184 | 39.41673394 | -95.79356799 | 2021-01-18 05:22:34 | Jackson, Kansas, US |
3104775 | 3104775 | 2021-01-16 | US | Virginia | Gloucester | 51073 | 1198 | 14 | 0 | 1184 | 37.40809042 | -76.53524337 | 2021-01-17 05:22:17 | Gloucester, Virginia, US |
3102730 | 3102730 | 2021-01-16 | US | Kansas | Jackson | 20085 | 1194 | 10 | 0 | 1184 | 39.41673394 | -95.79356799 | 2021-01-17 05:22:17 | Jackson, Kansas, US |
3517260 | 3517260 | 2021-01-15 | US | Missouri | Andrew | 29003 | 1200 | 16 | 0 | 1184 | 39.98492163 | -94.80163024 | 2021-01-16 05:22:40 | Andrew, Missouri, US |
3516692 | 3516692 | 2021-01-15 | US | Kansas | Jackson | 20085 | 1194 | 10 | 0 | 1184 | 39.41673394 | -95.79356799 | 2021-01-16 05:22:40 | Jackson, Kansas, US |
3516141 | 3516141 | 2021-01-15 | US | Georgia | Bacon | 13005 | 1209 | 25 | 0 | 1184 | 31.55456473 | -82.45936528 | 2021-01-16 05:22:40 | Bacon, Georgia, US |
3882906 | 3882906 | 2021-01-14 | US | Virginia | Fredericksburg | 51630 | 1196 | 12 | 0 | 1184 | 38.2977863 | -77.4922454 | 2021-01-15 05:22:24 | Fredericksburg, Virginia, US |
3903075 | 3903075 | 2021-01-09 | US | Texas | Hutchinson | 48233 | 2265 | 52 | 0 | 1184 | 35.84006574 | -101.3546643 | 2021-01-10 05:22:12 | Hutchinson, Texas, US |
3901093 | 3901093 | 2021-01-09 | US | Indiana | Tipton | 18159 | 1223 | 39 | 0 | 1184 | 40.31123252 | -86.05234925 | 2021-01-10 05:22:12 | Tipton, Indiana, US |
3037207 | 3037207 | 2021-01-05 | US | Tennessee | Benton | 47005 | 1247 | 31 | 0 | 1184 | 36.07110411 | -88.06849355 | 2021-01-06 05:22:16 | Benton, Tennessee, US |
3035490 | 3035490 | 2021-01-05 | US | Iowa | Hancock | 19081 | 1208 | 24 | 0 | 1184 | 43.08178477 | -93.73454884 | 2021-01-06 05:22:16 | Hancock, Iowa, US |
1063282 | 1063282 | 2021-01-04 | US | Kentucky | Meade | 21163 | 1188 | 4 | 0 | 1184 | 37.96163597 | -86.21028219 | 2021-01-05 05:21:49 | Meade, Kentucky, US |
1063202 | 1063202 | 2021-01-04 | US | Kentucky | Allen | 21003 | 1201 | 17 | 0 | 1184 | 36.75197631 | -86.19457544 | 2021-01-05 05:21:49 | Allen, Kentucky, US |
1063007 | 1063007 | 2021-01-04 | US | Iowa | Calhoun | 19025 | 1193 | 9 | 0 | 1184 | 42.38521079 | -94.64046046 | 2021-01-05 05:21:49 | Calhoun, Iowa, US |
1062051 | 1062051 | 2021-01-04 | Russia | Kamchatka Krai | 10401 | 82 | 9135 | 1184 | 57.1914882 | 160.03838190000005 | 2021-01-05 05:21:49 | Kamchatka Krai, Russia | ||
1138721 | 1138721 | 2021-01-01 | US | Mississippi | Stone | 28131 | 1202 | 18 | 0 | 1184 | 30.79187949 | -89.11547539 | 2021-01-02 05:22:33 | Stone, Mississippi, US |
3696567 | 3696567 | 2020-12-31 | US | Indiana | Franklin | 18047 | 1213 | 29 | 0 | 1184 | 39.4142482 | -85.06062647 | 2021-01-01 05:23:07 | Franklin, Indiana, US |
1012581 | 1012581 | 2020-12-30 | US | North Carolina | Ashe | 37009 | 1211 | 27 | 0 | 1184 | 36.43296207 | -81.49862729 | 2020-12-31 05:22:49 | Ashe, North Carolina, US |
1011281 | 1011281 | 2020-12-30 | US | Illinois | Ford | 17053 | 1221 | 37 | 0 | 1184 | 40.59706922 | -88.22350769 | 2020-12-31 05:22:49 | Ford, Illinois, US |
1010691 | 1010691 | 2020-12-30 | US | Alabama | Monroe | 1099 | 1195 | 11 | 0 | 1184 | 31.56729412 | -87.36995001 | 2020-12-31 05:22:49 | Monroe, Alabama, US |
2223702 | 2223702 | 2020-12-26 | Russia | Chuvashia Republic | 15815 | 475 | 14156 | 1184 | 55.4259922 | 47.0849429 | 2020-12-27 05:22:55 | Chuvashia Republic, Russia | ||
3770938 | 3770938 | 2020-12-22 | US | Indiana | Carroll | 18015 | 1198 | 14 | 0 | 1184 | 40.580783200000006 | -86.56198812 | 2020-12-23 05:22:03 | Carroll, Indiana, US |
929393 | 929393 | 2020-12-21 | US | Minnesota | Cottonwood | 27033 | 1196 | 12 | 0 | 1184 | 44.00715262 | -95.18138802 | 2020-12-22 05:22:33 | Cottonwood, Minnesota, US |
2122746 | 2122746 | 2020-12-20 | US | Texas | Cass | 48067 | 1125 | 43 | 0 | 1184 | 33.07499881 | -94.34646905 | 2020-12-21 05:27:58 | Cass, Texas, US |
2120184 | 2120184 | 2020-12-20 | US | Arkansas | Cross | 5037 | 1217 | 33 | 0 | 1184 | 35.29631396 | -90.77185818 | 2020-12-21 05:27:58 | Cross, Arkansas, US |
2933595 | 2933595 | 2020-12-19 | US | North Dakota | Barnes | 38003 | 1195 | 23 | 0 | 1184 | 46.93579637 | -98.06605978 | 2020-12-20 05:27:32 | Barnes, North Dakota, US |
1903291 | 1903291 | 2020-12-18 | US | Nevada | Churchill | 32001 | 1213 | 29 | 0 | 1184 | 39.58105744 | -118.3394607 | 2020-12-19 05:27:52 | Churchill, Nevada, US |
2130117 | 2130117 | 2020-12-17 | US | Nevada | Churchill | 32001 | 1213 | 29 | 0 | 1184 | 39.58105744 | -118.3394607 | 2020-12-18 05:28:18 | Churchill, Nevada, US |
2130109 | 2130109 | 2020-12-17 | US | Nebraska | Unassigned | 90031 | 1186 | 2 | 0 | 1184 | 42.8997274 | 0.0 | 2020-12-18 05:28:18 | Unassigned, Nebraska, US |
3150773 | 3150773 | 2020-12-16 | US | Iowa | Floyd | 19067 | 1210 | 26 | 0 | 1184 | 43.06000529999999 | -92.78940097 | 2020-12-17 05:28:12 | Floyd, Iowa, US |
1034601 | 1034601 | 2020-12-15 | Russia | North Ossetia - Alania Republic | 10605 | 81 | 9340 | 1184 | 42.79336110000001 | 44.6324493 | 2020-12-16 05:28:04 | North Ossetia - Alania Republic, Russia | ||
1752756 | 1752756 | 2020-12-14 | US | Louisiana | Concordia | 22029 | 1217 | 33 | 0 | 1184 | 31.44817835 | -91.63814433 | 2020-12-15 05:26:38 | Concordia, Louisiana, US |
3851165 | 3851165 | 2020-12-13 | US | Virginia | Petersburg | 51730 | 1215 | 31 | 0 | 1184 | 37.20530399 | -77.39368102 | 2020-12-14 05:26:27 | Petersburg, Virginia, US |
861221 | 861221 | 2020-12-11 | US | California | Lake | 6033 | 1205 | 21 | 0 | 1184 | 39.10124298 | -122.7536244 | 2020-12-12 05:26:19 | Lake, California, US |
861216 | 861216 | 2020-12-11 | US | California | Humboldt | 6023 | 1193 | 9 | 0 | 1184 | 40.69923009 | -123.876044 | 2020-12-12 05:26:19 | Humboldt, California, US |
1602477 | 1602477 | 2020-12-10 | US | New York | St. Lawrence | 36089 | 1206 | 22 | 0 | 1184 | 44.4976179 | -75.06550039 | 2020-12-11 05:26:59 | St. Lawrence, New York, US |
1601211 | 1601211 | 2020-12-10 | US | Illinois | Jo Daviess | 17085 | 1204 | 20 | 0 | 1184 | 42.36542373 | -90.21094405 | 2020-12-11 05:26:59 | Jo Daviess, Illinois, US |
1820457 | 1820457 | 2020-12-08 | US | Michigan | Out of MI | 80026 | 1193 | 9 | 0 | 1184 | 47.63197653 | 0.0 | 2020-12-09 05:28:01 | Out of MI, Michigan, US |
1008057 | 1008057 | 2020-12-06 | US | Minnesota | Wabasha | 27157 | 1185 | 1 | 0 | 1184 | 44.28424356 | -92.23121312 | 2020-12-07 05:26:14 | Wabasha, Minnesota, US |
3861543 | 3861543 | 2020-12-04 | US | Minnesota | Hubbard | 27057 | 1213 | 29 | 0 | 1184 | 47.10778564 | -94.91693868 | 2020-12-05 05:27:36 | Hubbard, Minnesota, US |
78145 | 78145 | 2020-12-03 | US | Texas | Dawson | 48115 | 801 | 37 | 0 | 1184 | 32.74255572 | -101.9477242 | 2020-12-04 05:27:27 | Dawson, Texas, US |
741357 | 741357 | 2020-12-02 | US | Texas | Dawson | 48115 | 790 | 37 | 0 | 1184 | 32.74255572 | -101.9477242 | 2020-12-03 05:28:22 | Dawson, Texas, US |
740709 | 740709 | 2020-12-02 | US | North Dakota | Ramsey | 38071 | 1219 | 8 | 0 | 1184 | 48.26886249 | -98.72223879 | 2020-12-03 05:28:22 | Ramsey, North Dakota, US |
738997 | 738997 | 2020-12-02 | US | Florida | Holmes | 12059 | 1199 | 15 | 0 | 1184 | 30.86747479 | -85.81319222 | 2020-12-03 05:28:22 | Holmes, 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]);