Schema

Raw

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10T09:00:00Z’
emis_organisation_guid	string	EMIS organisation GUID (alias id)	‘123e4567-e89b-12d3-a456-426614174000’
cdb	string	CDB value	’cdb-val’
ods_code	string	ODS code	’ABC123’
emis_parent_organisation_guid	string	Parent organisation GUID	’parent-123’
emis_ccg_organisation_guid	string	CCG organisation GUID	’ccg-123’
ccg_ods_code	string	CCG ODS code	’CCG123’
organisation_type_description	string	Organisation type description	’GP Practice’
open_date	date	Organisation open date	’2000-01-01’
close_date	date	Organisation close date	’2026-01-01’
emis_main_location_guid	string	Main location GUID	’loc-123’
_execution_date	date	View execution timestamp	’2026-04-10’
organisation	string	Organisation identifier	’CDB-0001’