Difference between revisions of "LanguagesGenderData.js"

Revision as of 14:10, 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"
  }
]