Wikidata

User:MartinPoulter/queries/equity research

< User:MartinPoulter‎ | queries

Visual art edit

Wikidata statements count for 100 Western artists edit 

SELECT ?q ?statements WHERE {
VALUES ?q {wd:Q184814 wd:Q762 wd:Q5592 wd:Q5598 wd:Q296 wd:Q5582 wd:Q5593 wd:Q7814 wd:Q130531 wd:Q102272 wd:Q5669 wd:Q43270 wd:Q42207 wd:Q83155 wd:Q5580 wd:Q212657 wd:Q301 wd:Q5432 wd:Q171344 wd:Q48319 wd:Q5811 wd:Q41554 wd:Q5597 wd:Q5599 wd:Q47551 wd:Q297 wd:Q41264 wd:Q35548 wd:Q93284 wd:Q159297 wd:Q34618 wd:Q5577 wd:Q46373 wd:Q33477 wd:Q5912 wd:Q154842 wd:Q104884 wd:Q37693 wd:Q203401 wd:Q23380 wd:Q61064 wd:Q44007 wd:Q7836 wd:Q130777 wd:Q40599 wd:Q44054 wd:Q5589 wd:Q152384 wd:Q151803 wd:Q41406 wd:Q46408 wd:Q134741 wd:Q37571 wd:Q39931 wd:Q172911 wd:Q164351 wd:Q156386 wd:Q155626 wd:Q34013 wd:Q82445 wd:Q159758 wd:Q5603 wd:Q203643 wd:Q160538 wd:Q153965 wd:Q153048 wd:Q37562 wd:Q157194 wd:Q151097 wd:Q151152 wd:Q30755 wd:Q272566 wd:Q1470 wd:Q271884 wd:Q182589 wd:Q189762 wd:Q154340 wd:Q182664 wd:Q151679 wd:Q1354277 wd:Q83158 wd:Q133600 wd:Q154594 wd:Q159907 wd:Q155407 wd:Q41513 wd:Q354779 wd:Q360371 wd:Q205148 wd:Q702272 wd:Q209615 wd:Q208993 wd:Q214074 wd:Q17169 wd:Q170068 wd:Q381458 wd:Q173223 wd:Q150679 wd:Q132305 wd:Q234109}
?q wikibase:statements ?statements
}
Try it!

Image gallery of Western masterpieces edit 

