⚠️ 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,687 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,687
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
298748 2021-01-21 Pakistan Azad Jammu and Kashmir     8753 248 8209 296 34.027401 73.947253 2021-01-22 05:22:10 Azad Jammu and Kashmir, Pakistan
298749 2021-01-21 Pakistan Balochistan     18696 192 18205 299 28.328492 65.898403 2021-01-22 05:22:10 Balochistan, Pakistan
298750 2021-01-21 Pakistan Gilgit-Baltistan     4899 102 4765 32 35.792146 74.982138 2021-01-22 05:22:10 Gilgit-Baltistan, Pakistan
298751 2021-01-21 Pakistan Islamabad     40548 461 38414 1673 33.665087 73.121219 2021-01-22 05:22:10 Islamabad, Pakistan
298752 2021-01-21 Pakistan Khyber Pakhtunkhwa     64651 1823 59613 3215 34.485332 72.09169 2021-01-22 05:22:10 Khyber Pakhtunkhwa, Pakistan
298753 2021-01-21 Pakistan Punjab     152158 4523 136645 10990 30.811346 72.13913199999998 2021-01-22 05:22:10 Punjab, Pakistan
298754 2021-01-21 Pakistan Sindh     239186 3855 216920 18411 26.009446 68.77680699999999 2021-01-22 05:22:10 Sindh, Pakistan
889799 2021-01-20 Pakistan Azad Jammu and Kashmir     8706 248 8177 281 34.027401 73.947253 2021-01-21 05:22:01 Azad Jammu and Kashmir, Pakistan
889800 2021-01-20 Pakistan Balochistan     18670 192 18161 317 28.328492 65.898403 2021-01-21 05:22:01 Balochistan, Pakistan
889801 2021-01-20 Pakistan Gilgit-Baltistan     4894 102 4765 27 35.792146 74.982138 2021-01-21 05:22:01 Gilgit-Baltistan, Pakistan
889802 2021-01-20 Pakistan Islamabad     40430 460 38278 1692 33.665087 73.121219 2021-01-21 05:22:01 Islamabad, Pakistan
889803 2021-01-20 Pakistan Khyber Pakhtunkhwa     64373 1811 59278 3284 34.485332 72.09169 2021-01-21 05:22:01 Khyber Pakhtunkhwa, Pakistan
889804 2021-01-20 Pakistan Punjab     151603 4501 135892 11210 30.811346 72.13913199999998 2021-01-21 05:22:01 Punjab, Pakistan
889805 2021-01-20 Pakistan Sindh     238470 3843 216145 18482 26.009446 68.77680699999999 2021-01-21 05:22:01 Sindh, Pakistan
318366 2021-01-19 Pakistan Azad Jammu and Kashmir     8672 245 8158 269 34.027401 73.947253 2021-01-20 05:21:54 Azad Jammu and Kashmir, Pakistan
318367 2021-01-19 Pakistan Balochistan     18640 191 18119 330 28.328492 65.898403 2021-01-20 05:21:54 Balochistan, Pakistan
318368 2021-01-19 Pakistan Gilgit-Baltistan     4892 102 4763 27 35.792146 74.982138 2021-01-20 05:21:54 Gilgit-Baltistan, Pakistan
318369 2021-01-19 Pakistan Islamabad     40304 460 38148 1696 33.665087 73.121219 2021-01-20 05:21:54 Islamabad, Pakistan
318370 2021-01-19 Pakistan Khyber Pakhtunkhwa     64078 1799 58803 3476 34.485332 72.09169 2021-01-20 05:21:54 Khyber Pakhtunkhwa, Pakistan
318371 2021-01-19 Pakistan Punjab     150889 4476 135425 10988 30.811346 72.13913199999998 2021-01-20 05:21:54 Punjab, Pakistan
318372 2021-01-19 Pakistan Sindh     237308 3830 215101 18377 26.009446 68.77680699999999 2021-01-20 05:21:54 Sindh, Pakistan
570352 2021-01-18 Pakistan Azad Jammu and Kashmir     8654 243 8138 273 34.027401 73.947253 2021-01-19 05:22:15 Azad Jammu and Kashmir, Pakistan
570353 2021-01-18 Pakistan Balochistan     18622 190 18110 322 28.328492 65.898403 2021-01-19 05:22:15 Balochistan, Pakistan
570354 2021-01-18 Pakistan Gilgit-Baltistan     4887 101 4756 30 35.792146 74.982138 2021-01-19 05:22:15 Gilgit-Baltistan, Pakistan
570355 2021-01-18 Pakistan Islamabad     40177 457 38046 1674 33.665087 73.121219 2021-01-19 05:22:15 Islamabad, Pakistan
570356 2021-01-18 Pakistan Khyber Pakhtunkhwa     63825 1791 58348 3686 34.485332 72.09169 2021-01-19 05:22:15 Khyber Pakhtunkhwa, Pakistan
570357 2021-01-18 Pakistan Punjab     150316 4460 134842 11014 30.811346 72.13913199999998 2021-01-19 05:22:15 Punjab, Pakistan
570358 2021-01-18 Pakistan Sindh     236530 3813 214231 18486 26.009446 68.77680699999999 2021-01-19 05:22:15 Sindh, Pakistan
534915 2021-01-17 Pakistan Azad Jammu and Kashmir     8631 241 8105 285 34.027401 73.947253 2021-01-18 05:22:34 Azad Jammu and Kashmir, Pakistan
534916 2021-01-17 Pakistan Balochistan     18612 190 18100 322 28.328492 65.898403 2021-01-18 05:22:34 Balochistan, Pakistan
534917 2021-01-17 Pakistan Gilgit-Baltistan     4884 101 4756 27 35.792146 74.982138 2021-01-18 05:22:34 Gilgit-Baltistan, Pakistan
534918 2021-01-17 Pakistan Islamabad     40111 457 37914 1740 33.665087 73.121219 2021-01-18 05:22:34 Islamabad, Pakistan
534919 2021-01-17 Pakistan Khyber Pakhtunkhwa     63615 1783 58240 3592 34.485332 72.09169 2021-01-18 05:22:34 Khyber Pakhtunkhwa, Pakistan
534920 2021-01-17 Pakistan Punjab     149782 4432 134489 10861 30.811346 72.13913199999998 2021-01-18 05:22:34 Punjab, Pakistan
534921 2021-01-17 Pakistan Sindh     235576 3793 213624 18159 26.009446 68.77680699999999 2021-01-18 05:22:34 Sindh, Pakistan
615703 2021-01-16 Pakistan Azad Jammu and Kashmir     8606 241 8082 283 34.027401 73.947253 2021-01-17 05:22:17 Azad Jammu and Kashmir, Pakistan
615704 2021-01-16 Pakistan Balochistan     18569 190 18071 308 28.328492 65.898403 2021-01-17 05:22:17 Balochistan, Pakistan
615705 2021-01-16 Pakistan Gilgit-Baltistan     4882 101 4750 31 35.792146 74.982138 2021-01-17 05:22:17 Gilgit-Baltistan, Pakistan
615706 2021-01-16 Pakistan Islamabad     40019 456 37769 1794 33.665087 73.121219 2021-01-17 05:22:17 Islamabad, Pakistan
615707 2021-01-16 Pakistan Khyber Pakhtunkhwa     63339 1779 58082 3478 34.485332 72.09169 2021-01-17 05:22:17 Khyber Pakhtunkhwa, Pakistan
615708 2021-01-16 Pakistan Punjab     149222 4409 133952 10861 30.811346 72.13913199999998 2021-01-17 05:22:17 Punjab, Pakistan
615709 2021-01-16 Pakistan Sindh     234654 3775 212933 17946 26.009446 68.77680699999999 2021-01-17 05:22:17 Sindh, Pakistan
180844 2021-01-15 Pakistan Azad Jammu and Kashmir     8583 238 8063 282 34.027401 73.947253 2021-01-16 05:22:40 Azad Jammu and Kashmir, Pakistan
180845 2021-01-15 Pakistan Balochistan     18537 190 18060 287 28.328492 65.898403 2021-01-16 05:22:40 Balochistan, Pakistan
180846 2021-01-15 Pakistan Gilgit-Baltistan     4882 101 4748 33 35.792146 74.982138 2021-01-16 05:22:40 Gilgit-Baltistan, Pakistan
180847 2021-01-15 Pakistan Islamabad     39888 450 37621 1817 33.665087 73.121219 2021-01-16 05:22:40 Islamabad, Pakistan
180848 2021-01-15 Pakistan Khyber Pakhtunkhwa     62996 1773 57755 3468 34.485332 72.09169 2021-01-16 05:22:40 Khyber Pakhtunkhwa, Pakistan
180849 2021-01-15 Pakistan Punjab     148488 4387 133586 10515 30.811346 72.13913199999998 2021-01-16 05:22:40 Punjab, Pakistan
180850 2021-01-15 Pakistan Sindh     233396 3769 212266 17361 26.009446 68.77680699999999 2021-01-16 05:22:40 Sindh, Pakistan
593536 2021-01-14 Pakistan Azad Jammu and Kashmir     8567 237 8044 286 34.027401 73.947253 2021-01-15 05:22:24 Azad Jammu and Kashmir, Pakistan
593537 2021-01-14 Pakistan Balochistan     18515 189 18021 305 28.328492 65.898403 2021-01-15 05:22:24 Balochistan, Pakistan
593538 2021-01-14 Pakistan Gilgit-Baltistan     4882 101 4748 33 35.792146 74.982138 2021-01-15 05:22:24 Gilgit-Baltistan, Pakistan
593539 2021-01-14 Pakistan Islamabad     39749 449 37413 1887 33.665087 73.121219 2021-01-15 05:22:24 Islamabad, Pakistan
593540 2021-01-14 Pakistan Khyber Pakhtunkhwa     62719 1762 57537 3420 34.485332 72.09169 2021-01-15 05:22:24 Khyber Pakhtunkhwa, Pakistan
593541 2021-01-14 Pakistan Punjab     147953 4370 132769 10814 30.811346 72.13913199999998 2021-01-15 05:22:24 Punjab, Pakistan
593542 2021-01-14 Pakistan Sindh     231953 3755 210774 17424 26.009446 68.77680699999999 2021-01-15 05:22:24 Sindh, Pakistan
724907 2021-01-13 Pakistan Azad Jammu and Kashmir     8540 236 8021 283 34.027401 73.947253 2021-01-14 05:22:32 Azad Jammu and Kashmir, Pakistan
724908 2021-01-13 Pakistan Balochistan     18488 188 18002 298 28.328492 65.898403 2021-01-14 05:22:32 Balochistan, Pakistan
724909 2021-01-13 Pakistan Gilgit-Baltistan     4882 101 4746 35 35.792146 74.982138 2021-01-14 05:22:32 Gilgit-Baltistan, Pakistan
724910 2021-01-13 Pakistan Islamabad     39624 449 37200 1975 33.665087 73.121219 2021-01-14 05:22:32 Islamabad, Pakistan
724911 2021-01-13 Pakistan Khyber Pakhtunkhwa     62377 1752 57313 3312 34.485332 72.09169 2021-01-14 05:22:32 Khyber Pakhtunkhwa, Pakistan
724912 2021-01-13 Pakistan Punjab     147292 4348 131825 11119 30.811346 72.13913199999998 2021-01-14 05:22:32 Punjab, Pakistan
724913 2021-01-13 Pakistan Sindh     230718 3744 210127 16847 26.009446 68.77680699999999 2021-01-14 05:22:32 Sindh, Pakistan
57242 2021-01-12 Pakistan Azad Jammu and Kashmir     8521 235 8001 285 34.027401 73.947253 2021-01-13 05:22:15 Azad Jammu and Kashmir, Pakistan
57243 2021-01-12 Pakistan Balochistan     18467 188 17978 301 28.328492 65.898403 2021-01-13 05:22:15 Balochistan, Pakistan
57244 2021-01-12 Pakistan Gilgit-Baltistan     4882 101 4744 37 35.792146 74.982138 2021-01-13 05:22:15 Gilgit-Baltistan, Pakistan
57245 2021-01-12 Pakistan Islamabad     39462 447 37049 1966 33.665087 73.121219 2021-01-13 05:22:15 Islamabad, Pakistan
57246 2021-01-12 Pakistan Khyber Pakhtunkhwa     62018 1748 57027 3243 34.485332 72.09169 2021-01-13 05:22:15 Khyber Pakhtunkhwa, Pakistan
57247 2021-01-12 Pakistan Punjab     146525 4323 130912 11290 30.811346 72.13913199999998 2021-01-13 05:22:15 Punjab, Pakistan
57248 2021-01-12 Pakistan Sindh     228949 3730 209239 15980 26.009446 68.77680699999999 2021-01-13 05:22:15 Sindh, Pakistan
265443 2021-01-11 Pakistan Azad Jammu and Kashmir     8501 235 7982 284 34.027401 73.947253 2021-01-12 05:22:15 Azad Jammu and Kashmir, Pakistan
265444 2021-01-11 Pakistan Balochistan     18429 188 17955 286 28.328492 65.898403 2021-01-12 05:22:15 Balochistan, Pakistan
265445 2021-01-11 Pakistan Gilgit-Baltistan     4882 101 4739 42 35.792146 74.982138 2021-01-12 05:22:15 Gilgit-Baltistan, Pakistan
265446 2021-01-11 Pakistan Islamabad     39340 443 36895 2002 33.665087 73.121219 2021-01-12 05:22:15 Islamabad, Pakistan
265447 2021-01-11 Pakistan Khyber Pakhtunkhwa     61648 1743 56714 3191 34.485332 72.09169 2021-01-12 05:22:15 Khyber Pakhtunkhwa, Pakistan
265448 2021-01-11 Pakistan Punjab     146016 4299 130765 10952 30.811346 72.13913199999998 2021-01-12 05:22:15 Punjab, Pakistan
265449 2021-01-11 Pakistan Sindh     227885 3708 206927 17250 26.009446 68.77680699999999 2021-01-12 05:22:15 Sindh, Pakistan
781414 2021-01-10 Pakistan Azad Jammu and Kashmir     8489 235 7966 288 34.027401 73.947253 2021-01-11 05:21:50 Azad Jammu and Kashmir, Pakistan
781415 2021-01-10 Pakistan Balochistan     18412 188 17938 286 28.328492 65.898403 2021-01-11 05:21:50 Balochistan, Pakistan
781416 2021-01-10 Pakistan Gilgit-Baltistan     4880 101 4734 45 35.792146 74.982138 2021-01-11 05:21:50 Gilgit-Baltistan, Pakistan
781417 2021-01-10 Pakistan Islamabad     39242 441 36765 2036 33.665087 73.121219 2021-01-11 05:21:50 Islamabad, Pakistan
781418 2021-01-10 Pakistan Khyber Pakhtunkhwa     61424 1740 56535 3149 34.485332 72.09169 2021-01-11 05:21:50 Khyber Pakhtunkhwa, Pakistan
781419 2021-01-10 Pakistan Punjab     145508 4272 130358 10878 30.811346 72.13913199999998 2021-01-11 05:21:50 Punjab, Pakistan
781420 2021-01-10 Pakistan Sindh     226338 3699 204075 18564 26.009446 68.77680699999999 2021-01-11 05:21:50 Sindh, Pakistan
134858 2021-01-09 Pakistan Azad Jammu and Kashmir     8478 235 7949 294 34.027401 73.947253 2021-01-10 05:22:12 Azad Jammu and Kashmir, Pakistan
134859 2021-01-09 Pakistan Balochistan     18373 188 17899 286 28.328492 65.898403 2021-01-10 05:22:12 Balochistan, Pakistan
134860 2021-01-09 Pakistan Gilgit-Baltistan     4879 101 4729 49 35.792146 74.982138 2021-01-10 05:22:12 Gilgit-Baltistan, Pakistan
134861 2021-01-09 Pakistan Islamabad     39120 439 36705 1976 33.665087 73.121219 2021-01-10 05:22:12 Islamabad, Pakistan
134862 2021-01-09 Pakistan Khyber Pakhtunkhwa     61148 1728 56239 3181 34.485332 72.09169 2021-01-10 05:22:12 Khyber Pakhtunkhwa, Pakistan
134863 2021-01-09 Pakistan Punjab     144909 4260 130120 10529 30.811346 72.13913199999998 2021-01-10 05:22:12 Punjab, Pakistan
134864 2021-01-09 Pakistan Sindh     225509 3693 203328 18488 26.009446 68.77680699999999 2021-01-10 05:22:12 Sindh, Pakistan
462674 2021-01-08 Pakistan Azad Jammu and Kashmir     8451 235 7923 293 34.027401 73.947253 2021-01-09 05:22:18 Azad Jammu and Kashmir, Pakistan
462675 2021-01-08 Pakistan Balochistan     18351 187 17898 266 28.328492 65.898403 2021-01-09 05:22:18 Balochistan, Pakistan
462676 2021-01-08 Pakistan Gilgit-Baltistan     4879 101 4728 50 35.792146 74.982138 2021-01-09 05:22:18 Gilgit-Baltistan, Pakistan
462677 2021-01-08 Pakistan Islamabad     38970 436 36546 1988 33.665087 73.121219 2021-01-09 05:22:18 Islamabad, Pakistan
462678 2021-01-08 Pakistan Khyber Pakhtunkhwa     60751 1718 55928 3105 34.485332 72.09169 2021-01-09 05:22:18 Khyber Pakhtunkhwa, Pakistan
462679 2021-01-08 Pakistan Punjab     144111 4242 129852 10017 30.811346 72.13913199999998 2021-01-09 05:22:18 Punjab, Pakistan
462680 2021-01-08 Pakistan Sindh     224004 3679 202570 17755 26.009446 68.77680699999999 2021-01-09 05:22:18 Sindh, Pakistan
290807 2021-01-07 Pakistan Azad Jammu and Kashmir     8430 234 7894 302 34.027401 73.947253 2021-01-08 05:22:42 Azad Jammu and Kashmir, Pakistan
290808 2021-01-07 Pakistan Balochistan     18314 186 17893 235 28.328492 65.898403 2021-01-08 05:22:42 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]);