johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Germany" and province_or_state = "Schleswig-Holstein" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026273 | 1026273 | 2020-10-17 | Germany | Schleswig-Holstein | 5600 | 163 | 4851 | 612 | 54.2194 | 9.6961 | 2020-10-18 04:24:25 | Schleswig-Holstein, Germany | ||
2856768 | 2856768 | 2020-10-16 | Germany | Schleswig-Holstein | 5510 | 163 | 4819 | 618 | 54.2194 | 9.6961 | 2020-10-17 04:24:12 | Schleswig-Holstein, Germany | ||
786298 | 786298 | 2020-10-15 | Germany | Schleswig-Holstein | 5456 | 163 | 4780 | 567 | 54.2194 | 9.6961 | 2020-10-16 04:24:01 | Schleswig-Holstein, Germany | ||
79009 | 79009 | 2020-10-14 | Germany | Schleswig-Holstein | 5391 | 163 | 4744 | 549 | 54.2194 | 9.6961 | 2020-10-15 04:24:28 | Schleswig-Holstein, Germany | ||
3781824 | 3781824 | 2020-10-13 | Germany | Schleswig-Holstein | 5325 | 162 | 4713 | 515 | 54.2194 | 9.6961 | 2020-10-14 04:24:05 | Schleswig-Holstein, Germany | ||
2291364 | 2291364 | 2020-10-12 | Germany | Schleswig-Holstein | 5260 | 162 | 4670 | 493 | 54.2194 | 9.6961 | 2020-10-13 04:24:02 | Schleswig-Holstein, Germany | ||
3785817 | 3785817 | 2020-10-11 | Germany | Schleswig-Holstein | 5235 | 162 | 4629 | 469 | 54.2194 | 9.6961 | 2020-10-12 04:23:45 | Schleswig-Holstein, Germany | ||
2601955 | 2601955 | 2020-10-10 | Germany | Schleswig-Holstein | 5209 | 162 | 4595 | 478 | 54.2194 | 9.6961 | 2020-10-11 04:23:46 | Schleswig-Holstein, Germany | ||
817488 | 817488 | 2020-10-09 | Germany | Schleswig-Holstein | 5155 | 162 | 4584 | 409 | 54.2194 | 9.6961 | 2020-10-10 04:23:57 | Schleswig-Holstein, Germany | ||
2689603 | 2689603 | 2020-10-08 | Germany | Schleswig-Holstein | 5076 | 162 | 4561 | 353 | 54.2194 | 9.6961 | 2020-10-09 04:23:59 | Schleswig-Holstein, Germany | ||
1041745 | 1041745 | 2020-10-07 | Germany | Schleswig-Holstein | 5032 | 162 | 4531 | 383 | 54.2194 | 9.6961 | 2020-10-08 04:23:56 | Schleswig-Holstein, Germany | ||
3117406 | 3117406 | 2020-10-06 | Germany | Schleswig-Holstein | 4978 | 162 | 4486 | 384 | 54.2194 | 9.6961 | 2020-10-07 04:23:40 | Schleswig-Holstein, Germany | ||
3801818 | 3801818 | 2020-10-05 | Germany | Schleswig-Holstein | 4938 | 162 | 4424 | 392 | 54.2194 | 9.6961 | 2020-10-06 04:23:33 | Schleswig-Holstein, Germany | ||
1822708 | 1822708 | 2020-10-04 | Germany | Schleswig-Holstein | 4914 | 162 | 4346 | 406 | 54.2194 | 9.6961 | 2020-10-05 04:23:33 | Schleswig-Holstein, Germany | ||
2514092 | 2514092 | 2020-10-03 | Germany | Schleswig-Holstein | 4898 | 162 | 4328 | 408 | 54.2194 | 9.6961 | 2020-10-04 04:23:44 | Schleswig-Holstein, Germany | ||
3389310 | 3389310 | 2020-10-02 | Germany | Schleswig-Holstein | 4848 | 162 | 4304 | 382 | 54.2194 | 9.6961 | 2020-10-03 04:23:40 | Schleswig-Holstein, Germany | ||
2379551 | 2379551 | 2020-10-01 | Germany | Schleswig-Holstein | 4821 | 162 | 4271 | 388 | 54.2194 | 9.6961 | 2020-10-02 04:23:51 | Schleswig-Holstein, Germany | ||
1045737 | 1045737 | 2020-09-30 | Germany | Schleswig-Holstein | 4772 | 162 | 4236 | 374 | 54.2194 | 9.6961 | 2020-10-01 04:23:42 | Schleswig-Holstein, Germany | ||
966818 | 966818 | 2020-09-29 | Germany | Schleswig-Holstein | 4724 | 161 | 4208 | 355 | 54.2194 | 9.6961 | 2020-09-30 04:23:33 | Schleswig-Holstein, Germany | ||
1515315 | 1515315 | 2020-09-28 | Germany | Schleswig-Holstein | 4686 | 161 | 4175 | 350 | 54.2194 | 9.6961 | 2020-09-29 04:23:42 | Schleswig-Holstein, Germany | ||
2581903 | 2581903 | 2020-09-27 | Germany | Schleswig-Holstein | 4671 | 161 | 4141 | 369 | 54.2194 | 9.6961 | 2020-09-28 04:23:00 | Schleswig-Holstein, Germany | ||
2613955 | 2613955 | 2020-09-26 | Germany | Schleswig-Holstein | 4656 | 161 | 4128 | 367 | 54.2194 | 9.6961 | 2020-09-27 04:23:00 | Schleswig-Holstein, Germany | ||
2812670 | 2812670 | 2020-09-25 | Germany | Schleswig-Holstein | 4603 | 161 | 4115 | 327 | 54.2194 | 9.6961 | 2020-09-26 04:23:00 | Schleswig-Holstein, Germany | ||
2605947 | 2605947 | 2020-09-24 | Germany | Schleswig-Holstein | 4540 | 161 | 4089 | 290 | 54.2194 | 9.6961 | 2020-09-25 04:23:00 | Schleswig-Holstein, Germany | ||
2653690 | 2653690 | 2020-09-23 | Germany | Schleswig-Holstein | 4498 | 161 | 4068 | 269 | 54.2194 | 9.6961 | 2020-09-24 04:23:00 | Schleswig-Holstein, Germany | ||
3316139 | 3316139 | 2020-09-22 | Germany | Schleswig-Holstein | 4460 | 161 | 4040 | 259 | 54.2194 | 9.6961 | 2020-09-23 04:23:00 | Schleswig-Holstein, Germany | ||
2836738 | 2836738 | 2020-09-21 | Germany | Schleswig-Holstein | 4421 | 161 | 4017 | 243 | 54.2194 | 9.6961 | 2020-09-22 04:23:00 | Schleswig-Holstein, Germany | ||
3093342 | 3093342 | 2020-09-20 | Germany | Schleswig-Holstein | 4405 | 161 | 3997 | 247 | 54.2194 | 9.6961 | 2020-09-21 04:23:00 | Schleswig-Holstein, Germany | ||
2454692 | 2454692 | 2020-09-19 | Germany | Schleswig-Holstein | 4384 | 161 | 3981 | 242 | 54.2194 | 9.6961 | 2020-09-20 04:22:00 | Schleswig-Holstein, Germany | ||
2848761 | 2848761 | 2020-09-18 | Germany | Schleswig-Holstein | 4350 | 161 | 3981 | 208 | 54.2194 | 9.6961 | 2020-09-19 04:22:00 | Schleswig-Holstein, Germany | ||
1121510 | 1121510 | 2020-09-17 | Germany | Schleswig-Holstein | 4311 | 161 | 3969 | 181 | 54.2194 | 9.6961 | 2020-09-18 05:05:00 | Schleswig-Holstein, Germany | ||
666199 | 666199 | 2020-09-16 | Germany | Schleswig-Holstein | 4288 | 161 | 3954 | 173 | 54.2194 | 9.6961 | 2020-09-17 04:22:00 | Schleswig-Holstein, Germany | ||
2728924 | 2728924 | 2020-09-15 | Germany | Schleswig-Holstein | 4255 | 161 | 3938 | 156 | 54.2194 | 9.6961 | 2020-09-16 04:22:53 | Schleswig-Holstein, Germany | ||
344196 | 344196 | 2020-09-14 | Germany | Schleswig-Holstein | 4231 | 161 | 3917 | 153 | 54.2194 | 9.6961 | 2020-09-15 03:22:50 | Schleswig-Holstein, Germany | ||
2868635 | 2868635 | 2020-09-13 | Germany | Schleswig-Holstein | 4222 | 161 | 3905 | 156 | 54.2194 | 9.6961 | 2020-09-14 04:26:00 | Schleswig-Holstein, Germany | ||
546674 | 546674 | 2020-09-12 | Germany | Schleswig-Holstein | 4218 | 161 | 3896 | 161 | 54.2194 | 9.6961 | 2020-09-13 04:30:52 | Schleswig-Holstein, Germany | ||
1444503 | 1444503 | 2020-09-11 | Germany | Schleswig-Holstein | 4207 | 161 | 3891 | 155 | 54.2194 | 9.6961 | 2020-09-12 04:25:05 | Schleswig-Holstein, Germany | ||
1173104 | 1173104 | 2020-09-10 | Germany | Schleswig-Holstein | 4197 | 161 | 3864 | 182 | 54.2194 | 9.6961 | 2020-09-11 04:46:23 | Schleswig-Holstein, Germany | ||
2171469 | 2171469 | 2020-09-09 | Germany | Schleswig-Holstein | 4168 | 161 | 3845 | 191 | 54.2194 | 9.6961 | 2020-09-10 04:29:01 | Schleswig-Holstein, Germany | ||
1243678 | 1243678 | 2020-09-08 | Germany | Schleswig-Holstein | 4150 | 161 | 3820 | 169 | 54.2194 | 9.6961 | 2020-09-09 04:28:48 | Schleswig-Holstein, Germany | ||
427257 | 427257 | 2020-09-07 | Germany | Schleswig-Holstein | 4126 | 161 | 3800 | 189 | 54.2194 | 9.6961 | 2020-09-08 04:28:25 | Schleswig-Holstein, Germany | ||
3161542 | 3161542 | 2020-09-06 | Germany | Schleswig-Holstein | 4120 | 161 | 3800 | 165 | 54.2194 | 9.6961 | 2020-09-07 04:28:30 | Schleswig-Holstein, Germany | ||
813497 | 813497 | 2020-09-05 | Germany | Schleswig-Holstein | 4115 | 161 | 3753 | 206 | 54.2194 | 9.6961 | 2020-09-06 04:28:33 | Schleswig-Holstein, Germany | ||
2661697 | 2661697 | 2020-09-04 | Germany | Schleswig-Holstein | 4107 | 161 | 3742 | 212 | 54.2194 | 9.6961 | 2020-09-05 04:28:19 | Schleswig-Holstein, Germany | ||
1354237 | 1354237 | 2020-09-03 | Germany | Schleswig-Holstein | 4091 | 161 | 3722 | 224 | 54.2194 | 9.6961 | 2020-09-04 04:28:26 | Schleswig-Holstein, Germany | ||
1105474 | 1105474 | 2020-09-02 | Germany | Schleswig-Holstein | 4064 | 160 | 3702 | 227 | 54.2194 | 9.6961 | 2020-09-03 04:28:22 | Schleswig-Holstein, Germany | ||
2059803 | 2059803 | 2020-09-01 | Germany | Schleswig-Holstein | 4045 | 160 | 3681 | 222 | 54.2194 | 9.6961 | 2020-09-02 04:28:25 | Schleswig-Holstein, Germany | ||
193988 | 193988 | 2020-08-31 | Germany | Schleswig-Holstein | 4029 | 160 | 3659 | 225 | 54.2194 | 9.6961 | 2020-09-01 04:28:31 | Schleswig-Holstein, Germany | ||
3931947 | 3931947 | 2020-08-30 | Germany | Schleswig-Holstein | 4022 | 160 | 3642 | 220 | 54.2194 | 9.6961 | 2020-08-31 04:28:27 | Schleswig-Holstein, Germany | ||
609609 | 609609 | 2020-08-29 | Germany | Schleswig-Holstein | 4015 | 160 | 3632 | 229 | 54.2194 | 9.6961 | 2020-08-30 04:28:22 | Schleswig-Holstein, Germany | ||
1523104 | 1523104 | 2020-08-28 | Germany | Schleswig-Holstein | 4000 | 160 | 3615 | 239 | 54.2194 | 9.6961 | 2020-08-29 04:28:19 | Schleswig-Holstein, Germany | ||
2510105 | 2510105 | 2020-08-27 | Germany | Schleswig-Holstein | 3981 | 160 | 3595 | 244 | 54.2194 | 9.6961 | 2020-08-28 04:28:11 | Schleswig-Holstein, Germany | ||
1996565 | 1996565 | 2020-08-26 | Germany | Schleswig-Holstein | 3961 | 160 | 3566 | 254 | 54.2194 | 9.6961 | 2020-08-27 04:28:15 | Schleswig-Holstein, Germany | ||
3562489 | 3562489 | 2020-08-25 | Germany | Schleswig-Holstein | 3927 | 160 | 3536 | 264 | 54.2194 | 9.6961 | 2020-08-26 04:28:11 | Schleswig-Holstein, Germany | ||
2991193 | 2991193 | 2020-08-24 | Germany | Schleswig-Holstein | 3904 | 160 | 3500 | 267 | 54.2194 | 9.6961 | 2020-08-25 04:28:02 | Schleswig-Holstein, Germany | ||
2215588 | 2215588 | 2020-08-23 | Germany | Schleswig-Holstein | 3902 | 160 | 3500 | 244 | 54.2194 | 9.6961 | 2020-08-24 04:27:56 | Schleswig-Holstein, Germany | ||
2299370 | 2299370 | 2020-08-22 | Germany | Schleswig-Holstein | 3890 | 160 | 3454 | 288 | 54.2194 | 9.6961 | 2020-08-23 04:27:48 | Schleswig-Holstein, Germany | ||
1479477 | 1479477 | 2020-08-21 | Germany | Schleswig-Holstein | 3872 | 160 | 3446 | 284 | 54.2194 | 9.6961 | 2020-08-22 04:27:49 | Schleswig-Holstein, Germany | ||
3484226 | 3484226 | 2020-08-20 | Germany | Schleswig-Holstein | 3851 | 160 | 3418 | 294 | 54.2194 | 9.6961 | 2020-08-21 04:27:41 | Schleswig-Holstein, Germany | ||
206175 | 206175 | 2020-08-19 | Germany | Schleswig-Holstein | 3825 | 160 | 3400 | 291 | 54.2194 | 9.6961 | 2020-08-20 04:27:43 | Schleswig-Holstein, Germany | ||
3177929 | 3177929 | 2020-08-18 | Germany | Schleswig-Holstein | 3807 | 158 | 3400 | 267 | 54.2194 | 9.6961 | 2020-08-19 04:27:00 | Schleswig-Holstein, Germany | ||
837533 | 837533 | 2020-08-17 | Germany | Schleswig-Holstein | 3790 | 158 | 3400 | 232 | 54.2194 | 9.6961 | 2020-08-18 04:27:56 | Schleswig-Holstein, Germany | ||
1555891 | 1555891 | 2020-08-16 | Germany | Schleswig-Holstein | 3782 | 158 | 3300 | 332 | 54.2194 | 9.6961 | 2020-08-17 04:27:20 | Schleswig-Holstein, Germany | ||
145893 | 145893 | 2020-08-15 | Germany | Schleswig-Holstein | 3768 | 158 | 3300 | 324 | 54.2194 | 9.6961 | 2020-08-16 04:27:42 | Schleswig-Holstein, Germany | ||
1612168 | 1612168 | 2020-08-14 | Germany | Schleswig-Holstein | 3744 | 158 | 3300 | 310 | 54.2194 | 9.6961 | 2020-08-15 04:27:31 | Schleswig-Holstein, Germany | ||
582752 | 582752 | 2020-08-13 | Germany | Schleswig-Holstein | 3714 | 158 | 3300 | 286 | 54.2194 | 9.6961 | 2020-08-14 04:51:19 | Schleswig-Holstein, Germany | ||
3531371 | 3531371 | 2020-08-12 | Germany | Schleswig-Holstein | 3675 | 158 | 3260 | 296 | 54.2194 | 9.6961 | 2020-08-13 04:29:15 | Schleswig-Holstein, Germany | ||
662220 | 662220 | 2020-08-11 | Germany | Schleswig-Holstein | 3620 | 158 | 3218 | 299 | 54.2194 | 9.6961 | 2020-08-12 04:27:29 | Schleswig-Holstein, Germany | ||
1920567 | 1920567 | 2020-08-10 | Germany | Schleswig-Holstein | 3588 | 158 | 3218 | 244 | 54.2194 | 9.6961 | 2020-08-11 04:35:08 | Schleswig-Holstein, Germany | ||
3923376 | 3923376 | 2020-08-09 | Germany | Schleswig-Holstein | 3586 | 158 | 3200 | 230 | 54.2194 | 9.6961 | 2020-08-10 04:34:55 | Schleswig-Holstein, Germany | ||
371544 | 371544 | 2020-08-08 | Germany | Schleswig-Holstein | 3578 | 158 | 3200 | 228 | 54.2194 | 9.6961 | 2020-08-09 04:34:54 | Schleswig-Holstein, Germany | ||
458728 | 458728 | 2020-08-07 | Germany | Schleswig-Holstein | 3569 | 158 | 3200 | 220 | 54.2194 | 9.6961 | 2020-08-08 04:34:53 | Schleswig-Holstein, Germany | ||
3612413 | 3612413 | 2020-08-06 | Germany | Schleswig-Holstein | 3534 | 158 | 3145 | 266 | 54.2194 | 9.6961 | 2020-08-07 04:35:11 | Schleswig-Holstein, Germany | ||
3793243 | 3793243 | 2020-08-05 | Germany | Schleswig-Holstein | 3516 | 157 | 3145 | 231 | 54.2194 | 9.6961 | 2020-08-06 04:35:02 | Schleswig-Holstein, Germany | ||
98479 | 98479 | 2020-08-04 | Germany | Schleswig-Holstein | 3494 | 156 | 3137 | 222 | 54.2194 | 9.6961 | 2020-08-05 04:34:43 | Schleswig-Holstein, Germany | ||
2740362 | 2740362 | 2020-08-03 | Germany | Schleswig-Holstein | 3467 | 156 | 3129 | 209 | 54.2194 | 9.6961 | 2020-08-04 04:41:59 | Schleswig-Holstein, Germany | ||
2808114 | 2808114 | 2020-08-02 | Germany | Schleswig-Holstein | 3463 | 156 | 3100 | 207 | 54.2194 | 9.6961 | 2020-08-03 04:34:35 | Schleswig-Holstein, Germany | ||
753682 | 753682 | 2020-08-01 | Germany | Schleswig-Holstein | 3451 | 156 | 3100 | 207 | 54.2194 | 9.6961 | 2020-08-02 04:34:47 | Schleswig-Holstein, Germany | ||
3264847 | 3264847 | 2020-07-31 | Germany | Schleswig-Holstein | 3427 | 156 | 3100 | 195 | 54.2194 | 9.6961 | 2020-08-01 04:36:27 | Schleswig-Holstein, Germany | ||
1928554 | 1928554 | 2020-07-30 | Germany | Schleswig-Holstein | 3401 | 156 | 3100 | 171 | 54.2194 | 9.6961 | 2020-07-31 04:35:18 | Schleswig-Holstein, Germany | ||
2958722 | 2958722 | 2020-07-29 | Germany | Schleswig-Holstein | 3379 | 156 | 3100 | 145 | 54.2194 | 9.6961 | 2020-07-30 04:35:05 | Schleswig-Holstein, Germany | ||
3185338 | 3185338 | 2020-07-28 | Germany | Schleswig-Holstein | 3341 | 156 | 3100 | 123 | 54.2194 | 9.6961 | 2020-07-29 04:35:11 | Schleswig-Holstein, Germany | ||
177389 | 177389 | 2020-07-27 | Germany | Schleswig-Holstein | 3322 | 155 | 3100 | 86 | 54.2194 | 9.6961 | 2020-07-28 04:58:43 | Schleswig-Holstein, Germany | ||
442702 | 442702 | 2020-07-26 | Germany | Schleswig-Holstein | 3318 | 155 | 3100 | 67 | 54.2194 | 9.6961 | 2020-07-27 04:35:02 | Schleswig-Holstein, Germany | ||
1502946 | 1502946 | 2020-07-25 | Germany | Schleswig-Holstein | 3311 | 155 | 3100 | 63 | 54.2194 | 9.6961 | 2020-07-26 04:35:00 | Schleswig-Holstein, Germany | ||
2563916 | 2563916 | 2020-07-24 | Germany | Schleswig-Holstein | 3299 | 155 | 3100 | 56 | 54.2194 | 9.6961 | 2020-07-25 04:47:39 | Schleswig-Holstein, Germany | ||
62124 | 62124 | 2020-07-23 | Germany | Schleswig-Holstein | 3292 | 155 | 3100 | 44 | 54.2194 | 9.6961 | 2020-07-24 05:30:40 | Schleswig-Holstein, Germany | ||
844936 | 844936 | 2020-07-22 | Germany | Schleswig-Holstein | 3278 | 155 | 3050 | 87 | 54.2194 | 9.6961 | 2020-07-23 05:15:04 | Schleswig-Holstein, Germany | ||
1707675 | 1707675 | 2020-07-21 | Germany | Schleswig-Holstein | 3271 | 155 | 3050 | 73 | 54.2194 | 9.6961 | 2020-07-22 04:34:42 | Schleswig-Holstein, Germany | ||
327166 | 327166 | 2020-07-20 | Germany | Schleswig-Holstein | 3261 | 155 | 3050 | 66 | 54.2194 | 9.6961 | 2020-07-21 04:38:46 | Schleswig-Holstein, Germany | ||
122071 | 122071 | 2020-07-19 | Germany | Schleswig-Holstein | 3253 | 154 | 3000 | 106 | 54.2194 | 9.6961 | 2020-07-20 05:34:40 | Schleswig-Holstein, Germany | ||
3205460 | 3205460 | 2020-07-18 | Germany | Schleswig-Holstein | 3251 | 154 | 3000 | 99 | 54.2194 | 9.6961 | 2020-07-19 04:34:58 | Schleswig-Holstein, Germany | ||
2708762 | 2708762 | 2020-07-17 | Germany | Schleswig-Holstein | 3238 | 154 | 3000 | 97 | 54.2194 | 9.6961 | 2020-07-18 04:34:45 | Schleswig-Holstein, Germany | ||
367572 | 367572 | 2020-07-16 | Germany | Schleswig-Holstein | 3235 | 154 | 3000 | 84 | 54.2194 | 9.6961 | 2020-07-17 04:34:50 | Schleswig-Holstein, Germany | ||
2748240 | 2748240 | 2020-07-15 | Germany | Schleswig-Holstein | 3229 | 154 | 3000 | 81 | 54.2194 | 9.6961 | 2020-07-16 04:44:59 | Schleswig-Holstein, Germany | ||
2158884 | 2158884 | 2020-07-14 | Germany | Schleswig-Holstein | 3221 | 154 | 3000 | 67 | 54.2194 | 9.6961 | 2020-07-15 04:34:39 | Schleswig-Holstein, Germany | ||
3491525 | 3491525 | 2020-07-13 | Germany | Schleswig-Holstein | 3207 | 154 | 3000 | 67 | 54.2194 | 9.6961 | 2020-07-14 04:34:46 | Schleswig-Holstein, Germany | ||
3737788 | 3737788 | 2020-07-12 | Germany | Schleswig-Holstein | 3206 | 154 | 3000 | 53 | 54.2194 | 9.6961 | 2020-07-13 04:43:04 | Schleswig-Holstein, Germany | ||
3436183 | 3436183 | 2020-07-11 | Germany | Schleswig-Holstein | 3206 | 154 | 3000 | 52 | 54.2194 | 9.6961 | 2020-07-12 04:34:30 | Schleswig-Holstein, Germany | ||
3237681 | 3237681 | 2020-07-10 | Germany | Schleswig-Holstein | 3202 | 154 | 3000 | 52 | 54.2194 | 9.6961 | 2020-07-11 04:34:26 | Schleswig-Holstein, Germany |
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]);