johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
146 rows where confirmed = 5 and province_or_state = "Mississippi" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1134072 | 1134072 | 2020-06-26 | US | Mississippi | Issaquena | 28055 | 5 | 0 | 0 | 5 | 32.72531359 | -90.97392828 | 2020-06-27 04:33:35 | Issaquena, Mississippi, US |
3275596 | 3275596 | 2020-05-15 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-05-16 02:32:19 | Sharkey, Mississippi, US |
1403772 | 1403772 | 2020-05-14 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-05-15 02:33:02 | Sharkey, Mississippi, US |
3846589 | 3846589 | 2020-05-13 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-05-14 03:32:28 | Sharkey, Mississippi, US |
2580796 | 2580796 | 2020-05-12 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-05-13 03:32:26 | Sharkey, Mississippi, US |
3330330 | 3330330 | 2020-05-11 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-05-12 03:32:27 | Sharkey, Mississippi, US |
3458945 | 3458945 | 2020-05-10 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-05-11 02:32:30 | Sharkey, Mississippi, US |
2898486 | 2898486 | 2020-05-09 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-05-10 02:32:30 | Sharkey, Mississippi, US |
113536 | 113536 | 2020-05-08 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-05-09 02:32:35 | Sharkey, Mississippi, US |
3294979 | 3294979 | 2020-05-07 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-05-08 02:32:32 | Sharkey, Mississippi, US |
2110202 | 2110202 | 2020-05-06 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-05-07 02:32:28 | Sharkey, Mississippi, US |
1931244 | 1931244 | 2020-05-05 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-05-06 02:32:31 | Sharkey, Mississippi, US |
3084108 | 3084108 | 2020-05-04 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-05-05 02:32:34 | Sharkey, Mississippi, US |
2276624 | 2276624 | 2020-05-03 | US | Mississippi | Greene | 28041 | 5 | 1 | 0 | 4 | 31.21444233 | -88.63922281 | 2020-05-04 02:32:28 | Greene, Mississippi, US |
2277967 | 2277967 | 2020-05-03 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-05-04 02:32:28 | Sharkey, Mississippi, US |
2041305 | 2041305 | 2020-05-02 | US | Mississippi | Greene | 28041 | 5 | 1 | 0 | 4 | 31.21444233 | -88.63922281 | 2020-05-03 02:32:28 | Greene, Mississippi, US |
2042645 | 2042645 | 2020-05-02 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-05-03 02:32:28 | Sharkey, Mississippi, US |
1182201 | 1182201 | 2020-05-01 | US | Mississippi | Greene | 28041 | 5 | 1 | 0 | 4 | 31.21444233 | -88.63922281 | 2020-05-02 02:32:27 | Greene, Mississippi, US |
1183539 | 1183539 | 2020-05-01 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-05-02 02:32:27 | Sharkey, Mississippi, US |
226687 | 226687 | 2020-04-30 | US | Mississippi | Greene | 28041 | 5 | 1 | 0 | 4 | 31.21444233 | -88.63922281 | 2020-05-01 02:32:28 | Greene, Mississippi, US |
228020 | 228020 | 2020-04-30 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-05-01 02:32:28 | Sharkey, Mississippi, US |
135437 | 135437 | 2020-04-29 | US | Mississippi | Greene | 28041 | 5 | 1 | 0 | 4 | 31.21444233 | -88.63922281 | 2020-04-30 02:32:27 | Greene, Mississippi, US |
136768 | 136768 | 2020-04-29 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.81595379999999 | 2020-04-30 02:32:27 | Sharkey, Mississippi, US |
269654 | 269654 | 2020-04-28 | US | Mississippi | Greene | 28041 | 5 | 1 | 0 | 4 | 31.21444233 | -88.63922281 | 2020-04-29 02:32:29 | Greene, Mississippi, US |
270984 | 270984 | 2020-04-28 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-04-29 02:32:29 | Sharkey, Mississippi, US |
3588649 | 3588649 | 2020-04-27 | US | Mississippi | Sharkey | 28125 | 5 | 0 | 0 | 5 | 32.88149103 | -90.8159538 | 2020-04-28 02:30:51 | Sharkey, Mississippi, US |
1457531 | 1457531 | 2020-04-24 | US | Mississippi | Jefferson | 28063 | 5 | 0 | 0 | 5 | 31.73397872 | -91.03764977 | 2020-04-25 06:30:53 | Jefferson, Mississippi, US |
2523124 | 2523124 | 2020-04-23 | US | Mississippi | Jefferson | 28063 | 5 | 0 | 0 | 5 | 31.73397872 | -91.03764977 | 2020-04-24 03:30:50 | Jefferson, Mississippi, US |
2524371 | 2524371 | 2020-04-23 | US | Mississippi | Tishomingo | 28141 | 5 | 0 | 0 | 5 | 34.74023475 | -88.23917219 | 2020-04-24 03:30:50 | Tishomingo, Mississippi, US |
1197579 | 1197579 | 2020-04-22 | US | Mississippi | Jefferson | 28063 | 5 | 0 | 0 | 5 | 31.73397872 | -91.03764977 | 2020-04-22 23:30:53 | Jefferson, Mississippi, US |
1198817 | 1198817 | 2020-04-22 | US | Mississippi | Tishomingo | 28141 | 5 | 0 | 0 | 5 | 34.74023475 | -88.23917219 | 2020-04-22 23:30:53 | Tishomingo, Mississippi, US |
520649 | 520649 | 2020-04-21 | US | Mississippi | Jefferson | 28063 | 5 | 0 | 0 | 5 | 31.73397872 | -91.03764977 | 2020-04-21 23:30:50 | Jefferson, Mississippi, US |
416077 | 416077 | 2020-04-18 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-18 22:32:47 | Benton, Mississippi, US |
931552 | 931552 | 2020-04-16 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-16 23:30:51 | Benton, Mississippi, US |
857461 | 857461 | 2020-04-15 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-15 22:56:51 | Benton, Mississippi, US |
3335389 | 3335389 | 2020-04-14 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-14 23:33:31 | Benton, Mississippi, US |
40497 | 40497 | 2020-04-13 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-13 23:07:54 | Benton, Mississippi, US |
41549 | 41549 | 2020-04-13 | US | Mississippi | Jefferson Davis | 28065 | 5 | 1 | 0 | 4 | 31.56884708 | -89.82670990000004 | 2020-04-13 23:07:54 | Jefferson Davis, Mississippi, US |
2575536 | 2575536 | 2020-04-12 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-12 23:18:00 | Benton, Mississippi, US |
2576580 | 2576580 | 2020-04-12 | US | Mississippi | Jefferson Davis | 28065 | 5 | 0 | 0 | 5 | 31.56884708 | -89.8267099 | 2020-04-12 23:18:00 | Jefferson Davis, Mississippi, US |
2564395 | 2564395 | 2020-04-11 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-11 22:45:33 | Benton, Mississippi, US |
2564677 | 2564677 | 2020-04-11 | US | Mississippi | Claiborne | 28021 | 5 | 0 | 0 | 5 | 31.97061673 | -90.90702196 | 2020-04-11 22:45:33 | Claiborne, Mississippi, US |
2565432 | 2565432 | 2020-04-11 | US | Mississippi | Jefferson Davis | 28065 | 5 | 0 | 0 | 5 | 31.56884708 | -89.82670990000004 | 2020-04-11 22:45:33 | Jefferson Davis, Mississippi, US |
1247602 | 1247602 | 2020-04-10 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-10 22:54:07 | Benton, Mississippi, US |
1248628 | 1248628 | 2020-04-10 | US | Mississippi | Jefferson Davis | 28065 | 5 | 0 | 0 | 5 | 31.56884708 | -89.82670990000004 | 2020-04-10 22:54:07 | Jefferson Davis, Mississippi, US |
1249704 | 1249704 | 2020-04-10 | US | Mississippi | Stone | 28131 | 5 | 0 | 0 | 5 | 30.79187949 | -89.11547539 | 2020-04-10 22:54:07 | Stone, Mississippi, US |
3947368 | 3947368 | 2020-04-09 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-09 23:02:37 | Benton, Mississippi, US |
3948073 | 3948073 | 2020-04-09 | US | Mississippi | George | 28039 | 5 | 0 | 0 | 5 | 30.86259065 | -88.64436789 | 2020-04-09 23:02:37 | George, Mississippi, US |
3948951 | 3948951 | 2020-04-09 | US | Mississippi | Noxubee | 28103 | 5 | 0 | 0 | 5 | 33.11009499 | -88.56949061 | 2020-04-09 23:02:37 | Noxubee, Mississippi, US |
3949446 | 3949446 | 2020-04-09 | US | Mississippi | Stone | 28131 | 5 | 0 | 0 | 5 | 30.79187949 | -89.11547539 | 2020-04-09 23:02:37 | Stone, Mississippi, US |
3559501 | 3559501 | 2020-04-08 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-08 22:51:58 | Benton, Mississippi, US |
3560152 | 3560152 | 2020-04-08 | US | Mississippi | Franklin | 28037 | 5 | 0 | 0 | 5 | 31.47786634 | -90.89672989 | 2020-04-08 22:51:58 | Franklin, Mississippi, US |
3560202 | 3560202 | 2020-04-08 | US | Mississippi | George | 28039 | 5 | 0 | 0 | 5 | 30.86259065 | -88.64436789 | 2020-04-08 22:51:58 | George, Mississippi, US |
3560453 | 3560453 | 2020-04-08 | US | Mississippi | Itawamba | 28057 | 5 | 0 | 0 | 5 | 34.27993475 | -88.3606733 | 2020-04-08 22:51:58 | Itawamba, Mississippi, US |
3561066 | 3561066 | 2020-04-08 | US | Mississippi | Noxubee | 28103 | 5 | 0 | 0 | 5 | 33.11009499 | -88.56949061 | 2020-04-08 22:51:58 | Noxubee, Mississippi, US |
3561842 | 3561842 | 2020-04-08 | US | Mississippi | Wayne | 28153 | 5 | 0 | 0 | 5 | 31.64135687 | -88.69573913 | 2020-04-08 22:51:58 | Wayne, Mississippi, US |
3019201 | 3019201 | 2020-04-07 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-07 23:04:49 | Benton, Mississippi, US |
3019847 | 3019847 | 2020-04-07 | US | Mississippi | Franklin | 28037 | 5 | 0 | 0 | 5 | 31.47786634 | -90.89672989 | 2020-04-07 23:04:49 | Franklin, Mississippi, US |
3019895 | 3019895 | 2020-04-07 | US | Mississippi | George | 28039 | 5 | 0 | 0 | 5 | 30.86259065 | -88.64436789 | 2020-04-07 23:04:49 | George, Mississippi, US |
3020109 | 3020109 | 2020-04-07 | US | Mississippi | Humphreys | 28053 | 5 | 1 | 0 | 4 | 33.12825718 | -90.52252707 | 2020-04-07 23:04:49 | Humphreys, Mississippi, US |
3020142 | 3020142 | 2020-04-07 | US | Mississippi | Itawamba | 28057 | 5 | 0 | 0 | 5 | 34.27993475 | -88.3606733 | 2020-04-07 23:04:49 | Itawamba, Mississippi, US |
3020339 | 3020339 | 2020-04-07 | US | Mississippi | Lawrence | 28077 | 5 | 0 | 0 | 5 | 31.55147224 | -90.10841127 | 2020-04-07 23:04:49 | Lawrence, Mississippi, US |
3020752 | 3020752 | 2020-04-07 | US | Mississippi | Noxubee | 28103 | 5 | 0 | 0 | 5 | 33.11009499 | -88.56949061 | 2020-04-07 23:04:49 | Noxubee, Mississippi, US |
3021518 | 3021518 | 2020-04-07 | US | Mississippi | Wayne | 28153 | 5 | 0 | 0 | 5 | 31.64135687 | -88.69573913 | 2020-04-07 23:04:49 | Wayne, Mississippi, US |
3624929 | 3624929 | 2020-04-06 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 4/6/20 23:22 | Benton, Mississippi, US |
3625561 | 3625561 | 2020-04-06 | US | Mississippi | Franklin | 28037 | 5 | 0 | 0 | 5 | 31.47786634 | -90.89672989 | 4/6/20 23:22 | Franklin, Mississippi, US |
3625609 | 3625609 | 2020-04-06 | US | Mississippi | George | 28039 | 5 | 0 | 0 | 5 | 30.86259065 | -88.64436789 | 4/6/20 23:22 | George, Mississippi, US |
3626042 | 3626042 | 2020-04-06 | US | Mississippi | Lawrence | 28077 | 5 | 0 | 0 | 5 | 31.55147224 | -90.10841127 | 4/6/20 23:22 | Lawrence, Mississippi, US |
3626446 | 3626446 | 2020-04-06 | US | Mississippi | Noxubee | 28103 | 5 | 0 | 0 | 5 | 33.11009499 | -88.56949061 | 4/6/20 23:22 | Noxubee, Mississippi, US |
3627145 | 3627145 | 2020-04-06 | US | Mississippi | Warren | 28149 | 5 | 0 | 0 | 5 | 32.35810271 | -90.83352619 | 4/6/20 23:22 | Warren, Mississippi, US |
3627201 | 3627201 | 2020-04-06 | US | Mississippi | Wayne | 28153 | 5 | 0 | 0 | 5 | 31.64135687 | -88.69573913 | 4/6/20 23:22 | Wayne, Mississippi, US |
586661 | 586661 | 2020-04-05 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-05 23:06:45 | Benton, Mississippi, US |
586834 | 586834 | 2020-04-05 | US | Mississippi | Carroll | 28015 | 5 | 0 | 0 | 5 | 33.44834567 | -89.91994479 | 2020-04-05 23:06:45 | Carroll, Mississippi, US |
586947 | 586947 | 2020-04-05 | US | Mississippi | Clarke | 28023 | 5 | 0 | 0 | 5 | 32.04158545 | -88.68896219999998 | 2020-04-05 23:06:45 | Clarke, Mississippi, US |
587282 | 587282 | 2020-04-05 | US | Mississippi | Franklin | 28037 | 5 | 0 | 0 | 5 | 31.47786634 | -90.89672989 | 2020-04-05 23:06:45 | Franklin, Mississippi, US |
587330 | 587330 | 2020-04-05 | US | Mississippi | George | 28039 | 5 | 0 | 0 | 5 | 30.86259065 | -88.64436789 | 2020-04-05 23:06:45 | George, Mississippi, US |
587662 | 587662 | 2020-04-05 | US | Mississippi | Kemper | 28069 | 5 | 0 | 0 | 5 | 32.75462946 | -88.64105766 | 2020-04-05 23:06:45 | Kemper, Mississippi, US |
588152 | 588152 | 2020-04-05 | US | Mississippi | Noxubee | 28103 | 5 | 0 | 0 | 5 | 33.11009499 | -88.56949061 | 2020-04-05 23:06:45 | Noxubee, Mississippi, US |
588541 | 588541 | 2020-04-05 | US | Mississippi | Simpson | 28127 | 5 | 0 | 0 | 5 | 31.91282117 | -89.91716179 | 2020-04-05 23:06:45 | Simpson, Mississippi, US |
588837 | 588837 | 2020-04-05 | US | Mississippi | Warren | 28149 | 5 | 0 | 0 | 5 | 32.35810271 | -90.83352619 | 2020-04-05 23:06:45 | Warren, Mississippi, US |
588892 | 588892 | 2020-04-05 | US | Mississippi | Wayne | 28153 | 5 | 0 | 0 | 5 | 31.64135687 | -88.69573913 | 2020-04-05 23:06:45 | Wayne, Mississippi, US |
1748382 | 1748382 | 2020-04-04 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 4/4/20 23:34 | Benton, Mississippi, US |
1748547 | 1748547 | 2020-04-04 | US | Mississippi | Carroll | 28015 | 5 | 0 | 0 | 5 | 33.44834567 | -89.91994479 | 4/4/20 23:34 | Carroll, Mississippi, US |
1748659 | 1748659 | 2020-04-04 | US | Mississippi | Clarke | 28023 | 5 | 0 | 0 | 5 | 32.04158545 | -88.6889622 | 4/4/20 23:34 | Clarke, Mississippi, US |
1749826 | 1749826 | 2020-04-04 | US | Mississippi | Noxubee | 28103 | 5 | 0 | 0 | 5 | 33.11009499 | -88.56949061 | 4/4/20 23:34 | Noxubee, Mississippi, US |
1750030 | 1750030 | 2020-04-04 | US | Mississippi | Quitman | 28119 | 5 | 0 | 0 | 5 | 34.25157572 | -90.28908 | 4/4/20 23:34 | Quitman, Mississippi, US |
1750196 | 1750196 | 2020-04-04 | US | Mississippi | Simpson | 28127 | 5 | 0 | 0 | 5 | 31.91282117 | -89.91716179 | 4/4/20 23:34 | Simpson, Mississippi, US |
3738149 | 3738149 | 2020-04-03 | US | Mississippi | Amite | 28005 | 5 | 1 | 0 | 4 | 31.17467303 | -90.80501621 | 2020-04-03 22:46:37 | Amite, Mississippi, US |
3738242 | 3738242 | 2020-04-03 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 2020-04-03 22:46:37 | Benton, Mississippi, US |
3738407 | 3738407 | 2020-04-03 | US | Mississippi | Carroll | 28015 | 5 | 0 | 0 | 5 | 33.44834567 | -89.91994479 | 2020-04-03 22:46:37 | Carroll, Mississippi, US |
3739278 | 3739278 | 2020-04-03 | US | Mississippi | Lawrence | 28077 | 5 | 0 | 0 | 5 | 31.55147224 | -90.10841127 | 2020-04-03 22:46:37 | Lawrence, Mississippi, US |
3739429 | 3739429 | 2020-04-03 | US | Mississippi | Marion | 28091 | 5 | 0 | 0 | 5 | 31.23132643 | -89.8209217 | 2020-04-03 22:46:37 | Marion, Mississippi, US |
3739617 | 3739617 | 2020-04-03 | US | Mississippi | Neshoba | 28099 | 5 | 0 | 0 | 5 | 32.75339664 | -89.11726492 | 2020-04-03 22:46:37 | Neshoba, Mississippi, US |
3739653 | 3739653 | 2020-04-03 | US | Mississippi | Noxubee | 28103 | 5 | 0 | 0 | 5 | 33.11009499 | -88.56949061 | 2020-04-03 22:46:37 | Noxubee, Mississippi, US |
3740014 | 3740014 | 2020-04-03 | US | Mississippi | Simpson | 28127 | 5 | 0 | 0 | 5 | 31.91282117 | -89.91716179 | 2020-04-03 22:46:37 | Simpson, Mississippi, US |
3740236 | 3740236 | 2020-04-03 | US | Mississippi | Union | 28145 | 5 | 0 | 0 | 5 | 34.49162015 | -89.00776006 | 2020-04-03 22:46:37 | Union, Mississippi, US |
3699326 | 3699326 | 2020-04-02 | US | Mississippi | Benton | 28009 | 5 | 0 | 0 | 5 | 34.81681228 | -89.18945516 | 4/2/20 23:25 | Benton, Mississippi, US |
3700344 | 3700344 | 2020-04-02 | US | Mississippi | Lawrence | 28077 | 5 | 0 | 0 | 5 | 31.55147224 | -90.10841127 | 4/2/20 23:25 | Lawrence, Mississippi, US |
3700486 | 3700486 | 2020-04-02 | US | Mississippi | Marion | 28091 | 5 | 0 | 0 | 5 | 31.23132643 | -89.8209217 | 4/2/20 23:25 | Marion, Mississippi, US |
3362870 | 3362870 | 2020-04-01 | US | Mississippi | Clarke | 28023 | 5 | 0 | 0 | 5 | 32.04158545 | -88.68896219999998 | 2020-04-01 21:58:49 | Clarke, Mississippi, 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]);