Oral evidence session by the lead committee (Scottish Parliament) Routes

SPARQL queries used by this page

PREFIX id: <https://id.parliament.uk/> PREFIX : <https://id.parliament.uk/schema/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?Step ?stepName ?description ?scopeNote ?linkNote ?dateNote ?publicationName ?publicationUrl ?stepType ?stepTypeLabel ?CommonsId ?LordsId ?legislature ?legislatureName WHERE { ?Step a :ProcedureStep; :name ?stepName; :procedureStepHasProcedureStepType ?stepType. ?stepType :name ?stepTypeLabel. optional { ?Step :procedureStepDescription ?description} optional {?Step :procedureStepHasProcedureStepPublication ?publication. ?publication :procedureStepPublicationName ?publicationName; :procedureStepPublicationUrl ?publicationUrl.} optional {?Step :procedureStepScopeNote ?scopeNote} optional {?Step :procedureStepLinkNote ?linkNote} optional {?Step :procedureStepDateNote ?dateNote} optional {?Step :procedureStepInLegislature ?legislature. ?legislature :name ?legislatureName.} optional {?Step :procedureStepHasHouse ?CommonsId. filter (?CommonsId IN (id:1AFu55Hs))} optional {?Step :procedureStepHasHouse ?LordsId. filter (?LordsId IN (id:WkUWUBMx))} filter (?Step IN (id:L5xPSZVi))} PREFIX id: <https://id.parliament.uk/> PREFIX : <https://id.parliament.uk/schema/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?Route ?startDate ?endDate ?FromStep ?FromStepName ?FromStepType ?FromStepTypeName ?FromStepCommonsId ?FromStepLordsId ?FromSteplegislature ?FromSteplegislatureName ?ToStep ?ToStepName ?ToStepType ?ToStepTypeName ?ToStepCommonsId ?ToStepLordsId ?ToSteplegislature ?ToSteplegislatureName WHERE { ?Step a :ProcedureStep; :name ?stepName. ?Step :procedureStepIsFromProcedureRoute | :procedureStepIsToProcedureRoute ?Route. optional {?Route:procedureRouteStartDate ?startDate} optional {?Route :procedureRouteEndDate ?endDate} ?Route :procedureRouteIsFromProcedureStep ?FromStep. ?Route :procedureRouteIsToProcedureStep ?ToStep. ?FromStep :name ?FromStepName; :procedureStepHasProcedureStepType ?FromStepType. ?FromStepType :name ?FromStepTypeName. ?ToStep :name ?ToStepName; :procedureStepHasProcedureStepType ?ToStepType. ?ToStepType :name ?ToStepTypeName. optional {?FromStep :procedureStepHasHouse ?FromStepCommonsId. filter (?FromStepCommonsId IN (id:1AFu55Hs))} optional {?FromStep :procedureStepHasHouse ?FromStepLordsId. filter (?FromStepLordsId IN (id:WkUWUBMx))} optional {?FromStep :procedureStepInLegislature ?FromSteplegislature. ?FromSteplegislature :name ?FromSteplegislatureName.} optional {?ToStep :procedureStepHasHouse ?ToStepCommonsId. filter (?ToStepCommonsId IN (id:1AFu55Hs))} optional {?ToStep :procedureStepHasHouse ?ToStepLordsId. filter (?ToStepLordsId IN (id:WkUWUBMx))} optional {?ToStep :procedureStepInLegislature ?ToSteplegislature. ?ToSteplegislature :name ?ToSteplegislatureName.} filter (?Step IN (id:L5xPSZVi)) } Order by ?FromStepName