johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
123 rows where country_or_region = "US", deaths = 6 and province_or_state = "Hawaii" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
568017 | 568017 | 2021-10-29 | US | Hawaii | Out of HI | 80015 | 2676 | 6 | 0 | 22.03935037 | 0.0 | 2021-10-30 04:22:03 | Out of HI, Hawaii, US | |
2463700 | 2463700 | 2021-09-14 | US | Hawaii | Kauai | 15007 | 1810 | 6 | 0 | 22.03935037 | -159.5966786 | 2021-09-15 03:22:37 | Kauai, Hawaii, US | |
1386539 | 1386539 | 2021-09-13 | US | Hawaii | Kauai | 15007 | 1796 | 6 | 0 | 22.03935037 | -159.5966786 | 2021-09-14 04:21:41 | Kauai, Hawaii, US | |
1885908 | 1885908 | 2021-09-12 | US | Hawaii | Kauai | 15007 | 1769 | 6 | 0 | 22.03935037 | -159.5966786 | 2021-09-13 04:21:15 | Kauai, Hawaii, US | |
207149 | 207149 | 2020-08-19 | US | Hawaii | Maui | 15009 | 262 | 6 | 0 | 256 | 20.86399628 | -156.56890969999995 | 2020-08-20 04:27:43 | Maui, Hawaii, US |
3178903 | 3178903 | 2020-08-18 | US | Hawaii | Maui | 15009 | 242 | 6 | 0 | 236 | 20.86399628 | -156.5689097 | 2020-08-19 04:27:00 | Maui, Hawaii, US |
838507 | 838507 | 2020-08-17 | US | Hawaii | Maui | 15009 | 235 | 6 | 0 | 229 | 20.86399628 | -156.56890969999995 | 2020-08-18 04:27:56 | Maui, Hawaii, US |
1556865 | 1556865 | 2020-08-16 | US | Hawaii | Maui | 15009 | 226 | 6 | 0 | 220 | 20.86399628 | -156.56890969999995 | 2020-08-17 04:27:20 | Maui, Hawaii, US |
146867 | 146867 | 2020-08-15 | US | Hawaii | Maui | 15009 | 213 | 6 | 0 | 207 | 20.86399628 | -156.56890969999995 | 2020-08-16 04:27:42 | Maui, Hawaii, US |
1613142 | 1613142 | 2020-08-14 | US | Hawaii | Maui | 15009 | 206 | 6 | 0 | 200 | 20.86399628 | -156.56890969999995 | 2020-08-15 04:27:31 | Maui, Hawaii, US |
583726 | 583726 | 2020-08-13 | US | Hawaii | Maui | 15009 | 198 | 6 | 0 | 192 | 20.86399628 | -156.56890969999995 | 2020-08-14 04:51:19 | Maui, Hawaii, US |
3532345 | 3532345 | 2020-08-12 | US | Hawaii | Maui | 15009 | 191 | 6 | 0 | 185 | 20.86399628 | -156.56890969999995 | 2020-08-13 04:29:15 | Maui, Hawaii, US |
663240 | 663240 | 2020-08-11 | US | Hawaii | Maui | 15009 | 190 | 6 | 0 | 184 | 20.86399628 | -156.56890969999995 | 2020-08-12 04:27:29 | Maui, Hawaii, US |
1918781 | 1918781 | 2020-08-10 | US | Hawaii | Maui | 15009 | 186 | 6 | 0 | 180 | 20.86399628 | -156.56890969999995 | 2020-08-11 04:35:08 | Maui, Hawaii, US |
3921590 | 3921590 | 2020-08-09 | US | Hawaii | Maui | 15009 | 185 | 6 | 0 | 179 | 20.86399628 | -156.56890969999995 | 2020-08-10 04:34:55 | Maui, Hawaii, US |
369758 | 369758 | 2020-08-08 | US | Hawaii | Maui | 15009 | 184 | 6 | 0 | 178 | 20.86399628 | -156.56890969999995 | 2020-08-09 04:34:54 | Maui, Hawaii, US |
456942 | 456942 | 2020-08-07 | US | Hawaii | Maui | 15009 | 181 | 6 | 0 | 175 | 20.86399628 | -156.56890969999995 | 2020-08-08 04:34:53 | Maui, Hawaii, US |
3610627 | 3610627 | 2020-08-06 | US | Hawaii | Maui | 15009 | 180 | 6 | 0 | 174 | 20.86399628 | -156.56890969999995 | 2020-08-07 04:35:11 | Maui, Hawaii, US |
3791457 | 3791457 | 2020-08-05 | US | Hawaii | Maui | 15009 | 177 | 6 | 0 | 171 | 20.86399628 | -156.56890969999995 | 2020-08-06 04:35:02 | Maui, Hawaii, US |
96693 | 96693 | 2020-08-04 | US | Hawaii | Maui | 15009 | 178 | 6 | 0 | 172 | 20.86399628 | -156.56890969999995 | 2020-08-05 04:34:43 | Maui, Hawaii, US |
2738576 | 2738576 | 2020-08-03 | US | Hawaii | Maui | 15009 | 178 | 6 | 0 | 172 | 20.86399628 | -156.56890969999995 | 2020-08-04 04:41:59 | Maui, Hawaii, US |
2806328 | 2806328 | 2020-08-02 | US | Hawaii | Maui | 15009 | 171 | 6 | 0 | 165 | 20.86399628 | -156.56890969999995 | 2020-08-03 04:34:35 | Maui, Hawaii, US |
751896 | 751896 | 2020-08-01 | US | Hawaii | Maui | 15009 | 170 | 6 | 0 | 164 | 20.86399628 | -156.56890969999995 | 2020-08-02 04:34:47 | Maui, Hawaii, US |
3263061 | 3263061 | 2020-07-31 | US | Hawaii | Maui | 15009 | 171 | 6 | 0 | 165 | 20.86399628 | -156.56890969999995 | 2020-08-01 04:36:27 | Maui, Hawaii, US |
1926769 | 1926769 | 2020-07-30 | US | Hawaii | Maui | 15009 | 167 | 6 | 0 | 161 | 20.86399628 | -156.56890969999995 | 2020-07-31 04:35:18 | Maui, Hawaii, US |
2956937 | 2956937 | 2020-07-29 | US | Hawaii | Maui | 15009 | 163 | 6 | 0 | 157 | 20.86399628 | -156.56890969999995 | 2020-07-30 04:35:05 | Maui, Hawaii, US |
3183556 | 3183556 | 2020-07-28 | US | Hawaii | Maui | 15009 | 154 | 6 | 0 | 148 | 20.86399628 | -156.56890969999995 | 2020-07-29 04:35:11 | Maui, Hawaii, US |
175608 | 175608 | 2020-07-27 | US | Hawaii | Maui | 15009 | 153 | 6 | 0 | 147 | 20.86399628 | -156.56890969999995 | 2020-07-28 04:58:43 | Maui, Hawaii, US |
440921 | 440921 | 2020-07-26 | US | Hawaii | Maui | 15009 | 153 | 6 | 0 | 147 | 20.86399628 | -156.56890969999995 | 2020-07-27 04:35:02 | Maui, Hawaii, US |
1501165 | 1501165 | 2020-07-25 | US | Hawaii | Maui | 15009 | 146 | 6 | 0 | 140 | 20.86399628 | -156.56890969999995 | 2020-07-26 04:35:00 | Maui, Hawaii, US |
2562135 | 2562135 | 2020-07-24 | US | Hawaii | Maui | 15009 | 141 | 6 | 0 | 135 | 20.86399628 | -156.56890969999995 | 2020-07-25 04:47:39 | Maui, Hawaii, US |
60368 | 60368 | 2020-07-23 | US | Hawaii | Maui | 15009 | 141 | 6 | 0 | 135 | 20.86399628 | -156.56890969999995 | 2020-07-24 05:30:40 | Maui, Hawaii, US |
843158 | 843158 | 2020-07-22 | US | Hawaii | Maui | 15009 | 139 | 6 | 0 | 133 | 20.86399628 | -156.56890969999995 | 2020-07-23 05:15:04 | Maui, Hawaii, US |
1705897 | 1705897 | 2020-07-21 | US | Hawaii | Maui | 15009 | 139 | 6 | 0 | 133 | 20.86399628 | -156.56890969999995 | 2020-07-22 04:34:42 | Maui, Hawaii, US |
325432 | 325432 | 2020-07-20 | US | Hawaii | Maui | 15009 | 135 | 6 | 0 | 129 | 20.86399628 | -156.56890969999995 | 2020-07-21 04:38:46 | Maui, Hawaii, US |
120295 | 120295 | 2020-07-19 | US | Hawaii | Maui | 15009 | 135 | 6 | 0 | 129 | 20.86399628 | -156.56890969999995 | 2020-07-20 05:34:40 | Maui, Hawaii, US |
3203683 | 3203683 | 2020-07-18 | US | Hawaii | Maui | 15009 | 135 | 6 | 0 | 129 | 20.86399628 | -156.56890969999995 | 2020-07-19 04:34:58 | Maui, Hawaii, US |
2707018 | 2707018 | 2020-07-17 | US | Hawaii | Maui | 15009 | 135 | 6 | 0 | 129 | 20.86399628 | -156.56890969999995 | 2020-07-18 04:34:45 | Maui, Hawaii, US |
365837 | 365837 | 2020-07-16 | US | Hawaii | Maui | 15009 | 135 | 6 | 0 | 129 | 20.86399628 | -156.56890969999995 | 2020-07-17 04:34:50 | Maui, Hawaii, US |
2746505 | 2746505 | 2020-07-15 | US | Hawaii | Maui | 15009 | 135 | 6 | 0 | 129 | 20.86399628 | -156.56890969999995 | 2020-07-16 04:44:59 | Maui, Hawaii, US |
2157150 | 2157150 | 2020-07-14 | US | Hawaii | Maui | 15009 | 135 | 6 | 0 | 129 | 20.86399628 | -156.56890969999995 | 2020-07-15 04:34:39 | Maui, Hawaii, US |
3489796 | 3489796 | 2020-07-13 | US | Hawaii | Maui | 15009 | 135 | 6 | 0 | 129 | 20.86399628 | -156.56890969999995 | 2020-07-14 04:34:46 | Maui, Hawaii, US |
3736057 | 3736057 | 2020-07-12 | US | Hawaii | Maui | 15009 | 134 | 6 | 0 | 128 | 20.86399628 | -156.56890969999995 | 2020-07-13 04:43:04 | Maui, Hawaii, US |
3434452 | 3434452 | 2020-07-11 | US | Hawaii | Maui | 15009 | 133 | 6 | 0 | 127 | 20.86399628 | -156.56890969999995 | 2020-07-12 04:34:30 | Maui, Hawaii, US |
3235951 | 3235951 | 2020-07-10 | US | Hawaii | Maui | 15009 | 131 | 6 | 0 | 125 | 20.86399628 | -156.56890969999995 | 2020-07-11 04:34:26 | Maui, Hawaii, US |
1003938 | 1003938 | 2020-07-09 | US | Hawaii | Maui | 15009 | 130 | 6 | 0 | 124 | 20.86399628 | -156.56890969999995 | 2020-07-10 04:34:24 | Maui, Hawaii, US |
2221154 | 2221154 | 2020-07-08 | US | Hawaii | Maui | 15009 | 130 | 6 | 0 | 124 | 20.86399628 | -156.56890969999995 | 2020-07-09 04:34:23 | Maui, Hawaii, US |
885763 | 885763 | 2020-07-07 | US | Hawaii | Maui | 15009 | 128 | 6 | 0 | 122 | 20.86399628 | -156.56890969999995 | 2020-07-08 05:33:48 | Maui, Hawaii, US |
2683324 | 2683324 | 2020-07-06 | US | Hawaii | Maui | 15009 | 128 | 6 | 0 | 122 | 20.86399628 | -156.56890969999995 | 2020-07-07 04:34:00 | Maui, Hawaii, US |
413788 | 413788 | 2020-07-05 | US | Hawaii | Maui | 15009 | 128 | 6 | 0 | 122 | 20.86399628 | -156.56890969999995 | 2020-07-06 04:33:57 | Maui, Hawaii, US |
528351 | 528351 | 2020-07-04 | US | Hawaii | Maui | 15009 | 128 | 6 | 0 | 122 | 20.86399628 | -156.56890969999995 | 2020-07-05 04:33:46 | Maui, Hawaii, US |
2233013 | 2233013 | 2020-07-03 | US | Hawaii | Maui | 15009 | 127 | 6 | 0 | 121 | 20.86399628 | -156.56890969999995 | 2020-07-04 04:33:51 | Maui, Hawaii, US |
3043809 | 3043809 | 2020-07-02 | US | Hawaii | Maui | 15009 | 125 | 6 | 0 | 119 | 20.86399628 | -156.56890969999995 | 2020-07-03 04:33:54 | Maui, Hawaii, US |
301501 | 301501 | 2020-07-01 | US | Hawaii | Maui | 15009 | 125 | 6 | 0 | 119 | 20.86399628 | -156.56890969999995 | 2020-07-02 04:33:46 | Maui, Hawaii, US |
2972881 | 2972881 | 2020-06-30 | US | Hawaii | Maui | 15009 | 123 | 6 | 0 | 117 | 20.86399628 | -156.56890969999995 | 2020-07-01 04:33:52 | Maui, Hawaii, US |
2631359 | 2631359 | 2020-06-29 | US | Hawaii | Maui | 15009 | 122 | 6 | 0 | 116 | 20.86399628 | -156.56890969999995 | 2020-06-30 04:33:48 | Maui, Hawaii, US |
2304923 | 2304923 | 2020-06-28 | US | Hawaii | Maui | 15009 | 123 | 6 | 0 | 117 | 20.86399628 | -156.56890969999995 | 2020-06-29 04:33:44 | Maui, Hawaii, US |
2038258 | 2038258 | 2020-06-27 | US | Hawaii | Maui | 15009 | 122 | 6 | 0 | 116 | 20.86399628 | -156.56890969999995 | 2020-06-28 04:34:04 | Maui, Hawaii, US |
1134539 | 1134539 | 2020-06-26 | US | Hawaii | Maui | 15009 | 122 | 6 | 0 | 116 | 20.86399628 | -156.56890969999995 | 2020-06-27 04:33:35 | Maui, Hawaii, US |
2623526 | 2623526 | 2020-06-25 | US | Hawaii | Maui | 15009 | 122 | 6 | 0 | 116 | 20.86399628 | -156.56890969999995 | 2020-06-26 04:33:43 | Maui, Hawaii, US |
2699168 | 2699168 | 2020-06-24 | US | Hawaii | Maui | 15009 | 122 | 6 | 0 | 116 | 20.86399628 | -156.56890969999995 | 2020-06-25 05:26:54 | Maui, Hawaii, US |
1520858 | 1520858 | 2020-06-23 | US | Hawaii | Maui | 15009 | 122 | 6 | 0 | 116 | 20.86399628 | -156.56890969999995 | 2020-06-24 04:33:28 | Maui, Hawaii, US |
1509054 | 1509054 | 2020-06-22 | US | Hawaii | Maui | 15009 | 122 | 6 | 0 | 116 | 20.86399628 | -156.56890969999995 | 2020-06-23 04:33:22 | Maui, Hawaii, US |
3247795 | 3247795 | 2020-06-21 | US | Hawaii | Maui | 15009 | 122 | 6 | 0 | 116 | 20.86399628 | -156.56890969999995 | 2020-06-22 04:33:20 | Maui, Hawaii, US |
2436388 | 2436388 | 2020-06-20 | US | Hawaii | Maui | 15009 | 121 | 6 | 0 | 115 | 20.86399628 | -156.56890969999995 | 2020-06-21 04:33:19 | Maui, Hawaii, US |
1689966 | 1689966 | 2020-06-19 | US | Hawaii | Maui | 15009 | 121 | 6 | 0 | 115 | 20.86399628 | -156.56890969999995 | 2020-06-20 04:33:19 | Maui, Hawaii, US |
3681116 | 3681116 | 2020-06-18 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-19 04:33:17 | Maui, Hawaii, US |
1194320 | 1194320 | 2020-06-17 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-18 04:33:18 | Maui, Hawaii, US |
2385084 | 2385084 | 2020-06-16 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-17 04:33:21 | Maui, Hawaii, US |
285646 | 285646 | 2020-06-15 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-16 04:33:09 | Maui, Hawaii, US |
1835600 | 1835600 | 2020-06-14 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-15 03:33:14 | Maui, Hawaii, US |
3059652 | 3059652 | 2020-06-13 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-14 03:33:15 | Maui, Hawaii, US |
735974 | 735974 | 2020-06-12 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-13 03:33:14 | Maui, Hawaii, US |
1271951 | 1271951 | 2020-06-11 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-12 05:09:52 | Maui, Hawaii, US |
2862396 | 2862396 | 2020-06-10 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-11 03:33:41 | Maui, Hawaii, US |
1209256 | 1209256 | 2020-06-09 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-10 04:07:00 | Maui, Hawaii, US |
215683 | 215683 | 2020-06-08 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-09 03:33:03 | Maui, Hawaii, US |
2798481 | 2798481 | 2020-06-07 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-08 03:33:22 | Maui, Hawaii, US |
572537 | 572537 | 2020-06-06 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-07 03:53:30 | Maui, Hawaii, US |
1268235 | 1268235 | 2020-06-05 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-06 02:33:00 | Maui, Hawaii, US |
1279718 | 1279718 | 2020-06-04 | US | Hawaii | Maui | 15009 | 119 | 6 | 0 | 113 | 20.86399628 | -156.56890969999995 | 2020-06-05 02:33:06 | Maui, Hawaii, US |
3865273 | 3865273 | 2020-06-03 | US | Hawaii | Maui | 15009 | 119 | 6 | 0 | 113 | 20.86399628 | -156.56890969999995 | 2020-06-04 02:33:14 | Maui, Hawaii, US |
2554317 | 2554317 | 2020-06-02 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-03 02:33:13 | Maui, Hawaii, US |
803854 | 803854 | 2020-06-01 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-02 02:33:08 | Maui, Hawaii, US |
1792499 | 1792499 | 2020-05-31 | US | Hawaii | Maui | 15009 | 120 | 6 | 0 | 114 | 20.86399628 | -156.56890969999995 | 2020-06-01 02:32:46 | Maui, Hawaii, US |
3637392 | 3637392 | 2020-05-30 | US | Hawaii | Maui | 15009 | 119 | 6 | 0 | 113 | 20.86399628 | -156.56890969999995 | 2020-05-31 02:32:45 | Maui, Hawaii, US |
1788933 | 1788933 | 2020-05-29 | US | Hawaii | Maui | 15009 | 118 | 6 | 0 | 112 | 20.86399628 | -156.56890969999995 | 2020-05-30 02:32:48 | Maui, Hawaii, US |
2710813 | 2710813 | 2020-05-28 | US | Hawaii | Maui | 15009 | 118 | 6 | 0 | 112 | 20.86399628 | -156.56890969999995 | 2020-05-29 02:32:50 | Maui, Hawaii, US |
2546835 | 2546835 | 2020-05-27 | US | Hawaii | Maui | 15009 | 118 | 6 | 0 | 112 | 20.86399628 | -156.56890969999995 | 2020-05-28 02:32:31 | Maui, Hawaii, US |
1039800 | 1039800 | 2020-05-26 | US | Hawaii | Maui | 15009 | 118 | 6 | 0 | 112 | 20.86399628 | -156.56890969999995 | 2020-05-27 02:32:31 | Maui, Hawaii, US |
1103530 | 1103530 | 2020-05-25 | US | Hawaii | Maui | 15009 | 118 | 6 | 0 | 112 | 20.86399628 | -156.56890969999995 | 2020-05-26 02:32:35 | Maui, Hawaii, US |
874211 | 874211 | 2020-05-24 | US | Hawaii | Maui | 15009 | 118 | 6 | 0 | 112 | 20.86399628 | -156.56890969999995 | 2020-05-25 02:32:44 | Maui, Hawaii, US |
996403 | 996403 | 2020-05-23 | US | Hawaii | Maui | 15009 | 118 | 6 | 0 | 112 | 20.86399628 | -156.56890969999995 | 2020-05-24 02:32:43 | Maui, Hawaii, US |
1863426 | 1863426 | 2020-05-22 | US | Hawaii | Maui | 15009 | 117 | 6 | 0 | 111 | 20.86399628 | -156.56890969999995 | 2020-05-23 02:32:42 | Maui, Hawaii, US |
266934 | 266934 | 2020-05-21 | US | Hawaii | Maui | 15009 | 118 | 6 | 0 | 112 | 20.86399628 | -156.56890969999995 | 2020-05-22 02:36:51 | Maui, Hawaii, US |
1430518 | 1430518 | 2020-05-20 | US | Hawaii | Maui | 15009 | 117 | 6 | 0 | 111 | 20.86399628 | -156.56890969999995 | 2020-05-21 02:32:48 | Maui, Hawaii, US |
2388813 | 2388813 | 2020-05-19 | US | Hawaii | Maui | 15009 | 117 | 6 | 0 | 111 | 20.86399628 | -156.56890969999995 | 2020-05-20 02:32:19 | Maui, Hawaii, US |
3259555 | 3259555 | 2020-05-18 | US | Hawaii | Maui | 15009 | 117 | 6 | 0 | 111 | 20.86399628 | -156.56890969999995 | 2020-05-19 02:32:18 | Maui, Hawaii, US |
3414949 | 3414949 | 2020-05-17 | US | Hawaii | Maui | 15009 | 117 | 6 | 0 | 111 | 20.86399628 | -156.56890969999995 | 2020-05-18 02:32:21 | Maui, Hawaii, US |
1828184 | 1828184 | 2020-05-16 | US | Hawaii | Maui | 15009 | 117 | 6 | 0 | 111 | 20.86399628 | -156.56890969999995 | 2020-05-17 02:32:32 | Maui, Hawaii, 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]);