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 = "Baden-Wurttemberg" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016615 | 2016615 | 2022-09-20 | Germany | Baden-Wurttemberg | 4443873 | 17217 | 0 | 48.6616 | 9.3501 | 2022-09-21 04:23:22 | Baden-Wurttemberg, Germany | |||
3570488 | 3570488 | 2022-09-19 | Germany | Baden-Wurttemberg | 4438037 | 17199 | 0 | 48.6616 | 9.3501 | 2022-09-20 04:22:48 | Baden-Wurttemberg, Germany | |||
419227 | 419227 | 2022-09-18 | Germany | Baden-Wurttemberg | 4434416 | 17193 | 0 | 48.6616 | 9.3501 | 2022-09-19 04:21:49 | Baden-Wurttemberg, Germany | |||
3373251 | 3373251 | 2022-09-17 | Germany | Baden-Wurttemberg | 4434416 | 17193 | 0 | 48.6616 | 9.3501 | 2022-09-18 04:22:50 | Baden-Wurttemberg, Germany | |||
2355359 | 2355359 | 2022-09-16 | Germany | Baden-Wurttemberg | 4434416 | 17193 | 0 | 48.6616 | 9.3501 | 2022-09-17 04:20:19 | Baden-Wurttemberg, Germany | |||
3986516 | 3986516 | 2022-09-15 | Germany | Baden-Wurttemberg | 4430315 | 17185 | 0 | 48.6616 | 9.3501 | 2022-09-16 04:21:19 | Baden-Wurttemberg, Germany | |||
1889033 | 1889033 | 2022-09-14 | Germany | Baden-Wurttemberg | 4426070 | 17078 | 0 | 48.6616 | 9.3501 | 2022-09-15 04:21:02 | Baden-Wurttemberg, Germany | |||
372088 | 372088 | 2022-09-13 | Germany | Baden-Wurttemberg | 4421116 | 17052 | 0 | 48.6616 | 9.3501 | 2022-09-14 04:20:44 | Baden-Wurttemberg, Germany | |||
2394693 | 2394693 | 2022-09-12 | Germany | Baden-Wurttemberg | 4415508 | 17048 | 0 | 48.6616 | 9.3501 | 2022-09-13 04:20:57 | Baden-Wurttemberg, Germany | |||
3765771 | 3765771 | 2022-09-11 | Germany | Baden-Wurttemberg | 4412822 | 17042 | 0 | 48.6616 | 9.3501 | 2022-09-12 04:20:58 | Baden-Wurttemberg, Germany | |||
3824346 | 3824346 | 2022-09-10 | Germany | Baden-Wurttemberg | 4412822 | 17042 | 0 | 48.6616 | 9.3501 | 2022-09-11 04:20:50 | Baden-Wurttemberg, Germany | |||
962803 | 962803 | 2022-09-09 | Germany | Baden-Wurttemberg | 4412822 | 17042 | 0 | 48.6616 | 9.3501 | 2022-09-10 04:21:10 | Baden-Wurttemberg, Germany | |||
253205 | 253205 | 2022-09-08 | Germany | Baden-Wurttemberg | 4409439 | 17026 | 0 | 48.6616 | 9.3501 | 2022-09-09 04:21:11 | Baden-Wurttemberg, Germany | |||
3745003 | 3745003 | 2022-09-07 | Germany | Baden-Wurttemberg | 4405259 | 17021 | 0 | 48.6616 | 9.3501 | 2022-09-08 04:21:02 | Baden-Wurttemberg, Germany | |||
114643 | 114643 | 2022-09-06 | Germany | Baden-Wurttemberg | 4400998 | 16999 | 0 | 48.6616 | 9.3501 | 2022-09-07 04:20:59 | Baden-Wurttemberg, Germany | |||
2633615 | 2633615 | 2022-09-05 | Germany | Baden-Wurttemberg | 4396339 | 16988 | 0 | 48.6616 | 9.3501 | 2022-09-06 04:21:02 | Baden-Wurttemberg, Germany | |||
2987179 | 2987179 | 2022-09-04 | Germany | Baden-Wurttemberg | 4393841 | 16978 | 0 | 48.6616 | 9.3501 | 2022-09-05 04:21:01 | Baden-Wurttemberg, Germany | |||
2712864 | 2712864 | 2022-09-03 | Germany | Baden-Wurttemberg | 4393841 | 16978 | 0 | 48.6616 | 9.3501 | 2022-09-04 04:21:22 | Baden-Wurttemberg, Germany | |||
1393569 | 1393569 | 2022-09-02 | Germany | Baden-Wurttemberg | 4393841 | 16978 | 0 | 48.6616 | 9.3501 | 2022-09-03 04:21:04 | Baden-Wurttemberg, Germany | |||
3547398 | 3547398 | 2022-09-01 | Germany | Baden-Wurttemberg | 4390666 | 16943 | 0 | 48.6616 | 9.3501 | 2022-09-02 04:21:07 | Baden-Wurttemberg, Germany | |||
2343318 | 2343318 | 2022-08-31 | Germany | Baden-Wurttemberg | 4386248 | 16933 | 0 | 48.6616 | 9.3501 | 2022-09-01 04:21:03 | Baden-Wurttemberg, Germany | |||
3773798 | 3773798 | 2022-08-30 | Germany | Baden-Wurttemberg | 4381851 | 16915 | 0 | 48.6616 | 9.3501 | 2022-08-31 04:20:57 | Baden-Wurttemberg, Germany | |||
1680394 | 1680394 | 2022-08-29 | Germany | Baden-Wurttemberg | 4376755 | 16901 | 0 | 48.6616 | 9.3501 | 2022-08-30 04:21:03 | Baden-Wurttemberg, Germany | |||
1876878 | 1876878 | 2022-08-28 | Germany | Baden-Wurttemberg | 4374080 | 16893 | 0 | 48.6616 | 9.3501 | 2022-08-29 04:21:06 | Baden-Wurttemberg, Germany | |||
2096005 | 2096005 | 2022-08-27 | Germany | Baden-Wurttemberg | 4374080 | 16893 | 0 | 48.6616 | 9.3501 | 2022-08-28 04:21:02 | Baden-Wurttemberg, Germany | |||
1531820 | 1531820 | 2022-08-26 | Germany | Baden-Wurttemberg | 4374080 | 16893 | 0 | 48.6616 | 9.3501 | 2022-08-27 04:20:57 | Baden-Wurttemberg, Germany | |||
2828707 | 2828707 | 2022-08-25 | Germany | Baden-Wurttemberg | 4370737 | 16886 | 0 | 48.6616 | 9.3501 | 2022-08-26 04:21:02 | Baden-Wurttemberg, Germany | |||
2323240 | 2323240 | 2022-08-24 | Germany | Baden-Wurttemberg | 4366032 | 16877 | 0 | 48.6616 | 9.3501 | 2022-08-25 04:21:13 | Baden-Wurttemberg, Germany | |||
1250649 | 1250649 | 2022-08-23 | Germany | Baden-Wurttemberg | 4361126 | 16864 | 0 | 48.6616 | 9.3501 | 2022-08-24 04:20:46 | Baden-Wurttemberg, Germany | |||
2852753 | 2852753 | 2022-08-22 | Germany | Baden-Wurttemberg | 4355458 | 16852 | 0 | 48.6616 | 9.3501 | 2022-08-23 04:20:56 | Baden-Wurttemberg, Germany | |||
2402725 | 2402725 | 2022-08-21 | Germany | Baden-Wurttemberg | 4352097 | 16841 | 0 | 48.6616 | 9.3501 | 2022-08-22 04:20:38 | Baden-Wurttemberg, Germany | |||
3797803 | 3797803 | 2022-08-20 | Germany | Baden-Wurttemberg | 4352097 | 16841 | 0 | 48.6616 | 9.3501 | 2022-08-21 04:20:44 | Baden-Wurttemberg, Germany | |||
2363389 | 2363389 | 2022-08-19 | Germany | Baden-Wurttemberg | 4352097 | 16841 | 0 | 48.6616 | 9.3501 | 2022-08-20 04:21:01 | Baden-Wurttemberg, Germany | |||
1161060 | 1161060 | 2022-08-18 | Germany | Baden-Wurttemberg | 4347811 | 16830 | 0 | 48.6616 | 9.3501 | 2022-08-19 04:20:54 | Baden-Wurttemberg, Germany | |||
3950384 | 3950384 | 2022-08-17 | Germany | Baden-Wurttemberg | 4342611 | 16800 | 0 | 48.6616 | 9.3501 | 2022-08-18 04:21:11 | Baden-Wurttemberg, Germany | |||
990886 | 990886 | 2022-08-16 | Germany | Baden-Wurttemberg | 4336379 | 16764 | 0 | 48.6616 | 9.3501 | 2022-08-17 04:20:59 | Baden-Wurttemberg, Germany | |||
2493925 | 2493925 | 2022-08-15 | Germany | Baden-Wurttemberg | 4329219 | 16754 | 0 | 48.6616 | 9.3501 | 2022-08-16 04:20:58 | Baden-Wurttemberg, Germany | |||
3647475 | 3647475 | 2022-08-14 | Germany | Baden-Wurttemberg | 4324784 | 16744 | 0 | 48.6616 | 9.3501 | 2022-08-15 04:20:59 | Baden-Wurttemberg, Germany | |||
1968481 | 1968481 | 2022-08-13 | Germany | Baden-Wurttemberg | 4324784 | 16744 | 0 | 48.6616 | 9.3501 | 2022-08-14 04:20:55 | Baden-Wurttemberg, Germany | |||
2888290 | 2888290 | 2022-08-12 | Germany | Baden-Wurttemberg | 4324784 | 16744 | 0 | 48.6616 | 9.3501 | 2022-08-13 04:20:52 | Baden-Wurttemberg, Germany | |||
3907895 | 3907895 | 2022-08-11 | Germany | Baden-Wurttemberg | 4319837 | 16735 | 0 | 48.6616 | 9.3501 | 2022-08-12 04:20:54 | Baden-Wurttemberg, Germany | |||
1346212 | 1346212 | 2022-08-10 | Germany | Baden-Wurttemberg | 4312962 | 16721 | 0 | 48.6616 | 9.3501 | 2022-08-11 04:20:49 | Baden-Wurttemberg, Germany | |||
1085967 | 1085967 | 2022-08-09 | Germany | Baden-Wurttemberg | 4304756 | 16711 | 0 | 48.6616 | 9.3501 | 2022-08-10 04:20:57 | Baden-Wurttemberg, Germany | |||
3543382 | 3543382 | 2022-08-08 | Germany | Baden-Wurttemberg | 4294748 | 16698 | 0 | 48.6616 | 9.3501 | 2022-08-09 04:20:34 | Baden-Wurttemberg, Germany | |||
1069785 | 1069785 | 2022-08-07 | Germany | Baden-Wurttemberg | 4286725 | 16680 | 0 | 48.6616 | 9.3501 | 2022-08-08 04:21:08 | Baden-Wurttemberg, Germany | |||
1940373 | 1940373 | 2022-08-06 | Germany | Baden-Wurttemberg | 4286725 | 16680 | 0 | 48.6616 | 9.3501 | 2022-08-07 04:20:54 | Baden-Wurttemberg, Germany | |||
880172 | 880172 | 2022-08-05 | Germany | Baden-Wurttemberg | 4286725 | 16680 | 0 | 48.6616 | 9.3501 | 2022-08-06 04:20:56 | Baden-Wurttemberg, Germany | |||
2008583 | 2008583 | 2022-08-04 | Germany | Baden-Wurttemberg | 4278700 | 16667 | 0 | 48.6616 | 9.3501 | 2022-08-05 04:20:52 | Baden-Wurttemberg, Germany | |||
1098010 | 1098010 | 2022-08-03 | Germany | Baden-Wurttemberg | 4268429 | 16646 | 0 | 48.6616 | 9.3501 | 2022-08-04 04:20:58 | Baden-Wurttemberg, Germany | |||
1404935 | 1404935 | 2022-08-02 | Germany | Baden-Wurttemberg | 4257420 | 16628 | 0 | 48.6616 | 9.3501 | 2022-08-03 04:20:59 | Baden-Wurttemberg, Germany | |||
3616973 | 3616973 | 2022-08-01 | Germany | Baden-Wurttemberg | 4242243 | 16607 | 0 | 48.6616 | 9.3501 | 2022-08-02 04:20:53 | Baden-Wurttemberg, Germany | |||
3871453 | 3871453 | 2022-07-31 | Germany | Baden-Wurttemberg | 4232208 | 16587 | 0 | 48.6616 | 9.3501 | 2022-08-01 04:21:03 | Baden-Wurttemberg, Germany | |||
674207 | 674207 | 2022-07-30 | Germany | Baden-Wurttemberg | 4232208 | 16587 | 0 | 48.6616 | 9.3501 | 2022-07-31 04:21:02 | Baden-Wurttemberg, Germany | |||
1783406 | 1783406 | 2022-07-29 | Germany | Baden-Wurttemberg | 4232208 | 16587 | 0 | 48.6616 | 9.3501 | 2022-07-30 04:20:42 | Baden-Wurttemberg, Germany | |||
1065769 | 1065769 | 2022-07-28 | Germany | Baden-Wurttemberg | 4219824 | 16565 | 0 | 48.6616 | 9.3501 | 2022-07-29 04:20:45 | Baden-Wurttemberg, Germany | |||
2335288 | 2335288 | 2022-07-27 | Germany | Baden-Wurttemberg | 4204160 | 16554 | 0 | 48.6616 | 9.3501 | 2022-07-28 04:20:56 | Baden-Wurttemberg, Germany | |||
1487478 | 1487478 | 2022-07-26 | Germany | Baden-Wurttemberg | 4185802 | 16528 | 0 | 48.6616 | 9.3501 | 2022-07-27 04:21:04 | Baden-Wurttemberg, Germany | |||
2593924 | 2593924 | 2022-07-25 | Germany | Baden-Wurttemberg | 4164226 | 16514 | 0 | 48.6616 | 9.3501 | 2022-07-26 04:20:58 | Baden-Wurttemberg, Germany | |||
896039 | 896039 | 2022-07-24 | Germany | Baden-Wurttemberg | 4150369 | 16504 | 0 | 48.6616 | 9.3501 | 2022-07-25 04:20:51 | Baden-Wurttemberg, Germany | |||
91033 | 91033 | 2022-07-23 | Germany | Baden-Wurttemberg | 4150369 | 16504 | 0 | 48.6616 | 9.3501 | 2022-07-24 04:20:47 | Baden-Wurttemberg, Germany | |||
900055 | 900055 | 2022-07-22 | Germany | Baden-Wurttemberg | 4150369 | 16504 | 0 | 48.6616 | 9.3501 | 2022-07-23 04:20:53 | Baden-Wurttemberg, Germany | |||
670191 | 670191 | 2022-07-21 | Germany | Baden-Wurttemberg | 4133391 | 16492 | 0 | 48.6616 | 9.3501 | 2022-07-22 04:21:15 | Baden-Wurttemberg, Germany | |||
1608154 | 1608154 | 2022-07-20 | Germany | Baden-Wurttemberg | 4114632 | 16481 | 0 | 48.6616 | 9.3501 | 2022-07-21 04:21:10 | Baden-Wurttemberg, Germany | |||
958787 | 958787 | 2022-07-19 | Germany | Baden-Wurttemberg | 4092867 | 16472 | 0 | 48.6616 | 9.3501 | 2022-07-20 04:20:59 | Baden-Wurttemberg, Germany | |||
3210174 | 3210174 | 2022-07-18 | Germany | Baden-Wurttemberg | 4068966 | 16473 | 0 | 48.6616 | 9.3501 | 2022-07-19 04:20:58 | Baden-Wurttemberg, Germany | |||
3405349 | 3405349 | 2022-07-17 | Germany | Baden-Wurttemberg | 4047674 | 16456 | 0 | 48.6616 | 9.3501 | 2022-07-18 04:20:59 | Baden-Wurttemberg, Germany | |||
2151549 | 2151549 | 2022-07-16 | Germany | Baden-Wurttemberg | 4047674 | 16456 | 0 | 48.6616 | 9.3501 | 2022-07-17 04:21:15 | Baden-Wurttemberg, Germany | |||
2418782 | 2418782 | 2022-07-15 | Germany | Baden-Wurttemberg | 4047674 | 16456 | 0 | 48.6616 | 9.3501 | 2022-07-16 04:21:05 | Baden-Wurttemberg, Germany | |||
3428857 | 3428857 | 2022-07-14 | Germany | Baden-Wurttemberg | 4033937 | 16455 | 0 | 48.6616 | 9.3501 | 2022-07-15 04:20:53 | Baden-Wurttemberg, Germany | |||
3109377 | 3109377 | 2022-07-13 | Germany | Baden-Wurttemberg | 4011339 | 16428 | 0 | 48.6616 | 9.3501 | 2022-07-14 04:20:57 | Baden-Wurttemberg, Germany | |||
629800 | 629800 | 2022-07-12 | Germany | Baden-Wurttemberg | 3990614 | 16419 | 0 | 48.6616 | 9.3501 | 2022-07-13 04:20:58 | Baden-Wurttemberg, Germany | |||
1211444 | 1211444 | 2022-07-11 | Germany | Baden-Wurttemberg | 3969904 | 16407 | 0 | 48.6616 | 9.3501 | 2022-07-12 04:20:51 | Baden-Wurttemberg, Germany | |||
2788926 | 2788926 | 2022-07-10 | Germany | Baden-Wurttemberg | 3954862 | 16393 | 0 | 48.6616 | 9.3501 | 2022-07-11 04:20:46 | Baden-Wurttemberg, Germany | |||
141879 | 141879 | 2022-07-09 | Germany | Baden-Wurttemberg | 3954862 | 16393 | 0 | 48.6616 | 9.3501 | 2022-07-10 04:20:54 | Baden-Wurttemberg, Germany | |||
1416979 | 1416979 | 2022-07-08 | Germany | Baden-Wurttemberg | 3954862 | 16393 | 0 | 48.6616 | 9.3501 | 2022-07-09 04:20:59 | Baden-Wurttemberg, Germany | |||
2740904 | 2740904 | 2022-07-07 | Germany | Baden-Wurttemberg | 3938397 | 16384 | 0 | 48.6616 | 9.3501 | 2022-07-08 04:20:56 | Baden-Wurttemberg, Germany | |||
1199699 | 1199699 | 2022-07-06 | Germany | Baden-Wurttemberg | 3920672 | 16377 | 0 | 48.6616 | 9.3501 | 2022-07-07 04:20:55 | Baden-Wurttemberg, Germany | |||
3966442 | 3966442 | 2022-07-05 | Germany | Baden-Wurttemberg | 3903019 | 16365 | 0 | 48.6616 | 9.3501 | 2022-07-06 04:20:58 | Baden-Wurttemberg, Germany | |||
3077953 | 3077953 | 2022-07-04 | Germany | Baden-Wurttemberg | 3884792 | 16354 | 0 | 48.6616 | 9.3501 | 2022-07-05 04:20:45 | Baden-Wurttemberg, Germany | |||
1767235 | 1767235 | 2022-07-03 | Germany | Baden-Wurttemberg | 3873564 | 16344 | 0 | 48.6616 | 9.3501 | 2022-07-04 04:20:54 | Baden-Wurttemberg, Germany | |||
3365221 | 3365221 | 2022-07-02 | Germany | Baden-Wurttemberg | 3873564 | 16344 | 0 | 48.6616 | 9.3501 | 2022-07-03 04:20:59 | Baden-Wurttemberg, Germany | |||
593550 | 593550 | 2022-07-01 | Germany | Baden-Wurttemberg | 3873564 | 16344 | 0 | 48.6616 | 9.3501 | 2022-07-02 04:21:16 | Baden-Wurttemberg, Germany | |||
3939951 | 3939951 | 2022-06-30 | Germany | Baden-Wurttemberg | 3860465 | 16332 | 0 | 48.6616 | 9.3501 | 2022-07-01 04:21:10 | Baden-Wurttemberg, Germany | |||
2489909 | 2489909 | 2022-06-29 | Germany | Baden-Wurttemberg | 3845449 | 16323 | 0 | 48.6616 | 9.3501 | 2022-06-30 04:21:01 | Baden-Wurttemberg, Germany | |||
2239291 | 2239291 | 2022-06-28 | Germany | Baden-Wurttemberg | 3830851 | 16294 | 0 | 48.6616 | 9.3501 | 2022-06-29 04:20:59 | Baden-Wurttemberg, Germany | |||
2147533 | 2147533 | 2022-06-27 | Germany | Baden-Wurttemberg | 3815110 | 16269 | 0 | 48.6616 | 9.3501 | 2022-06-28 04:20:58 | Baden-Wurttemberg, Germany | |||
475334 | 475334 | 2022-06-26 | Germany | Baden-Wurttemberg | 3806419 | 16263 | 0 | 48.6616 | 9.3501 | 2022-06-27 04:21:00 | Baden-Wurttemberg, Germany | |||
938709 | 938709 | 2022-06-25 | Germany | Baden-Wurttemberg | 3806419 | 16263 | 0 | 48.6616 | 9.3501 | 2022-06-26 04:21:02 | Baden-Wurttemberg, Germany | |||
3346529 | 3346529 | 2022-06-24 | Germany | Baden-Wurttemberg | 3806419 | 16263 | 0 | 48.6616 | 9.3501 | 2022-06-25 04:20:57 | Baden-Wurttemberg, Germany | |||
1648270 | 1648270 | 2022-06-23 | Germany | Baden-Wurttemberg | 3794363 | 16255 | 0 | 48.6616 | 9.3501 | 2022-06-24 04:20:58 | Baden-Wurttemberg, Germany | |||
2187505 | 2187505 | 2022-06-22 | Germany | Baden-Wurttemberg | 3782610 | 16248 | 0 | 48.6616 | 9.3501 | 2022-06-23 04:20:55 | Baden-Wurttemberg, Germany | |||
165936 | 165936 | 2022-06-21 | Germany | Baden-Wurttemberg | 3768735 | 16239 | 0 | 48.6616 | 9.3501 | 2022-06-22 04:20:54 | Baden-Wurttemberg, Germany | |||
1763219 | 1763219 | 2022-06-20 | Germany | Baden-Wurttemberg | 3756405 | 16225 | 0 | 48.6616 | 9.3501 | 2022-06-21 04:20:56 | Baden-Wurttemberg, Germany | |||
3269405 | 3269405 | 2022-06-19 | Germany | Baden-Wurttemberg | 3747115 | 16219 | 0 | 48.6616 | 9.3501 | 2022-06-20 04:21:01 | Baden-Wurttemberg, Germany | |||
3397317 | 3397317 | 2022-06-18 | Germany | Baden-Wurttemberg | 3747115 | 16219 | 0 | 48.6616 | 9.3501 | 2022-06-19 04:20:51 | Baden-Wurttemberg, Germany | |||
2311194 | 2311194 | 2022-06-17 | Germany | Baden-Wurttemberg | 3747115 | 16219 | 0 | 48.6616 | 9.3501 | 2022-06-18 04:21:10 | Baden-Wurttemberg, Germany | |||
558698 | 558698 | 2022-06-16 | Germany | Baden-Wurttemberg | 3747115 | 16219 | 0 | 48.6616 | 9.3501 | 2022-06-17 04:20:56 | Baden-Wurttemberg, Germany | |||
3982500 | 3982500 | 2022-06-15 | Germany | Baden-Wurttemberg | 3739088 | 16209 | 0 | 48.6616 | 9.3501 | 2022-06-16 04:20:55 | Baden-Wurttemberg, Germany | |||
946741 | 946741 | 2022-06-14 | Germany | Baden-Wurttemberg | 3730539 | 16199 | 0 | 48.6616 | 9.3501 | 2022-06-15 04:20:54 | Baden-Wurttemberg, Germany | |||
2979149 | 2979149 | 2022-06-13 | Germany | Baden-Wurttemberg | 3720283 | 16188 | 0 | 48.6616 | 9.3501 | 2022-06-14 04:20:52 | Baden-Wurttemberg, 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]);