johns_hopkins_csse_daily_reports

⚠️ 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

343 rows where country_or_region = "Pakistan" sorted by day descending

View and edit SQL

country_or_region

  • Pakistan · 343
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
180850 2020-07-13 Pakistan Azad Jammu and Kashmir     1655 45 1029 581 34.027401 73.947253 2020-07-14 04:34:46 Azad Jammu and Kashmir, Pakistan
180856 2020-07-13 Pakistan Balochistan     11192 126 7812 3254 28.328492 65.898403 2020-07-14 04:34:46 Balochistan, Pakistan
180949 2020-07-13 Pakistan Gilgit-Baltistan     1694 36 1370 288 35.792146 74.982138 2020-07-14 04:34:46 Gilgit-Baltistan, Pakistan
180991 2020-07-13 Pakistan Islamabad     14202 155 11327 2720 33.665087 73.121219 2020-07-14 04:34:46 Islamabad, Pakistan
181025 2020-07-13 Pakistan Khyber Pakhtunkhwa     30747 1106 21312 8329 34.485332 72.09169 2020-07-14 04:34:46 Khyber Pakhtunkhwa, Pakistan
181163 2020-07-13 Pakistan Punjab     87492 2026 63977 21489 30.811346 72.13913199999998 2020-07-14 04:34:46 Punjab, Pakistan
181220 2020-07-13 Pakistan Sindh     106622 1826 63829 40967 26.009446 68.77680699999999 2020-07-14 04:34:46 Sindh, Pakistan
321555 2020-07-12 Pakistan Azad Jammu and Kashmir     1599 44 978 577 34.027401 73.947253 2020-07-13 04:43:04 Azad Jammu and Kashmir, Pakistan
321561 2020-07-12 Pakistan Balochistan     11185 126 7598 3461 28.328492 65.898403 2020-07-13 04:43:04 Balochistan, Pakistan
321654 2020-07-12 Pakistan Gilgit-Baltistan     1671 36 1319 316 35.792146 74.982138 2020-07-13 04:43:04 Gilgit-Baltistan, Pakistan
321697 2020-07-12 Pakistan Islamabad     14108 153 10883 3072 33.665087 73.121219 2020-07-13 04:43:04 Islamabad, Pakistan
321731 2020-07-12 Pakistan Khyber Pakhtunkhwa     30486 1099 21158 8229 34.485332 72.09169 2020-07-13 04:43:04 Khyber Pakhtunkhwa, Pakistan
321869 2020-07-12 Pakistan Punjab     87043 2013 58023 27007 30.811346 72.13913199999998 2020-07-13 04:43:04 Punjab, Pakistan
321926 2020-07-12 Pakistan Sindh     105533 1795 61958 41780 26.009446 68.77680699999999 2020-07-13 04:43:04 Sindh, Pakistan
274947 2020-07-11 Pakistan Azad Jammu and Kashmir     1564 43 942 579 34.027401 73.947253 2020-07-12 04:34:30 Azad Jammu and Kashmir, Pakistan
274953 2020-07-11 Pakistan Balochistan     11157 126 7421 3610 28.328492 65.898403 2020-07-12 04:34:30 Balochistan, Pakistan
275046 2020-07-11 Pakistan Gilgit-Baltistan     1658 36 1316 306 35.792146 74.982138 2020-07-12 04:34:30 Gilgit-Baltistan, Pakistan
275089 2020-07-11 Pakistan Islamabad     14023 152 10645 3226 33.665087 73.121219 2020-07-12 04:34:30 Islamabad, Pakistan
275123 2020-07-11 Pakistan Khyber Pakhtunkhwa     30078 1087 20762 8229 34.485332 72.09169 2020-07-12 04:34:30 Khyber Pakhtunkhwa, Pakistan
275261 2020-07-11 Pakistan Punjab     86556 2006 55175 29375 30.811346 72.13913199999998 2020-07-12 04:34:30 Punjab, Pakistan
275318 2020-07-11 Pakistan Sindh     103836 1747 60439 41650 26.009446 68.77680699999999 2020-07-12 04:34:30 Sindh, Pakistan
9919 2020-07-10 Pakistan Azad Jammu and Kashmir     1532 42 894 596 34.027401 73.947253 2020-07-11 04:34:26 Azad Jammu and Kashmir, Pakistan
9925 2020-07-10 Pakistan Balochistan     11128 126 7224 3778 28.328492 65.898403 2020-07-11 04:34:26 Balochistan, Pakistan
10018 2020-07-10 Pakistan Gilgit-Baltistan     1630 36 1303 291 35.792146 74.982138 2020-07-11 04:34:26 Gilgit-Baltistan, Pakistan
10061 2020-07-10 Pakistan Islamabad     13927 147 10441 3339 33.665087 73.121219 2020-07-11 04:34:26 Islamabad, Pakistan
10095 2020-07-10 Pakistan Khyber Pakhtunkhwa     29775 1074 20271 8430 34.485332 72.09169 2020-07-11 04:34:26 Khyber Pakhtunkhwa, Pakistan
10233 2020-07-10 Pakistan Punjab     85991 1985 53836 30170 30.811346 72.13913199999998 2020-07-11 04:34:26 Punjab, Pakistan
10290 2020-07-10 Pakistan Sindh     102368 1713 59165 41490 26.009446 68.77680699999999 2020-07-11 04:34:26 Sindh, Pakistan
342132 2020-07-09 Pakistan Azad Jammu and Kashmir     1485 41 860 584 34.027401 73.947253 2020-07-10 04:34:24 Azad Jammu and Kashmir, Pakistan
342138 2020-07-09 Pakistan Balochistan     11099 125 6931 4043 28.328492 65.898403 2020-07-10 04:34:24 Balochistan, Pakistan
342231 2020-07-09 Pakistan Gilgit-Baltistan     1619 34 1290 295 35.792146 74.982138 2020-07-10 04:34:24 Gilgit-Baltistan, Pakistan
342274 2020-07-09 Pakistan Islamabad     13829 146 10240 3443 33.665087 73.121219 2020-07-10 04:34:24 Islamabad, Pakistan
342308 2020-07-09 Pakistan Khyber Pakhtunkhwa     29406 1063 19503 8840 34.485332 72.09169 2020-07-10 04:34:24 Khyber Pakhtunkhwa, Pakistan
342446 2020-07-09 Pakistan Punjab     85261 1972 52641 30648 30.811346 72.13913199999998 2020-07-10 04:34:24 Punjab, Pakistan
342503 2020-07-09 Pakistan Sindh     100900 1677 57627 41596 26.009446 68.77680699999999 2020-07-10 04:34:24 Sindh, Pakistan
253863 2020-07-08 Pakistan Azad Jammu and Kashmir     1459 40 828 591 34.027401 73.947253 2020-07-09 04:34:23 Azad Jammu and Kashmir, Pakistan
253869 2020-07-08 Pakistan Balochistan     11052 124 6658 4270 28.328492 65.898403 2020-07-09 04:34:23 Balochistan, Pakistan
253962 2020-07-08 Pakistan Gilgit-Baltistan     1605 31 1272 302 35.792146 74.982138 2020-07-09 04:34:23 Gilgit-Baltistan, Pakistan
254005 2020-07-08 Pakistan Islamabad     13731 142 9939 3650 33.665087 73.121219 2020-07-09 04:34:23 Islamabad, Pakistan
254039 2020-07-08 Pakistan Khyber Pakhtunkhwa     29052 1054 18791 9207 34.485332 72.09169 2020-07-09 04:34:23 Khyber Pakhtunkhwa, Pakistan
254177 2020-07-08 Pakistan Punjab     84587 1955 51450 31182 30.811346 72.13913199999998 2020-07-09 04:34:23 Punjab, Pakistan
254234 2020-07-08 Pakistan Sindh     99362 1637 56373 41352 26.009446 68.77680699999999 2020-07-09 04:34:23 Sindh, Pakistan
249982 2020-07-07 Pakistan Azad Jammu and Kashmir     1419 40 788 591 34.027401 73.947253 2020-07-08 05:33:48 Azad Jammu and Kashmir, Pakistan
249988 2020-07-07 Pakistan Balochistan     10919 124 6432 4363 28.328492 65.898403 2020-07-08 05:33:48 Balochistan, Pakistan
250081 2020-07-07 Pakistan Gilgit-Baltistan     1595 30 1232 333 35.792146 74.982138 2020-07-08 05:33:48 Gilgit-Baltistan, Pakistan
250124 2020-07-07 Pakistan Islamabad     13650 140 9655 3855 33.665087 73.121219 2020-07-08 05:33:48 Islamabad, Pakistan
250158 2020-07-07 Pakistan Khyber Pakhtunkhwa     28681 1045 17266 10370 34.485332 72.09169 2020-07-08 05:33:48 Khyber Pakhtunkhwa, Pakistan
250296 2020-07-07 Pakistan Punjab     83599 1929 50916 30754 30.811346 72.13913199999998 2020-07-08 05:33:48 Punjab, Pakistan
250353 2020-07-07 Pakistan Sindh     97626 1614 54676 41336 26.009446 68.77680699999999 2020-07-08 05:33:48 Sindh, Pakistan
59758 2020-07-06 Pakistan Azad Jammu and Kashmir     1383 36 741 606 34.027401 73.947253 2020-07-07 04:34:00 Azad Jammu and Kashmir, Pakistan
59764 2020-07-06 Pakistan Balochistan     10841 124 6131 4586 28.328492 65.898403 2020-07-07 04:34:00 Balochistan, Pakistan
59857 2020-07-06 Pakistan Gilgit-Baltistan     1587 30 1224 333 35.792146 74.982138 2020-07-07 04:34:00 Gilgit-Baltistan, Pakistan
59900 2020-07-06 Pakistan Islamabad     13557 140 9403 4014 33.665087 73.121219 2020-07-07 04:34:00 Islamabad, Pakistan
59934 2020-07-06 Pakistan Khyber Pakhtunkhwa     28236 1038 16549 10649 34.485332 72.09169 2020-07-07 04:34:00 Khyber Pakhtunkhwa, Pakistan
60072 2020-07-06 Pakistan Punjab     82669 1899 47054 33716 30.811346 72.13913199999998 2020-07-07 04:34:00 Punjab, Pakistan
60129 2020-07-06 Pakistan Sindh     96236 1572 53855 40809 26.009446 68.77680699999999 2020-07-07 04:34:00 Sindh, Pakistan
370246 2020-07-05 Pakistan Azad Jammu and Kashmir     1342 36 690 616 34.027401 73.947253 2020-07-06 04:33:57 Azad Jammu and Kashmir, Pakistan
370252 2020-07-05 Pakistan Balochistan     10814 123 5885 4806 28.328492 65.898403 2020-07-06 04:33:57 Balochistan, Pakistan
370345 2020-07-05 Pakistan Gilgit-Baltistan     1561 28 1203 330 35.792146 74.982138 2020-07-06 04:33:57 Gilgit-Baltistan, Pakistan
370388 2020-07-05 Pakistan Islamabad     13494 137 9156 4201 33.665087 73.121219 2020-07-06 04:33:57 Islamabad, Pakistan
370422 2020-07-05 Pakistan Khyber Pakhtunkhwa     28116 1028 16428 10660 34.485332 72.09169 2020-07-06 04:33:57 Khyber Pakhtunkhwa, Pakistan
370560 2020-07-05 Pakistan Punjab     81963 1884 45122 34957 30.811346 72.13913199999998 2020-07-06 04:33:57 Punjab, Pakistan
370617 2020-07-05 Pakistan Sindh     94528 1526 53165 39837 26.009446 68.77680699999999 2020-07-06 04:33:57 Sindh, Pakistan
338328 2020-07-04 Pakistan Azad Jammu and Kashmir     1214 34 686 494 34.027401 73.947253 2020-07-05 04:33:46 Azad Jammu and Kashmir, Pakistan
338334 2020-07-04 Pakistan Balochistan     10717 122 5331 5264 28.328492 65.898403 2020-07-05 04:33:46 Balochistan, Pakistan
338427 2020-07-04 Pakistan Gilgit-Baltistan     1536 28 1185 323 35.792146 74.982138 2020-07-05 04:33:46 Gilgit-Baltistan, Pakistan
338470 2020-07-04 Pakistan Islamabad     13292 130 8610 4552 33.665087 73.121219 2020-07-05 04:33:46 Islamabad, Pakistan
338504 2020-07-04 Pakistan Khyber Pakhtunkhwa     27506 1002 15520 10984 34.485332 72.09169 2020-07-05 04:33:46 Khyber Pakhtunkhwa, Pakistan
338642 2020-07-04 Pakistan Punjab     80297 1844 42854 35599 30.811346 72.13913199999998 2020-07-05 04:33:46 Punjab, Pakistan
338699 2020-07-04 Pakistan Sindh     90721 1459 50908 38354 26.009446 68.77680699999999 2020-07-05 04:33:46 Sindh, Pakistan
271138 2020-07-03 Pakistan Azad Jammu and Kashmir     1160 33 686 441 34.027401 73.947253 2020-07-04 04:33:51 Azad Jammu and Kashmir, Pakistan
271144 2020-07-03 Pakistan Balochistan     10666 122 5073 5471 28.328492 65.898403 2020-07-04 04:33:51 Balochistan, Pakistan
271237 2020-07-03 Pakistan Gilgit-Baltistan     1524 28 1173 323 35.792146 74.982138 2020-07-04 04:33:51 Gilgit-Baltistan, Pakistan
271280 2020-07-03 Pakistan Islamabad     13195 129 8264 4802 33.665087 73.121219 2020-07-04 04:33:51 Islamabad, Pakistan
271314 2020-07-03 Pakistan Khyber Pakhtunkhwa     27170 983 14715 11472 34.485332 72.09169 2020-07-04 04:33:51 Khyber Pakhtunkhwa, Pakistan
271452 2020-07-03 Pakistan Punjab     78956 1819 33786 43351 30.811346 72.13913199999998 2020-07-04 04:33:51 Punjab, Pakistan
271509 2020-07-03 Pakistan Sindh     89225 1437 49926 37862 26.009446 68.77680699999999 2020-07-04 04:33:51 Sindh, Pakistan
214910 2020-07-02 Pakistan Azad Jammu and Kashmir     1160 33 686 441 34.027401 73.947253 2020-07-03 04:33:54 Azad Jammu and Kashmir, Pakistan
214916 2020-07-02 Pakistan Balochistan     10666 122 5073 5471 28.328491999999997 65.898403 2020-07-03 04:33:54 Balochistan, Pakistan
215009 2020-07-02 Pakistan Gilgit-Baltistan     1524 28 1173 323 35.792146 74.982138 2020-07-03 04:33:54 Gilgit-Baltistan, Pakistan
215052 2020-07-02 Pakistan Islamabad     13195 129 8264 4802 33.665087 73.121219 2020-07-03 04:33:54 Islamabad, Pakistan
215086 2020-07-02 Pakistan Khyber Pakhtunkhwa     27170 983 14715 11472 34.485332 72.09169 2020-07-03 04:33:54 Khyber Pakhtunkhwa, Pakistan
215224 2020-07-02 Pakistan Punjab     78956 1819 33786 43351 30.811346 72.13913199999998 2020-07-03 04:33:54 Punjab, Pakistan
215281 2020-07-02 Pakistan Sindh     89225 1437 49926 37862 26.009446 68.77680699999999 2020-07-03 04:33:54 Sindh, Pakistan
167336 2020-07-01 Pakistan Azad Jammu and Kashmir     1135 32 557 546 34.027401 73.947253 2020-07-02 04:33:46 Azad Jammu and Kashmir, Pakistan
167342 2020-07-01 Pakistan Balochistan     10608 121 4764 5723 28.328492 65.898403 2020-07-02 04:33:46 Balochistan, Pakistan
167435 2020-07-01 Pakistan Gilgit-Baltistan     1511 28 1146 337 35.792146 74.982138 2020-07-02 04:33:46 Gilgit-Baltistan, Pakistan
167478 2020-07-01 Pakistan Islamabad     13082 129 7850 5103 33.665087 73.121219 2020-07-02 04:33:46 Islamabad, Pakistan
167512 2020-07-01 Pakistan Khyber Pakhtunkhwa     26938 973 13584 12381 34.485332 72.09169 2020-07-02 04:33:46 Khyber Pakhtunkhwa, Pakistan
167650 2020-07-01 Pakistan Punjab     77740 1784 28266 47690 30.811346 72.13913199999998 2020-07-02 04:33:46 Punjab, Pakistan
167707 2020-07-01 Pakistan Sindh     86795 1406 48527 36862 26.009446 68.77680699999999 2020-07-02 04:33:46 Sindh, Pakistan
356185 2020-06-30 Pakistan Azad Jammu and Kashmir     1093 30 550 513 34.027401 73.947253 2020-07-01 04:33:52 Azad Jammu and Kashmir, Pakistan
356191 2020-06-30 Pakistan Balochistan     10476 121 4484 5871 28.328492 65.898403 2020-07-01 04:33:52 Balochistan, Pakistan
356284 2020-06-30 Pakistan Gilgit-Baltistan     1489 26 1128 335 35.792146 74.982138 2020-07-01 04:33:52 Gilgit-Baltistan, Pakistan
356327 2020-06-30 Pakistan Islamabad     12912 128 7261 5523 33.665087 73.121219 2020-07-01 04:33:52 Islamabad, Pakistan
356361 2020-06-30 Pakistan Khyber Pakhtunkhwa     26598 951 13067 12580 34.485332 72.09169 2020-07-01 04:33:52 Khyber Pakhtunkhwa, Pakistan
356499 2020-06-30 Pakistan Punjab     76262 1762 27488 47012 30.811346 72.13913199999998 2020-07-01 04:33:52 Punjab, Pakistan
356556 2020-06-30 Pakistan Sindh     84640 1377 46824 36439 26.009446 68.77680699999999 2020-07-01 04:33:52 Sindh, Pakistan
53333 2020-06-29 Pakistan Azad Jammu and Kashmir     1065 28 539 498 34.027401 73.947253 2020-06-30 04:33:48 Azad Jammu and Kashmir, Pakistan
53339 2020-06-29 Pakistan Balochistan     10426 119 4197 6110 28.328491999999997 65.898403 2020-06-30 04:33:48 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
);
Powered by Datasette · Query took 2345.048ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette