Department of Trade and Industry Treaty work packages before Parliament

11 June 1983 - 28 June 2007

Work packages before Parliament All work packages Treaties Treaty work packages before Parliament All treaty work packages

Treaty work packages currently before Parliament led by this organisation.

There are 0 work packages.

RSS

Organisation accountable to Parliament identifier

https://id.parliament.uk/mWvDgQ5B

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 ?WorkPackage) 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:mWvDgQ5B))
         optional {?WorkPackage :workPackageHasBusinessItem ?businessItem .
                      ?businessItem :businessItemHasProcedureStep ?step;
                             :businessItemDate ?businessItemDate.
                      filter (?step in (id:isWn7s3K, id:cspzmb6w, id:ITNO9JWr, id:otscOTzB))}
                      ?WorkPackage :workPackageHasProcedure ?procedure.
                    ?procedure :name ?procedureName.
                         optional { ?WorkPackage :workPackageHasCalculationStyle ?calculationStyle. 
               ?calculationStyle :name ?calculationStyleName. }
        MINUS {  ?WorkPackage   :workPackageHasBusinessItem ?bi2.
      ?bi2 :businessItemHasProcedureStep ?stepId2.
        ?stepId2 :procedureStepHasProcedureStepCollectionMembership/:procedureStepCollectionMembershipHasProcedureStepCollection id:TRohjSuI}
          }

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 ?workPackage ?procedure ?procedureName ?treaty ?TreatyName ?treatyHasCountrySeriesMembership ?countrySeriesItemCitation ?treatyHasEuropeanUnionSeriesMembership ?europeanSeriesItemCitation ?treatyHasMiscellaneousSeriesMembership ?miscSeriesItemCitation ?combinedDate ?calculationStyle ?calculationStyleName  WHERE {
                 { ?Organisations a :GovernmentOrganisation.}
                 UNION {
                ?Organisations a :ArmsLengthBody.
                                }
                  ?Organisations :name ?Name;
                                 :leadGovernmentOrganisationHasTreaty ?treaty.
                  ?treaty :name ?TreatyName;
                          :workPackagedThingHasWorkPackage ?workPackage.
            ?workPackage :workPackageHasProcedure ?procedure.
            ?procedure :name ?procedureName.
                    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:mWvDgQ5B))
               optional {   ?workPackage :workPackageHasBusinessItem ?businessItem .
                 ?businessItem :businessItemHasProcedureStep ?step;
                        :businessItemDate ?businessItemDate.
          filter (?step in (id:isWn7s3K, id:cspzmb6w, id:ITNO9JWr, id:otscOTzB))}
          optional {    ?workPackage :workPackageHasBusinessItem ?businessItem2 .
                 ?businessItem2 :businessItemHasProcedureStep ?step2;
                                :businessItemDate ?businessItemDate2.
          filter (?step2 in (id:AmYrFxwO))}
                            ?workPackage :workPackageHasProcedure ?procedure.
                          ?procedure :name ?procedureName.
                               optional { ?workPackage :workPackageHasCalculationStyle ?calculationStyle. 
                     ?calculationStyle :name ?calculationStyleName. }
        MINUS {  ?workPackage   :workPackageHasBusinessItem ?bi2.
            ?bi2 :businessItemHasProcedureStep ?stepId2.
              ?stepId2 :procedureStepHasProcedureStepCollectionMembership/:procedureStepCollectionMembershipHasProcedureStepCollection id:TRohjSuI}
      BIND(COALESCE(?businessItemDate, ?businessItemDate2) AS ?combinedDate)
      } Order by desc(?combinedDate)                
      
                offset 0 limit 20