{ Analytica Model Using_GPT_to_clean_i, encoding="UTF-8" }
SoftwareVersion 6.3.6
{ System Variables with non-default values: }
SampleSize := 1000
TypeChecking := 1
Checking := 1
SaveOptions := 2
SaveValues := 0
DisplayInputs Object: Object Function, Object Index, Object Constant, Index Param_rec, Index Parameters_rec, Function Enum_vals_for_fn_par, Constant RE_for_Parameters_in, Function Embedding_similarity, Function Embedding_for
DisplayInputs Function: Object Self, Object Index, Object Constant, Index Param_rec, Index Parameters_rec, Function Enum_vals_for_fn_par, Constant RE_for_Parameters_in
DisplayOutputs Function: Object Object, Object Self, Object Variable
{!-50299|DiagramColor Model: 65535,65535,65535}
{!-50299|DiagramColor Module: 65535,65535,65535}
{!-50299|DiagramColor LinkModule: 65535,65535,65535}
{!-50299|DiagramColor Library: 65535,65535,65535}
{!-50299|DiagramColor LinkLibrary: 65535,65535,65535}
{!-50299|DiagramColor Form: 65535,65535,65535}
DisplayInputs Variable: Object Function, Function Embedding_similarity, Function Embedding_for
DisplayOutputs Index: Object Object, Object Function
DisplayOutputs Constant: Object Object, Object Function
NodeInfo FormNode: 1,0,0,,0,0,,,,0,,,0
{!-50299|NodeColor Text: 62258,62258,62258}
{!-60000|Attribute AcpStyles}
Model Using_GPT_to_clean_i
Title: Using GPT to clean inconsistent data
Description: This example model demonstrates how you can use GPT to clean real data.~
The data used here comes from the Pakistan Suicide Bombing Attacks data set on Kaggle. The example processes only the Time column, where the format of the entries is extremely varied and inconsistent.~
~
Normally this level of inconsistency would likely require a human in the loop to interpret the values and figure out what value to use. But GPT is pretty capable (even GPT-3.5) and can mostly likely handle this.~
~
The model is broken down into fine-grain steps so you can inspect each step of the processing in a separate variable. Read the Description of each variable for a detailed discussion of what is being done and why.
Author: Lonnie Chrisman~
Lumina Decision Systems
Date: Tue, Sep 5, 2023 10:28 AM
DiagState: 2,0,0,1590,1033,19,10,
WindState: 2,98,82,720,350
FontStyle: Arial,15
FileInfo: 0,Model Using_GPT_to_clean_i,2,2,0,0,C:\Src\AI Assistant Prototype\Example models\Using GPT to clean inconsistent data.ana
Index Attack_num
Title: Attack num
Description: This is the data index -- indexes each suiicide attack in the data set.
Definition: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496]
NodeLocation: 104,160,1
NodeSize: 64,24
NodeInfo: 1,,,,,,,0,,,,,,0
NumberFormat: 2,I,4,0,0,0,4,0,,0,"ABBREV",0,,,0,0,15,,0
Index Column
Description: The column index in the data set.
Definition: ['Date','Islamic Date','Blast Day Type','Holiday Type','Time','City','Latitude','Longitude','Province','Location','Location Category','Location Sensitivity','Open/Closed Space','Influencing Event/Event','Target Type','Targeted Sect if any','Killed Min','Killed Max','Injured Min','Injured Max','No. of Suicide Blasts','Explosive Weight (max)','Hospital Names','Temperature(C)','Temperature(F)']
NodeLocation: 104,224,1
NodeSize: 64,24
NodeInfo: 1,,,,,,,0,,,,,,0
NumberFormat: 2,I,4,0,0,0,4,0,,0,"ABBREV",0,,,0,0,15,,0
Variable The_data_Pakistan_su
Title: The data:~
Pakistan suicide attacks
Description: This is the Pakistan Suicide Bombing Attacks data set from Kaggle (unmodifed)
Definition: Table(Attack_num,Column)(~
19-Nov-1995,'25 Jumaada al-THaany 1416 A.H','Holiday','Weekend','N/A','Islamabad',33.718,73.0718,'Capital','Egyptian Embassy','Foreign','High','Closed',Null,'Foreigner','None',14,15,Null,60,2,Null,Null,15.835,60.503,~
6-Nov-2000,'10 SHa`baan 1421 A.H','Working Day',Null,'N/A','Karachi',24.9918,66.9911,'Sindh','office of Nawa-e-Waqt','Office Building','Low','Closed',Null,'Media','None',Null,3,Null,3,1,Null,Null,23.77,74.786,~
8-May-2002,'25 safar 1423 A.H','Working Day',Null,07:45:00,'Karachi',24.9918,66.9911,'Sindh','Pakistan Navy bus Parked outside Five Star Sheraton Hotel','Hotel','Medium','Closed',Null,'Foreigner','Christian',13,15,20,40,1,'2.5 Kg','1.Jinnah Postgraduate Medical Center 2. Civil Hospital Karachi 3. PN Shifa',31.46,88.628,~
14-Jun-2002,'3 Raby` al-THaany 1423 A.H','Working Day',Null,11:10:00,'Karachi',24.9918,66.9911,'Sindh','US Consulate Civil Lines Area','Foreign','High','Closed',Null,'Foreigner','Christian',Null,12,Null,51,1,'NA','NA',31.43,88.574,~
4-Jul-2003,'4 Jumaada al-awal 1424 A.H','Working Day',Null,'N/A','Quetta',30.2095,67.0182,'Baluchistan','Imambargah MeCongy Road Quetta','Religious','Medium','Closed','during Friday prayer','Religious','Shiite',44,47,Null,65,1,'NA','1.CMH Quetta ~
2.Civil Hospital 3. Boland Medical Complex',33.12,91.616,~
25-Dec-2003,'2 Thw al-Qi`dah 1424 A.H.','Holiday','Christmas/birthday of Quaid-e-Azam','1:40:00 PM/1:42:00 PM','Rawalpindi',33.6058,73.0437,'Punjab','Jhanda Chichi area rawalpindi','Mobile','Low','Open','president''s/chief of army staff convoy passing from there','Military','None',16,18,Null,50,2,'30kg in each car','1.District headquarters ~
Hospital ',9.445,49.001,~
28-Feb-2004,'8 MuHarram 1425 A.H','Working Day',Null,Null,'Rawalpindi',33.6058,73.0437,'Punjab','Yadgar-i-Hussaini in Satellite Town','Religious','Medium','Closed','maghrib prayer was in process','Religious','shiite',Null,1,3,4,1,'NA','NA',15.275,59.495,~
7-May-2004,'18 Raby` al-awal 1425 A.H','Working Day',Null,'1:20:00/1:17:00 PM','Karachi',24.9918,66.9911,'Sindh','Karachi Shia mosque Sindh Madrassatul Islam','Religious','Medium','Closed','Friday prayer was in progress','Religious','shiite',14,15,96,200,1,'2kg','Civil hospital',33.86,92.948,~
31-May-2004,Null,'Working Day',Null,'evening','Karachi',24.9918,66.9911,'Sindh','Imambargah off M.A Jinnah road near Numaish intersection','Religious','Medium','Closed',Null,'Religious','Shiite',16,18,Null,35,1,'NA','Civil hospital-Liaquat National hospital-Jinnah Postgraduate Medical Center',31.605,88.889,~
3-Jun-2004,'15 Raby` al-THaany 1425 A.H','Working Day',Null,'N/A','North waziristan',32.9746,70.1456,'FATA','checkpost in north waziristan-close to Afghanistan border','Military','High','Open',Null,'Military','None',Null,2,Null,2,1,Null,Null,27.18,80.924,~
28-Jul-2004,'11 Jumaada al-THaany 1425 A.H','Working Day',Null,20:50:00,'Kohat',33.5833,71.4333,'KPK','Near military facility/official Residence of General Officer Commanding','Residence','High','Closed','Army','Military','None',2,3,Null,3,2,'NA','CMH Kohat',32.43,90.374,~
30-Jul-2004,'13 Jumaada al-THaany 1425 A.H','Working Day',Null,19:20:00,'Attock',33.7645,72.3667,'Punjab','Mr Aziz election rally in jaffar village in fateh jang','Park/Ground','Low','Open','Election rally','Government Official','None',Null,7,44,70,1,'NA','1.District Headquarters hospital-rwp 2.PIMS Hospital 3. Tehsil headquarters hospital-Fateh Jang',26.665,79.997,~
1-Oct-2004,'17 SHa`baan 1425 A.H','Working Day',Null,'1:27 PM/1:25 PM','Sialkot',32.4972,74.5361,'Punjab','zainabia mosque-just a Km away from city police station on Raja road','Religious','Medium','Closed','Friday prayer','Religious','shiite',25,31,50,75,1,'NA','Allama Iqbal Memorial DHQ Hospital-Sardar Begum Hospital-and numner of other hospitals in Sialkot-Daska-Gujranwala and Lahore',27.51,81.518,~
10-Oct-2004,'26 SHa`baan 1425 A.H.','Holiday','Weekend','5:55:00/6:40:00 PM','Lahore',31.5451,74.3407,'Punjab','Jamia Masjid Kashmirian in Mochi Gate','Religious','Medium','Closed','Jamia Masjid /Shia Mosque','Religious','shiite',4,5,6,10,1,'NA','Mayo Hospital',24.39,75.902,~
19-Mar-2005,'9 safar 1426 A.H','Working Day',Null,'11.45PM /10.30 pm','Quetta',30.2095,67.0182,'Baluchistan','Gandava Town Shrine','Religious','Medium','Closed','Urs Ceremony','Religious','Shiite',25,50,8,100,1,'NA','NA',16.5,61.7,~
28-Apr-2005,'19 Raby` al-awal 1426 A.H','Working Day',Null,'N/A','Swat',35.2227,72.4258,'KPK','Baidara village of Matta-District Swat','Park/Ground','Low','Open','NA','civilian','None',Null,2,Null,Null,1,'NA','NA',19.935,67.883,~
27-May-2005,'19 Raby` al-THaany 1426 A.H','Working Day',Null,11:00:00,'Islamabad',33.718,73.0718,'Capital','Shrine of Bari Imam','Religious','Medium','Closed','Shia Muslim Annual ~
Congregation ','Civilian','Shiite/sunni',20,25,82,100,1,'NA','1. PIMS 2.Polyclinic 3.CDA Hospital 4.federal govt services 5.rwp generl hosp',27.16,80.888,~
30-May-2005,'22 Raby` al-THaany 1426 A.H','Working Day',Null,'evening','Karachi',24.9918,66.9911,'Sindh','Courtyard of an Imambargah(Madinatul Ilm ) in Gulshan e Iqbal','Religious','Medium','Closed','evening prayer','Religious','shiite',5,6,19,30,1,'NA','1. Patel Hospital 2. JMPC',31.945,89.501,~
9-Feb-2006,'10 MuHarram 1427 A.H','Holiday','Ashura',09:35:00,'Hangu',33.5351,71.0713,'KPK','Hangu-Tall road-Ashura Procession','Park/Ground','Low','Open','Ashura Day','Religious','Shiite',37,40,90,Null,1,'NA','Hangu Hospital',15.495,59.891,~
2-Mar-2006,'2 safar 1427 A.H.','Working Day',Null,09:00:00,'Karachi',24.9918,66.9911,'Sindh','Infront of USA consulate near marriott hotel','Hotel','Medium','Open','Terrorists attacked convoy of david foy-american diplomat.','Foreigner','Christian',4,5,30,54,1,'10-15 kg',Null,25.3,77.54,~
12-Apr-2006,'14 Raby` al-awal 1427 A.H','Holiday','Eid Milad un-Nabi','7.00 pm','Karachi',24.9918,66.9911,'Sindh','Nishter Park','Park/Ground','Medium','Open','Eid Miladun Nabi','Religious','Sunni',47,57,Null,100,1,'5 kg','1. Liaquat National Hospital 2. Civil Hospital KHI 3. JPMC 4. Abbasi Shaheed Hospital',28.415,83.147,~
2-Jun-2006,'6 Jumaada al-awal 1427 A.H','Working Day',Null,'10.30 am','Bannu',32.9861,70.6042,'KPK','Bakkahel Area of FR Bannu','Mobile','High','Open','Army convoy','Military','None',6,7,7,8,1,'NA','1. Combined Military 2. Hospital Peshawar',26.125,79.025,~
26-Jun-2006,'30 Jumaada al-awal 1427 A.H','Working Day',Null,15:30:00,'North Waziristan',32.9746,70.1456,'FATA','Aisha Checkpoint-10km East of ~
Miranshah','Military','High','Open','NA','Military','None',6,7,Null,26,1,'NA','NA',28.61,83.498,~
6-Aug-2006,'12 Rajab 1427 A.H','Holiday','Weekend','8.00 am','Lasbela',25.8377,66.5224,'Baluchistan','Zehri Street-Main Market~
Hub','Market','Low','Open','NA','Civilian','None',Null,1,Null,0,1,'NA','NA',27.5,81.5,~
8-Nov-2006,'17 SHawwal 1427 A.H','Working Day',Null,'8.30am','Malakand',34.503,71.9046,'KPK','Dargai Military Base-100km north of Peshawar','Military','High','Open','Recruits parade','Military','None',40,42,20,39,1,'NA','1. CMH Mardan~
2. CMH Peshawar',19.205,66.569,~
17-Nov-2006,'26 SHawwal 1427 A.H.','Working Day',Null,'7.30 am/7:15AM','Peshawar',34.0043,71.5448,'KPK','Fayaz Khalil Shaheed~
Chowk','Mobile','High','Open','police van','Police','None',Null,1,Null,2,1,'NA','NA',17.275,63.095,~
3-Dec-2006,'12 Thw al-Qi`dah 1427 A.H.','Holiday','Weekend','N/A','Bannu',32.9861,70.6042,'KPK','Speen Tangi-kohat bannu road','Police','High','Open','NA','Police','None',Null,1,Null,1,1,'NA','NA',4.705,40.469,~
22-Jan-2007,'3 MuHarram 1428 A.H','Working Day',Null,10:30:00,'North Waziristan',32.9746,70.1456,'FATA','Miltary convoy near Mir ali north~
Wazirstan ','Mobile','High','Open','Military convoy','Military','None',4,5,23,25,1,'NA','NA',2.325,36.185,~
26-Jan-2007,'7 MuHarram 1428 A.H','Working Day',Null,14:37:00,'Islamabad',33.718,73.0718,'Capital','Islamabad Marriott Hotal','Hotel','Medium','Closed','Indian High Commission Function','Foreigner','None',1,2,5,7,1,'NA','1.poly Clinic Hospital',16.3,61.34,~
27-Jan-2007,'8 MuHarram 1428 A.H','Working Day',Null,20:40:00,'Peshawar',34.0043,71.5448,'KPK','near Mosque in QissaKhawani Bazaar','Religious','Medium','Closed','Muharram procession about to start','Civilian','shiite',13,15,30,60,1,'NA','1.Lady Reading hospital',15.165,59.297,~
29-Jan-2007,'10 MuHarram 1428 A.H','Holiday','Ashura','N/A','D.I Khan',31.8238,70.9095,'KPK','Checkpost Dera Ismial Khan','Police','High','Open','Muharram procession','Civilian','shiite',2,3,Null,7,1,'NA','1.DIK Headquarters ~
Hospital ',17.745,63.941,~
3-Feb-2007,'15 MuHarram 1428 A.H.','Working Day',Null,06:17:00,'Lakki Marwat',32.6018,70.9148,'KPK','Ghazanikhel Market ~
Laik marwat','Market','Low','Open',Null,'Civilian','None',Null,1,Null,Null,1,'NA','NA',17.52,63.536,~
3-Feb-2007,'15 MuHarram 1428 A.H.','Working Day',Null,12:15:00,'Tank',31.8238,70.9095,'KPK','Military Convoy Barakhel area-tank','Mobile','High','Open','Military convoy','Military','None',Null,2,7,8,1,'NA','1.CMH Dera',19.935,67.883,~
6-Feb-2007,'18 MuHarram 1428 A.H.','Working Day',Null,'8:50:00 PM/9:10 PM','Islamabad',33.718,73.0718,'Capital','Islamabad Airport','Airport','High','Open',Null,'Civilian','None',Null,1,3,10,1,'NA','NA',16.635,61.943,~
17-Feb-2007,'29 MuHarram 1428 A.H','Working Day',Null,11:05:00,'Quetta',30.2095,67.0182,'Baluchistan','Quetta District court senior civil~
judge District Court','Government','High','Closed',Null,'Civilian','None',16,17,30,35,1,'NA','1.Quttea Civil hospital ~
2.Bolan medical hospital ',8.72,47.696,~
29-Mar-2007,'10 Raby` al-awal 1428 A.H','Working Day',Null,11:45:00,'Gujrat',32.5737,74.0786,'Punjab','Army training area guliana ~
near Kharian Contonment','Military','High','Open',Null,'Military','None',1,2,6,8,1,'NA','1.Combined Military~
Hospital ',25.595,78.071,~
28-Apr-2007,'11 Raby` al-THaany 1428 A.H.','Working Day',Null,18:55:00,'Charsadda',34.1509,71.7359,'KPK','Federal Interior Minister Speech ~
rallyy hometown Charsadda','Park/Ground','Low','Open','Rally Charsadda','Government Official','None',25,35,29,60,1,'NA','1.District Headquarters Hospital~
2.Lady Reading Hospital ',28.055,82.499,~
15-May-2007,'28 Raby` al-THaany 1428 A.H','Working Day',Null,12:55:00,'Peshawar',34.0043,71.5448,'KPK','Peshawar Hotel','Hotel','Medium','Closed',Null,'Foreigner','Sunni',22,26,12,35,1,'NA','1.Lady Reading Hospital',31.1,87.98,~
28-May-2007,'11 Jumaada al-awal 1428 A.H','Working Day',Null,'About 12pm','Tank',32.226,70.3761,'KPK','Boltonabad aera','Mobile','High','Open','rammed the vehicle into FC vehicle','Military','None',Null,3,Null,2,1,'NA','NA',24.935,76.883,~
4-Jul-2007,'19 Jumaada al-THaany 1428 A.H','Working Day',Null,10:25:00,'North Waziristan',32.9746,70.1456,'FATA','Miltary convoy in bannu Gurbaz area','Mobile','High','Open','Military convoy','Military','None',8,10,9,12,1,'NA','1.CMH Peshawar',26.975,80.555,~
12-Jul-2007,'27 Jumaada al-THaany 1428 A.H','Working Day',Null,'N/A','Swat',35.2227,72.4258,'KPK','Security Force convoy in mingora','Mobile','High','Open','Military convoy','Military','None',6,7,4,8,1,'NA','1.Agency Headquarters ~
hospital ',31.74,89.132,~
12-Jul-2007,'27 Jumaada al-THaany 1428 A.H','Working Day',Null,16:30:00,'North Waziristan',32.9746,70.1456,'FATA','Political Agent Office in Miranshah','Government','High','Closed',Null,'Government official','None',2,4,Null,3,1,'NA','NA',31.39,88.502,~
14-Jul-2007,'29 Jumaada al-THaany 1428 A.H','Working Day',Null,14:00:00,'North Waziristan',32.9746,70.1456,'FATA','Razmak towns Daznaray area-20kms to the north of Miramshah','Mobile','High','Open','Frontier Constabulary convoy','Military','None',23,24,26,29,1,'NA','1.CMH Bannu hospital',26.02,78.836,~
15-Jul-2007,'1 Rajab 1428 A.H','Holiday','Weekend','3:30 PM-4:00:00 PM/4:15PM','D.I Khan',31.8238,70.9095,'KPK','police recruitment center','Police','High','Closed','recruitment process in progress','Police','None',25,30,50,61,1,'NA','1.District Headquarters ~
Hospital ',28.82,83.876,~
15-Jul-2007,'1 Rajab 1428 A.H','Holiday','Weekend','between 7:00-7:40 AM','Swat',35.2227,72.4258,'KPK','Matta','Mobile','High','Open','police bus going from Kabal to Matta','Police','None',17,20,40,47,1,'NA',Null,27.255,81.059,~
17-Jul-2007,'3 Rajab 1428 A.H','Working Day',Null,08:27:00,'Islamabad',33.718,73.0718,'Capital','outside the venue of distric bar convention council Islamabad','Government','High','Open','Chief Justice Iftikhar muhammad ch had to address overthere','Government official','None',16,17,50,70,1,'NA','1.Fedral govt services hospital 2.PIMS',28.875,83.975,~
17-Jul-2007,'3 Rajab 1428 A.H','Working Day',Null,13:30:00,'North Waziristan',32.9746,70.1456,'FATA','Security check post Miramshah ~
North Wazirstan ','Military','High','Open',Null,'Military','None',Null,4,2,3,1,'NA','1.CMH Bannu hospital',26.945,80.501,~
19-Jul-2007,'5 Rajab 1428 A.H','Working Day',Null,08:40:00,'Lasbela',25.8377,66.5224,'Baluchistan','Industrial town hub baluchistan','Mobile','High','Open','chinese engineers were going from Karachi to Hub','Foreigner','Christian',28,30,28,50,1,'NA',Null,32.395,90.311,~
19-Jul-2007,'5 Rajab 1428 A.H','Working Day',Null,07:50:00,'Hangu',33.5351,71.0713,'KPK','Training Center in Hangu','Police','High','Closed',Null,'Police','None',6,8,30,35,1,'NA',Null,30.735,87.323,~
19-Jul-2007,'5 Rajab 1428 A.H','Working Day',Null,'N/A','Kohat',33.5833,71.4333,'KPK','Kohat Mosque','Religious','Medium','Closed',Null,'Religious','Sunni',15,20,8,58,1,'NA','CMH kohat',30.275,86.495,~
20-Jul-2007,'6 Rajab 1428 A.H','Working Day',Null,'12:30:00 PM/11:00AM','North Waziristan',32.9746,70.1456,'FATA','Security check post Miramshah ~
North Wazirstan ','Military','High','Open',Null,'Military','None',Null,4,5,6,1,'NA','NA',28.375,83.075,~
27-Jul-2007,'13 Rajab 1428 A.H','Working Day',Null,17:25:00,'Islamabad',33.718,73.0718,'Capital','near Hotel in Abpara market','Hotel','Medium','Closed',Null,'Police','None',14,15,50,70,1,'NA','1.Federal Government~
services hospital~
2.Capital Development ~
Authority hospital ',26.39,79.502,~
3-Aug-2007,'20 Rajab 1428 A.H.','Working Day',Null,'Night','Swat',35.2227,72.4258,'KPK','District Swat gora village matta','Mobile','Low','Open',Null,'civilian','None',Null,2,5,6,1,'NA','NA',28.01,82.418,~
4-Aug-2007,'21 Rajab 1428 A.H','Working Day',Null,10:30:00,'Kuram Agency',32.9746,70.1456,'FATA','Parachinar','Transport','Low','Open',Null,'civilian','Sunni',9,23,35,43,1,'NA','1.Agency Headqurters ~
Hospital ',25.835,78.503,~
17-Aug-2007,'4 SHa`baan 1428 A.H','Working Day',Null,'NA','Tank',32.226,70.3761,'KPK','Military Convoys in Tank district','Mobile','High','Open',Null,'Military','None',Null,Null,3,5,1,'NA','NA',26.185,79.133,~
19-Aug-2007,'6 SHa`baan 1428 A.H','Holiday','Weekend','NA','North Waziristan',32.9746,70.1456,'FATA','North Wazirstan Mirali Military~
checkpost ','Military','High','Open',Null,'Military','None',Null,2,Null,2,1,'NA','NA',29.01,84.218,~
19-Aug-2007,'6 SHa`baan 1428 A.H','Holiday','Weekend','NA','Bannu',32.9861,70.6042,'KPK','Bannu Police Check post','Police','High','Open',Null,'Police','None',Null,1,Null,4,1,'NA','NA',29.965,85.937,~
20-Aug-2007,'7 SHa`baan 1428 A.H','Working Day',Null,09:00:00,'Hangu',33.5351,71.0713,'KPK','Checkpost on thall-parachinar road/kurram road~
mandori village ','Military','High','Open',Null,'Military','None',3,7,14,18,1,'NA','1.Nawagai hospital',27.195,80.951,~
24-Aug-2007,'11 SHa`baan 1428 A.H','Working Day',Null,'NA','North Waziristan',32.9746,70.1456,'FATA','miranshah Military convoys','Mobile','High','Open','military convoy','Military','None',6,7,22,37,2,'NA','1.Bannu Hospital',28.365,83.057,~
26-Aug-2007,'13 SHa`baan 1428 A.H','Holiday','Weekend','NA','Shangla',34.8015,72.757,'KPK','Machaar area of Shangla District','Police','High','Open',Null,'police','None',Null,4,Null,2,1,'NA','NA',27.475,81.455,~
1-Sep-2007,'19 SHa`baan 1428 A.H','Working Day',Null,10:00:00,'Bajaur Agency',34.8718,71.5249,'FATA','Truck carrying security personeel was attacked in Mamond area','Mobile','High','Open','truck carrying security personnel','Military','None',3,7,4,9,1,'NA','1.Agency Headquarters ~
hospital ',28.84,83.912,~
1-Sep-2007,'19 SHa`baan 1428 A.H','Working Day',Null,Null,'South Waziristan',32.3202,69.8597,'FATA','check-post of the troops in the Jandola area of South Waziristan.','Military','High','Closed',Null,'Military','None',Null,0,Null,Null,1,'NA','NA',29.58,85.244,~
4-Sep-2007,'22 SHa`baan 1428 A.H','Working Day',Null,07:15:00,'Rawalpindi',33.6058,73.0437,'Punjab','1.Qasim Market Defence Ministry Bus','Mobile','High','Open',Null,'Military','None',18,25,Null,Null,2,'NA','1.District Headquarters Rwp~
2.Rwp General Hospital',27.15,80.87,~
4-Sep-2007,'22 SHa`baan 1428 A.H','Working Day',Null,07:15:00,'Rawalpindi',33.6058,73.0437,'Punjab','Near R.A Bazar behind general Headquarters','Market','Low','Open',Null,'Military','None',Null,7,Null,Null,1,'NA','1.District Headquarters Rwp~
2.Rwp General Hospital',27.15,80.87,~
11-Sep-2007,'29 SHa`baan 1428 A.H','Working Day',Null,'NA','D.I Khan',31.8238,70.9095,'KPK','Passanger van at Bannu adda/chungi','Mobile','Low','Open',Null,'Civilian','None',17,19,16,19,1,'NA','DI Khan Headquarter~
hospital ',30.815,87.467,~
13-Sep-2007,'1 RamaDHaan 1428 A.H','Working Day',Null,19:15:00,'Haripur',34.0011,72.9372,'KPK','army officers mess in Tarbela ghazi','Military','High','Closed','military convoy','Military','None',15,20,11,46,1,'NA','1.Wapda Hospital 2.CMH Pindi ~
3.CMH Attock ',26.975,80.555,~
22-Sep-2007,'10 RamaDHaan 1428 A.H','Working Day',Null,02:00:00,'Tank',32.226,70.3761,'KPK','military convoy going from Tank','Mobile','High','Open',Null,'Military','None',Null,5,3,10,1,'NA','NA',24.705,76.469,~
1-Oct-2007,'19 RamaDHaan 1428 A.H','Working Day',Null,08:30:00,'bannu',32.9861,70.6042,'KPK','checkpost near Dawa bridge/Durani Abshar Chowk','Police','High','Open','N/A','police','None',Null,16,29,32,1,'NA','1.District Headquartar ~
Hospital ',24.57,76.226,~
18-Oct-2007,'6 SHawwal 1428 A.H','Working Day',Null,'12:00 mid night','karachi',24.9918,66.9911,'Sindh','Benazir Survives midnight ~
carnage Karsaz bridge Sharea Faisal','Mobile','High','Open','Rally ppp','Government Official','None',125,145,100,550,2,'NA','1.Jinnah Hospital ~
2.Liaquat hospital ',28.025,82.445,~
25-Oct-2007,'13 SHawwal 1428 A.H','Working Day',Null,14:45:00,'Swat',35.2227,72.4258,'KPK','Mingora Police Line','Mobile','High','Open',Null,'Military','None',20,38,28,35,1,'NA','1.Saidu Shrif hospital',21.025,69.845,~
30-Oct-2007,'18 SHawwal 1428 A.H','Working Day',Null,11:50:00,'Rawalpindi',33.6058,73.0437,'Punjab','Rawalpindi police checkpoint ~
security zone','Police','High','Open',Null,'Military','None',7,8,18,31,1,'NA','1.CMH 2.Civil hospital',20.905,69.629,~
1-Nov-2007,'20 SHawwal 1428 A.H','Working Day',Null,07:10:00,'Sargodha',32.0791,72.6718,'Punjab','PAF Bus on faisalabad road-Sargodha','Mobile','High','Open','PAF Bus','Military','None',8,10,27,40,1,'10 kg','1.PAF Sargodha ~
2.CMH Rwp',20.82,69.476,~
9-Nov-2007,'28 SHawwal 1428 A.H','Holiday','Iqbal Day',16:15:00,'Peshawar',34.0043,71.5448,'KPK','Peshawar Federal minister ~
political amir muqam house','Residence','Low','Closed','Political Affairs meeting','Government Official','None',3,4,2,5,1,'5 to 6 Kg','1.Hayatabad Medical Complex',19.445,67.001,~
24-Nov-2007,'14 Thw al-Qi`dah 1428 A.H','Working Day',Null,07:40:00,'Rawalpindi',33.6058,73.0437,'Punjab','Bus carrying ISI officals parked outside Hamza Camp faizabad','Mobile','High','Open','Hamza camp','Military','None',17,38,Null,35,1,'NA','1.Military Hospital ~
2.Rawalpindi hospital ',15.555,59.999,~
24-Nov-2007,'14 Thw al-Qi`dah 1428 A.H','Working Day',Null,07:50:00,'Rawalpindi',33.6058,73.0437,'Punjab','GHQ','Military','High','Open',Null,'Military','None',Null,1,2,5,1,'NA',Null,15.555,59.999,~
4-Dec-2007,'24 Thw al-Qi`dah 1428 A.H','Working Day',Null,'NA','Peshawar',34.0043,71.5448,'KPK','Checkpost high-security cantonment area babar road','Military','High','Open',Null,'Military','None',Null,1,Null,0,1,'NA','NA',14.73,58.514,~
9-Dec-2007,'29 Thw al-Qi`dah 1428 A.H','Holiday','Weekend','11:15:00 AM/12:30 PM','Swat',35.2227,72.4258,'KPK','Ningolai Security checkpost','Police','High','Open',Null,'Police','None',10,13,Null,2,1,'10 to 15 kg','NA',11.925,53.465,~
10-Dec-2007,'30 Thw al-Qi`dah 1428 A.H','Working Day',Null,'7:24:00 AM/7:30AM','Attock',33.7645,72.3667,'Punjab','Truck carrying school children near Fauji gate Pakistan Aeranautical Complex','Mobile','Low','Open',Null,'Children/Women','None',Null,0,7,22,1,'NA','1.CMH Rwp',12.13,53.834,~
13-Dec-2007,'3 Thw al-Hijjah 1428 A.H','Working Day',Null,16:50:00,'Quetta',30.2095,67.0182,'Baluchistan','military Checkpost','Military','High','Open',Null,'Military','None',5,12,22,23,2,'NA','1.CMH hospital',4.16,39.488,~
15-Dec-2007,'5 Thw al-Hijjah 1428 A.H','Working Day',Null,09:25:00,'Nowshehra',34.0322,73.0944,'KPK','Noshera security check post','Military','High','Open',Null,'Military','None',5,6,11,20,1,'NA','1.CMH Nowshera',9.515,49.127,~
17-Dec-2007,'7 Thw al-Hijjah 1428 A.H','Working Day',Null,12:30:00,'Kohat',33.5833,71.4333,'KPK','kohat cantt-fountain round about-near army public school','Military','High','Open','recruits returning to barracks after morning exercise','Military','None',Null,12,2,5,1,'more than 5Kg','Combine Military hospital',11.345,52.421,~
21-Dec-2007,'13 Thw al-Hijjah 1428 A.H','Holiday','Eid-ul-azha','NA','Charsadda',34.1509,71.7359,'KPK','Charsadda Jamiya Masjid','Religious','Medium','Closed','Masjid','Civilian','Sunni',Null,60,Null,200,1,'5 to 6 kg','NA',15,59,~
23-Dec-2007,'13 Thw al-Hijjah 1428 A.H','Holiday','Weekend',18:00:00,'Swat',35.2227,72.4258,'KPK','military convoy hit in mingora','Mobile','High','Open',Null,'Military','None',9,14,Null,23,1,'NA','NA',12.76,54.968,~
27-Dec-2007,'17 Thw al-Hijjah 1428 A.H','Working Day',Null,17:10:00,'Rawalpindi',33.6058,73.0437,'Punjab','Rawalpindi Liaquat Bagh Park','Park/Ground','Low','Open','attack on Benazir Bhutto','Government official','None',21,30,48,70,1,'NA','Rawalpindi General hospital',10.21,50.378,~
7-Jan-2008,'28 Thw al-Hijjah 1428 A.H','Working Day',Null,11:15:00,'Swat',35.2227,72.4258,'KPK','infront of frontier house kabal','Military','High','Open','Security forces','Military','None',Null,Null,12,13,1,'NA','NA',6.77,44.186,~
10-Jan-2008,'1 MuHarram 1429 A.H','Working Day',Null,11:40:00,'Lahore',31.5451,74.3407,'Punjab','Lahore High court','Government','High','Open','lawyers protest rally was about to start. All of them were present inside the court. Bomber targeted the police officials outside the court','Police','None',24,26,73,80,1,'15 kg','1.Mayo-Ganga ram hospital',13.89,57.002,~
15-Jan-2008,'6 MuHarram 1429 A.H','Working Day',Null,10:30:00,'Mohmand agency',32.9746,70.1456,'FATA','checkpoint of security forces in Khapakh Kando near Ghalanai','Military','High','Open','Frontier Constabulary','Military','None',1,1,Null,Null,1,'NA','Ghalani hospital',5.145,41.261,~
17-Jan-2008,'8 MuHarram 1429 A.H','Working Day',Null,'6:00:00 PM/6:55PM','Peshawar',34.0043,71.5448,'KPK','Mirza Qasim baig Imambargah Jangi Mohallah-kohati','Religious','Medium','Closed','Imambargah','Religious','shiite',10,12,Null,25,1,'3 kg explosive and 3kg ball bearings','1.Lady Reading hospital',12.34,54.212,~
1-Feb-2008,'23 MuHarram 1429 A.H','Working Day',Null,16:30:00,'North Waziristan',32.9746,70.1456,'FATA','Kajhori checkpost north waziristan','Police','High','Open','Checkpost','Police','None',5,7,13,15,1,'NA','1.CMH bannu 2.MH Bannu',2.475,36.455,~
4-Feb-2008,'26 MuHarram 1429 A.H.','Working Day',Null,'7:24:00 AM/7:25AM/7:30 AM','Rawalpindi',33.6058,73.0437,'Punjab','Infront of NLC office near GHQ Rwp','Mobile','High','Open','bus carrying students and officials of army medical college-','Military','None',8,10,27,47,1,'6-7kg','1.CMH 2.MH 3. DHQ',8.42,47.156,~
5-Feb-2008,'27 MuHarram 1429 A.H','Working Day',Null,'NA','Quetta',30.2095,67.0182,'Baluchistan','Quetta Khilji Conlony','Park/Ground','Low','Open','Khilji colony','Civilian','None',Null,1,Null,1,1,'NA','NA',-2.37,27.734,~
9-Feb-2008,'2 safar 1429 A.H.','Working Day',Null,'NA','Charsadda',34.1509,71.7359,'KPK','Nakai in charsadda','Residence','Low','Closed','Awami National Party meeting was in progress','Government Official','None',25,27,35,51,1,'NA','1.Lady Reading Hospital 2. DHQ charsadda',7.935,46.283,~
11-Feb-2008,'4 safar 1429 A.H','Working Day',Null,12:55:00,'North Waziristan',32.9746,70.1456,'FATA','Aidak village in mirali-near miranshah','Religious','Low','Open','ANP gathring','Government official','None',6,10,9,13,1,'NA','NA',2.245,36.041,~
16-Feb-2008,'9 safar 1429 A.H.','Working Day',Null,'NA','Swat',35.2227,72.4258,'KPK','Mingora-army media center on saidu sharif road','Military','High','Closed','army media center and base near Gul Kadda','Military','None',2,3,14,18,1,'NA','District headquarters hospital saidu sharif',12.725,54.905,~
16-Feb-2008,'9 safar 1429 A.H.','Working Day',Null,'evening','Kuram Agency',35.2227,72.4258,'FATA','PPP election office in Eidgah market of Parachinar bazar','Government','High','Closed',Null,'Government official','None',38,47,109,110,1,'NA','Agency headquarter hospital',12.725,54.905,~
25-Feb-2008,'18 safar 1429 A.H','Working Day',Null,14:45:00,'Rawalpindi',33.6058,73.0437,'Punjab','Rawalpindi-R.A bazar mall road Sadar-nadira suift center','Mobile','High','Closed','near Surgeon-gernal car on signal','Military','None',Null,8,20,30,1,'4-5kg','1.CMH 2.MH 3.Contonment hospital 4. rwp general hospital 5. DHQ hospital',14.47,58.046,~
29-Feb-2008,'22 safar 1429 A.H.','Working Day',Null,20:00:00,'Swat',32.935,70.6688,'KPK','Swat Mingora DSP Funeral','Park/Ground','Low','Open',Null,'Police','None',38,45,40,100,1,'NA','1.Saidu Shrif hospital',19.85,67.73,~
1-Mar-2008,'23 safar 1429 A.H.','Working Day',Null,'NA','Bajaur Agency',34.8718,71.5249,'FATA','Khar-jardar area','Mobile','High','Open',Null,'Military','None',Null,2,Null,23,1,'NA','NA',19.375,66.875,~
2-Mar-2008,'24 safar 1429 A.H.','Holiday','Weekend',11:00:00,'Dara Adam Khel',33.6854,71.5131,'KPK','Dara adamkhel Jirga','Park/Ground','Low','Open','peace Jirga','Anti-Militants','None',40,43,50,60,1,'NA','1.Lady Reading Hospital 2.Hayatabad medical Complex',19.455,67.019,~
4-Mar-2008,'26 safar 1429 A.H','Working Day',Null,13:05:00,'Lahore',31.5451,74.3407,'Punjab','Navy war college mall road lahore','Military','High','Closed','Navy college','Military','None',4,8,15,24,2,'NA','1.CMH 2.Service hospital',20.655,69.179,~
11-Mar-2008,'3 Raby` al-awal 1429 A.H','Working Day',Null,'9:15 AM to 9:20:00 AM','Lahore',31.5451,74.3407,'Punjab','FIA building Temple road near The Mall-near regal chowk','Government','High','Closed',Null,'Government Official','None',26,31,175,200,1,'50kg','1.Ganga Ram Hospita 2.Mayo Hospital',21.295,70.331,~
11-Mar-2008,'3 Raby` al-awal 1429 A.H','Working Day',Null,09:20:00,'Lahore',31.5451,74.3407,'Punjab','Bungalow no 83/F Model Town-an advertising agency office','Residence','Low','Closed',Null,'Civilian','None',3,6,Null,12,1,'30kg','Ganga Ram hospital',21.295,70.331,~
17-Mar-2008,'9 Raby` al-awal 1429 A.H.','Working Day',Null,'NA','Swat',35.2227,72.4258,'KPK','Mingora police Lines','Police','High','Closed',Null,'Police','None',2,3,5,7,1,'NA','Saidu Sharif hospital',22.5,72.5,~
20-Mar-2008,'12 Raby` al-awal 1429 A.H.','Holiday','Eid Milad un-Nabi',15:00:00,'South Waziristan',32.3202,69.8597,'FATA','Army Camp at Zari noor-Wana','Military','High','Closed',Null,'Military','None',Null,5,9,11,1,'NA','Military Hospital',18.655,65.579,~
1-May-2008,'25 Raby` al-THaany 1429 A.H','Holiday','Labour Day','Thursday Morning','Khyber Agency',34.0211,71.2874,'FATA','Takia-Bar Qambarkhel Mosque','Religious','Medium','Closed',Null,'Religious','Sunni',Null,2,17,30,1,'NA','NA',28.985,84.173,~
6-May-2008,'1 Jumaada al-awal 1429 A.H','Working Day',Null,'8:40:00 AM/9:30:00 AM','Bannu',32.935,70.6688,'KPK','Bannu police check post','Police','High','Open',Null,'Police','None',3,7,10,15,1,'NA','1.DHQ 2.CMH',28.62,83.516,~
9-May-2008,'4 Jumaada al-awal 1429 A.H','Working Day',Null,'Friday Night','Swat',35.2227,72.4258,'KPK','Mingora police Station','Police','High','Closed',Null,'Police','None',Null,1,3,4,1,'NA','1.district headquarters hospital saidu sharif',23.985,75.173,~
18-May-2008,'13 Jumaada al-awal 1429 A.H.','Holiday','Weekend',20:00:00,'Mardan',34.1982,72.0444,'KPK','Military run bakery near a punjab regiment center in Mardan cantt','Military','High','Closed',Null,'Military','None',11,13,23,25,1,'NA','1.CMH 2.District Headqurtar Hospital',29.61,85.298,~
2-Jun-2008,'28 Jumaada al-awal 1429 A.H.','Working Day',Null,'1:00:00 PM/1:05PM','Islamabad',33.718,73.0718,'Capital','Islamabad Danish Embassy','Foreign','High','Closed',Null,'Foreigner','Jews',Null,8,25,30,1,'50kg','1.PIMS 2.Federal Government Service Hospital',26.5,79.7,~
6-Jul-2008,'3 Rajab 1429 A.H.','Holiday','Weekend','7:50:00/7:45:00 PM','Islamabad',33.718,73.0718,'Capital','Melody market near lal masjid','Market','Low','Open',Null,'Police','None',15,20,20,47,1,'5 kg','1.PIMS 2.Poly Clinic 3.Federal Government Service Hospital',26.86,80.348,~
13-Jul-2008,'10 Rajab 1429 A.H','Holiday','Weekend','NA','D.I Khan',31.8238,70.9095,'KPK','Shiite gathering -Near kotli imam Hussain','Religious','Medium','Closed',Null,'Religious','Shiite',Null,1,3,4,1,'NA','NA',31.075,87.935,~
13-Aug-2008,'12 SHa`baan 1429 A.H','Working Day',Null,23:35:00,'Lahore',31.5451,74.3407,'Punjab','neaar Iqbal Town police Station Lahore at dubai CHOWK SIGNAL','Police','High','Open',Null,'Police','None',8,9,20,35,1,'NA','1.Sheikh Zahid Hospital',25.835,78.503,~
19-Aug-2008,'18 SHa`baan 1429 A.H.','Working Day',Null,13:30:00,'D.I Khan',31.8238,70.9095,'KPK','Distric headquarter hospital','Hospital','Low','Closed','during the shiite protest against the death of shiite govt official','Civilian','Shiite',30,32,33,55,1,'NA','1.Combined Military Hospital',31.495,88.691,~
21-Aug-2008,'20 SHa`baan 1429 A.H','Working Day',Null,14:37:00,'Rawalpindi',33.6058,73.0437,'Punjab','Wah Cant Pakistn Ordinance Factories','Military','High','Closed',Null,'Government Official','None',70,100,67,200,2,'NA','pof hospital',28.89,84.002,~
23-Aug-2008,'22 SHa`baan 1429 A.H','Working Day',Null,07:45:00,'Swat',35.2227,72.4258,'KPK','Charbagh checkpost','Police','High','Open',Null,'Police','None',7,15,Null,20,1,'100Kg','1.Saidu sharif hospital',25.69,78.242,~
29-Aug-2008,'28 SHa`baan 1429 A.H','Working Day',Null,07:00:00,'Kohat',33.5833,71.4333,'KPK','army base camp/emergency center near Kohat tunnel','Military','High','Closed',Null,'Military','None',2,5,25,39,1,'NA','1.CMH Kohat',27.705,81.869,~
6-Sep-2008,'6 RamaDHaan 1429 A.H','Working Day',Null,'NA','Peshawar',34.0043,71.5448,'KPK','Zangali Checkpost on kohat road','Police','High','Open',Null,'Police','None',30,35,70,90,1,'150Kg','Lady Reading Hospital-Khyber teaching-Hayatabad complex',23.44,74.192,~
16-Sep-2008,'16 RamaDHaan 1429 A.H','Working Day',Null,'Half hour after aftar','Swat',35.2227,72.4258,'KPK','Kabal check post','Police','High','Open',Null,'Police','None',2,10,Null,25,1,'NA','NA',25.95,78.71,~
20-Sep-2008,'20 RamaDHaan 1429 A.H','Working Day',Null,'NA','North waziristan',32.9746,70.1456,'KPK','military convoy on Miranshah road near Norak','Mobile','High','Open',Null,'Military','None',7,17,5,20,1,'NA','1.CMH Bannu hospital',22.06,71.708,~
20-Sep-2008,'20 RamaDHaan 1429 A.H','Working Day',Null,20:05:00,'Islamabad',33.718,73.0718,'Capital','Islamabad Marriott Hotal','Hotel','Medium','Closed',Null,'Foreigner','None',40,60,200,300,1,'1000 Kg','1.Poly Clinic 2. PIMS',24.41,75.938,~
22-Sep-2008,'22 RamaDHaan 1429 A.H','Working Day',Null,'NA','Swat',35.2227,72.4258,'KPK','military security checkpost in Madian Town swat','Military','High','Open',Null,'Military','None',9,13,2,3,1,'NA','NA',21.005,69.809,~
24-Sep-2008,'24 RamaDHaan 1429 A.H','Working Day',Null,'NA','Quetta',30.2095,67.0182,'Baluchistan','Quetta cantt military Check post','Military','High','Open',Null,'Military','None',1,14,22,25,1,'8 Kg','1.CMH Hospital 2.Civil Hospital',23.225,73.805,~
3-Oct-2008,'3 SHawwal 1429 A.H','Holiday','Eid-ul-Fitar',16:00:00,'Peshawar',34.0043,71.5448,'KPK','wali bagh charsadda','Residence','Medium','Closed',Null,'Government Official','None',4,5,Null,18,1,'NA','1.District Hospital Charsadda',29.445,85.001,~
6-Oct-2008,'6 SHawwal 1429 A.H','Working Day',Null,16:45:00,'Bhakkar',31.6216,71.065,'Punjab','Bhakkar Rasheed Noranni MNA house','Residence','Medium','Closed',Null,'Government Official','None',22,26,60,100,1,'NA','1.Nishtar Hospital Multan',29.025,84.245,~
9-Oct-2008,'9 SHawwal 1429 A.H','Working Day',Null,12:45:00,'Islamabad',33.718,73.0718,'Capital','Islamabad Police line-anti terrorist squad building','Police','High','Closed','lawmakers gathered for a secret security briefing','Police','None',Null,Null,6,12,1,'60Kg','1. PIMS 2.Federal Government Services',24.17,75.506,~
9-Oct-2008,'9 SHawwal 1429 A.H','Working Day',Null,12:55:00,'Khyber Agency',34.0211,71.2874,'FATA','near michni post in landi kotal','Mobile','High','Open',Null,'Foreigner','Christian',Null,0,Null,0,1,'NA',Null,24.47,76.046,~
10-Oct-2008,'10 SHawwal 1429 A.H','Working Day',Null,'NA','Orakzai Agency',32.9746,70.1456,'FATA','anti-taliban Jirga-Khadezai area in upper Orakzai Agency','Park/Ground','Low','Open',Null,'Anti-Militants','Sunni',40,85,90,200,1,'8 ft deep crater','1.Kohat Dvisional Headquarters Hospital 2.Gahluj hospital 3.Hospitals in Hangu and Kohat',20.58,69.044,~
16-Oct-2008,'16 SHawwal 1429 A.H','Working Day',Null,'NA','Swat',35.2227,72.4258,'KPK','Mingora police Station','Police','High','Closed',Null,'Police','None',Null,4,Null,27,1,'NA','NA',19.835,67.703,~
26-Oct-2008,'26 SHawwal 1429 A.H','Holiday','Weekend',21:45:00,'Mohmand Agency',32.9746,70.1456,'FATA','Mohmad Agency-naqi Checkpost','Military','High','Open',Null,'Military','None',11,10,Null,5,1,'NA','1.Ghalaanai Hospital',15.35,59.63,~
29-Oct-2008,'29 SHawwal 1429 A.H.','Working Day',Null,14:15:00,'Bannu',32.9861,70.6042,'KPK','Militay checkpost cantoment area bannu','Military','High','Open',Null,'Military','None',Null,Null,Null,14,1,'NA','1.Combined Military Hospital',22.09,71.762,~
31-Oct-2008,'2 Thw al-Qi`dah 1429 A.H','Working Day',Null,13:30:00,'Mardan',34.1982,72.0444,'KPK','outside the office of Mardan DIG in malakand mardan road','Police','High','Closed',Null,'Police','None',9,10,21,25,1,'NA','district headquarter hospital',20.895,69.611,~
2-Nov-2008,'5 Thw al-Qi`dah 1429 A.H','Holiday','Weekend',09:00:00,'South Waziristan',32.3202,69.8597,'FATA','Zalai FC checkpost wana','Military','High','Open',Null,'Military','None',Null,8,Null,8,1,Null,Null,21.735,71.123,~
4-Nov-2008,'6 Thw al-Qi`dah 1429 A.H','Working Day',Null,Null,'Hangu',33.5351,71.0713,'KPK','Doabba-checkpost near surpul on hangu tal road','Police','High','Open',Null,'Police','None',Null,7,Null,4,1,'40 kg','CMH Hangu',21.11,69.998,~
6-Nov-2008,'8 Thw al-Qi`dah 1429 A.H','Working Day',Null,'NA','Swat',35.2227,72.4258,'KPK','Swat Police check post','Police','High','Open',Null,'Police','None',Null,2,Null,10,1,'NA','Syedo Shrif Hospital',16.485,61.673,~
6-Nov-2008,'8 Thw al-Qi`dah 1429 A.H','Working Day',Null,'NA','Bajaur Agency',34.8718,71.5249,'FATA','Salarzai Jirga in batmali area-Bajaur','Park/Ground','Low','Open','tribes were discussing formation of lashkar','Anti-Militants','Sunni',16,23,31,45,1,'NA','NA',16.705,62.069,~
11-Nov-2008,'13 Thw al-Qi`dah 1429 A.H','Working Day',Null,'NA','Peshawar',34.0043,71.5448,'KPK','Qayyum Stadium','Park/Ground','Low','Open','Sport Stadium','Government Official','None',3,4,13,20,1,'7 or 8Kg','1.Lady Reading Hospital 2.Combined Military Hospital',19.17,66.506,~
12-Nov-2008,'14 Thw al-Qi`dah 1429 A.H','Working Day',Null,10:00:00,'Charsadda',34.1509,71.7359,'KPK','attack on security forces camp in Subhan Khaur school-shabqadar area near muhamand agency boder','Military','High','Closed',Null,'Military','None',Null,7,10,12,1,'NA','NA',19.165,66.497,~
17-Nov-2008,'19 Thw al-Qi`dah 1429 A.H.','Working Day',Null,11:15:00,'Swat',35.2227,72.4258,'KPK','Security checkpost in gashgur area of Khawazakhela','Military','High','Open',Null,'Military','None',Null,10,Null,8,1,'NA','NA',14.075,57.335,~
20-Nov-2008,'22 Thw al-Qi`dah 1429 A.H.','Working Day',Null,'during maghrib prayer','Bajaur Agency',34.8718,71.5249,'FATA','Mosque in Badaan area of mamund','Religious','Medium','Closed','maghrib prayer','Religious','Sunni',Null,9,Null,Null,1,Null,'District hospital Bajur',14.17,57.506,~
28-Nov-2008,'30 Thw al-Qi`dah 1429 A.H.','Working Day',Null,'NA','Buner',34.3943,72.6151,'KPK','near Tarezi Chowk on the main Bannu-Kohat road.','Mobile','High','Open',Null,'Police',Null,Null,9,Null,16,1,'NA','NA',16.61,61.898,~
1-Dec-2008,'3 Thw al-Hijjah 1429 A.H','Working Day',Null,'Monday Morning','Swat',35.2227,72.4258,'KPK','sangota checkpost in mingora','Military','High','Open',Null,'Military','None',Null,10,Null,50,1,'NA','NA',15.45,59.81,~
3-Dec-2008,'5 Thw al-Hijjah 1429 A.H','Working Day',Null,'NA','Charsadda',34.1509,71.7359,'KPK','Army Convoy passing from shabqadar','Mobile','High','Open','Army convoy','Military','None',5,6,8,10,1,'NA','NA',15.815,60.467,~
5-Dec-2008,'8 Thw al-Hijjah 1429 A.H','Working Day',Null,12:30:00,'Orakzai Agency',32.9746,70.1456,'KPK','bazar of Kalaia area of lower Orakzai angency','Market','Low','Open',Null,'Civilian','None',6,10,8,15,1,'NA','Kalidya Hospital',12.465,54.437,~
9-Dec-2008,'11 Thw al-Hijjah 1429 A.H','Working Day',Null,'NA','Buner',34.3943,72.6151,'KPK','in Dagar-an area of Buner','Park/Ground','Low','Open',Null,'Government Official','None',Null,1,Null,4,1,'NA','NA',14.39,57.902,~
28-Dec-2008,Null,'Holiday','Weekend',10:30:00,'Buner',34.3943,72.6151,'KPK','Buner Poling station-Infront of govt high school Shalbandi','Government','High','Open',Null,'Government official','None',34,37,Null,16,Null,Null,Null,11.41,52.538,~
4-Jan-2009,'7 MuHarram 1430 A.H','Holiday','Weekend',19:30:00,'D.I Khan',31.8238,70.9095,'KPK','multan road in Deara Ismail Khan','Mobile','High','Open','muharram ul haram rally','Police',Null,7,10,21,25,1,'10 kg','Poly clinic multan',11.445,52.601,~
4-Jan-2009,'7 MuHarram 1430 A.H','Holiday','Weekend',Null,'Bannu',32.9861,70.6042,'KPK','near a check-post in Officers Colony','Police','High','open',Null,'Police',Null,Null,1,Null,2,1,Null,Null,8.275,46.895,~
23-Jan-2009,'26 MuHarram 1430 A.H.','Working Day',Null,Null,'Swat',35.3833,72.1833,'KPK','near Mingora town','Military','High','open',Null,'Military',Null,Null,2,11,25,1,Null,Null,12.95,55.31,~
5-Feb-2009,'10 safar 1430 A.H.','Working Day',Null,'6.35 pm','D.G Khan',30.05,70.6333,'Punjab','Outside Jhar ali Imambargah-in muslim town area','Religious','Medium','Open',Null,'Religious','Shiite',30,32,48,55,1,'NA','Local Hospital In DG Khan/Nishtar Hospital',15.105,59.189,~
5-Feb-2009,'10 safar 1430 A.H.','Working Day',Null,Null,'Swat',35.3833,72.1833,'KPK','near a Police station in the Mingora town of Swat District','Police','High','open',Null,'Police',Null,Null,12,Null,Null,Null,Null,Null,9.435,48.983,~
6-Feb-2009,'11 safar 1430 A.H','Working Day',Null,'8.15 am','Khyber Agency',34.0211,71.2874,'FATA','Peshawar-Torkham Highway near Teddi Bazar in Jamrood','Mobile','Low','Open','struck the trailer when signalled to stop','Foreigner','Christian',Null,0,Null,7,1,'NA','Jamrud Civil Hospital',10.32,50.576,~
9-Feb-2009,'14 safar 1430 A.H','Working Day',Null,'NA','Bannu',32.9861,70.6042,'KPK','Police checkpost on Baran Bridge','Police','High','Open','NA','Police','None',Null,5,17,18,1,'NA','DHQ Hospital Bannu / Peshawar Hospital',14.585,58.253,~
20-Feb-2009,'25 safar 1430 A.H','Working Day',Null,Null,'D.I Khan',31.8238,70.9095,'KPK','funeral procession on Dera Bannu road-near shobra hotel','Park/Ground','Low','Open','Funeral Procession of~
Imambargah Caretaker','Civilian','Shiite',30,36,150,200,1,'NA','1. DHQ D.I.Khan~
2. Nishtar Hospital~
3. Lady Reading Pesh',15.555,59.999,~
21-Feb-2009,'26 safar 1430 A.H','Working Day',Null,Null,'Bannu',32.9861,70.6042,'KPK','Lakki town','Police','High','Open','NA','Police','None',Null,2,Null,Null,Null,Null,Null,14.42,57.956,~
23-Feb-2009,'28 safar 1430 A.H.','Working Day',Null,'NA','Bannu',32.9861,70.6042,'KPK','Bannu miranshah road-House of DSP','Residence','Medium','Closed',Null,'Police','None',Null,1,Null,2,Null,'NA','NA',15.7,60.26,~
2-Mar-2009,'5 Raby` al-awal 1430 A.H','Working Day',Null,'NA','Pishin',30.5833,67,'Baluchistan','Killi Karbala village in Pishin district','Educational','Low','Closed',Null,'Government Official','Sunni',5,6,5,12,1,'NA','Civil hospital Quetta',18.76,65.768,~
11-Mar-2009,'14 Raby` al-awal 1430 A.H','Working Day',Null,'NA','Peshawar',34.0043,71.5448,'KPK','sarki gate area in Nimak Mandi area-Peshawar','Market','Low','Open','Inauguration of an ~
event by Sr Minister','Government Official','None',4,5,Null,6,1,'NA','Lady Reading Hospital',18.375,65.075,~
16-Mar-2009,'19 Raby` al-awal 1430 A.H','Working Day',Null,Null,'Rawalpindi',33.6058,73.0437,'Punjab','Rawalpindi cantt-Pirwadhi bus stand','Transport','Low','Open',Null,'Civilian','None',12,15,16,18,1,'10 kg','DHQ Hospital RWP~
2. Benazir Hospital RWP',20.875,69.575,~
23-Mar-2009,'26 Raby` al-awal 1430 A.H','Holiday','Pakistan Day','NA','Islamabad',33.718,73.0718,'Capital','sitara maket-special branch police gate','Police','High','Open',Null,'Police','None',Null,2,Null,8,1,'NA','NA',18.575,65.435,~
26-Mar-2009,'29 Raby` al-awal 1430 A.H','Working Day',Null,08:30:00,'Tank',32.226,70.3761,'KPK','road side restaurant opposite to military base in Jandola','Market','Low','Open','members of peace committe -members of Turkestan group','Anti-Militants','Sunni',7,15,Null,25,1,'NA','Civil Hospital Tank',14.305,57.749,~
27-Mar-2009,'30 Raby` al-awal 1430 A.H','Working Day',Null,'NA','Khyber Agency',34.0211,71.2874,'FATA','Mosque in Jamrood Tehsil on peshawar-turkham highway','Religious','Medium','Closed',Null,'Religious','Sunni',70,76,100,175,1,'NA','Peshwar Hospitals',18.595,65.471,~
30-Mar-2009,'3 Raby` al-THaany 1430 A.H','Working Day',Null,'NA','North waziristan',32.9746,70.1456,'FATA','Mirzail checkpost-Miranshah','Mobile','High','Open','security forces convoy was passing from checkpost','Military','None',Null,4,Null,9,1,'NA','NA',14.415,57.947,~
4-Apr-2009,'8 Raby` al-THaany 1430 A.H','Working Day',Null,'7.35 PM/7:37 PM','Islamabad',33.718,73.0718,'Capital','Margala Road Check Post~
Islamabad','Military','High','Open','NA','Military','None',Null,8,4,7,1,'8Kg','PIMS~
Polyclinic ',20.17,68.306,~
4-Apr-2009,'8 Raby` al-THaany 1430 A.H','Working Day',Null,Null,'North waziristan',32.9746,70.1456,'FATA','mirnshah security checkpost','Mobile','High','Open','military convoy was passing from checkpost','Military','None',Null,8,Null,39,1,'NA','NA',15.57,60.026,~
5-Apr-2009,'9 Raby` al-THaany 1430 A.H','Holiday','Weekend',12:30:00,'Chakwal',32.9303,72.8556,'Punjab','Imambargah in Chakwal','Religious','Medium','Closed','Shia Religious Gathering','Religious','Shiite',22,27,40,60,1,'NA','NA',20.555,68.999,~
15-Apr-2009,'19 Raby` al-THaany 1430 A.H','Working Day',Null,'Evening','Charsadda',34.1509,71.7359,'KPK','Harichand Police Post-~
Charsadda','Police','High','Open','NA','Police','None',16,18,5,10,1,'100kg','Charsadda DHQ/Tangi Hospital/JamalAbad hospital/Peshawar Hospital',Null,Null,~
18-Apr-2009,'22 Raby` al-THaany 1430 A.H','Working Day',Null,'3pm/4.15 pm','Hangu',33.5351,71.0713,'KPK','Check Post close to police station in Doaba Area','Police','High','Open','NA','Police','None',21,27,26,65,1,100,'Civil Hospital Hangu/ CMH Thall',21.175,70.115,~
5-May-2009,'10 Jumaada al-awal 1430 A.H.','Working Day',Null,'MORNING','Peshawar',34.0043,71.5448,'KPK','bara qadeem Check post-on peshawar-bara road-12km west of peshawar cantt','Military','High','Open','NA','Military','None',7,11,25,48,1,85,'Khyber Teaching Hospital / Hayatabad Medical Complex',18.615,65.507,~
11-May-2009,'16 Jumaada al-awal 1430 A.H','Working Day',Null,09:30:00,'Dara Adam Khel',33.6854,71.5131,'KPK','check post in the Outstrikes of Darra Adamkhel-in area of Sabeena police station','Police','High','Open','NA','Police','None',10,11,20,27,1,'NA','1. Lady Reading Hospital Pesh~
2. CMH Peshwar',25.66,78.188,~
21-May-2009,'26 Jumaada al-awal 1430 A.H','Working Day',Null,'Late Night/Evening','Tank',32.226,70.3761,'KPK','FC fort in Jandola','Military','High','Open','FC camp','Military','None',6,9,25,36,1,'NA','CMH Dera/ Tank Hospitals',21.54,70.772,~
27-May-2009,'3 Jumaada al-THaany 1430 A.H','Working Day',Null,'10.10 AM/10:30 AM','Lahore',31.5451,74.3407,'Punjab','hit police checkpost outside Rescue 15 Office and country''s premier intelligence agency','Police','High','Open','NA','Police','None',26,27,320,370,1,'125 kg','Ganga Ram hospital / Meo/ Services Hospital',33.275,91.895,~
28-May-2009,'4 Jumaada al-THaany 1430 A.H','Working Day',Null,17:40:00,'Peshawar',34.0043,71.5448,'KPK','Kohat Road-Sira Khora-~
Police Check Post ','Police','High','Open','NA','Police','None',3,5,3,9,1,'5kg','Lady Reading Hospital ~
Peshawar ',34.19,93.542,~
28-May-2009,'4 Jumaada al-THaany 1430 A.H','Working Day',Null,Null,'D.I Khan',31.8238,70.9095,'KPK','checkpost on circular road','Police','High','Open','NA','Police','None',3,5,8,12,1,160,'NA',29.085,84.353,~
5-Jun-2009,'12 Jumaada al-THaany 1430 A.H','Working Day',Null,'Jummah prayer time','Upper Dir',35.1977,71.8749,'FATA','Masjid in Hayagai Sharqai village','Religious','Medium','Closed','NA','Religious','Sunni',Null,40,50,70,1,'NA','NA',23.36,74.048,~
6-Jun-2009,'13 Jumaada al-THaany 1430 A.H','Working Day',Null,20:35:00,'Islamabad',33.718,73.0718,'Capital','Rescue 15 building in Islamabad','Police','High','Closed','Senior Police Officials meeting','Police','None',2,2,4,5,1,'NA','PIMS',26.235,79.223,~
9-Jun-2009,'16 Jumaada al-THaany 1430 A.H','Working Day',Null,'10.30 pm','Peshawar',34.0043,71.5448,'KPK','Pearl Continental Hotel~
Peshawar','Hotel','Medium','Closed','NA','Foreigner','None',11,15,50,80,1,'500 Kg','Lady Reading Hospital ~
Peshawar ',29.325,84.785,~
11-Jun-2009,'18 Jumaada al-THaany 1430 A.H','Working Day',Null,'Thursday night','Peshawar',34.0043,71.5448,'KPK','ring road Latifabad-Peshawar','Police','High','Open','NA','Police','None',1,2,8,15,1,'NA','LRH',30.935,87.683,~
12-Jun-2009,'19 Jumaada al-THaany 1430 A.H','Working Day',Null,'After Friday prayers','Lahore',31.5451,74.3407,'Punjab','Jamia Naeemia madrassa-Garhai Shahu area','Religious','Medium','Closed',Null,'Religious','Sunni',5,7,5,12,1,'24Kg','Mayo-Sir Ganga Ram Servuces-Jinnah Hospital',35.985,96.773,~
12-Jun-2009,'19 Jumaada al-THaany 1430 A.H','Working Day',Null,'2.40 Pm','Nowshehra',34.0322,73.0944,'KPK','military run Mosque in Nowshera Cantt-on supply depot morr','Religious','Medium','Closed',Null,'Religious','Sunni',4,7,63,105,1,'NA','contonment hospital-DHQ Hospital-peshawar CMH',29.2,84.56,~
22-Jun-2009,'29 Jumaada al-THaany 1430 A.H.','Working Day',Null,Null,'Swat',35.3833,72.1833,'KPK','Thakot Police check-post in Battagram District.','Police','High','Open','NA','Police','None',Null,2,Null,7,Null,Null,Null,27.665,81.797,~
26-Jun-2009,'3 Rajab 1430 A.H','Working Day',Null,'6:00:00 AM/6:30:00 AM','Muzaffarabad',34.3597,73.4711,'AJK','near non commisioned officers place-Muzaffarabad','Mobile','High','Open','NA','Military','None',Null,2,3,4,1,'NA','CMH Muzzafarabad',33.255,91.859,~
30-Jun-2009,'7 Rajab 1430 A.H.','Working Day',Null,'NA','Khyber Agency',34.0211,71.2874,'FATA','Quetta-Khi RCD highway-town of Torkham','Foreign','High','Open','blew himself up while being searched at the pak-afghna checkpost','foreigner','Sunni',1,4,10,11,1,'NA','NA',31.26,88.268,~
1-Jul-2009,'8 Rajab 1430 A.H.','Working Day',Null,'NA','Peshawar',34.0043,71.5448,'KPK','Mashokhel Mera Area-Kohat Road','Mobile','High','Open',Null,'Unknown','None',Null,1,Null,Null,1,'NA','NA',30.385,86.693,~
2-Jul-2009,'9 Rajab 1430 A.H.','Working Day',Null,16:30:00,'Rawalpindi',33.6058,73.0437,'Punjab','KRL Bas at Chur Chowk~
on peshawar road-rwp cantt','Mobile','High','Open','NA','Government official','None',Null,1,25,40,1,'10Kg','NA',27.29,81.122,~
8-Jul-2009,'15 Rajab 1430 A.H','Working Day',Null,03:00:00,'Peshawar',34.0043,71.5448,'KPK','nasir bagh road choongi bazar near police colony','Market','Low','Open','NA','Police','None',Null,1,2,5,1,'20 Kg','NA',34.825,94.685,~
28-Jul-2009,'6 SHa`baan 1430 A.H','Working Day',Null,'NA','North Waziristan',32.9746,70.1456,'KPK','Dirdony post on ghulam khan road-Near Miranshah','Police','High','Open','NA','Police','None',Null,2,3,5,1,'NA','NA',27.485,81.473,~
13-Aug-2009,'22 SHa`baan 1430 A.H','Working Day',Null,'NA','South Waziristan',32.3202,69.8597,'FATA','wana bazar','Mobile','Low','Open','leader of Nawaz group-a group against taliban','Anti-Militants','Sunni',4,5,Null,Null,1,'NA','NA',26.925,80.465,~
15-Aug-2009,'24 SHa`baan 1430 A.H','Working Day',Null,10:00:00,'Swat',35.2227,72.4258,'KPK','Check post in Khawazakhela- Char Bagh road near-waliabad village','Police','High','Open','NA','Police','None',3,5,Null,4,1,'NA','Saidu Sharif hospital',32.845,91.121,~
16-Aug-2009,'25 SHa`baan 1430 A.H','Holiday','Weekend','NA','swat',35.2227,72.4258,'KPK','security forces check point','Police','High','Open','NA','Police','None',Null,1,Null,3,1,'NA','NA',29.985,85.973,~
18-Aug-2009,'27 SHa`baan 1430 A.H.','Working Day',Null,19:00:00,'North Waziristan',32.9746,70.1456,'KPK','Esha check post on bannu-miranshah road','Military','High','Open','NA','Military','None',3,7,Null,3,1,'NA','NA',24.65,76.37,~
21-Aug-2009,'30 SHa`baan 1430 A.H','Working Day',Null,'NA','Kohat',33.5833,71.4333,'KPK','BB Pakdaman Street','Civilian',Null,'Open','NA','Civilian','None',Null,0,Null,Null,1,'NA','NA',29.035,84.263,~
22-Aug-2009,'1 RamaDHaan 1430 A.H.','Working Day',Null,17:00:00,'Swat',35.2227,72.4258,'KPK','kanju area of Kabal tehsil','Residence','Low','Closed','police raid in the area','Police','None',2,3,2,8,1,'NA','NA',26.025,78.845,~
23-Aug-2009,'2 RamaDHaan 1430 A.H.','Holiday','Weekend',Null,'Peshawar',34.0043,71.5448,'KPK','Momin Town','Residence','Low','open','Fateh Khawani of Haji Mobin Afridi','Anti-Militants','Sunni',Null,3,Null,15,1,'12Kg','Lady Reading Hospital',29.92,85.856,~
27-Aug-2009,'6 RamaDHaan 1430 A.H','Working Day',Null,'aftar time','Khyber Agency',34.0211,71.2874,'FATA','security post near Torkham border','Military','High','Open','NA','Military','None',20,22,10,27,1,'NA','Landi Kotal Hospital',30.08,86.144,~
30-Aug-2009,'9 RamaDHaan 1430 A.H','Holiday','Weekend','NA','Swat',35.2227,72.4258,'KPK','police training center in Mingora','Police','High','Closed','NA','Police','None',16,18,4,14,1,'12 Kg','Saidu Sharif hospital',29.155,84.479,~
12-Sep-2009,'22 RamaDHaan 1430 A.H','Working Day',Null,'5 min befor aftar','Hangu',33.5351,71.0713,'KPK','Doaba police station','Police','High','Closed','NA','Police','None',Null,Null,2,4,1,'NA','NA',26.635,79.943,~
13-Sep-2009,'23 RamaDHaan 1430 A.H','Holiday','Weekend',Null,'Malakand',34.503,71.9046,'KPK','checkpost in Thana area-near batkhela','Military','High','Open',Null,'Military','None',Null,1,3,5,2,'NA','NA',28.31,82.958,~
18-Sep-2009,'28 RamaDHaan 1430 A.H','Working Day',Null,10:00:00,'Kohat',33.5833,71.4333,'KPK','Kacha pakha bazar-in Astarzai union council area','Market','Low','Open','NA','Civilian','None',30,37,50,60,1,'150 kg','NA',29.19,84.542,~
19-Sep-2009,'29 RamaDHaan 1430 A.H','Working Day',Null,'Saturday Evening','Dara Adam Khel',33.6854,71.5131,'KPK','Security Check~
Post in zorkalay area','Police','High','Open','NA','Police','None',Null,2,Null,1,1,'NA','NA',29.865,85.757,~
21-Sep-2009,'2 SHawwal 1430 A.H.','Working Day',Null,'After Midnight','Totalai',34.2,72.5,'KPK','Tatalai District','Educational','Low','Closed',Null,'Government Official','None',Null,0,Null,Null,1,'NA','NA',26.855,80.339,~
26-Sep-2009,'7 SHawwal 1430 A.H','Working Day',Null,'7.00 am','Bannu',32.9861,70.6042,'KPK','outside Police Station in mundan area-Bannu','Police','High','Open','NA','Police','None',7,10,50,65,1,'180Kg','N/A',26.375,79.475,~
26-Sep-2009,'7 SHawwal 1430 A.H','Working Day',Null,'11.35 am','Peshawar',34.0043,71.5448,'KPK','Fakhar e Alam Road-~
Saddar-infront of Askari bank','Bank','Low','Open','NA','Civilian','None',10,14,50,120,1,'100 Kg','1. Lady Reading Hospital Pesh~
2. CMH Peshwar',31.075,87.935,~
28-Sep-2009,'9 SHawwal 1430 A.H','Working Day',Null,'Monday Morning','bannu',32.935,70.6688,'KPK','Bakakhel','Mobile','Low','Open','molvi abdul hakeem as goin to attend jirga-anti-talibanic cleric','Anti-Militants','Sunni',4,5,Null,Null,1,'NA','NA',24.33,75.794,~
5-Oct-2009,'16 SHawwal 1430 A.H','Working Day',Null,'12.15 pm','Islamabad',33.718,73.0718,'Capital','WFP office in islamabad F-8/3','Foreigner','High','Closed','NA','foreigner','Christian',Null,5,3,8,1,'8Kg','NA',24.935,76.883,~
9-Oct-2009,'20 SHawwal 1430 A.H','Working Day',Null,'12.15 PM','Peshawar',34.0043,71.5448,'KPK','Khayber Bazar-Peshawar','Market','Low','Open','NA','Civilian','None',48,50,148,187,1,'100Kg','Lady Reading Hospital ~
Peshawar ',25.75,78.35,~
12-Oct-2009,'23 SHawwal 1430 A.H','Working Day',Null,13:00:00,'Shangla',34.8015,72.757,'KPK','near police station in Alpuri area of shangla District','Mobile','High','Open','military convoy','Military','None',Null,41,45,50,1,'NA','Alpuri Hospital',22.04,71.672,~
15-Oct-2009,'26 SHawwal 1430 A.H','Working Day',Null,08:00:00,'Kohat',33.5833,71.4333,'KPK','Kohat Police Station','Police','High','Closed','NA','Police','None',11,12,20,24,1,'100 Kg','Kohat Hospital',23.25,73.85,~
15-Oct-2009,'26 SHawwal 1430 A.H','Working Day',Null,'NA','Lahore',31.5451,74.3407,'Punjab','FIA Headquarter-Manawan Police training school-elite training school','Police','High','Closed','N/A','Police','None',Null,18,Null,50,'N/A','NA','N/A',25.22,77.396,~
16-Oct-2009,'27 SHawwal 1430 A.H','Working Day',Null,14:45:00,'Peshawar',34.0043,71.5448,'KPK','crimes investigation agency (CIA) in Swati gate-near peshawar cantt','Military','High','Closed','NA','Military','None',14,15,15,24,1,'70 kg','Lady Reading Hospital ~
Peshawar ',23.265,73.877,~
20-Oct-2009,'1 Thw al-Qi`dah 1430 A.H','Working Day',Null,14:10:00,'Islamabad',33.718,73.0718,'Capital','Islamic International University~
Islamabad ','Educational','Low','Closed','NA','Civilian','None',5,6,29,40,2,'16 Kg','NA',21.895,71.411,~
23-Oct-2009,'4 Thw al-Qi`dah 1430 A.H','Working Day',Null,'7.10 am','Attock',33.7645,72.3667,'Punjab','Kamra chowk-Aeronautical Complex~
Security Check Post','Military','High','Open','NA','Military','None',8,9,13,17,1,'NA','Govt Hospital Kamra',20.865,69.557,~
24-Oct-2009,'5 Thw al-Qi`dah 1430 A.H','Working Day',Null,'late night','Chakwal',32.9303,72.8556,'Punjab','checkpost between kalarkahar and lilla interchange-lahore to isb motorway-','Police','High','Open',Null,'police','None',Null,1,Null,Null,1,'NA','NA',20.485,68.873,~
2-Nov-2009,'14 Thw al-Qi`dah 1430 A.H','Working Day',Null,'10.40 AM','Rawalpindi',33.6058,73.0437,'Punjab','Outside National Bank~
Rawalpindi Cantt','Bank','Low','Open','NA','Civilian','None',35,38,60,65,1,'15Kg','CMH-Distric headquarter hospital-militry hospital-combined military hospital',20.755,69.359,~
2-Nov-2009,'14 Thw al-Qi`dah 1430 A.H','Working Day',Null,18:40:00,'Lahore',31.5451,74.3407,'Punjab','Checkpost at Babu Sabu Interchange~
on Lahore Islamabad Motorway','Police','High','Open','NA','Police','None',Null,Null,10,25,1,'10Kg','mian munchi hospital-mayo hospital',21.02,69.836,~
8-Nov-2009,'20 Thw al-Qi`dah 1430 A.H','Holiday','Weekend','9.30 AM','Peshawar',34.0043,71.5448,'KPK','Cattle Market in Adezai~
Village in Peshawar','Market','Low','Open','NA','Government Official','None',12,19,35,45,1,'10 Kg','Lady Reading Hospital ~
Peshawar ',14.74,58.532,~
9-Nov-2009,'21 Thw al-Qi`dah 1430 A.H','Holiday','Iqbal Day','9.45 AM','Peshawar',34.0043,71.5448,'KPK','police check post near busy intersection that connects charsadda road and ring road-Faqirabad','Police','High','Open','NA','Police','None',Null,3,5,7,1,'7Kg','NA',15.475,59.855,~
10-Nov-2009,'22 Thw al-Qi`dah 1430 A.H','Working Day',Null,16:30:00,'Charsadda',34.1509,71.7359,'KPK','ghafoor market in charsadda bazar-tangi road Farooq e Azam Chowk','Market','Low','Open','NA','Civilian','None',32,34,60,100,1,'60Kg','Lady Reading Hospital ~
Peshawar ',15.49,59.882,~
13-Nov-2009,'25 Thw al-Qi`dah 1430 A.H','Working Day',Null,'6.45 AM','Peshawar',34.0043,71.5448,'KPK','Military Check point at the entrance of regional HQ ISI','Military','High','Open','NA','Military','None',10,13,47,70,1,'400Kg','Lady Reading Hospital-combined military hospital-khyber teaching hospital-~
Peshawar ',17.425,63.365,~
13-Nov-2009,'25 Thw al-Qi`dah 1430 A.H','Working Day',Null,'7.15 am','Bannu',32.9861,70.6042,'KPK','Bakakhel police station on bannu-miranshah road','Police','High','Closed','NA','Police','None',7,8,22,29,1,'200Kg','NA',10.7,51.26,~
14-Nov-2009,'26 Thw al-Qi`dah 1430 A.H','Working Day',Null,16:15:00,'Peshawar',34.0043,71.5448,'KPK','police check post on Pishtakhara Intersection','Police','High','Open','NA','Police','None',Null,12,25,35,1,'50-60Kg','1. LRH Peshawar~
2. Khyber Teaching~
3. Hayatabad Medical ',17.01,62.618,~
16-Nov-2009,'28 Thw al-Qi`dah 1430 A.H','Working Day',Null,'NA','Peshawar',34.0043,71.5448,'KPK','check point outside Badbher-police station','Police','High','Open','N/A','Police','None',Null,3,Null,43,1,'250Kg','LRH',14.65,58.37,~
19-Nov-2009,'2 Thw al-Hijjah 1430 A.H','Working Day',Null,'10.20 am','Peshawar',34.0043,71.5448,'KPK','Main Gate of the Judicial~
Complex on Khyber Road','Government','High','Open','NA','Government Official','None',20,22,46,50,1,'10 kg','Lady Reading Hospital ~
Peshawar ',15.72,60.296,~
1-Dec-2009,'14 Thw al-Hijjah 1430 A.H','Working Day',Null,'NA','Swat',35.2227,72.4258,'KPK','District Mangora-Tehsil Kabal~
-Dherai area','Residence','Medium','Closed',Null,'Government Official','None',1,2,11,30,1,'10 Kg','NA',13.83,56.894,~
2-Dec-2009,'15 Thw al-Hijjah 1430 A.H','Working Day',Null,13:30:00,'Islamabad',33.718,73.0718,'Capital','Naval Complex','Military','High','Open','NA','Military','None',Null,2,10,18,1,'12Kg','NA',15.595,60.071,~
4-Dec-2009,'17 Thw al-Hijjah 1430 A.H','Working Day',Null,'During Friday prayer','Rawalpindi',33.6058,73.0437,'Punjab','Qasim market-Parade Lane Masjid','Religious','Medium','Closed',Null,'Military','None',36,40,75,83,1,'NA','1. CMH Rawalpindi~
2. DHQ Rawalpindi~
3. AFIC 4.MH',16.04,60.872,~
7-Dec-2009,'20 Thw al-Hijjah 1430 A.H','Working Day',Null,12:30:00,'Peshawar',34.0043,71.5448,'KPK','At the Gate of Peshawar~
Session Court','Government','High','Open','NA','Government official','None',9,11,37,50,1,'8Kg','Lady Reading Hospital ~
Peshawar ',13.765,56.777,~
7-Dec-2009,'21 Thw al-Hijjah 1430 A.H','Working Day',Null,'8.42 pm','Lahore',31.5451,74.3407,'Punjab','Moon Market Lahore Allama Iqbal Town','Market','Low','Open','NA','Civilian','None',38,45,100,135,2,'NA','1. Jinnah Hospital~
2. Sheikh Zahyad Hospital~
3. Mayo Hospital 4.services hospital-5.farooq hospital',13.12,55.616,~
8-Dec-2009,'21 Thw al-Hijjah 1430 A.H','Working Day',Null,'12.10 PM','Multan',30.1886,71.4559,'Punjab','checkpost near ISI Office building in Qasim Bala area -Multan Cantt','Military','High','Open','NA','Military','None',8,15,47,61,1,'1000 Kg','1. CMH~
2. Nishtar Hospital ',14.84,58.712,~
15-Dec-2009,'28 Thw al-Hijjah 1430 A.H','Working Day',Null,'2.30 pm','D.G Khan',30.05,70.6333,'KPK','Khosa market near-house of Zulfiqar ali Khosa','Residence','Medium','Open','NA','Government Official','None',24,33,55,70,1,'1000 KG','district headquarters hospitals',16.34,61.412,~
17-Dec-2009,'30 Thw al-Hijjah 1430 A.H','Working Day',Null,Null,'Bannu',32.9861,70.6042,'KPK','Essakhel village-house of Local political leader','Residence','Medium','Closed',Null,'Government Official','None',Null,0,Null,0,1,'NA','NA',6.315,43.367,~
18-Dec-2009,'1 MuHarram 1431 A.H.','Working Day',Null,'1.30 pm','Lower Dir',34.8453,71.9046,'KPK','mosque on Khursheed police line- civil colony in Timergarah','Religious','Medium','Closed',Null,'Police','None',Null,12,28,35,1,'20 Kg','DHQ Timergara',10.69,51.242,~
22-Dec-2009,'5 MuHarram 1431 A.H','Working Day',Null,11:40:00,'Peshawar',34.0043,71.5448,'KPK','Main Gate Peshawar Press ~
Club','Office Building','Low','Closed','NA','Media','None',1,3,21,24,1,'10 kg','Lady Reading Hospital ~
Peshawar ',13.12,55.616,~
24-Dec-2009,'7 MuHarram 1431 A.H','Working Day',Null,'11.57 am','Peshawar',34.0043,71.5448,'KPK','junction of mall road and Arbab Road-near PIA Building','Police','High','Open','NA','Government Official','None',4,5,24,25,1,'10 Kg','Lady Reading Hospital ~
Peshawar ',13.48,56.264,~
24-Dec-2009,'7 MuHarram 1431 A.H','Working Day',Null,'10.18 pm','Islamabad',33.718,73.0718,'Capital','Majlis in Shakrial-near darbad saein boota','Religious','Medium','Open','Shia Religious Gathering','Religious','Shiite',Null,1,1,4,1,'NA','PIMS',12.7,54.86,~
28-Dec-2009,'11 MuHarram 1431 A.H','Holiday','Ashura','6.30 pm','Muzaffarabad',34.3597,73.4711,'AJK','CMH Road-Muzaffarabad','Park/Ground','Medium','Open','Muharram Procession','Religious','Shiite',10,15,81,100,1,'NA','NA',9.525,49.145,~
1-Jan-2010,'15 MuHarram 1431 A.H','Working Day',Null,17:00:00,'Lakki marwat',32.6018,70.9148,'KPK','Peshawar shah Hasankhel village ground','Park/Ground','Medium','Open',Null,'Civilian','None',88,100,37,100,1,'250 kg','Near local hospital',6.805,44.249,~
6-Jan-2010,'20 MuHarram 1431 A.H','Working Day',Null,06:50:00,'Sudhanoti',33.706,73.7242,'AJK','Military Base in tarar khal town sudhanoti district','Military','High','Open',Null,'Military','None',Null,4,11,12,1,'NA','CMH Rawala kot',11.39,52.502,~
8-Jan-2010,'22 MuHarram 1431 A.H','Working Day',Null,Null,'Khyber Agency',34.0211,71.2874,'KPK','at the gate of the headquarters of the militant group Ansar-ul-Islam in the Tirah area','Religious','low','Open','Ansar-ul-Islam (AI) Shura','Religious','None',Null,8,Null,11,1,'NA','NA',11.33,52.394,~
8-Jan-2010,'22 MuHarram 1431 A.H','Working Day',Null,Null,'peshawar',34.0043,71.5448,'KPK','Adezai village in Matni on the outskirts of Peshawar','Police','High','Open',Null,'Police','None',Null,0,Null,6,1,'NA','NA',12.075,53.735,~
16-Jan-2010,'30 MuHarram 1431 A.H','Working Day',Null,'10:00:00 AM/10:15 AM','Poonch',33.8243,73.7949,'AJK','Dothan village near rawlakot','Mobile','High','Open',Null,'Police','None',Null,1,1,2,1,'600 kg','CMH Rawala kot',12.41,54.338,~
23-Jan-2010,'8 safar 1431 A.H','Working Day',Null,'NA','Tank',32.226,70.3761,'KPK','gomal police station','Police','High','Open',Null,'Police','None',4,5,3,11,1,'NA','NA',6.015,42.827,~
29-Jan-2010,'14 safar 1431 A.H','Working Day',Null,'NA','Bajaur Agency',34.8718,71.5249,'FATA','Bajor agency headquarter (khar town) security check post','Military','High','Open',Null,'Military','None',16,17,26,47,1,'NA','District headquarter hospital Timra',6.905,44.429,~
10-Feb-2010,'26 safar 1431 A.H','Working Day',Null,'NA','Khyber Agency',34.0211,71.2874,'KPK','Jamrud tehsil Khyber agency','Mobile','High','Open',Null,'Military','None',17,22,6,11,1,'NA','1.Hayatabad Meical hospital',8.07,46.526,~
11-Feb-2010,'27 safar 1431 A.H','Working Day',Null,'Maghrib prayers','Bannu',32.9861,70.6042,'KPK','Bannu police Lines 2-','Police','High','Open',Null,'Police','None',Null,15,25,30,2,'NA','1.District Headquarter Hospital Bannu 2.Combined Military Hospital',2.32,36.176,~
18-Feb-2010,'4 Raby` al-awal 1431 A.H','Working Day',Null,'NA','Khyber Agency',34.0211,71.2874,'KPK','LI center near Darss Mosque in akakhel area of Tirah valley','Religious','Medium','Open','Lashkar-e-Islam Commander was the target','Anti-Militants','Sunni',22,31,30,110,1,'40Kg','Mashte hospital',11.835,53.303,~
20-Feb-2010,'6 Raby` al-awal 1431 A.H','Working Day',Null,09:30:00,'Mansehra',34.3333,73.2,'KPK','Balakot police station','Police','High','Open',Null,'Police','None',Null,1,4,10,2,'5Kg','1.Manseehra District Headquarters Hospital',13.74,56.732,~
22-Feb-2010,'8 Raby` al-awal 1431 A.H','Working Day',Null,04:20:00,'Swat',35.2227,72.4258,'KPK','Mingora-Nishat Chowk','Mobile','High','Open','attack on security forces vehicle','Military','None',7,13,37,41,1,'NA','1.CMH Hospital 2.Seydo Hospital',11.66,52.988,~
27-Feb-2010,'13 Raby` al-awal 1431 A.H','Holiday','Eid Milad un-Nabi','NA','Karak',33.1193,71.0951,'KPK','Karak Police Station','Police','High','Open',Null,'Police','None',Null,4,23,24,2,'250Kg','District Headquarter Hospital Karak',11.69,53.042,~
5-Mar-2010,'19 Raby` al-awal 1431 A.H','Working Day',Null,'NA','Hangu',33.5351,71.0713,'KPK','Tal parachinar road in the jurisdiction of dandore area of Hangu','Mobile','Low','Open',Null,'Civilian','Shiite',12,14,30,35,1,'12 kg','1.CMH Tal Hospital 2.District Headquarters hospital hangu',12.35,54.23,~
8-Mar-2010,'22 Raby` al-awal 1431 A.H','Working Day',Null,08:20:00,'Lahore',31.5451,74.3407,'Punjab','(SIA ) office-model Town area','Office Building','High','Open',Null,'Military','None',13,14,80,100,1,'600Kg','1.Jinna Hospital 2.General Hosptal 3.shaikh zayed Hospital 4.Ittefaq Hospital',20.46,68.828,~
12-Mar-2010,'26 Raby` al-awal 1431 A.H','Working Day',Null,12:45:00,'Lahore',31.5451,74.3407,'Punjab','Lahore Cant R.A Bazar Stop','Military','High','Open',Null,'Military','Sunni',43,57,90,100,2,'12 kg','Children Hospital',23.32,73.976,~
13-Mar-2010,'27 Raby` al-awal 1431 A.H','Working Day',Null,09:15:00,'Swat',35.2227,72.4258,'KPK','District court Checkpost','Police','High','Open',Null,'Police','None',14,17,52,60,1,'14 kg','1. Judical Complex',16.365,61.457,~
29-Mar-2010,'13 Raby` al-THaany 1431 A.H.','Working Day',Null,Null,'Tank',32.226,70.3761,'KPK','office of Pro-govt tribal leader-Misbahhuddin mehsud','Government/Office Building','Medium','Closed',Null,'Anti-Militants','Sunni',Null,2,Null,2,1,'NA',Null,16.64,61.952,~
29-Mar-2010,'13 Raby` al-THaany 1431 A.H.','Working Day',Null,Null,'Bajaur Agency',34.8718,71.5249,'FATA','Lagharai area in Bajaur','Mobile','Low','Open','Leader of anti-militants lashkar','Anti-Militants','Sunni',Null,2,5,8,1,'NA','Agency headquarter hospital in Khar',19.45,67.01,~
5-Apr-2010,'20 Raby` al-THaany 1431 A.H.','Working Day',Null,'NA','Peshawar',34.0043,71.5448,'KPK','U.S. consulate peshwar','Foreign','High','Open',Null,'foreigner','Christian',6,8,Null,0,1,'NA',Null,23.135,73.643,~
5-Apr-2010,'20 Raby` al-THaany 1431 A.H.','Working Day',Null,'12:00 noon','Lower Dir',34.8453,71.9046,'KPK','ANP rally in Timergara','Hotel','Medium','Open',Null,'Government Official','None',50,56,75,120,3,'NA','1.Lady Reading Hospital 2.Khaber Teaching Hospital',21.1,69.98,~
16-Apr-2010,'2 Jumaada al-awal 1431 A.H','Working Day',Null,Null,'Quetta',30.2095,67.0182,'Baluchistan','Quetta civil Hospital','Hospital','Low','Closed',Null,'Government Official','Shiite',Null,11,35,40,1,'15 kg','1.Civil Hospital 2.Bolan Medical Complex 3. CMH',25.14,77.252,~
17-Apr-2010,'3 Jumaada al-awal 1431 A.H','Working Day',Null,'12:00:00 PM/11:55 AM','Kohat',33.5833,71.4333,'KPK','IDP camp-kacha Pakha area on Hangu Road Kohat','Park/Ground','Low','Open',Null,'Civilian','None',41,44,60,70,2,'12 Kg','1.District Headquarter Hospital 2.Liaqat Hospital',28.745,83.741,~
18-Apr-2010,'4 Jumaada al-awal 1431 A.H','Holiday','Weekend',07:15:00,'Kohat',33.5833,71.4333,'KPK','Kohat Police Station','Police','High','Closed',Null,'Police','None',Null,7,30,32,1,'250 kg','District Headquarter Hospital',26.62,79.916,~
19-Apr-2010,'5 Jumaada al-awal 1431 A.H','Working Day',Null,12:30:00,'Peshawar',34.0043,71.5448,'KPK','Protest demonstration Qissa Khawani Bazaar','Park/Ground','Low','Open','Jamit-i-Islam members','Anti-Militants','Sunni',23,24,27,49,1,'8 kg','Lady Reading Hospital',25.96,78.728,~
28-Apr-2010,'14 Jumaada al-awal 1431 A.H','Working Day',Null,04:05:00,'Peshawar',34.0043,71.5448,'KPK','Pir Bala Police Check post','Police','High','Open',Null,'Police','None',4,5,11,14,1,'300 kg','Lady Reading Hospital',26.47,79.646,~
1-May-2010,'17 Jumaada al-awal 1431 A.H','Holiday','Labour Day','NA','Swat',35.2227,72.4258,'KPK','Sohrab Khan Market town Mingora','Market','Low','Open',Null,'Civilian','None',3,7,9,16,1,'15 kg','NA',23.315,73.967,~
2-May-2010,'18 Jumaada al-awal 1431 A.H','Holiday','Weekend','NA','Bajaur Agency',34.8718,71.5249,'FATA','Bilalabad area near Khar town','Military','High','Open',Null,'Military','None',Null,0,Null,0,1,'NA','NA',27.025,80.645,~
28-May-2010,'14 Jumaada al-THaany 1431 A.H','Working Day',Null,'NA','Lahore',31.5451,74.3407,'Punjab','Model Town and garhi shahu lahore','Religious','Medium','Closed',Null,'Civilian','Ahmedi',80,95,92,200,1,'NA','NA',31.495,88.691,~
1-Jul-2010,'19 Rajab 1431 A.H','Working Day',Null,'10:46:00 PM/11:00 PM','Lahore',31.5451,74.3407,'Punjab','Data Darbar-Lahore','Religious','Medium','Closed',Null,'Civilian','None',40,42,Null,175,2,'20 kg','1. Mayo Hospital~
2. Sir Ganga Ram Hospital ~
3. Services Hospital ',32.37,90.266,~
9-Jul-2010,'27 Rajab 1431 A.H','Working Day',Null,'NA','Mohmand Agency',32.9746,70.1456,'FATA','Yakka Ghund Tehsil~
of Mohmand Agency','Park/Ground','Low','Open',Null,'Government Official','None',65,80,104,110,2,'NA','Lady Reading Hospital Peshwar',26.725,80.105,~
12-Jul-2010,'30 Rajab 1431 A.H','Working Day',Null,'NA','Kohat',33.5833,71.4333,'KPK','outside the guest house of a pro-Government tribal elder-Malik Swab Khan-in Kohat District','Government','Low','Open',Null,'Government Official','None',Null,0,Null,0,1,'NA','NA',32.205,89.969,~
18-Jul-2010,'6 SHa`baan 1431 A.H','Holiday','Weekend','NA','Sargodha',32.0791,72.6718,'Punjab','Dar-ul-uloom muhamdia imambargh','Religious','Medium','Closed',Null,'Religious','Shiite',3,4,9,26,1,'NA','NA',34.805,94.649,~
26-Jul-2010,'14 SHa`baan 1431 A.H','Working Day',Null,'NA','Nowshehra',34.0322,73.0944,'KPK','Nowshera near~
Provincial Info Ministr house ','Residence','Medium','Closed',Null,'Government Official','Sunni',Null,8,23,25,1,'10 kg','Lady Reading Hospital Peshwar',31.52,88.736,~
4-Aug-2010,'23 SHa`baan 1431 A.H','Working Day',Null,'around 4:30 PM','Peshawar',34.0043,71.5448,'KPK','FC chowk near Dean''s trade center','Mobile','High','Open','NA','Military','None',3,4,11,14,1,'10Kg','NA',28.59,83.462,~
23-Aug-2010,'13 RamaDHaan 1431 A.H.','Working Day',Null,Null,'South waziristan',32.3202,69.8597,'FATA','Wana-mosque','Religious','Medium','Closed','Pro-Government cleric','Anti-Militants','Sunni',26,30,Null,40,1,'20Kg','NA',25.23,77.414,~
1-Sep-2010,'23 RamaDHaan 1431 A.H','Working Day',Null,'6:55pm/7:00pm/7:10pm','Lahore',31.5451,74.3407,'Punjab','1)First blast lower mal gate 2)Ghaznavi street urdu bazar 3) Bhati Chowk','Park/Ground','Low','Open','Yaum-e-Ali','Religious','Shiite',27,43,150,243,3,'NA','1)Mayo Hospital 2)Sir ganga Ram Hospital',31.97,89.546,~
3-Sep-2010,'24 RamaDHaan 1431 A.H.','Working Day',Null,'NA','Quetta',30.2095,67.0182,'Baluchistan','Mizan chowk Quetta','Park/Ground','Low','Open','Al-Quds Rally organized by Imamia stdents organization','Civilian','None',54,62,150,200,1,'15Kg','1.Combined Miltry Hospital 2.Civil Hospital',26.745,80.141,~
3-Sep-2010,'24 RamaDHaan 1431 A.H.','Working Day',Null,'NA','Mardan',34.1982,72.0444,'KPK','worship place of the Ahmedis in Muslimabad area','Religious','Medium','Closed',Null,'Religious','None',Null,1,Null,4,1,'NA','NA',27.875,82.175,~
6-Sep-2010,'27 RamaDHaan 1431 A.H','Holiday','Defence Day',07:05:00,'lakki marwat',32.6018,70.9148,'KPK','lakki marwat Police Station','Police','High','Closed',Null,'Police','None',15,19,34,57,1,'600 kg','1.Civil Hospital 2.DHQ Hospital',26.635,79.943,~
9-Sep-2010,'30 RamaDHaan 1431 A.H','Working Day',Null,12:30:00,'Quetta',30.2095,67.0182,'Baluchistan','Raily Housing Society~
Near Finance Minnister~
House Quetta','Residence','Medium','Open',Null,'Government Official','None',2,5,3,6,1,'15 kg','NA',25.8,78.44,~
7-Oct-2010,'28 SHawwal 1431 A.H','Working Day',Null,18:45:00,'Karachi',24.9918,66.9911,'Sindh','Shrine of Abdullah shah ghazi in Clifton','Religious','Medium','Closed','Attendess at shrine','Religious','Sunni',6,10,60,77,2,'6 kg','1. JPMC~
2. Civil Hospital KHI',30.45,86.81,~
18-Oct-2010,'10 Thw al-Qi`dah 1431 A.H','Working Day',Null,'NA','Lakki marwat',32.6018,70.9148,'KPK','jabukhel village','Park/Ground','Low','Open','police tried to stop the car but the driver exploded the car in residential area','civilian','None',Null,Null,5,14,1,'1200Kg',Null,20.785,69.413,~
1-Nov-2010,'24 Thw al-Qi`dah 1431 A.H','Working Day',Null,08:45:00,'Swabi',34.1335,72.4702,'KPK','District Shahmanoor Police Lines Swabi','Police','High','Open',Null,'Police','None',2,5,10,13,1,'12 kg','1.Judicial Complex',18.87,65.966,~
5-Nov-2010,'28 Thw al-Qi`dah 1431 A.H','Working Day',Null,13:30:00,'Dara Adam khel',33.6854,71.5131,'KPK','Dara Adam Khel Corwded Mosque','Religious','Medium','Closed',Null,'Religious','Sunni',61,76,70,132,1,'15Kg','1.District Headqurters Hospital 2.Lady reading hospital',20.1,68.18,~
11-Nov-2010,'5 Thw al-Hijjah 1431 A.H','Working Day',Null,20:10:00,'Karachi',24.9918,66.9911,'Sindh','Crime Investigation Department','Military','High','Closed',Null,'Military','None',16,20,100,140,1,'1000 Kg','NA',28.175,82.715,~
11-Nov-2010,'5 Thw al-Hijjah 1431 A.H','Working Day',Null,'NA','Poonch',33.8243,73.7949,'AJK','Rawalacot Security force vehicle','Mobile','Low','open',Null,'Military',Null,Null,0,Null,2,1,'NA','1.Zahid hospital',18.315,64.967,~
14-Nov-2010,'8 Thw al-Hijjah 1431 A.H','Holiday','Weekend','NA','South waziristan',32.3202,69.8597,'FATA','Shakai village','Market','Low','Open',Null,'Anti-Militants','Sunni',Null,1,Null,8,1,'NA','Wana hospital',7.985,46.373,~
30-Nov-2010,'24 Thw al-Hijjah 1431 A.H','Working Day',Null,08:45:00,'Bannu',32.935,70.6688,'KPK','near furniture market-Banu','Mobile','High','Open','police van crossing the chowk','Police','None',2,6,6,22,1,'12 kg','NA',9.975,49.955,~
6-Dec-2010,'30 Thw al-Hijjah 1431 A.H','Working Day',Null,14:00:00,'Mohmand Agency',32.9746,70.1456,'Fata','Mohmad Agency-Ghalani area-Political ~
Agent office ','Government','High','Closed',Null,'Government Official','None',40,50,60,100,2,'NA','1.Tehsil Headquarters Ghalani ~
2.Lady Reading ',5.08,41.144,~
7-Dec-2010,'1 MuHarram 1432 A.H','Working Day',Null,'NA','Quetta',30.2095,67.0182,'Baluchistan','railway level crossing sryab pattak','Transport','Low','Open','Minister Balochistan','Government Official','None',Null,Null,10,12,1,'NA','CMH',4.51,40.118,~
8-Dec-2010,'2 MuHarram 1432 A.H','Working Day',Null,13:00:00,'Kohat',33.5833,71.4333,'KPK','Kohat Bus stand','Transport','Low','Open',Null,'Civilian','None',18,20,Null,32,1,'10 kg','NA',12.205,53.969,~
10-Dec-2010,'4 MuHarram 1432 A.H','Working Day',Null,16:00:00,'Hangu',33.5351,71.0713,'KPK','Pass Killay area-under construction Private Hospital','Hospital','Low','Closed',Null,'civilian','None',10,17,16,30,1,'400 KG','Hospitals in Kohat Division',10.385,50.693,~
23-Dec-2010,'17 MuHarram 1432 A.H','Working Day',Null,'NA','Islamabad',33.718,73.0718,'Capital','Entrance to imambargah','Religious','Medium','Closed',Null,'religious','Sunni',Null,1,Null,2,1,'NA','NA',11.73,53.114,~
24-Dec-2010,'18 MuHarram 1432 A.H','Working Day',Null,'NA','Peshawar',34.0043,71.5448,'KPK','Mall road peshawar','Police','High','Open','Police was not sure about the bmbers target','Civilian','None',Null,4,Null,24,1,'10 kg','lady Reading Hospital-CMH',10.845,51.521,~
25-Dec-2010,'19 MuHarram 1432 A.H','Holiday','Christmas/ birthday of Quaid-e-Azam','NA','Bajaur Agency',34.8718,71.5249,'FATA','WFP office Khar','Foreign','High','Closed','target was police checkpost','Police','None',42,47,80,105,1,'NA','NA',9.705,49.469,~
27-Dec-2010,'21 MuHarram 1432 A.H','Working Day',Null,'Evening','Muzaffarabad',34.3597,73.4711,'AJK','Procession from Neelam Valley','Park/Ground','Medium','Open',Null,'religious','Shiite',Null,7,Null,65,1,'NA','NA',9.24,48.632,~
12-Jan-2011,'8 safar 1432 A.H','Working Day',Null,'Evening','Bannu',32.935,70.6688,'KPK','Bannu Police Station','Religious','Medium','Closed',Null,'civilian','Sunni',18,20,15,20,1,'1000 kg','Bannu''s Main hospital',7.775,45.995,~
25-Jan-2011,'21 safar 1432 A.H','Working Day',Null,'Evening','Lahore',31.5451,74.3407,'Punjab','Urdu Bazar intersection on circular road','Police','High','Open','Hazrat Imam Hussain Chehlum Procession','Religious','Shiite',11,17,71,80,1,'5Kg','Mayo Hospital-ganagaram hospital',14.165,57.497,~
27-Jan-2011,'23 safar 1432 A.H','Working Day',Null,Null,'Bajaur Agency',34.8718,71.5249,'FATA','Sarameena area of Khar tehsil in the Bajaur Agency','Military','High','Open',Null,'Military','None',Null,0,Null,0,1,'NA','NA',10.395,50.711,~
31-Jan-2011,'27 safar 1432 A.H','Working Day',Null,'Morning','Peshawar',34.0043,71.5448,'KPK','Kohat road Garhi Kamruddin over head bridge','Mobile','High','Open','Police car','Police','None',5,7,14,16,1,'7Kg','NA',14.355,57.839,~
10-Feb-2011,'7 Raby` al-awal 1432 A.H','Working Day',Null,'8:00 AM/8:15:00 AM','Mardan',34.1982,72.0444,'KPK','Punjab Regiment Center','Military','High','Open',Null,'Military','None',28,36,35,50,1,'9Kg','CMH Mardan-CMH rawalpindi',11.06,51.908,~
11-Feb-2011,'8 Raby` al-awal 1432 A.H','Working Day',Null,Null,'Mohmand Agency',32.9746,70.1456,'Fata','Dabo Dheri checkpost in Prang Ghar','Police','High','Open',Null,'Police','None',Null,1,Null,3,1,'NA','NA',1.445,34.601,~
12-Feb-2011,'9 Raby` al-awal 1432 A.H','Working Day',Null,'Saturday Morning','Malakand',34.503,71.9046,'KPK','Batakhel area','Residence','Low','Closed','security forces were trying to arest the bomber','Military','None',1,3,Null,Null,1,'NA','NA',8.305,46.949,~
19-Feb-2011,'16 Raby` al-awal 1432 A.H','Working Day',Null,Null,'Bannu',32.935,70.6688,'KPK','police station in bannu','Police','High','Open',Null,'Police','None',Null,Null,Null,4,1,'NA','NA',5.45,41.81,~
1-Mar-2011,'26 Raby` al-awal 1432 A.H','Working Day',Null,'Night','Karachi',24.9918,66.9911,'Sindh','near MDA flats along national highway-in Shah Latif Town','Park/Ground','Low','Open',Null,'civilian','None',Null,0,Null,0,1,Null,'NA',23.53,74.354,~
3-Mar-2011,'28 Raby` al-awal 1432 A.H','Working Day',Null,Null,'Hangu',33.5351,71.0713,'KPK','spin khawri chowk','Mobile','Low','Open',Null,'Police','None',5,9,30,36,1,'400Kg','NA',9.565,49.217,~
9-Mar-2011,'4 Raby` al-THaany 1432 A.H','Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Adezai Village-sheikh Neka graveyard','Park/Ground','Low','Open',Null,'Anti-Militants','Sunni',37,43,Null,52,1,'16Kg','Lady Reading Hospital',18.605,65.489,~
24-Mar-2011,'19 Raby` al-THaany 1432 A.H','Working Day',Null,08:00:00,'Hangu',33.5351,71.0713,'KPK','Rescue 15 Building adjecent to police station in Thall','Police','High','Open',Null,'Police','None',5,8,25,30,1,'250kg','CMH Thall',22.185,71.933,~
30-Mar-2011,'25 Raby` al-THaany 1432 A.H','Working Day',Null,'10:45 AM/ 11:00 AM','Swabi',34.1335,72.4702,'KPK','Peshawar- Islamabad Motorway-Swabi Interchange','Police','High','Open',Null,'Government Official','None',10,13,12,23,1,'8Kg','Shahmansoor Hospital Complex/Swabi District Hospital/khunda Civil Hospital and LRH Peshawar',20.12,68.216,~
31-Mar-2011,'26 Raby` al-THaany 1432 A.H','Working Day',Null,12:45:00,'Charsadda',34.1509,71.7359,'KPK','Near DCO office-Nowshehra road','Park/Ground','Low','Open',Null,'Government Official','None',Null,12,20,42,1,Null,'Lady reading hospital',19.405,66.929,~
1-Apr-2011,'27 Raby` al-THaany 1432 A.H','Working Day',Null,Null,'Dara Adam khel',33.6854,71.5131,'KPK','near a mosque in Dara adam khel bazar-khalid market','Market','Low','Open','peace committee members were present in mosque','Anti-Militants','Sunni',Null,1,2,8,1,'8kg',Null,18.315,64.967,~
3-Apr-2011,'29 Raby` al-THaany 1432 A.H','Holiday','Weekend','around 5pm and second attack after 15min/5:16:00 PM and second attack after 25 min','D.G Khan',30.05,70.6333,'KPK','sakhi arwar shrine-40 km away from D.G Khan','Religious','Medium','Open','Urs ceremony','Religious','Sunni',42,50,100,114,2,Null,'sakhi sarwar civil hospital-dera district headquarters hospital',23.035,73.463,~
4-Apr-2011,'30 Raby` al-THaany 1432 A.H','Working Day',Null,'Monday After Noon','Lower Dir',34.8453,71.9046,'KPK','Bargain Car market in Munda area of Lower Dir District','Market','Low','Open',Null,'Anti-Militants','Sunni',7,9,22,30,1,'8Kg','Temargara Hospital',16.585,61.853,~
7-Apr-2011,'3 Jumaada al-awal 1432 A.H','Working Day',Null,07:50:00,'Quetta',30.2095,67.0182,'Baluchistan','Gulistan road-also known as police lines','Residence','Medium','Open',Null,'Police','None',Null,1,17,19,1,'180kg','Civil hospital-CMH',20.76,69.368,~
23-Apr-2011,'19 Jumaada al-awal 1432 A.H','Working Day',Null,Null,'Bajaur Agency',34.8718,71.5249,'FATA','Salarzai area-65 km northeast of khar','Mobile','Low','Open',Null,'Anti-Militants','Sunni',Null,5,5,8,1,Null,'Agency headquarter hospital in Miranshah',26.34,79.412,~
13-May-2011,Null,'Working Day',Null,06:00:00,'Charsadda',34.1509,71.7359,'KPK','FC headquarters in Shabqadar-30km from peshawar','Military','High','Open','FC personnel were gathered there','Military','None',82,95,128,140,2,'16-20kg','LRH',29.285,84.713,~
14-May-2011,Null,'Working Day',Null,'11:20:00 AM/ 11:00 AM','D.G Khan',30.05,70.6333,'KPK','MCB bank-Main bazar of Taunsa Sharif','Bank','Low','Open',Null,'civilian','None',Null,3,Null,9,1,Null,Null,33.87,92.966,~
25-May-2011,Null,'Working Day',Null,04:40:00,'Peshawar',34.0043,71.5448,'KPK','CID station','Police','High','Closed',Null,'Police','None',8,11,41,48,1,'300kg','Lady reading hospital-khyber teaching complex-hayatabad medical complex',33.975,93.155,~
26-May-2011,Null,'Working Day',Null,18:00:00,'Hangu',33.5351,71.0713,'KPK','checkpoint close to Hangu police station and hangu DPO office','Police','High','Open',Null,'Police','None',28,32,55,60,1,'450kg','hungu district headquarter hospital',27.53,81.554,~
28-May-2011,Null,'Working Day',Null,10:00:00,'Bajaur Agency',34.8718,71.5249,'FATA','Bajaur Agency''s salarzai village-near Afghan border','Market','Low','Open',Null,'Anti-Militants','Sunni',Null,8,Null,11,1,Null,'khar agency headquarter hospital',30.06,86.108,~
5-Jun-2011,Null,'Holiday','Weekend',20:45:00,'Nowshehra',34.0322,73.0944,'KPK','Army run Bakery on Mall road-Nowshehra cantt','Military','High','Closed',Null,'Military','None',18,19,28,45,1,'8Kg','Lady reading hospital',32.48,90.464,~
12-Jun-2011,Null,'Holiday','Weekend',23:45:00,'Peshawar',34.0043,71.5448,'KPK','Khyber super market-peshawar cantt','Market','Low','Open',Null,'Civilian','None',32,35,80,107,1,'10 Kg','Lady reading hospital',31.05,87.89,~
13-Jun-2011,Null,'Working Day',Null,15:00:00,'Islamabad',33.718,73.0718,'Capital','silk bank in I-8 markaz','Bank','Low','Open',Null,'Civilian','None',1,2,4,6,1,'7kg','PIMS-Shifa International hospital',32.085,89.753,~
25-Jun-2011,Null,'Working Day',Null,Null,'D.I Khan',31.8238,70.9095,'KPK','Kolache Town','Police','High','Closed',Null,'Police','None',Null,10,3,5,1,Null,Null,32.925,91.265,~
11-Jul-2011,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Bazar in Central Battagram','Market','Low','Open',Null,'Government Official','None',Null,7,25,26,1,Null,'Battagram District Headquarters hospital',31.545,88.781,~
21-Jul-2011,Null,'Working Day',Null,Null,'South waziristan',32.3202,69.8597,'FATA','South waziristan','Mobile','Low','Open',Null,'Foreigner','NA',Null,Null,Null,2,1,Null,'Jandola hospital',24.3,75.74,~
24-Jul-2011,Null,'Holiday','Weekend',Null,'South waziristan',32.3202,69.8597,'FATA','Security Checkpost in chak Malai Area','Military','High','Open',Null,'Military','NA',Null,1,Null,7,1,Null,Null,25.195,77.351,~
6-Aug-2011,Null,'Working Day',Null,Null,'Mohmand Agency',32.9746,70.1456,'Fata','Danish Kol Bazaar Pandyali','Market','Low','Open',Null,'Military','NA',Null,1,Null,0,1,Null,Null,24.745,76.541,~
11-Aug-2011,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Check post near lahori gate','Police','High','Open',Null,'Police','NA',0,2,Null,12,1,Null,Null,30.1,86.18,~
19-Aug-2011,Null,'Working Day',Null,'Friday prayer time','Khyber Agency',34.0211,71.2874,'KPK','Jamia Masjid Madina in Ghundi Area of Jamrud','Religious','Medium','Closed',Null,'Civilian','NA',47,60,70,130,1,Null,'Tehsil Headquarters hospital Jamrud-Hayatabad Medical complex-Khyber Teaching Hospital',30.6,87.08,~
31-Aug-2011,'5 SHawwal 1432 A.H.','Holiday','Eid-ul-Fitar','Wednesday Morning just after offering Eid prayers','Quetta',30.2095,67.0182,'Baluchistan','near the Eidgah in Marriabad Major Muhammad Ali Shaheed Road.','Religious','Medium','Open',Null,'religious','Shiite',11,13,12,25,1,'60kg','city hospitals',25.59,78.062,~
1-Sep-2011,'6 SHawwal 1432 A.H.','Holiday','Eid-ul-Fitar','Thursday night','Lakki marwat',32.6018,70.9148,'KPK','near a police station in Darra Pezu Town','Police','High','Open',Null,'Police','NA',3,2,14,25,1,'300kg','NA',20.84,69.512,~
7-Sep-2011,Null,'Working Day',Null,Null,'Quetta',30.2095,67.0182,'Baluchistan','FC DIG''s residence at Anscumb road','Military','High','Closed',Null,'Military','NA',26,28,60,82,2,'100kg','Civil hospital-CMH',28.465,83.237,~
15-Sep-2011,Null,'Working Day',Null,'After noon','Lower Dir',34.8453,71.9046,'KPK','Jandola Town in Lower Dir-100 km from swat valley','Park/Ground','Low','Open',Null,'Civilian','NA',26,34,63,75,1,'NA',Null,27.235,81.023,~
19-Sep-2011,Null,'Working Day',Null,07:30:00,'karachi',24.9918,66.9911,'Sindh','Street 32-off Saba Avenue-DHA Phase VIII-house of CID SSP','Police','High','Open',Null,'Police','NA',Null,8,4,7,1,'300kg',Null,29.195,84.551,~
28-Oct-2011,Null,'Working Day',Null,Null,'Nowshehra',34.0322,73.0944,'KPK','Risalpur area of the Nowshera district','Police',Null,Null,Null,'Police','NA',Null,2,Null,Null,1,Null,Null,17.535,63.563,~
7-Nov-2011,Null,'Working Day',Null,Null,'Swabi',34.1335,72.4702,'KPK','Malikabad area of Swabi','Government Official',Null,Null,Null,'Government Official',Null,Null,3,Null,9,Null,Null,Null,19.065,66.317,~
16-Nov-2011,Null,'Working Day',Null,Null,'Karachi',24.9918,66.9911,'Sindh','Sea view-clifton-at lover''s point adjacent to village hotel','Mobile','low','Open',Null,'Police','None',5,7,Null,1,1,'NA','Jinnah Postgraduate Medical Center',25.305,77.549,~
18-Nov-2011,Null,'Working Day',Null,03:38:00,'Karachi',24.9918,66.9911,'Sindh','Block 13-near Pehlwan Goth roundabout-Gulistan-e-Jauhar','Residence','low','Closed',Null,'Military','None',Null,1,Null,Null,1,'NA','Jinnah Postgraduate Medical Center',27.245,81.041,~
24-Dec-2011,Null,'Working Day',Null,'5:30 AM/5:40 AM','Bannu',32.935,70.6688,'KPK','Tochi Scouts headquarters in Bannu','Military','High','Open',Null,'Military','None',4,6,18,19,1,'500 kg','CMH Bannu',7.28,45.104,~
3-Jan-2012,Null,'Working Day',Null,13:00:00,'Gujrat',32.5737,74.0786,'Punjab','Gorali village-4 km from Gujrat','Park/Ground','Low','Open',Null,'Civilian','None',Null,2,Null,Null,1,'NA','NA',10.935,51.683,~
3-Jan-2012,Null,'Working Day',Null,14:00:00,'Peshawar',34.0043,71.5448,'KPK','trade center on arbab road in university town','Market','Low','Closed',Null,'Civilian','None',Null,2,19,28,1,'5-6kg','Khyber teaching Hospital',12.07,53.726,~
3-Jan-2012,Null,'Working Day',Null,14:15:00,'Khyber Agency',34.0211,71.2874,'FATA','landikotal town','Market','Low','open',Null,'Civilian','None',Null,3,7,9,1,'NA',Null,11.285,52.313,~
14-Jan-2012,Null,'Working Day',Null,14:00:00,'D.I Khan',31.8238,70.9095,'KPK','District police officer''s office','Police','High','Open',Null,'Police','None',4,8,7,10,3,'NA','District Headquarters Hospital',6.71,44.078,~
30-Jan-2012,Null,'Working Day',Null,16:00:00,'Peshawar',34.0043,71.5448,'KPK','Pakha Ghullam area','Residence','Low','Open',Null,'Anti-Militants','None',3,4,7,8,1,'3kg','Lady Reading Hospital',11.325,52.385,~
17-Feb-2012,Null,'Working Day',Null,14:00:00,'Kuram Agency',32.9746,70.1456,'FATA','Parachinar Outside Shia Mousque','Market','Low','Open',Null,'Civilian','Shiite',21,28,Null,36,1,'NA','Agency Headquarter Hospital',0.04,32.072,~
16-Feb-2012,Null,'Working Day',Null,Null,'Upper Dir',35.1977,71.8749,'FATA','Dir Town in Northwestren Districk of Upperdir near Afghan Boarder','Market','Low','Open',Null,'Civilian','None',1,1,3,3,1,'NA',Null,4.985,40.973,~
24-Feb-2012,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','C-Division Police Station (Kotwali police Stataion)','Police','High','Closed',Null,'Police','None',0,4,Null,6,3,'NA',Null,9.905,49.829,~
3-Mar-2012,Null,'Holiday','Weekend',Null,'Peshawar',34.0043,71.5448,'KPK','Shabqadar town 35KM northeast of Peshawar','Mobile','High','Open',Null,'Government Official','None',0,1,Null,6,1,'6kg','Lady Reading Hospital (LRH)',16.955,62.519,~
4-Mar-2012,Null,'Holiday','Weekend',Null,'D.I Khan',31.8238,70.9095,'KPK','Police patrol in main market area of D.I Khan KPK','Mobile','Low','Open',Null,'Police','None',Null,0,Null,3,1,'NA','District Headquarters Hospital',15.735,60.323,~
11-Mar-2012,Null,'Holiday','Weekend',Null,'Peshawar',34.0043,71.5448,'KPK','Badaber Area 15Km from Peshawer','Park/Ground','Low','Open',Null,'Government Official','None',14,15,30,33,1,'6Kg','Lady Reading Hospital (LRH)',13.33,55.994,~
15-Mar-2012,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Pishtakhara Square-Close to Bara-Khayber Aagency','Police','Low','Open',Null,'Police','None',1,1,2,5,1,'6kg','Hayatabad Medical Hospital-Khyber Teaching Hospital',15.75,60.35,~
23-Mar-2012,Null,'Working Day',Null,Null,'Khyber Agency',34.0211,71.2874,'KPK','Akkakhel area of Bara in Khyber Agency','Religious','Low','Open',Null,'Anti-Militants','None',5,13,9,10,1,'NA',Null,19.65,67.37,~
5-Apr-2012,Null,'Working Day',Null,19:56:00,'Karachi',24.9918,66.9911,'Sindh','Garision Area of Malir','Mobile','Low','Open',Null,'Police','None',4,7,12,14,1,'NA',Null,31.345,88.421,~
4-May-2012,Null,'Working Day',Null,07:45:00,'Bajaur Agency',34.8718,71.5249,'FATA','security checkpoint in the middle of Khar Bazaar','Market','Low','Open',Null,'Police','None',24,26,40,75,1,'N/A','Agency Headquarters Hospital (AHH)-Lady Reading Hospital (LRH)-',24.58,76.244,~
12-Jun-2012,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Bazidkhel Village-Badhaber Area','Mobile','Low','Open',Null,'Anti-Militants','None',2,3,Null,5,1,'8Kg','Lady Reading Hospital (LRH)',30.605,87.089,~
28-Jun-2012,Null,'Working Day',Null,Null,'Quetta',30.2095,67.0182,'Baluchistan','Hazar Ganji Area','Mobile','Low','Open',Null,'Religious','Shiite',13,14,20,30,1,'50kg','Civil hospital-Bolan Medical Complex-CMH',28.455,83.219,~
16-Jul-2012,Null,'Working Day',Null,09:30:00,'Bannu',32.935,70.6688,'KPK','Old City Police Station','Police','High','Closed',Null,'Police','None',2,7,2,8,1,'NA','District Hospital Bannu',24.555,76.199,~
3-Sep-2012,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Abdara Road','foreign','Low','Open',Null,'Foreigner','None',0,2,18,21,1,'100-110kg','Khyber Teaching Hospital-American Club',29.015,84.227,~
10-Sep-2012,Null,'Working Day',Null,14:40:00,'Kuram Agency',32.9746,70.1456,'FATA','Kashmir Chowk-Parachinar','Market','Low','Open',Null,'Civilian','None',14,15,40,80,1,'NA',Null,19.935,67.883,~
13-Oct-2012,Null,'Holiday','Weekend',10:35:00,'Dara Adam khel',33.6854,71.5131,'KPK','Darra Bazar-Near Headquarters of Pro-Ggovernment Peac Body','Market','Medium','Open',Null,'Anti-Militants','None',13,20,39,41,1,'30kg','Lady Reading Hospital',23.495,74.291,~
4-Nov-2012,Null,'Holiday','Weekend','2:00 PM / 2:30 PM','Buner',34.3943,72.6151,'KPK','Near District Headquarters Hospital in Daggar Area','Mobile','Low','Open',Null,'Anti-Militants','None',5,6,7,10,1,Null,'District Headquarters Hospital',19.195,66.551,~
7-Nov-2012,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Near Khan Razzaq Police Station-Qissa Khawani Bazaar','Mobile','High','Open',Null,'Police','None',6,8,28,37,1,'7kg-8kg','Lady Reading Hospital',19.825,67.685,~
8-Nov-2012,Null,'Working Day',Null,06:55:00,'Karachi',24.9918,66.9911,'Sindh','Sachal Rangers'' Headquarters-North Nazimabad Block B Area','Military','High','Open',Null,'Military','None',0,3,18,23,1,'100kg-150kg','Abbasi Shaheed Hospital-Sindh Rangers Hospital-PNS Shifa Hospital',25.995,78.791,~
19-Nov-2012,Null,'Working Day',Null,Null,'Mohmand Agency',32.9746,70.1456,'FATA','Ghaiba Khwar Area of Haleemzai Tehsil','Mobile','Low','Open',Null,'Government Official','None',0,0,3,4,1,'NA','Ghallanai Headquarter Hospital',7.52,45.536,~
21-Nov-2012,Null,'Working Day',Null,18:15:00,'Karachi',24.9918,66.9911,'Sindh','Orangi Town Sec-5E-Near Haider-e-Qarrar Imambargah','Religious','High','Open','Muharram Procession','Religious','Shiite',3,4,4,7,1,'4kg-5kg','Qatar Hospital-Abbasi Shaheed Hospital',22.22,71.996,~
21-Nov-2012,Null,'Working Day',Null,Null,'Rawalpindi',33.6058,73.0437,'Punjab','Imambargah Qasar-e-Shabbir in Dhok Syedan-Misrial Road','Religious','High','Open','Muharram Procession','Religious','Shiite',12,20,25,40,1,'NA','DHQ-Combined Military-Benazir Bhutto Hospital',16.795,62.231,~
25-Nov-2012,Null,'Holiday','Ashura',Null,'D.I Khan',31.8238,70.9095,'KPK','Commissionary Bazaar-Choglia Area','Market','High','Open','Muharram Procession','religious','Shiite',5,6,70,80,1,'12kg','District Headquarter Teaching Hospital-Combined Military Hospital',12.21,53.978,~
29-Nov-2012,Null,'Working Day',Null,'NA','South Waziristan',32.3202,69.8597,'FATA','Rustam Bazaar','Mobile','Low','Open',Null,'Anti-Militants','None',5,8,10,18,1,Null,'Tehsil Headquarter Hospital Wana',3.895,39.011,~
4-Dec-2012,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Haved Police Station Bannu','Police','High','Open',Null,'Police','None',Null,Null,6,10,1,'600kg-800kg','DHQ Hospital Bannu',15.435,59.783,~
5-Dec-2012,Null,'Working Day',Null,06:30:00,'South waziristan',32.3202,69.8597,'FATA','Zaree Noor Camp-Angoor Adda Rd','Military','High','Open',Null,'Military','None',2,3,20,25,1,Null,'First Treatment Hospital',7.1,44.78,~
22-Dec-2012,Null,'Holiday','Weekend',Null,'Peshawar',34.0043,71.5448,'KPK','Dhaki Nalbandi Area-Qissa Khwani Bazar','Residence','High','Closed',Null,'Government Official','None',Null,9,17,20,1,'4kg-6kg','Lady Reading Hospital',15.065,59.117,~
10-Jan-2013,Null,'Working Day',Null,Null,'Quetta',30.2095,67.0182,'Baluchistan','Two suicide bombers blew themselves up at a crowded snooker club on Alamdar Road','Market','High','Closed',Null,'Civilian','Shiite',51,93,116,121,2,Null,'Civil Hospital and the Combined Military Hospital-Quetta',9.06,48.308,~
1-Feb-2013,Null,'Working Day',Null,'Friday prayer time','Hangu',33.5351,71.0713,'KPK','Masjid Faizullah and Masjid Purdil near Marketplace','Religious','High','Open','Possibley anti-taliban Sunni Council','Civilian','Sunni',24,27,40,50,1,Null,'DHQ-Kohat',10.79,51.422,~
14-Feb-2013,Null,'Working Day',Null,Null,'Hangu',33.5351,71.0713,'KPK','Security checkpost located in Tal area of Hangu','Military','High','Open','FC check post','Military','None',7,Null,8,23,1,Null,Null,12.12,53.816,~
14-Feb-2013,Null,'Working Day',Null,Null,'Bannu',32.935,70.6688,'KPK','Maryan police station in Frontier Region Bannu','Police','High','Open','TTP avenged killing of their fighters in custody and bodies thrown in Miramshah','Police','None',0,0,1,Null,4,Null,Null,8.31,46.958,~
16-Feb-2013,Null,'Working Day','Weekend',18:00:00,'Quetta',30.2095,67.0182,'Baluchistan','Kirani Road near Hazara Town','Market','Medium','Open',Null,'Civilian','Shiite',64,84,180,200,1,'1000kg','Civil Hospital and the Combined Military Hospital',5.49,41.882,~
18-Feb-2013,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Khyber Agency''s Political Agent Office in Peshawar','Office Building','High','Closed',Null,'Government Official','None',5,Null,7,Null,2,'6kg','Lady Reading Hospital',15.55,59.99,~
18-Mar-2013,Null,'Working Day',Null,12:10:00,'Peshawar',34.0043,71.5448,'KPK','Judicial Complex loacated on Khyber Road','Office Building','High','open','Court Proceeding','Government Official','None',2,4,22,47,2,'6kg','Lady Reading Hospital',18.725,65.705,~
23-Mar-2013,Null,'Holiday','Pakistan Day',Null,'North waziristan',32.9746,70.1456,'FATA','Security Checkpost near Miramshah','Military','High','Open','Tochi Scouts Check Post Building','Military','None',8,22,20,35,1,Null,Null,6.44,43.592,~
29-Mar-2013,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Near security check post Saddar Cantt area of Peshawar','Market','High','Open','FC convoy','Military','None',5,12,11,35,Null,Null,'Lady Reading Hospital',21.525,70.745,~
16-Apr-2013,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','The bomb blast took place in Yakatoot in Kotwali Abid Khan','Market','High','Open','Election campain gathering of a Secular Party','Civilian','None',16,18,49,60,1,'6kg','Lady Reading Hospital',22.805,73.049,~
16-Apr-2013,Null,'Working Day',Null,17:30:00,'North waziristan',32.9746,70.1456,'FATA','Near Dirdhoni Check Post','Military','High','Open','Military Convoy','Military','None',7,9,8,18,1,Null,'Military Hospital Miranshah',16.9,62.42,~
20-Apr-2013,Null,'Working Day',Null,Null,'Bajaur Agency',34.8718,71.5249,'FATA','Outside Headquarter Hospital','Office Building','High','Open',Null,'Civilian','None',4,4,4,4,1,'#N/A','Headquarter Hospital Bajour Agency',18.81,65.858,~
23-Apr-2013,Null,'Working Day',Null,Null,'Quetta',30.2095,67.0182,'Baluchistan','Paramilitary check post near the Shiite neighbourhood','Residence','High','Open','Secratian','Civilian','Shiite',6,6,37,40,1,Null,Null,17.65,63.77,~
29-Apr-2013,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Jehangir Abad neighbourhood on Arbab Road','Market','High','Open',Null,'civilian','None',8,10,30,45,Null,'6kg','Khyber Teaching Hospital',23.69,74.642,~
1-May-2013,Null,'Holiday','Labour Day',Null,'Shikarpur',28,68.6667,'Sindh','Southern Shikarpur district of Sindh province-some 400 kilometres (250 miles) northeast of Karachi','Mobile','Low','Open','Parliamentary Candidate from National People''s Party in Sindh','civilian','None',1,1,2,2,Null,Null,Null,30.715,87.287,~
7-May-2013,Null,'Working Day',Null,Null,'Hangu',33.5351,71.0713,'KPK','Near Market in the town of Doaba','Market','High','Open','KP 43 Election Candidate Syed Janan of JUIF','Civilian','None',12,12,35,40,Null,Null,Null,25.335,77.603,~
8-May-2013,Null,'Working Day',Null,05:30:00,'Bannu',32.935,70.6688,'KPK','Domail Police station Bannu','Police','High','Open','Bannu Police','Police','None',2,3,23,27,Null,Null,'Government Hospital Bannu',20.715,69.287,~
11-May-2013,Null,'Holiday','General Elections','Evening','Karachi',24.9918,66.9911,'Sindh','Manghopir','Military','Medium','Open',Null,'Military',Null,2,2,3,5,Null,Null,Null,30.64,87.152,~
12-May-2013,Null,'Holiday','Weekend','Evening','Quetta',30.2095,67.0182,'Baluchistan','Residence IG Police province of Balochistan','Police','High','Open',Null,'Police','None',6,7,45,68,Null,Null,'Civil Hospital',23.635,74.543,~
24-May-2013,Null,'Working Day',Null,'Noon','Peshawar',34.0043,71.5448,'KPK','Outside Jamia Uloom al-Islamia Peshawar','Religious','High','Open','Afghan Religious Leader Haji Hidayatullah','religious','None',3,3,2,2,Null,'6kg',Null,34.725,94.505,~
3-Jun-2013,Null,'Working Day',Null,Null,'North waziristan',32.9746,70.1456,'FATA','Razmak town 20kms to the north of Miramshah','Military','High','Open','Security Checkpost','Military','None',Null,Null,2,2,Null,Null,Null,21.715,71.087,~
15-Jun-2013,Null,'Working Day',Null,'Noon','Quetta',30.2095,67.0182,'Baluchistan','Parking of Sardar Bahadur Khan University-Quetta','Educational','Low','Open',Null,'civilian','None',12,14,19,19,Null,Null,'Bolan Medical Complex Quetta',29.55,85.19,~
15-Jun-2013,Null,'Working Day',Null,'Noon','Quetta',30.2095,67.0182,'Baluchistan','Bolan Medical Complex','Hospital','Low','Closed','Security officials visiting victims of suicide attack on student bus of Sarda Bahdur Khan Women Univrsity','Police','None',11,11,Null,Null,Null,Null,'Bolan Medical Complex Quetta',29.55,85.19,~
18-Jun-2013,Null,'Working Day',Null,'4pm','Mardan',34.1982,72.0444,'KPK','Zaragaranoo Kallay-Ittehad Colony Mardan','Park/Ground','Low','Open','Police officials argue that Imran Khan Mohmand-a provincial lawmaker seems to have been the target','civilian','None',27,34,52,60,Null,'7-8kg','Tehsil Headquarters Takht Bhai-Mardan Medical Complex and Lady Reading Hospital in Peshawar',27.465,81.437,~
21-Jun-2013,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Gulshan Colony','Religious','High','Closed','Sectarian strife','Civilian','Shiite',14,15,28,30,Null,'6-7Kg','Lady Reading Hospital',35,95,~
30-Jun-2013,Null,'Holiday','Weekend','Evening','Quetta',30.2095,67.0182,'Baluchistan','Hazara Town','Religious','High','Open','Sectarian strife','Civilian','Shiite',28,30,65,70,Null,Null,'Bolan Medical Complex Quetta-CMH-Civil Hospital',30.915,87.647,~
8-Jul-2013,Null,'Working Day',Null,Null,'Hangu',33.5351,71.0713,'KPK','Doaba Bazaar','Market','High','Open','Tribal elder Malik Habibullah Khan was the target','Civilian',Null,6,8,10,10,Null,Null,Null,30.72,87.296,~
25-Jul-2013,Null,'Working Day',Null,'Evening','Sukkur',27.6833,68.8667,'Sindh','Sukkur Barrage Colony','Police','Low','Open','Coordinated assault on ISI sukkur office building','Military','None',8,9,30,30,2,Null,Null,36.345,97.421,~
26-Jul-2013,Null,'Working Day',Null,'Evening','Kuram Agency',32.9746,70.1456,'KPK','Parachinar Bazaar','Market','High','Open',Null,'Civilian','Shiite',43,50,180,200,2,Null,'Parachinar Headquarters Hospital',26.015,78.827,~
8-Aug-2013,Null,'Holiday','Eid Holidays',Null,'Quetta',30.2095,67.0182,'Baluchistan','Police Headquarters Quetta','Police','High','Open','Gathering on Funeral prayers of SHO City Mohibullah who was shot dead earlier in the day','Police','None',30,38,50,60,1,'8kg','Civil Hospital and CMH Quetta',31.06,87.908,~
22-Sep-2013,Null,'Holiday',Null,Null,'Peshawar',34.0043,71.5448,'KPK','All Saints Church near Qissa Khawani bazaar in Peshawar','Religious','High','Open','Two suicide attackers blew themselves up outside a church near Qissa Khawani bazaar','Civilian','None',78,81,100,145,2,Null,'Lady Reading Hospital',29.84,85.712,~
2-Oct-2013,Null,'Working Day',Null,Null,'Chaman',30.9222,66.4447,'Baluchistan','southwestern border crossin between Afghanistan and Pakistan','Office Building','High','Open',Null,'Government Official','None',6,8,10,16,1,Null,Null,24.42,75.956,~
3-Oct-2013,Null,'Working Day',Null,Null,'Hangu',33.5351,71.0713,'KPK','Spin Tall region of Hangu','Residence','High','Open','A Compound of an anti-Taliban militia commander Mullah Nabi Hanafi was targetted by militants','Anti-Militants','None',15,17,22,22,1,Null,Null,25.96,78.728,~
11-Oct-2013,Null,'Working Day',Null,Null,'South waziristan',32.3202,69.8597,'FATA','Wana-main town of South waziristan','Military','High','Open','Military Convoy','Military','None',2,2,2,2,Null,Null,Null,19.61,67.298,~
16-Oct-2013,Null,'Holiday','Eid Holidays','Evening','D. I Khan',31.8238,70.9095,'KPK','Tehsil Kulachi-50km away from D.I Khan','Residence','High','Open','KP Law Minister Israrullah Gandapur was targeted and killed in the attack','Civilian','None',8,9,30,30,Null,Null,Null,28.61,83.498,~
16-Nov-2013,Null,'Holiday','Weekend',Null,'Bannu',32.935,70.6688,'KPK','Near River Kurram bridge','Mobile','High','Open','Targeted van of security forces','Military','None',0,0,7,7,Null,Null,'CMH Bannu',13.09,55.562,~
19-Nov-2013,Null,'Working Day',Null,Null,'North waziristan',32.9746,70.1456,'FATA','Mir Ali town of Miramshah','Park/Ground','High','Open','It is said that Bannu TTP Militant commander Saifuddin was the target','Anti-Militants','None',7,7,1,1,Null,Null,Null,12.545,54.581,~
22-Nov-2013,Null,'Working Day',Null,10:55:00,'Khyber Agency',34.0211,71.2874,'KPK','Torkhan customs office in Landikotal','Office Building','Medium','Closed',Null,'Government Official','None',0,0,26,26,Null,'5kg','Hayatabad Medical Complex-Peshawar',15.985,60.773,~
17-Dec-2013,Null,'Working Day',Null,'Evening','Rawalpindi',33.6058,73.0437,'Punjab','Gracy line area near Airport','Religious','Medium','Open','Sectarian strife','Civilian','Shiite',3,3,14,Null,Null,Null,'Benazir Bhutto Hospital and District Headquarters Hospital',14.39,57.902,~
18-Dec-2013,Null,'Working Day',Null,'Evening','North waziristan',32.9746,70.1456,'FATA','Kharoji checkpoint-about three kilometres east of Miranshah','Military','High','Open','Targeted security checkpoint as a revenge for killing Hakimullah Mahsud','Military','None',5,5,25,34,Null,Null,Null,8.19,46.742,~
20-Dec-2013,Null,'Working Day',Null,Null,'Karachi',24.9918,66.9911,'Sindh','Pakhtoon Chowk close to Old Sabzi Mandi-Karachi','Market','Medium','Open','Inspector Shafiq Tanoli was targeted','Police','None',2,2,20,21,Null,Null,'Jinnah Hospital',18.735,65.723,~
1-Jan-2014,Null,'Working Day',Null,Null,'Quetta',30.2095,67.0182,'Baluchistan','Qambrani Road in Akhtarabad-on the outskirts of Quetta','Transport','High','Open','Sectarian strife','Civilian','Shiite',2,3,30,31,Null,Null,'Bolan Medical Complex',1.605,34.889,~
6-Jan-2014,Null,'Working Day',Null,Null,'Hangu',33.5351,71.0713,'KPK','Shia-dominated Ibrahimzai area of Hangu district','Educational','High','Open','Sectarian strife','Civilian','Shiite',2,2,2,2,Null,Null,Null,9.235,48.623,~
9-Jan-2014,Null,'Working Day',Null,Null,'Karachi',24.9918,66.9911,'Sindh','Near Essa Nagri at the Lyari Expressway','Mobile','Low','Open','Superintendent of Police (SP) Crime Investigation Department (CID) Chaudhry Aslam was the TTP target','Police','None',3,3,7,11,Null,'20-25kg','Agha Khan University Hospital',15.395,59.711,~
20-Jan-2014,Null,'Working Day',Null,07:45:00,'Rawalpindi',33.6058,73.0437,'Punjab','R.A Bazaar','Market','High','Open','TTP claimed this attack as payback for a deadly military raid on the Lal Masjid (Red Mosque) in Rawalpindi in 2007.','Military','None',13,13,15,15,Null,Null,Null,11.455,52.619,~
23-Jan-2014,Null,Null,Null,Null,'Peshawar',34.0043,71.5448,'KPK','Kohat road',Null,Null,Null,Null,Null,Null,Null,6,Null,8,Null,Null,Null,11.11,51.998,~
29-Jan-2014,Null,'Working Day',Null,Null,'Karachi',24.9918,66.9911,'Sindh','North Nazimabad Rangers headquarters','Military','High','Open','Rangers targeted by TTP','Military','None',3,3,0,1,Null,Null,'Abbasi Shaheed Hospital',19.865,67.757,~
4-Feb-2014,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Kocha Risaldar area of Peshawar','Hotel','Medium','Closed','Sectarian strife','Civilian','None',9,9,25,50,Null,'5Kg','Lady Reading Hospital',10.82,51.476,~
7-Feb-2014,Null,'Working Day',Null,Null,'Khanewal',30.2999,71.9308,'Punjab',Null,'Mobile','Low','Open','Search operation of Security forces','Police','None',0,0,5,5,Null,Null,Null,13.335,56.003,~
10-Feb-2014,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Essa Khel Garhi area of Peshawar','Residence','Low','Open','Search operation of Security forces','Civilian','None',4,4,3,3,Null,'6kg','Lady Reading Hospital',12.535,54.563,~
13-Feb-2014,Null,'Working Day',Null,Null,'Karachi',24.9918,66.9911,'Sindh','Razzaqabad police training college in Karachi''s Shah Latif Town','Police','High','Open','TTP revenge','Police','None',11,13,36,47,Null,'25-30kg','Jinnah Hospital',20.305,68.549,~
24-Feb-2014,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Iranian consulate in University Town','Mobile','High','Open','Sectarian strife','Military','None',2,3,8,10,Null,'60kg','Lady Reading Hospital',16.13,61.034,~
3-Mar-2014,Null,'Working Day',Null,Null,'Islamabad',33.718,73.0718,'Capital','District court in Islamabad sector F-8','Office Building','Medium','Open','Judge with Laal masjid case','Government Official','None',11,11,24,29,Null,Null,'Pakistan Institute of Medical Sciences',10.81,51.458,~
14-Mar-2014,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Sarband Area on the outskirts of city','Police','High','Open','Police patrol','Police','None',8,11,32,45,Null,'14kg','Lady Reading Hospital',17.68,63.824,~
24-Apr-2014,Null,'Working Day',Null,Null,'Karachi',24.9918,66.9911,'Sindh','Near old vegetable market','Market','High','Open','Police Inspector Ishfaq Tanoli was the target of the blast','Police','None',2,4,2,15,Null,Null,Null,30.56,87.008,~
11-May-2014,Null,'Holiday',Null,12:40:00,'Peshawar',34.0043,71.5448,'KPK','Inside a mosque in Shahi Bagh area near Tirah IDPs registration center','Religious','High','Closed','IDPs of Tirah Valley','Civilian','None',4,5,9,11,Null,'10kg','Lady Reading Hospital',25.31,77.558,~
4-Jun-2014,Null,'Working Day',Null,09:20:00,'Fateh Jang',33.5689,72.6378,'Punjab','At a railway crossing at the junction of Fateh Jang and Rawalpindi','Mobile','Low','Open','Security forces vehicle','Military','None',5,5,5,5,Null,'2kg','DHQ Fateh Jang',31.055,87.899,~
8-Jun-2014,Null,'Holiday',Null,Null,'Taftan',28.28,62.35,'Baluchistan','Hotel in Taftan near the Pakistan-Iran border','Hotel','High','Closed','Shia pilgrims','Civilian','Shiite',23,30,7,16,Null,Null,'CMH Quetta',27.51,81.518,~
9-Jun-2014,Null,'Working Day',Null,Null,'Karachi',24.9918,66.9911,'Sindh','Jinnah Airport-Airport Road Karachi',Null,Null,Null,Null,Null,Null,Null,28,Null,24,Null,Null,Null,32.695,90.851,~
19-Jun-2014,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Residence of an anti-Taliban peace militia in Matan Adezai area of Peshawar','Residence','Medium','Closed','Farman Ullah-the leader of anti-militants lashkar','Civilian','None',1,2,5,5,Null,Null,'Lady Reading Hospital',32.965,91.337,~
24-Jun-2014,Null,'Working Day',Null,Null,'North waziristan',32.9746,70.1456,'FATA','Near a military checkpost in Spinwam village in Shawal valley','Hospital','High','Open','Operation Zarb-e-Azab','Military','None',3,3,1,1,Null,Null,Null,28.265,82.877,~
24-Sep-2014,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK',Null,'Mobile','Medium','open','the target of the bombing appeared to be Brigadier Khalid Javed-the second most senior officer in the Frontier Corps force','Military','None',4,5,18,29,Null,'45KG','Lady Reading Hospital-Combined Military Hospital',29.84,85.712,~
4-Oct-2014,Null,'Working Day',Null,'Night','Quetta',30.2095,67.0182,'Baluchistan','Near a girls high school in Hazara Town','Educational','High','Open','Hazara ethnic shitte group','Civilian','Shiite',5,5,12,12,Null,Null,'Bolan Medical Complex Hospital-Combined Military Hospital (CMH)',26.59,79.862,~
15-Oct-2014,Null,Null,Null,Null,'Tirah Valley',33.8679,70.51364,'FATA','Pir Mela Area of Tirah Valley in Khyber Agency',Null,Null,Null,Null,Null,Null,Null,7,Null,5,Null,Null,Null,17.21,62.978,~
23-Oct-2014,Null,'Working Day',Null,Null,'Quetta',30.2095,67.0182,'Baluchistan',Null,'Park/Ground','Medium','open','Jamiat Ulema-e-Islam-Fazl (JUI-F) chief Fazlur Rehman had a narrow escape as a suicide bomber detonated explosives near his vehicle outside a political rally in Quetta','Civilian','None',2,3,15,20,Null,Null,Null,21.405,70.529,~
2-Nov-2014,Null,'Holiday','Weekend',Null,'Wagah',31.6047,74.5729,'Punjab','Pak-India Border Crossing on Grand Trunk Road','Military','High','open',Null,'Civilian','None',45,55,70,120,Null,'15KG','General Hospital Lahore-',22.18,71.924,~
16-Dec-2014,Null,Null,Null,Null,'Peshawar',34.0043,71.5448,'KPK','Army Public School',Null,Null,Null,Null,Null,Null,Null,148,Null,132,Null,Null,Null,9.86,49.748,~
28-Dec-2014,Null,Null,Null,Null,'Zhob',31.35,69.45,'Balochistan','Ismailzai',Null,Null,Null,Null,Null,Null,Null,2,Null,0,Null,Null,Null,8.445,47.201,~
30-Jan-2015,Null,Null,Null,Null,'Shikarpur',28,68.6667,'Sindh','Imambargah',Null,Null,Null,Null,Null,Null,60,62,Null,39,Null,Null,Null,16.225,61.205,~
13-Feb-2015,Null,Null,Null,Null,'Peshawar',34.0043,71.5448,'KPK','Imambargah',Null,Null,Null,Null,Null,Null,Null,21,Null,60,Null,Null,Null,17.235,63.023,~
17-Feb-2015,Null,Null,Null,Null,'Lahore',31.5451,74.3407,'Punjab','Near Police Line',Null,Null,Null,Null,Null,Null,5,9,Null,Null,Null,Null,Null,18.68,65.624,~
18-Feb-2015,Null,Null,Null,Null,'Rawalpindi',33.6,73.0333,'Punjab','Qasre-sina Imambargah-kurri road',Null,Null,Null,Null,Null,Null,Null,5,Null,6,Null,Null,Null,15.25,59.45,~
15-Mar-2015,Null,Null,Null,Null,'Lahore',31.5451,74.3407,'Punjab','Outside Church',Null,Null,Null,Null,Null,Null,Null,17,70,72,Null,Null,Null,18.63,65.534,~
20-Mar-2015,Null,Null,Null,Null,'Karachi',24.9918,66.9911,'Sindh','Roadside Qalandria Chowk North Nazimabad',Null,Null,Null,Null,Null,Null,2,3,0,0,Null,Null,Null,27,80.6,~
6-May-2015,Null,'Working Day',Null,Null,'KURRAM AGENCY',32.9746,70.1456,'FATA','outside a high-school football ground in Alizai area of Lower Kurram Agency',Null,Null,Null,Null,Null,Null,2,3,Null,3,Null,Null,'Ali Zai Hospital',25.985,78.773,~
26-May-2015,Null,'Working Day',Null,Null,'Karachi',24.9918,66.9911,'Sindh','Orangi Town Faqeer Colony',Null,Null,Null,Null,'Rangers',Null,1,2,Null,Null,Null,Null,Null,33.05,91.49,~
26-May-2015,Null,'Working Day',Null,Null,'Karachi',24.9918,66.9911,'Sindh','Orangi Town Faqeer Colony',Null,Null,Null,Null,Null,Null,Null,5,Null,Null,Null,Null,Null,33.05,91.49,~
29-May-2015,Null,'Working Day',Null,Null,'Lahore',31.5451,74.3407,'Punjab','Kalma Chowk near Qaddafi Stadium',Null,Null,Null,Null,Null,Null,1,2,Null,6,Null,Null,Null,34.08,93.344,~
6-Jun-2015,Null,'Weekend',Null,Null,'Sargodha',32.0836,72.6711,'Punjab','near Ghausia Market Sargodha',Null,Null,Null,Null,Null,Null,Null,2,Null,6,Null,Null,Null,29.9,85.82,~
8-Jun-2015,Null,'Working Day',Null,Null,'North waziristan',32.9746379,70.1455,'FATA','near the Afghan border in Pakistan''s restive North Waziristan tribal area',Null,Null,Null,'The clashes were marked by an intense exchange of fire between security forces and militants-the report added. Of the 19 militants killed-five were militant commanders. The seven soldiers were killed when one of the militants detonated a suicide vest while being chased by troops.',Null,Null,7,19,Null,Null,Null,Null,Null,26.82,80.276,~
11-Jun-2015,Null,'Working Day',Null,Null,'Peshawar',34.0043,71.5448,'KPK','Peshawars Hayatabad area',Null,Null,Null,Null,Null,Null,1,2,4,7,Null,Null,Null,30.58,87.044,~
29-Jun-2015,Null,'Working Day',Null,Null,'Lahore',Null,Null,'Punjab','A house in Sheikhupura district',Null,Null,Null,Null,Null,Null,1,4,Null,'http://www.samaa.tv/pakistan/29-Jun-2015/shootout-after-suicide-attack-in-lahore',Null,Null,Null,Null,Null,~
17-Jul-2015,Null,'Holiday',Null,Null,'Quetta',Null,Null,'Balochistan','Entrance of a Shiite neighborhood in southwestern Pakistan',Null,Null,Null,'a suicide attacker has detonated his explosive vest at the entrance of a Shiite neighborhood in southwestern Pakistan killing one security guard.',Null,Null,1,1,Null,Null,Null,Null,Null,Null,Null,~
16-Aug-2015,Null,'Holiday',Null,Null,'ATTOCK',33.768734,72.362147,'Punjab','Political office in Attocks Shadi Khan area',Null,Null,Null,'Punjab home minister Colonel (retd) Shuja Khanzada was killed in a suicide attack on his political office in Shadi Khan village Attock Sunday along with 16 others.',Null,Null,16,19,23,25,Null,Null,Null,28.655,83.579,~
'Thursay-Aug 27-2015',Null,'Working Day',Null,Null,'MULTAN',30.193636,71.449009,'Punjab','house in the town of Pir Mahal',Null,Null,Null,Null,Null,Null,4,4,Null,2,Null,Null,Null,33.575,92.435,~
1-Sep-2015,Null,'Working Day',Null,Null,'Khyber Agency',34.021103,71.287421,'KPK','a local government office in Jamrud Bazaar area Khyber Agency',Null,Null,Null,Null,Null,Null,3,6,50,56,Null,Null,'Hayatabad Medical Complex',28.225,82.805,~
20-Sep-2015,Null,'Holiday',Null,Null,'Karachi',24.879503,67.174575,'Sindh','Residential Building in Rafah-e-Aam Society in Karachi','Residential Building','Low','closed','A suicide bomber blew himself up during a joint action by police and Rangers early on Sunday morning in Rafah-e-Aam Society in Karachi. The blast injured 2 police officers. The attackers were scheming for terrorist activities on Eid-ul-Azha.','Police & Rangers',Null,1,Null,2,Null,1,Null,Null,35,95,~
14-Oct-2015,Null,'Working Day',Null,Null,'Taunsa',30.712665,70.658161,'Punjab','At PoliticalParty MP''s office on College road Taunsa DGK.',Null,Null,Null,'Public meeting with MPA was targeted at political party office.',Null,Null,7,Null,10,20,1,'13KG',Null,29.11,84.398,~
22-Oct-2015,Null,'Holiday','Ashura Holiday',Null,'Quetta',30.182971,66.998734,'Balochistan','Shiite mosque in southwest Pakistan''s Sibi district','Religious',Null,'closed','Attack took place when the Shiites were holding a gathering ahead of the Ashoura, a key religious event. ','Religious','Shiite',10,11,12,15,1,Null,'Bhag Hospital',16.25,61.25,~
23-Oct-2015,Null,'Holiday','Ashura Holiday',Null,'Jacobabad',28.274681,68.712889,'Sindh','Attack on Muharram Procession in Jacobabad near Lashari Muhalla',Null,Null,Null,'Attack on Muharram procession','Religious','Shiite',22,23,40,'40+',Null,Null,'Jacobabad Civil Hospital',28.59,83.462,~
29-Dec-2015,Null,'Working Day',Null,Null,'Mardan',34.200114,72.050801,'KPK','NADRA office Nisatta Road Mardan','Government',Null,Null,Null,'Civilian',Null,21,26,50,56,Null,'8KG','district headquarters hospitaldistrict headquarters hospital',13.53,56.354,~
13-Jan-2016,Null,'Working Day',Null,Null,'Quetta',30.165686,67.00178,'Balochistan','Polio centre in Satellite town Quetta',Null,Null,Null,'Attack on Polio Centre','Civilian & Police','None',15,15,25,36,Null,'8KG','Civil Hospital, CMH ',6.855,44.339,~
19-Jan-2016,Null,'Working Day',Null,Null,'Peshawar',33.999533,71.42502,'KPK','check post in Karkhano Market- adjacent to Jamrud in Khyber Agency',Null,Null,Null,'Attack on Check Post',Null,'None',10,12,20,25,1,Null,'Hayatabad Medical Complex',11.645,52.961,~
29-Jan-2016,Null,'Working Day',Null,Null,'Zhob',31.341261,69.448659,'Balochistan','Suicide Bomber Attacks Army Facility',Null,Null,Null,Null,'Army','None',0,0,5,6,1,Null,'Civil Hospital Zhob',11.125,52.025,~
6-Feb-2016,Null,'Working Day',Null,Null,'Quetta',30.199805,67.010157,'Balochistan','Attack on vehicle of Frontier Corps near Liaquat Park Quetta',Null,Null,Null,'Attack on vehicle of Frontier Corps','Frontier Corps','None',9,11,30,35,1,'8-10KG','Civil Hospital Quetta- CMH',9.945,49.901,~
7-Mar-2016,Null,'Working Day',Null,Null,'Shabqadar-Charsadda',34.149433,71.742781,'KPK','Attack outside of session court in Shab-Qadar Charsadda',Null,Null,Null,Null,Null,'None',10,20,27,31,1,Null,'Lady Reading Hospital',16.715,62.087,~
27-Mar-2016,Null,'Holiday',Null,Null,'Lahore',31.51293,74.28899,'Punjab','Attack in children''s play area of Park in Lahore',Null,Null,Null,Null,Null,'Christian',70,72,233,300,1,'8-10KG','Jinnah Hospital,Sheikh Zaid Hospital,Services Hospital,Farooq Hospital,Meo Hospital,Bajwa Hospital',22.565,72.617,~
16-Apr-2016,'8 Rajab 1437 A.H.','Working Day',Null,Null,'Khyber Agency',34.047839,71.28436,'FATA','Hujra of Said Jamal in the Kharko Sarhgi area in the Zakhakhel tehsil of Khyber Agency','Residence','High','closed',Null,'Civilian','None',2,2,0,0,1,Null,Null,25.405,77.729,~
19-Apr-2016,'10 Rajab 1437 A.H.','Working Day',Null,Null,'Mardan',34.207854,72.049453,'KPK','Mardan Excise and Taxation Department located in Cantonment Area on Mall Road in Mardan District','Government','High','closed','Attack on Mardan Excise and Taxation Department','Government Official','None',1,1,10,18,1,'8-10KG',Null,23.105,73.589,~
30-May-2016,'22 Shaban 1437 A.H.','Working Day',Null,Null,'Mardan',34.195682,72.037771,'KPK','Mardan City Police Station','Police','High','Open','Attack on City Police Station, Mardan','Police','None',1,1,12,15,1,'8-10KG','Mardan district hospital.',30.02,86.036,~
8-Aug-2016,'05 Zeqad 1437 A.H.','Working Day',Null,Null,'Quetta',30.194225,67.008822,'Balochistan','Civil Hospital, Quetta','Government','High','Closed','The fatalities were mainly advocates','advocates (lawyers)','None',70,70,112,120,Null,'8KG',Null,29.585,85.253,~
2-Sep-2016,'29 Zeqad 1437 A.H.','Working Day',Null,05:50:00,'Mardan',34.195776,72.036565,'KPK','Mardan District Court','Government','High','closed','Attack on District Court, Mardan','Civilian','None',13,14,52,60,1,'6KG',Null,27.805,82.049,~
13-Sep-2016,'10 Zilhaj 1437 A.H.','Holiday','Eid ul Azha Holiday',07:30:00,'Shikarpur',28.002718,68.730383,'Sindh','Imambargah','Religious','High','Closed','Attack on Shia Imambargah on Eid ul Azha Prayer','religious','Shiite',0,0,10,13,Null,Null,Null,31.945,89.501,~
16-Sep-2016,'13 Zilhaj 1437 A.H.','Working Day',Null,13:30:00,'Mohmand Agency',34.400331,71.560424,'FATA','Jamea Masjid, Pai Khan','Religious','High','Closed','Attack on Masjid During Jumma Prayer','religious',Null,16,36,22,Null,1,Null,'District Headquarters Hospital (DHQ) Bajaur Agency',28.68,83.624,~
25-Oct-2016,'23 MuHarram 1438 A.H.','Working Day',Null,1-Jan-1904,'Quetta',30.14283,66.98195,'Balochistan','police training center','Government','High','Closed','Attack on Police Training Center, Saryab Road, Quetta','Police',Null,58,61,100,165,2,'8-10 KG',Null,14.545,58.181,~
12-Nov-2016,'11 safar 1438 A.H.','Weekend',Null,18:00:00,'Khuzdar',25.776775,67.02239,'Balochistan','Dargah Shah Noorani Shrine','Religious','High','Closed','Attack on Dargah Shah Noorani in Khuzdar district','Civilian','None',45,52,100,100,1,Null,'Hub, Khuzdar, Lasbella and Civil Hospital in Karachi',Null,Null,~
26-Nov-2016,'25 safar 1438 A.H.','Weekend',Null,06:00:00,'Mohmand Agency',34.325826,71.398789,'FATA','FC Check Post','Military','High','Open','Attack Camp of Mohmand Rifles in Mohmand Agency Headquarters, Ghalani, Mohmand Agency','Military','None',2,2,14,14,4,Null,Null,17.63,63.734,~
7-Feb-2017,'09 Jamadi-ul-Awal 1438 A.H.','Working Day',Null,05:00:00,'Bannu',32.949814,70.60908,'KPK','Police Station Mandan, Bannu','Police','High','Open','Attack on Mandan Police Station, Bannu','Police','None',0,0,2,2,1,'20 KG','DHQ Hospital Bannu',19,Null,~
13-Feb-2017,'16 Jumada al-awwal 1438 A.H','Working Day',Null,18:00:00,'Lahore',31.555382,74.331873,'Punjab','Mall road, Lahore','Government','High','Open','Attack on pharmaceutical protest','Civilian','None',14,18,83,90,1,'NA','1. Mayo Hospital 2. Sir Ganga Ram Hospital',16.255,61.259,~
15-Feb-2017,'19 Jumada al-awwal 1438 A.H','Working Day',Null,08:00:00,'Ghallanai, Mohmand Agency ',34.5,71.333333,'FATA','main gate of Mohmand Agency headquarters, Ghallanai','Commercial/residence','High','Open','Attack on paramilitary HQ','Army','None',5,8,0,3,1,Null,'Lady Reading Hospital',11.115,52.007,~
15-Feb-2017,'19 Jumada al-awwal 1438 A.H','Working Day',Null,15:30:00,'Hayatabad',33.986111,71.456944,'KPK','Hayatabad Medical Complex','Commercial/residence','Medium','Open','inauguration of the Out Patient Department (OPD) at the Hayatabad Medical Complex','Civilian Judges','None',1,1,4,18,1,'15 KG','Hayatabad Medical Complex',16.63,61.934,~
15-Feb-2017,'19 Jumada al-awwal 1438 A.H','Working Day',Null,09:00:00,'Mosal Kor, Mohmand Agency',34.553808,71.434141,'FATA','Office of political agent','Government','High',Null,Null,'Government Official','None',1,1,0,0,1,Null,Null,Null,Null,~
16-Feb-2017,'20 Jumada al-awwal 1438 A.H','Working Day',Null,18:00:00,'Sehwan town',26.419314,67.859373,'Sindh','Lal Shahbaz Qalandar shrine','Religious','High','Closed','Attack on shia community','Shia sect','shiite',70,72,150,200,1,Null,'1. Sehwan Taluka Hospital 2. Combined Military Hospital Hyderabad',23.71,74.678,~
21-Feb-2017,'25 Jumada al-awwal 1438 A.H','Working Day',Null,09:00:00,'Tangi, Charsadda District',34.3,71.653889,'KPK','Court','Government','High','Closed','Attack on lawyers and judges','Judges & lawyers','None',6,7,15,20,2,'NA','Lady Reading Hospital',11.18,52.124,~
5-Apr-2017,'08 Rajab 1438 A.H','Working Day',Null,07:15:00,'Lahore',31.463017,74.435675,'Punjab','Bedian Road',Null,'Low','Open','Population Census Team','Military','None',6,7,19,22,Null,'NA','Combined Military Hospital (CMH), General Hospital',29,84.2,~
12-May-2017,'15 Shaban 1438 A.H','Working Day',Null,14:30:00,'Quetta',29.800833,66.848056,'Baluchistan','Town of Mastung',Null,'Low','Open','Sucide bomber wearing an explosive vest carried out the attack.','Government Official','None',25,28,35,37,1,'NA',Null,44,111,~
20-May-2017,'23 Shaban 1438 A.H','Weekend',Null,Null,'Kohat',33.38752,71.340408,'KPK','Kamal khel area near lachi kohat','Police','Low','Open','Terrorist ambushed a police party while it was on its way to arrest criminals','Police','None',1,4,0,0,Null,'NA',Null,37,99,~
23-Jun-2017,'27 RamaDHaan 1438 A.H','Working Day',Null,13:30:00,'Quetta',33.88423,70.10878,'Balochistan','Parachinar town in the restive tribal bel','Religious','Low','Open','Suicide bombers targeting the capital of Balochistan province and the Shia-majority Parachinar town days before the end of the holy month of Ramzan.','Shia sect','Shiite',30,85,100,'100+',3,'75KG',Null,36,97,~
10-Jul-2017,'16 SHawwal 1438 A.H','Working Day',Null,11:43:00,'Chaman',30.90983,66.452402,'Balochistan','Boghra Road',Null,'Low','Open','Sucide bomber wearing an explosive vest carried out the attack.','Police','None',1,3,1,11,1,Null,Null,38,100,~
17-Jul-2017,'22 Shawaal 1438 A.H','Working Day',Null,Null,'Peshawar',34.015,71.5805,'KPK','near the Afghan border','Military','High','open','suicide bomber riding on a motorcycle hit a Frontier Corps vehicle in Peshawar','Military','None',1,2,1,7,1,Null,Null,37,98,~
17-Jul-2017,'22 Shawaal 1438 A.H','Working Day',Null,Null,'Peshawar',34.015,71.5805,'KPK','southwestern Chaman province','Military','High','Open','bomb struck in southwestern Chaman province','Military','None',1,1,1,1,1,Null,Null,37,98,~
24-Jul-2017,'29 Shawaal 1438 A.H','Working Day',Null,15:55:00,'Lahore',31.500875,74.33312,'Punjab','near Arfa Karim IT Tower Ferozepur Road',Null,'Medium','Open',Null,'Police',Null,26,27,56,56,1,Null,'Jinnah Hospital, General Hospital, Ittefaq Hospital',32,88,~
12-Aug-2017,'12 Zeqad 1438 A.H.','Weekend',Null,17:00:00,'Quetta',30.203658,67.004469,'Balochistan','Pishin bus stop',Null,'Medium','Open','the attacker had been carrying 25kg of incendiary explosives on a motorcycle that he had rammed into the military truck','Military','None',15,15,40,40,1,'25KG',Null,29,Null,~
5-Oct-2017,'13 MuHarram 1439 A.H','Working Day',Null,Null,'Quetta',28.571051,67.496895,'Balochistan','Fateh Pur Shrine in Jhal Magsi village','Religious','High','Open/Closed','at the entrance of shrine','Civilian','None',21,22,25,Null,1,Null,'Larkana Hospital, Gandawah District Headquarters Hospital, 1 shifted to Aga Khan Hospital KHI',27.8,81,~
19-Oct-2017,'27 MuHarram 1439 A.H','Working Day',Null,08:00:00,'Quetta',Null,Null,'Balochistan','Sariab Mill area','Highway','Low','Open','explosives-laden vehicle rammed into a security forces convoy on the Quetta-Sibi Highway','Police','None',7,7,22,22,1,Null,Null,26,79,~
9-Nov-2017,'19 Safar 1439 A.H','Working Day',Null,07:00:00,'Quetta',30.221057,67.002524,'Balochistan','Quetta''s Chaman Housing Scheme on airport road','Police','Low','Open','AIG Hamid Shakils vehicle','Police','None',2,2,8,8,1,'15KG','Combined Military Hospital (CMH)-(Quetta), Civil Hospital(Quetta)',25,77,~
24-Nov-2017,'5 Rabi Al-Awwal 1439 A.H','Working Day',Null,07:00:00,'Peshawar',33.970623,71.43862,'KPK','Near Zarghuni Masjid, Phase-2 Hayatabad','Police','Low','Open','a police vehicle of AIG Asharf Noor','Police','None',1,3,6,8,1,'20KG','Hayatabad Medical Complex(Peshawar)',22,72,~
25-Nov-2017,'6 Rabi Al-Awwal 1439 A.H','Working Day',Null,07:00:00,'Quetta',30.139626,66.981476,'Balochistan','Sariab Road, near Bus terminal','Military','Medium','Open','transport for a colonel in Pakistan''s armed forces, was parked near a bus terminal','Military','None',4,4,16,22,1,'10KG','Civil Hospital(Quetta)',29,84)
NodeLocation: 320,168,1
NodeSize: 88,32
NodeInfo: 1,,,,,,,0,,,,,,0
ValueState: 2,41,60,1367,646,,MIDM
{!40700|Att_CellFormat: CellSpan(Column,CellNumberFormat('Suffix',4,0,0,dateFormat:'TIME',fullPrecision:0,numbersAsDates:0,datesAsNumbers:0,digits_:4,zeroes_:2,showZeroImPart:0),5,header:0)}
{!50000|Att_ColumnWidths: [,Column,\([,,,,,,,,,,,,,,,,,,,,159])]}
Variable Time_of_event
Title: Time of event
Description: For this example we will work with just the Time column. After all, this is an example model. The purpose is to teach how to use an LLM to clean the data, not to do everything.~
The Time column has extremely inconsistent formats. To make is usable, our goal is to come up with a single Time (whenever there is a time) that is a pretty good representation of the information listed, using minimal human intervention.~
~
It is a good idea to extract each distinct item from a hetereogeneous data set into its own variable, and then work with that. The data index (Attack_num in this case) associates the different "column variables".
Definition: The_data_Pakistan_su[Column='Time']
NodeLocation: 320,248,1
NodeSize: 64,24
ValueState: 2,1626,39,477,525,,MIDM
NumberFormat: 3,D,4,2,0,0,4,0,$,0,"h:mm:ss tt",0,"TIME",40203,0,0,15,,0
Include 0,LinkLibrary OpenAI_API_lib,2,2,1,0,OpenAI API lib.ana
NodeLocation OpenAI_API_lib: 776,88,1
NodeSize OpenAI_API_lib: 64,24
Index To_Repair_Idx
Title: To Repair Idx
Description: The subset of the data index (Attack_num) that contains Time values that need to be cleaned. These don't parse as date-times, and aren't Null, indicating that they use a non-standard format or don't contain a single Time value, which is what we ultimately want.
Definition: subset(not IsDateTime(Time_of_event) and Time_of_event<>null)
NodeLocation: 120,344,1
NodeSize: 64,24
Constant Prompt_template
Title: Prompt template
Description: The prompt is the generic instructions we give to the language model. Like many prompts, this starts with some general instructions followed by a few examples. This style is called "few-shot prompting". ~
The placeholder «time» will be replaced by the actual data that needs to be cleaned.
Definition: 'Place the given time in the standard 24-hour format: hh:mm:ss.~
Use Null for missing time. Pick a single round time with a range.~
Output only the single time with no other explanatory text.~
~
7:34pm → 19:34:00~
3 in the afternoon → Output: 15:00:00~
N/A → Null~
Between 3:45pm / 4:05pm → 4:00pm~
morning → 08:00:00~
1:12:00 PM/1:25:00 PM → 13:00:00~
«time» → '
NodeLocation: 120,424,1
NodeSize: 64,24
Variable Entries_in_need_of_r
Title: Entries in need of repair
Description: The processing time by GPT for each entry is non-trivial, so we want to limit our processing by GPT to just those entries that require some interpretation / repair. This is the subset of Time values that were not in a standard, recognized time format. So these are the ones we will ask GPT to process for us.
Definition: Time_of_event[Attack_num=To_Repair_Idx]
NodeLocation: 320,344,1
NodeSize: 64,24
ValueState: 2,212,218,650,527,,MIDM
Variable Prompt_to_send
Title: Prompt to send
Description: The instantiated prompts, with the input data, that we send to GPT. In this case, we've organized the task into one prompt per data, so GPT will process each datum as a separate task.
Definition: TextReplace(Prompt_template, "«time»", Entries_in_need_of_r)
NodeLocation: 320,424,1
NodeSize: 64,24
ValueState: 2,1248,136,763,723,,MIDM
Variable Reformatted_times
Title: Reformatted times
Description: The call to GPT that does the work. The result is the response from GPT, which (hopefully) is rewritten versions of the time data in a standard format. The result is still unparsed text, exactly as produced by GPT.~
~
For each datum, it requests multiple completions. Since GPT's response is stochastic, some completions may succeed in cleaning the datum while others are unable to. And the different completions may select different final versions (in this case, it often happens when the original entry specified a range of times, but we've instructed it to select a single time, so different completions may select a different time). There are two advantages. It increases the odds of a successful clean, and it may improve accuracy by enabling a majority vote, taking the value that appears the most times (this has been shown to improve final accuracy).
Definition: Prompt_completion(Prompt_to_send, Completion_index:Try_index, temperature:0.3)
NodeLocation: 320,520,1
NodeSize: 64,24
ValueState: 2,680,615,705,496,,MIDM
Index Try_index
Title: Try index
Description: This indexes the multiple completions for each datum.
Definition: 1..5
NodeLocation: 120,520,1
NodeSize: 64,24
Button Read_overview_descri
Title: Read overview description
Description: Press this button to view the object window for the model, where you can read the model description. Good place to start for an overview.
NodeLocation: 120,60,1
NodeSize: 64,28
OnClick: ShowWindow( Using_GPT_to_clean_i, 'Object')
Text Te304281491
Description: ⇐ The subset of data that needs to be to cleaned.
NodeLocation: 572,360,-1
NodeSize: 180,24
Text Te1046673299
Description: ⇐ The data of interest.
NodeLocation: 580,252,-1
NodeSize: 180,12
Text Te1667430291
Description: ⇐ The response from GPT. Expect it to take 1-2 minutes.
NodeLocation: 604,532,-1
NodeSize: 212,20
Text Te1801648019
Description: ⇐ Instructions for GPT
NodeLocation: 580,428,-1
NodeSize: 180,12
Variable Selected_parsed_valu
Title: Selected parsed value
Description: From the multiple completions from GPT, this selects the answer produced the most times among successful completions.
Definition: Most_popular_good( Reformatted_times_pa, Try_index, not IsText(Reformatted_times_pa), Entries_in_need_of_r)
NodeLocation: 320,680,1
NodeSize: 64,24
ValueState: 2,1598,10,1064,523,,MIDM
NumberFormat: 3,D,4,2,0,0,4,0,$,0,"h:mm:ss tt",0,"TIME",40203,0,0,15,,0
Function Most_popular_good( x : [I] ; I : index ; cond : boolean [I] ; valueForNone : atom)
Description: Pick one value from «x» along «I» among those where «cond» is true. When there are multiple values to choose from, pick a value that appears most often (breaking ties arbitrarily). If there are no values with «cond»=true, return «valueForNone».
Definition: If not max(cond,I) Then valueForNone Else~
LocalIndex opts := Unique(x, condition:cond);~
Local nTimes := sum(opts=x,I);~
ArgMax(nTimes,opts)
NodeLocation: 960,88,1
NodeSize: 88,24
WindState: 2,963,740,720,350
Variable Reformatted_times_pa
Title: Reformatted times parsed
Description: The parsed version of the cleaned values returned by GPT. Those that parse were successfully cleaned and are now either a date-time number or Null (for missing). Those that don't parse are left as the uninterpretable text.~
~
This result retains the multiple completions for each datum.
Definition: if Reformatted_times='Null' then Null else ParseDate(Reformatted_times,Entries_in_need_of_r)
NodeLocation: 320,592,1
NodeSize: 64,24
ValueState: 2,116,122,821,534,,MIDM
ReformVal: [Try_index,To_Repair_Idx]
Variable Value_that_could_not
Title: Value that could not be cleaned
Description: This is the subset of values that GPT was unable to clean.
Definition: LocalIndex Uncleaned_Attack_num := Subset(IsText(Final_cleaned_time_o)) Do~
Final_cleaned_time_o[Attack_num=Uncleaned_Attack_num]
NodeLocation: 320,864,1
NodeSize: 64,32
ValueState: 2,1647,690,416,303,,MIDM
Objective Final_cleaned_time_o
Title: Final cleaned time of event
Description: The final cleaned data, in a standardized format.~
~
It may contain some data that GPT was unable to clean. These values are textual. All successfully cleaned data is either a date-time number or the value Null (for missing).
Definition: Selected_parsed_valu[To_Repair_Idx=Attack_num, defVal:Time_of_event]
NodeLocation: 320,776,1
NodeSize: 64,24
ValueState: 2,1495,261,416,303,,MIDM
NumberFormat: 3,D,4,2,0,0,4,0,$,0,"h:mm:ss tt",0,"TIME",40203,0,0,15,,0
Text Te1207629715
Title: Recommended viewing order
Description: ~
⇐ First read the model description.~
~
Then read the description of each variable below.~
⇓
NodeLocation: 404,68,-1
NodeSize: 180,52
Close Using_GPT_to_clean_i
{!-40499|MsgBox("This Analytica model file contains text characters encoded in UTF-8 (Unicode) format, not ASCII. It was saved from Analytica release 6.3. You need to upgrade to Analytica 6.3 to read the model correctly. If you use it with this release, the Unicode characters may look strange and parts of the model may not work.",16,"Analytica 6.3 required")}