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 688
- Islamabad 688
- Khyber Pakhtunkhwa 688
- Punjab 688
- Sindh 688
- Azad Jammu and Kashmir 687
- Balochistan 687
country_or_region 1
- Pakistan · 4,919 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1696480 | 1696480 | 2022-04-28 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-29 04:20:59 | Gilgit-Baltistan, Pakistan | |||
1696481 | 1696481 | 2022-04-28 | Pakistan | Islamabad | 135178 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-29 04:20:59 | Islamabad, Pakistan | |||
1696482 | 1696482 | 2022-04-28 | Pakistan | Khyber Pakhtunkhwa | 219460 | 6324 | 0 | 34.485332 | 72.09169 | 2022-04-29 04:20:59 | Khyber Pakhtunkhwa, Pakistan | |||
1696483 | 1696483 | 2022-04-28 | Pakistan | Punjab | 506018 | 13560 | 0 | 30.811346 | 72.139132 | 2022-04-29 04:20:59 | Punjab, Pakistan | |||
1696484 | 1696484 | 2022-04-28 | Pakistan | Sindh | 576769 | 8101 | 0 | 26.009446 | 68.776807 | 2022-04-29 04:20:59 | Sindh, Pakistan | |||
3851961 | 3851961 | 2022-04-27 | Pakistan | Azad Jammu and Kashmir | 43310 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-28 04:20:47 | Azad Jammu and Kashmir, Pakistan | |||
3851962 | 3851962 | 2022-04-27 | Pakistan | Balochistan | 35484 | 378 | 0 | 28.328492 | 65.898403 | 2022-04-28 04:20:47 | Balochistan, Pakistan | |||
3851963 | 3851963 | 2022-04-27 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-28 04:20:47 | Gilgit-Baltistan, Pakistan | |||
3851964 | 3851964 | 2022-04-27 | Pakistan | Islamabad | 135178 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-28 04:20:47 | Islamabad, Pakistan | |||
3851965 | 3851965 | 2022-04-27 | Pakistan | Khyber Pakhtunkhwa | 219460 | 6324 | 0 | 34.485332 | 72.09169 | 2022-04-28 04:20:47 | Khyber Pakhtunkhwa, Pakistan | |||
3851966 | 3851966 | 2022-04-27 | Pakistan | Punjab | 506018 | 13560 | 0 | 30.811346 | 72.139132 | 2022-04-28 04:20:47 | Punjab, Pakistan | |||
3851967 | 3851967 | 2022-04-27 | Pakistan | Sindh | 576769 | 8101 | 0 | 26.009446 | 68.776807 | 2022-04-28 04:20:47 | Sindh, Pakistan | |||
1326391 | 1326391 | 2022-04-26 | Pakistan | Azad Jammu and Kashmir | 43310 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-27 04:20:52 | Azad Jammu and Kashmir, Pakistan | |||
1326392 | 1326392 | 2022-04-26 | Pakistan | Balochistan | 35484 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-27 04:20:52 | Balochistan, Pakistan | |||
1326393 | 1326393 | 2022-04-26 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-27 04:20:52 | Gilgit-Baltistan, Pakistan | |||
1326394 | 1326394 | 2022-04-26 | Pakistan | Islamabad | 135178 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-27 04:20:52 | Islamabad, Pakistan | |||
1326395 | 1326395 | 2022-04-26 | Pakistan | Khyber Pakhtunkhwa | 219460 | 6324 | 0 | 34.485332 | 72.09169 | 2022-04-27 04:20:52 | Khyber Pakhtunkhwa, Pakistan | |||
1326396 | 1326396 | 2022-04-26 | Pakistan | Punjab | 506018 | 13560 | 0 | 30.811346 | 72.13913199999998 | 2022-04-27 04:20:52 | Punjab, Pakistan | |||
1326397 | 1326397 | 2022-04-26 | Pakistan | Sindh | 576769 | 8101 | 0 | 26.009446 | 68.77680699999999 | 2022-04-27 04:20:52 | Sindh, Pakistan | |||
3722345 | 3722345 | 2022-04-25 | Pakistan | Azad Jammu and Kashmir | 43310 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-26 04:20:51 | Azad Jammu and Kashmir, Pakistan | |||
3722346 | 3722346 | 2022-04-25 | Pakistan | Balochistan | 35484 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-26 04:20:51 | Balochistan, Pakistan | |||
3722347 | 3722347 | 2022-04-25 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-26 04:20:51 | Gilgit-Baltistan, Pakistan | |||
3722348 | 3722348 | 2022-04-25 | Pakistan | Islamabad | 135178 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-26 04:20:51 | Islamabad, Pakistan | |||
3722349 | 3722349 | 2022-04-25 | Pakistan | Khyber Pakhtunkhwa | 219460 | 6324 | 0 | 34.485332 | 72.09169 | 2022-04-26 04:20:51 | Khyber Pakhtunkhwa, Pakistan | |||
3722350 | 3722350 | 2022-04-25 | Pakistan | Punjab | 506018 | 13560 | 0 | 30.811346 | 72.13913199999998 | 2022-04-26 04:20:51 | Punjab, Pakistan | |||
3722351 | 3722351 | 2022-04-25 | Pakistan | Sindh | 576769 | 8101 | 0 | 26.009446 | 68.77680699999999 | 2022-04-26 04:20:51 | Sindh, Pakistan | |||
2028913 | 2028913 | 2022-04-24 | Pakistan | Azad Jammu and Kashmir | 43310 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-25 04:20:56 | Azad Jammu and Kashmir, Pakistan | |||
2028914 | 2028914 | 2022-04-24 | Pakistan | Balochistan | 35484 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-25 04:20:56 | Balochistan, Pakistan | |||
2028915 | 2028915 | 2022-04-24 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-25 04:20:56 | Gilgit-Baltistan, Pakistan | |||
2028916 | 2028916 | 2022-04-24 | Pakistan | Islamabad | 135178 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-25 04:20:56 | Islamabad, Pakistan | |||
2028917 | 2028917 | 2022-04-24 | Pakistan | Khyber Pakhtunkhwa | 219460 | 6324 | 0 | 34.485332 | 72.09169 | 2022-04-25 04:20:56 | Khyber Pakhtunkhwa, Pakistan | |||
2028918 | 2028918 | 2022-04-24 | Pakistan | Punjab | 506018 | 13560 | 0 | 30.811346 | 72.13913199999998 | 2022-04-25 04:20:56 | Punjab, Pakistan | |||
2028919 | 2028919 | 2022-04-24 | Pakistan | Sindh | 576769 | 8101 | 0 | 26.009446 | 68.77680699999999 | 2022-04-25 04:20:56 | Sindh, Pakistan | |||
746488 | 746488 | 2022-04-23 | Pakistan | Azad Jammu and Kashmir | 43308 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-24 04:20:56 | Azad Jammu and Kashmir, Pakistan | |||
746489 | 746489 | 2022-04-23 | Pakistan | Balochistan | 35484 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-24 04:20:56 | Balochistan, Pakistan | |||
746490 | 746490 | 2022-04-23 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-24 04:20:56 | Gilgit-Baltistan, Pakistan | |||
746491 | 746491 | 2022-04-23 | Pakistan | Islamabad | 135170 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-24 04:20:56 | Islamabad, Pakistan | |||
746492 | 746492 | 2022-04-23 | Pakistan | Khyber Pakhtunkhwa | 219437 | 6324 | 0 | 34.485332 | 72.09169 | 2022-04-24 04:20:56 | Khyber Pakhtunkhwa, Pakistan | |||
746493 | 746493 | 2022-04-23 | Pakistan | Punjab | 505904 | 13560 | 0 | 30.811346 | 72.13913199999998 | 2022-04-24 04:20:56 | Punjab, Pakistan | |||
746494 | 746494 | 2022-04-23 | Pakistan | Sindh | 576711 | 8101 | 0 | 26.009446 | 68.77680699999999 | 2022-04-24 04:20:56 | Sindh, Pakistan | |||
3436973 | 3436973 | 2022-04-22 | Pakistan | Azad Jammu and Kashmir | 43308 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-23 04:20:50 | Azad Jammu and Kashmir, Pakistan | |||
3436974 | 3436974 | 2022-04-22 | Pakistan | Balochistan | 35484 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-23 04:20:50 | Balochistan, Pakistan | |||
3436975 | 3436975 | 2022-04-22 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-23 04:20:50 | Gilgit-Baltistan, Pakistan | |||
3436976 | 3436976 | 2022-04-22 | Pakistan | Islamabad | 135170 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-23 04:20:50 | Islamabad, Pakistan | |||
3436977 | 3436977 | 2022-04-22 | Pakistan | Khyber Pakhtunkhwa | 219437 | 6324 | 0 | 34.485332 | 72.09169 | 2022-04-23 04:20:50 | Khyber Pakhtunkhwa, Pakistan | |||
3436978 | 3436978 | 2022-04-22 | Pakistan | Punjab | 505904 | 13560 | 0 | 30.811346 | 72.13913199999998 | 2022-04-23 04:20:50 | Punjab, Pakistan | |||
3436979 | 3436979 | 2022-04-22 | Pakistan | Sindh | 576711 | 8101 | 0 | 26.009446 | 68.77680699999999 | 2022-04-23 04:20:50 | Sindh, Pakistan | |||
2892558 | 2892558 | 2022-04-21 | Pakistan | Azad Jammu and Kashmir | 43308 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-22 04:20:45 | Azad Jammu and Kashmir, Pakistan | |||
2892559 | 2892559 | 2022-04-21 | Pakistan | Balochistan | 35483 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-22 04:20:45 | Balochistan, Pakistan | |||
2892560 | 2892560 | 2022-04-21 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-22 04:20:45 | Gilgit-Baltistan, Pakistan | |||
2892561 | 2892561 | 2022-04-21 | Pakistan | Islamabad | 135168 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-22 04:20:45 | Islamabad, Pakistan | |||
2892562 | 2892562 | 2022-04-21 | Pakistan | Khyber Pakhtunkhwa | 219422 | 6323 | 0 | 34.485332 | 72.09169 | 2022-04-22 04:20:45 | Khyber Pakhtunkhwa, Pakistan | |||
2892563 | 2892563 | 2022-04-21 | Pakistan | Punjab | 505857 | 13560 | 0 | 30.811346 | 72.13913199999998 | 2022-04-22 04:20:45 | Punjab, Pakistan | |||
2892564 | 2892564 | 2022-04-21 | Pakistan | Sindh | 576694 | 8101 | 0 | 26.009446 | 68.77680699999999 | 2022-04-22 04:20:45 | Sindh, Pakistan | |||
2307430 | 2307430 | 2022-04-20 | Pakistan | Azad Jammu and Kashmir | 43306 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-21 04:20:46 | Azad Jammu and Kashmir, Pakistan | |||
2307431 | 2307431 | 2022-04-20 | Pakistan | Balochistan | 35483 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-21 04:20:46 | Balochistan, Pakistan | |||
2307432 | 2307432 | 2022-04-20 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-21 04:20:46 | Gilgit-Baltistan, Pakistan | |||
2307433 | 2307433 | 2022-04-20 | Pakistan | Islamabad | 135165 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-21 04:20:46 | Islamabad, Pakistan | |||
2307434 | 2307434 | 2022-04-20 | Pakistan | Khyber Pakhtunkhwa | 219411 | 6323 | 0 | 34.485332 | 72.09169 | 2022-04-21 04:20:46 | Khyber Pakhtunkhwa, Pakistan | |||
2307435 | 2307435 | 2022-04-20 | Pakistan | Punjab | 505810 | 13560 | 0 | 30.811346 | 72.13913199999998 | 2022-04-21 04:20:46 | Punjab, Pakistan | |||
2307436 | 2307436 | 2022-04-20 | Pakistan | Sindh | 576677 | 8101 | 0 | 26.009446 | 68.77680699999999 | 2022-04-21 04:20:46 | Sindh, Pakistan | |||
2251569 | 2251569 | 2022-04-19 | Pakistan | Azad Jammu and Kashmir | 43306 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-20 04:20:45 | Azad Jammu and Kashmir, Pakistan | |||
2251570 | 2251570 | 2022-04-19 | Pakistan | Balochistan | 35483 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-20 04:20:45 | Balochistan, Pakistan | |||
2251571 | 2251571 | 2022-04-19 | Pakistan | Gilgit-Baltistan | 11736 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-20 04:20:45 | Gilgit-Baltistan, Pakistan | |||
2251572 | 2251572 | 2022-04-19 | Pakistan | Islamabad | 135165 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-20 04:20:45 | Islamabad, Pakistan | |||
2251573 | 2251573 | 2022-04-19 | Pakistan | Khyber Pakhtunkhwa | 219397 | 6323 | 0 | 34.485332 | 72.09169 | 2022-04-20 04:20:45 | Khyber Pakhtunkhwa, Pakistan | |||
2251574 | 2251574 | 2022-04-19 | Pakistan | Punjab | 505757 | 13560 | 0 | 30.811346 | 72.13913199999998 | 2022-04-20 04:20:45 | Punjab, Pakistan | |||
2251575 | 2251575 | 2022-04-19 | Pakistan | Sindh | 576642 | 8101 | 0 | 26.009446 | 68.77680699999999 | 2022-04-20 04:20:45 | Sindh, Pakistan | |||
1846119 | 1846119 | 2022-04-18 | Pakistan | Azad Jammu and Kashmir | 43306 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-19 04:21:00 | Azad Jammu and Kashmir, Pakistan | |||
1846120 | 1846120 | 2022-04-18 | Pakistan | Balochistan | 35483 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-19 04:21:00 | Balochistan, Pakistan | |||
1846121 | 1846121 | 2022-04-18 | Pakistan | Gilgit-Baltistan | 11736 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-19 04:21:00 | Gilgit-Baltistan, Pakistan | |||
1846122 | 1846122 | 2022-04-18 | Pakistan | Islamabad | 135159 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-19 04:21:00 | Islamabad, Pakistan | |||
1846123 | 1846123 | 2022-04-18 | Pakistan | Khyber Pakhtunkhwa | 219389 | 6323 | 0 | 34.485332 | 72.09169 | 2022-04-19 04:21:00 | Khyber Pakhtunkhwa, Pakistan | |||
1846124 | 1846124 | 2022-04-18 | Pakistan | Punjab | 505720 | 13559 | 0 | 30.811346 | 72.13913199999998 | 2022-04-19 04:21:00 | Punjab, Pakistan | |||
1846125 | 1846125 | 2022-04-18 | Pakistan | Sindh | 576618 | 8098 | 0 | 26.009446 | 68.77680699999999 | 2022-04-19 04:21:00 | Sindh, Pakistan | |||
3417063 | 3417063 | 2022-04-17 | Pakistan | Azad Jammu and Kashmir | 43306 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-18 04:21:12 | Azad Jammu and Kashmir, Pakistan | |||
3417064 | 3417064 | 2022-04-17 | Pakistan | Balochistan | 35483 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-18 04:21:12 | Balochistan, Pakistan | |||
3417065 | 3417065 | 2022-04-17 | Pakistan | Gilgit-Baltistan | 11735 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-18 04:21:12 | Gilgit-Baltistan, Pakistan | |||
3417066 | 3417066 | 2022-04-17 | Pakistan | Islamabad | 135157 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-18 04:21:12 | Islamabad, Pakistan | |||
3417067 | 3417067 | 2022-04-17 | Pakistan | Khyber Pakhtunkhwa | 219385 | 6323 | 0 | 34.485332 | 72.09169 | 2022-04-18 04:21:12 | Khyber Pakhtunkhwa, Pakistan | |||
3417068 | 3417068 | 2022-04-17 | Pakistan | Punjab | 505690 | 13559 | 0 | 30.811346 | 72.13913199999998 | 2022-04-18 04:21:12 | Punjab, Pakistan | |||
3417069 | 3417069 | 2022-04-17 | Pakistan | Sindh | 576570 | 8098 | 0 | 26.009446 | 68.77680699999999 | 2022-04-18 04:21:12 | Sindh, Pakistan | |||
304012 | 304012 | 2022-04-16 | Pakistan | Azad Jammu and Kashmir | 43306 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-17 04:20:59 | Azad Jammu and Kashmir, Pakistan | |||
304013 | 304013 | 2022-04-16 | Pakistan | Balochistan | 35483 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-17 04:20:59 | Balochistan, Pakistan | |||
304014 | 304014 | 2022-04-16 | Pakistan | Gilgit-Baltistan | 11729 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-17 04:20:59 | Gilgit-Baltistan, Pakistan | |||
304015 | 304015 | 2022-04-16 | Pakistan | Islamabad | 135150 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-17 04:20:59 | Islamabad, Pakistan | |||
304016 | 304016 | 2022-04-16 | Pakistan | Khyber Pakhtunkhwa | 219371 | 6322 | 0 | 34.485332 | 72.09169 | 2022-04-17 04:20:59 | Khyber Pakhtunkhwa, Pakistan | |||
304017 | 304017 | 2022-04-16 | Pakistan | Punjab | 505660 | 13559 | 0 | 30.811346 | 72.13913199999998 | 2022-04-17 04:20:59 | Punjab, Pakistan | |||
304018 | 304018 | 2022-04-16 | Pakistan | Sindh | 576549 | 8098 | 0 | 26.009446 | 68.77680699999999 | 2022-04-17 04:20:59 | Sindh, Pakistan | |||
2669957 | 2669957 | 2022-04-15 | Pakistan | Azad Jammu and Kashmir | 43304 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-16 04:20:48 | Azad Jammu and Kashmir, Pakistan | |||
2669958 | 2669958 | 2022-04-15 | Pakistan | Balochistan | 35483 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-16 04:20:48 | Balochistan, Pakistan | |||
2669959 | 2669959 | 2022-04-15 | Pakistan | Gilgit-Baltistan | 11723 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-16 04:20:48 | Gilgit-Baltistan, Pakistan | |||
2669960 | 2669960 | 2022-04-15 | Pakistan | Islamabad | 135148 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-16 04:20:48 | Islamabad, Pakistan | |||
2669961 | 2669961 | 2022-04-15 | Pakistan | Khyber Pakhtunkhwa | 219362 | 6322 | 0 | 34.485332 | 72.09169 | 2022-04-16 04:20:48 | Khyber Pakhtunkhwa, Pakistan | |||
2669962 | 2669962 | 2022-04-15 | Pakistan | Punjab | 505614 | 13559 | 0 | 30.811346 | 72.13913199999998 | 2022-04-16 04:20:48 | Punjab, Pakistan | |||
2669963 | 2669963 | 2022-04-15 | Pakistan | Sindh | 576517 | 8098 | 0 | 26.009446 | 68.77680699999999 | 2022-04-16 04:20:48 | Sindh, Pakistan | |||
1223742 | 1223742 | 2022-04-14 | Pakistan | Azad Jammu and Kashmir | 43303 | 792 | 0 | 34.027401 | 73.947253 | 2022-04-15 04:20:57 | Azad Jammu and Kashmir, Pakistan | |||
1223743 | 1223743 | 2022-04-14 | Pakistan | Balochistan | 35481 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-04-15 04:20:57 | Balochistan, Pakistan | |||
1223744 | 1223744 | 2022-04-14 | Pakistan | Gilgit-Baltistan | 11722 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-15 04:20:57 | Gilgit-Baltistan, Pakistan | |||
1223745 | 1223745 | 2022-04-14 | Pakistan | Islamabad | 135141 | 1023 | 0 | 33.665087 | 73.121219 | 2022-04-15 04:20:57 | 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]);