Datasets 36 tables · 371k rows
other
155kfct_acute_plac62kmart_ae_trust_monthly51kmart_rtt_incomplete_trust_monthly25kmart_cancer_trust_monthly21kfct_drug_alcohol_initial_assessments_scot18kfct_older_people_sex_ratio13kmart_percapita_trust_monthly7kvaccination_raw6keric_raw4kiuk_awards_agg3kfft_raw2kgovt_funded_research2kfct_pharmacy_wales213_ingest_manifest87fct_productivity_ons87fct_productivity_ons67mart_critical_care_beds_daily53isrctn_commercial_by_dimension29ctgov_uk_industry_by_year26isrctn_commercial_by_year20isrctn_commercial_top_funders15ctgov_uk_industry_top_sponsors15ctgov_uk_industry_top_conditions13rq16_ichp12rq16_hin_south_london12ctgov_uk_industry_by_status10rq16_scorecard_add10rq16_mhra_performance8rq16_uclpartners8rq16_scorecard_headline8rq16_oecd_hcqi8ctgov_uk_industry_by_phase6isrctn_commercial_results_reporting4rq16_hin_network4ctgov_uk_industry_results_reporting3_t2
fct_productivity_ons
nhs_marts · other NHS England
87rows
1.6KBsize
15columns
2026-09-16updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_marts.fct_productivity_ons LIMIT 100
In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot
Schema
| Column | Type |
|---|---|
| pillar | Nullable(String) |
| series | Nullable(String) |
| measure | Nullable(String) |
| geography_level | Nullable(String) |
| geography_code | Nullable(String) |
| geography_name | Nullable(String) |
| date | Nullable(String) |
| period | Nullable(String) |
| value | Nullable(Float64) |
| unit | Nullable(String) |
| source_pub | Nullable(String) |
| source_url | Nullable(String) |
| canonical_ods_code | Nullable(String) |
| trust_type | Nullable(String) |
| month_date | Nullable(Date) |
Sample rows
| productivity | ons_psp_total | psp_inputs | national | United Kingdom | 1997 | year | 100 | index 1997=100 | ONS Public service | https://www.ons.go | None | None | None | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| productivity | ons_psp_total | psp_inputs | national | United Kingdom | 1997 | year | 100 | index 1997=100 | ONS Public service productivity quar | https://www.ons.gov.uk/economy/econo | None | None | None | |
| productivity | ons_psp_total | psp_inputs | national | United Kingdom | 1998 | year | 101.6 | index 1997=100 | ONS Public service productivity quar | https://www.ons.gov.uk/economy/econo | None | None | None | |
| productivity | ons_psp_total | psp_inputs | national | United Kingdom | 1999 | year | 104.7 | index 1997=100 | ONS Public service productivity quar | https://www.ons.gov.uk/economy/econo | None | None | None |
Cited by papers
- none yet