MediaWiki
SandboxData.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 ?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"
}
]