MediaWiki
Difference between revisions of "LanguagesGenderData.js"
m |
m (Yug moved page MediaWiki:LanguagesGendersData.js to MediaWiki:LanguagesGenderData.js without leaving a redirect) |
||
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
/* ************** | /* ************** | ||
− | SELECT ?languageLabel ?wikidata ?iso ? | + | SELECT ?languageLabel ?wikidata ?iso ?malesCount ?malesRecords ?femalesCount ?femalesRecords |
(ROUND(1000*?femalesRecords/(?femalesRecords+?malesRecords))/10 AS ?percent) | (ROUND(1000*?femalesRecords/(?femalesRecords+?malesRecords))/10 AS ?percent) | ||
WITH { | WITH { | ||
Line 9: | Line 9: | ||
?language prop:P12 ?wikidata . # Assign value: P12 'wikidata id' into ?wikidata | ?language prop:P12 ?wikidata . # Assign value: P12 'wikidata id' into ?wikidata | ||
OPTIONAL { ?language prop:P13 ?iso . } # Assign value: P13 'iso639-3' into ?iso | OPTIONAL { ?language prop:P13 ?iso . } # Assign value: P13 'iso639-3' into ?iso | ||
+ | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | ||
} | } | ||
GROUP BY ?language ?languageLabel ?wikidata ?iso | GROUP BY ?language ?languageLabel ?wikidata ?iso | ||
Line 14: | Line 15: | ||
WITH { | WITH { | ||
SELECT ?language ?languageLabel ?iso ?genderLabel | SELECT ?language ?languageLabel ?iso ?genderLabel | ||
− | (COUNT(DISTINCT ?females) AS ? | + | (COUNT(DISTINCT ?females) AS ?femalesCount) |
(COUNT(DISTINCT ?record) AS ?femalesRecords) { | (COUNT(DISTINCT ?record) AS ?femalesRecords) { | ||
INCLUDE %base | INCLUDE %base | ||
Line 23: | Line 24: | ||
} GROUP BY ?language ?languageLabel ?iso ?genderLabel | } GROUP BY ?language ?languageLabel ?iso ?genderLabel | ||
} AS %females | } AS %females | ||
− | |||
WITH { | WITH { | ||
SELECT ?language ?languageLabel ?iso ?genderLabel | SELECT ?language ?languageLabel ?iso ?genderLabel | ||
− | (COUNT(DISTINCT ?males) AS ? | + | (COUNT(DISTINCT ?males) AS ?malesCount) |
(COUNT(DISTINCT ?record) AS ?malesRecords) { | (COUNT(DISTINCT ?record) AS ?malesRecords) { | ||
INCLUDE %base | INCLUDE %base | ||
Line 41: | Line 41: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } | ||
} | } | ||
− | GROUP BY ?languageLabel ?wikidata ?iso ? | + | GROUP BY ?languageLabel ?wikidata ?iso ?malesCount ?malesRecords ?femalesCount ?femalesRecords |
ORDER BY ASC(?languageLabel ) | ORDER BY ASC(?languageLabel ) | ||
************** */ | ************** */ | ||
Line 49: | Line 49: | ||
"wikidata": "Q56499", | "wikidata": "Q56499", | ||
"iso": "arq", | "iso": "arq", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "234", | "malesRecords": "234", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "5", | "femalesRecords": "5", | ||
"percent": "2.1" | "percent": "2.1" | ||
Line 59: | Line 59: | ||
"wikidata": "Q28244", | "wikidata": "Q28244", | ||
"iso": "amh", | "iso": "amh", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "8", | "malesRecords": "8", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "209", | "femalesRecords": "209", | ||
"percent": "96.3" | "percent": "96.3" | ||
Line 69: | Line 69: | ||
"wikidata": "Q13955", | "wikidata": "Q13955", | ||
"iso": "ara", | "iso": "ara", | ||
− | " | + | "malesCount": "12", |
"malesRecords": "5627", | "malesRecords": "5627", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "9", | "femalesRecords": "9", | ||
"percent": "0.2" | "percent": "0.2" | ||
Line 79: | Line 79: | ||
"wikidata": "Q56590", | "wikidata": "Q56590", | ||
"iso": "atj", | "iso": "atj", | ||
− | " | + | "malesCount": "2", |
− | "malesRecords": " | + | "malesRecords": "45", |
− | " | + | "femalesCount": "1", |
"femalesRecords": "432", | "femalesRecords": "432", | ||
− | "percent": "90. | + | "percent": "90.6" |
}, | }, | ||
{ | { | ||
Line 89: | Line 89: | ||
"wikidata": "Q33070", | "wikidata": "Q33070", | ||
"iso": "ban", | "iso": "ban", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "196", | "malesRecords": "196", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "302", | "femalesRecords": "302", | ||
"percent": "60.6" | "percent": "60.6" | ||
Line 99: | Line 99: | ||
"wikidata": "Q35107", | "wikidata": "Q35107", | ||
"iso": "bci", | "iso": "bci", | ||
− | " | + | "malesCount": "4", |
"malesRecords": "60", | "malesRecords": "60", | ||
− | " | + | "femalesCount": "3", |
"femalesRecords": "33", | "femalesRecords": "33", | ||
"percent": "35.5" | "percent": "35.5" | ||
Line 109: | Line 109: | ||
"wikidata": "Q8752", | "wikidata": "Q8752", | ||
"iso": "eus", | "iso": "eus", | ||
− | " | + | "malesCount": "4", |
− | "malesRecords": " | + | "malesRecords": "3114", |
− | " | + | "femalesCount": "4", |
− | "femalesRecords": " | + | "femalesRecords": "385", |
− | "percent": " | + | "percent": "11" |
}, | }, | ||
{ | { | ||
Line 119: | Line 119: | ||
"wikidata": "Q35455", | "wikidata": "Q35455", | ||
"iso": "bik", | "iso": "bik", | ||
− | " | + | "malesCount": "3", |
− | "malesRecords": " | + | "malesRecords": "933", |
− | " | + | "femalesCount": "3", |
− | "femalesRecords": " | + | "femalesRecords": "489", |
− | "percent": " | + | "percent": "34.4" |
}, | }, | ||
{ | { | ||
Line 129: | Line 129: | ||
"wikidata": "Q9186", | "wikidata": "Q9186", | ||
"iso": "yue", | "iso": "yue", | ||
− | " | + | "malesCount": "3", |
− | "malesRecords": " | + | "malesRecords": "319", |
− | " | + | "femalesCount": "1", |
"femalesRecords": "5393", | "femalesRecords": "5393", | ||
− | "percent": "94. | + | "percent": "94.4" |
}, | }, | ||
{ | { | ||
Line 139: | Line 139: | ||
"wikidata": "Q33284", | "wikidata": "Q33284", | ||
"iso": "bcl", | "iso": "bcl", | ||
− | " | + | "malesCount": "3", |
"malesRecords": "17", | "malesRecords": "17", | ||
− | " | + | "femalesCount": "2", |
− | "femalesRecords": " | + | "femalesRecords": "79", |
− | "percent": " | + | "percent": "82.3" |
}, | }, | ||
{ | { | ||
Line 149: | Line 149: | ||
"wikidata": "Q7850", | "wikidata": "Q7850", | ||
"iso": "zho", | "iso": "zho", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "3", | "malesRecords": "3", | ||
− | " | + | "femalesCount": "4", |
"femalesRecords": "184", | "femalesRecords": "184", | ||
"percent": "98.4" | "percent": "98.4" | ||
Line 159: | Line 159: | ||
"wikidata": "Q25289", | "wikidata": "Q25289", | ||
"iso": "cor", | "iso": "cor", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "9", | "malesRecords": "9", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "139", | "femalesRecords": "139", | ||
"percent": "93.9" | "percent": "93.9" | ||
Line 169: | Line 169: | ||
"wikidata": "Q32706", | "wikidata": "Q32706", | ||
"iso": "dyu", | "iso": "dyu", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "47", | "malesRecords": "47", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "16", | "femalesRecords": "16", | ||
"percent": "25.4" | "percent": "25.4" | ||
+ | }, | ||
+ | { | ||
+ | "languageLabel": "Dutch", | ||
+ | "wikidata": "Q7411", | ||
+ | "iso": "nld", | ||
+ | "malesCount": "3", | ||
+ | "malesRecords": "231", | ||
+ | "femalesCount": "1", | ||
+ | "femalesRecords": "291", | ||
+ | "percent": "55.7" | ||
}, | }, | ||
{ | { | ||
Line 179: | Line 189: | ||
"wikidata": "Q1860", | "wikidata": "Q1860", | ||
"iso": "eng", | "iso": "eng", | ||
− | " | + | "malesCount": "54", |
− | "malesRecords": " | + | "malesRecords": "20494", |
− | " | + | "femalesCount": "10", |
− | "femalesRecords": " | + | "femalesRecords": "1605", |
− | "percent": " | + | "percent": "7.3" |
}, | }, | ||
{ | { | ||
Line 189: | Line 199: | ||
"wikidata": "Q1412", | "wikidata": "Q1412", | ||
"iso": "fin", | "iso": "fin", | ||
− | " | + | "malesCount": "2", |
− | "malesRecords": " | + | "malesRecords": "853", |
− | " | + | "femalesCount": "2", |
"femalesRecords": "48", | "femalesRecords": "48", | ||
− | "percent": " | + | "percent": "5.3" |
}, | }, | ||
{ | { | ||
Line 199: | Line 209: | ||
"wikidata": "Q33291", | "wikidata": "Q33291", | ||
"iso": "fon", | "iso": "fon", | ||
− | " | + | "malesCount": "4", |
"malesRecords": "361", | "malesRecords": "361", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "2", | "femalesRecords": "2", | ||
"percent": "0.6" | "percent": "0.6" | ||
Line 209: | Line 219: | ||
"wikidata": "Q150", | "wikidata": "Q150", | ||
"iso": "fra", | "iso": "fra", | ||
− | " | + | "malesCount": "189", |
− | "malesRecords": " | + | "malesRecords": "225972", |
− | " | + | "femalesCount": "95", |
− | "femalesRecords": " | + | "femalesRecords": "17398", |
− | "percent": "7. | + | "percent": "7.1" |
}, | }, | ||
{ | { | ||
Line 219: | Line 229: | ||
"wikidata": "Q33302", | "wikidata": "Q33302", | ||
"iso": "fsl", | "iso": "fsl", | ||
− | " | + | "malesCount": "3", |
− | "malesRecords": " | + | "malesRecords": "15", |
− | " | + | "femalesCount": "1", |
"femalesRecords": "570", | "femalesRecords": "570", | ||
− | "percent": " | + | "percent": "97.4" |
}, | }, | ||
{ | { | ||
Line 229: | Line 239: | ||
"wikidata": "Q9307", | "wikidata": "Q9307", | ||
"iso": "glg", | "iso": "glg", | ||
− | " | + | "malesCount": "3", |
"malesRecords": "28", | "malesRecords": "28", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "6", | "femalesRecords": "6", | ||
"percent": "17.6" | "percent": "17.6" | ||
Line 239: | Line 249: | ||
"wikidata": "Q188", | "wikidata": "Q188", | ||
"iso": "deu", | "iso": "deu", | ||
− | " | + | "malesCount": "29", |
− | "malesRecords": " | + | "malesRecords": "11022", |
− | " | + | "femalesCount": "8", |
− | "femalesRecords": " | + | "femalesRecords": "4172", |
− | "percent": " | + | "percent": "27.5" |
}, | }, | ||
{ | { | ||
Line 249: | Line 259: | ||
"wikidata": "Q35271", | "wikidata": "Q35271", | ||
"iso": "bbj", | "iso": "bbj", | ||
− | " | + | "malesCount": "3", |
"malesRecords": "91", | "malesRecords": "91", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "96", | "femalesRecords": "96", | ||
"percent": "51.3" | "percent": "51.3" | ||
Line 259: | Line 269: | ||
"wikidata": "Q9129", | "wikidata": "Q9129", | ||
"iso": "gre", | "iso": "gre", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "5", | "malesRecords": "5", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "13", | "femalesRecords": "13", | ||
"percent": "72.2" | "percent": "72.2" | ||
Line 269: | Line 279: | ||
"wikidata": "Q33491", | "wikidata": "Q33491", | ||
"iso": "hat", | "iso": "hat", | ||
− | " | + | "malesCount": "4", |
− | "malesRecords": " | + | "malesRecords": "21", |
− | " | + | "femalesCount": "2", |
"femalesRecords": "8", | "femalesRecords": "8", | ||
− | "percent": " | + | "percent": "27.6" |
}, | }, | ||
{ | { | ||
Line 279: | Line 289: | ||
"wikidata": "Q33578", | "wikidata": "Q33578", | ||
"iso": "ibo", | "iso": "ibo", | ||
− | " | + | "malesCount": "6", |
− | "malesRecords": " | + | "malesRecords": "35", |
− | " | + | "femalesCount": "12", |
− | "femalesRecords": " | + | "femalesRecords": "1055", |
− | "percent": " | + | "percent": "96.8" |
}, | }, | ||
{ | { | ||
Line 289: | Line 299: | ||
"wikidata": "Q9240", | "wikidata": "Q9240", | ||
"iso": "ind", | "iso": "ind", | ||
− | " | + | "malesCount": "6", |
− | "malesRecords": " | + | "malesRecords": "391", |
− | " | + | "femalesCount": "1", |
"femalesRecords": "5", | "femalesRecords": "5", | ||
− | "percent": " | + | "percent": "1.3" |
+ | }, | ||
+ | { | ||
+ | "languageLabel": "Irish", | ||
+ | "wikidata": "Q9142", | ||
+ | "iso": "gle", | ||
+ | "malesCount": "2", | ||
+ | "malesRecords": "558", | ||
+ | "femalesCount": "2", | ||
+ | "femalesRecords": "32", | ||
+ | "percent": "5.4" | ||
}, | }, | ||
{ | { | ||
Line 299: | Line 319: | ||
"wikidata": "Q652", | "wikidata": "Q652", | ||
"iso": "ita", | "iso": "ita", | ||
− | " | + | "malesCount": "5", |
− | "malesRecords": " | + | "malesRecords": "3606", |
− | " | + | "femalesCount": "1", |
− | "femalesRecords": " | + | "femalesRecords": "879", |
− | "percent": " | + | "percent": "19.6" |
}, | }, | ||
{ | { | ||
Line 309: | Line 329: | ||
"wikidata": "Q33673", | "wikidata": "Q33673", | ||
"iso": "kan", | "iso": "kan", | ||
− | " | + | "malesCount": "6", |
"malesRecords": "329", | "malesRecords": "329", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "158", | "femalesRecords": "158", | ||
"percent": "32.4" | "percent": "32.4" | ||
Line 319: | Line 339: | ||
"wikidata": "Q35115", | "wikidata": "Q35115", | ||
"iso": "cak", | "iso": "cak", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "42", | "malesRecords": "42", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "3", | "femalesRecords": "3", | ||
"percent": "6.7" | "percent": "6.7" | ||
Line 329: | Line 349: | ||
"wikidata": "Q9176", | "wikidata": "Q9176", | ||
"iso": "kor", | "iso": "kor", | ||
− | " | + | "malesCount": "1", |
− | "malesRecords": " | + | "malesRecords": "122", |
− | " | + | "femalesCount": "1", |
"femalesRecords": "2", | "femalesRecords": "2", | ||
− | "percent": " | + | "percent": "1.6" |
}, | }, | ||
{ | { | ||
Line 339: | Line 359: | ||
"wikidata": "Q36368", | "wikidata": "Q36368", | ||
"iso": "kur", | "iso": "kur", | ||
− | " | + | "malesCount": "3", |
"malesRecords": "205", | "malesRecords": "205", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "382", | "femalesRecords": "382", | ||
"percent": "65.1" | "percent": "65.1" | ||
Line 349: | Line 369: | ||
"wikidata": "Q9192", | "wikidata": "Q9192", | ||
"iso": "cmn", | "iso": "cmn", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "15", | "malesRecords": "15", | ||
− | " | + | "femalesCount": "4", |
"femalesRecords": "814", | "femalesRecords": "814", | ||
"percent": "98.2" | "percent": "98.2" | ||
Line 359: | Line 379: | ||
"wikidata": "Q1571", | "wikidata": "Q1571", | ||
"iso": "mar", | "iso": "mar", | ||
− | " | + | "malesCount": "4", |
− | "malesRecords": " | + | "malesRecords": "1357", |
− | " | + | "femalesCount": "27", |
"femalesRecords": "13153", | "femalesRecords": "13153", | ||
− | "percent": " | + | "percent": "90.6" |
}, | }, | ||
{ | { | ||
"languageLabel": "Martinique Creole", | "languageLabel": "Martinique Creole", | ||
"wikidata": "Q3006281", | "wikidata": "Q3006281", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "25", | "malesRecords": "25", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "25", | "femalesRecords": "25", | ||
"percent": "50" | "percent": "50" | ||
Line 378: | Line 398: | ||
"wikidata": "Q56426", | "wikidata": "Q56426", | ||
"iso": "ary", | "iso": "ary", | ||
− | " | + | "malesCount": "6", |
"malesRecords": "1184", | "malesRecords": "1184", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "102", | "femalesRecords": "102", | ||
"percent": "7.9" | "percent": "7.9" | ||
Line 388: | Line 408: | ||
"wikidata": "Q14185", | "wikidata": "Q14185", | ||
"iso": "oci", | "iso": "oci", | ||
− | " | + | "malesCount": "5", |
− | "malesRecords": " | + | "malesRecords": "139", |
− | " | + | "femalesCount": "1", |
"femalesRecords": "67", | "femalesRecords": "67", | ||
− | "percent": "32. | + | "percent": "32.5" |
}, | }, | ||
{ | { | ||
Line 398: | Line 418: | ||
"wikidata": "Q33810", | "wikidata": "Q33810", | ||
"iso": "ori", | "iso": "ori", | ||
− | " | + | "malesCount": "4", |
− | "malesRecords": " | + | "malesRecords": "52709", |
− | " | + | "femalesCount": "1", |
"femalesRecords": "2", | "femalesRecords": "2", | ||
"percent": "0" | "percent": "0" | ||
Line 408: | Line 428: | ||
"wikidata": "Q9168", | "wikidata": "Q9168", | ||
"iso": "fas", | "iso": "fas", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "72", | "malesRecords": "72", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "811", | "femalesRecords": "811", | ||
"percent": "91.8" | "percent": "91.8" | ||
+ | }, | ||
+ | { | ||
+ | "languageLabel": "Picard", | ||
+ | "wikidata": "Q34024", | ||
+ | "iso": "pcd", | ||
+ | "malesCount": "4", | ||
+ | "malesRecords": "26", | ||
+ | "femalesCount": "18", | ||
+ | "femalesRecords": "104", | ||
+ | "percent": "80" | ||
}, | }, | ||
{ | { | ||
Line 418: | Line 448: | ||
"wikidata": "Q809", | "wikidata": "Q809", | ||
"iso": "pol", | "iso": "pol", | ||
− | " | + | "malesCount": "11", |
− | "malesRecords": " | + | "malesRecords": "70634", |
− | " | + | "femalesCount": "3", |
− | "femalesRecords": " | + | "femalesRecords": "13699", |
− | "percent": " | + | "percent": "16.2" |
}, | }, | ||
{ | { | ||
Line 428: | Line 458: | ||
"wikidata": "Q5146", | "wikidata": "Q5146", | ||
"iso": "por", | "iso": "por", | ||
− | " | + | "malesCount": "5", |
− | "malesRecords": " | + | "malesRecords": "3268", |
− | " | + | "femalesCount": "3", |
− | "femalesRecords": " | + | "femalesRecords": "2521", |
− | "percent": " | + | "percent": "43.5" |
}, | }, | ||
{ | { | ||
Line 438: | Line 468: | ||
"wikidata": "Q58635", | "wikidata": "Q58635", | ||
"iso": "pan", | "iso": "pan", | ||
− | " | + | "malesCount": "5", |
"malesRecords": "3979", | "malesRecords": "3979", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "326", | "femalesRecords": "326", | ||
"percent": "7.6" | "percent": "7.6" | ||
Line 448: | Line 478: | ||
"wikidata": "Q7913", | "wikidata": "Q7913", | ||
"iso": "ron", | "iso": "ron", | ||
− | " | + | "malesCount": "4", |
"malesRecords": "16959", | "malesRecords": "16959", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "2442", | "femalesRecords": "2442", | ||
"percent": "12.6" | "percent": "12.6" | ||
Line 458: | Line 488: | ||
"wikidata": "Q7737", | "wikidata": "Q7737", | ||
"iso": "rus", | "iso": "rus", | ||
− | " | + | "malesCount": "16", |
"malesRecords": "5406", | "malesRecords": "5406", | ||
− | " | + | "femalesCount": "10", |
"femalesRecords": "3186", | "femalesRecords": "3186", | ||
"percent": "37.1" | "percent": "37.1" | ||
Line 468: | Line 498: | ||
"wikidata": "Q33965", | "wikidata": "Q33965", | ||
"iso": "sat", | "iso": "sat", | ||
− | " | + | "malesCount": "7", |
"malesRecords": "397", | "malesRecords": "397", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "150", | "femalesRecords": "150", | ||
"percent": "27.4" | "percent": "27.4" | ||
Line 478: | Line 508: | ||
"wikidata": "Q33274", | "wikidata": "Q33274", | ||
"iso": "shy", | "iso": "shy", | ||
− | " | + | "malesCount": "6", |
"malesRecords": "1729", | "malesRecords": "1729", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "1", | "femalesRecords": "1", | ||
"percent": "0.1" | "percent": "0.1" | ||
Line 488: | Line 518: | ||
"wikidata": "Q55633582", | "wikidata": "Q55633582", | ||
"iso": "ajp", | "iso": "ajp", | ||
− | " | + | "malesCount": "8", |
− | "malesRecords": " | + | "malesRecords": "2734", |
− | " | + | "femalesCount": "2", |
"femalesRecords": "146", | "femalesRecords": "146", | ||
− | "percent": " | + | "percent": "5.1" |
}, | }, | ||
{ | { | ||
Line 498: | Line 528: | ||
"wikidata": "Q1321", | "wikidata": "Q1321", | ||
"iso": "spa", | "iso": "spa", | ||
− | " | + | "malesCount": "17", |
− | "malesRecords": " | + | "malesRecords": "9623", |
− | " | + | "femalesCount": "10", |
− | "femalesRecords": " | + | "femalesRecords": "728", |
− | "percent": "7 | + | "percent": "7" |
}, | }, | ||
{ | { | ||
Line 508: | Line 538: | ||
"wikidata": "Q8097", | "wikidata": "Q8097", | ||
"iso": "tel", | "iso": "tel", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "397", | "malesRecords": "397", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "5", | "femalesRecords": "5", | ||
"percent": "1.2" | "percent": "1.2" | ||
Line 518: | Line 548: | ||
"wikidata": "Q8798", | "wikidata": "Q8798", | ||
"iso": "ukr", | "iso": "ukr", | ||
− | " | + | "malesCount": "5", |
− | "malesRecords": " | + | "malesRecords": "19086", |
− | " | + | "femalesCount": "1", |
"femalesRecords": "5", | "femalesRecords": "5", | ||
"percent": "0" | "percent": "0" | ||
Line 528: | Line 558: | ||
"wikidata": "Q891085", | "wikidata": "Q891085", | ||
"iso": "guc", | "iso": "guc", | ||
− | " | + | "malesCount": "1", |
− | "malesRecords": " | + | "malesRecords": "26", |
− | " | + | "femalesCount": "5", |
"femalesRecords": "18", | "femalesRecords": "18", | ||
− | "percent": " | + | "percent": "40.9" |
}, | }, | ||
{ | { | ||
Line 538: | Line 568: | ||
"wikidata": "Q9309", | "wikidata": "Q9309", | ||
"iso": "cym", | "iso": "cym", | ||
− | " | + | "malesCount": "6", |
− | "malesRecords": " | + | "malesRecords": "1649", |
− | " | + | "femalesCount": "3", |
"femalesRecords": "70", | "femalesRecords": "70", | ||
− | "percent": " | + | "percent": "4.1" |
} | } | ||
] | ] |
Latest revision as of 21:41, 8 August 2022
/* **************
SELECT ?languageLabel ?wikidata ?iso ?malesCount ?malesRecords ?femalesCount ?femalesRecords
(ROUND(1000*?femalesRecords/(?femalesRecords+?malesRecords))/10 AS ?percent)
WITH {
SELECT ?language ?languageLabel ?wikidata ?iso {
?record prop:P2 entity:Q2 . # Filter: P2 'instance of' is Q2 'record'
?record prop:P4 ?language . # Assign value: P4 'language' into ?language
?language prop:P12 ?wikidata . # Assign value: P12 'wikidata id' into ?wikidata
OPTIONAL { ?language prop:P13 ?iso . } # Assign value: P13 'iso639-3' into ?iso
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?language ?languageLabel ?wikidata ?iso
} AS %base
WITH {
SELECT ?language ?languageLabel ?iso ?genderLabel
(COUNT(DISTINCT ?females) AS ?femalesCount)
(COUNT(DISTINCT ?record) AS ?femalesRecords) {
INCLUDE %base
?record prop:P4 ?language ; # Filter
prop:P5 ?females . # Assign value: P5 'speaker' into ?females
?females prop:P8 entity:Q17 ; # Filter
prop:P8 ?gender . # Assign value: P8 'gender' into ?gender
} GROUP BY ?language ?languageLabel ?iso ?genderLabel
} AS %females
WITH {
SELECT ?language ?languageLabel ?iso ?genderLabel
(COUNT(DISTINCT ?males) AS ?malesCount)
(COUNT(DISTINCT ?record) AS ?malesRecords) {
INCLUDE %base
?record prop:P4 ?language ;
prop:P5 ?males . # Assign value: P5 'speaker' into variable ?speakerQid
?males prop:P8 entity:Q16 ;
prop:P8 ?gender .
} GROUP BY ?language ?languageLabel ?iso ?genderLabel
} AS %males
{
INCLUDE %base
INCLUDE %females
INCLUDE %males
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?languageLabel ?wikidata ?iso ?malesCount ?malesRecords ?femalesCount ?femalesRecords
ORDER BY ASC(?languageLabel )
************** */
[
{
"languageLabel": "Algerian Arabic",
"wikidata": "Q56499",
"iso": "arq",
"malesCount": "2",
"malesRecords": "234",
"femalesCount": "2",
"femalesRecords": "5",
"percent": "2.1"
},
{
"languageLabel": "Amharic",
"wikidata": "Q28244",
"iso": "amh",
"malesCount": "1",
"malesRecords": "8",
"femalesCount": "1",
"femalesRecords": "209",
"percent": "96.3"
},
{
"languageLabel": "Arabic",
"wikidata": "Q13955",
"iso": "ara",
"malesCount": "12",
"malesRecords": "5627",
"femalesCount": "2",
"femalesRecords": "9",
"percent": "0.2"
},
{
"languageLabel": "Atikamekw",
"wikidata": "Q56590",
"iso": "atj",
"malesCount": "2",
"malesRecords": "45",
"femalesCount": "1",
"femalesRecords": "432",
"percent": "90.6"
},
{
"languageLabel": "Balinese",
"wikidata": "Q33070",
"iso": "ban",
"malesCount": "1",
"malesRecords": "196",
"femalesCount": "1",
"femalesRecords": "302",
"percent": "60.6"
},
{
"languageLabel": "Baoulé",
"wikidata": "Q35107",
"iso": "bci",
"malesCount": "4",
"malesRecords": "60",
"femalesCount": "3",
"femalesRecords": "33",
"percent": "35.5"
},
{
"languageLabel": "Basque",
"wikidata": "Q8752",
"iso": "eus",
"malesCount": "4",
"malesRecords": "3114",
"femalesCount": "4",
"femalesRecords": "385",
"percent": "11"
},
{
"languageLabel": "Bikol languages",
"wikidata": "Q35455",
"iso": "bik",
"malesCount": "3",
"malesRecords": "933",
"femalesCount": "3",
"femalesRecords": "489",
"percent": "34.4"
},
{
"languageLabel": "Cantonese",
"wikidata": "Q9186",
"iso": "yue",
"malesCount": "3",
"malesRecords": "319",
"femalesCount": "1",
"femalesRecords": "5393",
"percent": "94.4"
},
{
"languageLabel": "Central Bikol",
"wikidata": "Q33284",
"iso": "bcl",
"malesCount": "3",
"malesRecords": "17",
"femalesCount": "2",
"femalesRecords": "79",
"percent": "82.3"
},
{
"languageLabel": "Chinese writing",
"wikidata": "Q7850",
"iso": "zho",
"malesCount": "1",
"malesRecords": "3",
"femalesCount": "4",
"femalesRecords": "184",
"percent": "98.4"
},
{
"languageLabel": "Cornish",
"wikidata": "Q25289",
"iso": "cor",
"malesCount": "1",
"malesRecords": "9",
"femalesCount": "1",
"femalesRecords": "139",
"percent": "93.9"
},
{
"languageLabel": "Dioula language",
"wikidata": "Q32706",
"iso": "dyu",
"malesCount": "2",
"malesRecords": "47",
"femalesCount": "1",
"femalesRecords": "16",
"percent": "25.4"
},
{
"languageLabel": "Dutch",
"wikidata": "Q7411",
"iso": "nld",
"malesCount": "3",
"malesRecords": "231",
"femalesCount": "1",
"femalesRecords": "291",
"percent": "55.7"
},
{
"languageLabel": "English",
"wikidata": "Q1860",
"iso": "eng",
"malesCount": "54",
"malesRecords": "20494",
"femalesCount": "10",
"femalesRecords": "1605",
"percent": "7.3"
},
{
"languageLabel": "Finnish",
"wikidata": "Q1412",
"iso": "fin",
"malesCount": "2",
"malesRecords": "853",
"femalesCount": "2",
"femalesRecords": "48",
"percent": "5.3"
},
{
"languageLabel": "Fon",
"wikidata": "Q33291",
"iso": "fon",
"malesCount": "4",
"malesRecords": "361",
"femalesCount": "1",
"femalesRecords": "2",
"percent": "0.6"
},
{
"languageLabel": "French",
"wikidata": "Q150",
"iso": "fra",
"malesCount": "189",
"malesRecords": "225972",
"femalesCount": "95",
"femalesRecords": "17398",
"percent": "7.1"
},
{
"languageLabel": "French Sign Language",
"wikidata": "Q33302",
"iso": "fsl",
"malesCount": "3",
"malesRecords": "15",
"femalesCount": "1",
"femalesRecords": "570",
"percent": "97.4"
},
{
"languageLabel": "Galician",
"wikidata": "Q9307",
"iso": "glg",
"malesCount": "3",
"malesRecords": "28",
"femalesCount": "1",
"femalesRecords": "6",
"percent": "17.6"
},
{
"languageLabel": "German",
"wikidata": "Q188",
"iso": "deu",
"malesCount": "29",
"malesRecords": "11022",
"femalesCount": "8",
"femalesRecords": "4172",
"percent": "27.5"
},
{
"languageLabel": "Ghomala' language",
"wikidata": "Q35271",
"iso": "bbj",
"malesCount": "3",
"malesRecords": "91",
"femalesCount": "2",
"femalesRecords": "96",
"percent": "51.3"
},
{
"languageLabel": "Greek",
"wikidata": "Q9129",
"iso": "gre",
"malesCount": "1",
"malesRecords": "5",
"femalesCount": "1",
"femalesRecords": "13",
"percent": "72.2"
},
{
"languageLabel": "Haitian Creole",
"wikidata": "Q33491",
"iso": "hat",
"malesCount": "4",
"malesRecords": "21",
"femalesCount": "2",
"femalesRecords": "8",
"percent": "27.6"
},
{
"languageLabel": "Igbo",
"wikidata": "Q33578",
"iso": "ibo",
"malesCount": "6",
"malesRecords": "35",
"femalesCount": "12",
"femalesRecords": "1055",
"percent": "96.8"
},
{
"languageLabel": "Indonesian",
"wikidata": "Q9240",
"iso": "ind",
"malesCount": "6",
"malesRecords": "391",
"femalesCount": "1",
"femalesRecords": "5",
"percent": "1.3"
},
{
"languageLabel": "Irish",
"wikidata": "Q9142",
"iso": "gle",
"malesCount": "2",
"malesRecords": "558",
"femalesCount": "2",
"femalesRecords": "32",
"percent": "5.4"
},
{
"languageLabel": "Italian",
"wikidata": "Q652",
"iso": "ita",
"malesCount": "5",
"malesRecords": "3606",
"femalesCount": "1",
"femalesRecords": "879",
"percent": "19.6"
},
{
"languageLabel": "Kannada",
"wikidata": "Q33673",
"iso": "kan",
"malesCount": "6",
"malesRecords": "329",
"femalesCount": "2",
"femalesRecords": "158",
"percent": "32.4"
},
{
"languageLabel": "Kaqchikel",
"wikidata": "Q35115",
"iso": "cak",
"malesCount": "1",
"malesRecords": "42",
"femalesCount": "1",
"femalesRecords": "3",
"percent": "6.7"
},
{
"languageLabel": "Korean",
"wikidata": "Q9176",
"iso": "kor",
"malesCount": "1",
"malesRecords": "122",
"femalesCount": "1",
"femalesRecords": "2",
"percent": "1.6"
},
{
"languageLabel": "Kurdish",
"wikidata": "Q36368",
"iso": "kur",
"malesCount": "3",
"malesRecords": "205",
"femalesCount": "1",
"femalesRecords": "382",
"percent": "65.1"
},
{
"languageLabel": "Mandarin Chinese",
"wikidata": "Q9192",
"iso": "cmn",
"malesCount": "2",
"malesRecords": "15",
"femalesCount": "4",
"femalesRecords": "814",
"percent": "98.2"
},
{
"languageLabel": "Marathi",
"wikidata": "Q1571",
"iso": "mar",
"malesCount": "4",
"malesRecords": "1357",
"femalesCount": "27",
"femalesRecords": "13153",
"percent": "90.6"
},
{
"languageLabel": "Martinique Creole",
"wikidata": "Q3006281",
"malesCount": "1",
"malesRecords": "25",
"femalesCount": "1",
"femalesRecords": "25",
"percent": "50"
},
{
"languageLabel": "Moroccan Arabic",
"wikidata": "Q56426",
"iso": "ary",
"malesCount": "6",
"malesRecords": "1184",
"femalesCount": "2",
"femalesRecords": "102",
"percent": "7.9"
},
{
"languageLabel": "Occitan",
"wikidata": "Q14185",
"iso": "oci",
"malesCount": "5",
"malesRecords": "139",
"femalesCount": "1",
"femalesRecords": "67",
"percent": "32.5"
},
{
"languageLabel": "Odia",
"wikidata": "Q33810",
"iso": "ori",
"malesCount": "4",
"malesRecords": "52709",
"femalesCount": "1",
"femalesRecords": "2",
"percent": "0"
},
{
"languageLabel": "Persian",
"wikidata": "Q9168",
"iso": "fas",
"malesCount": "2",
"malesRecords": "72",
"femalesCount": "2",
"femalesRecords": "811",
"percent": "91.8"
},
{
"languageLabel": "Picard",
"wikidata": "Q34024",
"iso": "pcd",
"malesCount": "4",
"malesRecords": "26",
"femalesCount": "18",
"femalesRecords": "104",
"percent": "80"
},
{
"languageLabel": "Polish",
"wikidata": "Q809",
"iso": "pol",
"malesCount": "11",
"malesRecords": "70634",
"femalesCount": "3",
"femalesRecords": "13699",
"percent": "16.2"
},
{
"languageLabel": "Portuguese",
"wikidata": "Q5146",
"iso": "por",
"malesCount": "5",
"malesRecords": "3268",
"femalesCount": "3",
"femalesRecords": "2521",
"percent": "43.5"
},
{
"languageLabel": "Punjabi",
"wikidata": "Q58635",
"iso": "pan",
"malesCount": "5",
"malesRecords": "3979",
"femalesCount": "2",
"femalesRecords": "326",
"percent": "7.6"
},
{
"languageLabel": "Romanian",
"wikidata": "Q7913",
"iso": "ron",
"malesCount": "4",
"malesRecords": "16959",
"femalesCount": "1",
"femalesRecords": "2442",
"percent": "12.6"
},
{
"languageLabel": "Russian",
"wikidata": "Q7737",
"iso": "rus",
"malesCount": "16",
"malesRecords": "5406",
"femalesCount": "10",
"femalesRecords": "3186",
"percent": "37.1"
},
{
"languageLabel": "Santali",
"wikidata": "Q33965",
"iso": "sat",
"malesCount": "7",
"malesRecords": "397",
"femalesCount": "1",
"femalesRecords": "150",
"percent": "27.4"
},
{
"languageLabel": "Shawiya language",
"wikidata": "Q33274",
"iso": "shy",
"malesCount": "6",
"malesRecords": "1729",
"femalesCount": "1",
"femalesRecords": "1",
"percent": "0.1"
},
{
"languageLabel": "South Levantine Arabic",
"wikidata": "Q55633582",
"iso": "ajp",
"malesCount": "8",
"malesRecords": "2734",
"femalesCount": "2",
"femalesRecords": "146",
"percent": "5.1"
},
{
"languageLabel": "Spanish",
"wikidata": "Q1321",
"iso": "spa",
"malesCount": "17",
"malesRecords": "9623",
"femalesCount": "10",
"femalesRecords": "728",
"percent": "7"
},
{
"languageLabel": "Telugu",
"wikidata": "Q8097",
"iso": "tel",
"malesCount": "2",
"malesRecords": "397",
"femalesCount": "1",
"femalesRecords": "5",
"percent": "1.2"
},
{
"languageLabel": "Ukrainian",
"wikidata": "Q8798",
"iso": "ukr",
"malesCount": "5",
"malesRecords": "19086",
"femalesCount": "1",
"femalesRecords": "5",
"percent": "0"
},
{
"languageLabel": "Wayuu",
"wikidata": "Q891085",
"iso": "guc",
"malesCount": "1",
"malesRecords": "26",
"femalesCount": "5",
"femalesRecords": "18",
"percent": "40.9"
},
{
"languageLabel": "Welsh",
"wikidata": "Q9309",
"iso": "cym",
"malesCount": "6",
"malesRecords": "1649",
"femalesCount": "3",
"femalesRecords": "70",
"percent": "4.1"
}
]