johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
288 rows where active = 795 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 26
- US 233
- Russia 12
- Benin 5
- Chile 4
- Mexico 4
- Gabon 3
- Germany 3
- Japan 3
- Peru 3
- Colombia 2
- Azerbaijan 1
- Cabo Verde 1
- Estonia 1
- Eswatini 1
- Ireland 1
- Italy 1
- Madagascar 1
- Malaysia 1
- Montenegro 1
- Netherlands 1
- Pakistan 1
- Spain 1
- Trinidad and Tobago 1
- Ukraine 1
- United Kingdom 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
829740 | 829740 | 2021-07-09 | Pakistan | Balochistan | 27863 | 317 | 26751 | 795 | 28.328492 | 65.898403 | 2021-07-10 04:21:25 | Balochistan, Pakistan | ||
1936064 | 1936064 | 2021-07-05 | Ukraine | Kharkiv Oblast | 148657 | 3542 | 144320 | 795 | 49.9935 | 36.2304 | 2021-07-06 04:21:32 | Kharkiv Oblast, Ukraine | ||
399968 | 399968 | 2021-06-29 | Azerbaijan | 335961 | 4973 | 330193 | 795 | 40.1431 | 47.5769 | 2021-06-30 04:21:41 | Azerbaijan | |||
2295647 | 2295647 | 2021-06-24 | Russia | Chuvashia Republic | 26957 | 1515 | 24647 | 795 | 55.4259922 | 47.0849429 | 2021-06-25 04:21:33 | Chuvashia Republic, Russia | ||
1564159 | 1564159 | 2021-06-14 | Madagascar | 41948 | 889 | 40264 | 795 | -18.766947 | 46.869107 | 2021-06-15 04:22:22 | Madagascar | |||
1412841 | 1412841 | 2021-05-24 | Chile | Atacama | 20545 | 226 | 19524 | 795 | -27.5661 | -70.0503 | 2021-05-25 04:21:08 | Atacama, Chile | ||
1913406 | 1913406 | 2021-05-20 | Russia | Chuvashia Republic | 25238 | 1404 | 23039 | 795 | 55.4259922 | 47.0849429 | 2021-05-21 04:20:43 | Chuvashia Republic, Russia | ||
2939237 | 2939237 | 2021-05-16 | Germany | Bremen | 26530 | 468 | 25310 | 795 | 53.0793 | 8.8017 | 2021-05-17 04:20:34 | Bremen, Germany | ||
1082170 | 1082170 | 2021-05-14 | Russia | Smolensk Oblast | 30081 | 936 | 28350 | 795 | 55.03434960000001 | 33.0192065 | 2021-05-15 04:20:58 | Smolensk Oblast, Russia | ||
2824453 | 2824453 | 2021-05-10 | Malaysia | Sabah | 58954 | 442 | 57717 | 795 | 5.9788 | 116.0753 | 2021-05-11 04:20:41 | Sabah, Malaysia | ||
1636513 | 1636513 | 2021-04-29 | Russia | Irkutsk Oblast | 66070 | 2235 | 63040 | 795 | 56.6370122 | 104.719221 | 2021-04-30 04:21:03 | Irkutsk Oblast, Russia | ||
3129548 | 3129548 | 2021-04-18 | Japan | Nara | 4982 | 61 | 4126 | 795 | 34.317451 | 135.871644 | 2021-04-19 04:20:57 | Nara, Japan | ||
3643414 | 3643414 | 2021-03-30 | Colombia | Tolima | 66519 | 2149 | 63575 | 795 | 4.0925 | -75.1545 | 2021-03-31 04:26:25 | Tolima, Colombia | ||
3453051 | 3453051 | 2021-03-18 | Russia | Chuvashia Republic | 22212 | 1136 | 20281 | 795 | 55.4259922 | 47.0849429 | 2021-03-19 05:26:09 | Chuvashia Republic, Russia | ||
1579947 | 1579947 | 2021-03-13 | Chile | Tarapaca | 26143 | 471 | 24877 | 795 | -19.9232 | -69.5132 | 2021-03-14 05:25:37 | Tarapaca, Chile | ||
2359378 | 2359378 | 2021-03-08 | Germany | Bremen | 18492 | 366 | 17355 | 795 | 53.0793 | 8.8017 | 2021-03-09 05:28:19 | Bremen, Germany | ||
3669279 | 3669279 | 2021-03-06 | US | Michigan | Missaukee | 26113 | 813 | 18 | 0 | 795 | 44.33772443 | -85.09256478 | 2021-03-07 05:21:54 | Missaukee, Michigan, US |
1618139 | 1618139 | 2021-03-05 | US | Missouri | Grundy | 29079 | 829 | 34 | 0 | 795 | 40.11406587 | -93.56509276 | 2021-03-06 04:23:41 | Grundy, Missouri, US |
1617192 | 1617192 | 2021-03-05 | US | Idaho | Valley | 16085 | 800 | 5 | 0 | 795 | 44.76728382 | -115.5676773 | 2021-03-06 04:23:41 | Valley, Idaho, US |
2209550 | 2209550 | 2021-03-04 | US | Missouri | Grundy | 29079 | 829 | 34 | 0 | 795 | 40.11406587 | -93.56509276 | 2021-03-05 05:26:29 | Grundy, Missouri, US |
1093173 | 1093173 | 2021-03-03 | US | Texas | Hansford | 48195 | 1008 | 21 | 0 | 795 | 36.27743284 | -101.3545796 | 2021-03-04 05:24:24 | Hansford, Texas, US |
1092632 | 1092632 | 2021-03-03 | US | Oklahoma | Latimer | 40077 | 804 | 9 | 0 | 795 | 34.87844729 | -95.25215049 | 2021-03-04 05:24:24 | Latimer, Oklahoma, US |
1091971 | 1091971 | 2021-03-03 | US | Missouri | Grundy | 29079 | 829 | 34 | 0 | 795 | 40.11406587 | -93.56509276 | 2021-03-04 05:24:24 | Grundy, Missouri, US |
1090902 | 1090902 | 2021-03-03 | US | Georgia | Long | 13183 | 807 | 12 | 0 | 795 | 31.75218791 | -81.74952375 | 2021-03-04 05:24:24 | Long, Georgia, US |
3256043 | 3256043 | 2021-03-02 | US | Missouri | Grundy | 29079 | 829 | 34 | 0 | 795 | 40.11406587 | -93.56509276 | 2021-03-03 05:23:28 | Grundy, Missouri, US |
3255396 | 3255396 | 2021-03-02 | US | Kansas | Anderson | 20003 | 813 | 18 | 0 | 795 | 38.21413251 | -95.29272815 | 2021-03-03 05:23:28 | Anderson, Kansas, US |
999688 | 999688 | 2021-03-01 | US | Kansas | Anderson | 20003 | 813 | 18 | 0 | 795 | 38.21413251 | -95.29272815 | 2021-03-02 05:23:30 | Anderson, Kansas, US |
2185625 | 2185625 | 2021-02-26 | US | Nebraska | Butler | 31023 | 806 | 11 | 0 | 795 | 41.22703692 | -97.13106306 | 2021-02-27 05:22:28 | Butler, Nebraska, US |
474584 | 474584 | 2021-02-19 | US | Texas | Morris | 48343 | 964 | 23 | 0 | 795 | 33.11304005 | -94.73255695 | 2021-02-20 05:22:51 | Morris, Texas, US |
473439 | 473439 | 2021-02-19 | US | Montana | Valley | 30105 | 806 | 11 | 0 | 795 | 48.36435097 | -106.6669635 | 2021-02-20 05:22:51 | Valley, Montana, US |
473298 | 473298 | 2021-02-19 | US | Missouri | Dallas | 29059 | 817 | 22 | 0 | 795 | 37.6811355 | -93.02127031 | 2021-02-20 05:22:51 | Dallas, Missouri, US |
1155007 | 1155007 | 2021-02-18 | US | Missouri | Dallas | 29059 | 817 | 22 | 0 | 795 | 37.6811355 | -93.02127031 | 2021-02-19 05:24:16 | Dallas, Missouri, US |
3602927 | 3602927 | 2021-02-17 | US | Missouri | Dallas | 29059 | 817 | 22 | 0 | 795 | 37.6811355 | -93.02127031 | 2021-02-18 05:22:58 | Dallas, Missouri, US |
3052062 | 3052062 | 2021-02-16 | US | Missouri | Dallas | 29059 | 817 | 22 | 0 | 795 | 37.6811355 | -93.02127031 | 2021-02-17 05:23:10 | Dallas, Missouri, US |
1341016 | 1341016 | 2021-02-15 | US | Puerto Rico | Juana Diaz | 72075 | 795 | 0 | 0 | 795 | 18.050764 | -66.49458100000001 | 2021-02-16 05:24:38 | Juana Diaz, Puerto Rico, US |
2638528 | 2638528 | 2021-02-11 | US | Georgia | Hancock | 13141 | 850 | 55 | 0 | 795 | 33.2721566 | -82.99766919 | 2021-02-12 05:23:29 | Hancock, Georgia, US |
1530609 | 1530609 | 2021-02-09 | US | Puerto Rico | Barranquitas | 72019 | 795 | 0 | 0 | 795 | 18.201592 | -66.30963 | 2021-02-10 05:22:41 | Barranquitas, Puerto Rico, US |
1528801 | 1528801 | 2021-02-09 | US | Hawaii | Out of HI | 80015 | 798 | 3 | 0 | 795 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US |
976807 | 976807 | 2021-02-06 | US | Missouri | Dent | 29065 | 809 | 14 | 0 | 795 | 37.60663134 | -91.50790473 | 2021-02-07 05:23:00 | Dent, Missouri, US |
975287 | 975287 | 2021-02-06 | US | Alabama | Greene | 1063 | 824 | 29 | 0 | 795 | 32.85504247 | -87.95684022 | 2021-02-07 05:23:00 | Greene, Alabama, US |
1590065 | 1590065 | 2021-02-05 | US | Missouri | Dent | 29065 | 809 | 14 | 0 | 795 | 37.60663134 | -91.50790473 | 2021-02-06 05:23:55 | Dent, Missouri, US |
793945 | 793945 | 2021-02-04 | US | Wisconsin | Pepin | 55091 | 802 | 7 | 0 | 795 | 44.58307413 | -91.99949611 | 2021-02-05 05:22:38 | Pepin, Wisconsin, US |
792272 | 792272 | 2021-02-04 | US | Missouri | Dent | 29065 | 809 | 14 | 0 | 795 | 37.60663134 | -91.50790473 | 2021-02-05 05:22:38 | Dent, Missouri, US |
791900 | 791900 | 2021-02-04 | US | Louisiana | Red River | 22081 | 829 | 34 | 0 | 795 | 32.09530039 | -93.34213308 | 2021-02-05 05:22:38 | Red River, Louisiana, US |
343837 | 343837 | 2021-02-03 | US | Wisconsin | Pepin | 55091 | 802 | 7 | 0 | 795 | 44.58307413 | -91.99949611 | 2021-02-04 05:22:26 | Pepin, Wisconsin, US |
1459553 | 1459553 | 2021-01-31 | Chile | Nuble | 13821 | 265 | 12761 | 795 | -36.7226 | -71.7622 | 2021-02-01 05:22:53 | Nuble, Chile | ||
1899238 | 1899238 | 2021-01-29 | US | Nebraska | Knox | 31107 | 804 | 9 | 0 | 795 | 42.63758421 | -97.89178836 | 2021-01-30 05:22:49 | Knox, Nebraska, US |
2484054 | 2484054 | 2021-01-28 | US | Nebraska | Knox | 31107 | 804 | 9 | 0 | 795 | 42.63758421 | -97.89178836 | 2021-01-29 05:22:23 | Knox, Nebraska, US |
3154509 | 3154509 | 2021-01-27 | US | Hawaii | Out of HI | 80015 | 798 | 3 | 0 | 795 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US |
14424 | 14424 | 2021-01-26 | US | Nebraska | Knox | 31107 | 803 | 8 | 0 | 795 | 42.63758421 | -97.89178836 | 2021-01-27 05:23:41 | Knox, Nebraska, US |
13768 | 13768 | 2021-01-26 | US | Kentucky | Magoffin | 21153 | 796 | 1 | 0 | 795 | 37.70820545 | -83.0657714 | 2021-01-27 05:23:41 | Magoffin, Kentucky, US |
13130 | 13130 | 2021-01-26 | US | Georgia | Evans | 13109 | 811 | 16 | 0 | 795 | 32.15328841 | -81.8870105 | 2021-01-27 05:23:41 | Evans, Georgia, US |
2570983 | 2570983 | 2021-01-25 | US | Virginia | Dickenson | 51051 | 808 | 13 | 0 | 795 | 37.12560977 | -82.35124171 | 2021-01-26 05:22:02 | Dickenson, Virginia, US |
2469081 | 2469081 | 2021-01-22 | US | North Carolina | Alleghany | 37005 | 798 | 3 | 0 | 795 | 36.49360862 | -81.12857041 | 2021-01-23 05:22:03 | Alleghany, North Carolina, US |
436571 | 436571 | 2021-01-21 | US | Iowa | Monroe | 19135 | 814 | 19 | 0 | 795 | 41.02988815 | -92.8690667 | 2021-01-22 05:22:10 | Monroe, Iowa, US |
436138 | 436138 | 2021-01-21 | US | Georgia | Dooly | 13093 | 825 | 30 | 0 | 795 | 32.15630737 | -83.79746561 | 2021-01-22 05:22:10 | Dooly, Georgia, US |
908209 | 908209 | 2021-01-19 | Japan | Okinawa | 6578 | 86 | 5697 | 795 | 25.768923 | 126.668016 | 2021-01-20 05:21:54 | Okinawa, Japan | ||
239018 | 239018 | 2021-01-18 | US | Mississippi | Benton | 28009 | 818 | 23 | 0 | 795 | 34.81681228 | -89.18945516 | 2021-01-19 05:22:15 | Benton, Mississippi, US |
238762 | 238762 | 2021-01-18 | US | Louisiana | St. Helena | 22091 | 801 | 6 | 0 | 795 | 30.82210324 | -90.71013176 | 2021-01-19 05:22:15 | St. Helena, Louisiana, US |
3102893 | 3102893 | 2021-01-16 | US | Kentucky | Powell | 21197 | 795 | 0 | 0 | 795 | 37.83218794 | -83.82553961 | 2021-01-17 05:22:17 | Powell, Kentucky, US |
3102319 | 3102319 | 2021-01-16 | US | Georgia | Turner | 13287 | 821 | 26 | 0 | 795 | 31.71612656 | -83.62069378 | 2021-01-17 05:22:17 | Turner, Georgia, US |
3882136 | 3882136 | 2021-01-14 | US | Oklahoma | Major | 40093 | 799 | 4 | 0 | 795 | 36.31149996 | -98.53467076 | 2021-01-15 05:22:24 | Major, Oklahoma, US |
775563 | 775563 | 2021-01-12 | US | Iowa | Montgomery | 19137 | 817 | 22 | 0 | 795 | 41.03018714 | -95.15642896 | 2021-01-13 05:22:15 | Montgomery, Iowa, US |
2628593 | 2628593 | 2021-01-10 | US | Puerto Rico | Cidra | 72041 | 795 | 0 | 0 | 795 | 18.173559 | -66.161179 | 2021-01-11 05:21:50 | Cidra, Puerto Rico, US |
2627676 | 2627676 | 2021-01-10 | US | Mississippi | Jefferson Davis | 28065 | 819 | 24 | 0 | 795 | 31.56884708 | -89.82670990000003 | 2021-01-11 05:21:50 | Jefferson Davis, Mississippi, US |
2626886 | 2626886 | 2021-01-10 | US | Illinois | Menard | 17129 | 801 | 6 | 0 | 795 | 40.02742725 | -89.80246001 | 2021-01-11 05:21:50 | Menard, Illinois, US |
3903451 | 3903451 | 2021-01-09 | US | West Virginia | Nicholas | 54067 | 804 | 9 | 0 | 795 | 38.29617706 | -80.79759588 | 2021-01-10 05:22:12 | Nicholas, West Virginia, US |
3903103 | 3903103 | 2021-01-09 | US | Texas | Leon | 48289 | 1178 | 26 | 0 | 795 | 31.29872538 | -95.9936328 | 2021-01-10 05:22:12 | Leon, Texas, US |
2543267 | 2543267 | 2021-01-07 | US | Missouri | Barton | 29011 | 803 | 8 | 0 | 795 | 37.50207671 | -94.34757022 | 2021-01-08 05:22:42 | Barton, Missouri, US |
2542352 | 2542352 | 2021-01-07 | US | Idaho | Teton | 16081 | 798 | 3 | 0 | 795 | 43.75303583 | -111.2056773 | 2021-01-08 05:22:42 | Teton, Idaho, US |
2867927 | 2867927 | 2021-01-06 | US | Texas | Somervell | 48425 | 812 | 8 | 0 | 795 | 32.22236802 | -97.77403489 | 2021-01-07 05:22:03 | Somervell, Texas, US |
2866475 | 2866475 | 2021-01-06 | US | Minnesota | Swift | 27151 | 812 | 17 | 0 | 795 | 45.2829032 | -95.68264092 | 2021-01-07 05:22:03 | Swift, Minnesota, US |
2866103 | 2866103 | 2021-01-06 | US | Kentucky | Fleming | 21069 | 797 | 2 | 0 | 795 | 38.36758311 | -83.69657514 | 2021-01-07 05:22:03 | Fleming, Kentucky, US |
1064707 | 1064707 | 2021-01-04 | US | South Dakota | Grant | 46051 | 830 | 35 | 0 | 795 | 45.1723937 | -96.77002276 | 2021-01-05 05:21:49 | Grant, South Dakota, US |
1064592 | 1064592 | 2021-01-04 | US | Puerto Rico | Las Piedras | 72085 | 795 | 0 | 0 | 795 | 18.187527 | -65.86946800000001 | 2021-01-05 05:21:49 | Las Piedras, Puerto Rico, US |
2230316 | 2230316 | 2021-01-02 | US | South Carolina | Calhoun | 45017 | 815 | 20 | 0 | 795 | 33.66926881 | -80.77722168 | 2021-01-03 05:22:52 | Calhoun, South Carolina, US |
2230219 | 2230219 | 2021-01-02 | US | Pennsylvania | Wyoming | 42131 | 824 | 29 | 0 | 795 | 41.51955538 | -76.01074915 | 2021-01-03 05:22:52 | Wyoming, Pennsylvania, US |
3699137 | 3699137 | 2020-12-31 | United Kingdom | Gibraltar | 2040 | 7 | 1238 | 795 | 36.1408 | -5.3536 | 2021-01-01 05:23:07 | Gibraltar, United Kingdom | ||
3780504 | 3780504 | 2020-12-27 | US | Oregon | Columbia | 41009 | 808 | 13 | 0 | 795 | 45.94464254 | -123.0890898 | 2020-12-28 05:22:06 | Columbia, Oregon, US |
3770993 | 3770993 | 2020-12-22 | US | Indiana | Pike | 18125 | 821 | 26 | 0 | 795 | 38.40112197 | -87.23574907 | 2020-12-23 05:22:03 | Pike, Indiana, US |
1901914 | 1901914 | 2020-12-18 | US | Georgia | Bleckley | 13023 | 828 | 33 | 0 | 795 | 32.43829035 | -83.33035166 | 2020-12-19 05:27:52 | Bleckley, Georgia, US |
1037747 | 1037747 | 2020-12-15 | US | Virginia | Nottoway | 51135 | 819 | 24 | 0 | 795 | 37.1435975 | -78.05065922 | 2020-12-16 05:28:04 | Nottoway, Virginia, US |
1754728 | 1754728 | 2020-12-14 | US | West Virginia | Boone | 54005 | 813 | 18 | 0 | 795 | 38.01974191 | -81.69888019 | 2020-12-15 05:26:38 | Boone, West Virginia, US |
3848047 | 3848047 | 2020-12-13 | Russia | Voronezh Oblast | 39237 | 828 | 37614 | 795 | 50.9800393 | 40.15065070000001 | 2020-12-14 05:26:27 | Voronezh Oblast, Russia | ||
848931 | 848931 | 2020-12-12 | US | Virginia | Martinsville | 51690 | 822 | 27 | 0 | 795 | 36.68212094 | -79.86352771 | 2020-12-13 05:27:20 | Martinsville, Virginia, US |
861602 | 861602 | 2020-12-11 | US | Idaho | Franklin | 16041 | 802 | 7 | 0 | 795 | 42.18332217 | -111.8149666 | 2020-12-12 05:26:19 | Franklin, Idaho, US |
861422 | 861422 | 2020-12-11 | US | Georgia | Berrien | 13019 | 824 | 29 | 0 | 795 | 31.27590016 | -83.22529920000002 | 2020-12-12 05:26:19 | Berrien, Georgia, US |
1602338 | 1602338 | 2020-12-10 | US | Nebraska | Wayne | 31179 | 800 | 5 | 0 | 795 | 42.20934475 | -97.11926964 | 2020-12-11 05:26:59 | Wayne, Nebraska, US |
1601685 | 1601685 | 2020-12-10 | US | Kentucky | Union | 21225 | 802 | 7 | 0 | 795 | 37.66166713 | -87.94300009 | 2020-12-11 05:26:59 | Union, Kentucky, US |
2976237 | 2976237 | 2020-12-09 | US | Illinois | Mason | 17125 | 824 | 29 | 0 | 795 | 40.23917274 | -89.91824452 | 2020-12-10 05:26:19 | Mason, Illinois, US |
2976154 | 2976154 | 2020-12-09 | US | Idaho | Fremont | 16043 | 806 | 11 | 0 | 795 | 44.22800938 | -111.4809943 | 2020-12-10 05:26:19 | Fremont, Idaho, US |
2975448 | 2975448 | 2020-12-09 | Russia | Mari El Republic | 8033 | 101 | 7137 | 795 | 56.5767504 | 47.8817512 | 2020-12-10 05:26:19 | Mari El Republic, Russia | ||
2348609 | 2348609 | 2020-12-07 | US | Iowa | Guthrie | 19077 | 810 | 15 | 0 | 795 | 41.68378965 | -94.50111014 | 2020-12-08 05:27:42 | Guthrie, Iowa, US |
1009009 | 1009009 | 2020-12-06 | US | Puerto Rico | Canovanas | 72029 | 795 | 0 | 0 | 795 | 18.328802 | -65.887612 | 2020-12-07 05:26:14 | Canovanas, Puerto Rico, US |
1006981 | 1006981 | 2020-12-06 | US | Florida | Gilchrist | 12041 | 815 | 20 | 0 | 795 | 29.72856978 | -82.79880657 | 2020-12-07 05:26:14 | Gilchrist, Florida, US |
1634217 | 1634217 | 2020-12-05 | US | Missouri | Livingston | 29117 | 811 | 16 | 0 | 795 | 39.78110272 | -93.54645978 | 2020-12-06 05:26:18 | Livingston, Missouri, US |
1633841 | 1633841 | 2020-12-05 | US | Louisiana | West Feliciana | 22125 | 820 | 25 | 0 | 795 | 30.87882871 | -91.4148538 | 2020-12-06 05:26:18 | West Feliciana, Louisiana, US |
1633252 | 1633252 | 2020-12-05 | US | Idaho | Washington | 16087 | 807 | 12 | 0 | 795 | 44.45275475 | -116.7847688 | 2020-12-06 05:26:18 | Washington, Idaho, US |
1632905 | 1632905 | 2020-12-05 | US | Colorado | Delta | 8029 | 1055 | 19 | 0 | 795 | 38.86246243 | -107.8631342 | 2020-12-06 05:26:18 | Delta, Colorado, US |
3863425 | 3863425 | 2020-12-04 | US | Wyoming | Goshen | 56015 | 804 | 9 | 0 | 795 | 42.08798185 | -104.3534743 | 2020-12-05 05:27:36 | Goshen, Wyoming, 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]);