SPARQL examples: Difference between revisions
(add missing header) |
(rm extra headers) |
||
Line 4: | Line 4: | ||
{{SPARQL|query= | {{SPARQL|query= | ||
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= | ||
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= | ||
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= | ||
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")
}