MediaWiki
Difference between revisions of "LanguagesRecordsData.js"
m (Yug moved page MediaWiki:LanguagesGalleryData.js to MediaWiki:LanguagesRecordsData.js without leaving a redirect: Better) |
m |
||
Line 1: | Line 1: | ||
/* ************** | /* ************** | ||
− | + | SELECT ?languageLabel ?wikidata ?iso ?malesCount ?malesRecords ?femalesCount ?femalesRecords | |
− | + | (ROUND(1000*?femalesRecords/(?femalesRecords+?malesRecords))/10 AS ?percent) | |
− | SELECT | + | 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 | |
− | ?language prop:P2 entity: | + | 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) | |
− | ?record prop:P4 ?language . | + | (COUNT(DISTINCT ?record) AS ?femalesRecords) { |
− | ? | + | INCLUDE %base |
− | ?record | + | ?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 | + | GROUP BY ?languageLabel ?wikidata ?iso ?malesCount ?malesRecords ?femalesCount ?femalesRecords |
− | ORDER BY | + | 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": " | ||
− | "wikidata": " | ||
− | "iso": " | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | " | ||
− | " | ||
− | " | ||
− | " | ||
− | " | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
}, | }, | ||
{ | { | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
"languageLabel": "Arabic", | "languageLabel": "Arabic", | ||
"wikidata": "Q13955", | "wikidata": "Q13955", | ||
"iso": "ara", | "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", | "languageLabel": "Basque", | ||
"wikidata": "Q8752", | "wikidata": "Q8752", | ||
"iso": "eus", | "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", | |
− | "languageLabel": " | + | "wikidata": "Q9186", |
− | "wikidata": " | + | "iso": "yue", |
− | "iso": " | + | "malesCount": "2", |
− | " | + | "malesRecords": "298", |
− | " | + | "femalesCount": "1", |
− | " | + | "femalesRecords": "5393", |
− | + | "percent": "94.8" | |
− | |||
− | " | ||
− | " | ||
− | |||
− | |||
− | |||
− | |||
− | |||
}, | }, | ||
{ | { | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
"languageLabel": "Central Bikol", | "languageLabel": "Central Bikol", | ||
"wikidata": "Q33284", | "wikidata": "Q33284", | ||
"iso": "bcl", | "iso": "bcl", | ||
− | " | + | "malesCount": "3", |
− | " | + | "malesRecords": "17", |
− | " | + | "femalesCount": "1", |
− | + | "femalesRecords": "74", | |
− | + | "percent": "81.3" | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | " | ||
− | |||
− | |||
− | " | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
}, | }, | ||
{ | { | ||
− | |||
"languageLabel": "Chinese writing", | "languageLabel": "Chinese writing", | ||
"wikidata": "Q7850", | "wikidata": "Q7850", | ||
"iso": "zho", | "iso": "zho", | ||
− | " | + | "malesCount": "1", |
− | " | + | "malesRecords": "3", |
− | " | + | "femalesCount": "4", |
− | + | "femalesRecords": "184", | |
− | + | "percent": "98.4" | |
− | |||
− | |||
− | |||
− | |||
− | " | ||
− | " | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
}, | }, | ||
{ | { | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
"languageLabel": "Cornish", | "languageLabel": "Cornish", | ||
"wikidata": "Q25289", | "wikidata": "Q25289", | ||
"iso": "cor", | "iso": "cor", | ||
− | " | + | "malesCount": "1", |
− | " | + | "malesRecords": "9", |
− | " | + | "femalesCount": "1", |
+ | "femalesRecords": "139", | ||
+ | "percent": "93.9" | ||
}, | }, | ||
{ | { | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
"languageLabel": "Dioula language", | "languageLabel": "Dioula language", | ||
"wikidata": "Q32706", | "wikidata": "Q32706", | ||
"iso": "dyu", | "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", | |
− | "languageLabel": " | + | "wikidata": "Q33302", |
− | "wikidata": " | + | "iso": "fsl", |
− | "iso": " | + | "malesCount": "2", |
− | " | + | "malesRecords": "4", |
− | " | + | "femalesCount": "1", |
− | + | "femalesRecords": "570", | |
− | + | "percent": "99.3" | |
− | " | ||
− | " | ||
− | " | ||
− | |||
− | |||
− | |||
− | |||
}, | }, | ||
{ | { | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
"languageLabel": "Galician", | "languageLabel": "Galician", | ||
"wikidata": "Q9307", | "wikidata": "Q9307", | ||
"iso": "glg", | "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" | ||
}, | }, | ||
{ | { | ||
− | "language": " | + | "languageLabel": "Ghomala' language", |
− | " | + | "wikidata": "Q35271", |
− | " | + | "iso": "bbj", |
− | " | + | "malesCount": "3", |
− | " | + | "malesRecords": "91", |
− | " | + | "femalesCount": "2", |
+ | "femalesRecords": "96", | ||
+ | "percent": "51.3" | ||
}, | }, | ||
{ | { | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
"languageLabel": "Greek", | "languageLabel": "Greek", | ||
"wikidata": "Q9129", | "wikidata": "Q9129", | ||
"iso": "gre", | "iso": "gre", | ||
− | " | + | "malesCount": "1", |
− | " | + | "malesRecords": "5", |
− | " | + | "femalesCount": "1", |
− | + | "femalesRecords": "13", | |
− | + | "percent": "72.2" | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | " | ||
− | " | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
}, | }, | ||
{ | { | ||
− | |||
"languageLabel": "Haitian Creole", | "languageLabel": "Haitian Creole", | ||
"wikidata": "Q33491", | "wikidata": "Q33491", | ||
"iso": "hat", | "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" | ||
}, | }, | ||
{ | { | ||
− | "language": " | + | "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", | |
− | "languageLabel": " | + | "wikidata": "Q9309", |
− | "wikidata": " | + | "iso": "cym", |
− | " | + | "malesCount": "6", |
− | " | + | "malesRecords": "791", |
− | + | "femalesCount": "3", | |
− | + | "femalesRecords": "70", | |
− | " | + | "percent": "8.1" |
− | " | ||
− | " | ||
− | " | ||
− | |||
} | } | ||
] | ] |
Revision as of 14:09, 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"
}
]