MediaWiki
LanguagesGenderData.js
Note: After saving, you may have to bypass your browser's cache to see the changes.
- Firefox / Safari: Hold Shift while clicking Reload, or press either Ctrl-F5 or Ctrl-R (⌘-R on a Mac)
- Google Chrome: Press Ctrl-Shift-R (⌘-Shift-R on a Mac)
- Internet Explorer / Edge: Hold Ctrl while clicking Refresh, or press Ctrl-F5
- Opera: Go to Menu → Settings (Opera → Preferences on a Mac) and then to Privacy & security → Clear browsing data → Cached images and files.
/* **************
select ?languageLabel ?iso ?malesCount ?malesRecords ?femalesCount ?femalesRecords (ROUND(1000*?femalesRecords/(?femalesRecords+?malesRecords))/10 as ?percentFemaleRecordings)
with {
select ?language ?languageLabel ?iso {
?record prop:P2 entity:Q2 . # Filter: items where P2 'instance of' is Q2 'record'
?record prop:P4 ?language . # Filter: items where P4 'language' is Q34 'Marathi'
# OPTIONAL { ?language prop:P12 ?wikidata } # Assign value: P12 'wikidata id' into variable ?WD
OPTIONAL { ?language prop:P13 ?iso } # Assign value: P13 'iso639-3' into ?isoCode
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?language ?languageLabel ?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 ;
prop:P5 ?females . # Assign value: P5 'speaker' into variable ?speakerQid
?females prop:P8 entity:Q17 ;
prop:P8 ?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 ?iso ?malesCount ?malesRecords ?femalesCount ?femalesRecords
ORDER BY ASC(?languageLabel )
************** */
[
{
"languageLabel": "Algerian Arabic",
"iso": "arq",
"malesCount": "2",
"malesRecords": "234",
"femalesCount": "2",
"femalesRecords": "5",
"percentFemaleRecordings": "2.1"
},
{
"languageLabel": "Amharic",
"iso": "amh",
"malesCount": "1",
"malesRecords": "8",
"femalesCount": "1",
"femalesRecords": "209",
"percentFemaleRecordings": "96.3"
},
{
"languageLabel": "Arabic",
"iso": "ara",
"malesCount": "12",
"malesRecords": "5627",
"femalesCount": "2",
"femalesRecords": "9",
"percentFemaleRecordings": "0.2"
},
{
"languageLabel": "Atikamekw",
"iso": "atj",
"malesCount": "1",
"malesRecords": "43",
"femalesCount": "1",
"femalesRecords": "432",
"percentFemaleRecordings": "90.9"
},
{
"languageLabel": "Balinese",
"iso": "ban",
"malesCount": "1",
"malesRecords": "196",
"femalesCount": "1",
"femalesRecords": "302",
"percentFemaleRecordings": "60.6"
},
{
"languageLabel": "Baoulé",
"iso": "bci",
"malesCount": "4",
"malesRecords": "60",
"femalesCount": "3",
"femalesRecords": "33",
"percentFemaleRecordings": "35.5"
},
{
"languageLabel": "Basque",
"iso": "eus",
"malesCount": "4",
"malesRecords": "2729",
"femalesCount": "3",
"femalesRecords": "330",
"percentFemaleRecordings": "10.8"
},
{
"languageLabel": "Bikol languages",
"iso": "bik",
"malesCount": "2",
"malesRecords": "423",
"femalesCount": "1",
"femalesRecords": "1",
"percentFemaleRecordings": "0.2"
},
{
"languageLabel": "Cantonese",
"iso": "yue",
"malesCount": "2",
"malesRecords": "298",
"femalesCount": "1",
"femalesRecords": "5393",
"percentFemaleRecordings": "94.8"
},
{
"languageLabel": "Central Bikol",
"iso": "bcl",
"malesCount": "3",
"malesRecords": "17",
"femalesCount": "1",
"femalesRecords": "74",
"percentFemaleRecordings": "81.3"
},
{
"languageLabel": "Chinese writing",
"iso": "zho",
"malesCount": "1",
"malesRecords": "3",
"femalesCount": "4",
"femalesRecords": "184",
"percentFemaleRecordings": "98.4"
},
{
"languageLabel": "Cornish",
"iso": "cor",
"malesCount": "1",
"malesRecords": "9",
"femalesCount": "1",
"femalesRecords": "139",
"percentFemaleRecordings": "93.9"
},
{
"languageLabel": "Dioula language",
"iso": "dyu",
"malesCount": "2",
"malesRecords": "47",
"femalesCount": "1",
"femalesRecords": "16",
"percentFemaleRecordings": "25.4"
},
{
"languageLabel": "English",
"iso": "eng",
"malesCount": "41",
"malesRecords": "17575",
"femalesCount": "10",
"femalesRecords": "1699",
"percentFemaleRecordings": "8.8"
},
{
"languageLabel": "Finnish",
"iso": "fin",
"malesCount": "2",
"malesRecords": "1126",
"femalesCount": "2",
"femalesRecords": "48",
"percentFemaleRecordings": "4.1"
},
{
"languageLabel": "Fon",
"iso": "fon",
"malesCount": "4",
"malesRecords": "361",
"femalesCount": "1",
"femalesRecords": "2",
"percentFemaleRecordings": "0.6"
},
{
"languageLabel": "French",
"iso": "fra",
"malesCount": "172",
"malesRecords": "217922",
"femalesCount": "87",
"femalesRecords": "18600",
"percentFemaleRecordings": "7.9"
},
{
"languageLabel": "French Sign Language",
"iso": "fsl",
"malesCount": "2",
"malesRecords": "4",
"femalesCount": "1",
"femalesRecords": "570",
"percentFemaleRecordings": "99.3"
},
{
"languageLabel": "Galician",
"iso": "glg",
"malesCount": "3",
"malesRecords": "28",
"femalesCount": "1",
"femalesRecords": "6",
"percentFemaleRecordings": "17.6"
},
{
"languageLabel": "German",
"iso": "deu",
"malesCount": "26",
"malesRecords": "10529",
"femalesCount": "8",
"femalesRecords": "4103",
"percentFemaleRecordings": "28"
},
{
"languageLabel": "Ghomala' language",
"iso": "bbj",
"malesCount": "3",
"malesRecords": "91",
"femalesCount": "2",
"femalesRecords": "96",
"percentFemaleRecordings": "51.3"
},
{
"languageLabel": "Greek",
"iso": "gre",
"malesCount": "1",
"malesRecords": "5",
"femalesCount": "1",
"femalesRecords": "13",
"percentFemaleRecordings": "72.2"
},
{
"languageLabel": "Haitian Creole",
"iso": "hat",
"malesCount": "1",
"malesRecords": "1",
"femalesCount": "2",
"femalesRecords": "8",
"percentFemaleRecordings": "88.9"
},
{
"languageLabel": "Igbo",
"iso": "ibo",
"malesCount": "1",
"malesRecords": "12",
"femalesCount": "3",
"femalesRecords": "633",
"percentFemaleRecordings": "98.1"
},
{
"languageLabel": "Indonesian",
"iso": "ind",
"malesCount": "2",
"malesRecords": "3",
"femalesCount": "1",
"femalesRecords": "5",
"percentFemaleRecordings": "62.5"
},
{
"languageLabel": "Italian",
"iso": "ita",
"malesCount": "5",
"malesRecords": "3403",
"femalesCount": "2",
"femalesRecords": "883",
"percentFemaleRecordings": "20.6"
},
{
"languageLabel": "Kannada",
"iso": "kan",
"malesCount": "6",
"malesRecords": "329",
"femalesCount": "2",
"femalesRecords": "158",
"percentFemaleRecordings": "32.4"
},
{
"languageLabel": "Kaqchikel",
"iso": "cak",
"malesCount": "1",
"malesRecords": "42",
"femalesCount": "1",
"femalesRecords": "3",
"percentFemaleRecordings": "6.7"
},
{
"languageLabel": "Korean",
"iso": "kor",
"malesCount": "1",
"malesRecords": "51",
"femalesCount": "1",
"femalesRecords": "2",
"percentFemaleRecordings": "3.8"
},
{
"languageLabel": "Kurdish",
"iso": "kur",
"malesCount": "3",
"malesRecords": "205",
"femalesCount": "1",
"femalesRecords": "382",
"percentFemaleRecordings": "65.1"
},
{
"languageLabel": "Mandarin Chinese",
"iso": "cmn",
"malesCount": "2",
"malesRecords": "15",
"femalesCount": "4",
"femalesRecords": "814",
"percentFemaleRecordings": "98.2"
},
{
"languageLabel": "Marathi",
"iso": "mar",
"malesCount": "3",
"malesRecords": "1254",
"femalesCount": "27",
"femalesRecords": "13153",
"percentFemaleRecordings": "91.3"
},
{
"languageLabel": "Martinique Creole",
"malesCount": "1",
"malesRecords": "25",
"femalesCount": "1",
"femalesRecords": "25",
"percentFemaleRecordings": "50"
},
{
"languageLabel": "Moroccan Arabic",
"iso": "ary",
"malesCount": "6",
"malesRecords": "1184",
"femalesCount": "2",
"femalesRecords": "102",
"percentFemaleRecordings": "7.9"
},
{
"languageLabel": "Occitan",
"iso": "oci",
"malesCount": "4",
"malesRecords": "138",
"femalesCount": "1",
"femalesRecords": "67",
"percentFemaleRecordings": "32.7"
},
{
"languageLabel": "Odia",
"iso": "ori",
"malesCount": "4",
"malesRecords": "50434",
"femalesCount": "1",
"femalesRecords": "2",
"percentFemaleRecordings": "0"
},
{
"languageLabel": "Persian",
"iso": "fas",
"malesCount": "2",
"malesRecords": "72",
"femalesCount": "2",
"femalesRecords": "811",
"percentFemaleRecordings": "91.8"
},
{
"languageLabel": "Polish",
"iso": "pol",
"malesCount": "11",
"malesRecords": "63379",
"femalesCount": "3",
"femalesRecords": "12971",
"percentFemaleRecordings": "17"
},
{
"languageLabel": "Portuguese",
"iso": "por",
"malesCount": "4",
"malesRecords": "2758",
"femalesCount": "2",
"femalesRecords": "2520",
"percentFemaleRecordings": "47.7"
},
{
"languageLabel": "Punjabi",
"iso": "pan",
"malesCount": "5",
"malesRecords": "3979",
"femalesCount": "2",
"femalesRecords": "326",
"percentFemaleRecordings": "7.6"
},
{
"languageLabel": "Romanian",
"iso": "ron",
"malesCount": "4",
"malesRecords": "16959",
"femalesCount": "1",
"femalesRecords": "2442",
"percentFemaleRecordings": "12.6"
},
{
"languageLabel": "Russian",
"iso": "rus",
"malesCount": "16",
"malesRecords": "5406",
"femalesCount": "10",
"femalesRecords": "3186",
"percentFemaleRecordings": "37.1"
},
{
"languageLabel": "Santali",
"iso": "sat",
"malesCount": "7",
"malesRecords": "397",
"femalesCount": "1",
"femalesRecords": "150",
"percentFemaleRecordings": "27.4"
},
{
"languageLabel": "Shawiya language",
"iso": "shy",
"malesCount": "6",
"malesRecords": "1729",
"femalesCount": "1",
"femalesRecords": "1",
"percentFemaleRecordings": "0.1"
},
{
"languageLabel": "South Levantine Arabic",
"iso": "ajp",
"malesCount": "4",
"malesRecords": "1244",
"femalesCount": "2",
"femalesRecords": "146",
"percentFemaleRecordings": "10.5"
},
{
"languageLabel": "Spanish",
"iso": "spa",
"malesCount": "15",
"malesRecords": "8052",
"femalesCount": "9",
"femalesRecords": "632",
"percentFemaleRecordings": "7.3"
},
{
"languageLabel": "Telugu",
"iso": "tel",
"malesCount": "2",
"malesRecords": "397",
"femalesCount": "1",
"femalesRecords": "5",
"percentFemaleRecordings": "1.2"
},
{
"languageLabel": "Ukrainian",
"iso": "ukr",
"malesCount": "3",
"malesRecords": "18596",
"femalesCount": "1",
"femalesRecords": "5",
"percentFemaleRecordings": "0"
},
{
"languageLabel": "Wayuu",
"iso": "guc",
"malesCount": "1",
"malesRecords": "22",
"femalesCount": "5",
"femalesRecords": "18",
"percentFemaleRecordings": "45"
},
{
"languageLabel": "Welsh",
"iso": "cym",
"malesCount": "6",
"malesRecords": "791",
"femalesCount": "3",
"femalesRecords": "70",
"percentFemaleRecordings": "8.1"
}
]