⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,974 rows where country_or_region = "Pakistan" sorted by day descending

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Pakistan · 1,974
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
904567 2021-03-03 Pakistan Azad Jammu and Kashmir     10371 307 9347 717 34.027401 73.947253 2021-03-04 05:24:24 Azad Jammu and Kashmir, Pakistan
904568 2021-03-03 Pakistan Balochistan     19084 200 18773 111 28.328492 65.898403 2021-03-04 05:24:24 Balochistan, Pakistan
904569 2021-03-03 Pakistan Gilgit-Baltistan     4957 102 4850 5 35.792146 74.982138 2021-03-04 05:24:24 Gilgit-Baltistan, Pakistan
904570 2021-03-03 Pakistan Islamabad     44921 503 42419 1999 33.665087 73.121219 2021-03-04 05:24:24 Islamabad, Pakistan
904571 2021-03-03 Pakistan Khyber Pakhtunkhwa     73007 2096 68676 2235 34.485332 72.09169 2021-03-04 05:24:24 Khyber Pakhtunkhwa, Pakistan
904572 2021-03-03 Pakistan Punjab     174191 5480 162993 5718 30.811346 72.13913199999998 2021-03-04 05:24:24 Punjab, Pakistan
904573 2021-03-03 Pakistan Sindh     258904 4388 248184 6332 26.009446 68.77680699999999 2021-03-04 05:24:24 Sindh, Pakistan
66948 2021-03-02 Pakistan Azad Jammu and Kashmir     10319 306 9302 711 34.027401 73.947253 2021-03-03 05:23:28 Azad Jammu and Kashmir, Pakistan
66949 2021-03-02 Pakistan Balochistan     19076 200 18768 108 28.328492 65.898403 2021-03-03 05:23:28 Balochistan, Pakistan
66950 2021-03-02 Pakistan Gilgit-Baltistan     4956 102 4845 9 35.792146 74.982138 2021-03-03 05:23:28 Gilgit-Baltistan, Pakistan
66951 2021-03-02 Pakistan Islamabad     44690 501 42317 1872 33.665087 73.121219 2021-03-03 05:23:28 Islamabad, Pakistan
66952 2021-03-02 Pakistan Khyber Pakhtunkhwa     72801 2091 68507 2203 34.485332 72.09169 2021-03-03 05:23:28 Khyber Pakhtunkhwa, Pakistan
66953 2021-03-02 Pakistan Punjab     173395 5441 162658 5296 30.811346 72.13913199999998 2021-03-03 05:23:28 Punjab, Pakistan
66954 2021-03-02 Pakistan Sindh     258679 4372 247858 6449 26.009446 68.77680699999999 2021-03-03 05:23:28 Sindh, Pakistan
1291526 2021-03-01 Pakistan Azad Jammu and Kashmir     10280 306 9262 712 34.027401 73.947253 2021-03-02 05:23:30 Azad Jammu and Kashmir, Pakistan
1291527 2021-03-01 Pakistan Balochistan     19066 200 18762 104 28.328492 65.898403 2021-03-02 05:23:30 Balochistan, Pakistan
1291528 2021-03-01 Pakistan Gilgit-Baltistan     4956 102 4845 9 35.792146 74.982138 2021-03-02 05:23:30 Gilgit-Baltistan, Pakistan
1291529 2021-03-01 Pakistan Islamabad     44516 501 42203 1812 33.665087 73.121219 2021-03-02 05:23:30 Islamabad, Pakistan
1291530 2021-03-01 Pakistan Khyber Pakhtunkhwa     72615 2085 68225 2305 34.485332 72.09169 2021-03-02 05:23:30 Khyber Pakhtunkhwa, Pakistan
1291531 2021-03-01 Pakistan Punjab     172683 5391 161895 5397 30.811346 72.13913199999998 2021-03-02 05:23:30 Punjab, Pakistan
1291532 2021-03-01 Pakistan Sindh     258412 4353 242214 11845 26.009446 68.77680699999999 2021-03-02 05:23:30 Sindh, Pakistan
579941 2021-02-28 Pakistan Azad Jammu and Kashmir     10243 301 9228 714 34.027401 73.947253 2021-03-01 05:23:01 Azad Jammu and Kashmir, Pakistan
579942 2021-02-28 Pakistan Balochistan     19049 200 18754 95 28.328492 65.898403 2021-03-01 05:23:01 Balochistan, Pakistan
579943 2021-02-28 Pakistan Gilgit-Baltistan     4956 102 4843 11 35.792146 74.982138 2021-03-01 05:23:01 Gilgit-Baltistan, Pakistan
579944 2021-02-28 Pakistan Islamabad     44373 501 42085 1787 33.665087 73.121219 2021-03-01 05:23:01 Islamabad, Pakistan
579945 2021-02-28 Pakistan Khyber Pakhtunkhwa     72424 2079 68128 2217 34.485332 72.09169 2021-03-01 05:23:01 Khyber Pakhtunkhwa, Pakistan
579946 2021-02-28 Pakistan Punjab     172054 5363 161469 5222 30.811346 72.13913199999998 2021-03-01 05:23:01 Punjab, Pakistan
579947 2021-02-28 Pakistan Sindh     258266 4350 241864 12052 26.009446 68.77680699999999 2021-03-01 05:23:01 Sindh, Pakistan
680667 2021-02-27 Pakistan Azad Jammu and Kashmir     10198 297 9195 706 34.027401 73.947253 2021-02-28 05:22:20 Azad Jammu and Kashmir, Pakistan
680668 2021-02-27 Pakistan Balochistan     19045 200 18745 100 28.328492 65.898403 2021-02-28 05:22:20 Balochistan, Pakistan
680669 2021-02-27 Pakistan Gilgit-Baltistan     4956 102 4841 13 35.792146 74.982138 2021-02-28 05:22:20 Gilgit-Baltistan, Pakistan
680670 2021-02-27 Pakistan Islamabad     44259 496 41995 1768 33.665087 73.121219 2021-02-28 05:22:20 Islamabad, Pakistan
680671 2021-02-27 Pakistan Khyber Pakhtunkhwa     72162 2072 68024 2066 34.485332 72.09169 2021-02-28 05:22:20 Khyber Pakhtunkhwa, Pakistan
680672 2021-02-27 Pakistan Punjab     171349 5350 160997 5002 30.811346 72.13913199999998 2021-02-28 05:22:20 Punjab, Pakistan
680673 2021-02-27 Pakistan Sindh     258004 4343 241480 12181 26.009446 68.77680699999999 2021-02-28 05:22:20 Sindh, Pakistan
873695 2021-02-26 Pakistan Azad Jammu and Kashmir     10147 297 9185 665 34.027401 73.947253 2021-02-27 05:22:28 Azad Jammu and Kashmir, Pakistan
873696 2021-02-26 Pakistan Balochistan     19038 200 18743 95 28.328492 65.898403 2021-02-27 05:22:28 Balochistan, Pakistan
873697 2021-02-26 Pakistan Gilgit-Baltistan     4956 102 4840 14 35.792146 74.982138 2021-02-27 05:22:28 Gilgit-Baltistan, Pakistan
873698 2021-02-26 Pakistan Islamabad     44106 496 41894 1716 33.665087 73.121219 2021-02-27 05:22:28 Islamabad, Pakistan
873699 2021-02-26 Pakistan Khyber Pakhtunkhwa     72003 2070 67803 2130 34.485332 72.09169 2021-02-27 05:22:28 Khyber Pakhtunkhwa, Pakistan
873700 2021-02-26 Pakistan Punjab     170817 5337 160685 4795 30.811346 72.13913199999998 2021-02-27 05:22:28 Punjab, Pakistan
873701 2021-02-26 Pakistan Sindh     257730 4335 241256 12139 26.009446 68.77680699999999 2021-02-27 05:22:28 Sindh, Pakistan
388350 2021-02-25 Pakistan Azad Jammu and Kashmir     10101 296 9144 661 34.027401 73.947253 2021-02-26 05:22:40 Azad Jammu and Kashmir, Pakistan
388351 2021-02-25 Pakistan Balochistan     19035 200 18734 101 28.328492 65.898403 2021-02-26 05:22:40 Balochistan, Pakistan
388352 2021-02-25 Pakistan Gilgit-Baltistan     4956 102 4840 14 35.792146 74.982138 2021-02-26 05:22:40 Gilgit-Baltistan, Pakistan
388353 2021-02-25 Pakistan Islamabad     44032 496 41765 1771 33.665087 73.121219 2021-02-26 05:22:40 Islamabad, Pakistan
388354 2021-02-25 Pakistan Khyber Pakhtunkhwa     71728 2065 67632 2031 34.485332 72.09169 2021-02-26 05:22:40 Khyber Pakhtunkhwa, Pakistan
388355 2021-02-25 Pakistan Punjab     170222 5323 159295 5604 30.811346 72.13913199999998 2021-02-26 05:22:40 Punjab, Pakistan
388356 2021-02-25 Pakistan Sindh     257408 4322 240983 12103 26.009446 68.77680699999999 2021-02-26 05:22:40 Sindh, Pakistan
454781 2021-02-24 Pakistan Azad Jammu and Kashmir     10022 296 9097 629 34.027401 73.947253 2021-02-25 05:24:57 Azad Jammu and Kashmir, Pakistan
454782 2021-02-24 Pakistan Balochistan     19010 199 18732 79 28.328492 65.898403 2021-02-25 05:24:57 Balochistan, Pakistan
454783 2021-02-24 Pakistan Gilgit-Baltistan     4955 102 4836 17 35.792146 74.982138 2021-02-25 05:24:57 Gilgit-Baltistan, Pakistan
454784 2021-02-24 Pakistan Islamabad     43901 494 41640 1767 33.665087 73.121219 2021-02-25 05:24:57 Islamabad, Pakistan
454785 2021-02-24 Pakistan Khyber Pakhtunkhwa     71490 2058 67448 1984 34.485332 72.09169 2021-02-25 05:24:57 Khyber Pakhtunkhwa, Pakistan
454786 2021-02-24 Pakistan Punjab     169474 5308 157459 6707 30.811346 72.13913199999998 2021-02-25 05:24:57 Punjab, Pakistan
454787 2021-02-24 Pakistan Sindh     257089 4315 240676 12098 26.009446 68.77680699999999 2021-02-25 05:24:57 Sindh, Pakistan
1055963 2021-02-23 Pakistan Azad Jammu and Kashmir     9955 293 9055 607 34.027401 73.947253 2021-02-24 05:29:16 Azad Jammu and Kashmir, Pakistan
1055964 2021-02-23 Pakistan Balochistan     19004 199 18716 89 28.328492 65.898403 2021-02-24 05:29:16 Balochistan, Pakistan
1055965 2021-02-23 Pakistan Gilgit-Baltistan     4954 102 4832 20 35.792146 74.982138 2021-02-24 05:29:16 Gilgit-Baltistan, Pakistan
1055966 2021-02-23 Pakistan Islamabad     43753 494 41539 1720 33.665087 73.121219 2021-02-24 05:29:16 Islamabad, Pakistan
1055967 2021-02-23 Pakistan Khyber Pakhtunkhwa     71282 2050 67187 2045 34.485332 72.09169 2021-02-24 05:29:16 Khyber Pakhtunkhwa, Pakistan
1055968 2021-02-23 Pakistan Punjab     168891 5269 156821 6801 30.811346 72.13913199999998 2021-02-24 05:29:16 Punjab, Pakistan
1055969 2021-02-23 Pakistan Sindh     256741 4301 240057 12383 26.009446 68.77680699999999 2021-02-24 05:29:16 Sindh, Pakistan
1232970 2021-02-22 Pakistan Azad Jammu and Kashmir     9878 291 9012 575 34.027401 73.947253 2021-02-23 05:23:41 Azad Jammu and Kashmir, Pakistan
1232971 2021-02-22 Pakistan Balochistan     18993 199 18713 81 28.328492 65.898403 2021-02-23 05:23:41 Balochistan, Pakistan
1232972 2021-02-22 Pakistan Gilgit-Baltistan     4951 102 4826 23 35.792146 74.982138 2021-02-23 05:23:41 Gilgit-Baltistan, Pakistan
1232973 2021-02-22 Pakistan Islamabad     43623 493 41451 1679 33.665087 73.121219 2021-02-23 05:23:41 Islamabad, Pakistan
1232974 2021-02-22 Pakistan Khyber Pakhtunkhwa     71146 2043 67007 2096 34.485332 72.09169 2021-02-23 05:23:41 Khyber Pakhtunkhwa, Pakistan
1232975 2021-02-22 Pakistan Punjab     168348 5237 155948 7163 30.811346 72.13913199999998 2021-02-23 05:23:41 Punjab, Pakistan
1232976 2021-02-22 Pakistan Sindh     256445 4293 239286 12866 26.009446 68.77680699999999 2021-02-23 05:23:41 Sindh, Pakistan
1244908 2021-02-21 Pakistan Azad Jammu and Kashmir     9828 288 8971 569 34.027401 73.947253 2021-02-22 05:24:21 Azad Jammu and Kashmir, Pakistan
1244909 2021-02-21 Pakistan Balochistan     18988 199 18708 81 28.328492 65.898403 2021-02-22 05:24:21 Balochistan, Pakistan
1244910 2021-02-21 Pakistan Gilgit-Baltistan     4951 102 4821 28 35.792146 74.982138 2021-02-22 05:24:21 Gilgit-Baltistan, Pakistan
1244911 2021-02-21 Pakistan Islamabad     43485 492 41363 1630 33.665087 73.121219 2021-02-22 05:24:21 Islamabad, Pakistan
1244912 2021-02-21 Pakistan Khyber Pakhtunkhwa     71043 2036 66885 2122 34.485332 72.09169 2021-02-22 05:24:21 Khyber Pakhtunkhwa, Pakistan
1244913 2021-02-21 Pakistan Punjab     167819 5208 155632 6979 30.811346 72.13913199999998 2021-02-22 05:24:21 Punjab, Pakistan
1244914 2021-02-21 Pakistan Sindh     256220 4292 239111 12817 26.009446 68.77680699999999 2021-02-22 05:24:21 Sindh, Pakistan
599863 2021-02-20 Pakistan Azad Jammu and Kashmir     9777 288 8938 551 34.027401 73.947253 2021-02-21 05:24:33 Azad Jammu and Kashmir, Pakistan
599864 2021-02-20 Pakistan Balochistan     18979 199 18697 83 28.328492 65.898403 2021-02-21 05:24:33 Balochistan, Pakistan
599865 2021-02-20 Pakistan Gilgit-Baltistan     4951 102 4821 28 35.792146 74.982138 2021-02-21 05:24:33 Gilgit-Baltistan, Pakistan
599866 2021-02-20 Pakistan Islamabad     43402 488 41279 1635 33.665087 73.121219 2021-02-21 05:24:33 Islamabad, Pakistan
599867 2021-02-20 Pakistan Khyber Pakhtunkhwa     70886 2032 66685 2169 34.485332 72.09169 2021-02-21 05:24:33 Khyber Pakhtunkhwa, Pakistan
599868 2021-02-20 Pakistan Punjab     167345 5204 154895 7246 30.811346 72.13913199999998 2021-02-21 05:24:33 Punjab, Pakistan
599869 2021-02-20 Pakistan Sindh     255834 4288 238792 12754 26.009446 68.77680699999999 2021-02-21 05:24:33 Sindh, Pakistan
442843 2021-02-19 Pakistan Azad Jammu and Kashmir     9718 286 8899 533 34.027401 73.947253 2021-02-20 05:22:51 Azad Jammu and Kashmir, Pakistan
442844 2021-02-19 Pakistan Balochistan     18972 199 18689 84 28.328492 65.898403 2021-02-20 05:22:51 Balochistan, Pakistan
442845 2021-02-19 Pakistan Gilgit-Baltistan     4951 102 4821 28 35.792146 74.982138 2021-02-20 05:22:51 Gilgit-Baltistan, Pakistan
442846 2021-02-19 Pakistan Islamabad     43282 488 41203 1591 33.665087 73.121219 2021-02-20 05:22:51 Islamabad, Pakistan
442847 2021-02-19 Pakistan Khyber Pakhtunkhwa     70716 2027 66524 2165 34.485332 72.09169 2021-02-20 05:22:51 Khyber Pakhtunkhwa, Pakistan
442848 2021-02-19 Pakistan Punjab     166777 5185 154568 7024 30.811346 72.13913199999998 2021-02-20 05:22:51 Punjab, Pakistan
442849 2021-02-19 Pakistan Sindh     255430 4276 238498 12656 26.009446 68.77680699999999 2021-02-20 05:22:51 Sindh, Pakistan
1268724 2021-02-18 Pakistan Azad Jammu and Kashmir     9673 285 8865 523 34.027401 73.947253 2021-02-19 05:24:16 Azad Jammu and Kashmir, Pakistan
1268725 2021-02-18 Pakistan Balochistan     18967 199 18675 93 28.328492 65.898403 2021-02-19 05:24:16 Balochistan, Pakistan
1268726 2021-02-18 Pakistan Gilgit-Baltistan     4947 102 4816 29 35.792146 74.982138 2021-02-19 05:24:16 Gilgit-Baltistan, Pakistan
1268727 2021-02-18 Pakistan Islamabad     43145 488 41139 1518 33.665087 73.121219 2021-02-19 05:24:16 Islamabad, Pakistan
1268728 2021-02-18 Pakistan Khyber Pakhtunkhwa     70493 2020 66391 2082 34.485332 72.09169 2021-02-19 05:24:16 Khyber Pakhtunkhwa, Pakistan
1268729 2021-02-18 Pakistan Punjab     166242 5166 153924 7152 30.811346 72.13913199999998 2021-02-19 05:24:16 Punjab, Pakistan
1268730 2021-02-18 Pakistan Sindh     255039 4267 238030 12742 26.009446 68.77680699999999 2021-02-19 05:24:16 Sindh, Pakistan
322366 2021-02-17 Pakistan Azad Jammu and Kashmir     9629 284 8831 514 34.027401 73.947253 2021-02-18 05:22:58 Azad Jammu and Kashmir, Pakistan
322367 2021-02-17 Pakistan Balochistan     18958 199 18668 91 28.328492 65.898403 2021-02-18 05:22:58 Balochistan, Pakistan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);