Factgrid2024-09-19

Queries

# Queries
# Wolfgang Fahl 2024-09-19
'IlluminatiNoImage':
  sparql: |
    # Query for items related to Illuminati without an associated image
    # 2024-09-19 Claude
    SELECT DISTINCT ?item ?itemLabel
    WHERE {
      ?item wdt:P611 wd:Q393235 .
      ?item rdfs:label ?itemLabel_de .
         SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
     FILTER NOT EXISTS { ?item wdt:P705 [] }.
    }
'AntonGraffPortraitsWithImages':
  sparql: |
    # Query for portraits by Anton Graff with optional image content and Wikimedia Commons links
    # 2024-09-19
    SELECT ?Portrait ?PortraitLabel ?depicting ?depictingLabel ?Wikimedia_Commons_Item_image ?careerLabel ?OhdabLabel WHERE {
      SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
      ?Portrait wdt:P121 wd:Q11225.
      ?Portrait wdt:P611 wd:Q393235.
      OPTIONAL { ?Portrait wdt:P705 ?depicting.
       OPTIONAL { ?depicting wdt:P165 ?career.
        OPTIONAL { ?career wdt:P1007 ?Ohdab . }
                }
               }
      OPTIONAL { ?Portrait wdt:P189 ?Wikimedia_Commons_Item_image. }
    }
    ORDER BY ?Portrait

Tool

https://wiki.bitplan.com/index.php?title=PyLoDStorage

pip install pylodstorage

endpoints.yaml

# SPARQL endpoints for sparqlquery tool
'factgrid':
  endpoint: https://database.factgrid.de/sparql/
  website: https://database.factgrid.de/query/
  database: factgrid
  method: POST
  lang: sparql
  prefixes: |
    PREFIX bd: <http://www.bigdata.com/rdf#>
    PREFIX cc: <http://creativecommons.org/ns#>
    PREFIX dct: <http://purl.org/dc/terms/>
    PREFIX geo: <http://www.opengis.net/ont/geosparql#>
    PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>
    PREFIX owl: <http://www.w3.org/2002/07/owl#>
    PREFIX p: <http://factgrid.de/prop/>
    PREFIX pq: <http://factgrid.de/prop/qualifier/>
    PREFIX pqn: <http://factgrid.de/prop/qualifier/value-normalized/>
    PREFIX pqv: <http://factgrid.de/prop/qualifier/value/>
    PREFIX pr: <http://factgrid.de/prop/reference/>
    PREFIX prn: <http://factgrid.de/prop/reference/value-normalized/>
    PREFIX prov: <http://www.w3.org/ns/prov#>
    PREFIX prv: <http://factgrid.de/prop/reference/value/>
    PREFIX ps: <http://factgrid.de/prop/statement/>
    PREFIX psn: <http://factgrid.de/prop/statement/value-normalized/>
    PREFIX psv: <http://factgrid.de/prop/statement/value/>
    PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
    PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
    PREFIX schema: <http://schema.org/>
    PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
    PREFIX wd: <http://factgrid.de/entity/>
    PREFIX wdata: <http://factgrid.de/wiki/Special:EntityData/>
    PREFIX wdno: <http://factgrid.de/prop/novalue/>
    PREFIX wdref: <http://factgrid.de/reference/>
    PREFIX wds: <http://factgrid.de/entity/statement/>
    PREFIX wdt: <http://factgrid.de/prop/direct/>
    PREFIX wdtn: <http://factgrid.de/prop/direct-normalized/>
    PREFIX wdv: <http://factgrid.de/value/>
    PREFIX wikibase: <http://wikiba.se/ontology#>
    PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>