| WMDE-Fisch | |
| Jul 16 2019, 3:44 PM |
| F29790691: occupation_cats.txt | |
| Jul 17 2019, 9:49 AM |
Some solutions we're looking into would only work with changes on article or category pages. Lets find some number to get a rough idea on how many of them would be affected.
For the first number from de.wikipedia.org:
https://de.wikipedia.org/wiki/Kategorie:Frau =>115.072
https://de.wikipedia.org/w/index.php?search=incategory%3AFrau =>114.522
I'm going to estimate the number of gendered categories by producing a list of all occupations and country demonyms, and matching against category labels. So for example, the occupation "Arzt" will match the category "Altägyptischer Arzt".
Dump of all occupations (TODO: filter out entries without a label)
SELECT ?item ?itemLabel
WHERE
{
?item wdt:P31 wd:Q28640.
SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}Demonyms:
SELECT ?item ?itemLabel
WHERE
{
?item wdt:P31 wd:Q217438.
SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}Categories:
mysql dewiki -e 'select page_title from page where page_namespace=14' > categories.csv
Update: the demonyms are incomplete, only ten or so labels in German. I'll skip for now.
A bit of code to generate a nice fgrep pattern file, P8758
Matching is done like,
grep -E -f grep_cats.txt categories.csv
34 711 categories match, here's the full list:
A sample of 20 for manual validation:
shuf -n 20 occupations_cats.txt Hochschullehrer_(Landwirtschaftliche_Universität_Athen) Politiker_(Fehring) Bürgermeister_(Leutkirch_im_Allgäu) Fußballspieler_(Aydınspor_1923) Übersetzer_ins_Malayalam Polnischer_Meister_(Fechten) Hammerwerfer_(Usbekistan) Hochschullehrer_(Lauenburg) Politiker_(Baden-Württemberg) Beamter_(Thailand) Bürgermeister_(Erfurt) Offizier_des_Oldenburgischen_Haus-_und_Verdienstordens_des_Herzogs_Peter_Friedrich_Ludwig Kammerherr_(Russland) Maler_des_Impressionismus Hockeyspieler_(Frankfurter_Sportclub_Sachsenhausen_Forsthausstraße) Fotograf_(Graz) Fußballspieler_(AC_Juvenes/Dogana) Fußballspieler_(Paradou_AC) Jüngerer_Bürgermeister_(Reichsstadt_Frankfurt) Bürgermeister_(Münster,_Tirol)