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 462
- Balochistan 462
- Gilgit-Baltistan 462
- Islamabad 462
- Khyber Pakhtunkhwa 462
- Punjab 462
- Sindh 462
country_or_region 1
- Pakistan · 3,339 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
2462938 | 2462938 | 2021-09-14 | Pakistan | Khyber Pakhtunkhwa | 169429 | 5310 | 0 | 34.485332 | 72.09169 | 2021-09-15 03:22:37 | Khyber Pakhtunkhwa, Pakistan | |||
2462939 | 2462939 | 2021-09-14 | Pakistan | Punjab | 416901 | 12291 | 0 | 30.811346 | 72.13913199999998 | 2021-09-15 03:22:37 | Punjab, Pakistan | |||
2462940 | 2462940 | 2021-09-14 | Pakistan | Sindh | 446840 | 7192 | 0 | 26.009446 | 68.77680699999999 | 2021-09-15 03:22:37 | Sindh, Pakistan | |||
1385773 | 1385773 | 2021-09-13 | Pakistan | Azad Jammu and Kashmir | 33432 | 724 | 0 | 34.027401 | 73.947253 | 2021-09-14 04:21:41 | Azad Jammu and Kashmir, Pakistan | |||
1385774 | 1385774 | 2021-09-13 | Pakistan | Balochistan | 32618 | 344 | 0 | 28.328491999999997 | 65.898403 | 2021-09-14 04:21:41 | Balochistan, Pakistan | |||
1385775 | 1385775 | 2021-09-13 | Pakistan | Gilgit-Baltistan | 10168 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-14 04:21:41 | Gilgit-Baltistan, Pakistan | |||
1385776 | 1385776 | 2021-09-13 | Pakistan | Islamabad | 103125 | 889 | 0 | 33.665087 | 73.121219 | 2021-09-14 04:21:41 | Islamabad, Pakistan | |||
1385777 | 1385777 | 2021-09-13 | Pakistan | Khyber Pakhtunkhwa | 169040 | 5290 | 0 | 34.485332 | 72.09169 | 2021-09-14 04:21:41 | Khyber Pakhtunkhwa, Pakistan | |||
1385778 | 1385778 | 2021-09-13 | Pakistan | Punjab | 415654 | 12259 | 0 | 30.811346 | 72.13913199999998 | 2021-09-14 04:21:41 | Punjab, Pakistan | |||
1385779 | 1385779 | 2021-09-13 | Pakistan | Sindh | 446045 | 7177 | 0 | 26.009446 | 68.77680699999999 | 2021-09-14 04:21:41 | Sindh, Pakistan | |||
1885142 | 1885142 | 2021-09-12 | Pakistan | Azad Jammu and Kashmir | 33379 | 721 | 0 | 34.027401 | 73.947253 | 2021-09-13 04:21:15 | Azad Jammu and Kashmir, Pakistan | |||
1885143 | 1885143 | 2021-09-12 | Pakistan | Balochistan | 32591 | 342 | 0 | 28.328491999999997 | 65.898403 | 2021-09-13 04:21:15 | Balochistan, Pakistan | |||
1885144 | 1885144 | 2021-09-12 | Pakistan | Gilgit-Baltistan | 10168 | 181 | 0 | 35.792146 | 74.982138 | 2021-09-13 04:21:15 | Gilgit-Baltistan, Pakistan | |||
1885145 | 1885145 | 2021-09-12 | Pakistan | Islamabad | 102863 | 889 | 0 | 33.665087 | 73.121219 | 2021-09-13 04:21:15 | Islamabad, Pakistan | |||
1885146 | 1885146 | 2021-09-12 | Pakistan | Khyber Pakhtunkhwa | 168748 | 5270 | 0 | 34.485332 | 72.09169 | 2021-09-13 04:21:15 | Khyber Pakhtunkhwa, Pakistan | |||
1885147 | 1885147 | 2021-09-12 | Pakistan | Punjab | 414390 | 12225 | 0 | 30.811346 | 72.13913199999998 | 2021-09-13 04:21:15 | Punjab, Pakistan | |||
1885148 | 1885148 | 2021-09-12 | Pakistan | Sindh | 445369 | 7159 | 0 | 26.009446 | 68.77680699999999 | 2021-09-13 04:21:15 | Sindh, Pakistan | |||
3806045 | 3806045 | 2021-09-11 | Pakistan | Azad Jammu and Kashmir | 33268 | 718 | 0 | 34.027401 | 73.947253 | 2021-09-12 04:21:13 | Azad Jammu and Kashmir, Pakistan | |||
3806046 | 3806046 | 2021-09-11 | Pakistan | Balochistan | 32569 | 342 | 0 | 28.328491999999997 | 65.898403 | 2021-09-12 04:21:13 | Balochistan, Pakistan | |||
3806047 | 3806047 | 2021-09-11 | Pakistan | Gilgit-Baltistan | 10162 | 179 | 0 | 35.792146 | 74.982138 | 2021-09-12 04:21:13 | Gilgit-Baltistan, Pakistan | |||
3806048 | 3806048 | 2021-09-11 | Pakistan | Islamabad | 102617 | 887 | 0 | 33.665087 | 73.121219 | 2021-09-12 04:21:13 | Islamabad, Pakistan | |||
3806049 | 3806049 | 2021-09-11 | Pakistan | Khyber Pakhtunkhwa | 168258 | 5250 | 0 | 34.485332 | 72.09169 | 2021-09-12 04:21:13 | Khyber Pakhtunkhwa, Pakistan | |||
3806050 | 3806050 | 2021-09-11 | Pakistan | Punjab | 413182 | 12211 | 0 | 30.811346 | 72.13913199999998 | 2021-09-12 04:21:13 | Punjab, Pakistan | |||
3806051 | 3806051 | 2021-09-11 | Pakistan | Sindh | 444464 | 7133 | 0 | 26.009446 | 68.77680699999999 | 2021-09-12 04:21:13 | Sindh, Pakistan | |||
3448985 | 3448985 | 2021-09-10 | Pakistan | Azad Jammu and Kashmir | 33210 | 716 | 0 | 34.027401 | 73.947253 | 2021-09-11 04:21:30 | Azad Jammu and Kashmir, Pakistan | |||
3448986 | 3448986 | 2021-09-10 | Pakistan | Balochistan | 32549 | 342 | 0 | 28.328491999999997 | 65.898403 | 2021-09-11 04:21:30 | Balochistan, Pakistan | |||
3448987 | 3448987 | 2021-09-10 | Pakistan | Gilgit-Baltistan | 10150 | 179 | 0 | 35.792146 | 74.982138 | 2021-09-11 04:21:30 | Gilgit-Baltistan, Pakistan | |||
3448988 | 3448988 | 2021-09-10 | Pakistan | Islamabad | 102347 | 886 | 0 | 33.665087 | 73.121219 | 2021-09-11 04:21:30 | Islamabad, Pakistan | |||
3448989 | 3448989 | 2021-09-10 | Pakistan | Khyber Pakhtunkhwa | 167782 | 5225 | 0 | 34.485332 | 72.09169 | 2021-09-11 04:21:30 | Khyber Pakhtunkhwa, Pakistan | |||
3448990 | 3448990 | 2021-09-10 | Pakistan | Punjab | 411808 | 12198 | 0 | 30.811346 | 72.13913199999998 | 2021-09-11 04:21:30 | Punjab, Pakistan | |||
3448991 | 3448991 | 2021-09-10 | Pakistan | Sindh | 443521 | 7116 | 0 | 26.009446 | 68.77680699999999 | 2021-09-11 04:21:30 | Sindh, Pakistan | |||
1262931 | 1262931 | 2021-09-09 | Pakistan | Azad Jammu and Kashmir | 33131 | 715 | 0 | 34.027401 | 73.947253 | 2021-09-10 04:21:20 | Azad Jammu and Kashmir, Pakistan | |||
1262932 | 1262932 | 2021-09-09 | Pakistan | Balochistan | 32517 | 342 | 0 | 28.328491999999997 | 65.898403 | 2021-09-10 04:21:20 | Balochistan, Pakistan | |||
1262933 | 1262933 | 2021-09-09 | Pakistan | Gilgit-Baltistan | 10127 | 179 | 0 | 35.792146 | 74.982138 | 2021-09-10 04:21:20 | Gilgit-Baltistan, Pakistan | |||
1262934 | 1262934 | 2021-09-09 | Pakistan | Islamabad | 102094 | 884 | 0 | 33.665087 | 73.121219 | 2021-09-10 04:21:20 | Islamabad, Pakistan | |||
1262935 | 1262935 | 2021-09-09 | Pakistan | Khyber Pakhtunkhwa | 167154 | 5200 | 0 | 34.485332 | 72.09169 | 2021-09-10 04:21:20 | Khyber Pakhtunkhwa, Pakistan | |||
1262936 | 1262936 | 2021-09-09 | Pakistan | Punjab | 410463 | 12171 | 0 | 30.811346 | 72.13913199999998 | 2021-09-10 04:21:20 | Punjab, Pakistan | |||
1262937 | 1262937 | 2021-09-09 | Pakistan | Sindh | 442401 | 7089 | 0 | 26.009446 | 68.77680699999999 | 2021-09-10 04:21:20 | Sindh, Pakistan | |||
2279301 | 2279301 | 2021-09-08 | Pakistan | Azad Jammu and Kashmir | 33037 | 714 | 0 | 34.027401 | 73.947253 | 2021-09-09 04:21:27 | Azad Jammu and Kashmir, Pakistan | |||
2279302 | 2279302 | 2021-09-08 | Pakistan | Balochistan | 32480 | 342 | 0 | 28.328491999999997 | 65.898403 | 2021-09-09 04:21:27 | Balochistan, Pakistan | |||
2279303 | 2279303 | 2021-09-08 | Pakistan | Gilgit-Baltistan | 10109 | 179 | 0 | 35.792146 | 74.982138 | 2021-09-09 04:21:27 | Gilgit-Baltistan, Pakistan | |||
2279304 | 2279304 | 2021-09-08 | Pakistan | Islamabad | 101840 | 879 | 0 | 33.665087 | 73.121219 | 2021-09-09 04:21:27 | Islamabad, Pakistan | |||
2279305 | 2279305 | 2021-09-08 | Pakistan | Khyber Pakhtunkhwa | 166564 | 5175 | 0 | 34.485332 | 72.09169 | 2021-09-09 04:21:27 | Khyber Pakhtunkhwa, Pakistan | |||
2279306 | 2279306 | 2021-09-08 | Pakistan | Punjab | 408758 | 12135 | 0 | 30.811346 | 72.13913199999998 | 2021-09-09 04:21:27 | Punjab, Pakistan | |||
2279307 | 2279307 | 2021-09-08 | Pakistan | Sindh | 441410 | 7073 | 0 | 26.009446 | 68.77680699999999 | 2021-09-09 04:21:27 | Sindh, Pakistan | |||
642080 | 642080 | 2021-09-07 | Pakistan | Azad Jammu and Kashmir | 32942 | 712 | 0 | 34.027401 | 73.947253 | 2021-09-08 04:21:31 | Azad Jammu and Kashmir, Pakistan | |||
642081 | 642081 | 2021-09-07 | Pakistan | Balochistan | 32456 | 342 | 0 | 28.328491999999997 | 65.898403 | 2021-09-08 04:21:31 | Balochistan, Pakistan | |||
642082 | 642082 | 2021-09-07 | Pakistan | Gilgit-Baltistan | 10084 | 179 | 0 | 35.792146 | 74.982138 | 2021-09-08 04:21:31 | Gilgit-Baltistan, Pakistan | |||
642083 | 642083 | 2021-09-07 | Pakistan | Islamabad | 101550 | 877 | 0 | 33.665087 | 73.121219 | 2021-09-08 04:21:31 | Islamabad, Pakistan | |||
642084 | 642084 | 2021-09-07 | Pakistan | Khyber Pakhtunkhwa | 165980 | 5155 | 0 | 34.485332 | 72.09169 | 2021-09-08 04:21:31 | Khyber Pakhtunkhwa, Pakistan | |||
642085 | 642085 | 2021-09-07 | Pakistan | Punjab | 406960 | 12118 | 0 | 30.811346 | 72.13913199999998 | 2021-09-08 04:21:31 | Punjab, Pakistan | |||
642086 | 642086 | 2021-09-07 | Pakistan | Sindh | 440164 | 7030 | 0 | 26.009446 | 68.77680699999999 | 2021-09-08 04:21:31 | Sindh, Pakistan | |||
3194143 | 3194143 | 2021-09-06 | Pakistan | Azad Jammu and Kashmir | 32873 | 712 | 0 | 34.027401 | 73.947253 | 2021-09-07 04:21:35 | Azad Jammu and Kashmir, Pakistan | |||
3194144 | 3194144 | 2021-09-06 | Pakistan | Balochistan | 32411 | 342 | 0 | 28.328491999999997 | 65.898403 | 2021-09-07 04:21:35 | Balochistan, Pakistan | |||
3194145 | 3194145 | 2021-09-06 | Pakistan | Gilgit-Baltistan | 10065 | 178 | 0 | 35.792146 | 74.982138 | 2021-09-07 04:21:35 | Gilgit-Baltistan, Pakistan | |||
3194146 | 3194146 | 2021-09-06 | Pakistan | Islamabad | 101249 | 877 | 0 | 33.665087 | 73.121219 | 2021-09-07 04:21:35 | Islamabad, Pakistan | |||
3194147 | 3194147 | 2021-09-06 | Pakistan | Khyber Pakhtunkhwa | 165512 | 5130 | 0 | 34.485332 | 72.09169 | 2021-09-07 04:21:35 | Khyber Pakhtunkhwa, Pakistan | |||
3194148 | 3194148 | 2021-09-06 | Pakistan | Punjab | 405005 | 12096 | 0 | 30.811346 | 72.13913199999998 | 2021-09-07 04:21:35 | Punjab, Pakistan | |||
3194149 | 3194149 | 2021-09-06 | Pakistan | Sindh | 439119 | 6995 | 0 | 26.009446 | 68.77680699999999 | 2021-09-07 04:21:35 | Sindh, Pakistan | |||
3281011 | 3281011 | 2021-09-05 | Pakistan | Azad Jammu and Kashmir | 32824 | 708 | 0 | 34.027401 | 73.947253 | 2021-09-06 04:21:22 | Azad Jammu and Kashmir, Pakistan | |||
3281012 | 3281012 | 2021-09-05 | Pakistan | Balochistan | 32403 | 340 | 0 | 28.328491999999997 | 65.898403 | 2021-09-06 04:21:22 | Balochistan, Pakistan | |||
3281013 | 3281013 | 2021-09-05 | Pakistan | Gilgit-Baltistan | 10051 | 177 | 0 | 35.792146 | 74.982138 | 2021-09-06 04:21:22 | Gilgit-Baltistan, Pakistan | |||
3281014 | 3281014 | 2021-09-05 | Pakistan | Islamabad | 100956 | 874 | 0 | 33.665087 | 73.121219 | 2021-09-06 04:21:22 | Islamabad, Pakistan | |||
3281015 | 3281015 | 2021-09-05 | Pakistan | Khyber Pakhtunkhwa | 165200 | 5107 | 0 | 34.485332 | 72.09169 | 2021-09-06 04:21:22 | Khyber Pakhtunkhwa, Pakistan | |||
3281016 | 3281016 | 2021-09-05 | Pakistan | Punjab | 403157 | 12066 | 0 | 30.811346 | 72.13913199999998 | 2021-09-06 04:21:22 | Punjab, Pakistan | |||
3281017 | 3281017 | 2021-09-05 | Pakistan | Sindh | 438327 | 6960 | 0 | 26.009446 | 68.77680699999999 | 2021-09-06 04:21:22 | Sindh, Pakistan | |||
249425 | 249425 | 2021-09-04 | Pakistan | Azad Jammu and Kashmir | 32718 | 706 | 0 | 34.027401 | 73.947253 | 2021-09-05 04:21:33 | Azad Jammu and Kashmir, Pakistan | |||
249426 | 249426 | 2021-09-04 | Pakistan | Balochistan | 32374 | 340 | 0 | 28.328491999999997 | 65.898403 | 2021-09-05 04:21:33 | Balochistan, Pakistan | |||
249427 | 249427 | 2021-09-04 | Pakistan | Gilgit-Baltistan | 10039 | 175 | 0 | 35.792146 | 74.982138 | 2021-09-05 04:21:33 | Gilgit-Baltistan, Pakistan | |||
249428 | 249428 | 2021-09-04 | Pakistan | Islamabad | 100758 | 873 | 0 | 33.665087 | 73.121219 | 2021-09-05 04:21:33 | Islamabad, Pakistan | |||
249429 | 249429 | 2021-09-04 | Pakistan | Khyber Pakhtunkhwa | 164732 | 5087 | 0 | 34.485332 | 72.09169 | 2021-09-05 04:21:33 | Khyber Pakhtunkhwa, Pakistan | |||
249430 | 249430 | 2021-09-04 | Pakistan | Punjab | 401373 | 12039 | 0 | 30.811346 | 72.13913199999998 | 2021-09-05 04:21:33 | Punjab, Pakistan | |||
249431 | 249431 | 2021-09-04 | Pakistan | Sindh | 437311 | 6955 | 0 | 26.009446 | 68.77680699999999 | 2021-09-05 04:21:33 | Sindh, Pakistan | |||
3974706 | 3974706 | 2021-09-03 | Pakistan | Azad Jammu and Kashmir | 32484 | 702 | 0 | 34.027401 | 73.947253 | 2021-09-04 04:21:28 | Azad Jammu and Kashmir, Pakistan | |||
3974707 | 3974707 | 2021-09-03 | Pakistan | Balochistan | 32329 | 339 | 0 | 28.328491999999997 | 65.898403 | 2021-09-04 04:21:28 | Balochistan, Pakistan | |||
3974708 | 3974708 | 2021-09-03 | Pakistan | Gilgit-Baltistan | 9993 | 174 | 0 | 35.792146 | 74.982138 | 2021-09-04 04:21:28 | Gilgit-Baltistan, Pakistan | |||
3974709 | 3974709 | 2021-09-03 | Pakistan | Islamabad | 100242 | 868 | 0 | 33.665087 | 73.121219 | 2021-09-04 04:21:28 | Islamabad, Pakistan | |||
3974710 | 3974710 | 2021-09-03 | Pakistan | Khyber Pakhtunkhwa | 163677 | 5041 | 0 | 34.485332 | 72.09169 | 2021-09-04 04:21:28 | Khyber Pakhtunkhwa, Pakistan | |||
3974711 | 3974711 | 2021-09-03 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-04 04:21:28 | Punjab, Pakistan | |||
3974712 | 3974712 | 2021-09-03 | Pakistan | Sindh | 435159 | 6932 | 0 | 26.009446 | 68.77680699999999 | 2021-09-04 04:21:28 | Sindh, Pakistan | |||
178168 | 178168 | 2021-09-02 | Pakistan | Azad Jammu and Kashmir | 32484 | 702 | 0 | 34.027401 | 73.947253 | 2021-09-03 04:21:20 | Azad Jammu and Kashmir, Pakistan | |||
178169 | 178169 | 2021-09-02 | Pakistan | Balochistan | 32329 | 339 | 0 | 28.328491999999997 | 65.898403 | 2021-09-03 04:21:20 | Balochistan, Pakistan | |||
178170 | 178170 | 2021-09-02 | Pakistan | Gilgit-Baltistan | 9993 | 174 | 0 | 35.792146 | 74.982138 | 2021-09-03 04:21:20 | Gilgit-Baltistan, Pakistan | |||
178171 | 178171 | 2021-09-02 | Pakistan | Islamabad | 100242 | 868 | 0 | 33.665087 | 73.121219 | 2021-09-03 04:21:20 | Islamabad, Pakistan | |||
178172 | 178172 | 2021-09-02 | Pakistan | Khyber Pakhtunkhwa | 163677 | 5041 | 0 | 34.485332 | 72.09169 | 2021-09-03 04:21:20 | Khyber Pakhtunkhwa, Pakistan | |||
178173 | 178173 | 2021-09-02 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-03 04:21:20 | Punjab, Pakistan | |||
178174 | 178174 | 2021-09-02 | Pakistan | Sindh | 435159 | 6932 | 0 | 26.009446 | 68.77680699999999 | 2021-09-03 04:21:20 | Sindh, Pakistan | |||
67203 | 67203 | 2021-09-01 | Pakistan | Azad Jammu and Kashmir | 32380 | 702 | 0 | 34.027401 | 73.947253 | 2021-09-02 04:21:15 | Azad Jammu and Kashmir, Pakistan | |||
67204 | 67204 | 2021-09-01 | Pakistan | Balochistan | 32248 | 339 | 0 | 28.328491999999997 | 65.898403 | 2021-09-02 04:21:15 | Balochistan, Pakistan | |||
67205 | 67205 | 2021-09-01 | Pakistan | Gilgit-Baltistan | 9952 | 173 | 0 | 35.792146 | 74.982138 | 2021-09-02 04:21:15 | Gilgit-Baltistan, Pakistan | |||
67206 | 67206 | 2021-09-01 | Pakistan | Islamabad | 99910 | 866 | 0 | 33.665087 | 73.121219 | 2021-09-02 04:21:15 | Islamabad, Pakistan | |||
67207 | 67207 | 2021-09-01 | Pakistan | Khyber Pakhtunkhwa | 163010 | 5015 | 0 | 34.485332 | 72.09169 | 2021-09-02 04:21:15 | Khyber Pakhtunkhwa, Pakistan | |||
67208 | 67208 | 2021-09-01 | Pakistan | Punjab | 396326 | 11959 | 0 | 30.811346 | 72.13913199999998 | 2021-09-02 04:21:15 | Punjab, Pakistan | |||
67209 | 67209 | 2021-09-01 | Pakistan | Sindh | 433931 | 6924 | 0 | 26.009446 | 68.77680699999999 | 2021-09-02 04:21:15 | Sindh, Pakistan | |||
2068045 | 2068045 | 2021-08-31 | Pakistan | Azad Jammu and Kashmir | 32228 | 698 | 0 | 34.027401 | 73.947253 | 2021-09-01 04:21:38 | Azad Jammu and Kashmir, Pakistan | |||
2068046 | 2068046 | 2021-08-31 | Pakistan | Balochistan | 32248 | 339 | 0 | 28.328491999999997 | 65.898403 | 2021-09-01 04:21:38 | 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]);