Main Page: Difference between revisions

From Doelgericht Digitaal Transformeren

Main Page (view source)

Revision as of 08:28, 31 August 2023

2,983 bytes added ,  1 year ago
no edit summary
No edit summary
No edit summary
Line 109: Line 109:


Nood aan meer voorbeelden? Laat het weten op de overlegpagina.
Nood aan meer voorbeelden? Laat het weten op de overlegpagina.
=== Hoe ziet de data eruit? ===
==== Dansers en choreografen ====
Welke dansers en choreografen enzo werkten tussen 1980 en 2000 samen aan meer dan 10 verschillende werken?
PREFIX kp:<https://osloddt.wikibase.cloud/entity/>
PREFIX kpt:<https://osloddt.wikibase.cloud/prop/direct/>
PREFIX kpp:<https://osloddt.wikibase.cloud/prop/>
PREFIX kppq:<https://osloddt.wikibase.cloud/prop/qualifier/>
PREFIX kpps:<https://osloddt.wikibase.cloud/prop/statement/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT DISTINCT ?creditA ?creditALabel (COUNT(?werk) AS ?werkCount) ?creditB ?creditBLabel
WHERE
{
  ?werk kpt:P17 ?begindatum.
  FILTER (?begindatum >= "1980-01-01T00:00:0+00:00"^^xsd:dateTime && ?begindatum < "2000-01-01T00:00:00+00:00"^^xsd:dateTime)
  ?werk kpt:P8 ?discipline.
  FILTER(?discipline IN (kp:Q68584,kp:Q68551,kp:Q68559,kp:Q68558,kp:Q68571,kp:Q68586,kp:Q68597,kp:Q68613,kp:Q68626,kp:Q68630,kp:Q68635,kp:Q68641,kp:Q68652,kp:Q68687,kp:Q68713,kp:Q68716,kp:Q68726,kp:Q68756,kp:Q68763,kp:Q68779,kp:Q68786,kp:Q68790))
  ?activiteit kpt:P4 ?werk.
  ?activiteit kpp:P42 ?statementA.
  ?statementA kppq:P15 ?roleA.
  FILTER(?roleA IN (kp:Q69028,kp:Q69752,kp:Q69029,kp:Q69030,kp:Q68959,kp:Q69051,kp:Q69052,kp:Q69053,kp:Q69068,kp:Q69069,kp:Q69070,kp:Q69071,kp:Q69135,kp:Q69136,kp:Q69360,kp:Q68983,kp:Q68984,kp:Q69080,kp:Q69081,kp:Q69083,kp:Q69084,kp:Q69289,kp:Q69536,kp:Q69537,kp:Q69436,kp:Q69437,kp:Q69438,kp:Q69439,kp:Q69534,kp:Q69006,kp:Q69007,kp:Q69008,kp:Q69036,kp:Q69037,kp:Q69291,kp:Q69292,kp:Q69479,kp:Q69480,kp:Q69481,kp:Q69482,kp:Q69252))
  ?statementA kpps:P42 ?creditA.
  ?activiteit kpp:P42 ?statementB.
  ?statementB kppq:P15 ?roleB.
  FILTER(?roleB IN (kp:Q69028,kp:Q69752,kp:Q69029,kp:Q69030,kp:Q68959,kp:Q69051,kp:Q69052,kp:Q69053,kp:Q69068,kp:Q69069,kp:Q69070,kp:Q69071,kp:Q69135,kp:Q69136,kp:Q69360,kp:Q68983,kp:Q68984,kp:Q69080,kp:Q69081,kp:Q69083,kp:Q69084,kp:Q69289,kp:Q69536,kp:Q69537,kp:Q69436,kp:Q69437,kp:Q69438,kp:Q69439,kp:Q69534,kp:Q69006,kp:Q69007,kp:Q69008,kp:Q69036,kp:Q69037,kp:Q69291,kp:Q69292,kp:Q69479,kp:Q69480,kp:Q69481,kp:Q69482,kp:Q69252))
  ?statementB kpps:P42 ?creditB.
  FILTER(?creditA != ?creditB)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,en" . }
}
GROUP BY ?creditA ?creditALabel ?creditB ?creditBLabel
HAVING (?werkCount >= 10)
==== Releases en hun contributors ====
Een overzicht van jazz/folk/wereldmuziek albums in de databank, met de contributors:
PREFIX kp:<https://osloddt.wikibase.cloud/entity/>
PREFIX kpp:<https://osloddt.wikibase.cloud/prop/direct/>
SELECT DISTINCT ?release ?releaseLabel ?contributor ?contributorLabel
WHERE {
?release kpp:P13 kp:Q58532.
?release kpp:P8 kp:Q68897.
?track kpp:P43 ?release.
?track kpp:P4 ?work.
{ ?release kpp:P42 ?contributor. } UNION { { ?track kpp:P42 ?contributor. } UNION { ?work kpp:P42 ?contributor. } }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl,en" . }
}
ORDER BY ASC(?releaseLabel)
Retrieved from "https://osloddt.wikibase.cloud/wiki/Special:MobileDiff/7471126"