|
Metabase Meet & Greet Meet the WMSE team behind Metabase and other editors and friends of Metabase! Everyone is welcome, regardless if you are an active editor or simply interested in the platform. Ask questions, brainstorm and write queries, or simply chat about the future of Metabase. The first Metabase Meet & Greet will be in November - help us pick the time. |
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 29: | Line 29: | ||
} | } | ||
</SPARQL> | </SPARQL> | ||
=Documents= | |||
==People and how many documents they have authored== | |||
<SPARQL tryit="1"> | |||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | |||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | |||
SELECT ?author ?authorLabel (COUNT(?item) AS ?count) | |||
WHERE | |||
{ | |||
?item wbt:P5/wbt:P4* wb:Q21. | |||
?item wbt:P19 ?author. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } | |||
} | |||
GROUP BY ?author ?authorLabel | |||
ORDER BY DESC (?count) | |||
</SPARQL> | |||
=Projects= | =Projects= | ||
==Timeline of all projects== | ==Timeline of all projects== | ||
Revision as of 07:41, 25 April 2023
Overview queries
All types of documents and their Wikidata equivalents
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?item ?itemLabel ?wikidata_iri
WHERE
{
?item wbt:P4* wb:Q21.
OPTIONAL {?item wbt:P1 ?wikidataQ}
BIND(URI(concat("http://www.wikidata.org/entity/", ?wikidataQ)) AS ?wikidata_iri)
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
All index terms and their Wikidata equivalents
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?item ?itemLabelEN ?itemLabelSV ?wikidata_iri
WHERE
{
?item wbt:P5 wb:Q12 .
OPTIONAL {?item wbt:P1 ?wikidataQ}
OPTIONAL {?item rdfs:label ?itemLabelEN filter (lang(?itemLabelEN) = "en")}.
OPTIONAL {?item rdfs:label ?itemLabelSV filter (lang(?itemLabelSV) = "sv")}.
BIND(URI(concat("http://www.wikidata.org/entity/", ?wikidataQ)) AS ?wikidata_iri)
}
Documents
People and how many documents they have authored
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?author ?authorLabel (COUNT(?item) AS ?count)
WHERE
{
?item wbt:P5/wbt:P4* wb:Q21.
?item wbt:P19 ?author.
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
GROUP BY ?author ?authorLabel
ORDER BY DESC (?count)
Projects
Timeline of all projects
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
#defaultView:Timeline
SELECT ?item ?itemLabel ?start ?end
WHERE
{
?item wbt:P5 wb:Q2 .
?item wbt:P6 ?start.
?item wbt:P7 ?end.
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
Federated queries
Documents authored by employees of Wikimedia Sverige (via Wikidata)
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?document ?documentLabel ?person ?personLabel
WHERE
{
?document wbt:P19 ?person.
?person wbt:P1 ?wikidataQ.
BIND(URI(concat("http://www.wikidata.org/entity/", ?wikidataQ)) AS ?wikidata_iri)
SERVICE <https://query.wikidata.org/sparql> {
?wikidata_iri wdt:P108 wd:Q15279144.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}
Organizations and their social media and official website (from Wikidata)
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?item ?itemLabel ?wikidata_iri ?url ?twitter ?instagram
WHERE
{
?item wbt:P5 wb:Q13 .
?item wbt:P1 ?wikidataQ.
BIND(URI(concat("http://www.wikidata.org/entity/", ?wikidataQ)) AS ?wikidata_iri)
SERVICE <https://query.wikidata.org/sparql> {
OPTIONAL {?wikidata_iri wdt:P856 ?url.}
OPTIONAL {?wikidata_iri wdt:P2002 ?twitter.}
OPTIONAL {?wikidata_iri wdt:P2003 ?instagram.}
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
}