Difference between revisions of "What is the proportion of presidents who have died in held position? (Q440)"

From QAWiki
Jump to navigation Jump to search
(‎Created claim: mention (P38): presidente)
(‎Created claim: mention (P38): muerto)
 
(32 intermediate revisions by 2 users not shown)
label / eslabel / es
¿Cuál es la proporción de presidentes que han muerto ejerciendo?
¿Cuál es la proporción de presidentes que han muerto ejerciendo su cargo?
label / enlabel / en
 
What is the proportion of presidents who have died in held position?
aliases / en / 0aliases / en / 0
 
What ratio of presidents have died in office?
aliases / es / 0aliases / es / 0
 
¿Qué cociente de presidentes han muerto durante su mandato?
Property / queryProperty / query
SELECT (((COUNT(DISTINCT?deathPresident))/(COUNT(DISTINCT?president))) AS ?p) WHERE { ?president wdt:P39/wdt:P279* wd:Q30461. ?deathPresident wdt:P39/wdt:P279* wd:Q30461; p:P39/wdt:P279* ?presidency . ?presidency ps:P39/wdt:P279* wd:Q30461; pq:P1534 /wdt:P279* wd:Q99521170 . }
SELECT (COUNT(?obj3) / COUNT(DISTINCT ?sbj) AS ?ratio) WHERE { { SELECT DISTINCT ?sbj ?obj3 WHERE { ?sbj p:P39 ?obj1 . ?obj1 ps:P39 ?obj2 . ?obj2 wdt:P31?/wdt:P279* wd:Q30461 . OPTIONAL { ?obj1 pq:P1534/wdt:P279* ?obj3 . FILTER(?obj3 = wd:Q99521170) } } } }
Property / query: SELECT (COUNT(?obj3) / COUNT(DISTINCT ?sbj) AS ?ratio) WHERE { { SELECT DISTINCT ?sbj ?obj3 WHERE { ?sbj p:P39 ?obj1 . ?obj1 ps:P39 ?obj2 . ?obj2 wdt:P31?/wdt:P279* wd:Q30461 . OPTIONAL { ?obj1 pq:P1534/wdt:P279* ?obj3 . FILTER(?obj3 = wd:Q99521170) } } } } / qualifier
 
Property / query: SELECT (COUNT(?obj3) / COUNT(DISTINCT ?sbj) AS ?ratio) WHERE { { SELECT DISTINCT ?sbj ?obj3 WHERE { ?sbj p:P39 ?obj1 . ?obj1 ps:P39 ?obj2 . ?obj2 wdt:P31?/wdt:P279* wd:Q30461 . OPTIONAL { ?obj1 pq:P1534/wdt:P279* ?obj3 . FILTER(?obj3 = wd:Q99521170) } } } } / qualifier
 
Property / query: SELECT (COUNT(?obj3) / COUNT(DISTINCT ?sbj) AS ?ratio) WHERE { { SELECT DISTINCT ?sbj ?obj3 WHERE { ?sbj p:P39 ?obj1 . ?obj1 ps:P39 ?obj2 . ?obj2 wdt:P31?/wdt:P279* wd:Q30461 . OPTIONAL { ?obj1 pq:P1534/wdt:P279* ?obj3 . FILTER(?obj3 = wd:Q99521170) } } } } / qualifier
 
Property / query: SELECT (COUNT(?obj3) / COUNT(DISTINCT ?sbj) AS ?ratio) WHERE { { SELECT DISTINCT ?sbj ?obj3 WHERE { ?sbj p:P39 ?obj1 . ?obj1 ps:P39 ?obj2 . ?obj2 wdt:P31?/wdt:P279* wd:Q30461 . OPTIONAL { ?obj1 pq:P1534/wdt:P279* ?obj3 . FILTER(?obj3 = wd:Q99521170) } } } } / qualifier
 
Property / query: SELECT (COUNT(?obj3) / COUNT(DISTINCT ?sbj) AS ?ratio) WHERE { { SELECT DISTINCT ?sbj ?obj3 WHERE { ?sbj p:P39 ?obj1 . ?obj1 ps:P39 ?obj2 . ?obj2 wdt:P31?/wdt:P279* wd:Q30461 . OPTIONAL { ?obj1 pq:P1534/wdt:P279* ?obj3 . FILTER(?obj3 = wd:Q99521170) } } } } / qualifier
 
comment: Data are noisy due to inclusion of presidents not of countries (English)
Property / query: SELECT (COUNT(?obj3) / COUNT(DISTINCT ?sbj) AS ?ratio) WHERE { { SELECT DISTINCT ?sbj ?obj3 WHERE { ?sbj p:P39 ?obj1 . ?obj1 ps:P39 ?obj2 . ?obj2 wdt:P31?/wdt:P279* wd:Q30461 . OPTIONAL { ?obj1 pq:P1534/wdt:P279* ?obj3 . FILTER(?obj3 = wd:Q99521170) } } } } / qualifier
 
