Office of the Advocate General for Scotland Treaties

24 November 2008 -

Work packages before Parliament All work packages Treaties

There are 0 treaties.

Organisation accountable to Parliament identifier

https://id.parliament.uk/Pt4e6RQz

SPARQL queries used by this page

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#>
      PREFIX id: <https://id.parliament.uk/>
      SELECT distinct (count(distinct ?treaty) as ?count)  WHERE {
       { ?Organisations a :GovernmentOrganisation.}
       UNION {
      ?Organisations a :ArmsLengthBody.
                      }
        ?Organisations :name ?Name;
                       :leadGovernmentOrganisationHasTreaty ?treaty.
        ?treaty :name ?TreatyName;
                :workPackagedThingHasWorkPackage ?WorkPackage.
          OPTIONAL
        {
          ?treaty :treatyHasCountrySeriesMembership ?treatyHasCountrySeriesMembership .
          ?treatyHasCountrySeriesMembership :seriesItemCitation ?countrySeriesItemCitation .
        }
        OPTIONAL
        {
          ?treaty :treatyHasEuropeanUnionSeriesMembership ?treatyHasEuropeanUnionSeriesMembership .
          ?treatyHasEuropeanUnionSeriesMembership :seriesItemCitation ?europeanSeriesItemCitation .
        }
        OPTIONAL
        {
          ?treaty :treatyHasMiscellaneousSeriesMembership ?treatyHasMiscellaneousSeriesMembership .
          ?treatyHasMiscellaneousSeriesMembership :seriesItemCitation ?miscSeriesItemCitation .
        }
 
         filter (?Organisations in (id:Pt4e6RQz))
    
      }

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#>
      PREFIX id: <https://id.parliament.uk/>
      SELECT distinct ?treaty ?TreatyName ?treatyHasCountrySeriesMembership ?countrySeriesItemCitation ?treatyHasEuropeanUnionSeriesMembership ?europeanSeriesItemCitation ?treatyHasMiscellaneousSeriesMembership ?miscSeriesItemCitation  WHERE {
       { ?Organisations a :GovernmentOrganisation.}
       UNION {
      ?Organisations a :ArmsLengthBody.
                      }
        ?Organisations :name ?Name;
                       :leadGovernmentOrganisationHasTreaty ?treaty.
        ?treaty :name ?TreatyName;
                :workPackagedThingHasWorkPackage ?WorkPackage.
          OPTIONAL
        {
          ?treaty :treatyHasCountrySeriesMembership ?treatyHasCountrySeriesMembership .
          ?treatyHasCountrySeriesMembership :seriesItemCitation ?countrySeriesItemCitation .
        }
        OPTIONAL
        {
          ?treaty :treatyHasEuropeanUnionSeriesMembership ?treatyHasEuropeanUnionSeriesMembership .
          ?treatyHasEuropeanUnionSeriesMembership :seriesItemCitation ?europeanSeriesItemCitation .
        }
        OPTIONAL
        {
          ?treaty :treatyHasMiscellaneousSeriesMembership ?treatyHasMiscellaneousSeriesMembership .
          ?treatyHasMiscellaneousSeriesMembership :seriesItemCitation ?miscSeriesItemCitation .
        }
 
         filter (?Organisations in (id:Pt4e6RQz))
    
      } order by ?TreatyName

offset 0 limit 20