johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
168 rows where active = 1360 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3958574 | 3958574 | 2021-06-26 | Malawi | 35554 | 1181 | 33013 | 1360 | -13.2543 | 34.3015 | 2021-06-27 04:21:39 | Malawi | |||
2295659 | 2295659 | 2021-06-24 | Russia | Karelia Republic | 49027 | 610 | 47057 | 1360 | 62.61940309999999 | 33.4920267 | 2021-06-25 04:21:33 | Karelia Republic, Russia | ||
522769 | 522769 | 2021-06-09 | Germany | Hamburg | 76677 | 1578 | 73800 | 1360 | 53.5511 | 9.9937 | 2021-06-10 04:23:17 | Hamburg, Germany | ||
825802 | 825802 | 2021-06-06 | Russia | Leningrad Oblast | 45787 | 1505 | 42922 | 1360 | 60.1853296 | 32.3925325 | 2021-06-07 04:22:51 | Leningrad Oblast, Russia | ||
20219 | 20219 | 2021-05-28 | Colombia | Huila | 58300 | 2026 | 54914 | 1360 | 2.5359 | -75.5277 | 2021-05-29 04:20:41 | Huila, Colombia | ||
1409074 | 1409074 | 2021-04-23 | Japan | Okinawa | 11923 | 133 | 10430 | 1360 | 25.768923 | 126.668016 | 2021-04-24 04:20:38 | Okinawa, Japan | ||
3245995 | 3245995 | 2021-04-21 | Zimbabwe | 37980 | 1555 | 35065 | 1360 | -19.015438 | 29.154857 | 2021-04-22 04:20:53 | Zimbabwe | |||
3242585 | 3242585 | 2021-04-21 | Russia | Volgograd Oblast | 55939 | 1055 | 53524 | 1360 | 49.6048339 | 44.29035820000001 | 2021-04-22 04:20:53 | Volgograd Oblast, Russia | ||
983207 | 983207 | 2021-04-17 | Russia | Volgograd Oblast | 55510 | 1035 | 53115 | 1360 | 49.6048339 | 44.29035820000001 | 2021-04-18 04:20:41 | Volgograd Oblast, Russia | ||
1841690 | 1841690 | 2021-04-14 | Brazil | Piaui | 223251 | 4659 | 215624 | 1360 | -7.7183 | -42.7289 | 2021-04-15 04:20:54 | Piaui, Brazil | ||
2645753 | 2645753 | 2021-04-08 | Japan | Aichi | 28344 | 597 | 26387 | 1360 | 35.035551 | 137.211621 | 2021-04-09 04:21:13 | Aichi, Japan | ||
3710355 | 3710355 | 2021-04-03 | Russia | Kurgan Oblast | 19341 | 354 | 17627 | 1360 | 55.7655302 | 64.5632681 | 2021-04-04 04:20:49 | Kurgan Oblast, Russia | ||
3669916 | 3669916 | 2021-03-06 | US | North Carolina | Chowan | 37041 | 1382 | 22 | 0 | 1360 | 36.12908077 | -76.60118385 | 2021-03-07 05:21:54 | Chowan, North Carolina, US |
3667974 | 3667974 | 2021-03-06 | US | Alabama | Cleburne | 1029 | 1401 | 41 | 0 | 1360 | 33.67679204 | -85.52005899 | 2021-03-07 05:21:54 | Cleburne, Alabama, US |
3667803 | 3667803 | 2021-03-06 | Russia | Adygea Republic | 13855 | 154 | 12341 | 1360 | 44.6939006 | 40.1520421 | 2021-03-07 05:21:54 | Adygea Republic, Russia | ||
1618537 | 1618537 | 2021-03-05 | US | North Carolina | Chowan | 37041 | 1382 | 22 | 0 | 1360 | 36.12908077 | -76.60118385 | 2021-03-06 04:23:41 | Chowan, North Carolina, US |
999187 | 999187 | 2021-03-01 | US | Georgia | Bleckley | 13023 | 1409 | 49 | 0 | 1360 | 32.43829035 | -83.33035166 | 2021-03-02 05:23:30 | Bleckley, Georgia, US |
2368245 | 2368245 | 2021-02-28 | US | Georgia | Bleckley | 13023 | 1409 | 49 | 0 | 1360 | 32.43829035 | -83.33035166 | 2021-03-01 05:23:01 | Bleckley, Georgia, US |
2185291 | 2185291 | 2021-02-26 | US | Minnesota | Fillmore | 27045 | 1368 | 8 | 0 | 1360 | 43.67394126 | -92.08980382 | 2021-02-27 05:22:28 | Fillmore, Minnesota, US |
2184778 | 2184778 | 2021-02-26 | US | Iowa | Iowa | 19095 | 1383 | 23 | 0 | 1360 | 41.68630265 | -92.0643373 | 2021-02-27 05:22:28 | Iowa, Iowa, US |
283573 | 283573 | 2021-02-24 | US | Virginia | Richmond | 51159 | 1367 | 7 | 0 | 1360 | 37.937575 | -76.72920628 | 2021-02-25 05:24:57 | Richmond, Virginia, US |
282947 | 282947 | 2021-02-24 | US | Puerto Rico | Rio Grande | 72119 | 1360 | 0 | 0 | 1360 | 18.346329 | -65.813742 | 2021-02-25 05:24:57 | Rio Grande, Puerto Rico, US |
1939215 | 1939215 | 2021-02-23 | US | Puerto Rico | Rio Grande | 72119 | 1360 | 0 | 0 | 1360 | 18.346329 | -65.813742 | 2021-02-24 05:29:16 | Rio Grande, Puerto Rico, US |
743429 | 743429 | 2021-02-20 | US | Indiana | Parke | 18121 | 1375 | 15 | 0 | 1360 | 39.77202286 | -87.20375833 | 2021-02-21 05:24:33 | Parke, Indiana, US |
474802 | 474802 | 2021-02-19 | US | Virginia | Richmond | 51159 | 1367 | 7 | 0 | 1360 | 37.937575 | -76.72920628 | 2021-02-20 05:22:51 | Richmond, Virginia, US |
1155915 | 1155915 | 2021-02-18 | US | South Carolina | Bamberg | 45009 | 1408 | 48 | 0 | 1360 | 33.21927586 | -81.05659969 | 2021-02-19 05:24:16 | Bamberg, South Carolina, US |
1154515 | 1154515 | 2021-02-18 | US | Kentucky | Garrard | 21079 | 1368 | 8 | 0 | 1360 | 37.6388668 | -84.53289319 | 2021-02-19 05:24:16 | Garrard, Kentucky, US |
3604333 | 3604333 | 2021-02-17 | US | Virginia | Appomattox | 51011 | 1369 | 9 | 0 | 1360 | 37.37569884 | -78.81340003 | 2021-02-18 05:22:58 | Appomattox, Virginia, US |
3603263 | 3603263 | 2021-02-17 | US | New York | Delaware | 36025 | 1392 | 32 | 0 | 1360 | 42.19837623 | -74.96709306 | 2021-02-18 05:22:58 | Delaware, New York, US |
3052329 | 3052329 | 2021-02-16 | US | New Hampshire | Unassigned | 90033 | 1365 | 5 | 0 | 1360 | 44.69063265 | 0.0 | 2021-02-17 05:23:10 | Unassigned, New Hampshire, US |
2284929 | 2284929 | 2021-02-14 | US | Louisiana | LaSalle | 22059 | 1393 | 33 | 0 | 1360 | 31.67884782 | -92.15907765 | 2021-02-15 05:24:49 | LaSalle, Louisiana, US |
3981483 | 3981483 | 2021-02-10 | US | Tennessee | Benton | 47005 | 1472 | 37 | 0 | 1360 | 36.07110411 | -88.06849355 | 2021-02-11 05:23:55 | Benton, Tennessee, US |
3980762 | 3980762 | 2021-02-10 | US | New Mexico | Grant | 35017 | 1391 | 31 | 0 | 1360 | 32.73911281 | -108.3827845 | 2021-02-11 05:23:55 | Grant, New Mexico, US |
1673420 | 1673420 | 2021-02-07 | US | Illinois | Clay | 17025 | 1399 | 39 | 0 | 1360 | 38.75388572 | -88.48914513 | 2021-02-08 05:22:39 | Clay, Illinois, US |
1672255 | 1672255 | 2021-02-07 | Chile | Valparaiso | 44748 | 1446 | 41942 | 1360 | -33.0472 | -71.6127 | 2021-02-08 05:22:39 | Valparaiso, Chile | ||
792316 | 792316 | 2021-02-04 | US | Missouri | Osage | 29151 | 1372 | 12 | 0 | 1360 | 38.46036182 | -91.8613635 | 2021-02-05 05:22:38 | Osage, Missouri, US |
2215140 | 2215140 | 2021-01-30 | US | West Virginia | Hampshire | 54027 | 1388 | 28 | 0 | 1360 | 39.32103553 | -78.60826476 | 2021-01-31 05:22:42 | Hampshire, West Virginia, US |
2213417 | 2213417 | 2021-01-30 | US | Minnesota | Renville | 27129 | 1400 | 40 | 0 | 1360 | 44.72836381 | -94.94553734 | 2021-01-31 05:22:42 | Renville, Minnesota, US |
2570610 | 2570610 | 2021-01-25 | US | Tennessee | Humphreys | 47085 | 1428 | 17 | 0 | 1360 | 36.03958805 | -87.77992872 | 2021-01-26 05:22:02 | Humphreys, Tennessee, US |
1761296 | 1761296 | 2021-01-24 | US | Montana | Lincoln | 30053 | 1369 | 9 | 0 | 1360 | 48.54265777 | -115.4046155 | 2021-01-25 05:22:16 | Lincoln, Montana, US |
2467854 | 2467854 | 2021-01-22 | US | Illinois | White | 17193 | 1382 | 22 | 0 | 1360 | 38.08706198 | -88.17657461 | 2021-01-23 05:22:03 | White, Illinois, US |
2466766 | 2466766 | 2021-01-22 | India | Odisha | 334020 | 1903 | 330757 | 1360 | 20.505428 | 84.418059 | 2021-01-23 05:22:03 | Odisha, India | ||
909358 | 909358 | 2021-01-19 | US | Iowa | Floyd | 19067 | 1396 | 36 | 0 | 1360 | 43.06000529999999 | -92.78940097 | 2021-01-20 05:21:54 | Floyd, Iowa, US |
3103932 | 3103932 | 2021-01-16 | US | Ohio | Paulding | 39125 | 1390 | 30 | 0 | 1360 | 41.11676341 | -84.5801017 | 2021-01-17 05:22:17 | Paulding, Ohio, US |
3517671 | 3517671 | 2021-01-15 | US | New York | Washington | 36115 | 1381 | 21 | 0 | 1360 | 43.31153794 | -73.43043448 | 2021-01-16 05:22:40 | Washington, New York, US |
3882649 | 3882649 | 2021-01-14 | US | Texas | Fayette | 48149 | 1470 | 43 | 0 | 1360 | 29.87788372 | -96.92076062 | 2021-01-15 05:22:24 | Fayette, Texas, US |
3311235 | 3311235 | 2021-01-13 | US | Texas | Cass | 48067 | 1392 | 56 | 0 | 1360 | 33.07499881 | -94.34646905 | 2021-01-14 05:22:32 | Cass, Texas, US |
3308430 | 3308430 | 2021-01-13 | Russia | North Ossetia - Alania Republic | 13095 | 104 | 11631 | 1360 | 42.79336110000001 | 44.6324493 | 2021-01-14 05:22:32 | North Ossetia - Alania Republic, Russia | ||
3900171 | 3900171 | 2021-01-09 | Russia | Komi Republic | 32500 | 609 | 30531 | 1360 | 63.9881421 | 54.3326073 | 2021-01-10 05:22:12 | Komi Republic, Russia | ||
2864565 | 2864565 | 2021-01-06 | Colombia | Huila | 36178 | 1154 | 33664 | 1360 | 2.5359 | -75.5277 | 2021-01-07 05:22:03 | Huila, Colombia | ||
1063811 | 1063811 | 2021-01-04 | US | Missouri | Texas | 29215 | 1378 | 18 | 0 | 1360 | 37.31728859 | -91.96564727 | 2021-01-05 05:21:49 | Texas, Missouri, US |
3232414 | 3232414 | 2021-01-03 | US | Missouri | Texas | 29215 | 1378 | 18 | 0 | 1360 | 37.31728859 | -91.96564727 | 2021-01-04 05:22:02 | Texas, Missouri, US |
3232014 | 3232014 | 2021-01-03 | US | Maryland | Caroline | 24011 | 1370 | 10 | 0 | 1360 | 38.87172293 | -75.82904158 | 2021-01-04 05:22:02 | Caroline, Maryland, US |
2229837 | 2229837 | 2021-01-02 | US | North Carolina | Hertford | 37091 | 1410 | 50 | 0 | 1360 | 36.3607755 | -76.98104134 | 2021-01-03 05:22:52 | Hertford, North Carolina, US |
2229232 | 2229232 | 2021-01-02 | US | Minnesota | Hubbard | 27057 | 1397 | 37 | 0 | 1360 | 47.10778564 | -94.91693868 | 2021-01-03 05:22:52 | Hubbard, Minnesota, US |
2228739 | 2228739 | 2021-01-02 | US | Iowa | Page | 19145 | 1374 | 14 | 0 | 1360 | 40.7393172 | -95.1497813 | 2021-01-03 05:22:52 | Page, Iowa, US |
2228356 | 2228356 | 2021-01-02 | US | Georgia | Mitchell | 13205 | 1412 | 52 | 0 | 1360 | 31.22483255 | -84.19381821 | 2021-01-03 05:22:52 | Mitchell, Georgia, US |
1139111 | 1139111 | 2021-01-01 | US | New York | Greene | 36039 | 1383 | 23 | 0 | 1360 | 42.275797 | -74.12384884 | 2021-01-02 05:22:33 | Greene, New York, US |
1138451 | 1138451 | 2021-01-01 | US | Maryland | Dorchester | 24019 | 1382 | 22 | 0 | 1360 | 38.45413522 | -76.02752426 | 2021-01-02 05:22:33 | Dorchester, Maryland, US |
1138103 | 1138103 | 2021-01-01 | US | Iowa | Page | 19145 | 1373 | 13 | 0 | 1360 | 40.7393172 | -95.1497813 | 2021-01-02 05:22:33 | Page, Iowa, US |
769790 | 769790 | 2020-12-29 | US | West Virginia | Greenbrier | 54025 | 1391 | 31 | 0 | 1360 | 37.9463652 | -80.45335881 | 2020-12-30 05:22:34 | Greenbrier, West Virginia, US |
768595 | 768595 | 2020-12-29 | US | North Carolina | Anson | 37007 | 1383 | 23 | 0 | 1360 | 34.97403241 | -80.09953279 | 2020-12-30 05:22:34 | Anson, North Carolina, US |
767509 | 767509 | 2020-12-29 | US | Iowa | Harrison | 19085 | 1412 | 52 | 0 | 1360 | 41.68330137 | -95.81558439 | 2020-12-30 05:22:34 | Harrison, Iowa, US |
767127 | 767127 | 2020-12-29 | US | Georgia | Harris | 13145 | 1389 | 29 | 0 | 1360 | 32.73709786 | -84.90538572 | 2020-12-30 05:22:34 | Harris, Georgia, US |
766780 | 766780 | 2020-12-29 | US | Arkansas | Chicot | 5017 | 1389 | 29 | 0 | 1360 | 33.26458973 | -91.29539209 | 2020-12-30 05:22:34 | Chicot, Arkansas, US |
3781289 | 3781289 | 2020-12-27 | US | Virginia | Pulaski | 51155 | 1391 | 31 | 0 | 1360 | 37.06474963 | -80.71229738 | 2020-12-28 05:22:06 | Pulaski, Virginia, US |
3778727 | 3778727 | 2020-12-27 | US | Georgia | Lee | 13177 | 1393 | 33 | 0 | 1360 | 31.779330600000005 | -84.14324253 | 2020-12-28 05:22:06 | Lee, Georgia, US |
3693437 | 3693437 | 2020-12-24 | US | Missouri | Ste. Genevieve | 29186 | 1363 | 3 | 0 | 1360 | 37.89090059 | -90.1949941 | 2020-12-25 05:22:48 | Ste. Genevieve, Missouri, US |
928036 | 928036 | 2020-12-21 | US | Alabama | Butler | 1013 | 1405 | 45 | 0 | 1360 | 31.75300095 | -86.68057478 | 2020-12-22 05:22:33 | Butler, Alabama, US |
1901415 | 1901415 | 2020-12-18 | Russia | Tatarstan Republic | 11975 | 170 | 10445 | 1360 | 55.7648572 | 52.43104273 | 2020-12-19 05:27:52 | Tatarstan Republic, Russia | ||
3153065 | 3153065 | 2020-12-16 | US | West Virginia | Hancock | 54029 | 1378 | 18 | 0 | 1360 | 40.51943859 | -80.57461608 | 2020-12-17 05:28:12 | Hancock, West Virginia, US |
1035575 | 1035575 | 2020-12-15 | US | Iowa | Kossuth | 19109 | 1383 | 23 | 0 | 1360 | 43.20405458 | -94.20691791 | 2020-12-16 05:28:04 | Kossuth, Iowa, US |
1754198 | 1754198 | 2020-12-14 | US | Tennessee | Grainger | 47057 | 1397 | 21 | 0 | 1360 | 36.27469206 | -83.51254721 | 2020-12-15 05:26:38 | Grainger, Tennessee, US |
1753191 | 1753191 | 2020-12-14 | US | Missouri | Moniteau | 29135 | 1375 | 15 | 0 | 1360 | 38.63571781 | -92.57976951 | 2020-12-15 05:26:38 | Moniteau, Missouri, US |
846700 | 846700 | 2020-12-12 | US | Indiana | Sullivan | 18153 | 1383 | 23 | 0 | 1360 | 39.08952258 | -87.41414469 | 2020-12-13 05:27:20 | Sullivan, Indiana, US |
863088 | 863088 | 2020-12-11 | US | North Dakota | Richland | 38077 | 1401 | 13 | 0 | 1360 | 46.26440649 | -96.94852979 | 2020-12-12 05:26:19 | Richland, North Dakota, US |
1601947 | 1601947 | 2020-12-10 | US | Minnesota | Martin | 27091 | 1383 | 23 | 0 | 1360 | 43.67429718 | -94.55099908 | 2020-12-11 05:26:59 | Martin, Minnesota, US |
2978643 | 2978643 | 2020-12-09 | US | Virginia | Wise | 51195 | 1410 | 50 | 0 | 1360 | 36.9746148 | -82.62410519 | 2020-12-10 05:26:19 | Wise, Virginia, US |
2977275 | 2977275 | 2020-12-09 | US | Nebraska | Colfax | 31037 | 1374 | 14 | 0 | 1360 | 41.57486951 | -97.0868542 | 2020-12-10 05:26:19 | Colfax, Nebraska, US |
1819275 | 1819275 | 2020-12-08 | US | Arkansas | Johnson | 5071 | 1373 | 13 | 0 | 1360 | 35.56759135 | -93.46036368 | 2020-12-09 05:28:01 | Johnson, Arkansas, US |
2348252 | 2348252 | 2020-12-07 | US | Georgia | Lumpkin | 13187 | 1380 | 20 | 0 | 1360 | 34.57286511 | -84.00425681 | 2020-12-08 05:27:42 | Lumpkin, Georgia, US |
1007783 | 1007783 | 2020-12-06 | US | Louisiana | De Soto | 22031 | 1401 | 41 | 0 | 1360 | 32.05457447 | -93.74130302 | 2020-12-07 05:26:14 | De Soto, Louisiana, US |
740228 | 740228 | 2020-12-02 | US | Missouri | New Madrid | 29143 | 1384 | 24 | 0 | 1360 | 36.59666326 | -89.66070007 | 2020-12-03 05:28:22 | New Madrid, Missouri, US |
739837 | 739837 | 2020-12-02 | US | Louisiana | West Baton Rouge | 22121 | 1403 | 43 | 0 | 1360 | 30.46058217 | -91.30989571 | 2020-12-03 05:28:22 | West Baton Rouge, Louisiana, US |
394708 | 394708 | 2020-11-27 | US | Ohio | Logan | 39091 | 1390 | 30 | 0 | 1360 | 40.38996525 | -83.76784341 | 2020-11-28 05:25:50 | Logan, Ohio, US |
926611 | 926611 | 2020-11-26 | US | Tennessee | Giles | 47055 | 1423 | 49 | 0 | 1360 | 35.20222469 | -87.03992678 | 2020-11-27 05:26:53 | Giles, Tennessee, US |
924921 | 924921 | 2020-11-26 | US | Iowa | Washington | 19183 | 1374 | 14 | 0 | 1360 | 41.33577126 | -91.71725711 | 2020-11-27 05:26:53 | Washington, Iowa, US |
1975238 | 1975238 | 2020-11-25 | US | Pennsylvania | Columbia | 42037 | 1408 | 48 | 0 | 1360 | 41.04821986 | -76.40565017 | 2020-11-26 05:27:44 | Columbia, Pennsylvania, US |
681636 | 681636 | 2020-11-23 | US | Virginia | Fauquier | 51061 | 1387 | 27 | 0 | 1360 | 38.73564842 | -77.80647472 | 2020-11-24 05:27:31 | Fauquier, Virginia, US |
680221 | 680221 | 2020-11-23 | US | Missouri | Lafayette | 29107 | 1389 | 29 | 0 | 1360 | 39.06986886 | -93.78076396 | 2020-11-24 05:27:31 | Lafayette, Missouri, US |
3839573 | 3839573 | 2020-11-21 | US | Texas | Grimes | 48185 | 1278 | 38 | 0 | 1360 | 30.54579585 | -95.98902499 | 2020-11-22 05:25:45 | Grimes, Texas, US |
3838586 | 3838586 | 2020-11-21 | US | Nebraska | Saline | 31151 | 1363 | 3 | 0 | 1360 | 40.52418865 | -97.14085859 | 2020-11-22 05:25:45 | Saline, Nebraska, US |
2702298 | 2702298 | 2020-11-20 | US | Georgia | Emanuel | 13107 | 1407 | 47 | 0 | 1360 | 32.59221302 | -82.30239915 | 2020-11-21 05:25:51 | Emanuel, Georgia, US |
823843 | 823843 | 2020-11-19 | US | North Carolina | Alexander | 37003 | 1373 | 13 | 0 | 1360 | 35.922379600000006 | -81.17751948 | 2020-11-20 05:26:28 | Alexander, North Carolina, US |
822452 | 822452 | 2020-11-19 | US | Georgia | Upson | 13293 | 1437 | 77 | 0 | 1360 | 32.87920671 | -84.30024826 | 2020-11-20 05:26:28 | Upson, Georgia, US |
123567 | 123567 | 2020-11-18 | US | Georgia | Stephens | 13257 | 1407 | 47 | 0 | 1360 | 34.55151201 | -83.29405315 | 2020-11-19 05:25:23 | Stephens, Georgia, US |
2788552 | 2788552 | 2020-11-13 | US | Wisconsin | Langlade | 55067 | 1384 | 24 | 0 | 1360 | 45.26271619 | -89.07483625 | 2020-11-14 05:25:37 | Langlade, Wisconsin, US |
3443618 | 3443618 | 2020-11-11 | US | South Carolina | Dillon | 45033 | 1408 | 48 | 0 | 1360 | 34.39007791 | -79.37741872 | 2020-11-12 05:25:55 | Dillon, South Carolina, US |
3443314 | 3443314 | 2020-11-11 | US | Ohio | Scioto | 39145 | 1378 | 18 | 0 | 1360 | 38.80270163 | -82.98907345 | 2020-11-12 05:25:55 | Scioto, Ohio, US |
274787 | 274787 | 2020-11-10 | US | Pennsylvania | Adams | 42001 | 1394 | 34 | 0 | 1360 | 39.87140411 | -77.21610347 | 2020-11-11 05:25:30 | Adams, Pennsylvania, 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]);