SPARQL examples - Revision history

Admin: fix query with properties

2023-04-03T13:34:44Z

fix query with properties

← Older revision		Revision as of 13:34, 3 April 2023
Line 64:		Line 64:
	schema:description ?propertyDescription;		schema:description ?propertyDescription;
	rdfs:label ?propertyLabel.		rdfs:label ?propertyLabel.
	~~FILTER((LANG(?propertyLabel)) = "en")~~
	~~FILTER((LANG(?propertyDescription)) = "en")~~
	OPTIONAL { ?propertyWikibase skos:altLabel ?propertyAlias. }		OPTIONAL { ?propertyWikibase skos:altLabel ?propertyAlias. }
	~~FILTER((LANG(?propertyAlias)) = "en")~~
	}		}
	}}		}}

Admin at 07:38, 3 April 2023

2023-04-03T07:38:16Z

← Older revision		Revision as of 07:38, 3 April 2023
Line 23:		Line 23:
	}}		}}

	=== Companies with ~~company~~ labels, ISINs, WKNs, BvD IDs, Crefo numbers, LEIs, ROR IDs, GND IDs and Wikidata IDs ===		=== Companies with labels, ISINs, WKNs, BvD IDs, Crefo numbers, LEIs, ROR IDs, GND IDs and Wikidata IDs ===

	{{SPARQL\|query=		{{SPARQL\|query=

Admin at 07:34, 3 April 2023

2023-04-03T07:34:42Z

← Older revision		Revision as of 07:34, 3 April 2023
Line 41:		Line 41:
	}		}
	ORDER BY ?companyLabel		ORDER BY ?companyLabel
	}		}}

	== Entities ==		== Entities ==

Admin: add query with a few company identifiers

2023-04-03T07:34:10Z

add query with a few company identifiers

@@ Line 22: / Line 22: @@
+}
 }}
 == Entities ==

Admin: rm extra headers

2023-04-03T07:20:20Z

rm extra headers

← Older revision		Revision as of 07:20, 3 April 2023
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;

Admin: add missing header

2023-04-03T07:15:44Z

add missing header

← Older revision		Revision as of 07:15, 3 April 2023
Line 13:		Line 13:
	}		}
	}}		}}

			=== Companies with official names and time ranges for them ===

	{{SPARQL\|query=		{{SPARQL\|query=

Admin: add query for companies with official names and time ranges

2023-04-03T07:15:08Z

add query for companies with official names and time ranges

← Older revision		Revision as of 07:15, 3 April 2023
Line 1:		Line 1:
	== Companies with labels, ISINs and WKNs ==		== Companies ==

			=== Companies with labels, ISINs and WKNs ===

	{{SPARQL\|query=		{{SPARQL\|query=
Line 11:		Line 13:
	}		}
	}}		}}

			{{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 {
			?company wdt:P325 wd:Q1.
			?company p:P346 [ ps:P346 ?official_name; pq:P79 ?start_time ; pq:P76 ?end_time ]

			}
			}}

			== Entities ==

	=== Entities with labels ===		=== Entities with labels ===
Line 21:		Line 34:
	}		}
	}}		}}

			== Properties ==

	=== Properties with labels, aliases, descriptions and datatypes ===		=== Properties with labels, aliases, descriptions and datatypes ===

Admin: add query with AKF data

2023-04-03T07:03:18Z

add query with AKF data

← Older revision		Revision as of 07:03, 3 April 2023
Line 1:		Line 1:
	== ~~Items~~ ==		== Companies with labels, ISINs and WKNs ==

			{{SPARQL\|query=
			#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")
			}
			}}

	=== Entities with labels ===		=== Entities with labels ===

	{{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 13:		Line 25:

	{{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;

Admin: Created page with "== Items == === Entities with labels === {{SPARQL|query= SELECT DISTINCT ?entity ?entityLabel WHERE { ?entity rdfs:label ?entityLabel. FILTER((LANG(?entityLabel)) = "en") } }} === Properties with labels, aliases, descriptions and datatypes === {{SPARQL|query= SELECT DISTINCT ?propertyWikibase ?propertyLabel ?propertyAlias ?propertyDescription ?propertyType WHERE { ?propertyWikibase wikibase:directClaim ?p; wikibase:propertyType ?propertyType; schema:d..."

2023-03-31T15:26:10Z

Created page with "== Items == === Entities with labels === {{SPARQL|query= SELECT DISTINCT ?entity ?entityLabel WHERE { ?entity rdfs:label ?entityLabel. FILTER((LANG(?entityLabel)) = "en") } }} === Properties with labels, aliases, descriptions and datatypes === {{SPARQL|query= SELECT DISTINCT ?propertyWikibase ?propertyLabel ?propertyAlias ?propertyDescription ?propertyType WHERE { ?propertyWikibase wikibase:directClaim ?p; wikibase:propertyType ?propertyType; schema:d..."

New page

== Items ==

=== Entities with labels ===

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

=== Properties with labels, aliases, descriptions and datatypes ===

{{SPARQL|query=
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")
}
}}