MediaWiki:LanguagesGenderData.js

/* **************
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"
  }
]