johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6,636 rows where country_or_region = "Pakistan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 7
- Gilgit-Baltistan 476
- Islamabad 476
- Khyber Pakhtunkhwa 476
- Punjab 476
- Sindh 476
- Azad Jammu and Kashmir 475
- Balochistan 475
country_or_region 1
- Pakistan · 3,435 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1334422 | 1334422 | 2021-09-28 | Pakistan | Gilgit-Baltistan | 10311 | 184 | 0 | 35.792146 | 74.982138 | 2021-09-29 04:21:45 | Gilgit-Baltistan, Pakistan | |||
1334423 | 1334423 | 2021-09-28 | Pakistan | Islamabad | 105287 | 922 | 0 | 33.665087 | 73.121219 | 2021-09-29 04:21:45 | Islamabad, Pakistan | |||
1334424 | 1334424 | 2021-09-28 | Pakistan | Khyber Pakhtunkhwa | 173548 | 5525 | 0 | 34.485332 | 72.09169 | 2021-09-29 04:21:45 | Khyber Pakhtunkhwa, Pakistan | |||
1334425 | 1334425 | 2021-09-28 | Pakistan | Punjab | 430353 | 12595 | 0 | 30.811346 | 72.13913199999998 | 2021-09-29 04:21:45 | Punjab, Pakistan | |||
1334426 | 1334426 | 2021-09-28 | Pakistan | Sindh | 456897 | 7379 | 0 | 26.009446 | 68.77680699999999 | 2021-09-29 04:21:45 | Sindh, Pakistan | |||
1235789 | 1235789 | 2021-09-27 | Pakistan | Azad Jammu and Kashmir | 34074 | 737 | 0 | 34.027401 | 73.947253 | 2021-09-28 04:21:28 | Azad Jammu and Kashmir, Pakistan | |||
1235790 | 1235790 | 2021-09-27 | Pakistan | Balochistan | 32875 | 348 | 0 | 28.328491999999997 | 65.898403 | 2021-09-28 04:21:28 | Balochistan, Pakistan | |||
1235791 | 1235791 | 2021-09-27 | Pakistan | Gilgit-Baltistan | 10308 | 184 | 0 | 35.792146 | 74.982138 | 2021-09-28 04:21:28 | Gilgit-Baltistan, Pakistan | |||
1235792 | 1235792 | 2021-09-27 | Pakistan | Islamabad | 105217 | 919 | 0 | 33.665087 | 73.121219 | 2021-09-28 04:21:28 | Islamabad, Pakistan | |||
1235793 | 1235793 | 2021-09-27 | Pakistan | Khyber Pakhtunkhwa | 173353 | 5514 | 0 | 34.485332 | 72.09169 | 2021-09-28 04:21:28 | Khyber Pakhtunkhwa, Pakistan | |||
1235794 | 1235794 | 2021-09-27 | Pakistan | Punjab | 429655 | 12575 | 0 | 30.811346 | 72.13913199999998 | 2021-09-28 04:21:28 | Punjab, Pakistan | |||
1235795 | 1235795 | 2021-09-27 | Pakistan | Sindh | 456343 | 7361 | 0 | 26.009446 | 68.77680699999999 | 2021-09-28 04:21:28 | Sindh, Pakistan | |||
2076090 | 2076090 | 2021-09-26 | Pakistan | Azad Jammu and Kashmir | 34046 | 735 | 0 | 34.027401 | 73.947253 | 2021-09-27 04:21:16 | Azad Jammu and Kashmir, Pakistan | |||
2076091 | 2076091 | 2021-09-26 | Pakistan | Balochistan | 32861 | 346 | 0 | 28.328491999999997 | 65.898403 | 2021-09-27 04:21:16 | Balochistan, Pakistan | |||
2076092 | 2076092 | 2021-09-26 | Pakistan | Gilgit-Baltistan | 10299 | 184 | 0 | 35.792146 | 74.982138 | 2021-09-27 04:21:16 | Gilgit-Baltistan, Pakistan | |||
2076093 | 2076093 | 2021-09-26 | Pakistan | Islamabad | 105120 | 916 | 0 | 33.665087 | 73.121219 | 2021-09-27 04:21:16 | Islamabad, Pakistan | |||
2076094 | 2076094 | 2021-09-26 | Pakistan | Khyber Pakhtunkhwa | 173210 | 5507 | 0 | 34.485332 | 72.09169 | 2021-09-27 04:21:16 | Khyber Pakhtunkhwa, Pakistan | |||
2076095 | 2076095 | 2021-09-26 | Pakistan | Punjab | 429081 | 12559 | 0 | 30.811346 | 72.13913199999998 | 2021-09-27 04:21:16 | Punjab, Pakistan | |||
2076096 | 2076096 | 2021-09-26 | Pakistan | Sindh | 455808 | 7350 | 0 | 26.009446 | 68.77680699999999 | 2021-09-27 04:21:16 | Sindh, Pakistan | |||
1724642 | 1724642 | 2021-09-25 | Pakistan | Azad Jammu and Kashmir | 34020 | 735 | 0 | 34.027401 | 73.947253 | 2021-09-26 04:21:29 | Azad Jammu and Kashmir, Pakistan | |||
1724643 | 1724643 | 2021-09-25 | Pakistan | Balochistan | 32849 | 346 | 0 | 28.328491999999997 | 65.898403 | 2021-09-26 04:21:29 | Balochistan, Pakistan | |||
1724644 | 1724644 | 2021-09-25 | Pakistan | Gilgit-Baltistan | 10296 | 184 | 0 | 35.792146 | 74.982138 | 2021-09-26 04:21:29 | Gilgit-Baltistan, Pakistan | |||
1724645 | 1724645 | 2021-09-25 | Pakistan | Islamabad | 105021 | 915 | 0 | 33.665087 | 73.121219 | 2021-09-26 04:21:29 | Islamabad, Pakistan | |||
1724646 | 1724646 | 2021-09-25 | Pakistan | Khyber Pakhtunkhwa | 173023 | 5498 | 0 | 34.485332 | 72.09169 | 2021-09-26 04:21:29 | Khyber Pakhtunkhwa, Pakistan | |||
1724647 | 1724647 | 2021-09-25 | Pakistan | Punjab | 428394 | 12553 | 0 | 30.811346 | 72.13913199999998 | 2021-09-26 04:21:29 | Punjab, Pakistan | |||
1724648 | 1724648 | 2021-09-25 | Pakistan | Sindh | 455065 | 7335 | 0 | 26.009446 | 68.77680699999999 | 2021-09-26 04:21:29 | Sindh, Pakistan | |||
1921362 | 1921362 | 2021-09-24 | Pakistan | Azad Jammu and Kashmir | 33990 | 734 | 0 | 34.027401 | 73.947253 | 2021-09-25 04:21:31 | Azad Jammu and Kashmir, Pakistan | |||
1921363 | 1921363 | 2021-09-24 | Pakistan | Balochistan | 32837 | 346 | 0 | 28.328491999999997 | 65.898403 | 2021-09-25 04:21:31 | Balochistan, Pakistan | |||
1921364 | 1921364 | 2021-09-24 | Pakistan | Gilgit-Baltistan | 10289 | 184 | 0 | 35.792146 | 74.982138 | 2021-09-25 04:21:31 | Gilgit-Baltistan, Pakistan | |||
1921365 | 1921365 | 2021-09-24 | Pakistan | Islamabad | 104913 | 910 | 0 | 33.665087 | 73.121219 | 2021-09-25 04:21:31 | Islamabad, Pakistan | |||
1921366 | 1921366 | 2021-09-24 | Pakistan | Khyber Pakhtunkhwa | 172766 | 5488 | 0 | 34.485332 | 72.09169 | 2021-09-25 04:21:31 | Khyber Pakhtunkhwa, Pakistan | |||
1921367 | 1921367 | 2021-09-24 | Pakistan | Punjab | 427583 | 12535 | 0 | 30.811346 | 72.13913199999998 | 2021-09-25 04:21:31 | Punjab, Pakistan | |||
1921368 | 1921368 | 2021-09-24 | Pakistan | Sindh | 454510 | 7327 | 0 | 26.009446 | 68.77680699999999 | 2021-09-25 04:21:31 | Sindh, Pakistan | |||
601833 | 601833 | 2021-09-23 | Pakistan | Azad Jammu and Kashmir | 33955 | 734 | 0 | 34.027401 | 73.947253 | 2021-09-24 04:21:44 | Azad Jammu and Kashmir, Pakistan | |||
601834 | 601834 | 2021-09-23 | Pakistan | Balochistan | 32828 | 345 | 0 | 28.328491999999997 | 65.898403 | 2021-09-24 04:21:44 | Balochistan, Pakistan | |||
601835 | 601835 | 2021-09-23 | Pakistan | Gilgit-Baltistan | 10286 | 184 | 0 | 35.792146 | 74.982138 | 2021-09-24 04:21:44 | Gilgit-Baltistan, Pakistan | |||
601836 | 601836 | 2021-09-23 | Pakistan | Islamabad | 104764 | 909 | 0 | 33.665087 | 73.121219 | 2021-09-24 04:21:44 | Islamabad, Pakistan | |||
601837 | 601837 | 2021-09-23 | Pakistan | Khyber Pakhtunkhwa | 172498 | 5480 | 0 | 34.485332 | 72.09169 | 2021-09-24 04:21:44 | Khyber Pakhtunkhwa, Pakistan | |||
601838 | 601838 | 2021-09-23 | Pakistan | Punjab | 426639 | 12514 | 0 | 30.811346 | 72.13913199999998 | 2021-09-24 04:21:44 | Punjab, Pakistan | |||
601839 | 601839 | 2021-09-23 | Pakistan | Sindh | 453858 | 7316 | 0 | 26.009446 | 68.77680699999999 | 2021-09-24 04:21:44 | Sindh, Pakistan | |||
3011477 | 3011477 | 2021-09-22 | Pakistan | Azad Jammu and Kashmir | 33923 | 734 | 0 | 34.027401 | 73.947253 | 2021-09-23 04:21:43 | Azad Jammu and Kashmir, Pakistan | |||
3011478 | 3011478 | 2021-09-22 | Pakistan | Balochistan | 32812 | 345 | 0 | 28.328491999999997 | 65.898403 | 2021-09-23 04:21:43 | Balochistan, Pakistan | |||
3011479 | 3011479 | 2021-09-22 | Pakistan | Gilgit-Baltistan | 10277 | 183 | 0 | 35.792146 | 74.982138 | 2021-09-23 04:21:43 | Gilgit-Baltistan, Pakistan | |||
3011480 | 3011480 | 2021-09-22 | Pakistan | Islamabad | 104619 | 907 | 0 | 33.665087 | 73.121219 | 2021-09-23 04:21:43 | Islamabad, Pakistan | |||
3011481 | 3011481 | 2021-09-22 | Pakistan | Khyber Pakhtunkhwa | 172210 | 5463 | 0 | 34.485332 | 72.09169 | 2021-09-23 04:21:43 | Khyber Pakhtunkhwa, Pakistan | |||
3011482 | 3011482 | 2021-09-22 | Pakistan | Punjab | 425703 | 12490 | 0 | 30.811346 | 72.13913199999998 | 2021-09-23 04:21:43 | Punjab, Pakistan | |||
3011483 | 3011483 | 2021-09-22 | Pakistan | Sindh | 453051 | 7310 | 0 | 26.009446 | 68.77680699999999 | 2021-09-23 04:21:43 | Sindh, Pakistan | |||
3757615 | 3757615 | 2021-09-21 | Pakistan | Azad Jammu and Kashmir | 33864 | 733 | 0 | 34.027401 | 73.947253 | 2021-09-22 04:21:45 | Azad Jammu and Kashmir, Pakistan | |||
3757616 | 3757616 | 2021-09-21 | Pakistan | Balochistan | 32796 | 345 | 0 | 28.328491999999997 | 65.898403 | 2021-09-22 04:21:45 | Balochistan, Pakistan | |||
3757617 | 3757617 | 2021-09-21 | Pakistan | Gilgit-Baltistan | 10264 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-22 04:21:45 | Gilgit-Baltistan, Pakistan | |||
3757618 | 3757618 | 2021-09-21 | Pakistan | Islamabad | 104472 | 905 | 0 | 33.665087 | 73.121219 | 2021-09-22 04:21:45 | Islamabad, Pakistan | |||
3757619 | 3757619 | 2021-09-21 | Pakistan | Khyber Pakhtunkhwa | 171874 | 5444 | 0 | 34.485332 | 72.09169 | 2021-09-22 04:21:45 | Khyber Pakhtunkhwa, Pakistan | |||
3757620 | 3757620 | 2021-09-21 | Pakistan | Punjab | 424701 | 12470 | 0 | 30.811346 | 72.13913199999998 | 2021-09-22 04:21:45 | Punjab, Pakistan | |||
3757621 | 3757621 | 2021-09-21 | Pakistan | Sindh | 452267 | 7295 | 0 | 26.009446 | 68.77680699999999 | 2021-09-22 04:21:45 | Sindh, Pakistan | |||
809718 | 809718 | 2021-09-20 | Pakistan | Azad Jammu and Kashmir | 33821 | 733 | 0 | 34.027401 | 73.947253 | 2021-09-21 04:21:26 | Azad Jammu and Kashmir, Pakistan | |||
809719 | 809719 | 2021-09-20 | Pakistan | Balochistan | 32772 | 344 | 0 | 28.328491999999997 | 65.898403 | 2021-09-21 04:21:26 | Balochistan, Pakistan | |||
809720 | 809720 | 2021-09-20 | Pakistan | Gilgit-Baltistan | 10257 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-21 04:21:26 | Gilgit-Baltistan, Pakistan | |||
809721 | 809721 | 2021-09-20 | Pakistan | Islamabad | 104348 | 904 | 0 | 33.665087 | 73.121219 | 2021-09-21 04:21:26 | Islamabad, Pakistan | |||
809722 | 809722 | 2021-09-20 | Pakistan | Khyber Pakhtunkhwa | 171589 | 5426 | 0 | 34.485332 | 72.09169 | 2021-09-21 04:21:26 | Khyber Pakhtunkhwa, Pakistan | |||
809723 | 809723 | 2021-09-20 | Pakistan | Punjab | 423670 | 12449 | 0 | 30.811346 | 72.13913199999998 | 2021-09-21 04:21:26 | Punjab, Pakistan | |||
809724 | 809724 | 2021-09-20 | Pakistan | Sindh | 451448 | 7289 | 0 | 26.009446 | 68.77680699999999 | 2021-09-21 04:21:26 | Sindh, Pakistan | |||
1814917 | 1814917 | 2021-09-19 | Pakistan | Azad Jammu and Kashmir | 33787 | 729 | 0 | 34.027401 | 73.947253 | 2021-09-20 04:21:22 | Azad Jammu and Kashmir, Pakistan | |||
1814918 | 1814918 | 2021-09-19 | Pakistan | Balochistan | 32769 | 344 | 0 | 28.328491999999997 | 65.898403 | 2021-09-20 04:21:22 | Balochistan, Pakistan | |||
1814919 | 1814919 | 2021-09-19 | Pakistan | Gilgit-Baltistan | 10245 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-20 04:21:22 | Gilgit-Baltistan, Pakistan | |||
1814920 | 1814920 | 2021-09-19 | Pakistan | Islamabad | 104242 | 902 | 0 | 33.665087 | 73.121219 | 2021-09-20 04:21:22 | Islamabad, Pakistan | |||
1814921 | 1814921 | 2021-09-19 | Pakistan | Khyber Pakhtunkhwa | 171388 | 5412 | 0 | 34.485332 | 72.09169 | 2021-09-20 04:21:22 | Khyber Pakhtunkhwa, Pakistan | |||
1814922 | 1814922 | 2021-09-19 | Pakistan | Punjab | 422790 | 12407 | 0 | 30.811346 | 72.13913199999998 | 2021-09-20 04:21:22 | Punjab, Pakistan | |||
1814923 | 1814923 | 2021-09-19 | Pakistan | Sindh | 450787 | 7270 | 0 | 26.009446 | 68.77680699999999 | 2021-09-20 04:21:22 | Sindh, Pakistan | |||
16497 | 16497 | 2021-09-18 | Pakistan | Azad Jammu and Kashmir | 33732 | 729 | 0 | 34.027401 | 73.947253 | 2021-09-19 04:21:34 | Azad Jammu and Kashmir, Pakistan | |||
16498 | 16498 | 2021-09-18 | Pakistan | Balochistan | 32757 | 344 | 0 | 28.328491999999997 | 65.898403 | 2021-09-19 04:21:34 | Balochistan, Pakistan | |||
16499 | 16499 | 2021-09-18 | Pakistan | Gilgit-Baltistan | 10240 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-19 04:21:34 | Gilgit-Baltistan, Pakistan | |||
16500 | 16500 | 2021-09-18 | Pakistan | Islamabad | 104114 | 902 | 0 | 33.665087 | 73.121219 | 2021-09-19 04:21:34 | Islamabad, Pakistan | |||
16501 | 16501 | 2021-09-18 | Pakistan | Khyber Pakhtunkhwa | 171072 | 5395 | 0 | 34.485332 | 72.09169 | 2021-09-19 04:21:34 | Khyber Pakhtunkhwa, Pakistan | |||
16502 | 16502 | 2021-09-18 | Pakistan | Punjab | 421800 | 12396 | 0 | 30.811346 | 72.13913199999998 | 2021-09-19 04:21:34 | Punjab, Pakistan | |||
16503 | 16503 | 2021-09-18 | Pakistan | Sindh | 450126 | 7258 | 0 | 26.009446 | 68.77680699999999 | 2021-09-19 04:21:34 | Sindh, Pakistan | |||
2618182 | 2618182 | 2021-09-17 | Pakistan | Azad Jammu and Kashmir | 33682 | 728 | 0 | 34.027401 | 73.947253 | 2021-09-18 04:21:24 | Azad Jammu and Kashmir, Pakistan | |||
2618183 | 2618183 | 2021-09-17 | Pakistan | Balochistan | 32722 | 344 | 0 | 28.328491999999997 | 65.898403 | 2021-09-18 04:21:24 | Balochistan, Pakistan | |||
2618184 | 2618184 | 2021-09-17 | Pakistan | Gilgit-Baltistan | 10232 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-18 04:21:24 | Gilgit-Baltistan, Pakistan | |||
2618185 | 2618185 | 2021-09-17 | Pakistan | Islamabad | 103923 | 899 | 0 | 33.665087 | 73.121219 | 2021-09-18 04:21:24 | Islamabad, Pakistan | |||
2618186 | 2618186 | 2021-09-17 | Pakistan | Khyber Pakhtunkhwa | 170738 | 5374 | 0 | 34.485332 | 72.09169 | 2021-09-18 04:21:24 | Khyber Pakhtunkhwa, Pakistan | |||
2618187 | 2618187 | 2021-09-17 | Pakistan | Punjab | 420615 | 12365 | 0 | 30.811346 | 72.13913199999998 | 2021-09-18 04:21:24 | Punjab, Pakistan | |||
2618188 | 2618188 | 2021-09-17 | Pakistan | Sindh | 449349 | 7243 | 0 | 26.009446 | 68.77680699999999 | 2021-09-18 04:21:24 | Sindh, Pakistan | |||
2808890 | 2808890 | 2021-09-16 | Pakistan | Azad Jammu and Kashmir | 33628 | 728 | 0 | 34.027401 | 73.947253 | 2021-09-17 04:21:46 | Azad Jammu and Kashmir, Pakistan | |||
2808891 | 2808891 | 2021-09-16 | Pakistan | Balochistan | 32707 | 344 | 0 | 28.328491999999997 | 65.898403 | 2021-09-17 04:21:46 | Balochistan, Pakistan | |||
2808892 | 2808892 | 2021-09-16 | Pakistan | Gilgit-Baltistan | 10222 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-17 04:21:46 | Gilgit-Baltistan, Pakistan | |||
2808893 | 2808893 | 2021-09-16 | Pakistan | Islamabad | 103720 | 895 | 0 | 33.665087 | 73.121219 | 2021-09-17 04:21:46 | Islamabad, Pakistan | |||
2808894 | 2808894 | 2021-09-16 | Pakistan | Khyber Pakhtunkhwa | 170391 | 5354 | 0 | 34.485332 | 72.09169 | 2021-09-17 04:21:46 | Khyber Pakhtunkhwa, Pakistan | |||
2808895 | 2808895 | 2021-09-16 | Pakistan | Punjab | 419423 | 12345 | 0 | 30.811346 | 72.13913199999998 | 2021-09-17 04:21:46 | Punjab, Pakistan | |||
2808896 | 2808896 | 2021-09-16 | Pakistan | Sindh | 448658 | 7224 | 0 | 26.009446 | 68.77680699999999 | 2021-09-17 04:21:46 | Sindh, Pakistan | |||
1374635 | 1374635 | 2021-09-15 | Pakistan | Azad Jammu and Kashmir | 33551 | 727 | 0 | 34.027401 | 73.947253 | 2021-09-16 04:22:19 | Azad Jammu and Kashmir, Pakistan | |||
1374636 | 1374636 | 2021-09-15 | Pakistan | Balochistan | 32671 | 344 | 0 | 28.328491999999997 | 65.898403 | 2021-09-16 04:22:19 | Balochistan, Pakistan | |||
1374637 | 1374637 | 2021-09-15 | Pakistan | Gilgit-Baltistan | 10204 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-16 04:22:19 | Gilgit-Baltistan, Pakistan | |||
1374638 | 1374638 | 2021-09-15 | Pakistan | Islamabad | 103549 | 893 | 0 | 33.665087 | 73.121219 | 2021-09-16 04:22:19 | Islamabad, Pakistan | |||
1374639 | 1374639 | 2021-09-15 | Pakistan | Khyber Pakhtunkhwa | 169972 | 5329 | 0 | 34.485332 | 72.09169 | 2021-09-16 04:22:19 | Khyber Pakhtunkhwa, Pakistan | |||
1374640 | 1374640 | 2021-09-15 | Pakistan | Punjab | 418196 | 12319 | 0 | 30.811346 | 72.13913199999998 | 2021-09-16 04:22:19 | Punjab, Pakistan | |||
1374641 | 1374641 | 2021-09-15 | Pakistan | Sindh | 447678 | 7210 | 0 | 26.009446 | 68.77680699999999 | 2021-09-16 04:22:19 | Sindh, Pakistan | |||
2462934 | 2462934 | 2021-09-14 | Pakistan | Azad Jammu and Kashmir | 33490 | 727 | 0 | 34.027401 | 73.947253 | 2021-09-15 03:22:37 | Azad Jammu and Kashmir, Pakistan | |||
2462935 | 2462935 | 2021-09-14 | Pakistan | Balochistan | 32658 | 344 | 0 | 28.328491999999997 | 65.898403 | 2021-09-15 03:22:37 | Balochistan, Pakistan | |||
2462936 | 2462936 | 2021-09-14 | Pakistan | Gilgit-Baltistan | 10198 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-15 03:22:37 | Gilgit-Baltistan, Pakistan | |||
2462937 | 2462937 | 2021-09-14 | Pakistan | Islamabad | 103293 | 892 | 0 | 33.665087 | 73.121219 | 2021-09-15 03:22:37 | Islamabad, Pakistan |
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]);