Wikipedia talk:WikiProject Ghana/Parliament of Ghana/Members of the 7th Parliament of the 4th Republic of Ghana

Occupation
Since they are all politicians anyway, could we remove politician from their occupation, so that occupation lists anything else they are, beside being a politician. -Masssly (talk) 14:19, 10 February 2019 (UTC)
 * Also, I'm trying to add qualifiers as columns. i.e. parliamentary group and electoral district. Thanks -Masssly (talk) 14:25, 10 February 2019 (UTC)
 * I'll do you some reports covering all of the qualifiers. --Tagishsimon (talk) 16:44, 10 February 2019 (UTC)
 * Apologies, Masssly, I was just too tired last night to begin this work. I'm going to be starting in a few minutes. I'll use this page to make some notes on whatever I do, so it'll possibly be worth it being on your watchlist. --Tagishsimon (talk) 11:41, 11 February 2019 (UTC)

I have:
 * Changed Member of the 6th Parliament of the 4th Republic of Ghana and Member of the 7th Parliament of the 4th Republic of Ghana to be subclass of Member of the Parliament of Ghana, because that item exists; previously they were subclass of Member of Parliament. Member of the Parliament of Ghana is a subclass of Member of Parliament, so that tree works. If we create new positions for other legislative periods, they should follow the pattern.
 * Now I'm checking through constituencies and, having matched the names of constituences listed at https://www.parliament.gh/mps?az with existing constituency items in wikidata, I'm
 * Renaming constituencies, where I have a basic name match, to the name used at https://www.parliament.gh/mps?az
 * Adding a Reference URL for the P31 value, pointing to the individual page under https://www.parliament.gh/mps?az
 * Adding new items for constituencies which I have not found items for.
 * That will leave us with a set of 'good' constituencies against which we can add MPs, but also a list of constituencies which have names that did not match. We'll have to deal with this list somehow, either by merging them, or putting end-dates on their P31 value (e.g. where a constituency has been split into two). So, sooner or later, I'll do two reports, of 'good' constituencies, and of the 'other' constituencies. Petscan is running right now, so it might take 10 minutes before the next move, which will be the start of comparison of MP names.
 * Initial report on 'good' constituencies.
 * Initial report on 'other' constituencies.
 * Good. Now we have 275 good constituencies. Next, I move on to MPs. This might take some time.
 * Okay. I've matched up existing MP items to the full list of 275 MPs. I need to take a break now for maybe 3 hours, and then I'll run another quickstatements session which will give us 275 MPs. After this we can look at:
 * Any further merges which might be necessary - I've been looking at items which are marked as MPs ... there may be some items matching the names of the 275 MPs, which did not have a P39 MP statement
 * Two discrepancies, of names of two ministers who I cannot find in the list of 275 MPs
 * Reports on MP items, and constituency items, looking for additional data we can add.
 * But bottom-line: we're in a good position and we really should have the majority of the work done in the next 6 to 8 hours.
 * So, now, I'm running in three quickstatement batches, the first two for existing MPs which will remove all 7thP of the 4thR P39s and then reinsert the same P39s with full details. After that I'll create items with fully qualified position statements for ~226 MPs. Then we can get on to the business of adding other properties such as P17, P106, etc. I guess the QS matches will take maybe 30 minutes or less.
 * There will be some P39 clean-up to be done; Some MPs will have 2 P39 values, Member of the 7th Parliament of the 4th Republic of Ghana and Member of the Parliament of Ghana and we should delete the second of those. But that's an easy task.

