CRaG Treaty pre-laying scrutiny Business step

There are 38 steps.

Step	Actualisation count
Government objectives in trade negotiations deposited in the House of Commons library (House of Commons)	0
Government objectives in trade negotiations deposited in the House of Lords library (House of Lords)	0
Government response to the International Agreements Committee (IAC) scrutiny report of government negotiation objectives (House of Lords)	0
Government response to the International Trade Committee (ITC) scrutiny report of government objectives (House of Commons)	0
Informational copy of a free trade agreement laid before the House of Commons (House of Commons)	0
Informational copy of a free trade agreement laid before the House of Lords (House of Lords)	0
Informational copy of a free trade agreement withdrawn from the House of Commons (House of Commons)	0
Informational copy of a free trade agreement withdrawn from the House of Lords (House of Lords)	0
International Agreements Committee (IAC) scrutiny report of government negotiation objectives (House of Lords)	0
International Trade Committee (ITC) scrutiny report of government negotiation objectives (House of Commons)	0
Laid before the House of Commons (House of Commons)	0
Laid before the House of Lords (House of Lords)	0
Ministerial statement announcing a treaty has been signed (House of Commons)	0
Ministerial statement announcing a treaty has been signed (House of Lords)	0
Ministerial statement announcing an agreement in principle for a treaty (House of Commons)	0
Ministerial statement announcing an agreement in principle for a treaty (House of Lords)	0
Ministerial statement announcing the government's intention to accede to a treaty (House of Commons)	0
Ministerial statement announcing the government's intention to accede to a treaty (House of Lords)	0
Ministerial statement announcing the laying of a report pursuant to Section 42 of the Agriculture Act 2020 on a free trade agreement (House of Commons)	0
Ministerial statement announcing the laying of a report pursuant to Section 42 of the Agriculture Act 2020 on a free trade agreement (House of Lords)	0
Ministerial statement calling for input on a treaty (House of Commons)	0
Ministerial statement calling for input on a treaty (House of Lords)	0
Ministerial statement on the progress of negotiations for a treaty (House of Commons)	0
Ministerial statement on the progress of negotiations for a treaty (House of Lords)	0
Oral question about the negotiation progress of a treaty (House of Lords)	0
Publication of a report pursuant to Section 42 of the Agriculture Act 2020 on a free trade agreement laid before the House of Commons (House of Commons)	0
Publication of a report pursuant to Section 42 of the Agriculture Act 2020 on a free trade agreement laid before the House of Lords (House of Lords)	0
Publication of a report pursuant to Section 42 of the Agriculture Act 2020 on a free trade agreement withdrawn from the House of Commons	0
Publication of a report pursuant to Section 42 of the Agriculture Act 2020 on a free trade agreement withdrawn from the House of Lords (House of Lords)	0
Trade and Agriculture Commission advice to the Secretary of State for Business and Trade laid before the House of Commons (House of Commons)	0
Trade and Agriculture Commission advice to the Secretary of State for Business and Trade laid before the House of Lords (House of Lords)	0
Trade and Agriculture Commission advice to the Secretary of State for Business and Trade withdrawn from the House of Commons (House of Commons)	0
Trade and Agriculture Commission advice to the Secretary of State for Business and Trade withdrawn from the House of Lords (House of Lords)	0
Trade and Agriculture Commission advice to the Secretary of State for International Trade laid before the House of Commons (House of Commons)	0
Trade and Agriculture Commission advice to the Secretary of State for International Trade laid before the House of Lords (House of Lords)	0
Trade and Agriculture Commission advice to the Secretary of State for International Trade withdrawn from the House of Commons (House of Commons)	0
Trade and Agriculture Commission advice to the Secretary of State for International Trade withdrawn from the House of Lords (House of Lords)	0
Treaty signed	0

Procedure identifier

https://id.parliament.uk/R8oDwdeY

SPARQL queries used by this page

A list of steps of a type within a procedure

# We declare the Parliament and ID namespaces.
PREFIX : <https://id.parliament.uk/schema/>
PREFIX id: <https://id.parliament.uk/>

# We select the properties we want to appear in results. If all properties are required, an asterisk can be used between SELECT and WHERE instead of listing properties.
SELECT DISTINCT ?procedure ?procedureName ?stepType ?stepTypeLabel ?step ?stepName ?legislature ?legislatureName ?commonsId ?lordsId (COALESCE(?rawBiCount, 0) AS ?biCount) WHERE {

# We set the value of the procedure property.   
VALUES ?procedure { id:R8oDwdeY }

# We specify that the procedure property is a procedure and look for its name.   
?procedure a :Procedure;
:name ?procedureName.

# We look for all procedure routes and the steps in those routes, including whether they are a From step or a To step. The pipe in line 17 is a SPARQL OR.  
?procedure :procedureHasProcedureRoute ?route.
?route :procedureRouteIsFromProcedureStep|:procedureRouteIsToProcedureStep ?step.

# We specify the procedure step must have a name, a step type and that the step type also has a name.   
?step :name ?stepName.
?step :procedureStepHasProcedureStepType ?stepType.
?stepType :name ?stepTypeLabel.

# We limit steps to being only of the type 'Business step'.
FILTER (?stepType in (id:Jwc6nqJi))

# We check to see if the step belongs to a legislature. A legislature will be Scottish Parliament, Senedd Cymru or the Northern Ireland Assembly.   
OPTIONAL {?step :procedureStepInLegislature ?legislature .
?legislature :name ?legislatureName .}

# We check to see if the step belongs to the House of Commons.     
OPTIONAL {?step :procedureStepHasHouse ?commonsId .
FILTER (?commonsId = id:1AFu55Hs)}

# We check to see if the step belongs to the House of Lords.   
OPTIONAL {?step :procedureStepHasHouse ?lordsId .
FILTER (?lordsId = id:WkUWUBMx)}

# We specify an optional subquery which calculates the number of distinct business items that actualise a steps from the procedure. We make it optional because not every step will be actualised in a business item.   
OPTIONAL {
SELECT ?step (COUNT(DISTINCT ?bi) AS ?rawBiCount)
WHERE {
# We find business items actualising the step. 
?step :procedureStepHasBusinessItem ?bi .

# We find the work package each business item belongs to.
?bi :businessItemHasWorkPackage ?wp.

# We specify that the work packages must have the procedure. 
?wp :workPackageHasProcedure id:R8oDwdeY.}

# We group the results by step.    
GROUP BY ?step}
}

# We order the results by step name. 
ORDER BY ?stepName