Datasets 69 tables · 8.7m rows
context
1.4mdim_gp_practice_populations_scot_long_raw1.1mfct_context_fingertips_profiles761kfct_context_phof659kfct_context_pharmacy_quality581kfct_context_population_projections_scot542kfct_context_childhood_vaccination443kfct_context_cqc_directory314kdim_cqc_long_raw297kfct_context_alcohol253kfct_context_la_health_profile233kfct_context_health_protection233kfct_context_flu_covid_surveillance222kdim_population_long_raw194kfct_context_respiratory163kfct_context_help_health_costs144kfct_context_public_health116kfct_context_smoking93kfct_context_personal_wellbeing_ons_api91kfct_context_adhd_stimulant83kfct_context_liver_disease80kfct_context_palliative_care79kfct_context_census_rm_multivariate74kfct_context_private_adhd_cns_foi71kfct_context_nimdm17_ni58kdim_bnf_raw48kfct_context_gp_profile43kdim_national_life_tables_long_raw39kfct_context_sti_surveillance37kfct_context_litigation37kdim_population_estimates25kfct_context_contraception_patients_foi21kfct_context_dementia_profile16kfct_context_cancer_services14kfct_context_pcn_debt_recovery12kfct_context_better_care_fund12kfct_context_census_caring_identity_rm19111kfct_context_census_dwelling_stock10kdim_national_cost_collection_long_raw10kfct_context_adult_obesity9kfct_context_population_fingertips9kdim_practice8kfct_context_amr_local_indicators7kfct_context_qof_disease_registers_wales4kdim_pharmacy_fp57_refunds_long_raw3kfct_context_hepatitis_b_surveillance2kfct_context_census_general_health2kfct_context_antidepressant_sicbl_age_foi1kdim_trust_raw1kdim_pcn_raw1kfct_context_pharmacy_openings_closures1kdim_trust779fct_context_hypnotics_sicbl_foi673fct_context_hypnotics_age_cuts_2023655fct_context_legionellosis_surveillance567fct_context_hypnotics_age_cuts_2023_foi299fct_context_vdps298fct_context_ssbbv_sentinel_blood_borne_virus252dim_date125fct_context_charge_compliance115fct_context_baby_loss_certificate94fct_context_gp_pension_employment_foi93dim_legacy_org_mapping90fct_context_liothyronine62dim_region_alias42dim_icb_raw42dim_icb18dim_region7dim_population_by_region4fct_context_nhs_pension_payment_bands_foi
fct_context_pharmacy_openings_closures
nhs_raw · context NHS England
1krows
11.0KBsize
16columns
2026-08-18updated
OGL 3.0licence
Query this dataset
SELECT * FROM nhs_raw.fct_context_pharmacy_openings_closures 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) |
| category | Nullable(String) |
| date | Nullable(String) |
| period | Nullable(String) |
| value | Nullable(Float64) |
| unit | Nullable(String) |
| source_pub | Nullable(String) |
| source_url | Nullable(String) |
| size_band | Nullable(String) |
| publication_vintage | Nullable(String) |
Sample rows
| context | pharmacy_openings_ | total_pharmacies | national | E92000001 | England | event | 2021-01 | month | 11206 | pharmacies | NHSBSA Pharmacy Op | https://opendata.n | all | 202607 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| context | pharmacy_openings_closures | total_pharmacies | national | E92000001 | England | event | 2021-01 | month | 11206 | pharmacies | NHSBSA Pharmacy Openings and Closure | https://opendata.nhsbsa.net/dataset/ | all | 202607 | |
| context | pharmacy_openings_closures | total_pharmacies_excluding_distance_ | national | E92000001 | England | event | 2021-01 | month | 10837 | pharmacies | NHSBSA Pharmacy Openings and Closure | https://opendata.nhsbsa.net/dataset/ | all | 202607 | |
| context | pharmacy_openings_closures | total_pharmacies_excluding_distance_ | national | E92000001 | England | event | 2021-01 | month | 10837 | pharmacies | NHSBSA Pharmacy Openings and Closure | https://opendata.nhsbsa.net/dataset/ | all_ex_distance_sellers | 202607 |
Cited by papers
- none yet