Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10 12:00:00’
emis_organisation_guid	varchar	Unique identifier for the organisation	’org-12345’
cdb	varchar	CDB identifier	’cdb-99999’
ods_code	varchar	ODS code for the organisation	’A12345’
emis_parent_organisation_guid	varchar	Parent organisation GUID	’org-00001’
emis_ccg_organisation_guid	varchar	CCG organisation GUID	’org-ccg-001’
ccg_ods_code	varchar	ODS code of the CCG	’Z123’
organisation_type_description	varchar	Human-readable organisation type	’GP Practice’
open_date	date	Date the organisation opened	’2000-04-01’
close_date	date	Date the organisation closed	’2026-12-31’
emis_main_location_guid	varchar	Main location GUID for the organisation	’loc-55555’
_execution_date	varchar	Extract execution date	’2026-04-10’
organisation	varchar	Organisation identifier	’CDB-0001’