Arbitrary break


 * So, we now have 277 MPs, which is as expected, and 2 too many. Our problem children right now are Boakye Agyarko and Kweku Ofori Asiamah aka Kweku Asiamah, neither of whom I found in my Ghanain MPS spreadsheet, but both of whom are listed on en.wikipedia as being 7/4 MPs. I'll leave them both to you, Masssly. Now I'm going to get on with doing something about gender (for those for which I can from the name derive the gender), occupation, and whatever other properties occur to me. And then I'll start doing some Listeria reports.
 * Apparently this person Boakye Agyarko has a brother with a similar name. But they (Boakye Agyarko) themself is not an MP, he's brother, Kwabena Agyarko (Q59132463) already listed as an MP, is an MP. Interestingly, Q59132463 recently died, and his wife Q61697679 is now the MP for the same constituency. I've updated those 3 items appropriately. Consequently, Listeria counts both the dead MP and his wife as MP's in the 7th of 4th. I think that that's how it should be. So, instead of 275, a total of 276 MPS is now to be expected.-Masssly (talk) 22:53, 11 February 2019 (UTC)


 * Quick pointer for you, Masssly, to User_talk:Tagishsimon#Wittylama on wikidata. I get the impression you're very comfortable with getting main properties into Listeria tables, but may not yet know how to get qualifiers and reference data for main properties. The Wittylama essay explains how, and was produced for someone else who had that issue. Presuming my assumption is right, I hope it is of some use to you. As far as Listeria goes, if you can get the qualifier in the query, and the variable name is in the select, then you can the the variable name in the columns line ....
 * Your current columns line is |columns=number:#,label:Article,description,P4100,P39,P21,P106,P18,P69,P140,item
 * If we suppose we have fetched ?constituency within the query, and we have a value ?constituencyLabel in the select, then we cn add that to columns - so - |columns=number:#,label:Article,description,P4100,P39,P21,P106,P18,P69,P140,?ConstituencyLabel,item ... anyway, we'll get to that once I've added some more properties.

Another arbitrary break
 * I've done most of what I'm going to do, except perhaps for some more reports, and some Aliases where existing items have labels that differ from names on the Parliament website.
 * Quite a few items need gender
 * And I need to do the WikiProject every politician section for Ghana.
 * But you have a good base to start from
 * Constituencies could probably do with some sort of P131 - located in the administrative territorial entity property and maybe we should provide short-name aliases for them.
 * I had to reread what you meant to say here to get it. I agree :) The important word for the label would be the first word. Eg. Mion Constituency, Northern Region (Q16733862). The alias will simply be Mion, or Mion Constituency. Some participants at the editathon might be interested to work on particular regions, or I may put them in teams based on regions. Therefore, since the table is sortable, another (separate) column showing the region of the constituency would be helpful. -Masssly (talk) 22:17, 11 February 2019 (UTC)


 * Let me know if you have any concerns or want to discuss anything.


 * this is how you change column headings in Listeria :)

