johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
342 rows where active = 786 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408438 | 408438 | 2021-07-28 | Pakistan | Gilgit-Baltistan | 7935 | 133 | 7016 | 786 | 35.792146 | 74.982138 | 2021-07-29 04:21:33 | Gilgit-Baltistan, Pakistan | ||
3631897 | 3631897 | 2021-07-14 | India | Bihar | 723570 | 9621 | 713163 | 786 | 25.679658 | 85.60484 | 2021-07-15 04:21:48 | Bihar, India | ||
829512 | 829512 | 2021-07-09 | Germany | Niedersachsen | 261494 | 5794 | 255000 | 786 | 52.6367 | 9.8451 | 2021-07-10 04:21:25 | Niedersachsen, Germany | ||
1932669 | 1932669 | 2021-07-05 | Russia | Novgorod Oblast | 32625 | 187 | 31652 | 786 | 58.2843833 | 32.5169757 | 2021-07-06 04:21:32 | Novgorod Oblast, Russia | ||
2071832 | 2071832 | 2021-07-02 | Germany | Niedersachsen | 261107 | 5769 | 254600 | 786 | 52.6367 | 9.8451 | 2021-07-03 04:21:37 | Niedersachsen, Germany | ||
1125450 | 1125450 | 2021-06-18 | Colombia | Quindio | 46884 | 1402 | 44696 | 786 | 4.461 | -75.6674 | 2021-06-19 04:22:33 | Quindio, Colombia | ||
2339595 | 2339595 | 2021-06-15 | Russia | Ivanovo Oblast | 37154 | 1247 | 35121 | 786 | 56.9167446 | 41.43521370000001 | 2021-06-16 04:22:32 | Ivanovo Oblast, Russia | ||
3145827 | 3145827 | 2021-06-07 | Russia | Smolensk Oblast | 31598 | 1045 | 29767 | 786 | 55.03434960000001 | 33.0192065 | 2021-06-08 04:22:35 | Smolensk Oblast, Russia | ||
2586183 | 2586183 | 2021-06-05 | Russia | Chuvashia Republic | 26013 | 1443 | 23784 | 786 | 55.4259922 | 47.0849429 | 2021-06-06 04:24:03 | Chuvashia Republic, Russia | ||
1448652 | 1448652 | 2021-06-03 | Luxembourg | 70088 | 818 | 68484 | 786 | 49.8153 | 6.1296 | 2021-06-04 04:23:37 | Luxembourg | |||
1708573 | 1708573 | 2021-06-02 | Russia | Yamalo-Nenets Autonomous Okrug | 39144 | 419 | 37939 | 786 | 67.1471631 | 74.3415488 | 2021-06-03 04:23:32 | Yamalo-Nenets Autonomous Okrug, Russia | ||
83356 | 83356 | 2021-05-25 | Russia | Yamalo-Nenets Autonomous Okrug | 38982 | 417 | 37779 | 786 | 67.1471631 | 74.3415488 | 2021-05-26 04:20:35 | Yamalo-Nenets Autonomous Okrug, Russia | ||
1413318 | 1413318 | 2021-05-24 | Russia | Yamalo-Nenets Autonomous Okrug | 38963 | 417 | 37760 | 786 | 67.1471631 | 74.3415488 | 2021-05-25 04:21:08 | Yamalo-Nenets Autonomous Okrug, Russia | ||
1913062 | 1913062 | 2021-05-20 | Colombia | La Guajira | 34287 | 1092 | 32409 | 786 | 11.3548 | -72.5205 | 2021-05-21 04:20:43 | La Guajira, Colombia | ||
3057867 | 3057867 | 2021-05-13 | Malaysia | Melaka | 8340 | 27 | 7527 | 786 | 2.1896 | 102.2501 | 2021-05-14 04:20:41 | Melaka, Malaysia | ||
3954686 | 3954686 | 2021-05-11 | Russia | Chuvashia Republic | 24779 | 1390 | 22603 | 786 | 55.4259922 | 47.0849429 | 2021-05-12 04:21:29 | Chuvashia Republic, Russia | ||
1555639 | 1555639 | 2021-05-08 | Zimbabwe | 38414 | 1576 | 36052 | 786 | -19.015438 | 29.154857 | 2021-05-09 04:20:35 | Zimbabwe | |||
2505697 | 2505697 | 2021-05-07 | Zimbabwe | 38403 | 1576 | 36041 | 786 | -19.015438 | 29.154857 | 2021-05-08 04:21:04 | Zimbabwe | |||
646146 | 646146 | 2021-05-05 | Russia | Chuvashia Republic | 24470 | 1381 | 22303 | 786 | 55.4259922 | 47.0849429 | 2021-05-06 04:20:38 | Chuvashia Republic, Russia | ||
1409237 | 1409237 | 2021-04-23 | Russia | Chuvashia Republic | 23829 | 1338 | 21705 | 786 | 55.4259922 | 47.0849429 | 2021-04-24 04:20:38 | Chuvashia Republic, Russia | ||
2411030 | 2411030 | 2021-04-19 | Russia | Astrakhan Oblast | 32087 | 710 | 30591 | 786 | 47.1878186 | 47.608851 | 2021-04-20 04:20:41 | Astrakhan Oblast, Russia | ||
388417 | 388417 | 2021-04-04 | Russia | Chuvashia Republic | 22968 | 1243 | 20939 | 786 | 55.4259922 | 47.0849429 | 2021-04-05 04:20:35 | Chuvashia Republic, Russia | ||
1219762 | 1219762 | 2021-03-27 | Russia | Chuvashia Republic | 22618 | 1191 | 20641 | 786 | 55.4259922 | 47.0849429 | 2021-03-28 05:28:10 | Chuvashia Republic, Russia | ||
3452650 | 3452650 | 2021-03-18 | Chile | Nuble | 19089 | 377 | 17926 | 786 | -36.7226 | -71.7622 | 2021-03-19 05:26:09 | Nuble, Chile | ||
3624740 | 3624740 | 2021-03-17 | Uzbekistan | 80858 | 622 | 79450 | 786 | 41.377491 | 64.585262 | 2021-03-18 05:26:22 | Uzbekistan | |||
1838125 | 1838125 | 2021-03-12 | Russia | Chuvashia Republic | 21967 | 1099 | 20082 | 786 | 55.4259922 | 47.0849429 | 2021-03-13 05:25:15 | Chuvashia Republic, Russia | ||
3671177 | 3671177 | 2021-03-06 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-03-07 05:21:54 | Menominee, Wisconsin, US |
3668816 | 3668816 | 2021-03-06 | US | Iowa | Ida | 19093 | 818 | 32 | 0 | 786 | 42.38696136 | -95.51355387 | 2021-03-07 05:21:54 | Ida, Iowa, US |
3668770 | 3668770 | 2021-03-06 | US | Iowa | Adair | 19001 | 816 | 30 | 0 | 786 | 41.33075609 | -94.47105874 | 2021-03-07 05:21:54 | Adair, Iowa, US |
1619798 | 1619798 | 2021-03-05 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-03-06 04:23:41 | Menominee, Wisconsin, US |
1617391 | 1617391 | 2021-03-05 | US | Iowa | Adair | 19001 | 815 | 29 | 0 | 786 | 41.33075609 | -94.47105874 | 2021-03-06 04:23:41 | Adair, Iowa, US |
2211209 | 2211209 | 2021-03-04 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-03-05 05:26:29 | Menominee, Wisconsin, US |
2209311 | 2209311 | 2021-03-04 | US | Michigan | Missaukee | 26113 | 803 | 17 | 0 | 786 | 44.33772443 | -85.09256478 | 2021-03-05 05:26:29 | Missaukee, Michigan, US |
1093630 | 1093630 | 2021-03-03 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-03-04 05:24:24 | Menominee, Wisconsin, US |
3257702 | 3257702 | 2021-03-02 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-03-03 05:23:28 | Menominee, Wisconsin, US |
3257643 | 3257643 | 2021-03-02 | US | West Virginia | Pleasants | 54073 | 803 | 17 | 0 | 786 | 39.37091679 | -81.16771771 | 2021-03-03 05:23:28 | Pleasants, West Virginia, US |
1001994 | 1001994 | 2021-03-01 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-03-02 05:23:30 | Menominee, Wisconsin, US |
999859 | 999859 | 2021-03-01 | US | Kentucky | Leslie | 21131 | 788 | 2 | 0 | 786 | 37.09246661 | -83.37999606 | 2021-03-02 05:23:30 | Leslie, Kentucky, US |
2371052 | 2371052 | 2021-02-28 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-03-01 05:23:01 | Menominee, Wisconsin, US |
2368917 | 2368917 | 2021-02-28 | US | Kentucky | Leslie | 21131 | 788 | 2 | 0 | 786 | 37.09246661 | -83.37999606 | 2021-03-01 05:23:01 | Leslie, Kentucky, US |
3069554 | 3069554 | 2021-02-27 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-02-28 05:22:20 | Menominee, Wisconsin, US |
3067104 | 3067104 | 2021-02-27 | US | Indiana | Martin | 18101 | 800 | 14 | 0 | 786 | 38.7099921 | -86.80373186 | 2021-02-28 05:22:20 | Martin, Indiana, US |
2187138 | 2187138 | 2021-02-26 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-02-27 05:22:28 | Menominee, Wisconsin, US |
1861560 | 1861560 | 2021-02-25 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-02-26 05:22:40 | Menominee, Wisconsin, US |
1859110 | 1859110 | 2021-02-25 | US | Indiana | Martin | 18101 | 800 | 14 | 0 | 786 | 38.7099921 | -86.80373186 | 2021-02-26 05:22:40 | Martin, Indiana, US |
283738 | 283738 | 2021-02-24 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-02-25 05:24:57 | Menominee, Wisconsin, US |
282740 | 282740 | 2021-02-24 | US | Oklahoma | Latimer | 40077 | 794 | 8 | 0 | 786 | 34.87844729 | -95.25215049 | 2021-02-25 05:24:57 | Latimer, Oklahoma, US |
281288 | 281288 | 2021-02-24 | US | Indiana | Martin | 18101 | 800 | 14 | 0 | 786 | 38.7099921 | -86.80373186 | 2021-02-25 05:24:57 | Martin, Indiana, US |
1938493 | 1938493 | 2021-02-23 | US | Nebraska | Butler | 31023 | 797 | 11 | 0 | 786 | 41.22703692 | -97.13106306 | 2021-02-24 05:29:16 | Butler, Nebraska, US |
1937700 | 1937700 | 2021-02-23 | US | Kansas | Anderson | 20003 | 804 | 18 | 0 | 786 | 38.21413251 | -95.29272815 | 2021-02-24 05:29:16 | Anderson, Kansas, US |
534261 | 534261 | 2021-02-22 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-02-23 05:23:41 | Menominee, Wisconsin, US |
532748 | 532748 | 2021-02-22 | US | Nebraska | Butler | 31023 | 797 | 11 | 0 | 786 | 41.22703692 | -97.13106306 | 2021-02-23 05:23:41 | Butler, Nebraska, US |
532106 | 532106 | 2021-02-22 | US | Kentucky | Hancock | 21091 | 800 | 14 | 0 | 786 | 37.83766422 | -86.78280584 | 2021-02-23 05:23:41 | Hancock, Kentucky, US |
531955 | 531955 | 2021-02-22 | US | Kansas | Anderson | 20003 | 804 | 18 | 0 | 786 | 38.21413251 | -95.29272815 | 2021-02-23 05:23:41 | Anderson, Kansas, US |
185595 | 185595 | 2021-02-21 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-02-22 05:24:21 | Menominee, Wisconsin, US |
183440 | 183440 | 2021-02-21 | US | Kentucky | Hancock | 21091 | 800 | 14 | 0 | 786 | 37.83766422 | -86.78280584 | 2021-02-22 05:24:21 | Hancock, Kentucky, US |
183289 | 183289 | 2021-02-21 | US | Kansas | Anderson | 20003 | 803 | 17 | 0 | 786 | 38.21413251 | -95.29272815 | 2021-02-22 05:24:21 | Anderson, Kansas, US |
745869 | 745869 | 2021-02-20 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-02-21 05:24:33 | Menominee, Wisconsin, US |
745453 | 745453 | 2021-02-20 | US | Texas | La Salle | 48283 | 975 | 21 | 0 | 786 | 28.34453111 | -99.09908775 | 2021-02-21 05:24:33 | La Salle, Texas, US |
743714 | 743714 | 2021-02-20 | US | Kentucky | Hancock | 21091 | 800 | 14 | 0 | 786 | 37.83766422 | -86.78280584 | 2021-02-21 05:24:33 | Hancock, Kentucky, US |
743563 | 743563 | 2021-02-20 | US | Kansas | Anderson | 20003 | 803 | 17 | 0 | 786 | 38.21413251 | -95.29272815 | 2021-02-21 05:24:33 | Anderson, Kansas, US |
474967 | 474967 | 2021-02-19 | US | Wisconsin | Menominee | 55078 | 797 | 11 | 0 | 786 | 45.00422544 | -88.70950714 | 2021-02-20 05:22:51 | Menominee, Wisconsin, US |
474551 | 474551 | 2021-02-19 | US | Texas | La Salle | 48283 | 975 | 21 | 0 | 786 | 28.34453111 | -99.09908775 | 2021-02-20 05:22:51 | La Salle, Texas, US |
472661 | 472661 | 2021-02-19 | US | Kansas | Anderson | 20003 | 803 | 17 | 0 | 786 | 38.21413251 | -95.29272815 | 2021-02-20 05:22:51 | Anderson, Kansas, US |
1156260 | 1156260 | 2021-02-18 | US | Texas | La Salle | 48283 | 975 | 21 | 0 | 786 | 28.34453111 | -99.09908775 | 2021-02-19 05:24:16 | La Salle, Texas, US |
1154344 | 1154344 | 2021-02-18 | US | Iowa | Pocahontas | 19151 | 804 | 18 | 0 | 786 | 42.73420133 | -94.67862564 | 2021-02-19 05:24:16 | Pocahontas, Iowa, US |
1152915 | 1152915 | 2021-02-18 | Chile | Nuble | 15921 | 309 | 14826 | 786 | -36.7226 | -71.7622 | 2021-02-19 05:24:16 | Nuble, Chile | ||
3603158 | 3603158 | 2021-02-17 | US | Nebraska | Thurston | 31173 | 796 | 10 | 0 | 786 | 42.15725356 | -96.54157099 | 2021-02-18 05:22:58 | Thurston, Nebraska, US |
3602264 | 3602264 | 2021-02-17 | US | Iowa | Pocahontas | 19151 | 804 | 18 | 0 | 786 | 42.73420133 | -94.67862564 | 2021-02-18 05:22:58 | Pocahontas, Iowa, US |
3051399 | 3051399 | 2021-02-16 | US | Iowa | Pocahontas | 19151 | 804 | 18 | 0 | 786 | 42.73420133 | -94.67862564 | 2021-02-17 05:23:10 | Pocahontas, Iowa, US |
1341447 | 1341447 | 2021-02-15 | US | Texas | Morris | 48343 | 955 | 23 | 0 | 786 | 33.11304005 | -94.73255695 | 2021-02-16 05:24:38 | Morris, Texas, US |
1339498 | 1339498 | 2021-02-15 | US | Iowa | Pocahontas | 19151 | 804 | 18 | 0 | 786 | 42.73420133 | -94.67862564 | 2021-02-16 05:24:38 | Pocahontas, Iowa, US |
2286598 | 2286598 | 2021-02-14 | US | Texas | Morris | 48343 | 955 | 23 | 0 | 786 | 33.11304005 | -94.73255695 | 2021-02-15 05:24:49 | Morris, Texas, US |
2284649 | 2284649 | 2021-02-14 | US | Iowa | Pocahontas | 19151 | 804 | 18 | 0 | 786 | 42.73420133 | -94.67862564 | 2021-02-15 05:24:49 | Pocahontas, Iowa, US |
2284291 | 2284291 | 2021-02-14 | US | Georgia | Stewart | 13259 | 807 | 21 | 0 | 786 | 32.07996777 | -84.83208037 | 2021-02-15 05:24:49 | Stewart, Georgia, US |
2679049 | 2679049 | 2021-02-13 | US | Iowa | Pocahontas | 19151 | 804 | 18 | 0 | 786 | 42.73420133 | -94.67862564 | 2021-02-14 05:23:43 | Pocahontas, Iowa, US |
2677662 | 2677662 | 2021-02-13 | Colombia | Bolivar | 65819 | 1325 | 63708 | 786 | 8.6704 | -74.03 | 2021-02-14 05:23:43 | Bolivar, Colombia | ||
3540682 | 3540682 | 2021-02-12 | US | Iowa | Pocahontas | 19151 | 804 | 18 | 0 | 786 | 42.73420133 | -94.67862564 | 2021-02-13 05:22:12 | Pocahontas, Iowa, US |
3540105 | 3540105 | 2021-02-12 | US | Colorado | San Miguel | 8113 | 805 | 0 | 0 | 786 | 38.00450883 | -108.4020725 | 2021-02-13 05:22:12 | San Miguel, Colorado, US |
2639608 | 2639608 | 2021-02-11 | US | Missouri | Dallas | 29059 | 808 | 22 | 0 | 786 | 37.6811355 | -93.02127031 | 2021-02-12 05:23:29 | Dallas, Missouri, US |
3978507 | 3978507 | 2021-02-10 | Guyana | 8092 | 182 | 7124 | 786 | 4.860416000000002 | -58.93018000000001 | 2021-02-11 05:23:55 | Guyana | |||
1529875 | 1529875 | 2021-02-09 | US | Montana | Carbon | 30009 | 797 | 11 | 0 | 786 | 45.22850116 | -109.0274047 | 2021-02-10 05:22:41 | Carbon, Montana, US |
1528703 | 1528703 | 2021-02-09 | US | Georgia | Hancock | 13141 | 841 | 55 | 0 | 786 | 33.2721566 | -82.99766919 | 2021-02-10 05:22:41 | Hancock, Georgia, US |
1589029 | 1589029 | 2021-02-05 | US | Georgia | Pulaski | 13235 | 819 | 33 | 0 | 786 | 32.23334561 | -83.47549959999998 | 2021-02-06 05:23:55 | Pulaski, Georgia, US |
793522 | 793522 | 2021-02-04 | US | Texas | La Salle | 48283 | 974 | 20 | 0 | 786 | 28.34453111 | -99.09908775 | 2021-02-05 05:22:38 | La Salle, Texas, US |
342981 | 342981 | 2021-02-03 | US | Puerto Rico | Aguas Buenas | 72007 | 786 | 0 | 0 | 786 | 18.251619 | -66.126806 | 2021-02-04 05:22:26 | Aguas Buenas, Puerto Rico, US |
342223 | 342223 | 2021-02-03 | US | Missouri | Ripley | 29181 | 797 | 11 | 0 | 786 | 36.65460667 | -90.85990261 | 2021-02-04 05:22:26 | Ripley, Missouri, US |
1687207 | 1687207 | 2021-02-02 | US | Puerto Rico | Aguas Buenas | 72007 | 786 | 0 | 0 | 786 | 18.251619 | -66.126806 | 2021-02-03 05:22:52 | Aguas Buenas, Puerto Rico, US |
1678025 | 1678025 | 2021-02-01 | US | Maine | Sagadahoc | 23023 | 787 | 1 | 0 | 786 | 43.95415864 | -69.85074999 | 2021-02-02 05:22:49 | Sagadahoc, Maine, US |
1900509 | 1900509 | 2021-01-29 | US | Virginia | Lexington | 51678 | 803 | 17 | 0 | 786 | 37.78258621 | -79.44262866 | 2021-01-30 05:22:49 | Lexington, Virginia, US |
3157167 | 3157167 | 2021-01-27 | US | Wisconsin | Pepin | 55091 | 793 | 7 | 0 | 786 | 44.58307413 | -91.99949611 | 2021-01-28 05:22:24 | Pepin, Wisconsin, US |
15902 | 15902 | 2021-01-26 | US | Wisconsin | Pepin | 55091 | 793 | 7 | 0 | 786 | 44.58307413 | -91.99949611 | 2021-01-27 05:23:41 | Pepin, Wisconsin, US |
2428987 | 2428987 | 2021-01-23 | US | Nebraska | Knox | 31107 | 793 | 7 | 0 | 786 | 42.63758421 | -97.89178836 | 2021-01-24 05:22:35 | Knox, Nebraska, US |
2427970 | 2427970 | 2021-01-23 | US | Indiana | Crawford | 18025 | 799 | 13 | 0 | 786 | 38.28814402 | -86.44518825 | 2021-01-24 05:22:35 | Crawford, Indiana, US |
2468889 | 2468889 | 2021-01-22 | US | Nebraska | Knox | 31107 | 793 | 7 | 0 | 786 | 42.63758421 | -97.89178836 | 2021-01-23 05:22:03 | Knox, Nebraska, US |
2468449 | 2468449 | 2021-01-22 | US | Michigan | Leelanau | 26089 | 796 | 10 | 0 | 786 | 44.94430054 | -85.80150326 | 2021-01-23 05:22:03 | Leelanau, Michigan, US |
2468233 | 2468233 | 2021-01-22 | US | Kentucky | Magoffin | 21153 | 787 | 1 | 0 | 786 | 37.70820545 | -83.0657714 | 2021-01-23 05:22:03 | Magoffin, Kentucky, US |
2467618 | 2467618 | 2021-01-22 | US | Georgia | Irwin | 13155 | 808 | 22 | 0 | 786 | 31.60213036 | -83.27501387 | 2021-01-23 05:22:03 | Irwin, Georgia, US |
2466496 | 2466496 | 2021-01-22 | Andorra | 9416 | 93 | 8537 | 786 | 42.5063 | 1.5218 | 2021-01-23 05:22:03 | Andorra | |||
435853 | 435853 | 2021-01-21 | US | Arkansas | Marion | 5089 | 813 | 27 | 0 | 786 | 36.26844485 | -92.68451899 | 2021-01-22 05:22:10 | Marion, Arkansas, 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]);