Second Meeting of the Routine Data Section

Category: Routine data

Location: Botnar Research Centre, CSM, NDORMS, University of Oxford, Windmill Road, Headington, Oxford, OX3 7LD | Date: 21 January 2019

A group has been formed to address the issues encountered by NIHR statisticians working on complex, routine datasets. We aim to provide a networking group for statistical researchers involved in the analysis of either established databases or routine data that has not been pre-processed.

The event is free and that lunch and refreshments are provided

Please register for this event here. There are 45 places available and registrations will close on 12th January.


10.30-11.00 Registration and coffee

11.00 Introduction and welcome to the NIHR Statistics Group and the Routine Data Section (Routine Data Group Committee)

All the following talks are running with the format of 20 mins for a talk plus 10 mins for discussion.

11.10-11.40 GP consultations and code lists

John Edwards   Arthritis Research UK Primary Care Centre, Keele University  

Content: I aim to illustrate how an appointment with a GP turns into to coded information in the electronic health records.


  1. to map the range of processes involved in converting a consultation to a record, including the level of training they primary care clinicians are given, and the difficulties faced.
  2. give some real examples that illustrate how it works in practice, with different kinds of patients/conditions.


12.00-13.00 Primary care consultation databases

CPRD (Dan Dedman CPRD, MHRA)

Content: I will give a brief introduction on CPRD data, data access, and ISAC applications. I will talk some examples of common problems and issues in the ISAC applications. In addition, I will talk about challenges when requesting CPRD linkage data.

Chris Bates, Lead data Scientist ResearchOne

Content: I will give a brief introduction on ResearchOne and data available in ResearchOne. I will talk about data access process.

Objectives: From this, attendees will not only have an idea of primary care consultation databases for research, but also know process of obtaining data from two different data providers.

13.00-13.45 Lunch and networking

13.45-14.45 Experiences of coding/working with primary care consultation data

Antonella Delmestri CSM, NDORMS, University of Oxford

Content: I will show the advantages of automation in big clinical data management, curation and extraction by using a DataBase Management System (e.g. MySQL) and a programming language (e.g. Python).

Rosa Parisi University of Manchester

Content: I will demonstrate how a R package could manipulate and analyse electronic health record data ( During this session, you will find out how to use the package rEHR in order to extract ready-for analysis dataset, including creating a longitudinal cohort or perform matching. It could be centrally by a Data Manager, or with the use of existing programming package.

14.45-15.00 Coffee

15.00-15.30 Handling Missing data in the primary care consultation database

Irene Petersen University College London

Content: I will discuss the scale of missing data in the primary care consultation database, and discuss typical approaches to handle missing data. I will also introduce the two-fold approach for multiple imputation for longitudinal electronic health record data.

Objectives: From this, attendees will have ideas of handling missing data in the primary care consultation data.

15.30-16.00 Jessica Harris, University of Bristol

Content: I will present a CPRD/HES linked study and go through how I have used various codelists, to define exposures and outcomes.

16.00-16.30 breakout sessions

16.30 Close of meeting, followed by an optional social networking

Join the NIHR Statistics Group - Subscribe for the latest news, updates and event information.