UK Health Facts and Dimensions Sample

ONS, NHS Digital, Ordnance Survey, NHS England, and many more data sources. Their data comes in all kinds of shapes and sizes with varying degrees of quality.

The work required to extract, transform and load these datasets into a Snowflake is enormous. We have done all of it and it is ready to query right now.

Over 5000 tables of all statistics and reference data used in the UK health sector.

Small sample of schemas (see website for full list):

A&E
PHE Fingertips stats
Cancer
ODS codes
SNOMED codes

Small sample of fields:

UPRN
ODS_Code
GP_Practice
Effective_Snapshot_Date
Measure_Name
Measure_Description
Measure_Value

搜集汇总

背景与挑战

背景概述

该数据集整合了来自英国ONS、NHS Digital等多个来源的卫生数据，经过提取、转换和加载处理，已存储在Snowflake平台中，可立即查询。它包含超过5000个表，涵盖了英国卫生部门使用的所有统计和参考数据，示例包括A&E、SNOMED代码以及UPRN等字段。