Przejdź do zawartości

KHW:SPARQL examples

Dodaj linki
Z Arcarium Index

Przykłady

Wszystkie osoby w wiki

PREFIX wd:  <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt: <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?person ?label
WHERE {
  ?person wdt:P1 wd:Q2 .

  OPTIONAL {
    ?person rdfs:label ?label .
    FILTER(LANG(?label) = "mul")
  }
}
ORDER BY ?label

Wypróbuj!


Wszyscy politycy

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?person ?label
WHERE {
  ?person wdt:P1 wd:Q2 .
  ?person wdt:P20 wd:Q35911 .

  OPTIONAL {
    ?person rdfs:label ?label .
    FILTER(LANG(?label) = "mul")
  }
}
ORDER BY ?label

Wypróbuj!

Ciała zbiorowe które były aktywne w XIX wieku

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?institution ?label ?activityStart ?activityEnd
WHERE {
  ?institution wdt:P1 wd:Q13168 .

  OPTIONAL {
    ?institution wdt:P22 ?activityStart .
  }

  OPTIONAL {
    ?institution wdt:P23 ?activityEnd .
  }

  OPTIONAL {
    ?institution rdfs:label ?label .
    FILTER(LANG(?label) = "mul")
  }

  FILTER(
    (BOUND(?activityStart) || BOUND(?activityEnd)) &&
    (!BOUND(?activityStart) || YEAR(?activityStart) <= 1900) &&
    (!BOUND(?activityEnd)   || YEAR(?activityEnd) >= 1801)
  )
}
ORDER BY ?label

Wypróbuj!