comment: Los datos contienen ruido relacionado con presidentes no de países (Spanish)
Property / mentionProperty / mention
position held (English)
position (English)
Property / mention: position (English) / qualifier
 
Property / mention: position (English) / qualifier
 
Property / mention: position held (English) / qualifier
 
Property / mentionProperty / mention
cargo ocupado (Spanish)
cargo (Spanish)
Property / mention: cargo (Spanish) / qualifier
 
Property / mention: cargo (Spanish) / qualifier
 
Property / mention: cargo ocupado (Spanish) / qualifier
 
Property / mentionProperty / mention
president (English)
presidents (English)
Property / mentionProperty / mention
presidente (Spanish)
presidentes (Spanish)
Property / mention
 
died in held position (English)
Property / mention: died in held position (English) / rank
 
Normal rank
Property / mention: died in held position (English) / qualifier
 
Property / mention: died in held position (English) / qualifier
 
Property / mention: died in held position (English) / qualifier
 
Property / mention
 
han muerto ejerciendo su cargo (Spanish)
Property / mention: han muerto ejerciendo su cargo (Spanish) / rank
 
Normal rank
Property / mention: han muerto ejerciendo su cargo (Spanish) / qualifier
 
Property / mention: han muerto ejerciendo su cargo (Spanish) / qualifier
 
Property / mention: han muerto ejerciendo su cargo (Spanish) / qualifier
 
Property / mention
 
held position (English)
Property / mention: held position (English) / rank
 
Normal rank
Property / mention: held position (English) / qualifier
 
Property / mention
 
office (English)
Property / mention: office (English) / rank
 
Normal rank
Property / mention: office (English) / qualifier
 
Property / mention: office (English) / qualifier
 
Property / mention
 
han muerto durante su mandato (Spanish)
Property / mention: han muerto durante su mandato (Spanish) / rank
 
Normal rank
Property / mention: han muerto durante su mandato (Spanish) / qualifier
 
Property / mention: han muerto durante su mandato (Spanish) / qualifier
 
Property / mention: han muerto durante su mandato (Spanish) / qualifier
 
Property / mention
 
mandato (Spanish)
Property / mention: mandato (Spanish) / rank
 
Normal rank
Property / mention: mandato (Spanish) / qualifier
 
Property / mention: mandato (Spanish) / qualifier
 
Property / mention
 
died (English)
Property / mention: died (English) / rank
 
Normal rank
Property / mention: died (English) / qualifier
 
Property / mention
 
muerto (Spanish)
Property / mention: muerto (Spanish) / rank
 
Normal rank
Property / mention: muerto (Spanish) / qualifier
 

Latest revision as of 00:25, 19 May 2025

No description defined
  • What ratio of presidents have died in office?
Language Label Description Also known as
English
What is the proportion of presidents who have died in held position?
No description defined
  • What ratio of presidents have died in office?

Statements

instance of
question
0 references
query
SELECT (COUNT(?obj3) / COUNT(DISTINCT ?sbj) AS ?ratio) WHERE { { SELECT DISTINCT ?sbj ?obj3 WHERE { ?sbj p:P39 ?obj1 . ?obj1 ps:P39 ?obj2 . ?obj2 wdt:P31?/wdt:P279* wd:Q30461 . OPTIONAL { ?obj1 pq:P1534/wdt:P279* ?obj3 . FILTER(?obj3 = wd:Q99521170) } } } }
dataset
Wikidata
query language
SPARQL
issue
incomplete data
unclear criteria
comment
Data are noisy due to inclusion of presidents not of countries (English)
Los datos contienen ruido relacionado con presidentes no de países (Spanish)
0 references
mention
position (English)
Wikidata property ID
P39
Wikidata item ID
Q4164871
0 references
cargo (Spanish)
Wikidata property ID
P39
Wikidata item ID
Q4164871
0 references
presidents (English)
Wikidata item ID
Q30461
0 references
presidentes (Spanish)
Wikidata item ID
Q30461
0 references
died in held position (English)
Wikidata item ID
Q99521170
Q5247364
value of Wikidata property ID
P1534
0 references
han muerto ejerciendo su cargo (Spanish)
Wikidata item ID
Q99521170
Q5247364
value of Wikidata property ID
P1534
0 references
held position (English)
Wikidata property ID
P39
0 references
office (English)
Wikidata item ID
Q294414
Wikidata property ID
P39
0 references
han muerto durante su mandato (Spanish)
Wikidata item ID
Q99521170
Q5247364
value of Wikidata property ID
P1534
0 references
mandato (Spanish)
Wikidata item ID
Q294414
Wikidata property ID
P39
0 references
died (English)
Wikidata item ID
Q4
0 references
muerto (Spanish)
Wikidata item ID
Q4
0 references
 
Retrieved from "http://qawiki.org/w/index.php?title=Item:Q440&oldid=14487"