query-d23d87eb7225a2e919692dd12c3669d0

rq turtle/ttl


Daten-Download in 25.000er Schritten (mit offset)

----------------------------------------------------------

SELECT DISTINCT ?item ?label_en ?label_de ?desc_en ?desc_de ?dewiki (SAMPLE(?dob) AS ?date_of_birth) (SAMPLE(?pob) AS ?place_of_birth) (SAMPLE(?dod) AS ?date_of_death) (SAMPLE(?pod) AS ?place_of_death) (SAMPLE(?img) AS ?image) (SAMPLE(?coc) AS ?citizenship) (SAMPLE(?occ) AS ?occupation) WHERE { SERVICE bd:slice { ?item wdt:P31 wd:Q5 . bd:serviceParam bd:slice.offset 0 . bd:serviceParam bd:slice.limit 25000 . }

OPTIONAL { ?item rdfs:label ?label_en . FILTER(LANG(?label_en) = 'en') . } OPTIONAL { ?item rdfs:label ?label_de . FILTER(LANG(?label_de) = 'de') . } OPTIONAL { ?item schema:description ?desc_en . FILTER(LANG(?desc_en) = 'en') . } OPTIONAL { ?item schema:description ?desc_de . FILTER(LANG(?desc_de) = 'de') . } OPTIONAL { ?dewiki schema:about ?item; schema:isPartOf https://de.wikipedia.org/ } OPTIONAL { ?item wdt:P569 ?dob } OPTIONAL { ?item wdt:P570 ?dod } OPTIONAL { ?item wdt:P19 ?pob } OPTIONAL { ?item wdt:P20 ?pod }

OPTIONAL { ?item wdt:P27 ?coc } OPTIONAL { ?item wdt:P106 ?occ } OPTIONAL { ?item wdt:P18 ?img } } GROUP BY ?item ?label_en ?label_de ?desc_en ?desc_de ?dewiki

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#----------------------------------------------------------
# Daten-Download in 25.000er Schritten (mit offset)
#----------------------------------------------------------

SELECT DISTINCT
  ?item
  ?label_en
  ?label_de
  ?desc_en
  ?desc_de
  ?dewiki
  (SAMPLE(?dob) AS ?date_of_birth)
  (SAMPLE(?pob) AS ?place_of_birth)
  (SAMPLE(?dod) AS ?date_of_death)
  (SAMPLE(?pod) AS ?place_of_death)
  (SAMPLE(?img) AS ?image)
  (SAMPLE(?coc) AS ?citizenship)
  (SAMPLE(?occ) AS ?occupation)
WHERE {
  SERVICE bd:slice {
    ?item wdt:P31 wd:Q5 .
    bd:serviceParam bd:slice.offset 0 .
    bd:serviceParam bd:slice.limit 25000 .
  }                 

  OPTIONAL {
    ?item rdfs:label ?label_en .
    FILTER(LANG(?label_en) = 'en') .
  }
  OPTIONAL {
    ?item rdfs:label ?label_de .
    FILTER(LANG(?label_de) = 'de') .
  }
  OPTIONAL {
    ?item schema:description ?desc_en .
    FILTER(LANG(?desc_en) = 'en') .
  }
  OPTIONAL {
    ?item schema:description ?desc_de .
    FILTER(LANG(?desc_de) = 'de') .
  }
  OPTIONAL {
    ?dewiki schema:about ?item; schema:isPartOf <https://de.wikipedia.org/>
  }
  OPTIONAL { ?item wdt:P569 ?dob }
  OPTIONAL { ?item wdt:P570 ?dod }
  OPTIONAL { ?item wdt:P19 ?pob }
  OPTIONAL { ?item wdt:P20 ?pod }

  OPTIONAL { ?item wdt:P27 ?coc }
  OPTIONAL { ?item wdt:P106 ?occ }
  OPTIONAL { ?item wdt:P18 ?img }
} GROUP BY ?item ?label_en ?label_de ?desc_en ?desc_de ?dewiki

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v19("?citizenship") v11("?coc"):::projected v14("?date_of_birth") v16("?date_of_death") v1("?desc_de"):::projected v2("?desc_en"):::projected v6("?dewiki"):::projected v7("?dob"):::projected v8("?dod"):::projected v18("?image") v13("?img"):::projected v5("?item"):::projected v3("?label_de"):::projected v4("?label_en"):::projected v12("?occ"):::projected v20("?occupation") v15("?place_of_birth") v17("?place_of_death") v9("?pob"):::projected v10("?pod"):::projected c15([https://de.wikipedia.org/]):::iri c8(["0^^xsd:integer"]):::literal c6(["bd:serviceParam"]):::iri c10(["25000^^xsd:integer"]):::literal c5(["wd:Q5"]):::iri subgraph s1["http://www.bigdata.com/rdf#slice"] style s1 stroke-width:4px; v5 --"wdt:P31"--> c5 c6 --"bd:slice.offset"--> c8 c6 --"bd:slice.limit"--> c10 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."rdfs:label".-> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."rdfs:label".-> v3 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:description".-> v2 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:description".-> v1 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v6 -."schema:about".-> v5 v6 --"schema:isPartOf"--> c15 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P569".-> v7 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P570".-> v8 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P19".-> v9 end subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P20".-> v10 end subgraph optional9["(optional)"] style optional9 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P27".-> v11 end subgraph optional10["(optional)"] style optional10 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P106".-> v12 end subgraph optional11["(optional)"] style optional11 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P18".-> v13 end bind7[/"sample(?dob)"/] v7 --o bind7 bind7 --as--o v14 bind8[/"sample(?pob)"/] v9 --o bind8 bind8 --as--o v15 bind9[/"sample(?dod)"/] v8 --o bind9 bind9 --as--o v16 bind10[/"sample(?pod)"/] v10 --o bind10 bind10 --as--o v17 bind11[/"sample(?img)"/] v13 --o bind11 bind11 --as--o v18 bind12[/"sample(?coc)"/] v11 --o bind12 bind12 --as--o v19 bind13[/"sample(?occ)"/] v12 --o bind13 bind13 --as--o v20