Comments 1
Wow, thanks so much for this. Here are my initial thoughts, (more coming as I go through). -Masssly (talk) 22:05, 11 February 2019 (UTC)


 * 1. If Occupation is politician, let’s ignore it.


 * Agreed - you only want to see their other occupations in the table. Equally, wikidata wants to see that all MPs have an occupation=politician. Still, we know that is now covered, and so the table can & should be changed. I say can - not quite sure how to just now, but I'll have a think about it.


 * Now done.


 * 2. About the second column (label:Article), most are not linked yet. If linked, some will be red because those (red) articles don’t yet exist on WP. Fine! I could use AWB to create stubs for those. My upcoming editathon would subsequently add flesh and destub those AWB generated WP articles. Now, while some of these would-be (red listed) articles currently exist on WP with the same name as in this Listeria generated list. Some however, would still exist on WP but under slightly different titles. Those would still be red. How would you suggest that I deal with those.


 * It's an interesting question how many of the to-be redlisted names will have articles on en.wikipedia already ... at a rough count, all of the 68 MPs in Category:Ghanaian MPs 2013–17 are linked in our table, which is to say their article is sitelied from the item we use in the table, which is as it should be. I suppose the question back to you right now is, if you think there may exist articles for people on our list, which are not right now showing up as blue links, which en.wiki category might we find such articles in? Perhaps answering my own question I guess in Category:21st-century Ghanaian politicians or one of its subcategories? I'm afraid I think the best thing to do will be to produce a list of all of the names found in these categories, and any other categories you want to suggest; and to compare that list of names with the list of names from out table. THat is probably best done in a spreadsheet, and maybe I'll do that today or in the next few days.
 * If there are such articles, they will have their own item, and so in wikidata we'll need to merge the two items (The item pointing to the existing article, with the item used by our table) and by doing to, the redlink will turn blue.
 * I need to start by providing you with redlinks rather than unlinked names. Let me have a look at that now. - Now done.


 * I've compared all names in Category:21st-century Ghanaian politicians and all subcategories; I found 6 people and merged them, so they now show in our list as blue. You could maybe go through Category:20th-century Ghanaian politicians but maybe it is not so likely that someone is featured in 16+ year old lists, but not in the more modern categories. I don't know.


 * 3. Page size. Can we add column for Page Size of the Wikipedia Article. I'd once used this tool before to count readable prose. Readable prose would be the most relevant thing to know about as we destub the WP articles. But if that's not possible (without going into the article to activate the script to check), then File size or Wiki text can also be useful to have. — Preceding unsigned comment added by Masssly (talk • contribs) 23:34, 11 February 2019 (UTC)


 * There is no possibility of that from Listeria, I'm afraid. We can take a Listeria list and make a static copy of it so that you can add data by hand; that's about my best suggestion.


 * 4. These two look like the same person. If so the wikipedia articles need to be merged, and then the same for the wikidata items: Nii Okaidja Adamafio and Nii Okaija Adamafio.
 * Good catch. One is an alternative spelling, which I've turn now into a redirect on WP. On Wikidata when I try to merge I get the error A conflict detected on enwiki: Q7034344 with enwiki:Nii Okaidja Adamafio, Q16733387 with enwiki:Nii Okaija Adamafio -Masssly (talk) 10:24, 12 February 2019 (UTC)
 * Needed to delete the en.wiki sitelink on the item attached to the now-redirct. Then they merge. Done.


 * 5. I've been going through this useful report - everyone with Ghanaian citizenship, according to Wikidata. I found a few more merges. If you run it and have a look though, you might spot things that I have not. As a side-project, where there are two people with the same name and profession (e.g. both footballers) it is useful to include the date of birth and death in the description so that others who find both items from a search know instantly that they are different people. Oh, and then this Ghanaian citizens with "politician" in their description


 * 6. I suspect these two are the same person, but I have no basis for merging them. Over to you: https://www.wikidata.org/wiki/Q61694731 and https://www.wikidata.org/wiki/Q16733693
 * Correct and done


 * 7. Here's another thing. Remembering that the useful deduplication reports in point 5, above, are based on Country of Citizenship ... here's a petscan looking at items for humans with articles found under Category:Ghanaian people, where the item does not have a P27 Country of Citizenship statement. (If you get a 502 error, run it again until you don't). I think if you want to do a proper deduplication of Ghana people items, which will help to stop more duplicate creation based on redlists such as the one we have just created, it would be ideal to get P27 values on these items. Whether they are all citizens of Ghana, I don't know. It's one more thing that someone at an editaton, or you, could so. And then having done it, run the reports at point 5, above, again, and you'll probably find more duplicates. Here is a small petscan looking just at Ghanaian politician people articles where the item has no P27 country of citizenship - These are the most urgent items in need of P27=Ghana (presuming they are Ghanaian), if you want the reports produced in Point 5 to do their work. (Late news: I've coded a few hundred more people as P27=Ghana, and done some more merges. You looking through the reports at point 5 continues to be a good idea, as does getting as much more of the P27 coding done as possible.)


 * 8. Manually checking that the red article links really do not have an EN:WP entry. Some (eg. Q4723552 and Q4723552) actually do, just that they are titled differently. I'm fixing them. -Masssly (talk) 01:22, 13 February 2019 (UTC)


 * 9. Thanks for   & . The SPARQL query has now become too complicated to play with :) I was actually aiming to do away with the "Party" column, and replace it with the "alias of Political party". i.e, to replace the label "National Democratic Congress" with NDC, and "New Patriotic Party" with NPP. Done


 * 10. Also, to do same in 9 above for constituency, i.e. to replace for example "Wa Central Constituency, Upper West Region" with "Wa Central Constituency". Done


 * 11. Finally, to make it easy to sort based on regions, can we have an entirely new column for the "Region", as in example "Upper West Region", "Upper East Region", etc.
 * I've added the column and added P131 values to all constituencies. You'll see that some constituencies have multiple P131s ... that's something you maybe want to look at.
 * Right. I think that is happening because located in the administrative territorial entity (P131) is
 * Accepting cities (Q515) which obviously shouldn't be there. You'd even notice the error that those statements have potential issues. I will remove them.
 * Accepting both Districts and Regions. That doesn't hurt the report anyway. Either only regions, or regions + districts works fine for me. -Masssly (talk) 14:32, 13 February 2019 (UTC)


 * I've filtered out cities and districts from the live list. If you want to fix the issues, they're listed on this historical version or on this report.


 * 12. I presume https://www.wikidata.org/wiki/Q61694673 and https://www.wikidata.org/wiki/Q35562144 are the same person, but I cannot tell from the enwiki article attached to the latter - Osei Bonsu Amoah. So, Masssly, yours to merge.
 * Same person. Done -Masssly (talk) 22:16, 13 February 2019 (UTC)

Comments 2

 * 13. Lots of the MP wikipedia articles have no references, and so have been marked with Prod BLP - that needs fixing... list here
 * These have now been fixed by . -Masssly (talk) 10:17, 17 February 2019 (UTC)


 * Good work adding those refs. Now three more things to point out: 1) Many of the articles need DEFAULTSORT adding to them, since they're listed at Category:Ghanaian MPs 2017– by their first name not their family name, and 2) that category only lists 208 of the 275, so 67 are missing the category 3) New articles need linking to their wikidata items. Although they're showing up as bluelinks, this is only because Listeria is broken. Right now we have a couple of hundred which are not linked. The risk is that new items are created for them leaving us with a merge task to complete. Also worth mentioning - Listeria is dead until circa 26/02/2019, and so there will be no updates of this members list until then. --Tagishsimon (talk) 11:25, 17 February 2019 (UTC)


 * I've done MPs 171 through to the end; am slowly working backwards up the list.
 * All MP articles are now linked to their wikidata item. --Tagishsimon (talk) 17:21, 17 February 2019 (UTC)


 * 14. Looks to me like we've added the membership of the 7P of the 4R to https://www.wikidata.org/wiki/Q5960304 in error - the subject of this wikidata item was active in the 1960s. So we probably need a new item, and a new article, and to remove the DoB and position statement from Q5960304. --Tagishsimon (talk) 11:36, 17 February 2019 (UTC)
 * Now fixed. --Tagishsimon (talk) 18:08, 17 February 2019 (UTC)
 * There appear to be some confusion here :) The subject is actually called Brako, and not Baako.-Masssly (talk) 21:05, 17 February 2019 (UTC)
 * oh dear :) I hope it's all sorted now! --Tagishsimon (talk) 21:14, 17 February 2019 (UTC)


 * 15 I knew this wouldn't work, but it was worth the try :) Pls take a look. -Masssly (talk) 23:20, 21 February 2019 (UTC)


 * done. I'm looking forward to seeing what happens during and after your editathon. Wish I was there ;) --Tagishsimon (talk) 00:04, 22 February 2019 (UTC)


 * Last weekend's editathon went well. Not much was accomplished with regards to edits though, but I feel that I made some progress with training of participants, majority of whom were new to any Wikimedia project. I quickly realised that Wikidata may be easier to edit, but much harder to explain to newbies, about why they should edit (or why it's relevant). Much of the time was spent on training. I'm expecting the same participant cohort to attend the subsequent events on April 25 and May 25. Likely, we can have all the empty cells filled up. -Masssly (talk) 13:54, 3 March 2019 (UTC)
 * I saw the photos on Twitter; a very good turn-out. Wikidata is hard to explain; I wonder, sometimes, why I spend so much time on it ... it's not something that delivers much to the end-user, in the way that a wikipedia article does. But small steps are also important, Masssly, and you've done good work to get us this far. I look forward to the next two editathons, although end-April feels a long way away. Here are a couple of new reports which might help your users understand some of the value of structured data. Would be interesting to do these for e.g. place of birth, or region of birth. --Tagishsimon (talk) 17:55, 3 March 2019 (UTC)


 * Where were MPs educated?
 * What was their occupation.
 * Thanks! I happen to be ambassador for Arts+Feminism in West Africa, and March is our "very busy" month, reason why I pushed my editathons to April and May. Interesting point about using reports to excite users, I'll try that next time. Indeed, place of birth, or region of birth reports would be very interesting too. We'd add those statements to Wikidata in our next sessions. Other reports I know would be very interesting to users is


 * a chart that compares country of education of MP's (whether they were educated in Ghana or out of Ghana), ie, say two frequency bars, one bar counts schools in Ghana and the other counts schools out of Ghana


 * a bubble chart of the countries where their schools are located.


 * By the way, I'm happy to know that you heard the noise we made about the editathon from all the way :) What's your twitter handle, mine is @masssly. -Masssly (talk) 21:30, 3 March 2019 (UTC)

