MediaWiki
Difference between revisions of "LanguagesGenderData.js"
m |
m |
||
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 8: | ||
?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 14: | ||
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 23: | ||
} 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 40: | ||
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 48: | ||
"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 58: | ||
"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 68: | ||
"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 78: | ||
"wikidata": "Q56590", | "wikidata": "Q56590", | ||
"iso": "atj", | "iso": "atj", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "43", | "malesRecords": "43", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "432", | "femalesRecords": "432", | ||
"percent": "90.9" | "percent": "90.9" | ||
Line 89: | Line 88: | ||
"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 98: | ||
"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 108: | ||
"wikidata": "Q8752", | "wikidata": "Q8752", | ||
"iso": "eus", | "iso": "eus", | ||
− | " | + | "malesCount": "4", |
"malesRecords": "2729", | "malesRecords": "2729", | ||
− | " | + | "femalesCount": "3", |
"femalesRecords": "330", | "femalesRecords": "330", | ||
"percent": "10.8" | "percent": "10.8" | ||
Line 119: | Line 118: | ||
"wikidata": "Q35455", | "wikidata": "Q35455", | ||
"iso": "bik", | "iso": "bik", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "423", | "malesRecords": "423", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "1", | "femalesRecords": "1", | ||
"percent": "0.2" | "percent": "0.2" | ||
Line 129: | Line 128: | ||
"wikidata": "Q9186", | "wikidata": "Q9186", | ||
"iso": "yue", | "iso": "yue", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "298", | "malesRecords": "298", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "5393", | "femalesRecords": "5393", | ||
"percent": "94.8" | "percent": "94.8" | ||
Line 139: | Line 138: | ||
"wikidata": "Q33284", | "wikidata": "Q33284", | ||
"iso": "bcl", | "iso": "bcl", | ||
− | " | + | "malesCount": "3", |
"malesRecords": "17", | "malesRecords": "17", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "74", | "femalesRecords": "74", | ||
"percent": "81.3" | "percent": "81.3" | ||
Line 149: | Line 148: | ||
"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 158: | ||
"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 168: | ||
"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" | ||
Line 179: | Line 178: | ||
"wikidata": "Q1860", | "wikidata": "Q1860", | ||
"iso": "eng", | "iso": "eng", | ||
− | " | + | "malesCount": "41", |
"malesRecords": "17575", | "malesRecords": "17575", | ||
− | " | + | "femalesCount": "10", |
"femalesRecords": "1699", | "femalesRecords": "1699", | ||
"percent": "8.8" | "percent": "8.8" | ||
Line 189: | Line 188: | ||
"wikidata": "Q1412", | "wikidata": "Q1412", | ||
"iso": "fin", | "iso": "fin", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "1126", | "malesRecords": "1126", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "48", | "femalesRecords": "48", | ||
"percent": "4.1" | "percent": "4.1" | ||
Line 199: | Line 198: | ||
"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 208: | ||
"wikidata": "Q150", | "wikidata": "Q150", | ||
"iso": "fra", | "iso": "fra", | ||
− | " | + | "malesCount": "172", |
"malesRecords": "217922", | "malesRecords": "217922", | ||
− | " | + | "femalesCount": "87", |
"femalesRecords": "18600", | "femalesRecords": "18600", | ||
"percent": "7.9" | "percent": "7.9" | ||
Line 219: | Line 218: | ||
"wikidata": "Q33302", | "wikidata": "Q33302", | ||
"iso": "fsl", | "iso": "fsl", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "4", | "malesRecords": "4", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "570", | "femalesRecords": "570", | ||
"percent": "99.3" | "percent": "99.3" | ||
Line 229: | Line 228: | ||
"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 238: | ||
"wikidata": "Q188", | "wikidata": "Q188", | ||
"iso": "deu", | "iso": "deu", | ||
− | " | + | "malesCount": "26", |
"malesRecords": "10529", | "malesRecords": "10529", | ||
− | " | + | "femalesCount": "8", |
"femalesRecords": "4103", | "femalesRecords": "4103", | ||
"percent": "28" | "percent": "28" | ||
Line 249: | Line 248: | ||
"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 258: | ||
"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 268: | ||
"wikidata": "Q33491", | "wikidata": "Q33491", | ||
"iso": "hat", | "iso": "hat", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "1", | "malesRecords": "1", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "8", | "femalesRecords": "8", | ||
"percent": "88.9" | "percent": "88.9" | ||
Line 279: | Line 278: | ||
"wikidata": "Q33578", | "wikidata": "Q33578", | ||
"iso": "ibo", | "iso": "ibo", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "12", | "malesRecords": "12", | ||
− | " | + | "femalesCount": "3", |
"femalesRecords": "633", | "femalesRecords": "633", | ||
"percent": "98.1" | "percent": "98.1" | ||
Line 289: | Line 288: | ||
"wikidata": "Q9240", | "wikidata": "Q9240", | ||
"iso": "ind", | "iso": "ind", | ||
− | " | + | "malesCount": "2", |
"malesRecords": "3", | "malesRecords": "3", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "5", | "femalesRecords": "5", | ||
"percent": "62.5" | "percent": "62.5" | ||
Line 299: | Line 298: | ||
"wikidata": "Q652", | "wikidata": "Q652", | ||
"iso": "ita", | "iso": "ita", | ||
− | " | + | "malesCount": "5", |
"malesRecords": "3403", | "malesRecords": "3403", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "883", | "femalesRecords": "883", | ||
"percent": "20.6" | "percent": "20.6" | ||
Line 309: | Line 308: | ||
"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 318: | ||
"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 328: | ||
"wikidata": "Q9176", | "wikidata": "Q9176", | ||
"iso": "kor", | "iso": "kor", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "51", | "malesRecords": "51", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "2", | "femalesRecords": "2", | ||
"percent": "3.8" | "percent": "3.8" | ||
Line 339: | Line 338: | ||
"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 348: | ||
"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 358: | ||
"wikidata": "Q1571", | "wikidata": "Q1571", | ||
"iso": "mar", | "iso": "mar", | ||
− | " | + | "malesCount": "3", |
"malesRecords": "1254", | "malesRecords": "1254", | ||
− | " | + | "femalesCount": "27", |
"femalesRecords": "13153", | "femalesRecords": "13153", | ||
"percent": "91.3" | "percent": "91.3" | ||
Line 368: | Line 367: | ||
"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 377: | ||
"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 387: | ||
"wikidata": "Q14185", | "wikidata": "Q14185", | ||
"iso": "oci", | "iso": "oci", | ||
− | " | + | "malesCount": "4", |
"malesRecords": "138", | "malesRecords": "138", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "67", | "femalesRecords": "67", | ||
"percent": "32.7" | "percent": "32.7" | ||
Line 398: | Line 397: | ||
"wikidata": "Q33810", | "wikidata": "Q33810", | ||
"iso": "ori", | "iso": "ori", | ||
− | " | + | "malesCount": "4", |
"malesRecords": "50434", | "malesRecords": "50434", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "2", | "femalesRecords": "2", | ||
"percent": "0" | "percent": "0" | ||
Line 408: | Line 407: | ||
"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" | ||
Line 418: | Line 417: | ||
"wikidata": "Q809", | "wikidata": "Q809", | ||
"iso": "pol", | "iso": "pol", | ||
− | " | + | "malesCount": "11", |
"malesRecords": "63379", | "malesRecords": "63379", | ||
− | " | + | "femalesCount": "3", |
"femalesRecords": "12971", | "femalesRecords": "12971", | ||
"percent": "17" | "percent": "17" | ||
Line 428: | Line 427: | ||
"wikidata": "Q5146", | "wikidata": "Q5146", | ||
"iso": "por", | "iso": "por", | ||
− | " | + | "malesCount": "4", |
"malesRecords": "2758", | "malesRecords": "2758", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "2520", | "femalesRecords": "2520", | ||
"percent": "47.7" | "percent": "47.7" | ||
Line 438: | Line 437: | ||
"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 447: | ||
"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 457: | ||
"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 467: | ||
"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 477: | ||
"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 487: | ||
"wikidata": "Q55633582", | "wikidata": "Q55633582", | ||
"iso": "ajp", | "iso": "ajp", | ||
− | " | + | "malesCount": "4", |
"malesRecords": "1244", | "malesRecords": "1244", | ||
− | " | + | "femalesCount": "2", |
"femalesRecords": "146", | "femalesRecords": "146", | ||
"percent": "10.5" | "percent": "10.5" | ||
Line 498: | Line 497: | ||
"wikidata": "Q1321", | "wikidata": "Q1321", | ||
"iso": "spa", | "iso": "spa", | ||
− | " | + | "malesCount": "15", |
"malesRecords": "8052", | "malesRecords": "8052", | ||
− | " | + | "femalesCount": "9", |
"femalesRecords": "632", | "femalesRecords": "632", | ||
"percent": "7.3" | "percent": "7.3" | ||
Line 508: | Line 507: | ||
"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 517: | ||
"wikidata": "Q8798", | "wikidata": "Q8798", | ||
"iso": "ukr", | "iso": "ukr", | ||
− | " | + | "malesCount": "3", |
"malesRecords": "18596", | "malesRecords": "18596", | ||
− | " | + | "femalesCount": "1", |
"femalesRecords": "5", | "femalesRecords": "5", | ||
"percent": "0" | "percent": "0" | ||
Line 528: | Line 527: | ||
"wikidata": "Q891085", | "wikidata": "Q891085", | ||
"iso": "guc", | "iso": "guc", | ||
− | " | + | "malesCount": "1", |
"malesRecords": "22", | "malesRecords": "22", | ||
− | " | + | "femalesCount": "5", |
"femalesRecords": "18", | "femalesRecords": "18", | ||
"percent": "45" | "percent": "45" | ||
Line 538: | Line 537: | ||
"wikidata": "Q9309", | "wikidata": "Q9309", | ||
"iso": "cym", | "iso": "cym", | ||
− | " | + | "malesCount": "6", |
"malesRecords": "791", | "malesRecords": "791", | ||
− | " | + | "femalesCount": "3", |
"femalesRecords": "70", | "femalesRecords": "70", | ||
"percent": "8.1" | "percent": "8.1" | ||
} | } | ||
] | ] |
Revision as of 16:32, 25 January 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": "1",
"malesRecords": "43",
"femalesCount": "1",
"femalesRecords": "432",
"percent": "90.9"
},
{
"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": "2729",
"femalesCount": "3",
"femalesRecords": "330",
"percent": "10.8"
},
{
"languageLabel": "Bikol languages",
"wikidata": "Q35455",
"iso": "bik",
"malesCount": "2",
"malesRecords": "423",
"femalesCount": "1",
"femalesRecords": "1",
"percent": "0.2"
},
{
"languageLabel": "Cantonese",
"wikidata": "Q9186",
"iso": "yue",
"malesCount": "2",
"malesRecords": "298",
"femalesCount": "1",
"femalesRecords": "5393",
"percent": "94.8"
},
{
"languageLabel": "Central Bikol",
"wikidata": "Q33284",
"iso": "bcl",
"malesCount": "3",
"malesRecords": "17",
"femalesCount": "1",
"femalesRecords": "74",
"percent": "81.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": "English",
"wikidata": "Q1860",
"iso": "eng",
"malesCount": "41",
"malesRecords": "17575",
"femalesCount": "10",
"femalesRecords": "1699",
"percent": "8.8"
},
{
"languageLabel": "Finnish",
"wikidata": "Q1412",
"iso": "fin",
"malesCount": "2",
"malesRecords": "1126",
"femalesCount": "2",
"femalesRecords": "48",
"percent": "4.1"
},
{
"languageLabel": "Fon",
"wikidata": "Q33291",
"iso": "fon",
"malesCount": "4",
"malesRecords": "361",
"femalesCount": "1",
"femalesRecords": "2",
"percent": "0.6"
},
{
"languageLabel": "French",
"wikidata": "Q150",
"iso": "fra",
"malesCount": "172",
"malesRecords": "217922",
"femalesCount": "87",
"femalesRecords": "18600",
"percent": "7.9"
},
{
"languageLabel": "French Sign Language",
"wikidata": "Q33302",
"iso": "fsl",
"malesCount": "2",
"malesRecords": "4",
"femalesCount": "1",
"femalesRecords": "570",
"percent": "99.3"
},
{
"languageLabel": "Galician",
"wikidata": "Q9307",
"iso": "glg",
"malesCount": "3",
"malesRecords": "28",
"femalesCount": "1",
"femalesRecords": "6",
"percent": "17.6"
},
{
"languageLabel": "German",
"wikidata": "Q188",
"iso": "deu",
"malesCount": "26",
"malesRecords": "10529",
"femalesCount": "8",
"femalesRecords": "4103",
"percent": "28"
},
{
"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": "1",
"malesRecords": "1",
"femalesCount": "2",
"femalesRecords": "8",
"percent": "88.9"
},
{
"languageLabel": "Igbo",
"wikidata": "Q33578",
"iso": "ibo",
"malesCount": "1",
"malesRecords": "12",
"femalesCount": "3",
"femalesRecords": "633",
"percent": "98.1"
},
{
"languageLabel": "Indonesian",
"wikidata": "Q9240",
"iso": "ind",
"malesCount": "2",
"malesRecords": "3",
"femalesCount": "1",
"femalesRecords": "5",
"percent": "62.5"
},
{
"languageLabel": "Italian",
"wikidata": "Q652",
"iso": "ita",
"malesCount": "5",
"malesRecords": "3403",
"femalesCount": "2",
"femalesRecords": "883",
"percent": "20.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": "51",
"femalesCount": "1",
"femalesRecords": "2",
"percent": "3.8"
},
{
"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": "3",
"malesRecords": "1254",
"femalesCount": "27",
"femalesRecords": "13153",
"percent": "91.3"
},
{
"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": "4",
"malesRecords": "138",
"femalesCount": "1",
"femalesRecords": "67",
"percent": "32.7"
},
{
"languageLabel": "Odia",
"wikidata": "Q33810",
"iso": "ori",
"malesCount": "4",
"malesRecords": "50434",
"femalesCount": "1",
"femalesRecords": "2",
"percent": "0"
},
{
"languageLabel": "Persian",
"wikidata": "Q9168",
"iso": "fas",
"malesCount": "2",
"malesRecords": "72",
"femalesCount": "2",
"femalesRecords": "811",
"percent": "91.8"
},
{
"languageLabel": "Polish",
"wikidata": "Q809",
"iso": "pol",
"malesCount": "11",
"malesRecords": "63379",
"femalesCount": "3",
"femalesRecords": "12971",
"percent": "17"
},
{
"languageLabel": "Portuguese",
"wikidata": "Q5146",
"iso": "por",
"malesCount": "4",
"malesRecords": "2758",
"femalesCount": "2",
"femalesRecords": "2520",
"percent": "47.7"
},
{
"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": "4",
"malesRecords": "1244",
"femalesCount": "2",
"femalesRecords": "146",
"percent": "10.5"
},
{
"languageLabel": "Spanish",
"wikidata": "Q1321",
"iso": "spa",
"malesCount": "15",
"malesRecords": "8052",
"femalesCount": "9",
"femalesRecords": "632",
"percent": "7.3"
},
{
"languageLabel": "Telugu",
"wikidata": "Q8097",
"iso": "tel",
"malesCount": "2",
"malesRecords": "397",
"femalesCount": "1",
"femalesRecords": "5",
"percent": "1.2"
},
{
"languageLabel": "Ukrainian",
"wikidata": "Q8798",
"iso": "ukr",
"malesCount": "3",
"malesRecords": "18596",
"femalesCount": "1",
"femalesRecords": "5",
"percent": "0"
},
{
"languageLabel": "Wayuu",
"wikidata": "Q891085",
"iso": "guc",
"malesCount": "1",
"malesRecords": "22",
"femalesCount": "5",
"femalesRecords": "18",
"percent": "45"
},
{
"languageLabel": "Welsh",
"wikidata": "Q9309",
"iso": "cym",
"malesCount": "6",
"malesRecords": "791",
"femalesCount": "3",
"femalesRecords": "70",
"percent": "8.1"
}
]