Department for Communities and Local Government Work packages before Parliament

5 May 2006 - 9 January 2018

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

There are 0 work packages.

RSS

Organisation accountable to Parliament identifier

https://id.parliament.uk/mxR6qrqu

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 ?LaidThing) as ?count) WHERE {
       { ?Organisations a :GovernmentOrganisation.}
       UNION {
      ?Organisations a :ArmsLengthBody.
                      }
        ?Organisations :name ?Name;
                       :layingBodyHasLaying ?Laying.
        ?Laying :layingHasLaidThing ?LaidThing;
                :businessItemHasProcedureStep ?Step;
                :layingDate ?LaidDate.
        filter (?Step in (id:cspzmb6w, id:isWn7s3K))
        ?LaidThing :name ?LaidThingName. 
        ?LaidThing :workPackagedThingHasWorkPackage ?workPackage.
                           ?workPackage :workPackageHasProcedure ?procedure.
                ?procedure :name ?procedureName.
               optional { ?workPackage :workPackageHasCalculationStyle ?calculationStyle. 
                  ?calculationStyle :name ?calculationStyleName. }
        filter (?Organisations in (id:mxR6qrqu))
   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  ?LaidThing ?LaidThingName ?workPackage ?combinedDate ?procedure ?procedureName ?calculationStyle ?calculationStyleName WHERE {
            { ?Organisations a :GovernmentOrganisation.}
            UNION {
           ?Organisations a :ArmsLengthBody.
                           }
             ?Organisations :name ?Name;
                            :layingBodyHasLaying ?Laying.
       ?Laying :layingHasLaidThing ?LaidThing.
                   filter (?Step in (id:cspzmb6w, id:isWn7s3K))
             ?LaidThing :name ?LaidThingName. 
             ?LaidThing :workPackagedThingHasWorkPackage ?workPackage.
                                ?workPackage :workPackageHasProcedure ?procedure.
                     ?procedure :name ?procedureName.
                    optional { ?workPackage :workPackageHasCalculationStyle ?calculationStyle. 
                       ?calculationStyle :name ?calculationStyleName. }
             filter (?Organisations in (id:mxR6qrqu))
       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))}
        MINUS {  ?workPackage   :workPackageHasBusinessItem ?bi2.
       ?bi2 :businessItemHasProcedureStep ?stepId2.
          ?stepId2 :procedureStepHasProcedureStepCollectionMembership/:procedureStepCollectionMembershipHasProcedureStepCollection id:TRohjSuI}
     BIND(COALESCE(?businessItemDate, ?businessItemDate2) AS ?combinedDate)
     } Order by desc(?combinedDate)
     limit 20 offset 0