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 rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)
province_or_state 7
- Azad Jammu and Kashmir 933
- Balochistan 933
- Gilgit-Baltistan 933
- Islamabad 933
- Khyber Pakhtunkhwa 933
- Punjab 933
- Sindh 933
country_or_region 1
- Pakistan · 6,636 ✖
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002820 | 4002820 | 2022-10-08 | Pakistan | Sindh | 594417 | 8242 | 0 | 26.009446 | 68.776807 | 2022-10-09 04:21:16 | Sindh, Pakistan | |||
4002819 | 4002819 | 2022-10-08 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-09 04:21:16 | Punjab, Pakistan | |||
4002818 | 4002818 | 2022-10-08 | Pakistan | Khyber Pakhtunkhwa | 224312 | 6370 | 0 | 34.485332 | 72.09169 | 2022-10-09 04:21:16 | Khyber Pakhtunkhwa, Pakistan | |||
4002817 | 4002817 | 2022-10-08 | Pakistan | Islamabad | 139425 | 1031 | 0 | 33.665087 | 73.121219 | 2022-10-09 04:21:16 | Islamabad, Pakistan | |||
4002816 | 4002816 | 2022-10-08 | Pakistan | Gilgit-Baltistan | 12059 | 191 | 0 | 35.792146 | 74.982138 | 2022-10-09 04:21:16 | Gilgit-Baltistan, Pakistan | |||
4002815 | 4002815 | 2022-10-08 | Pakistan | Balochistan | 36002 | 378 | 0 | 28.328492 | 65.898403 | 2022-10-09 04:21:16 | Balochistan, Pakistan | |||
4002814 | 4002814 | 2022-10-08 | Pakistan | Azad Jammu and Kashmir | 44320 | 793 | 0 | 34.027401 | 73.947253 | 2022-10-09 04:21:16 | Azad Jammu and Kashmir, Pakistan | |||
3998800 | 3998800 | 2021-12-30 | Pakistan | Sindh | 481689 | 7670 | 0 | 26.009446 | 68.77680699999999 | 2021-12-31 04:21:50 | Sindh, Pakistan | |||
3998799 | 3998799 | 2021-12-30 | Pakistan | Punjab | 444977 | 13066 | 0 | 30.811346 | 72.13913199999998 | 2021-12-31 04:21:50 | Punjab, Pakistan | |||
3998798 | 3998798 | 2021-12-30 | Pakistan | Khyber Pakhtunkhwa | 181370 | 5928 | 0 | 34.485332 | 72.09169 | 2021-12-31 04:21:50 | Khyber Pakhtunkhwa, Pakistan | |||
3998797 | 3998797 | 2021-12-30 | Pakistan | Islamabad | 108618 | 967 | 0 | 33.665087 | 73.121219 | 2021-12-31 04:21:50 | Islamabad, Pakistan | |||
3998796 | 3998796 | 2021-12-30 | Pakistan | Gilgit-Baltistan | 10429 | 186 | 0 | 35.792146 | 74.982138 | 2021-12-31 04:21:50 | Gilgit-Baltistan, Pakistan | |||
3998795 | 3998795 | 2021-12-30 | Pakistan | Balochistan | 33633 | 364 | 0 | 28.328491999999997 | 65.898403 | 2021-12-31 04:21:50 | Balochistan, Pakistan | |||
3998794 | 3998794 | 2021-12-30 | Pakistan | Azad Jammu and Kashmir | 34660 | 746 | 0 | 34.027401 | 73.947253 | 2021-12-31 04:21:50 | Azad Jammu and Kashmir, Pakistan | |||
3994788 | 3994788 | 2022-09-27 | Pakistan | Sindh | 594261 | 8240 | 0 | 26.009446 | 68.776807 | 2022-09-28 04:23:01 | Sindh, Pakistan | |||
3994787 | 3994787 | 2022-09-27 | Pakistan | Punjab | 522137 | 13613 | 0 | 30.811346 | 72.139132 | 2022-09-28 04:23:01 | Punjab, Pakistan | |||
3994786 | 3994786 | 2022-09-27 | Pakistan | Khyber Pakhtunkhwa | 224231 | 6366 | 0 | 34.485332 | 72.09169 | 2022-09-28 04:23:01 | Khyber Pakhtunkhwa, Pakistan | |||
3994785 | 3994785 | 2022-09-27 | Pakistan | Islamabad | 139411 | 1031 | 0 | 33.665087 | 73.121219 | 2022-09-28 04:23:01 | Islamabad, Pakistan | |||
3994784 | 3994784 | 2022-09-27 | Pakistan | Gilgit-Baltistan | 12057 | 191 | 0 | 35.792146 | 74.982138 | 2022-09-28 04:23:01 | Gilgit-Baltistan, Pakistan | |||
3994783 | 3994783 | 2022-09-27 | Pakistan | Balochistan | 35996 | 378 | 0 | 28.328492 | 65.898403 | 2022-09-28 04:23:01 | Balochistan, Pakistan | |||
3994782 | 3994782 | 2022-09-27 | Pakistan | Azad Jammu and Kashmir | 44317 | 793 | 0 | 34.027401 | 73.947253 | 2022-09-28 04:23:01 | Azad Jammu and Kashmir, Pakistan | |||
3990753 | 3990753 | 2020-10-20 | Pakistan | Sindh | 142348 | 2587 | 135494 | 4267 | 26.009446 | 68.77680699999999 | 2020-10-21 04:24:14 | Sindh, Pakistan | ||
3990752 | 3990752 | 2020-10-20 | Pakistan | Punjab | 101936 | 2319 | 97271 | 2346 | 30.811346 | 72.13913199999998 | 2020-10-21 04:24:14 | Punjab, Pakistan | ||
3990751 | 3990751 | 2020-10-20 | Pakistan | Khyber Pakhtunkhwa | 38779 | 1265 | 37064 | 450 | 34.485332 | 72.09169 | 2020-10-21 04:24:14 | Khyber Pakhtunkhwa, Pakistan | ||
3990750 | 3990750 | 2020-10-20 | Pakistan | Islamabad | 18309 | 199 | 16888 | 1222 | 33.665087 | 73.121219 | 2020-10-21 04:24:14 | Islamabad, Pakistan | ||
3990749 | 3990749 | 2020-10-20 | Pakistan | Gilgit-Baltistan | 4091 | 90 | 3771 | 230 | 35.792146 | 74.982138 | 2020-10-21 04:24:14 | Gilgit-Baltistan, Pakistan | ||
3990748 | 3990748 | 2020-10-20 | Pakistan | Balochistan | 15717 | 148 | 15351 | 218 | 28.328492 | 65.898403 | 2020-10-21 04:24:14 | Balochistan, Pakistan | ||
3990747 | 3990747 | 2020-10-20 | Pakistan | Azad Jammu and Kashmir | 3564 | 84 | 2835 | 645 | 34.027401 | 73.947253 | 2020-10-21 04:24:14 | Azad Jammu and Kashmir, Pakistan | ||
3986777 | 3986777 | 2022-09-15 | Pakistan | Sindh | 593867 | 8238 | 0 | 26.009446 | 68.776807 | 2022-09-16 04:21:19 | Sindh, Pakistan | |||
3986776 | 3986776 | 2022-09-15 | Pakistan | Punjab | 521917 | 13611 | 0 | 30.811346 | 72.139132 | 2022-09-16 04:21:19 | Punjab, Pakistan | |||
3986775 | 3986775 | 2022-09-15 | Pakistan | Khyber Pakhtunkhwa | 224053 | 6362 | 0 | 34.485332 | 72.09169 | 2022-09-16 04:21:19 | Khyber Pakhtunkhwa, Pakistan | |||
3986774 | 3986774 | 2022-09-15 | Pakistan | Islamabad | 139358 | 1031 | 0 | 33.665087 | 73.121219 | 2022-09-16 04:21:19 | Islamabad, Pakistan | |||
3986773 | 3986773 | 2022-09-15 | Pakistan | Gilgit-Baltistan | 12046 | 191 | 0 | 35.792146 | 74.982138 | 2022-09-16 04:21:19 | Gilgit-Baltistan, Pakistan | |||
3986772 | 3986772 | 2022-09-15 | Pakistan | Balochistan | 35980 | 378 | 0 | 28.328492 | 65.898403 | 2022-09-16 04:21:19 | Balochistan, Pakistan | |||
3986771 | 3986771 | 2022-09-15 | Pakistan | Azad Jammu and Kashmir | 44309 | 793 | 0 | 34.027401 | 73.947253 | 2022-09-16 04:21:19 | Azad Jammu and Kashmir, Pakistan | |||
3982759 | 3982759 | 2022-06-15 | Pakistan | Sindh | 578006 | 8108 | 0 | 26.009446 | 68.776807 | 2022-06-16 04:20:55 | Sindh, Pakistan | |||
3982758 | 3982758 | 2022-06-15 | Pakistan | Punjab | 507561 | 13565 | 0 | 30.811346 | 72.139132 | 2022-06-16 04:20:55 | Punjab, Pakistan | |||
3982757 | 3982757 | 2022-06-15 | Pakistan | Khyber Pakhtunkhwa | 219756 | 6324 | 0 | 34.485332 | 72.09169 | 2022-06-16 04:20:55 | Khyber Pakhtunkhwa, Pakistan | |||
3982756 | 3982756 | 2022-06-15 | Pakistan | Islamabad | 135643 | 1024 | 0 | 33.665087 | 73.121219 | 2022-06-16 04:20:55 | Islamabad, Pakistan | |||
3982755 | 3982755 | 2022-06-15 | Pakistan | Gilgit-Baltistan | 11753 | 191 | 0 | 35.792146 | 74.982138 | 2022-06-16 04:20:55 | Gilgit-Baltistan, Pakistan | |||
3982754 | 3982754 | 2022-06-15 | Pakistan | Balochistan | 35506 | 378 | 0 | 28.328492 | 65.898403 | 2022-06-16 04:20:55 | Balochistan, Pakistan | |||
3982753 | 3982753 | 2022-06-15 | Pakistan | Azad Jammu and Kashmir | 43356 | 792 | 0 | 34.027401 | 73.947253 | 2022-06-16 04:20:55 | Azad Jammu and Kashmir, Pakistan | |||
3978723 | 3978723 | 2021-02-10 | Pakistan | Sindh | 252296 | 4171 | 229215 | 18910 | 26.009446 | 68.77680699999999 | 2021-02-11 05:23:55 | Sindh, Pakistan | ||
3978722 | 3978722 | 2021-02-10 | Pakistan | Punjab | 162391 | 4982 | 149987 | 7422 | 30.811346 | 72.13913199999998 | 2021-02-11 05:23:55 | Punjab, Pakistan | ||
3978721 | 3978721 | 2021-02-10 | Pakistan | Khyber Pakhtunkhwa | 68972 | 1976 | 64933 | 2063 | 34.485332 | 72.09169 | 2021-02-11 05:23:55 | Khyber Pakhtunkhwa, Pakistan | ||
3978720 | 3978720 | 2021-02-10 | Pakistan | Islamabad | 42279 | 481 | 40516 | 1282 | 33.665087 | 73.121219 | 2021-02-11 05:23:55 | Islamabad, Pakistan | ||
3978719 | 3978719 | 2021-02-10 | Pakistan | Gilgit-Baltistan | 4923 | 102 | 4799 | 22 | 35.792146 | 74.982138 | 2021-02-11 05:23:55 | Gilgit-Baltistan, Pakistan | ||
3978718 | 3978718 | 2021-02-10 | Pakistan | Balochistan | 18898 | 197 | 18619 | 82 | 28.328492 | 65.898403 | 2021-02-11 05:23:55 | Balochistan, Pakistan | ||
3978717 | 3978717 | 2021-02-10 | Pakistan | Azad Jammu and Kashmir | 9334 | 276 | 8614 | 444 | 34.027401 | 73.947253 | 2021-02-11 05:23:55 | Azad Jammu and Kashmir, Pakistan | ||
3974712 | 3974712 | 2021-09-03 | Pakistan | Sindh | 435159 | 6932 | 0 | 26.009446 | 68.77680699999999 | 2021-09-04 04:21:28 | Sindh, Pakistan | |||
3974711 | 3974711 | 2021-09-03 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-04 04:21:28 | Punjab, 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 | |||
3974709 | 3974709 | 2021-09-03 | Pakistan | Islamabad | 100242 | 868 | 0 | 33.665087 | 73.121219 | 2021-09-04 04:21:28 | Islamabad, 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 | |||
3974707 | 3974707 | 2021-09-03 | Pakistan | Balochistan | 32329 | 339 | 0 | 28.328491999999997 | 65.898403 | 2021-09-04 04:21:28 | Balochistan, 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 | |||
3970697 | 3970697 | 2021-06-11 | Pakistan | Sindh | 327021 | 5220 | 298344 | 23457 | 26.009446 | 68.77680699999999 | 2021-06-12 04:22:22 | Sindh, Pakistan | ||
3970696 | 3970696 | 2021-06-11 | Pakistan | Punjab | 343703 | 10479 | 321422 | 11802 | 30.811346 | 72.13913199999998 | 2021-06-12 04:22:22 | Punjab, Pakistan | ||
3970695 | 3970695 | 2021-06-11 | Pakistan | Khyber Pakhtunkhwa | 135569 | 4203 | 127820 | 3546 | 34.485332 | 72.09169 | 2021-06-12 04:22:22 | Khyber Pakhtunkhwa, Pakistan | ||
3970694 | 3970694 | 2021-06-11 | Pakistan | Islamabad | 82065 | 769 | 79140 | 2156 | 33.665087 | 73.121219 | 2021-06-12 04:22:22 | Islamabad, Pakistan | ||
3970693 | 3970693 | 2021-06-11 | Pakistan | Gilgit-Baltistan | 5698 | 108 | 5488 | 102 | 35.792146 | 74.982138 | 2021-06-12 04:22:22 | Gilgit-Baltistan, Pakistan | ||
3970692 | 3970692 | 2021-06-11 | Pakistan | Balochistan | 26152 | 292 | 24788 | 1072 | 28.328492 | 65.898403 | 2021-06-12 04:22:22 | Balochistan, Pakistan | ||
3970691 | 3970691 | 2021-06-11 | Pakistan | Azad Jammu and Kashmir | 19723 | 562 | 18579 | 582 | 34.027401 | 73.947253 | 2021-06-12 04:22:22 | Azad Jammu and Kashmir, Pakistan | ||
3966701 | 3966701 | 2022-07-05 | Pakistan | Sindh | 583084 | 8118 | 0 | 26.009446 | 68.776807 | 2022-07-06 04:20:58 | Sindh, Pakistan | |||
3966700 | 3966700 | 2022-07-05 | Pakistan | Punjab | 508920 | 13574 | 0 | 30.811346 | 72.139132 | 2022-07-06 04:20:58 | Punjab, Pakistan | |||
3966699 | 3966699 | 2022-07-05 | Pakistan | Khyber Pakhtunkhwa | 220132 | 6324 | 0 | 34.485332 | 72.09169 | 2022-07-06 04:20:58 | Khyber Pakhtunkhwa, Pakistan | |||
3966698 | 3966698 | 2022-07-05 | Pakistan | Islamabad | 136381 | 1026 | 0 | 33.665087 | 73.121219 | 2022-07-06 04:20:58 | Islamabad, Pakistan | |||
3966697 | 3966697 | 2022-07-05 | Pakistan | Gilgit-Baltistan | 11763 | 191 | 0 | 35.792146 | 74.982138 | 2022-07-06 04:20:58 | Gilgit-Baltistan, Pakistan | |||
3966696 | 3966696 | 2022-07-05 | Pakistan | Balochistan | 35582 | 378 | 0 | 28.328492 | 65.898403 | 2022-07-06 04:20:58 | Balochistan, Pakistan | |||
3966695 | 3966695 | 2022-07-05 | Pakistan | Azad Jammu and Kashmir | 43413 | 792 | 0 | 34.027401 | 73.947253 | 2022-07-06 04:20:58 | Azad Jammu and Kashmir, Pakistan | |||
3962666 | 3962666 | 2021-03-10 | Pakistan | Sindh | 260406 | 4448 | 251673 | 4285 | 26.009446 | 68.77680699999999 | 2021-03-11 05:25:48 | Sindh, Pakistan | ||
3962665 | 3962665 | 2021-03-10 | Pakistan | Punjab | 180944 | 5662 | 167967 | 7315 | 30.811346 | 72.13913199999998 | 2021-03-11 05:25:48 | Punjab, Pakistan | ||
3962664 | 3962664 | 2021-03-10 | Pakistan | Khyber Pakhtunkhwa | 74722 | 2129 | 70044 | 2549 | 34.485332 | 72.09169 | 2021-03-11 05:25:48 | Khyber Pakhtunkhwa, Pakistan | ||
3962663 | 3962663 | 2021-03-10 | Pakistan | Islamabad | 46579 | 516 | 43435 | 2628 | 33.665087 | 73.121219 | 2021-03-11 05:25:48 | Islamabad, Pakistan | ||
3962662 | 3962662 | 2021-03-10 | Pakistan | Gilgit-Baltistan | 4959 | 104 | 4855 | 0 | 35.792146 | 74.982138 | 2021-03-11 05:25:48 | Gilgit-Baltistan, Pakistan | ||
3962661 | 3962661 | 2021-03-10 | Pakistan | Balochistan | 19157 | 202 | 18845 | 110 | 28.328492 | 65.898403 | 2021-03-11 05:25:48 | Balochistan, Pakistan | ||
3962660 | 3962660 | 2021-03-10 | Pakistan | Azad Jammu and Kashmir | 10730 | 316 | 9673 | 741 | 34.027401 | 73.947253 | 2021-03-11 05:25:48 | Azad Jammu and Kashmir, Pakistan | ||
3958654 | 3958654 | 2021-06-26 | Pakistan | Sindh | 335555 | 5410 | 311005 | 19140 | 26.009446 | 68.77680699999999 | 2021-06-27 04:21:39 | Sindh, Pakistan | ||
3958653 | 3958653 | 2021-06-26 | Pakistan | Punjab | 345796 | 10721 | 326231 | 8844 | 30.811346 | 72.13913199999998 | 2021-06-27 04:21:39 | Punjab, Pakistan | ||
3958652 | 3958652 | 2021-06-26 | Pakistan | Khyber Pakhtunkhwa | 137628 | 4304 | 131513 | 1811 | 34.485332 | 72.09169 | 2021-06-27 04:21:39 | Khyber Pakhtunkhwa, Pakistan | ||
3958651 | 3958651 | 2021-06-26 | Pakistan | Islamabad | 82565 | 776 | 80815 | 974 | 33.665087 | 73.121219 | 2021-06-27 04:21:39 | Islamabad, Pakistan | ||
3958650 | 3958650 | 2021-06-26 | Pakistan | Gilgit-Baltistan | 5984 | 111 | 5657 | 216 | 35.792146 | 74.982138 | 2021-06-27 04:21:39 | Gilgit-Baltistan, Pakistan | ||
3958649 | 3958649 | 2021-06-26 | Pakistan | Balochistan | 27003 | 307 | 25874 | 822 | 28.328492 | 65.898403 | 2021-06-27 04:21:39 | Balochistan, Pakistan | ||
3958648 | 3958648 | 2021-06-26 | Pakistan | Azad Jammu and Kashmir | 20212 | 582 | 19196 | 434 | 34.027401 | 73.947253 | 2021-06-27 04:21:39 | Azad Jammu and Kashmir, Pakistan | ||
3954638 | 3954638 | 2021-05-11 | Pakistan | Sindh | 294251 | 4765 | 271581 | 17905 | 26.009446 | 68.77680699999999 | 2021-05-12 04:21:29 | Sindh, Pakistan | ||
3954637 | 3954637 | 2021-05-11 | Pakistan | Punjab | 322117 | 9188 | 276800 | 36129 | 30.811346 | 72.13913199999998 | 2021-05-12 04:21:29 | Punjab, Pakistan | ||
3954636 | 3954636 | 2021-05-11 | Pakistan | Khyber Pakhtunkhwa | 125392 | 3668 | 112706 | 9018 | 34.485332 | 72.09169 | 2021-05-12 04:21:29 | Khyber Pakhtunkhwa, Pakistan | ||
3954635 | 3954635 | 2021-05-11 | Pakistan | Islamabad | 78560 | 718 | 67811 | 10031 | 33.665087 | 73.121219 | 2021-05-12 04:21:29 | Islamabad, Pakistan | ||
3954634 | 3954634 | 2021-05-11 | Pakistan | Gilgit-Baltistan | 5407 | 107 | 5186 | 114 | 35.792146 | 74.982138 | 2021-05-12 04:21:29 | Gilgit-Baltistan, Pakistan | ||
3954633 | 3954633 | 2021-05-11 | Pakistan | Balochistan | 23655 | 255 | 22012 | 1388 | 28.328492 | 65.898403 | 2021-05-12 04:21:29 | Balochistan, Pakistan | ||
3954632 | 3954632 | 2021-05-11 | Pakistan | Azad Jammu and Kashmir | 18056 | 509 | 15596 | 1951 | 34.027401 | 73.947253 | 2021-05-12 04:21:29 | Azad Jammu and Kashmir, Pakistan | ||
3950643 | 3950643 | 2022-08-17 | Pakistan | Sindh | 592654 | 8217 | 0 | 26.009446 | 68.776807 | 2022-08-18 04:21:11 | Sindh, Pakistan | |||
3950642 | 3950642 | 2022-08-17 | Pakistan | Punjab | 518993 | 13595 | 0 | 30.811346 | 72.139132 | 2022-08-18 04:21:11 | Punjab, Pakistan | |||
3950641 | 3950641 | 2022-08-17 | Pakistan | Khyber Pakhtunkhwa | 222650 | 6340 | 0 | 34.485332 | 72.09169 | 2022-08-18 04:21:11 | Khyber Pakhtunkhwa, Pakistan | |||
3950640 | 3950640 | 2022-08-17 | Pakistan | Islamabad | 138560 | 1030 | 0 | 33.665087 | 73.121219 | 2022-08-18 04:21:11 | Islamabad, Pakistan | |||
3950639 | 3950639 | 2022-08-17 | Pakistan | Gilgit-Baltistan | 11976 | 191 | 0 | 35.792146 | 74.982138 | 2022-08-18 04:21:11 | Gilgit-Baltistan, Pakistan | |||
3950638 | 3950638 | 2022-08-17 | Pakistan | Balochistan | 35905 | 378 | 0 | 28.328492 | 65.898403 | 2022-08-18 04:21:11 | Balochistan, Pakistan | |||
3950637 | 3950637 | 2022-08-17 | Pakistan | Azad Jammu and Kashmir | 44071 | 793 | 0 | 34.027401 | 73.947253 | 2022-08-18 04:21:11 | Azad Jammu and Kashmir, Pakistan | |||
3950071 | 3950071 | 2020-04-09 | Pakistan | 4489 | 65 | 572 | 3852 | 30.3753 | 69.3451 | 2020-04-09 23:02:19 | Pakistan | |||
3947126 | 3947126 | 2020-03-28 | Pakistan | 1495 | 12 | 29 | 1454 | 30.3753 | 69.3451 | 3/28/20 23:05 | 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]);