johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
213 rows where active = 1168 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
778568 | 778568 | 2021-07-08 | Russia | Kamchatka Krai | 15630 | 238 | 14224 | 1168 | 57.1914882 | 160.03838190000005 | 2021-07-09 04:21:21 | Kamchatka Krai, Russia | ||
3381410 | 3381410 | 2021-06-13 | Japan | Saitama | 45036 | 817 | 43051 | 1168 | 35.997101 | 139.347635 | 2021-06-14 04:22:46 | Saitama, Japan | ||
2825038 | 2825038 | 2021-05-01 | Russia | Tyumen Oblast | 35194 | 472 | 33554 | 1168 | 58.8206488 | 70.36588370000001 | 2021-05-02 04:20:48 | Tyumen Oblast, Russia | ||
2571702 | 2571702 | 2021-04-13 | Japan | Miyagi | 7272 | 44 | 6060 | 1168 | 38.446859 | 140.927086 | 2021-04-14 04:20:41 | Miyagi, Japan | ||
3709830 | 3709830 | 2021-04-03 | Angola | 22579 | 540 | 20871 | 1168 | -11.2027 | 17.8739 | 2021-04-04 04:20:49 | Angola | |||
1837776 | 1837776 | 2021-03-12 | Colombia | Cordoba | 39429 | 1879 | 36382 | 1168 | 8.0493 | -75.574 | 2021-03-13 05:25:15 | Cordoba, Colombia | ||
3669725 | 3669725 | 2021-03-06 | US | Nebraska | Red Willow | 31145 | 1180 | 12 | 0 | 1168 | 40.17556879999999 | -100.476998 | 2021-03-07 05:21:54 | Red Willow, Nebraska, US |
1618346 | 1618346 | 2021-03-05 | US | Nebraska | Red Willow | 31145 | 1180 | 12 | 0 | 1168 | 40.17556879999999 | -100.476998 | 2021-03-06 04:23:41 | Red Willow, Nebraska, US |
1618024 | 1618024 | 2021-03-05 | US | Mississippi | Carroll | 28015 | 1193 | 25 | 0 | 1168 | 33.44834567 | -89.91994479 | 2021-03-06 04:23:41 | Carroll, Mississippi, US |
2209423 | 2209423 | 2021-03-04 | US | Minnesota | Watonwan | 27165 | 1176 | 8 | 0 | 1168 | 43.97823903 | -94.61413846 | 2021-03-05 05:26:29 | Watonwan, Minnesota, US |
3254409 | 3254409 | 2021-03-02 | Russia | Yaroslavl Oblast | 33074 | 410 | 31496 | 1168 | 57.77819760000001 | 39.0021095 | 2021-03-03 05:23:28 | Yaroslavl Oblast, Russia | ||
3068102 | 3068102 | 2021-02-27 | US | Nebraska | Red Willow | 31145 | 1179 | 11 | 0 | 1168 | 40.17556879999999 | -100.476998 | 2021-02-28 05:22:20 | Red Willow, Nebraska, US |
2186458 | 2186458 | 2021-02-26 | US | South Dakota | Lake | 46079 | 1185 | 17 | 0 | 1168 | 44.02193107 | -97.12926365 | 2021-02-27 05:22:28 | Lake, South Dakota, US |
1860108 | 1860108 | 2021-02-25 | US | Nebraska | Red Willow | 31145 | 1179 | 11 | 0 | 1168 | 40.17556879999999 | -100.476998 | 2021-02-26 05:22:40 | Red Willow, Nebraska, US |
1858973 | 1858973 | 2021-02-25 | US | Illinois | Cumberland | 17035 | 1186 | 18 | 0 | 1168 | 39.27432424 | -88.2401158 | 2021-02-26 05:22:40 | Cumberland, Illinois, US |
282005 | 282005 | 2021-02-24 | US | Mississippi | Montgomery | 28097 | 1205 | 37 | 0 | 1168 | 33.49419589 | -89.61729103 | 2021-02-25 05:24:57 | Montgomery, Mississippi, US |
281602 | 281602 | 2021-02-24 | US | Kentucky | Lee | 21129 | 1187 | 19 | 0 | 1168 | 37.59645942 | -83.71513901 | 2021-02-25 05:24:57 | Lee, Kentucky, US |
1938280 | 1938280 | 2021-02-23 | US | Mississippi | Perry | 28111 | 1201 | 33 | 0 | 1168 | 31.17161885 | -88.99281835 | 2021-02-24 05:29:16 | Perry, Mississippi, US |
1938273 | 1938273 | 2021-02-23 | US | Mississippi | Montgomery | 28097 | 1205 | 37 | 0 | 1168 | 33.49419589 | -89.61729103 | 2021-02-24 05:29:16 | Montgomery, Mississippi, US |
532122 | 532122 | 2021-02-22 | US | Kentucky | Larue | 21123 | 1180 | 12 | 0 | 1168 | 37.54567114 | -85.70138352 | 2021-02-23 05:23:41 | Larue, Kentucky, US |
184838 | 184838 | 2021-02-21 | US | South Carolina | Calhoun | 45017 | 1203 | 35 | 0 | 1168 | 33.66926881 | -80.77722168 | 2021-02-22 05:24:21 | Calhoun, South Carolina, US |
183456 | 183456 | 2021-02-21 | US | Kentucky | Larue | 21123 | 1180 | 12 | 0 | 1168 | 37.54567114 | -85.70138352 | 2021-02-22 05:24:21 | Larue, Kentucky, US |
183206 | 183206 | 2021-02-21 | US | Iowa | Chickasaw | 19037 | 1181 | 13 | 0 | 1168 | 43.06001295 | -92.31773347 | 2021-02-22 05:24:21 | Chickasaw, Iowa, US |
744910 | 744910 | 2021-02-20 | US | Oklahoma | Woods | 40151 | 1179 | 11 | 0 | 1168 | 36.76705782 | -98.86573064 | 2021-02-21 05:24:33 | Woods, Oklahoma, US |
743730 | 743730 | 2021-02-20 | US | Kentucky | Larue | 21123 | 1179 | 11 | 0 | 1168 | 37.54567114 | -85.70138352 | 2021-02-21 05:24:33 | Larue, Kentucky, US |
3053776 | 3053776 | 2021-02-16 | US | Wyoming | Lincoln | 56023 | 1179 | 11 | 0 | 1168 | 42.26376367 | -110.6563997 | 2021-02-17 05:23:10 | Lincoln, Wyoming, US |
3052578 | 3052578 | 2021-02-16 | US | North Dakota | McLean | 38055 | 1199 | 31 | 0 | 1168 | 47.60766714 | -101.3182418 | 2021-02-17 05:23:10 | McLean, North Dakota, US |
1339334 | 1339334 | 2021-02-15 | US | Indiana | Blackford | 18009 | 1195 | 27 | 0 | 1168 | 40.47388153 | -85.32499702 | 2021-02-16 05:24:38 | Blackford, Indiana, US |
2286795 | 2286795 | 2021-02-14 | US | Virginia | New Kent | 51127 | 1175 | 7 | 0 | 1168 | 37.50694406 | -76.99828634 | 2021-02-15 05:24:49 | New Kent, Virginia, US |
3541659 | 3541659 | 2021-02-12 | US | New Mexico | San Miguel | 35047 | 1177 | 9 | 0 | 1168 | 35.48014807 | -104.8163562 | 2021-02-13 05:22:12 | San Miguel, New Mexico, US |
3539573 | 3539573 | 2021-02-12 | Namibia | 35554 | 384 | 34002 | 1168 | -22.9576 | 18.4904 | 2021-02-13 05:22:12 | Namibia | |||
3982255 | 3982255 | 2021-02-10 | Malaysia | Negeri Sembilan | 12755 | 27 | 11560 | 1168 | 2.7258 | 101.9424 | 2021-02-11 05:23:55 | Negeri Sembilan, Malaysia | ||
616989 | 616989 | 2021-02-08 | US | Virginia | Buchanan | 51027 | 1200 | 32 | 0 | 1168 | 37.26818323 | -82.03749726 | 2021-02-09 05:23:30 | Buchanan, Virginia, US |
615513 | 615513 | 2021-02-08 | US | Mississippi | Noxubee | 28103 | 1195 | 27 | 0 | 1168 | 33.11009499 | -88.56949061 | 2021-02-09 05:23:30 | Noxubee, Mississippi, US |
614699 | 614699 | 2021-02-08 | US | Illinois | Massac | 17127 | 1198 | 30 | 0 | 1168 | 37.22078441 | -88.71036614 | 2021-02-09 05:23:30 | Massac, Illinois, US |
1675756 | 1675756 | 2021-02-07 | US | Virginia | Bristol | 51520 | 1195 | 27 | 0 | 1168 | 36.6163024 | -82.16359122 | 2021-02-08 05:22:39 | Bristol, Virginia, US |
976712 | 976712 | 2021-02-06 | US | Mississippi | Greene | 28041 | 1199 | 31 | 0 | 1168 | 31.21444233 | -88.63922281 | 2021-02-07 05:23:00 | Greene, Mississippi, US |
975472 | 975472 | 2021-02-06 | US | California | Mono | 6051 | 1174 | 3 | 0 | 1168 | 37.93899289 | -118.8872409 | 2021-02-07 05:23:00 | Mono, California, US |
1588926 | 1588926 | 2021-02-05 | US | Georgia | Brooks | 13027 | 1208 | 40 | 0 | 1168 | 30.83922642 | -83.58303423 | 2021-02-06 05:23:55 | Brooks, Georgia, US |
341646 | 341646 | 2021-02-03 | US | Kentucky | Caldwell | 21033 | 1189 | 21 | 0 | 1168 | 37.14749129 | -87.86948214 | 2021-02-04 05:22:26 | Caldwell, Kentucky, US |
1462107 | 1462107 | 2021-01-31 | US | North Carolina | Polk | 37149 | 1187 | 19 | 0 | 1168 | 35.27820615 | -82.16812354 | 2021-02-01 05:22:53 | Polk, North Carolina, US |
1899376 | 1899376 | 2021-01-29 | US | New York | Delaware | 36025 | 1197 | 29 | 0 | 1168 | 42.19837623 | -74.96709306 | 2021-01-30 05:22:49 | Delaware, New York, US |
2483438 | 2483438 | 2021-01-28 | US | Kentucky | Union | 21225 | 1178 | 10 | 0 | 1168 | 37.66166713 | -87.94300009 | 2021-01-29 05:22:23 | Union, Kentucky, US |
13974 | 13974 | 2021-01-26 | US | Michigan | Iosco | 26069 | 1231 | 63 | 0 | 1168 | 44.35486835 | -83.63484895 | 2021-01-27 05:23:41 | Iosco, Michigan, US |
2429393 | 2429393 | 2021-01-23 | US | Ohio | Noble | 39121 | 1205 | 37 | 0 | 1168 | 39.76818851 | -81.45937183 | 2021-01-24 05:22:35 | Noble, Ohio, US |
2467565 | 2467565 | 2021-01-22 | US | Georgia | Charlton | 13049 | 1191 | 23 | 0 | 1168 | 30.78371028 | -82.13951596 | 2021-01-23 05:22:03 | Charlton, Georgia, US |
438739 | 438739 | 2021-01-21 | US | Virginia | Powhatan | 51145 | 1175 | 7 | 0 | 1168 | 37.55016038 | -77.91267882 | 2021-01-22 05:22:10 | Powhatan, Virginia, US |
437926 | 437926 | 2021-01-21 | US | Oklahoma | Noble | 40103 | 1176 | 8 | 0 | 1168 | 36.38953329 | -97.22928674 | 2021-01-22 05:22:10 | Noble, Oklahoma, US |
437211 | 437211 | 2021-01-21 | US | Mississippi | Yalobusha | 28161 | 1202 | 34 | 0 | 1168 | 34.02824175 | -89.70762049999998 | 2021-01-22 05:22:10 | Yalobusha, Mississippi, US |
1096917 | 1096917 | 2021-01-20 | US | South Carolina | Saluda | 45081 | 1199 | 31 | 0 | 1168 | 34.00795823 | -81.72713237 | 2021-01-21 05:22:01 | Saluda, South Carolina, US |
1095481 | 1095481 | 2021-01-20 | US | Kentucky | Garrard | 21079 | 1172 | 4 | 0 | 1168 | 37.6388668 | -84.53289319 | 2021-01-21 05:22:01 | Garrard, Kentucky, US |
1095330 | 1095330 | 2021-01-20 | US | Iowa | Winnebago | 19189 | 1197 | 29 | 0 | 1168 | 43.37751174 | -93.73407298 | 2021-01-21 05:22:01 | Winnebago, Iowa, US |
910093 | 910093 | 2021-01-19 | US | Missouri | Livingston | 29117 | 1193 | 25 | 0 | 1168 | 39.78110272 | -93.54645978 | 2021-01-20 05:21:54 | Livingston, Missouri, US |
909222 | 909222 | 2021-01-19 | US | Illinois | Wabash | 17185 | 1179 | 11 | 0 | 1168 | 38.44272901 | -87.84922065 | 2021-01-20 05:21:54 | Wabash, Illinois, US |
3506204 | 3506204 | 2021-01-17 | US | South Dakota | Charles Mix | 46023 | 1182 | 14 | 0 | 1168 | 43.20660134 | -98.58856175 | 2021-01-18 05:22:34 | Charles Mix, South Dakota, US |
3104787 | 3104787 | 2021-01-16 | US | Virginia | Hopewell | 51670 | 1180 | 12 | 0 | 1168 | 37.29186313 | -77.29754684 | 2021-01-17 05:22:17 | Hopewell, Virginia, US |
3101429 | 3101429 | 2021-01-16 | Italy | Molise | 7483 | 230 | 6085 | 1168 | 41.55774754 | 14.65916051 | 2021-01-17 05:22:17 | Molise, Italy | ||
3517168 | 3517168 | 2021-01-15 | US | Minnesota | Wadena | 27159 | 1182 | 14 | 0 | 1168 | 46.58589171 | -94.96968506 | 2021-01-16 05:22:40 | Wadena, Minnesota, US |
3516600 | 3516600 | 2021-01-15 | US | Iowa | Jefferson | 19101 | 1191 | 23 | 0 | 1168 | 41.03192394 | -91.94849466 | 2021-01-16 05:22:40 | Jefferson, Iowa, US |
3883047 | 3883047 | 2021-01-14 | US | West Virginia | Hampshire | 54027 | 1192 | 24 | 0 | 1168 | 39.32103553 | -78.60826476 | 2021-01-15 05:22:24 | Hampshire, West Virginia, US |
3881340 | 3881340 | 2021-01-14 | US | Minnesota | Wadena | 27159 | 1182 | 14 | 0 | 1168 | 46.58589171 | -94.96968506 | 2021-01-15 05:22:24 | Wadena, Minnesota, US |
3311558 | 3311558 | 2021-01-13 | US | Virginia | Louisa | 51109 | 1179 | 11 | 0 | 1168 | 37.97850256 | -77.96274807 | 2021-01-14 05:22:32 | Louisa, Virginia, US |
3311533 | 3311533 | 2021-01-13 | US | Virginia | Fredericksburg | 51630 | 1180 | 12 | 0 | 1168 | 38.2977863 | -77.4922454 | 2021-01-14 05:22:32 | Fredericksburg, Virginia, US |
3308423 | 3308423 | 2021-01-13 | Russia | Mari El Republic | 9835 | 132 | 8535 | 1168 | 56.5767504 | 47.8817512 | 2021-01-14 05:22:32 | Mari El Republic, Russia | ||
777928 | 777928 | 2021-01-12 | US | Wisconsin | Washburn | 55129 | 1185 | 17 | 0 | 1168 | 45.89838588 | -91.79050449 | 2021-01-13 05:22:15 | Washburn, Wisconsin, US |
777242 | 777242 | 2021-01-12 | US | South Dakota | Todd | 46121 | 1187 | 19 | 0 | 1168 | 43.19338568 | -100.7195503 | 2021-01-13 05:22:15 | Todd, South Dakota, US |
190997 | 190997 | 2021-01-11 | US | Idaho | Gooding | 16047 | 1188 | 20 | 0 | 1168 | 42.96927962 | -114.8108306 | 2021-01-12 05:22:15 | Gooding, Idaho, US |
3903443 | 3903443 | 2021-01-09 | US | West Virginia | Mason | 54053 | 1190 | 22 | 0 | 1168 | 38.77071799 | -82.02524219 | 2021-01-10 05:22:12 | Mason, West Virginia, US |
3903420 | 3903420 | 2021-01-09 | US | West Virginia | Boone | 54005 | 1190 | 22 | 0 | 1168 | 38.01974191 | -81.69888019 | 2021-01-10 05:22:12 | Boone, West Virginia, US |
157551 | 157551 | 2021-01-08 | US | Wisconsin | Rusk | 55107 | 1182 | 14 | 0 | 1168 | 45.47498854 | -91.1333012 | 2021-01-09 05:22:18 | Rusk, Wisconsin, US |
3037255 | 3037255 | 2021-01-05 | US | Tennessee | Lewis | 47101 | 1216 | 20 | 0 | 1168 | 35.52853208 | -87.49022694 | 2021-01-06 05:22:16 | Lewis, Tennessee, US |
3036982 | 3036982 | 2021-01-05 | US | Pennsylvania | Montour | 42093 | 1193 | 25 | 0 | 1168 | 41.03023987 | -76.66345939 | 2021-01-06 05:22:16 | Montour, Pennsylvania, US |
1063631 | 1063631 | 2021-01-04 | US | Mississippi | Clarke | 28023 | 1227 | 59 | 0 | 1168 | 32.04158545 | -88.68896219999998 | 2021-01-05 05:21:49 | Clarke, Mississippi, US |
1063258 | 1063258 | 2021-01-04 | US | Kentucky | Johnson | 21115 | 1184 | 16 | 0 | 1168 | 37.85106355 | -82.8264322 | 2021-01-05 05:21:49 | Johnson, Kentucky, US |
3231600 | 3231600 | 2021-01-03 | US | Iowa | Allamakee | 19005 | 1194 | 26 | 0 | 1168 | 43.28383218 | -91.37860922 | 2021-01-04 05:22:02 | Allamakee, Iowa, US |
2230424 | 2230424 | 2021-01-02 | US | Tennessee | Benton | 47005 | 1225 | 31 | 0 | 1168 | 36.07110411 | -88.06849355 | 2021-01-03 05:22:52 | Benton, Tennessee, US |
2229665 | 2229665 | 2021-01-02 | US | New Hampshire | Grafton | 33009 | 1177 | 9 | 0 | 1168 | 43.93779815 | -71.82057197 | 2021-01-03 05:22:52 | Grafton, New Hampshire, US |
1137416 | 1137416 | 2021-01-01 | US | California | Calaveras | 6009 | 1189 | 21 | 0 | 1168 | 38.20537103 | -120.552913 | 2021-01-02 05:22:33 | Calaveras, California, US |
1013237 | 1013237 | 2020-12-30 | US | Tennessee | Grundy | 47061 | 1210 | 18 | 0 | 1168 | 35.38433717 | -85.72142731 | 2020-12-31 05:22:49 | Grundy, Tennessee, US |
768159 | 768159 | 2020-12-29 | US | Mississippi | Tallahatchie | 28135 | 1199 | 31 | 0 | 1168 | 33.95339918 | -90.1729398 | 2020-12-30 05:22:34 | Tallahatchie, Mississippi, US |
767633 | 767633 | 2020-12-29 | US | Kansas | Neosho | 20133 | 1180 | 12 | 0 | 1168 | 37.55862897 | -95.30670046 | 2020-12-30 05:22:34 | Neosho, Kansas, US |
767061 | 767061 | 2020-12-29 | US | Georgia | Banks | 13011 | 1187 | 19 | 0 | 1168 | 34.35607081 | -83.49644388 | 2020-12-30 05:22:34 | Banks, Georgia, US |
3779153 | 3779153 | 2020-12-27 | US | Kansas | Atchison | 20005 | 1178 | 10 | 0 | 1168 | 39.53185661 | -95.30870026 | 2020-12-28 05:22:06 | Atchison, Kansas, US |
2224758 | 2224758 | 2020-12-26 | US | Kansas | Atchison | 20005 | 1178 | 10 | 0 | 1168 | 39.53185661 | -95.30870026 | 2020-12-27 05:22:55 | Atchison, Kansas, US |
204982 | 204982 | 2020-12-25 | US | Puerto Rico | Dorado | 72051 | 1168 | 0 | 0 | 1168 | 18.436115 | -66.278669 | 2020-12-26 05:22:28 | Dorado, Puerto Rico, US |
203505 | 203505 | 2020-12-25 | US | Kansas | Atchison | 20005 | 1178 | 10 | 0 | 1168 | 39.53185661 | -95.30870026 | 2020-12-26 05:22:28 | Atchison, Kansas, US |
3692728 | 3692728 | 2020-12-24 | US | Kansas | Atchison | 20005 | 1178 | 10 | 0 | 1168 | 39.53185661 | -95.30870026 | 2020-12-25 05:22:48 | Atchison, Kansas, US |
3692643 | 3692643 | 2020-12-24 | US | Iowa | Cherokee | 19035 | 1188 | 20 | 0 | 1168 | 42.73538914 | -95.62389402 | 2020-12-25 05:22:48 | Cherokee, Iowa, US |
2408080 | 2408080 | 2020-12-23 | US | Kansas | Atchison | 20005 | 1178 | 10 | 0 | 1168 | 39.53185661 | -95.30870026 | 2020-12-24 05:23:04 | Atchison, Kansas, US |
2120217 | 2120217 | 2020-12-20 | US | Arkansas | Ouachita | 5103 | 1190 | 22 | 0 | 1168 | 33.58839816 | -92.87795984 | 2020-12-21 05:27:58 | Ouachita, Arkansas, US |
1754748 | 1754748 | 2020-12-14 | US | West Virginia | Logan | 54045 | 1222 | 54 | 0 | 1168 | 37.8299889 | -81.93528571 | 2020-12-15 05:26:38 | Logan, West Virginia, US |
1753390 | 1753390 | 2020-12-14 | US | Nebraska | York | 31185 | 1174 | 6 | 0 | 1168 | 40.87272618 | -97.59710186 | 2020-12-15 05:26:38 | York, Nebraska, US |
861558 | 861558 | 2020-12-11 | US | Georgia | Union | 13291 | 1208 | 40 | 0 | 1168 | 34.82995757 | -83.98967069 | 2020-12-12 05:26:19 | Union, Georgia, US |
2976356 | 2976356 | 2020-12-09 | US | Indiana | Starke | 18149 | 1201 | 33 | 0 | 1168 | 41.27890281 | -86.64686895 | 2020-12-10 05:26:19 | Starke, Indiana, US |
2349350 | 2349350 | 2020-12-07 | US | Missouri | Morgan | 29141 | 1181 | 13 | 0 | 1168 | 38.4181765 | -92.88791859 | 2020-12-08 05:27:42 | Morgan, Missouri, US |
1634765 | 1634765 | 2020-12-05 | US | Ohio | Henry | 39069 | 1209 | 41 | 0 | 1168 | 41.3339642 | -84.06830637 | 2020-12-06 05:26:18 | Henry, Ohio, US |
1633348 | 1633348 | 2020-12-05 | US | Illinois | Warren | 17187 | 1190 | 22 | 0 | 1168 | 40.84925021 | -90.6147432 | 2020-12-06 05:26:18 | Warren, Illinois, US |
3860922 | 3860922 | 2020-12-04 | US | Indiana | Jay | 18075 | 1188 | 20 | 0 | 1168 | 40.43781032 | -85.00576229 | 2020-12-05 05:27:36 | Jay, Indiana, US |
78556 | 78556 | 2020-12-03 | US | West Virginia | Fayette | 54019 | 1203 | 35 | 0 | 1168 | 38.02974928 | -81.08286634 | 2020-12-04 05:27:27 | Fayette, West Virginia, US |
78046 | 78046 | 2020-12-03 | US | Tennessee | Marion | 47115 | 1215 | 19 | 0 | 1168 | 35.12997174 | -85.62265895 | 2020-12-04 05:27:27 | Marion, Tennessee, 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]);