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
- Azad Jammu and Kashmir 487
- Balochistan 487
- Gilgit-Baltistan 487
- Islamabad 487
- Khyber Pakhtunkhwa 487
- Punjab 487
- Sindh 487
country_or_region 1
- Pakistan · 3,514 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2876351 | 2876351 | 2021-10-09 | Pakistan | Azad Jammu and Kashmir | 34399 | 739 | 0 | 34.027401 | 73.947253 | 2021-10-10 04:21:38 | Azad Jammu and Kashmir, Pakistan | |||
2876352 | 2876352 | 2021-10-09 | Pakistan | Balochistan | 33072 | 350 | 0 | 28.328491999999997 | 65.898403 | 2021-10-10 04:21:38 | Balochistan, Pakistan | |||
2876353 | 2876353 | 2021-10-09 | Pakistan | Gilgit-Baltistan | 10348 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-10 04:21:38 | Gilgit-Baltistan, Pakistan | |||
2876354 | 2876354 | 2021-10-09 | Pakistan | Islamabad | 106113 | 931 | 0 | 33.665087 | 73.121219 | 2021-10-10 04:21:38 | Islamabad, Pakistan | |||
2876355 | 2876355 | 2021-10-09 | Pakistan | Khyber Pakhtunkhwa | 175735 | 5636 | 0 | 34.485332 | 72.09169 | 2021-10-10 04:21:38 | Khyber Pakhtunkhwa, Pakistan | |||
2876356 | 2876356 | 2021-10-09 | Pakistan | Punjab | 435882 | 12780 | 0 | 30.811346 | 72.13913199999998 | 2021-10-10 04:21:38 | Punjab, Pakistan | |||
2876357 | 2876357 | 2021-10-09 | Pakistan | Sindh | 462466 | 7484 | 0 | 26.009446 | 68.77680699999999 | 2021-10-10 04:21:38 | Sindh, Pakistan | |||
2959517 | 2959517 | 2021-10-08 | Pakistan | Azad Jammu and Kashmir | 34326 | 739 | 0 | 34.027401 | 73.947253 | 2021-10-09 04:21:34 | Azad Jammu and Kashmir, Pakistan | |||
2959518 | 2959518 | 2021-10-08 | Pakistan | Balochistan | 33069 | 349 | 0 | 28.328491999999997 | 65.898403 | 2021-10-09 04:21:34 | Balochistan, Pakistan | |||
2959519 | 2959519 | 2021-10-08 | Pakistan | Gilgit-Baltistan | 10344 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-09 04:21:34 | Gilgit-Baltistan, Pakistan | |||
2959520 | 2959520 | 2021-10-08 | Pakistan | Islamabad | 106058 | 931 | 0 | 33.665087 | 73.121219 | 2021-10-09 04:21:34 | Islamabad, Pakistan | |||
2959521 | 2959521 | 2021-10-08 | Pakistan | Khyber Pakhtunkhwa | 175584 | 5632 | 0 | 34.485332 | 72.09169 | 2021-10-09 04:21:34 | Khyber Pakhtunkhwa, Pakistan | |||
2959522 | 2959522 | 2021-10-08 | Pakistan | Punjab | 435512 | 12770 | 0 | 30.811346 | 72.13913199999998 | 2021-10-09 04:21:34 | Punjab, Pakistan | |||
2959523 | 2959523 | 2021-10-08 | Pakistan | Sindh | 462295 | 7480 | 0 | 26.009446 | 68.77680699999999 | 2021-10-09 04:21:34 | Sindh, Pakistan | |||
467555 | 467555 | 2021-10-07 | Pakistan | Azad Jammu and Kashmir | 34316 | 739 | 0 | 34.027401 | 73.947253 | 2021-10-08 04:21:25 | Azad Jammu and Kashmir, Pakistan | |||
467556 | 467556 | 2021-10-07 | Pakistan | Balochistan | 33040 | 349 | 0 | 28.328491999999997 | 65.898403 | 2021-10-08 04:21:25 | Balochistan, Pakistan | |||
467557 | 467557 | 2021-10-07 | Pakistan | Gilgit-Baltistan | 10341 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-08 04:21:25 | Gilgit-Baltistan, Pakistan | |||
467558 | 467558 | 2021-10-07 | Pakistan | Islamabad | 105983 | 930 | 0 | 33.665087 | 73.121219 | 2021-10-08 04:21:25 | Islamabad, Pakistan | |||
467559 | 467559 | 2021-10-07 | Pakistan | Khyber Pakhtunkhwa | 175358 | 5623 | 0 | 34.485332 | 72.09169 | 2021-10-08 04:21:25 | Khyber Pakhtunkhwa, Pakistan | |||
467560 | 467560 | 2021-10-07 | Pakistan | Punjab | 435040 | 12757 | 0 | 30.811346 | 72.13913199999998 | 2021-10-08 04:21:25 | Punjab, Pakistan | |||
467561 | 467561 | 2021-10-07 | Pakistan | Sindh | 462155 | 7474 | 0 | 26.009446 | 68.77680699999999 | 2021-10-08 04:21:25 | Sindh, Pakistan | |||
2458935 | 2458935 | 2021-10-06 | Pakistan | Azad Jammu and Kashmir | 34299 | 739 | 0 | 34.027401 | 73.947253 | 2021-10-07 04:21:36 | Azad Jammu and Kashmir, Pakistan | |||
2458936 | 2458936 | 2021-10-06 | Pakistan | Balochistan | 33026 | 349 | 0 | 28.328491999999997 | 65.898403 | 2021-10-07 04:21:36 | Balochistan, Pakistan | |||
2458937 | 2458937 | 2021-10-06 | Pakistan | Gilgit-Baltistan | 10338 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-07 04:21:36 | Gilgit-Baltistan, Pakistan | |||
2458938 | 2458938 | 2021-10-06 | Pakistan | Islamabad | 105930 | 930 | 0 | 33.665087 | 73.121219 | 2021-10-07 04:21:36 | Islamabad, Pakistan | |||
2458939 | 2458939 | 2021-10-06 | Pakistan | Khyber Pakhtunkhwa | 175212 | 5613 | 0 | 34.485332 | 72.09169 | 2021-10-07 04:21:36 | Khyber Pakhtunkhwa, Pakistan | |||
2458940 | 2458940 | 2021-10-06 | Pakistan | Punjab | 434647 | 12744 | 0 | 30.811346 | 72.13913199999998 | 2021-10-07 04:21:36 | Punjab, Pakistan | |||
2458941 | 2458941 | 2021-10-06 | Pakistan | Sindh | 461869 | 7471 | 0 | 26.009446 | 68.77680699999999 | 2021-10-07 04:21:36 | Sindh, Pakistan | |||
3832629 | 3832629 | 2021-10-05 | Pakistan | Azad Jammu and Kashmir | 34278 | 738 | 0 | 34.027401 | 73.947253 | 2021-10-06 04:21:33 | Azad Jammu and Kashmir, Pakistan | |||
3832630 | 3832630 | 2021-10-05 | Pakistan | Balochistan | 33004 | 349 | 0 | 28.328491999999997 | 65.898403 | 2021-10-06 04:21:33 | Balochistan, Pakistan | |||
3832631 | 3832631 | 2021-10-05 | Pakistan | Gilgit-Baltistan | 10338 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-06 04:21:33 | Gilgit-Baltistan, Pakistan | |||
3832632 | 3832632 | 2021-10-05 | Pakistan | Islamabad | 105839 | 930 | 0 | 33.665087 | 73.121219 | 2021-10-06 04:21:33 | Islamabad, Pakistan | |||
3832633 | 3832633 | 2021-10-05 | Pakistan | Khyber Pakhtunkhwa | 175012 | 5608 | 0 | 34.485332 | 72.09169 | 2021-10-06 04:21:33 | Khyber Pakhtunkhwa, Pakistan | |||
3832634 | 3832634 | 2021-10-05 | Pakistan | Punjab | 434139 | 12724 | 0 | 30.811346 | 72.13913199999998 | 2021-10-06 04:21:33 | Punjab, Pakistan | |||
3832635 | 3832635 | 2021-10-05 | Pakistan | Sindh | 461258 | 7451 | 0 | 26.009446 | 68.77680699999999 | 2021-10-06 04:21:33 | Sindh, Pakistan | |||
987122 | 987122 | 2021-10-04 | Pakistan | Azad Jammu and Kashmir | 34253 | 738 | 0 | 34.027401 | 73.947253 | 2021-10-05 04:21:27 | Azad Jammu and Kashmir, Pakistan | |||
987123 | 987123 | 2021-10-04 | Pakistan | Balochistan | 32992 | 349 | 0 | 28.328491999999997 | 65.898403 | 2021-10-05 04:21:27 | Balochistan, Pakistan | |||
987124 | 987124 | 2021-10-04 | Pakistan | Gilgit-Baltistan | 10334 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-05 04:21:27 | Gilgit-Baltistan, Pakistan | |||
987125 | 987125 | 2021-10-04 | Pakistan | Islamabad | 105801 | 929 | 0 | 33.665087 | 73.121219 | 2021-10-05 04:21:27 | Islamabad, Pakistan | |||
987126 | 987126 | 2021-10-04 | Pakistan | Khyber Pakhtunkhwa | 174841 | 5593 | 0 | 34.485332 | 72.09169 | 2021-10-05 04:21:27 | Khyber Pakhtunkhwa, Pakistan | |||
987127 | 987127 | 2021-10-04 | Pakistan | Punjab | 433687 | 12710 | 0 | 30.811346 | 72.13913199999998 | 2021-10-05 04:21:27 | Punjab, Pakistan | |||
987128 | 987128 | 2021-10-04 | Pakistan | Sindh | 460748 | 7442 | 0 | 26.009446 | 68.77680699999999 | 2021-10-05 04:21:27 | Sindh, Pakistan | |||
1274432 | 1274432 | 2021-10-03 | Pakistan | Azad Jammu and Kashmir | 34234 | 738 | 0 | 34.027401 | 73.947253 | 2021-10-04 04:21:31 | Azad Jammu and Kashmir, Pakistan | |||
1274433 | 1274433 | 2021-10-03 | Pakistan | Balochistan | 32981 | 349 | 0 | 28.328491999999997 | 65.898403 | 2021-10-04 04:21:31 | Balochistan, Pakistan | |||
1274434 | 1274434 | 2021-10-03 | Pakistan | Gilgit-Baltistan | 10332 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-04 04:21:31 | Gilgit-Baltistan, Pakistan | |||
1274435 | 1274435 | 2021-10-03 | Pakistan | Islamabad | 105733 | 928 | 0 | 33.665087 | 73.121219 | 2021-10-04 04:21:31 | Islamabad, Pakistan | |||
1274436 | 1274436 | 2021-10-03 | Pakistan | Khyber Pakhtunkhwa | 174671 | 5580 | 0 | 34.485332 | 72.09169 | 2021-10-04 04:21:31 | Khyber Pakhtunkhwa, Pakistan | |||
1274437 | 1274437 | 2021-10-03 | Pakistan | Punjab | 433286 | 12685 | 0 | 30.811346 | 72.13913199999998 | 2021-10-04 04:21:31 | Punjab, Pakistan | |||
1274438 | 1274438 | 2021-10-03 | Pakistan | Sindh | 460111 | 7427 | 0 | 26.009446 | 68.77680699999999 | 2021-10-04 04:21:31 | Sindh, Pakistan | |||
3928185 | 3928185 | 2021-10-02 | Pakistan | Azad Jammu and Kashmir | 34216 | 738 | 0 | 34.027401 | 73.947253 | 2021-10-03 04:21:24 | Azad Jammu and Kashmir, Pakistan | |||
3928186 | 3928186 | 2021-10-02 | Pakistan | Balochistan | 32956 | 349 | 0 | 28.328491999999997 | 65.898403 | 2021-10-03 04:21:24 | Balochistan, Pakistan | |||
3928187 | 3928187 | 2021-10-02 | Pakistan | Gilgit-Baltistan | 10331 | 184 | 0 | 35.792146 | 74.982138 | 2021-10-03 04:21:24 | Gilgit-Baltistan, Pakistan | |||
3928188 | 3928188 | 2021-10-02 | Pakistan | Islamabad | 105664 | 927 | 0 | 33.665087 | 73.121219 | 2021-10-03 04:21:24 | Islamabad, Pakistan | |||
3928189 | 3928189 | 2021-10-02 | Pakistan | Khyber Pakhtunkhwa | 174490 | 5571 | 0 | 34.485332 | 72.09169 | 2021-10-03 04:21:24 | Khyber Pakhtunkhwa, Pakistan | |||
3928190 | 3928190 | 2021-10-02 | Pakistan | Punjab | 432809 | 12672 | 0 | 30.811346 | 72.13913199999998 | 2021-10-03 04:21:24 | Punjab, Pakistan | |||
3928191 | 3928191 | 2021-10-02 | Pakistan | Sindh | 459392 | 7425 | 0 | 26.009446 | 68.77680699999999 | 2021-10-03 04:21:24 | Sindh, Pakistan | |||
2132165 | 2132165 | 2021-10-01 | Pakistan | Azad Jammu and Kashmir | 34193 | 738 | 0 | 34.027401 | 73.947253 | 2021-10-02 04:21:25 | Azad Jammu and Kashmir, Pakistan | |||
2132166 | 2132166 | 2021-10-01 | Pakistan | Balochistan | 32943 | 349 | 0 | 28.328491999999997 | 65.898403 | 2021-10-02 04:21:25 | Balochistan, Pakistan | |||
2132167 | 2132167 | 2021-10-01 | Pakistan | Gilgit-Baltistan | 10329 | 184 | 0 | 35.792146 | 74.982138 | 2021-10-02 04:21:25 | Gilgit-Baltistan, Pakistan | |||
2132168 | 2132168 | 2021-10-01 | Pakistan | Islamabad | 105590 | 926 | 0 | 33.665087 | 73.121219 | 2021-10-02 04:21:25 | Islamabad, Pakistan | |||
2132169 | 2132169 | 2021-10-01 | Pakistan | Khyber Pakhtunkhwa | 174260 | 5559 | 0 | 34.485332 | 72.09169 | 2021-10-02 04:21:25 | Khyber Pakhtunkhwa, Pakistan | |||
2132170 | 2132170 | 2021-10-01 | Pakistan | Punjab | 432190 | 12661 | 0 | 30.811346 | 72.13913199999998 | 2021-10-02 04:21:25 | Punjab, Pakistan | |||
2132171 | 2132171 | 2021-10-01 | Pakistan | Sindh | 458697 | 7414 | 0 | 26.009446 | 68.77680699999999 | 2021-10-02 04:21:25 | Sindh, Pakistan | |||
2773122 | 2773122 | 2021-09-30 | Pakistan | Azad Jammu and Kashmir | 34157 | 738 | 0 | 34.027401 | 73.947253 | 2021-10-01 04:21:35 | Azad Jammu and Kashmir, Pakistan | |||
2773123 | 2773123 | 2021-09-30 | Pakistan | Balochistan | 32926 | 348 | 0 | 28.328491999999997 | 65.898403 | 2021-10-01 04:21:35 | Balochistan, Pakistan | |||
2773124 | 2773124 | 2021-09-30 | Pakistan | Gilgit-Baltistan | 10328 | 184 | 0 | 35.792146 | 74.982138 | 2021-10-01 04:21:35 | Gilgit-Baltistan, Pakistan | |||
2773125 | 2773125 | 2021-09-30 | Pakistan | Islamabad | 105516 | 924 | 0 | 33.665087 | 73.121219 | 2021-10-01 04:21:35 | Islamabad, Pakistan | |||
2773126 | 2773126 | 2021-09-30 | Pakistan | Khyber Pakhtunkhwa | 174017 | 5547 | 0 | 34.485332 | 72.09169 | 2021-10-01 04:21:35 | Khyber Pakhtunkhwa, Pakistan | |||
2773127 | 2773127 | 2021-09-30 | Pakistan | Punjab | 431666 | 12637 | 0 | 30.811346 | 72.13913199999998 | 2021-10-01 04:21:35 | Punjab, Pakistan | |||
2773128 | 2773128 | 2021-09-30 | Pakistan | Sindh | 457928 | 7407 | 0 | 26.009446 | 68.77680699999999 | 2021-10-01 04:21:35 | Sindh, Pakistan | |||
706578 | 706578 | 2021-09-29 | Pakistan | Azad Jammu and Kashmir | 34127 | 738 | 0 | 34.027401 | 73.947253 | 2021-09-30 04:21:20 | Azad Jammu and Kashmir, Pakistan | |||
706579 | 706579 | 2021-09-29 | Pakistan | Balochistan | 32916 | 348 | 0 | 28.328491999999997 | 65.898403 | 2021-09-30 04:21:20 | Balochistan, Pakistan | |||
706580 | 706580 | 2021-09-29 | Pakistan | Gilgit-Baltistan | 10321 | 184 | 0 | 35.792146 | 74.982138 | 2021-09-30 04:21:20 | Gilgit-Baltistan, Pakistan | |||
706581 | 706581 | 2021-09-29 | Pakistan | Islamabad | 105417 | 923 | 0 | 33.665087 | 73.121219 | 2021-09-30 04:21:20 | Islamabad, Pakistan | |||
706582 | 706582 | 2021-09-29 | Pakistan | Khyber Pakhtunkhwa | 173796 | 5537 | 0 | 34.485332 | 72.09169 | 2021-09-30 04:21:20 | Khyber Pakhtunkhwa, Pakistan | |||
706583 | 706583 | 2021-09-29 | Pakistan | Punjab | 431092 | 12617 | 0 | 30.811346 | 72.13913199999998 | 2021-09-30 04:21:20 | Punjab, Pakistan | |||
706584 | 706584 | 2021-09-29 | Pakistan | Sindh | 457458 | 7382 | 0 | 26.009446 | 68.77680699999999 | 2021-09-30 04:21:20 | Sindh, Pakistan | |||
1334420 | 1334420 | 2021-09-28 | Pakistan | Azad Jammu and Kashmir | 34101 | 737 | 0 | 34.027401 | 73.947253 | 2021-09-29 04:21:45 | Azad Jammu and Kashmir, Pakistan | |||
1334421 | 1334421 | 2021-09-28 | Pakistan | Balochistan | 32888 | 348 | 0 | 28.328491999999997 | 65.898403 | 2021-09-29 04:21:45 | Balochistan, Pakistan | |||
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 |
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]);