Datasets 77 tables · 13.3m rows

all prescribing activity demand workforce outcome context other

activity

1.8mtalking_therapies_raw 1.8mfct_activity_talking_therapies 1.7mfct_activity_talking_therapies 1.4mfct_activity_uec_sitrep 1.1mfct_activity_winter_sitrep 679kfct_activity_dental_contractor_payments_foi 507kfct_activity_chc_fnc 450kfct_activity_dental_stats_england 418kfct_activity_csds 375kfct_activity_mh_eip 286kfct_activity_hes 286kfct_activity_hes 222kfct_activity_breastfeeding 203kfct_activity_pc_ooh_scot 136kfct_activity_hospital_activity 123kfct_activity_bed_occupancy 123kfct_activity_bed_occupancy 107kfct_activity_iucadc 92kfct_activity_outpatient_referrals 89kfct_activity_vte 86kfct_activity_outpatient_transformation 85kfct_activity_pharmacy_first_payments_foi 82kfct_activity_dementia_screening 79kfct_activity_iuc111 77kfct_activity_mixed_sex 77kfct_activity_gp_extended_access_historical 66kfct_activity_community_discharge 64kfct_activity_shmi 64kfct_activity_smi_health_checks 62kfct_activity_ed_wait_times_wales 61kfct_activity_mhsds 61kfct_activity_mhsds 61kfct_activity_cyped 60kfct_activity_pharmacy_first_referrals_foi 58kfct_activity_pharmacy_child_flu_pilot 50kfct_activity_cdc 38kfct_activity_nhs_claims_history 32kfct_activity_mh_community_teams 31kfct_activity_fft 25kfct_activity_wheelchair 24kfct_activity_nhs_resolution_claims 19kfct_activity_gp_extended_access 17kfct_activity_estates_eric 15kfct_activity_dental_new_patient_premium 14kfct_activity_acute_provider_performance 14kfct_activity_acute_provider_performance 11kfct_activity_genomic_testing 11kfct_activity_virtual_ward 9kfct_activity_post_covid 9kfct_outcome_gp_survey_dental 7kfct_activity_maternity_services_monthly 7kfct_activity_ucr 6kfct_activity_eric 5kfct_activity_npda_audit 5kfct_dental_patients_wales 5kfct_activity_dental_patients_wales 5kfct_activity_cancelled_elective_ops 4kfct_activity_corridor_care 4kfct_activity_msds 4kfct_activity_msds 3kfct_activity_dental_treatment_detail_wales 3kfct_activity_dental_wales 2kfct_activity_critical_care 2kfct_activity_critical_care 2kfct_activity_pharmacy_wales 1kfct_activity_england_nhse_community_bed_audit 1kfct_activity_bed_kh03 1kfct_activity_orthodontic_children_adults_foi 735fct_activity_wgos_ophthalmics_wales 710fct_activity_community_bed_audit 624fct_activity_dental_uda_performer 592fct_activity_dtoc 592fct_activity_dtoc 494fct_activity_dental_antibiotic 294fct_activity_ihs_reimbursement_students 279fct_activity_dental_treatment_wales 9fct_activity_hrt_ppc

fct_activity_mh_eip

nhs_raw · activity NHS England

375krows

1.5MBsize

14columns

2026-08-18updated

OGL 3.0licence

Query this dataset

SELECT * FROM nhs_raw.fct_activity_mh_eip LIMIT 100

In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot

Schema

Column	Type
date	Nullable(DateTime64(6))
measure	Nullable(String)
value	Nullable(Float64)
unit	Nullable(String)
geography_level	Nullable(String)
geography_code	Nullable(String)
geography_name	Nullable(String)
category	Nullable(String)
commissioner_code	Nullable(String)
commissioner_name	Nullable(String)
source_pub	Nullable(String)
source_url	Nullable(String)
canonical_ods_code	Nullable(String)
trust_type	Nullable(String)

Sample rows

2019-09-01 00:00:0	pathways_0_1_weeks	pathways	trust	RXY	KENT AND MEDWAY NH	incomplete	07T	NHS CITY AND HACKN	NHSE Early Interve	https://www.englan	RXY	mental_health
2019-09-01 00:00:00.000000	pathways_0_1_weeks	pathways	trust	RXY	KENT AND MEDWAY NHS AND SOCIAL CARE	incomplete	07T	NHS CITY AND HACKNEY CCG	NHSE Early Intervention in Psychosis	https://www.england.nhs.uk/statistic	RXY	mental_health
2019-09-01 00:00:00.000000	pathways_1_2_weeks	pathways	trust	RXY	KENT AND MEDWAY NHS AND SOCIAL CARE	incomplete	07T	NHS CITY AND HACKNEY CCG	NHSE Early Intervention in Psychosis	https://www.england.nhs.uk/statistic	RXY	mental_health
2019-09-01 00:00:00.000000	pathways_2_3_weeks	pathways	trust	RXY	KENT AND MEDWAY NHS AND SOCIAL CARE	incomplete	07T	NHS CITY AND HACKNEY CCG	NHSE Early Intervention in Psychosis	https://www.england.nhs.uk/statistic	RXY	mental_health

Cited by papers

none yet