Sugarcane
ELITE MEMBER
- Joined
- Jun 2, 2011
- Messages
- 21,105
- Reaction score
- 29
- Country
- Location
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Sir ji abhi tu ...Qatari gift report missing ha...
Report is accidently leaked by bureaucracy ...whole PDM is after those poor employees who follow the routine .....lollllllllllllllllllll....
perhaps too lateReport is accidently leaked by bureaucracy ...whole PDM is after those poor employees who follow the routine .....lollllllllllllllllllll....
AsSalam u Alaikum,
Q01: Why would anyone release the toshakhana 'dataset' in pdf format? It is as if someone wants hundred of people to waste their time taking screenshots and being stuck in manual analysis. It doesn't make sense, with all the 'Digital Pakistan' efforts going on over the years.
Q02: How come this dataset is not already part of a proper database, with a timeline and images of gifts' arrival and retention. What does that say about our other national assets if accountability couldn't be maintained for these millions of dollars of gifts?
Q03: What is the definition of a 'gift'? There are rows, certainly, but some rows have a 'vase,' for instance, while some have ten different high-value items bundled on the same row.
Q04: Who gave these gifts? That is one important piece of information completely missing from the picture. If these gifts are to lobby and influence our past and present rulers, which is usually the case, that data should also be released.
Q05: Who assesses the price of these items, and how fair and transparent is the process? Most of the items seem quite undervalued, at a glance, even without factoring in the USD over the years.
Q06: For the gifts that were auctioned off, who conducted the auction, who were the allowed participants, and why are the buyers not included in the dataset? Does 'Presented to' equal 'Bought by' if a gift is retained, or can anyone buy off anyone else's gift?
A few observations on the dataset: A lot (~323) of the gifts still don't contain the recipient's name. They do contain designations, but I'm not inclined to find out who the "Leader of the House, Senate" was at a certain date, so all such gifts are labeled "Anonymous".
One would expect spelling consistency, as this was recently digitized, but the norm seems that no two entries for the same person should match. A Muhammad Omer (just an example) is likely M. Omer, Mohammed Umar, Mohammad R. Omar, and Dr. M. Umer in different rows!
Then there are instances like Shafeq vs. Shafiq, Kureshi vs. Qureshi, Afzal vs. Afzaal, each pair for the same person, which makes this practice look either careless or deliberate. Still, I'll go with Occam's razor on this one.
The one exception to this make-all-names-different rule is 'Mr. Asif Ali Zardari', whose name is somehow meticulously accurately spelled for all 180 or so entries under his name, which is quite strange.
Around 50% of the gifts seem to have been received by ten-ish people, and 20% of the people received 80% of the total gifts (H/T Mr. Pareto), regardless of who retained what percent of those gifts. Some obvious angels retained less than 50% of their received gifts ;-)
There seem to be 1200+ watches. Some of the entries have two, or even three watches, in the same row. I have not split them up yet and have not touched the assessed and auctioned values' data, but I might do so if there is enough interest (READ retweets).
What I have attempted, though, is to consolidate all the gifts for anyone who seems to be the same person, so Dr. X, Mr. X, and Mr. M. X are merged under a single name. Any Son/Daughter/Wife of..., and gifts to people rising through the ranks are also merged.
If a row contains a list, or a list of lists, of gifts, I have split each such gift(s) into its own rows. This gives a more accurate set of counts (increased from 4000 to 6000) than the original distribution. People's salutations have also been extracted while fixing the names.
Sorting the latest sheet by the 'fgivenname' and comparing it with the 'frecipient' column should present an interesting view of how shuffled the data was. I'll merge fixes if anyone points them out - I have opened up comments on the sheet for this.
With all the party affiliation switches and horse-trading over the years, I have not bothered with identifying any individual's political party or professional capacity.
The next logical step for the cleanup would be to clean up each gift's assessed and final price. I'm open to tackling the next cleanup phase if the data, in its current state, is deemed useful by enough people, and they ask me to.
Disclaimer: I've used a mix of Python, regex, and some manual tweaking, where absolutely necessary. Mistakes and inaccuracies are expected. I'll try to fix things that are pointed out to me. The toshakhana semi-clean dataset --> ToshaKhanalysis
Then there are rows like this - where THREE items are listed, but the assessed prices of FOUR are mentioned, making the data integrity questionable.
The sheet is partially updated with the easily parsed assessed values of the gifts in the 'fassessedvalue' column. The most expensive gift so far - a Rs. 140,000,000 watch - "Displayed at the MP House". It doesn't which house, or whether it is displayed on a wrist, or in a case.
Another Rolex desired to be displayed at the PM House. Why would a recipient who does not live in the PM House 'desire' to display a Rolex in the PM House? Who in the world displays (expensive but quite common) watches in any country's PM House? "Oh, look, we got a Rolex gift?"
An innocent #toshakhana typo, that reduces the value of a set of gifts by 1/1000, from 847000 to 847.
This entry lists ONE watch but lists the prices for TWO, further increasing the confidence in the released toshakhana dataset.
'One small packet' and 'One large packet' were magically assessed to be worth Rs. 4,000, and nobody asked how.
A Ladies' Handbag for a First Lady should not be assessed at Rs. 2,000 unless the era is the 1800s. The gift-giver must have been really cheap. Even the maid at my house has a bag worth more than 2,000.
Mariam Nawaz left nothing in Toshakhana .