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_pharmacy_wales
nhs_raw · other StatsWales
2krows
13.6KBsize
14columns
2026-09-06updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_raw.fct_pharmacy_wales 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) |
| canonical_ods_code | Nullable(String) |
| date | Nullable(String) |
| period | Nullable(String) |
| value | Nullable(Float64) |
| unit | Nullable(String) |
| category | Nullable(String) |
| source_pub | Nullable(String) |
| source_url | Nullable(String) |
Sample rows
| activity | pharmacy_wales | Contacted my GP pr | national | Wales | 2024-25 | fy | 25890 | count | emergency_medicine | Welsh community ph | https://api.stats. | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| activity | pharmacy_wales | Contacted my GP practice | national | Wales | 2024-25 | fy | 25890 | count | emergency_medicines | Welsh community pharmacy activity (S | https://api.stats.gov.wales/ | ||
| activity | pharmacy_wales | Contacted my GP practice | lhb | Betsi Cadwaladr University Local Hea | 2024-25 | fy | 8564 | count | emergency_medicines | Welsh community pharmacy activity (S | https://api.stats.gov.wales/ | ||
| activity | pharmacy_wales | Contacted my GP practice | lhb | Powys Teaching Local Health Board | 2024-25 | fy | 367 | count | emergency_medicines | Welsh community pharmacy activity (S | https://api.stats.gov.wales/ |
Cited by papers
- none yet