johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Aiken, South Carolina, US" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state 1
- South Carolina 1,013
country_or_region 1
- US 1,013
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
805816 | 805816 | 2020-03-27 | US | South Carolina | Aiken | 45003 | 6 | 0 | 0 | 6 | 33.54338026 | -81.63645384 | 2020-03-27 22:14:55 | Aiken, South Carolina, US |
915916 | 915916 | 2020-03-26 | US | South Carolina | Aiken | 45003 | 2 | 0 | 0 | 2 | 33.54338026 | -81.63645384 | 2020-03-26 23:48:35 | Aiken, South Carolina, US |
1129316 | 1129316 | 2020-03-25 | US | South Carolina | Aiken | 45003 | 2 | 0 | 0 | 2 | 33.54338026 | -81.63645384 | 2020-03-25 23:33:19 | Aiken, South Carolina, US |
1475824 | 1475824 | 2020-03-24 | US | South Carolina | Aiken | 45003 | 2 | 0 | 0 | 2 | 33.54338026 | -81.63645384 | 2020-03-24 23:37:31 | Aiken, South Carolina, US |
1869186 | 1869186 | 2020-03-30 | US | South Carolina | Aiken | 45003 | 9 | 0 | 0 | 9 | 33.54338026 | -81.63645384 | 3/30/20 22:52 | Aiken, South Carolina, US |
2143881 | 2143881 | 2020-03-23 | US | South Carolina | Aiken | 45003 | 1 | 0 | 0 | 1 | 33.54338026 | -81.63645384 | 2020-03-23 23:19:34 | Aiken, South Carolina, US |
2872427 | 2872427 | 2020-03-29 | US | South Carolina | Aiken | 45003 | 9 | 0 | 0 | 9 | 33.54338026 | -81.63645384 | 3/29/20 23:08 | Aiken, South Carolina, US |
2908225 | 2908225 | 2020-03-22 | US | South Carolina | Aiken | 45003 | 1 | 0 | 0 | 1 | 33.54338026 | -81.63645384 | 3/22/20 23:45 | Aiken, South Carolina, US |
3943767 | 3943767 | 2020-03-28 | US | South Carolina | Aiken | 45003 | 7 | 0 | 0 | 7 | 33.54338026 | -81.63645384 | 3/28/20 23:05 | Aiken, South Carolina, US |
40359 | 40359 | 2020-04-13 | US | South Carolina | Aiken | 45003 | 51 | 1 | 0 | 50 | 33.54338026 | -81.63645384 | 2020-04-13 23:07:54 | Aiken, South Carolina, US |
586533 | 586533 | 2020-04-05 | US | South Carolina | Aiken | 45003 | 27 | 1 | 0 | 26 | 33.54338026 | -81.63645384 | 2020-04-05 23:06:45 | Aiken, South Carolina, US |
1247468 | 1247468 | 2020-04-10 | US | South Carolina | Aiken | 45003 | 48 | 1 | 0 | 47 | 33.54338026 | -81.63645384 | 2020-04-10 22:54:07 | Aiken, South Carolina, US |
1748259 | 1748259 | 2020-04-04 | US | South Carolina | Aiken | 45003 | 24 | 1 | 0 | 23 | 33.54338026 | -81.63645384 | 4/4/20 23:34 | Aiken, South Carolina, US |
2564259 | 2564259 | 2020-04-11 | US | South Carolina | Aiken | 45003 | 50 | 1 | 0 | 49 | 33.54338026 | -81.63645384 | 2020-04-11 22:45:33 | Aiken, South Carolina, US |
2575399 | 2575399 | 2020-04-12 | US | South Carolina | Aiken | 45003 | 50 | 1 | 0 | 49 | 33.54338026 | -81.63645384 | 2020-04-12 23:18:00 | Aiken, South Carolina, US |
3019070 | 3019070 | 2020-04-07 | US | South Carolina | Aiken | 45003 | 28 | 1 | 0 | 27 | 33.54338026 | -81.63645384 | 2020-04-07 23:04:49 | Aiken, South Carolina, US |
3362493 | 3362493 | 2020-04-01 | US | South Carolina | Aiken | 45003 | 18 | 1 | 0 | 17 | 33.54338026 | -81.63645384 | 2020-04-01 21:58:49 | Aiken, South Carolina, US |
3559369 | 3559369 | 2020-04-08 | US | South Carolina | Aiken | 45003 | 28 | 1 | 0 | 27 | 33.54338026 | -81.63645384 | 2020-04-08 22:51:58 | Aiken, South Carolina, US |
3624801 | 3624801 | 2020-04-06 | US | South Carolina | Aiken | 45003 | 27 | 1 | 0 | 26 | 33.54338026 | -81.63645384 | 4/6/20 23:22 | Aiken, South Carolina, US |
3699207 | 3699207 | 2020-04-02 | US | South Carolina | Aiken | 45003 | 22 | 1 | 0 | 21 | 33.54338026 | -81.63645384 | 4/2/20 23:25 | Aiken, South Carolina, US |
3738122 | 3738122 | 2020-04-03 | US | South Carolina | Aiken | 45003 | 22 | 1 | 0 | 21 | 33.54338026 | -81.63645384 | 2020-04-03 22:46:37 | Aiken, South Carolina, US |
3813635 | 3813635 | 2020-03-31 | US | South Carolina | Aiken | 45003 | 13 | 1 | 0 | 12 | 33.54338026 | -81.63645384 | 2020-03-31 23:43:56 | Aiken, South Carolina, US |
3947234 | 3947234 | 2020-04-09 | US | South Carolina | Aiken | 45003 | 42 | 1 | 0 | 41 | 33.54338026 | -81.63645384 | 2020-04-09 23:02:37 | Aiken, South Carolina, US |
47414 | 47414 | 2020-04-17 | US | South Carolina | Aiken | 45003 | 66 | 3 | 0 | 63 | 33.54338026 | -81.63645384 | 2020-04-17 23:30:52 | Aiken, South Carolina, US |
857321 | 857321 | 2020-04-15 | US | South Carolina | Aiken | 45003 | 60 | 3 | 0 | 57 | 33.54338026 | -81.63645384 | 2020-04-15 22:56:51 | Aiken, South Carolina, US |
931412 | 931412 | 2020-04-16 | US | South Carolina | Aiken | 45003 | 63 | 3 | 0 | 60 | 33.54338026 | -81.63645384 | 2020-04-16 23:30:51 | Aiken, South Carolina, US |
3335250 | 3335250 | 2020-04-14 | US | South Carolina | Aiken | 45003 | 60 | 3 | 0 | 57 | 33.54338026 | -81.63645384 | 2020-04-14 23:33:31 | Aiken, South Carolina, US |
415934 | 415934 | 2020-04-18 | US | South Carolina | Aiken | 45003 | 67 | 4 | 0 | 63 | 33.54338026 | -81.63645384 | 2020-04-18 22:32:47 | Aiken, South Carolina, US |
519434 | 519434 | 2020-04-21 | US | South Carolina | Aiken | 45003 | 70 | 4 | 0 | 66 | 33.54338026 | -81.63645384 | 2020-04-21 23:30:50 | Aiken, South Carolina, US |
1196360 | 1196360 | 2020-04-22 | US | South Carolina | Aiken | 45003 | 82 | 4 | 0 | 78 | 33.54338026 | -81.63645384 | 2020-04-22 23:30:53 | Aiken, South Carolina, US |
1382227 | 1382227 | 2020-04-19 | US | South Carolina | Aiken | 45003 | 69 | 4 | 0 | 65 | 33.54338026 | -81.63645384 | 2020-04-19 23:41:01 | Aiken, South Carolina, US |
2470526 | 2470526 | 2020-04-20 | US | South Carolina | Aiken | 45003 | 70 | 4 | 0 | 66 | 33.54338026 | -81.63645384 | 2020-04-20 23:36:47 | Aiken, South Carolina, US |
2521897 | 2521897 | 2020-04-23 | US | South Carolina | Aiken | 45003 | 84 | 5 | 0 | 79 | 33.54338026 | -81.63645384 | 2020-04-24 03:30:50 | Aiken, South Carolina, US |
111171 | 111171 | 2020-05-08 | US | South Carolina | Aiken | 45003 | 112 | 6 | 0 | 106 | 33.54338026 | -81.63645384 | 2020-05-09 02:32:35 | Aiken, South Carolina, US |
134455 | 134455 | 2020-04-29 | US | South Carolina | Aiken | 45003 | 97 | 6 | 0 | 91 | 33.54338026 | -81.63645384 | 2020-04-30 02:32:27 | Aiken, South Carolina, US |
225701 | 225701 | 2020-04-30 | US | South Carolina | Aiken | 45003 | 99 | 6 | 0 | 93 | 33.54338026 | -81.63645384 | 2020-05-01 02:32:28 | Aiken, South Carolina, US |
268674 | 268674 | 2020-04-28 | US | South Carolina | Aiken | 45003 | 94 | 6 | 0 | 88 | 33.54338026 | -81.63645384 | 2020-04-29 02:32:29 | Aiken, South Carolina, US |
1181209 | 1181209 | 2020-05-01 | US | South Carolina | Aiken | 45003 | 101 | 6 | 0 | 95 | 33.54338026 | -81.63645384 | 2020-05-02 02:32:27 | Aiken, South Carolina, US |
1456302 | 1456302 | 2020-04-24 | US | South Carolina | Aiken | 45003 | 86 | 6 | 0 | 80 | 33.54338026 | -81.63645384 | 2020-04-25 06:30:53 | Aiken, South Carolina, US |
1928896 | 1928896 | 2020-05-05 | US | South Carolina | Aiken | 45003 | 108 | 6 | 0 | 102 | 33.54338026 | -81.63645384 | 2020-05-06 02:32:31 | Aiken, South Carolina, US |
2040311 | 2040311 | 2020-05-02 | US | South Carolina | Aiken | 45003 | 105 | 6 | 0 | 99 | 33.54338026 | -81.63645384 | 2020-05-03 02:32:28 | Aiken, South Carolina, US |
2107849 | 2107849 | 2020-05-06 | US | South Carolina | Aiken | 45003 | 108 | 6 | 0 | 102 | 33.54338026 | -81.63645384 | 2020-05-07 02:32:28 | Aiken, South Carolina, US |
2275629 | 2275629 | 2020-05-03 | US | South Carolina | Aiken | 45003 | 108 | 6 | 0 | 102 | 33.54338026 | -81.63645384 | 2020-05-04 02:32:28 | Aiken, South Carolina, US |
2896120 | 2896120 | 2020-05-09 | US | South Carolina | Aiken | 45003 | 116 | 6 | 0 | 110 | 33.54338026 | -81.63645384 | 2020-05-10 02:32:30 | Aiken, South Carolina, US |
3081767 | 3081767 | 2020-05-04 | US | South Carolina | Aiken | 45003 | 108 | 6 | 0 | 102 | 33.54338026 | -81.63645384 | 2020-05-05 02:32:34 | Aiken, South Carolina, US |
3292621 | 3292621 | 2020-05-07 | US | South Carolina | Aiken | 45003 | 109 | 6 | 0 | 103 | 33.54338026 | -81.63645384 | 2020-05-08 02:32:32 | Aiken, South Carolina, US |
3327962 | 3327962 | 2020-05-11 | US | South Carolina | Aiken | 45003 | 119 | 6 | 0 | 113 | 33.54338026 | -81.63645384 | 2020-05-12 03:32:27 | Aiken, South Carolina, US |
3456577 | 3456577 | 2020-05-10 | US | South Carolina | Aiken | 45003 | 118 | 6 | 0 | 112 | 33.54338026 | -81.63645384 | 2020-05-11 02:32:30 | Aiken, South Carolina, US |
3499895 | 3499895 | 2020-04-25 | US | South Carolina | Aiken | 45003 | 89 | 6 | 0 | 83 | 33.54338026 | -81.63645384 | 2020-04-26 02:30:51 | Aiken, South Carolina, US |
3586348 | 3586348 | 2020-04-27 | US | South Carolina | Aiken | 45003 | 92 | 6 | 0 | 86 | 33.54338026 | -81.63645384 | 2020-04-28 02:30:51 | Aiken, South Carolina, US |
3589538 | 3589538 | 2020-04-26 | US | South Carolina | Aiken | 45003 | 89 | 6 | 0 | 83 | 33.54338026 | -81.63645384 | 2020-04-27 02:30:52 | Aiken, South Carolina, US |
265239 | 265239 | 2020-05-21 | US | South Carolina | Aiken | 45003 | 161 | 7 | 0 | 154 | 33.54338026 | -81.63645384 | 2020-05-22 02:36:51 | Aiken, South Carolina, US |
802137 | 802137 | 2020-06-01 | US | South Carolina | Aiken | 45003 | 206 | 7 | 0 | 199 | 33.54338026 | -81.63645384 | 2020-06-02 02:33:08 | Aiken, South Carolina, US |
872506 | 872506 | 2020-05-24 | US | South Carolina | Aiken | 45003 | 173 | 7 | 0 | 166 | 33.54338026 | -81.63645384 | 2020-05-25 02:32:44 | Aiken, South Carolina, US |
994701 | 994701 | 2020-05-23 | US | South Carolina | Aiken | 45003 | 169 | 7 | 0 | 162 | 33.54338026 | -81.63645384 | 2020-05-24 02:32:43 | Aiken, South Carolina, US |
1038094 | 1038094 | 2020-05-26 | US | South Carolina | Aiken | 45003 | 181 | 7 | 0 | 174 | 33.54338026 | -81.63645384 | 2020-05-27 02:32:31 | Aiken, South Carolina, US |
1101825 | 1101825 | 2020-05-25 | US | South Carolina | Aiken | 45003 | 178 | 7 | 0 | 171 | 33.54338026 | -81.63645384 | 2020-05-26 02:32:35 | Aiken, South Carolina, US |
1277995 | 1277995 | 2020-06-04 | US | South Carolina | Aiken | 45003 | 208 | 7 | 0 | 201 | 33.54338026 | -81.63645384 | 2020-06-05 02:33:06 | Aiken, South Carolina, US |
1401399 | 1401399 | 2020-05-14 | US | South Carolina | Aiken | 45003 | 135 | 7 | 0 | 128 | 33.54338026 | -81.63645384 | 2020-05-15 02:33:02 | Aiken, South Carolina, US |
1428824 | 1428824 | 2020-05-20 | US | South Carolina | Aiken | 45003 | 160 | 7 | 0 | 153 | 33.54338026 | -81.63645384 | 2020-05-21 02:32:48 | Aiken, South Carolina, US |
1787221 | 1787221 | 2020-05-29 | US | South Carolina | Aiken | 45003 | 191 | 7 | 0 | 184 | 33.54338026 | -81.63645384 | 2020-05-30 02:32:48 | Aiken, South Carolina, US |
1790784 | 1790784 | 2020-05-31 | US | South Carolina | Aiken | 45003 | 197 | 7 | 0 | 190 | 33.54338026 | -81.63645384 | 2020-06-01 02:32:46 | Aiken, South Carolina, US |
1826499 | 1826499 | 2020-05-16 | US | South Carolina | Aiken | 45003 | 150 | 7 | 0 | 143 | 33.54338026 | -81.63645384 | 2020-05-17 02:32:32 | Aiken, South Carolina, US |
1861726 | 1861726 | 2020-05-22 | US | South Carolina | Aiken | 45003 | 166 | 7 | 0 | 159 | 33.54338026 | -81.63645384 | 2020-05-23 02:32:42 | Aiken, South Carolina, US |
2387124 | 2387124 | 2020-05-19 | US | South Carolina | Aiken | 45003 | 156 | 7 | 0 | 149 | 33.54338026 | -81.63645384 | 2020-05-20 02:32:19 | Aiken, South Carolina, US |
2545127 | 2545127 | 2020-05-27 | US | South Carolina | Aiken | 45003 | 184 | 7 | 0 | 177 | 33.54338026 | -81.63645384 | 2020-05-28 02:32:31 | Aiken, South Carolina, US |
2552596 | 2552596 | 2020-06-02 | US | South Carolina | Aiken | 45003 | 208 | 7 | 0 | 201 | 33.54338026 | -81.63645384 | 2020-06-03 02:33:13 | Aiken, South Carolina, US |
2578425 | 2578425 | 2020-05-12 | US | South Carolina | Aiken | 45003 | 123 | 7 | 0 | 116 | 33.54338026 | -81.63645384 | 2020-05-13 03:32:26 | Aiken, South Carolina, US |
2709104 | 2709104 | 2020-05-28 | US | South Carolina | Aiken | 45003 | 189 | 7 | 0 | 182 | 33.54338026 | -81.63645384 | 2020-05-29 02:32:50 | Aiken, South Carolina, US |
3257868 | 3257868 | 2020-05-18 | US | South Carolina | Aiken | 45003 | 155 | 7 | 0 | 148 | 33.54338026 | -81.63645384 | 2020-05-19 02:32:18 | Aiken, South Carolina, US |
3273219 | 3273219 | 2020-05-15 | US | South Carolina | Aiken | 45003 | 137 | 7 | 0 | 130 | 33.54338026 | -81.63645384 | 2020-05-16 02:32:19 | Aiken, South Carolina, US |
3413263 | 3413263 | 2020-05-17 | US | South Carolina | Aiken | 45003 | 154 | 7 | 0 | 147 | 33.54338026 | -81.63645384 | 2020-05-18 02:32:21 | Aiken, South Carolina, US |
3635678 | 3635678 | 2020-05-30 | US | South Carolina | Aiken | 45003 | 194 | 7 | 0 | 187 | 33.54338026 | -81.63645384 | 2020-05-31 02:32:45 | Aiken, South Carolina, US |
3844217 | 3844217 | 2020-05-13 | US | South Carolina | Aiken | 45003 | 132 | 7 | 0 | 125 | 33.54338026 | -81.63645384 | 2020-05-14 03:32:28 | Aiken, South Carolina, US |
3863551 | 3863551 | 2020-06-03 | US | South Carolina | Aiken | 45003 | 208 | 7 | 0 | 201 | 33.54338026 | -81.63645384 | 2020-06-04 02:33:14 | Aiken, South Carolina, US |
213957 | 213957 | 2020-06-08 | US | South Carolina | Aiken | 45003 | 212 | 8 | 0 | 204 | 33.54338026 | -81.63645384 | 2020-06-09 03:33:03 | Aiken, South Carolina, US |
570811 | 570811 | 2020-06-06 | US | South Carolina | Aiken | 45003 | 216 | 8 | 0 | 208 | 33.54338026 | -81.63645384 | 2020-06-07 03:53:30 | Aiken, South Carolina, US |
1207528 | 1207528 | 2020-06-09 | US | South Carolina | Aiken | 45003 | 213 | 8 | 0 | 205 | 33.54338026 | -81.63645384 | 2020-06-10 04:07:00 | Aiken, South Carolina, US |
1266510 | 1266510 | 2020-06-05 | US | South Carolina | Aiken | 45003 | 216 | 8 | 0 | 208 | 33.54338026 | -81.63645384 | 2020-06-06 02:33:00 | Aiken, South Carolina, US |
1270220 | 1270220 | 2020-06-11 | US | South Carolina | Aiken | 45003 | 222 | 8 | 0 | 214 | 33.54338026 | -81.63645384 | 2020-06-12 05:09:52 | Aiken, South Carolina, US |
2796755 | 2796755 | 2020-06-07 | US | South Carolina | Aiken | 45003 | 208 | 8 | 0 | 200 | 33.54338026 | -81.63645384 | 2020-06-08 03:33:22 | Aiken, South Carolina, US |
2860666 | 2860666 | 2020-06-10 | US | South Carolina | Aiken | 45003 | 216 | 8 | 0 | 208 | 33.54338026 | -81.63645384 | 2020-06-11 03:33:41 | Aiken, South Carolina, US |
283904 | 283904 | 2020-06-15 | US | South Carolina | Aiken | 45003 | 234 | 9 | 0 | 225 | 33.54338026 | -81.63645384 | 2020-06-16 04:33:09 | Aiken, South Carolina, US |
734235 | 734235 | 2020-06-12 | US | South Carolina | Aiken | 45003 | 225 | 9 | 0 | 216 | 33.54338026 | -81.63645384 | 2020-06-13 03:33:14 | Aiken, South Carolina, US |
1132774 | 1132774 | 2020-06-26 | US | South Carolina | Aiken | 45003 | 325 | 9 | 0 | 316 | 33.54338026 | -81.63645384 | 2020-06-27 04:33:35 | Aiken, South Carolina, US |
1192577 | 1192577 | 2020-06-17 | US | South Carolina | Aiken | 45003 | 246 | 9 | 0 | 237 | 33.54338026 | -81.63645384 | 2020-06-18 04:33:18 | Aiken, South Carolina, US |
1507306 | 1507306 | 2020-06-22 | US | South Carolina | Aiken | 45003 | 279 | 9 | 0 | 270 | 33.54338026 | -81.63645384 | 2020-06-23 04:33:22 | Aiken, South Carolina, US |
1519107 | 1519107 | 2020-06-23 | US | South Carolina | Aiken | 45003 | 281 | 9 | 0 | 272 | 33.54338026 | -81.63645384 | 2020-06-24 04:33:28 | Aiken, South Carolina, US |
1688223 | 1688223 | 2020-06-19 | US | South Carolina | Aiken | 45003 | 261 | 9 | 0 | 252 | 33.54338026 | -81.63645384 | 2020-06-20 04:33:19 | Aiken, South Carolina, US |
1833860 | 1833860 | 2020-06-14 | US | South Carolina | Aiken | 45003 | 232 | 9 | 0 | 223 | 33.54338026 | -81.63645384 | 2020-06-15 03:33:14 | Aiken, South Carolina, US |
2036492 | 2036492 | 2020-06-27 | US | South Carolina | Aiken | 45003 | 335 | 9 | 0 | 326 | 33.54338026 | -81.63645384 | 2020-06-28 04:34:04 | Aiken, South Carolina, US |
2303157 | 2303157 | 2020-06-28 | US | South Carolina | Aiken | 45003 | 345 | 9 | 0 | 336 | 33.54338026 | -81.63645384 | 2020-06-29 04:33:44 | Aiken, South Carolina, US |
2383343 | 2383343 | 2020-06-16 | US | South Carolina | Aiken | 45003 | 240 | 9 | 0 | 231 | 33.54338026 | -81.63645384 | 2020-06-17 04:33:21 | Aiken, South Carolina, US |
2434641 | 2434641 | 2020-06-20 | US | South Carolina | Aiken | 45003 | 267 | 9 | 0 | 258 | 33.54338026 | -81.63645384 | 2020-06-21 04:33:19 | Aiken, South Carolina, US |
2621762 | 2621762 | 2020-06-25 | US | South Carolina | Aiken | 45003 | 314 | 9 | 0 | 305 | 33.54338026 | -81.63645384 | 2020-06-26 04:33:43 | Aiken, South Carolina, US |
2629592 | 2629592 | 2020-06-29 | US | South Carolina | Aiken | 45003 | 358 | 9 | 0 | 349 | 33.54338026 | -81.63645384 | 2020-06-30 04:33:48 | Aiken, South Carolina, US |
2697409 | 2697409 | 2020-06-24 | US | South Carolina | Aiken | 45003 | 302 | 9 | 0 | 293 | 33.54338026 | -81.63645384 | 2020-06-25 05:26:54 | Aiken, South Carolina, US |
3057912 | 3057912 | 2020-06-13 | US | South Carolina | Aiken | 45003 | 228 | 9 | 0 | 219 | 33.54338026 | -81.63645384 | 2020-06-14 03:33:15 | Aiken, South Carolina, US |
3246048 | 3246048 | 2020-06-21 | US | South Carolina | Aiken | 45003 | 274 | 9 | 0 | 265 | 33.54338026 | -81.63645384 | 2020-06-22 04:33:20 | Aiken, South Carolina, US |
3679373 | 3679373 | 2020-06-18 | US | South Carolina | Aiken | 45003 | 256 | 9 | 0 | 247 | 33.54338026 | -81.63645384 | 2020-06-19 04:33:17 | Aiken, South Carolina, 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]);