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 490
- Balochistan 490
- Gilgit-Baltistan 490
- Islamabad 490
- Khyber Pakhtunkhwa 490
- Punjab 490
- Sindh 490
country_or_region 1
- Pakistan · 3,535 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491745 | 1491745 | 2021-10-12 | Pakistan | Azad Jammu and Kashmir | 34360 | 740 | 0 | 34.027401 | 73.947253 | 2021-10-13 04:20:51 | Azad Jammu and Kashmir, Pakistan | |||
1491746 | 1491746 | 2021-10-12 | Pakistan | Balochistan | 33092 | 350 | 0 | 28.328491999999997 | 65.898403 | 2021-10-13 04:20:51 | Balochistan, Pakistan | |||
1491747 | 1491747 | 2021-10-12 | Pakistan | Gilgit-Baltistan | 10359 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-13 04:20:51 | Gilgit-Baltistan, Pakistan | |||
1491748 | 1491748 | 2021-10-12 | Pakistan | Islamabad | 106241 | 935 | 0 | 33.665087 | 73.121219 | 2021-10-13 04:20:51 | Islamabad, Pakistan | |||
1491749 | 1491749 | 2021-10-12 | Pakistan | Khyber Pakhtunkhwa | 176194 | 5657 | 0 | 34.485332 | 72.09169 | 2021-10-13 04:20:51 | Khyber Pakhtunkhwa, Pakistan | |||
1491750 | 1491750 | 2021-10-12 | Pakistan | Punjab | 436720 | 12800 | 0 | 30.811346 | 72.13913199999998 | 2021-10-13 04:20:51 | Punjab, Pakistan | |||
1491751 | 1491751 | 2021-10-12 | Pakistan | Sindh | 463703 | 7505 | 0 | 26.009446 | 68.77680699999999 | 2021-10-13 04:20:51 | Sindh, Pakistan | |||
3007478 | 3007478 | 2021-10-11 | Pakistan | Azad Jammu and Kashmir | 34354 | 739 | 0 | 34.027401 | 73.947253 | 2021-10-12 04:21:09 | Azad Jammu and Kashmir, Pakistan | |||
3007479 | 3007479 | 2021-10-11 | Pakistan | Balochistan | 33083 | 350 | 0 | 28.328491999999997 | 65.898403 | 2021-10-12 04:21:09 | Balochistan, Pakistan | |||
3007480 | 3007480 | 2021-10-11 | Pakistan | Gilgit-Baltistan | 10353 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-12 04:21:09 | Gilgit-Baltistan, Pakistan | |||
3007481 | 3007481 | 2021-10-11 | Pakistan | Islamabad | 106201 | 933 | 0 | 33.665087 | 73.121219 | 2021-10-12 04:21:09 | Islamabad, Pakistan | |||
3007482 | 3007482 | 2021-10-11 | Pakistan | Khyber Pakhtunkhwa | 176048 | 5650 | 0 | 34.485332 | 72.09169 | 2021-10-12 04:21:09 | Khyber Pakhtunkhwa, Pakistan | |||
3007483 | 3007483 | 2021-10-11 | Pakistan | Punjab | 436442 | 12792 | 0 | 30.811346 | 72.13913199999998 | 2021-10-12 04:21:09 | Punjab, Pakistan | |||
3007484 | 3007484 | 2021-10-11 | Pakistan | Sindh | 463167 | 7502 | 0 | 26.009446 | 68.77680699999999 | 2021-10-12 04:21:09 | Sindh, Pakistan | |||
423494 | 423494 | 2021-10-10 | Pakistan | Azad Jammu and Kashmir | 34350 | 739 | 0 | 34.027401 | 73.947253 | 2021-10-11 04:21:31 | Azad Jammu and Kashmir, Pakistan | |||
423495 | 423495 | 2021-10-10 | Pakistan | Balochistan | 33076 | 350 | 0 | 28.328491999999997 | 65.898403 | 2021-10-11 04:21:31 | Balochistan, Pakistan | |||
423496 | 423496 | 2021-10-10 | Pakistan | Gilgit-Baltistan | 10350 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-11 04:21:31 | Gilgit-Baltistan, Pakistan | |||
423497 | 423497 | 2021-10-10 | Pakistan | Islamabad | 106153 | 932 | 0 | 33.665087 | 73.121219 | 2021-10-11 04:21:31 | Islamabad, Pakistan | |||
423498 | 423498 | 2021-10-10 | Pakistan | Khyber Pakhtunkhwa | 175974 | 5645 | 0 | 34.485332 | 72.09169 | 2021-10-11 04:21:31 | Khyber Pakhtunkhwa, Pakistan | |||
423499 | 423499 | 2021-10-10 | Pakistan | Punjab | 436197 | 12785 | 0 | 30.811346 | 72.13913199999998 | 2021-10-11 04:21:31 | Punjab, Pakistan | |||
423500 | 423500 | 2021-10-10 | Pakistan | Sindh | 462859 | 7497 | 0 | 26.009446 | 68.77680699999999 | 2021-10-11 04:21:31 | Sindh, Pakistan | |||
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 |
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]);