Datasets 77 tables · 13.3m rows
activity
1.8mtalking_therapies_raw1.8mfct_activity_talking_therapies1.7mfct_activity_talking_therapies1.4mfct_activity_uec_sitrep1.1mfct_activity_winter_sitrep679kfct_activity_dental_contractor_payments_foi507kfct_activity_chc_fnc450kfct_activity_dental_stats_england418kfct_activity_csds375kfct_activity_mh_eip286kfct_activity_hes286kfct_activity_hes222kfct_activity_breastfeeding203kfct_activity_pc_ooh_scot136kfct_activity_hospital_activity123kfct_activity_bed_occupancy123kfct_activity_bed_occupancy107kfct_activity_iucadc92kfct_activity_outpatient_referrals89kfct_activity_vte86kfct_activity_outpatient_transformation85kfct_activity_pharmacy_first_payments_foi82kfct_activity_dementia_screening79kfct_activity_iuc11177kfct_activity_mixed_sex77kfct_activity_gp_extended_access_historical66kfct_activity_community_discharge64kfct_activity_shmi64kfct_activity_smi_health_checks62kfct_activity_ed_wait_times_wales61kfct_activity_mhsds61kfct_activity_mhsds61kfct_activity_cyped60kfct_activity_pharmacy_first_referrals_foi58kfct_activity_pharmacy_child_flu_pilot50kfct_activity_cdc38kfct_activity_nhs_claims_history32kfct_activity_mh_community_teams31kfct_activity_fft25kfct_activity_wheelchair24kfct_activity_nhs_resolution_claims19kfct_activity_gp_extended_access17kfct_activity_estates_eric15kfct_activity_dental_new_patient_premium14kfct_activity_acute_provider_performance14kfct_activity_acute_provider_performance11kfct_activity_genomic_testing11kfct_activity_virtual_ward9kfct_activity_post_covid9kfct_outcome_gp_survey_dental7kfct_activity_maternity_services_monthly7kfct_activity_ucr6kfct_activity_eric5kfct_activity_npda_audit5kfct_dental_patients_wales5kfct_activity_dental_patients_wales5kfct_activity_cancelled_elective_ops4kfct_activity_corridor_care4kfct_activity_msds4kfct_activity_msds3kfct_activity_dental_treatment_detail_wales3kfct_activity_dental_wales2kfct_activity_critical_care2kfct_activity_critical_care2kfct_activity_pharmacy_wales1kfct_activity_england_nhse_community_bed_audit1kfct_activity_bed_kh031kfct_activity_orthodontic_children_adults_foi735fct_activity_wgos_ophthalmics_wales710fct_activity_community_bed_audit624fct_activity_dental_uda_performer592fct_activity_dtoc592fct_activity_dtoc494fct_activity_dental_antibiotic294fct_activity_ihs_reimbursement_students279fct_activity_dental_treatment_wales9fct_activity_hrt_ppc
talking_therapies_raw
nhs_raw · activity NHS England
1.8mrows
4.4MBsize
24columns
2026-08-17updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_raw.talking_therapies_raw LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| reporting_period_start | Nullable(String) |
| reporting_period_end | Nullable(String) |
| group_type | Nullable(String) |
| org_code1 | Nullable(String) |
| org_name1 | Nullable(String) |
| org_code2 | Nullable(String) |
| org_name2 | Nullable(String) |
| measure_id | Nullable(String) |
| measure_name | Nullable(String) |
| measure_value_suppressed | Nullable(String) |
| month | Nullable(String) |
| source_file | Nullable(String) |
| reportingperiodstartdate | Nullable(String) |
| reportingperiodenddate | Nullable(String) |
| org_code | Nullable(String) |
| datatable | Nullable(String) |
| uid | Nullable(String) |
| dataitem | Nullable(String) |
| valid_suppressed | Nullable(String) |
| default_suppressed | Nullable(String) |
| invalid_suppressed | Nullable(String) |
| missing_suppressed | Nullable(String) |
| denominator_suppressed | Nullable(String) |
| measure_value | Nullable(String) |
Sample rows
| 2025-05-01 | 2025-05-31 | Provider | all | all SubICBs | 8EJ83 | RENNIE GROVE PEACE | M001 | Count_ReferralsRec | None | 2025-05 | talkingtherapies_t | None | None | None | None | None | None | None | None | None | None | None | * |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-05-01 | 2025-05-31 | Provider | all | all SubICBs | 8EJ83 | RENNIE GROVE PEACE HOSPICE CARE (PEA | M001 | Count_ReferralsReceived | None | 2025-05 | talkingtherapies_timeseries_may2025- | None | None | None | None | None | None | None | None | None | None | None | * |
| 2025-05-01 | 2025-05-31 | SubICB/Provider | 06K | NHS HERTFORDSHIRE AND WEST ESSEX ICB | 8EJ83 | RENNIE GROVE PEACE HOSPICE CARE (PEA | M001 | Count_ReferralsReceived | None | 2025-05 | talkingtherapies_timeseries_may2025- | None | None | None | None | None | None | None | None | None | None | None | * |
| 2025-05-01 | 2025-05-31 | SubICB/Provider | 06N | NHS HERTFORDSHIRE AND WEST ESSEX ICB | 8EJ83 | RENNIE GROVE PEACE HOSPICE CARE (PEA | M001 | Count_ReferralsReceived | None | 2025-05 | talkingtherapies_timeseries_may2025- | None | None | None | None | None | None | None | None | None | None | None | * |