Skip to main content

Table 1 Discover data elements by level of aggregation

From: How an electronic health record became a real-world research resource: comparison between London’s Whole Systems Integrated Care database and the Clinical Practice Research Datalink

Data element

Event level

Patient level

Organisation level

Data coding system

Demographics

 

Y

 

n/a

GP or other primary care consultation

Y

  

Read codes

Clinical tests ordered in primary care

Y

  

Read codes

Referrals to secondary care

Y

  

Read codes

Practice staffing

  

Y

n/a

Social care contacts

Y

  

Unique to this data set

Community mental health

Y

  

Unique to this data set

Emergency department visits

Y

  

Unique to England

Hospital stays

Y

  

ICD10 for diagnoses; UK’s OPCS for procedures

Hospital outpatient appointments

Y

  

ICD10 for diagnoses; UK’s OPCS for procedures

Death registration

 

Y

 

ICD10 for causes

Geographical location (postcode)

 

Y

Y

UK postcode