Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10 12:00:00’
_mkb_version	varchar	Version of the MKB coding system	’MKB-229’
_record_version	varchar	Version of the record	’1’
emis_code_id	varchar	Unique identifier for the code	’code-12345’
fully_specified_name	varchar	Fully specified name of the concept	’Hypertension’
other_code	varchar	Alternate code for the concept	’alt-67890’
other_code_system	varchar	Code system for the alternate code	’ICD-10’
other_display	varchar	Display name for the alternate code	’High BP’
readv2_code	varchar	Read v2 code for the concept	’R2-54321’
snomed_concept_id	varchar	SNOMED concept identifier	’SN-98765’
snomed_description_id	varchar	SNOMED description identifier	’SD-11223’
term	varchar	Term associated with the concept	’Blood Pressure’
organisation	varchar	Organization identifier	’EMIS’
_execution_date	date	Date of execution	’2026-04-10’