Doubles and troubles
I notice that there are now many doublures in the voting districts.. They have as their incumbent the present MP. Also the approach of having one line item per session of parliament is wrong. The position is not "member of 7th parliament" (just ask them) they are a member of parliament of ghana. That is it. A particular session of parliament is only relevant in its election. Thanks, GerardM (talk) 05:06, 12 February 2019 (UTC)


 * See https://www.wikidata.org/wiki/Wikidata:WikiProject_every_politician/Political_data_model#Approach_5 - the use of "member of 7th parliament" is an accepted coding - see, for instance, all Biriths MP items. If you ask one of the MPs, are you a member of the 7th parliament of the 4th republic, they will say yes. So, not wrong, though perhaps not to everyones taste. It has been discussed, iirc, in the Political data model talk page, or anothe page of that prpject, and in the edit summaries. I know Jura1 is not a fan.


 * There were existing parliamentairians you remove them for something that is inferior. It is one thing to start from scratch there were many people already known as parliamentarian


 * I don't grok exactly what you mean when you say "there are now many doublures in the voting districts". Constituencies are not duplicated. There are two reports, above, of a) 2016-7 constituencies, the majority of which are pre-existing items renamed to follow the source naming convention, and a minority of which aew new constituencies arising out of splitting existing constituencies into e.g. North & South for the 2017 (or indeed an earlier) period; and b) constituencies which are deprecated from whenever they were replaced. If instead you mean that some MPs have two P39 statemenets covering the same legislative period, when they should have one; that was noted in the running notes above as an outstanding task which has not yet been addressed as this is a work in progress. Such duplicates will be removed sometime soon. --Tagishsimon (talk) 09:13, 12 February 2019 (UTC)


 * How about new voting districts that already existed and already have a Wikidata ID?


 * Are you aware of any I missed? These two queries might help:
 * Initial report on 'good' constituencies.
 * Initial report on 'other' constituencies.
 * But the most recently created item in the 'other' list was created on 21 March 2013‎. So presuming the item had P31=Q41760643 ... I dunno, Gerard. It feels like you're being a griefer, to be honest. You've alleged that there are duplicate constituencies, without evidence, and in the absence of any obvious duplicates. You've kvetched about the nature of the position statement, although member of the nth parliament is in widespread use on wikidata. And you're waving your hands around about regions and districts, below, again with no particular relation to the practice of categorisation in Ghana - which is to nest constituencies directly into regions, rather than into districts. It's not helpful. It is stressful. It is pointless. Why are you doing this? What point are you trying to make?

