User:Fnielsen/Gender
Jump to navigation
Jump to search
Try it!
Try it!
Try it!
Try it!
Gender
Personer beskrevet på den danske Wikipedia per køn[edit]
Kønnet bestemt udfra Wikidata annotering og tilstedeværelsen af et link fra Wikidata til Den Danske Wikipedia.
SELECT
?count ?gender ?genderLabel
WHERE {
{
SELECT
(COUNT(DISTINCT ?person) AS ?count) ?gender
WHERE {
?person wdt:P21 ?gender .
?person wdt:P31 wd:Q5 .
?article schema:about ?person .
?article schema:isPartOf <https://da.wikipedia.org/> .
}
GROUP BY ?gender
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "da". }
}
ORDER BY DESC(?count)
2019-01-22: Mænd 58117, kvinder: 12070, Andre: 15+3+3+2+1=24
Kvindeforhold: 12070 / (58117 + 12070 + 24) = 17.2%
Mandeforhold: 58117 / (58117 + 12070 + 24) = 82.8%
Personer på Wikisource fordelt på køn[edit]
SELECT
?count ?language ?gender ?genderLabel
WHERE {
{
SELECT
(COUNT(DISTINCT ?person) AS ?count) ?gender ?language
WHERE {
[] schema:isPartOf / wikibase:wikiGroup "wikisource" ;
schema:inLanguage ?language ;
schema:about ?person .
?person wdt:P21 ?gender .
VALUES ?gender { wd:Q6581097 wd:Q6581072 }
}
GROUP BY ?gender ?language
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "da". }
}
ORDER BY ?language ?gender
Kvindeforhold på den danske Wikipedia per dekade[edit]
#defaultView:LineChart
SELECT
(STR(?year_) AS ?year)
(COALESCE(SAMPLE(?number_of_females), 0)
/ (COALESCE(SAMPLE(?number_of_females), 0)
+ SAMPLE(?number_of_males)) AS ?female_ratio)
WITH {
SELECT
(MIN(?years) AS ?year_)
?person
WHERE {
?person wdt:P31 wd:Q5 .
?person wdt:P21 ?gender .
?article schema:about ?person .
?article schema:isPartOf <https://da.wikipedia.org/> .
?person wdt:P569 ?datetime .
FILTER (?datetime >= "1850-01-01T00:00:00Z"^^xsd:dateTime)
BIND(CONCAT(SUBSTR(STR(YEAR(?datetime)), 1, 3), "0-9") AS ?years)
}
GROUP BY ?person
} AS %persons
WHERE {
{
SELECT
?year_
(COUNT(?person) AS ?number_of_females)
WHERE {
INCLUDE %persons
?person wdt:P21 wd:Q6581072 .
}
GROUP BY ?year_
}
UNION
{
SELECT
?year_
(COUNT(?person) AS ?number_of_males)
WHERE {
INCLUDE %persons
?person wdt:P21 wd:Q6581097
}
GROUP BY ?year_
}
}
GROUP BY ?year_
ORDER BY DESC(?year)
De yngste er typisk kongelige børn.
SELECT
?person ?personLabel
WHERE {
{
SELECT ?person WHERE {
?person wdt:P31 wd:Q5 .
?person wdt:P21 ?gender .
?article schema:about ?person .
?article schema:isPartOf <https://da.wikipedia.org/> .
?person wdt:P569 ?datetime .
FILTER (?datetime >= "2010-01-01T00:00:00Z"^^xsd:dateTime)
}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "da". }
}
Mulige ny Wikipedia-artikler[edit]
- Modtagere af Q61268766