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 = "Sachsen-Anhalt" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533302 | 2533302 | 2022-05-12 | Germany | Sachsen-Anhalt | 706013 | 5293 | 0 | 51.9503 | 11.6923 | 2022-05-13 04:20:51 | Sachsen-Anhalt, Germany | |||
3444748 | 3444748 | 2022-05-11 | Germany | Sachsen-Anhalt | 704492 | 5287 | 0 | 51.9503 | 11.6923 | 2022-05-12 04:20:54 | Sachsen-Anhalt, Germany | |||
3535365 | 3535365 | 2022-05-10 | Germany | Sachsen-Anhalt | 702835 | 5285 | 0 | 51.9503 | 11.6923 | 2022-05-11 04:20:48 | Sachsen-Anhalt, Germany | |||
221900 | 221900 | 2022-05-09 | Germany | Sachsen-Anhalt | 701141 | 5282 | 0 | 51.9503 | 11.6923 | 2022-05-10 04:20:50 | Sachsen-Anhalt, Germany | |||
2331285 | 2331285 | 2022-05-08 | Germany | Sachsen-Anhalt | 699429 | 5275 | 0 | 51.9503 | 11.6923 | 2022-05-09 04:20:54 | Sachsen-Anhalt, Germany | |||
360247 | 360247 | 2022-05-07 | Germany | Sachsen-Anhalt | 699429 | 5275 | 0 | 51.9503 | 11.6923 | 2022-05-08 04:20:49 | Sachsen-Anhalt, Germany | |||
1397598 | 1397598 | 2022-05-06 | Germany | Sachsen-Anhalt | 699429 | 5275 | 0 | 51.9503 | 11.6923 | 2022-05-07 04:21:09 | Sachsen-Anhalt, Germany | |||
2597953 | 2597953 | 2022-05-05 | Germany | Sachsen-Anhalt | 697741 | 5268 | 0 | 51.9503 | 11.6923 | 2022-05-06 04:21:00 | Sachsen-Anhalt, Germany | |||
3265402 | 3265402 | 2022-05-04 | Germany | Sachsen-Anhalt | 695476 | 5265 | 0 | 51.9503 | 11.6923 | 2022-05-05 04:20:55 | Sachsen-Anhalt, Germany | |||
1572041 | 1572041 | 2022-05-03 | Germany | Sachsen-Anhalt | 693601 | 5256 | 0 | 51.9503 | 11.6923 | 2022-05-04 04:20:59 | Sachsen-Anhalt, Germany | |||
463301 | 463301 | 2022-05-02 | Germany | Sachsen-Anhalt | 691695 | 5254 | 0 | 51.9503 | 11.6923 | 2022-05-03 04:21:00 | Sachsen-Anhalt, Germany | |||
3915940 | 3915940 | 2022-05-01 | Germany | Sachsen-Anhalt | 689114 | 5248 | 0 | 51.9503 | 11.6923 | 2022-05-02 04:21:10 | Sachsen-Anhalt, Germany | |||
2840744 | 2840744 | 2022-04-30 | Germany | Sachsen-Anhalt | 689114 | 5248 | 0 | 51.9503 | 11.6923 | 2022-05-01 04:20:57 | Sachsen-Anhalt, Germany | |||
1157057 | 1157057 | 2022-04-29 | Germany | Sachsen-Anhalt | 689114 | 5248 | 0 | 51.9503 | 11.6923 | 2022-04-30 04:21:05 | Sachsen-Anhalt, Germany | |||
1696239 | 1696239 | 2022-04-28 | Germany | Sachsen-Anhalt | 686932 | 5247 | 0 | 51.9503 | 11.6923 | 2022-04-29 04:20:59 | Sachsen-Anhalt, Germany | |||
3851722 | 3851722 | 2022-04-27 | Germany | Sachsen-Anhalt | 684102 | 5228 | 0 | 51.9503 | 11.6923 | 2022-04-28 04:20:47 | Sachsen-Anhalt, Germany | |||
1326152 | 1326152 | 2022-04-26 | Germany | Sachsen-Anhalt | 681481 | 5211 | 0 | 51.9503 | 11.6923 | 2022-04-27 04:20:52 | Sachsen-Anhalt, Germany | |||
3722106 | 3722106 | 2022-04-25 | Germany | Sachsen-Anhalt | 678455 | 5208 | 0 | 51.9503 | 11.6923 | 2022-04-26 04:20:51 | Sachsen-Anhalt, Germany | |||
2028674 | 2028674 | 2022-04-24 | Germany | Sachsen-Anhalt | 673923 | 5191 | 0 | 51.9503 | 11.6923 | 2022-04-25 04:20:56 | Sachsen-Anhalt, Germany | |||
746249 | 746249 | 2022-04-23 | Germany | Sachsen-Anhalt | 673923 | 5191 | 0 | 51.9503 | 11.6923 | 2022-04-24 04:20:56 | Sachsen-Anhalt, Germany | |||
3436734 | 3436734 | 2022-04-22 | Germany | Sachsen-Anhalt | 673923 | 5191 | 0 | 51.9503 | 11.6923 | 2022-04-23 04:20:50 | Sachsen-Anhalt, Germany | |||
2892319 | 2892319 | 2022-04-21 | Germany | Sachsen-Anhalt | 668872 | 5177 | 0 | 51.9503 | 11.6923 | 2022-04-22 04:20:45 | Sachsen-Anhalt, Germany | |||
2307191 | 2307191 | 2022-04-20 | Germany | Sachsen-Anhalt | 664318 | 5162 | 0 | 51.9503 | 11.6923 | 2022-04-21 04:20:46 | Sachsen-Anhalt, Germany | |||
2251330 | 2251330 | 2022-04-19 | Germany | Sachsen-Anhalt | 660143 | 5151 | 0 | 51.9503 | 11.6923 | 2022-04-20 04:20:45 | Sachsen-Anhalt, Germany | |||
1845880 | 1845880 | 2022-04-18 | Germany | Sachsen-Anhalt | 653907 | 5138 | 0 | 51.9503 | 11.6923 | 2022-04-19 04:21:00 | Sachsen-Anhalt, Germany | |||
3416824 | 3416824 | 2022-04-17 | Germany | Sachsen-Anhalt | 653907 | 5138 | 0 | 51.9503 | 11.6923 | 2022-04-18 04:21:12 | Sachsen-Anhalt, Germany | |||
303773 | 303773 | 2022-04-16 | Germany | Sachsen-Anhalt | 653907 | 5138 | 0 | 51.9503 | 11.6923 | 2022-04-17 04:20:59 | Sachsen-Anhalt, Germany | |||
2669718 | 2669718 | 2022-04-15 | Germany | Sachsen-Anhalt | 653907 | 5138 | 0 | 51.9503 | 11.6923 | 2022-04-16 04:20:48 | Sachsen-Anhalt, Germany | |||
1223503 | 1223503 | 2022-04-14 | Germany | Sachsen-Anhalt | 653907 | 5138 | 0 | 51.9503 | 11.6923 | 2022-04-15 04:20:57 | Sachsen-Anhalt, Germany | |||
2442661 | 2442661 | 2022-04-13 | Germany | Sachsen-Anhalt | 649514 | 5125 | 0 | 51.9503 | 11.6923 | 2022-04-13 23:21:06 | Sachsen-Anhalt, Germany | |||
1948418 | 1948418 | 2022-04-12 | Germany | Sachsen-Anhalt | 645832 | 5113 | 0 | 51.9503 | 11.6923 | 2022-04-13 04:21:03 | Sachsen-Anhalt, Germany | |||
3206171 | 3206171 | 2022-04-11 | Germany | Sachsen-Anhalt | 642117 | 5108 | 0 | 51.9503 | 11.6923 | 2022-04-12 04:20:49 | Sachsen-Anhalt, Germany | |||
1576057 | 1576057 | 2022-04-10 | Germany | Sachsen-Anhalt | 636361 | 5083 | 0 | 51.9503 | 11.6923 | 2022-04-11 04:21:02 | Sachsen-Anhalt, Germany | |||
1652299 | 1652299 | 2022-04-09 | Germany | Sachsen-Anhalt | 636361 | 5083 | 0 | 51.9503 | 11.6923 | 2022-04-10 04:20:52 | Sachsen-Anhalt, Germany | |||
2115621 | 2115621 | 2022-04-08 | Germany | Sachsen-Anhalt | 636361 | 5083 | 0 | 51.9503 | 11.6923 | 2022-04-09 04:20:42 | Sachsen-Anhalt, Germany | |||
3320145 | 3320145 | 2022-04-07 | Germany | Sachsen-Anhalt | 632230 | 5071 | 0 | 51.9503 | 11.6923 | 2022-04-08 04:20:48 | Sachsen-Anhalt, Germany | |||
2800681 | 2800681 | 2022-04-06 | Germany | Sachsen-Anhalt | 626624 | 5057 | 0 | 51.9503 | 11.6923 | 2022-04-07 04:20:53 | Sachsen-Anhalt, Germany | |||
3867450 | 3867450 | 2022-04-05 | Germany | Sachsen-Anhalt | 622320 | 5035 | 0 | 51.9503 | 11.6923 | 2022-04-06 04:20:49 | Sachsen-Anhalt, Germany | |||
2748792 | 2748792 | 2022-04-04 | Germany | Sachsen-Anhalt | 618276 | 5028 | 0 | 51.9503 | 11.6923 | 2022-04-05 04:20:48 | Sachsen-Anhalt, Germany | |||
3730138 | 3730138 | 2022-04-03 | Germany | Sachsen-Anhalt | 609580 | 5008 | 0 | 51.9503 | 11.6923 | 2022-04-04 04:20:51 | Sachsen-Anhalt, Germany | |||
499573 | 499573 | 2022-04-02 | Germany | Sachsen-Anhalt | 609580 | 5008 | 0 | 51.9503 | 11.6923 | 2022-04-03 04:20:48 | Sachsen-Anhalt, Germany | |||
3350558 | 3350558 | 2022-04-01 | Germany | Sachsen-Anhalt | 609580 | 5008 | 0 | 51.9503 | 11.6923 | 2022-04-02 04:20:47 | Sachsen-Anhalt, Germany | |||
1539863 | 1539863 | 2022-03-31 | Germany | Sachsen-Anhalt | 602868 | 5000 | 0 | 51.9503 | 11.6923 | 2022-04-01 04:20:28 | Sachsen-Anhalt, Germany | |||
2477876 | 2477876 | 2022-03-30 | Germany | Sachsen-Anhalt | 595290 | 4988 | 0 | 51.9503 | 11.6923 | 2022-03-31 04:20:56 | Sachsen-Anhalt, Germany | |||
157917 | 157917 | 2022-03-29 | Germany | Sachsen-Anhalt | 588498 | 4979 | 0 | 51.9503 | 11.6923 | 2022-03-30 04:20:45 | Sachsen-Anhalt, Germany | |||
1436488 | 1436488 | 2022-03-28 | Germany | Sachsen-Anhalt | 583352 | 4972 | 0 | 51.9503 | 11.6923 | 2022-03-26 23:20:45 | Sachsen-Anhalt, Germany | |||
876169 | 876169 | 2022-03-27 | Germany | Sachsen-Anhalt | 568629 | 4963 | 0 | 51.9503 | 11.6923 | 2022-03-26 23:20:45 | Sachsen-Anhalt, Germany | |||
2163452 | 2163452 | 2022-03-26 | Germany | Sachsen-Anhalt | 568629 | 4963 | 0 | 51.9503 | 11.6923 | 2022-03-26 23:20:45 | Sachsen-Anhalt, Germany | |||
1720388 | 1720388 | 2022-03-25 | Germany | Sachsen-Anhalt | 568629 | 4963 | 0 | 51.9503 | 11.6923 | 2022-03-26 04:20:23 | Sachsen-Anhalt, Germany | |||
1468005 | 1468005 | 2022-03-24 | Germany | Sachsen-Anhalt | 560079 | 4943 | 0 | 51.9503 | 11.6923 | 2022-03-25 04:20:46 | Sachsen-Anhalt, Germany | |||
3022179 | 3022179 | 2022-03-23 | Germany | Sachsen-Anhalt | 550437 | 4925 | 0 | 51.9503 | 11.6923 | 2022-03-24 04:20:43 | Sachsen-Anhalt, Germany | |||
1905101 | 1905101 | 2022-03-22 | Germany | Sachsen-Anhalt | 542576 | 4911 | 0 | 51.9503 | 11.6923 | 2022-03-23 04:20:48 | Sachsen-Anhalt, Germany | |||
3238232 | 3238232 | 2022-03-21 | Germany | Sachsen-Anhalt | 537448 | 4907 | 0 | 51.9503 | 11.6923 | 2022-03-22 04:20:54 | Sachsen-Anhalt, Germany | |||
24305 | 24305 | 2022-03-20 | Germany | Sachsen-Anhalt | 520699 | 4895 | 0 | 51.9503 | 11.6923 | 2022-03-21 04:20:50 | Sachsen-Anhalt, Germany | |||
1656315 | 1656315 | 2022-03-19 | Germany | Sachsen-Anhalt | 520699 | 4895 | 0 | 51.9503 | 11.6923 | 2022-03-20 04:20:45 | Sachsen-Anhalt, Germany | |||
335841 | 335841 | 2022-03-18 | Germany | Sachsen-Anhalt | 520699 | 4895 | 0 | 51.9503 | 11.6923 | 2022-03-19 04:20:47 | Sachsen-Anhalt, Germany | |||
694294 | 694294 | 2022-03-17 | Germany | Sachsen-Anhalt | 512338 | 4881 | 0 | 51.9503 | 11.6923 | 2022-03-18 04:20:55 | Sachsen-Anhalt, Germany | |||
2319237 | 2319237 | 2022-03-16 | Germany | Sachsen-Anhalt | 502509 | 4873 | 0 | 51.9503 | 11.6923 | 2022-03-17 04:20:56 | Sachsen-Anhalt, Germany | |||
261437 | 261437 | 2022-03-15 | Germany | Sachsen-Anhalt | 496271 | 4867 | 0 | 51.9503 | 11.6923 | 2022-03-16 04:20:50 | Sachsen-Anhalt, Germany | |||
2263796 | 2263796 | 2022-03-14 | Germany | Sachsen-Anhalt | 489931 | 4859 | 0 | 51.9503 | 11.6923 | 2022-03-15 04:20:47 | Sachsen-Anhalt, Germany | |||
3627862 | 3627862 | 2022-03-13 | Germany | Sachsen-Anhalt | 473808 | 4829 | 0 | 51.9503 | 11.6923 | 2022-03-14 04:20:46 | Sachsen-Anhalt, Germany | |||
950770 | 950770 | 2022-03-12 | Germany | Sachsen-Anhalt | 473808 | 4829 | 0 | 51.9503 | 11.6923 | 2022-03-13 04:20:49 | Sachsen-Anhalt, Germany | |||
356231 | 356231 | 2022-03-11 | Germany | Sachsen-Anhalt | 473808 | 4829 | 0 | 51.9503 | 11.6923 | 2022-03-12 04:20:50 | Sachsen-Anhalt, Germany | |||
1865383 | 1865383 | 2022-03-10 | Germany | Sachsen-Anhalt | 465452 | 4815 | 0 | 51.9503 | 11.6923 | 2022-03-11 04:20:50 | Sachsen-Anhalt, Germany | |||
2140078 | 2140078 | 2022-03-09 | Germany | Sachsen-Anhalt | 457252 | 4810 | 0 | 51.9503 | 11.6923 | 2022-03-10 04:20:48 | Sachsen-Anhalt, Germany | |||
919589 | 919589 | 2022-03-08 | Germany | Sachsen-Anhalt | 446920 | 4792 | 0 | 51.9503 | 11.6923 | 2022-03-09 04:20:59 | Sachsen-Anhalt, Germany | |||
1547876 | 1547876 | 2022-03-07 | Germany | Sachsen-Anhalt | 446920 | 4792 | 0 | 51.9503 | 11.6923 | 2022-03-08 04:20:54 | Sachsen-Anhalt, Germany | |||
2199545 | 2199545 | 2022-03-06 | Germany | Sachsen-Anhalt | 433014 | 4780 | 0 | 51.9503 | 11.6923 | 2022-03-07 04:20:47 | Sachsen-Anhalt, Germany | |||
2092002 | 2092002 | 2022-03-05 | Germany | Sachsen-Anhalt | 433014 | 4780 | 0 | 51.9503 | 11.6923 | 2022-03-06 04:20:49 | Sachsen-Anhalt, Germany | |||
2665702 | 2665702 | 2022-03-04 | Germany | Sachsen-Anhalt | 433014 | 4780 | 0 | 51.9503 | 11.6923 | 2022-03-05 04:21:10 | Sachsen-Anhalt, Germany | |||
1644267 | 1644267 | 2022-03-03 | Germany | Sachsen-Anhalt | 425154 | 4770 | 0 | 51.9503 | 11.6923 | 2022-03-04 04:21:09 | Sachsen-Anhalt, Germany | |||
2525270 | 2525270 | 2022-03-02 | Germany | Sachsen-Anhalt | 416947 | 4761 | 0 | 51.9503 | 11.6923 | 2022-03-03 04:21:01 | Sachsen-Anhalt, Germany | |||
1992564 | 1992564 | 2022-03-01 | Germany | Sachsen-Anhalt | 412427 | 4754 | 0 | 51.9503 | 11.6923 | 2022-03-02 04:21:07 | Sachsen-Anhalt, Germany | |||
942738 | 942738 | 2022-02-28 | Germany | Sachsen-Anhalt | 408719 | 4745 | 0 | 51.9503 | 11.6923 | 2022-03-01 04:21:09 | Sachsen-Anhalt, Germany | |||
2732929 | 2732929 | 2022-02-27 | Germany | Sachsen-Anhalt | 393336 | 4732 | 0 | 51.9503 | 11.6923 | 2022-02-28 04:21:05 | Sachsen-Anhalt, Germany | |||
3046082 | 3046082 | 2022-02-26 | Germany | Sachsen-Anhalt | 393336 | 4732 | 0 | 51.9503 | 11.6923 | 2022-02-27 04:21:04 | Sachsen-Anhalt, Germany | |||
574737 | 574737 | 2022-02-25 | Germany | Sachsen-Anhalt | 393336 | 4732 | 0 | 51.9503 | 11.6923 | 2022-02-26 04:21:12 | Sachsen-Anhalt, Germany | |||
1511313 | 1511313 | 2022-02-24 | Germany | Sachsen-Anhalt | 385380 | 4726 | 0 | 51.9503 | 11.6923 | 2022-02-25 04:21:11 | Sachsen-Anhalt, Germany | |||
1057754 | 1057754 | 2022-02-23 | Germany | Sachsen-Anhalt | 376539 | 4719 | 0 | 51.9503 | 11.6923 | 2022-02-24 04:21:14 | Sachsen-Anhalt, Germany | |||
2446677 | 2446677 | 2022-02-22 | Germany | Sachsen-Anhalt | 370665 | 4707 | 0 | 51.9503 | 11.6923 | 2022-02-23 04:21:09 | Sachsen-Anhalt, Germany | |||
3718090 | 3718090 | 2022-02-21 | Germany | Sachsen-Anhalt | 367206 | 4706 | 0 | 51.9503 | 11.6923 | 2022-02-22 04:21:01 | Sachsen-Anhalt, Germany | |||
3911924 | 3911924 | 2022-02-20 | Germany | Sachsen-Anhalt | 354727 | 4699 | 0 | 51.9503 | 11.6923 | 2022-02-21 04:21:05 | Sachsen-Anhalt, Germany | |||
3875482 | 3875482 | 2022-02-19 | Germany | Sachsen-Anhalt | 354727 | 4699 | 0 | 51.9503 | 11.6923 | 2022-02-20 04:21:00 | Sachsen-Anhalt, Germany | |||
3855738 | 3855738 | 2022-02-18 | Germany | Sachsen-Anhalt | 354727 | 4699 | 0 | 51.9503 | 11.6923 | 2022-02-19 04:21:11 | Sachsen-Anhalt, Germany | |||
1297957 | 1297957 | 2022-02-17 | Germany | Sachsen-Anhalt | 347853 | 4691 | 0 | 51.9503 | 11.6923 | 2022-02-18 04:21:04 | Sachsen-Anhalt, Germany | |||
3820343 | 3820343 | 2022-02-16 | Germany | Sachsen-Anhalt | 340691 | 4684 | 0 | 51.9503 | 11.6923 | 2022-02-17 04:20:56 | Sachsen-Anhalt, Germany | |||
3671557 | 3671557 | 2022-02-15 | Germany | Sachsen-Anhalt | 335666 | 4678 | 0 | 51.9503 | 11.6923 | 2022-02-16 04:21:10 | Sachsen-Anhalt, Germany | |||
2641658 | 2641658 | 2022-02-14 | Germany | Sachsen-Anhalt | 330888 | 4671 | 0 | 51.9503 | 11.6923 | 2022-02-15 04:21:09 | Sachsen-Anhalt, Germany | |||
185975 | 185975 | 2022-02-13 | Germany | Sachsen-Anhalt | 317709 | 4663 | 0 | 51.9503 | 11.6923 | 2022-02-14 04:20:51 | Sachsen-Anhalt, Germany | |||
315821 | 315821 | 2022-02-12 | Germany | Sachsen-Anhalt | 317709 | 4663 | 0 | 51.9503 | 11.6923 | 2022-02-13 04:21:00 | Sachsen-Anhalt, Germany | |||
233147 | 233147 | 2022-02-11 | Germany | Sachsen-Anhalt | 317709 | 4663 | 0 | 51.9503 | 11.6923 | 2022-02-12 04:21:06 | Sachsen-Anhalt, Germany | |||
1463989 | 1463989 | 2022-02-10 | Germany | Sachsen-Anhalt | 310001 | 4654 | 0 | 51.9503 | 11.6923 | 2022-02-11 04:21:09 | Sachsen-Anhalt, Germany | |||
3073950 | 3073950 | 2022-02-09 | Germany | Sachsen-Anhalt | 302677 | 4641 | 0 | 51.9503 | 11.6923 | 2022-02-10 04:21:14 | Sachsen-Anhalt, Germany | |||
1362257 | 1362257 | 2022-02-08 | Germany | Sachsen-Anhalt | 297058 | 4633 | 0 | 51.9503 | 11.6923 | 2022-02-09 04:21:04 | Sachsen-Anhalt, Germany | |||
70995 | 70995 | 2022-02-07 | Germany | Sachsen-Anhalt | 293854 | 4630 | 0 | 51.9503 | 11.6923 | 2022-02-08 04:21:15 | Sachsen-Anhalt, Germany | |||
2012611 | 2012611 | 2022-02-06 | Germany | Sachsen-Anhalt | 283271 | 4623 | 0 | 51.9503 | 11.6923 | 2022-02-07 04:21:05 | Sachsen-Anhalt, Germany | |||
1293940 | 1293940 | 2022-02-05 | Germany | Sachsen-Anhalt | 283271 | 4623 | 0 | 51.9503 | 11.6923 | 2022-02-06 04:21:00 | Sachsen-Anhalt, Germany | |||
2327268 | 2327268 | 2022-02-04 | Germany | Sachsen-Anhalt | 283271 | 4623 | 0 | 51.9503 | 11.6923 | 2022-02-05 04:21:05 | Sachsen-Anhalt, Germany | |||
2473859 | 2473859 | 2022-02-03 | Germany | Sachsen-Anhalt | 278722 | 4613 | 0 | 51.9503 | 11.6923 | 2022-02-04 04:21:10 | Sachsen-Anhalt, Germany | |||
459284 | 459284 | 2022-02-02 | Germany | Sachsen-Anhalt | 272943 | 4606 | 0 | 51.9503 | 11.6923 | 2022-02-03 04:21:21 | Sachsen-Anhalt, 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]);