Constituencies are part of a district
I was fixing constituencies that are part of a region.. the lowest level is what we should follow is the district. Thanks, GerardM (talk) 05:15, 12 February 2019 (UTC)


 * I've not looked at this. I suspect we should follow the Ghanaian administrative decomposition; I got the sense from the naming that Constituencies were organised into Regions, but I've not looked at this in detail. The need to deal with P131s was noted above. --Tagishsimon (talk) 09:13, 12 February 2019 (UTC)


 * Exactly a region is comprised of districts and a district is comprised of constituencies.


 * Only if constituencies are coterminous with districts. And there's no evidence of that that I can find - although they may be. The Parliament nests constituencies directly within regions. Absent any data to enable region->district->constituency, we'll be going with the source, if it's all the same to you.


 * Well there is the English Wikipedia list of constituencies were they are linked to districts and no, it is not all the same to me. You are implementing a substandard set of data, that fact was established earlier replacing what was already there. Now you assume that you have the source / are the source and get it wrong. Wonderful. Thanks, no thanks GerardM (talk) 15:16, 17 February 2019 (UTC)


 * Nothing has been replaced. Really, Gerard, what the fuck are you on about? It's just a constant stream of diarrhea of unsubstantiated accusations from you, with no evidence, no links, nothing. Existing constituency wikidata items continue to exist and have been used as the electoral district to which the MPs have been assigned. No P131 districts have been removed from them. No duplicate items have been created, beyond the occasional MP item which has subsequently been merged. For the future, perhaps do us the courtesy of pointing, with a link, to whatever you think the problem is, and we can do some constructive business. As to structure and sources: I've already indicated that if a source can be found that nests 2017 constituencies within districts, it would be appropriate to follow that pattern. Absent such a list, we will use what sources we have. You seem to be suggesting that the Parliament of Ghana website is not a source? Thats ... stupid, just really really stupid and unsupportable. Just more mud throwing. Finally, nothing at all is stopping you from adding districts to constituency items, should you choose to do so. However it seems you'd rather spend your time making deranged accusations on this page. --Tagishsimon (talk) 15:58, 17 February 2019 (UTC)

So here's a challenge, Gerard. Point me to a SINGLE instance of me "replacing what was already there", or a SINGLE instance of me duplicating an existing constituency or a SINGLE instance of me removing a district P131 from a constituency. In other words, a SINGLE example to back up your relentless and wholly false accusations. And if not, just please go away and stop wasting my time. --Tagishsimon (talk) 17:23, 17 February 2019 (UTC)