SPARQL examples: Difference between revisions

(add missing header)
(rm extra headers)
Line 4: Line 4:


{{SPARQL|query=
{{SPARQL|query=
#Companies with labels, ISINs and WKNs
SELECT DISTINCT ?company ?companyLabel ?ISIN ?WKN WHERE {
SELECT DISTINCT ?company ?companyLabel ?ISIN ?WKN WHERE {
   ?company rdfs:label ?companyLabel;
   ?company rdfs:label ?companyLabel;
Line 17: Line 16:


{{SPARQL|query=
{{SPARQL|query=
#Companies with official names and time ranges for them
SELECT DISTINCT ?company ?official_name (year(?start_time) as ?start_year) (year(?end_time) as ?end_year) WHERE {
SELECT DISTINCT ?company ?official_name (year(?start_time) as ?start_year) (year(?end_time) as ?end_year) WHERE {
   ?company wdt:P325 wd:Q1.
   ?company wdt:P325 wd:Q1.
Line 30: Line 28:


{{SPARQL|query=
{{SPARQL|query=
# Entities with labels
SELECT DISTINCT ?entity ?entityLabel WHERE {
SELECT DISTINCT ?entity ?entityLabel WHERE {
   ?entity rdfs:label ?entityLabel.
   ?entity rdfs:label ?entityLabel.
Line 42: Line 39:


{{SPARQL|query=
{{SPARQL|query=
# Properties with labels, aliases, descriptions and datatypes
SELECT DISTINCT ?propertyWikibase ?propertyLabel ?propertyAlias ?propertyDescription ?propertyType WHERE {
SELECT DISTINCT ?propertyWikibase ?propertyLabel ?propertyAlias ?propertyDescription ?propertyType WHERE {
   ?propertyWikibase wikibase:directClaim ?p;
   ?propertyWikibase wikibase:directClaim ?p;

Revision as of 07:20, 3 April 2023

Companies

Companies with labels, ISINs and WKNs

SELECT DISTINCT ?company ?companyLabel ?ISIN ?WKN WHERE {
  ?company rdfs:label ?companyLabel;
    wdt:P325 wd:Q1.
  OPTIONAL { ?company wdt:P127 ?ISIN. }
  OPTIONAL { ?company wdt:P4 ?WKN. }
  FILTER((LANG(?companyLabel)) = "de")
}

Companies with official names and time ranges for them

SELECT DISTINCT ?company ?official_name (year(?start_time) as ?start_year) (year(?end_time) as ?end_year) WHERE {
  ?company wdt:P325 wd:Q1.
  ?company p:P346 [ ps:P346 ?official_name; pq:P79 ?start_time ; pq:P76 ?end_time ]

}

Entities

Entities with labels

SELECT DISTINCT ?entity ?entityLabel WHERE {
  ?entity rdfs:label ?entityLabel.
  FILTER((LANG(?entityLabel)) = "en")
}

Properties

Properties with labels, aliases, descriptions and datatypes

SELECT DISTINCT ?propertyWikibase ?propertyLabel ?propertyAlias ?propertyDescription ?propertyType WHERE {
  ?propertyWikibase wikibase:directClaim ?p;
    wikibase:propertyType ?propertyType;
    schema:description ?propertyDescription;
    rdfs:label ?propertyLabel.
  FILTER((LANG(?propertyLabel)) = "en")
  FILTER((LANG(?propertyDescription)) = "en")
  OPTIONAL { ?propertyWikibase skos:altLabel ?propertyAlias. }
  FILTER((LANG(?propertyAlias)) = "en")
}