Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’20251216113730’
_mkb_version	varchar	Version of the MKB coding system	’MKB-229’
_record_version	varchar	Version of the record	’20251216110018’
emis_code_id	bigint	Unique identifier for the code	13239821040006117
fully_specified_name	varchar	Fully specified name of the concept	’Solution for injection’
other_code	varchar	Alternate code for the concept	’999999’
other_code_system	varchar	Code system for the alternate code	’https://fhir.hl7.org.uk/Id/egton-codes’
other_display	varchar	Display name for the alternate code	’High BP’
readv2_code	varchar	Read v2 code for the concept	’^ESCT00’
snomed_concept_id	bigint	SNOMED concept identifier	30277711000001222
snomed_description_id	bigint	SNOMED description identifier	80237711000001294
term	varchar	Term associated with the concept	’Solution for injection’
organisation	varchar	Organization identifier	’EMIS’
_execution_date	varchar	Date of execution	’20260520042133’