#defaultView:ImageGrid{"hide": ["?img"]}
SELECT ?q ?qLabel (SAMPLE(?image) AS ?img) (GROUP_CONCAT(DISTINCT ?creatorname; separator="; ") AS ?artist_list) (YEAR(SAMPLE(?date)) AS ?year) WHERE {
VALUES ?q {wd:Q187483 wd:Q151047 wd:Q321303 wd:Q128910 wd:Q235242 wd:Q219831 wd:Q630530 wd:Q152509 wd:Q18003128 wd:Q45585 wd:Q471379 wd:Q25729 wd:Q175036 wd:Q83872 wd:Q220859 wd:Q1189907 wd:Q1759631 wd:Q734834 wd:Q735085 wd:Q179900 wd:Q1217288 wd:Q12418 wd:Q844675 wd:Q186953 wd:Q1206860 wd:Q94802 wd:Q567861 wd:Q699091 wd:Q500985 wd:Q655705 wd:Q2653851 wd:Q208758 wd:Q185372 wd:Q3207063 wd:Q1619527 wd:Q636537 wd:Q1978815 wd:Q212616 wd:Q2366825 wd:Q29530 wd:Q15992445 wd:Q509806 wd:Q970968 wd:Q1213936 wd:Q2664039 wd:Q890678 wd:Q698487 wd:Q2272215 wd:Q421716 wd:Q2990634 wd:Q1212937 wd:Q2381632 wd:Q464782 wd:Q2465911 wd:Q1311080 wd:Q780466 wd:Q15008032 wd:Q6583495 wd:Q2727560 wd:Q2247406 wd:Q2352789 wd:Q3998985 wd:Q7735033 wd:Q311243 wd:Q3697674 wd:Q2629559 wd:Q59201 wd:Q1091086 wd:Q219344 wd:Q3222585 wd:Q2384215 wd:Q1065493 wd:Q1368055 wd:Q2622172 wd:Q1195035 wd:Q175628 wd:Q7728560 wd:Q1167907 wd:Q1090837 wd:Q331225 wd:Q4156438 wd:Q18346884 wd:Q3633443 wd:Q960447 wd:Q17277950 wd:Q95984336 wd:Q3205060 wd:Q164517 wd:Q1170315 wd:Q3877556 wd:Q5526647 wd:Q1192436 wd:Q1052784 wd:Q3210239 wd:Q2905377 wd:Q1061035 wd:Q19609193 wd:Q19904229 wd:Q1769529 wd:Q19760121}
  OPTIONAL {?q wdt:P18 ?commons_image}
    BIND (IF(BOUND(?commons_image), ?commons_image, <http://commons.wikimedia.org/wiki/Special:FilePath/No%20image%20available.svg>) AS ?image)
  OPTIONAL {?q wdt:P170 ?creator. ?creator rdfs:label ?creatorname FILTER(lang(?creatorname)="[AUTO_LANGUAGE]")}
  OPTIONAL {?q wdt:P571 ?inception}
    OPTIONAL {?q wdt:P577 ?publication}
    BIND (IF(BOUND(?inception), ?inception, ?publication) AS ?date) 
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} GROUP BY ?q ?qLabel ORDER BY ?year
Try it!

100 Western masterpieces edit

wd:Q187483 wd:Q151047 wd:Q321303 wd:Q128910 wd:Q235242 wd:Q219831 wd:Q630530 wd:Q152509 wd:Q18003128 wd:Q45585 wd:Q471379 wd:Q25729 wd:Q175036 wd:Q83872 wd:Q220859 wd:Q1189907 wd:Q1759631 wd:Q734834 wd:Q735085 wd:Q179900 wd:Q1217288 wd:Q12418 wd:Q844675 wd:Q186953 wd:Q1206860 wd:Q94802 wd:Q567861 wd:Q699091 wd:Q500985 wd:Q655705 wd:Q2653851 wd:Q208758 wd:Q185372 wd:Q3207063 wd:Q1619527 wd:Q636537 wd:Q1978815 wd:Q212616 wd:Q2366825 wd:Q29530 wd:Q15992445 wd:Q509806 wd:Q970968 wd:Q1213936 wd:Q2664039 wd:Q890678 wd:Q698487 wd:Q2272215 wd:Q421716 wd:Q2990634 wd:Q1212937 wd:Q2381632 wd:Q464782 wd:Q2465911 wd:Q1311080 wd:Q780466 wd:Q15008032 wd:Q6583495 wd:Q2727560 wd:Q2247406 wd:Q2352789 wd:Q3998985 wd:Q7735033 wd:Q311243 wd:Q3697674 wd:Q2629559 wd:Q59201 wd:Q1091086 wd:Q219344 wd:Q3222585 wd:Q2384215 wd:Q1065493 wd:Q1368055 wd:Q2622172 wd:Q1195035 wd:Q175628 wd:Q7728560 wd:Q1167907 wd:Q1090837 wd:Q331225 wd:Q4156438 wd:Q18346884 wd:Q3633443 wd:Q960447 wd:Q17277950 wd:Q95984336 wd:Q3205060 wd:Q164517 wd:Q1170315 wd:Q3877556 wd:Q5526647 wd:Q1192436 wd:Q1052784 wd:Q3210239 wd:Q2905377 wd:Q1061035 wd:Q19609193 wd:Q19904229 wd:Q1769529 wd:Q19760121

100 non-Western artists (1 without Q number) edit

wd:Q3566081 wd:Q36020 wd:Q716331 wd:Q197342 wd:Q2245281 wd:Q2006048 wd:Q433603 wd:Q1360244 wd:Q2739948 wd:Q2915617 wd:Q2032614 wd:Q197461 wd:Q702525 wd:Q704735 wd:Q731030 wd:Q700903 wd:Q2706164 wd:Q484901 wd:Q3561135 wd:Q334875 wd:Q6712884 wd:Q1937873 wd:Q728311 wd:Q6752753 wd:Q3571072 wd:Q380726 wd:Q453832 wd:Q3156405 wd:Q5588580 wd:Q588110 wd:Q307497 wd:Q198097 wd:Q735871 wd:Q16224779 wd:Q4665830 wd:Q866302 wd:Q856754 wd:Q4298226 wd:Q2386947 wd:Q1375979 wd:Q1190012 wd:Q1659496 wd:Q333453 wd:Q7241 wd:Q369608 wd:Q691796 wd:Q520713 wd:Q3348980 wd:Q332041 wd:Q466627 wd:Q171128 wd:Q465919 wd:Q9012423 wd:Q464988 wd:Q281203 wd:Q148400 wd:Q28483 wd:Q6734398 wd:Q690790 wd:Q1269352 wd:Q465342 wd:Q560086 wd:Q4216829 wd:Q5588 wd:Q7633801 wd:Q453890 wd:Q7849256 wd:Q450236 wd:Q5543308 wd:Q3103960 wd:Q150312 wd:Q175745 wd:Q2443222 wd:Q2326096 wd:Q558522 wd:Q2399275 wd:Q4885605 wd:Q351430 wd:Q2367328 wd:Q332420 wd:Q5221627 wd:Q712390 wd:Q7675477 wd:Q2720307 wd:Q203768 wd:Q1397989 wd:Q732347 wd:Q4664743 wd:Q122347 wd:Q6671884 wd:Q2662098 wd:Q1943578 wd:Q382165 wd:Q440221 wd:Q272877 wd:Q15461959 wd:Q3894655 wd:Q384560 wd:Q966300

100 non-Western masterpieces (66 without Q numbers) edit

wd:Q2040958 wd:Q47604352 wd:Q736832 wd:Q57820024 wd:Q15592269 wd:Q15409979 wd:Q706846 wd:Q1262004 wd:Q1950283 wd:Q5299596 wd:Q3114572 wd:Q1766064 wd:Q44461629 wd:Q28840318 wd:Q3278527 wd:Q17144276 wd:Q21741513 wd:Q28913656 wd:Q27954536 wd:Q18177323 wd:Q7487097 wd:Q69257018 wd:Q95639662 wd:Q20474457 wd:Q15631050 wd:Q2072991 wd:Q16685337 wd:Q100353485 wd:Q85112920 wd:Q19884814 wd:Q5572241 wd:Q20487143 wd:Q1627110 wd:Q7969530

Commons categories for 100 Western artists edit 

SELECT ?q ?category WHERE {
VALUES ?q {wd:Q184814 wd:Q762 wd:Q5592 wd:Q5598 wd:Q296 wd:Q5582 wd:Q5593 wd:Q7814 wd:Q130531 wd:Q102272 wd:Q5669 wd:Q43270 wd:Q42207 wd:Q83155 wd:Q5580 wd:Q212657 wd:Q301 wd:Q5432 wd:Q171344 wd:Q48319 wd:Q5811 wd:Q41554 wd:Q5597 wd:Q5599 wd:Q47551 wd:Q297 wd:Q41264 wd:Q35548 wd:Q93284 wd:Q159297 wd:Q34618 wd:Q5577 wd:Q46373 wd:Q33477 wd:Q5912 wd:Q154842 wd:Q104884 wd:Q37693 wd:Q203401 wd:Q23380 wd:Q61064 wd:Q44007 wd:Q7836 wd:Q130777 wd:Q40599 wd:Q44054 wd:Q5589 wd:Q152384 wd:Q151803 wd:Q41406 wd:Q46408 wd:Q134741 wd:Q37571 wd:Q39931 wd:Q172911 wd:Q164351 wd:Q156386 wd:Q155626 wd:Q34013 wd:Q82445 wd:Q159758 wd:Q5603 wd:Q203643 wd:Q160538 wd:Q153965 wd:Q153048 wd:Q37562 wd:Q157194 wd:Q151097 wd:Q151152 wd:Q30755 wd:Q272566 wd:Q1470 wd:Q271884 wd:Q182589 wd:Q189762 wd:Q154340 wd:Q182664 wd:Q151679 wd:Q1354277 wd:Q83158 wd:Q133600 wd:Q154594 wd:Q159907 wd:Q155407 wd:Q41513 wd:Q354779 wd:Q360371 wd:Q205148 wd:Q702272 wd:Q209615 wd:Q208993 wd:Q214074 wd:Q17169 wd:Q170068 wd:Q381458 wd:Q173223 wd:Q150679 wd:Q132305 wd:Q234109}
  ?q wdt:P373 ?category
}
Try it!

All links for an artist with language and article title edit 

SELECT ?lang ?link ?article WHERE {
?link schema:about wd:Q762; schema:inLanguage ?lang; schema:name ?article
FILTER(CONTAINS(str(?link), ".wikipedia.org/")) # only Wikipedia links
}
Try it!

Wikipedia article count for Western artists edit 

SELECT ?q (COUNT(?link) AS ?wplinks) WHERE {
VALUES ?q {wd:Q184814 wd:Q762 wd:Q5592 wd:Q5598 wd:Q296 wd:Q5582 wd:Q5593 wd:Q7814 wd:Q130531 wd:Q102272 wd:Q5669 wd:Q43270 wd:Q42207 wd:Q83155 wd:Q5580 wd:Q212657 wd:Q301 wd:Q5432 wd:Q171344 wd:Q48319 wd:Q5811 wd:Q41554 wd:Q5597 wd:Q5599 wd:Q47551 wd:Q297 wd:Q41264 wd:Q35548 wd:Q93284 wd:Q159297 wd:Q34618 wd:Q5577 wd:Q46373 wd:Q33477 wd:Q5912 wd:Q154842 wd:Q104884 wd:Q37693 wd:Q203401 wd:Q23380 wd:Q61064 wd:Q44007 wd:Q7836 wd:Q130777 wd:Q40599 wd:Q44054 wd:Q5589 wd:Q152384 wd:Q151803 wd:Q41406 wd:Q46408 wd:Q134741 wd:Q37571 wd:Q39931 wd:Q172911 wd:Q164351 wd:Q156386 wd:Q155626 wd:Q34013 wd:Q82445 wd:Q159758 wd:Q5603 wd:Q203643 wd:Q160538 wd:Q153965 wd:Q153048 wd:Q37562 wd:Q157194 wd:Q151097 wd:Q151152 wd:Q30755 wd:Q272566 wd:Q1470 wd:Q271884 wd:Q182589 wd:Q189762 wd:Q154340 wd:Q182664 wd:Q151679 wd:Q1354277 wd:Q83158 wd:Q133600 wd:Q154594 wd:Q159907 wd:Q155407 wd:Q41513 wd:Q354779 wd:Q360371 wd:Q205148 wd:Q702272 wd:Q209615 wd:Q208993 wd:Q214074 wd:Q17169 wd:Q170068 wd:Q381458 wd:Q173223 wd:Q150679 wd:Q132305 wd:Q234109}
?link schema:about ?q FILTER(CONTAINS(str(?link), ".wikipedia.org/"))
} GROUP BY ?q ORDER BY ?q
Try it!

All Wikipedia article links for 100 Western artists edit 

SELECT ?q ?lang ?link ?article WHERE {
VALUES ?q {wd:Q184814 wd:Q762 wd:Q5592 wd:Q5598 wd:Q296 wd:Q5582 wd:Q5593 wd:Q7814 wd:Q130531 wd:Q102272 wd:Q5669 wd:Q43270 wd:Q42207 wd:Q83155 wd:Q5580 wd:Q212657 wd:Q301 wd:Q5432 wd:Q171344 wd:Q48319 wd:Q5811 wd:Q41554 wd:Q5597 wd:Q5599 wd:Q47551 wd:Q297 wd:Q41264 wd:Q35548 wd:Q93284 wd:Q159297 wd:Q34618 wd:Q5577 wd:Q46373 wd:Q33477 wd:Q5912 wd:Q154842 wd:Q104884 wd:Q37693 wd:Q203401 wd:Q23380 wd:Q61064 wd:Q44007 wd:Q7836 wd:Q130777 wd:Q40599 wd:Q44054 wd:Q5589 wd:Q152384 wd:Q151803 wd:Q41406 wd:Q46408 wd:Q134741 wd:Q37571 wd:Q39931 wd:Q172911 wd:Q164351 wd:Q156386 wd:Q155626 wd:Q34013 wd:Q82445 wd:Q159758 wd:Q5603 wd:Q203643 wd:Q160538 wd:Q153965 wd:Q153048 wd:Q37562 wd:Q157194 wd:Q151097 wd:Q151152 wd:Q30755 wd:Q272566 wd:Q1470 wd:Q271884 wd:Q182589 wd:Q189762 wd:Q154340 wd:Q182664 wd:Q151679 wd:Q1354277 wd:Q83158 wd:Q133600 wd:Q154594 wd:Q159907 wd:Q155407 wd:Q41513 wd:Q354779 wd:Q360371 wd:Q205148 wd:Q702272 wd:Q209615 wd:Q208993 wd:Q214074 wd:Q17169 wd:Q170068 wd:Q381458 wd:Q173223 wd:Q150679 wd:Q132305 wd:Q234109}
?link schema:about ?q; schema:inLanguage ?lang; schema:name ?article
FILTER(CONTAINS(str(?link), ".wikipedia.org/"))
} ORDER BY ?q ?lang
Try it!

Wikmedia languages and their language codes edit 

SELECT DISTINCT ?code ?langLabel WHERE {
?lang wdt:P424 ?code.
{?lang wdt:P31 wd:Q34770} UNION {?lang wdt:P31/wdt:P31 wd:Q20829075} UNION {?lang wdt:P31/wdt:P279? wd:Q33215}
# language or type of language or constructed language (e.g Volapuk) or type of constructed language (e.g. Simple English = controlled language)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?code
Try it!

Analysis of the geographical distribution of artists in English Wikipedia's list of sculptors edit

Inspired by queries by User:PAC2 

#defaultView:BarChart
#title:Continents of individuals mentioned in "List of sculptors"
SELECT ?cont ?contLabel (COUNT(?item) AS ?count)
WHERE {
  SERVICE wikibase:mwapi {
     bd:serviceParam wikibase:endpoint "en.wikipedia.org";
                     wikibase:api "Generator";
                     mwapi:generator "links";
                     mwapi:titles "List of sculptors".
     ?item wikibase:apiOutputItem mwapi:item.
  } 
  FILTER BOUND (?item)
  ?item wdt:P31 wd:Q5 .  # restrict to human beings
  ?item wdt:P27/wdt:P30 ?cont . # continent of country of citizenship
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?cont ?contLabel
ORDER BY ?contLabel
Continents of individuals mentioned in "List of sculptors"

Religions and worldviews edit

Religions and worldviews and their notable adherents edit 

#title:Religions and worldviews with numbers of adherents known to Wikidata
SELECT ?rel ?relLabel ?count WITH
{ SELECT ?rel (COUNT(?item) AS ?count) WHERE {?item wdt:P31 wd:Q5 ; # human
  wdt:P140 ?rel } GROUP BY ?rel } AS %sub
WHERE {
  INCLUDE %sub
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} ORDER BY DESC(?count)
Religions and worldviews with numbers of adherents known to Wikidata

Comparison of Christian hymns and bhajans (Hindu/Buddhist devotional songs) edit 

#title:Comparison of Christian hymns and bhajans
SELECT ?type ?typeLabel (COUNT(DISTINCT ?item) AS ?count) (SUM(?links) AS ?sites) WHERE {
{ BIND(wd:Q856713 AS ?type) .
  ?item wdt:P31/wdt:P279? wd:Q856713 .
?item wikibase:sitelinks ?links }
UNION {
  BIND(wd:Q854775 AS ?type) .
  ?item wdt:P31/wdt:P279? wd:Q854775 .
  ?item wikibase:sitelinks ?links 
} 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?type ?typeLabel
Comparison of Christian hymns and bhajans


All sizes of Wikipedia articles on a topic edit 

SELECT ?sitelink ?size
WHERE {
VALUES ?item1 {wd:Q9438}
?sitelink schema:about ?item1  # get Wikimedia pages
FILTER(CONTAINS(str(?sitelink), ".wikipedia.org/")) # only Wikipedia articles
?sitelink schema:name ?title ; schema:isPartOf ?site.
BIND(REPLACE(SUBSTR(STR(?site), 9), '/', '') AS ?endpoint)
OPTIONAL{
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Generator" ; 
    wikibase:endpoint ?endpoint ;
    mwapi:generator "allpages" ;
    mwapi:gapfrom ?title ;
    mwapi:gapto ?title ;
    mwapi:prop "revisions" ;
    mwapi:rvprop "size" .
    ?bytes wikibase:apiOutput "revisions/rev/@size" .
  }
BIND (xsd:integer(?bytes) AS ?size)
}
} ORDER BY DESC(?size)
Try it!

Totals version of above edit 

SELECT ?item1 (SUM(?size) as ?total_bytes) (COUNT(?sitelink) AS ?sites)
WHERE {
VALUES ?item1 {wd:Q9438}
?sitelink schema:about ?item1  # get Wikimedia pages
FILTER(CONTAINS(str(?sitelink), ".wikipedia.org/")) # only Wikipedia articles
?sitelink schema:name ?title ; schema:isPartOf ?site.
BIND(REPLACE(SUBSTR(STR(?site), 9), '/', '') AS ?endpoint)
OPTIONAL{
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Generator" ; 
    wikibase:endpoint ?endpoint ;
    mwapi:generator "allpages" ;
    mwapi:gapfrom ?title ;
    mwapi:gapto ?title ;
    mwapi:prop "revisions" ;
    mwapi:rvprop "size" .
    ?bytes wikibase:apiOutput "revisions/rev/@size" .
  }
  BIND (xsd:integer(?bytes) AS ?size)
   } 
} GROUP BY ?item1
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:MartinPoulter/queries/equity_research&oldid=2060603617"