Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’20251216113730’
_mkb_version	varchar	MKB version field	’MKB-229’
_record_version	varchar	Internal record version	’20251216110018’
emis_code_id	bigint	EMIS code identifier	13239821040006117
fully_specified_name	varchar	Canonical concept name	’Headache NOS’
other_code	varchar	Alternate code	’999999’
other_code_system	varchar	System for alternate code	’https://fhir.hl7.org.uk/Id/egton-codes’
other_display	varchar	Alternate display text	’Other term’
readv2_code	varchar	Read v2 code	’G43..’
snomed_concept_id	bigint	SNOMED concept id	30277711000001222
snomed_description_id	bigint	SNOMED description id	80237711000001294
term	varchar	Human readable term	’Migraine’
_execution_date	varchar(14)	Extract execution date	’20260520042133’
organisation	varchar(4)	Organisation identifier	’EMIS’