Subsetting CEUR-WS from Wikidata

Applied Migration Queries

Migrating all locations

SELECT DISTINCT  (?locations as ?item) ?label WHERE {
  ?proceedings wdt:P179 wd:Q27230297.
  ?proceedings wdt:P4745 ?event.
  ?event wdt:P276|wdt:P17 ?locations.
  OPTIONAL{?locations rdfs:label ?label. FILTER(lang(?label)="en")}
          
}

Migrating all Events

SELECT (?event as ?item) ?label WHERE {
  ?proceedings wdt:P179 wd:Q27230297.
  ?proceedings wdt:P4745 ?event.
  OPTIONAL{?event rdfs:label ?label. FILTER(lang(?label)="en")}
          
}

Migrating all related Scholars

# Q0.5 List all scholars (authors and editors) of CEUR-Workshop proceedings
SELECT DISTINCT 
  (?scholar as ?item) 
  ?label
  #(GROUP_CONCAT(?_givenNameLabel) as ?givenName) 
  #(GROUP_CONCAT(?_familyNameLabel) as ?familyName)
WHERE{
  # Proceeding
  ?proceeding wdt:P31 wd:Q1143604.
  # CEUR-WS
  ?proceeding wdt:P179 wd:Q27230297.
  {
    # authors
    # published in 
    ?paper wdt:P1433 ?proceeding.
    # author
    ?paper wdt:P50 ?scholar.
  }UNION{
    # editors
    ?proceeding wdt:P98 ?scholar. 
  }
  
  ?scholar rdfs:label ?label. 
  FILTER(LANG(?label)="en").
  #OPTIONAL{
  #  ?scholar wdt:P735 ?_givenName.
  #  ?_givenName rdfs:label ?_givenNameLabel.
  #   FILTER(LANG(?_givenNameLabel)="en").
  #} 
  
  #OPTIONAL{
  #  ?scholar wdt:P734 ?_familyName.
  #  ?_familyName rdfs:label ?_familyNameLabel.
  #  FILTER(LANG(?_familyNameLabel)="en").
  #} 
}
GROUP BY ?scholar ?label

Migrating all Proceedings

SELECT (?proceedings as ?item) ?proceedingsLabel 
WHERE {
  ?proceedings wdt:P179 wd:Q27230297; rdfs:label ?proceedingsLabel. 
  FILTER(lang(?proceedingsLabel)="en")
}