PREFIX xsd: PREFIX schema: PREFIX rdf: PREFIX rdfs: PREFIX iisgv: PREFIX gg: PREFIX geo: PREFIX hdng: PREFIX hdnggemeente: PREFIX hdngv: PREFIX hdngvar: PREFIX sdmx: PREFIX sdmx-code: SELECT * WHERE { # get all available variables and details of this variable, for all municipalities ?gemeente schema:variableMeasured ?variable . ?variable hdngv:category ?category . ?variable hdngv:specification ?specification . ?variable sdmx:sex ?sex . # give me only variables on "[enter string here]" FILTER(REGEX(?category, "Bevolking")) # or search in the specification variable #FILTER(REGEX(?specification, "katholiek", "i")) # # optional: and/or for this municipality (upper case!) FILTER(?gemeente = hdnggemeente:LEIDEN) # retrieve which year observations are available for these variables for the specified municipality ?variable schema:hasObservation ?observation . ?observation hdngv:year ?year . # optional: specify a certain year FILTER(?year = "1899"^^) # now give me the actual values of these variables for this municipality#year combination ?observation hdng:gemeente ?gemeente . ?observation ?variable ?value . }

A pivot table example

API

Variables