Pakistan ToshaKhana Files

Unleashing Pakistan's Hidden Corruption by Ruling Elites

@kaggle.zusmani_pakistan_toshakhana_files

Table List

1 table(187.81 KB)

Refined Tk Data Ver 2

@kaggle.zusmani_pakistan_toshakhana_files.refined_tk_data_ver_2

187.81 KB
4214 rows
9 columns

detail_of_gifts Detail Of Gifts	item_category Item Category	name_of_recipient Name Of Recipient	affiliation Affiliation	date Date	assessed_value Assessed Value	retained Retained	remarks Remarks
Two small silver Bowls	Decoration Pieces	Mr. Abdul Sattar, Minister for Foreign Affairs	Gen. Musharrafarraf	Tue Jan 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	5000	Yes	Yes
One Pilot Pen with ink	Pen	Mr. Abdul Sattar, Minister for Foreign Affairs	Gen. Musharraf	Tue Jan 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	3500	Yes	Yes
One silver vase	Decoration Pieces	Mr. Shaukat Aziz, Minister for Finance	Gen. Musharraf	Wed Jan 09 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	7500	Yes	Yes
One (decoration) folding Screen	Decoration Pieces	Mr. Abdul Sattar, Minister for Foreign Affairs	Gen. Musharraf	Tue Jan 15 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2200	Yes	Yes
One Decoration Piece	Decoration Pieces	Mr. Abdul Sattar, Minister for Foreign Affairs	Gen. Musharraf	Tue Jan 22 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2000	Yes	Yes
One gown	Clothes	Mr. Ahmed Waqar, Secretary Privatization Commission	Gen. Musharraf	Sat Jan 26 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2500	Yes	Yes
One Coffee Set (07 pcs)	Crockery	Mr. Abdul Sattar, Minister for Foreign Affairs	Gen. Musharraf	Mon Jan 28 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	1800	Yes	Yes
Art glass decoration piece	Decoration Pieces	Mr. Shaukat Aziz, Minister for Finance	Gen. Musharraf	Fri Feb 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	1200	Yes	Yes
One leather black colour wallet	Decoration Pieces	Dr. Tariq Hassan, Advisor to Finance Minister	Gen. Musharraf	Mon Feb 04 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	150	Auctioned	Auctioned for Rs.500/-
One Pen Stand fitted with clock	Pen	Mr. Altaf M. Saleem, Minster for Privatization	Gen. Musharraf	Wed Feb 06 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	550	Auctioned	Auctioned for Rs.305/-


CREATE TABLE refined_tk_data_ver_2 (
  "detail_of_gifts" VARCHAR,
  "item_category" VARCHAR,
  "name_of_recipient" VARCHAR,
  "affiliation" VARCHAR,
  "date" TIMESTAMP,
  "assessed_value" DOUBLE,
  "retention_cost" DOUBLE,
  "retained" VARCHAR,
  "remarks" VARCHAR
);