Back to Global Data Atlas
GB-SCT Option 3 Hybrid Blueprint API & DB Probed Phase 1 Live Ingested
Schema v1.0.0 • Updated 2026-07-22

Scottish Parliament (Holyrood) Data Audit Blueprint

Declarative field mappings, API endpoints, rate limits, Hansard disambiguation rules, and continuous drift health probe status.

Location / Chamber Edinburgh, Holyrood (DEVOLVED_UNICAMERAL)
Open License Open Parliament Licence v3.0 / Open Government Licence v3.0
Target Cohort 2019-2024 BICD Cohort 1

Phase 1 Live Ingested Database Metrics (PostgreSQL Mirror)

LIVE INGESTED
101 2019–2024 Total Bills Ingested
89 Enacted Acts (Stage 3 Passed)
12 In Progress / Defeated / Pending
101 SHA-256 Provenance Audit Hashes

API Endpoints & Access Specifications

Endpoint NameTarget URLMethodRate LimitFormat
Bills Master APIhttps://data.parliament.scot/api/billsGET600 req/minJSON
Bill Stages APIhttps://data.parliament.scot/api/billstagesGET600 req/minJSON
Bill Stage Types Lookuphttps://data.parliament.scot/api/billstagetypesGET600 req/minJSON
Bill Types Lookuphttps://data.parliament.scot/api/billtypesGET600 req/minJSON
Members Master APIhttps://data.parliament.scot/api/membersGET600 req/minJSON

Dual-Layer Field Mappings & Provenance Matrix

Canonical FieldNative Key PathProvenance TierConfidenceNotes / Transformation
normalized.titleShortNameNATIVE_DIRECTHIGH
normalized.parliament_termSessionENRICHEDHIGHSession 5 (2016-2021) / Session 6 (2021-2026)
normalized.initiator_typeBillTypeIDENRICHEDHIGHMapped from billtypes lookup (1=Executive, 2=Member's, 3=Budget, etc.)
normalized.final_statusBillStagesENRICHEDHIGHDerived from latest StageType (e.g. Royal Assent -> ENACTED)

Hansard Resolution

Format: XML / HTML
Disambiguation: MSP ID / PersonID
Timestamp Granularity: SPEECH_LEVEL
Interruption Flags: Available

Procedural Rules

  • Unicameral 3-stage process: Stage 1 (Committee & Chamber Agreement), Stage 2 (Detailed Committee Amendment), Stage 3 (Final Passage).
  • UK Government Section 35 Order power under Scotland Act 1998 can prevent Royal Assent.

5-Bill Typology Empirical Audit Tests

SP Bill 13 4 Stages

Gender Recognition Reform (Scotland) Bill

Executive Bill (Subject to Section 35 Order)

Passed Stage 3 December 2022; Section 35 Order issued January 2023.