205,551
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
→Line Charts
Superraptor (talk | contribs) |
Superraptor (talk | contribs) |
||
| Line 220: | Line 220: | ||
== Visualization Queries == | == Visualization Queries == | ||
=== Line Charts === | === Line Charts === | ||
==== Equaldex's Equality Index Over Time ==== | |||
This query returns a line chart showcasing how the Equaldex's Equality Index (P864) has changed over the last five years. It uses the service wikibase:label to return the labels in your default language or in English. | |||
<sparql tryit="1">PREFIX wd: <https://lgbtdb.wikibase.cloud/entity/> | |||
PREFIX wdt: <https://lgbtdb.wikibase.cloud/prop/direct/> | |||
PREFIX p: <https://lgbtdb.wikibase.cloud/prop/> | |||
PREFIX pq: <https://lgbtdb.wikibase.cloud/prop/qualifier/> | |||
PREFIX ps: <https://lgbtdb.wikibase.cloud/prop/statement/> | |||
#defaultView:LineChart | |||
SELECT ?EqualityIndex ?PointInTime ?RegionLabel | |||
WHERE | |||
{ | |||
?RegionLabel p:P861 ?EqualityIndexProp . | |||
?EqualityIndexProp pq:P19 ?PointInTime ; | |||
ps:P861 ?EqualityIndex . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
ORDER BY ?RegionLabel ?PointInTime | |||
</sparql> | |||
==== GAI Values Over Time ==== | ==== GAI Values Over Time ==== | ||
This query returns a line chart showcasing how the Williams Institute's Global Acceptance Index (GAI; P870) has changed in all regions over the past two decades. It uses the service wikibase:label to return the labels in your default language or in English. | This query returns a line chart showcasing how the Williams Institute's Global Acceptance Index (GAI; P870) has changed in all regions over the past two decades. It uses the service wikibase:label to return the labels in your default language or in English. | ||