Obiekty dLibry w których autorem jest kobieta

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT ?dlibraLink ?title ?creator ?creatorLabel
WHERE {
  ?dlibraObject dp:creator ?creator .

  ?creator wdt:P15 wd:Q6 .

  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  OPTIONAL {
    ?creator rdfs:label ?creatorLabel .
    FILTER(LANG(?creatorLabel) = "mul")
  }

  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?creatorLabel ?title

Wypróbuj!

Karty ze sztambucha autorstwa mężczyzn

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT ?dlibraLink ?title ?creator ?creatorLabel
WHERE {
  ?dlibraObject dp:creator ?creator .
  ?dlibraObject dp:documenttype "karta ze sztambucha" .

  ?creator wdt:P15 wd:Q5 .

  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  OPTIONAL {
    ?creator rdfs:label ?creatorLabel .
    FILTER(LANG(?creatorLabel) = "mul")
  }

  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?creatorLabel ?title

Wypróbuj!

Publikacje z miejscem powiązanym z Arcarium Index

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>

PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT ?dlibraLink ?title ?place ?placeLabel
WHERE {
  ?dlibraObject dp:location ?place .

  ?place wdt:P1 wd:Q10 .

  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  OPTIONAL {
    ?place rdfs:label ?placeLabel .
    FILTER(LANG(?placeLabel) = "mul")
  }

  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?place), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?placeLabel ?title

Wypróbuj!

Dokumenty autorstwa polityków napisane w Berlinie w XIX wieku

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?authorLabel
  ?authorLink
  ?date
WHERE {
  # Berlin
  ?dlibraObject dp:location wd:Q29180 .

  # Creator is a person
  ?dlibraObject dp:creator ?author .
  ?author wdt:P1 wd:Q2 .

  # Creator is a politician
  ?author wdt:P20 ?politicianType .

  VALUES ?politicianType {
    wd:Q35911
    wd:Q38276
  }

  # Author label
  OPTIONAL {
    ?author rdfs:label ?authorLabel .
    FILTER(LANG(?authorLabel) = "mul")
  }

  # Normal Wikibase page URL for author
  BIND(
    IRI(
      REPLACE(
        STR(?author),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?authorLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # XIX century
  ?dlibraObject dp:date ?date .

  FILTER(
    REGEX(STR(?date), "(18(0[1-9]|[1-9][0-9])|1900)")
  )

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?author), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?date ?title

Wypróbuj!

Dokumenty ikonograficzne wszystkich poetek

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?authorLabel
  ?authorLink
WHERE {
  # Iconographic document
  ?dlibraObject dp:documenttype "dokument ikonograficzny" .

  # Creator is a person
  ?dlibraObject dp:creator ?author .
  ?author wdt:P1 wd:Q2 .

  # Creator is a poetess
  ?author wdt:P20 wd:Q37031 .

  # Author label
  OPTIONAL {
    ?author rdfs:label ?authorLabel .
    FILTER(LANG(?authorLabel) = "mul")
  }

  # Normal Wikibase page URL for author
  BIND(
    IRI(
      REPLACE(
        STR(?author),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?authorLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?author), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?authorLabel ?title

Wypróbuj!

Dokumenty wszystkich kobiet pisane z Berlina w XVIII wieku

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?authorLabel
  ?authorLink
  ?date
WHERE {
  # Berlin
  ?dlibraObject dp:location wd:Q29180 .

  # Creator is a person
  ?dlibraObject dp:creator ?author .
  ?author wdt:P1 wd:Q2 .

  # Creator is a woman
  ?author wdt:P15 wd:Q6 .

  # Author label
  OPTIONAL {
    ?author rdfs:label ?authorLabel .
    FILTER(LANG(?authorLabel) = "mul")
  }

  # Normal Wikibase page URL for author
  BIND(
    IRI(
      REPLACE(
        STR(?author),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?authorLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # XVIII century
  ?dlibraObject dp:date ?date .

  FILTER(
    REGEX(STR(?date), "(17(0[1-9]|[1-9][0-9])|1800)")
  )

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?author), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?date ?authorLabel ?title

Wypróbuj!

Utwory wszystkich kobiet

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?authorLabel
  ?authorLink
WHERE {
  # Work
  ?dlibraObject dp:documenttype "utwór" .

  # Creator is a person
  ?dlibraObject dp:creator ?author .
  ?author wdt:P1 wd:Q2 .

  # Creator is a woman
  ?author wdt:P15 wd:Q6 .

  # Author label
  OPTIONAL {
    ?author rdfs:label ?authorLabel .
    FILTER(LANG(?authorLabel) = "mul")
  }

  # Normal Wikibase page URL for author
  BIND(
    IRI(
      REPLACE(
        STR(?author),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?authorLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?author), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?authorLabel ?title

Wypróbuj!

Listy w języku hiszpański nieodnalezione w edycji

PREFIX ds: <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp: <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?language
  ?edition
WHERE {
  # Letter
  ?dlibraObject dp:documenttype "list" .

  # Spanish language
  ?dlibraObject dp:language ?language .
  FILTER(LCASE(STR(?language)) = "hiszpański")

  # Edition not found
  ?dlibraObject dp:edition ?edition .
  FILTER(LCASE(STR(?edition)) = "nieodnalezione")

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?title

Wypróbuj!

Listy do kobiet pisane w XVIII wieku

PREFIX ds:   <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp:   <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX wd:   <https://arcarium.index.bj.uj.edu.pl/entity/>
PREFIX wdt:  <https://arcarium.index.bj.uj.edu.pl/prop/direct/>
PREFIX dc:   <http://purl.org/dc/elements/1.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?recipientLabel
  ?recipientLink
  ?date
WHERE {
  # Letter
  ?dlibraObject dp:documenttype "list" .

  # Recipient is a person
  ?dlibraObject dp:addressed ?recipient .
  ?recipient wdt:P1 wd:Q2 .

  # Recipient is a woman
  ?recipient wdt:P15 wd:Q6 .

  # Recipient label
  OPTIONAL {
    ?recipient rdfs:label ?recipientLabel .
    FILTER(LANG(?recipientLabel) = "mul")
  }

  # Normal Wikibase page URL for recipient
  BIND(
    IRI(
      REPLACE(
        STR(?recipient),
        "https://arcarium.index.bj.uj.edu.pl/entity/",
        "https://arcarium.index.bj.uj.edu.pl/wiki/Item:"
      )
    )
    AS ?recipientLink
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # XVIII century
  ?dlibraObject dp:date ?date .

  FILTER(
    REGEX(STR(?date), "(17(0[1-9]|[1-9][0-9])|1800)")
  )

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(STR(?recipient), STR(wd:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?date ?recipientLabel ?title

Wypróbuj!

Dokumenty po francusku z XVII wieku

PREFIX ds: <https://arcarium.manuscripta.bj.uj.edu.pl/subject/>
PREFIX dp: <https://arcarium.manuscripta.bj.uj.edu.pl/predicate/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT
  ?dlibraLink
  ?title
  ?date
WHERE {
  # French
  ?dlibraObject dp:language ?language .
  FILTER(LCASE(STR(?language)) = "francuski")

  # XVII century
  ?dlibraObject dp:date ?date .

  FILTER(
    REGEX(STR(?date), "(16(0[1-9]|[1-9][0-9])|1700)")
  )

  # Object title
  OPTIONAL {
    ?dlibraObject dp:title ?title .
  }

  # Actual dLibra URL
  ?dlibraObject dc:identifier ?dlibraLink .

  FILTER(
    STRSTARTS(STR(?dlibraObject), STR(ds:)) &&
    STRSTARTS(
      STR(?dlibraLink),
      "https://arcarium.manuscripta.bj.uj.edu.pl/dlibra/"
    )
  )
}
ORDER BY ?date ?title

Wypróbuj!

Źródło: „https://arcarium.index.bj.uj.edu.pl/index.php?title=KHW:SPARQL_examples&oldid=50065”