Datasets 413 datasets
prescribing
1.08bnfct_prescribing847.5mepd_prescribing38.4mfct_pcacontext
22.5mfct_context_fingertips_allother
16.6mfct_scmdprescribing
12.0mfct_hospital_dispenseddemand
7.2mfct_demand_rttprescribing
6.9mdim_prescriberoutcome
6.9mfct_outcome_gp_surveyprescribing
6.6mdim_prescriber_rawworkforce
5.3mfct_workforce_mainprescribing
3.8mfct_activity_prescribing_secondaryactivity
3.5mfct_activity_hes_monthlycontext
2.7mdim_postcode_geodemand
2.6mfct_demand_canceractivity
1.9mfct_activity_dental_contractor_payments_foi1.7mfct_activity_talking_therapiesprescribing
1.7mfct_activity_prescribing_paper1.7mfct_activity_dispensing_doctor_padmcontext
1.4mdim_gp_practice_populations_scot_long_rawactivity
1.3mfct_activity_uec_sitrepcontext
1.1mfct_context_fingertips_profilesactivity
1.1mfct_activity_winter_sitrepworkforce
1.1mfct_workforce_staff_survey_archiveoutcome
1.0mfct_outcome_la_life_expectancyactivity
954kstg_uec_sitrep_p3_wintersdemand
926kfct_demand_diagnosticsoutcome
859kfct_outcome_ons_la_life_expectancyprescribing
823kfct_activity_prescribed_dispensed_scotcontext
761kfct_context_phof744kfct_context_social_services_walesprescribing
702kstg_item_prescribing_dispenserscontext
659kfct_context_pharmacy_qualityactivity
659kfct_activity_pharmacy_qualityother
637kstg_contracts_finder_tender_itemscontext
581kfct_context_population_projections_scotactivity
563kfct_activity_acute_dischargeoutcome
548kfct_outcome_covid_19_wider_impacts_scotcontext
542kfct_context_childhood_vaccinationactivity
536kfct_activity_diagnostic_imagingcontext
536kdim_activity_diagnostic_imagingoutcome
518kfct_outcome_heart_disease_statistics_scotworkforce
510kfct_workforce_staff_survey510kdim_staff_surveyactivity
507kfct_activity_chc_fncdemand
478kfct_demand_ae469kfct_demand_gp_appointmentscontext
457kfct_context_cqc_directoryactivity
450kfct_activity_dental_stats_englanddemand
441kfct_demand_ambulanceprescribing
428kfct_context_prescribing_glp1_foiactivity
418kfct_activity_csdsoutcome
396kfct_outcome_proms383kfct_outcome_smoking_quit_successactivity
375kfct_activity_mh_eipoutcome
365kfct_outcome_births_hospitals_scotcontext
365kdim_outcome_births_hospitals_scotother
326kfct_gp_registered_patientscontext
314kdim_cqc_long_raw311kdim_gp_walesother
297kstg_cf_partiescontext
297kfct_context_alcoholactivity
286kfct_activity_hesdemand
264kfct_demand_ae_weekly_scotcontext
253kfct_context_la_health_profile233kfct_context_health_protection233kfct_context_flu_covid_surveillance227kfct_context_cancer_prevalence222kdim_population_long_rawactivity
222kfct_activity_breastfeedingprescribing
211kfct_context_scottish_dispensedactivity
203kfct_activity_pc_ooh_scotworkforce
203kfct_workforce_sickness_absenceprescribing
197kfct_context_glp1_first_dispensing_foioutcome
197kfct_outcome_ons_weekly_deathscontext
194kfct_context_respiratory191kdim_geographyprescribing
187kdim_gp_prescriber_settings_rawcontext
174kfct_experience_cqc_survey174kdim_experience_cqc_surveyoutcome
173kfct_outcome_shmi_diag_groupworkforce
170kdim_gp_workforce_scot_rawcontext
163kfct_context_help_health_costsoutcome
160kfct_outcome_mortality_weekly158kfct_mortality_weeklyother
155kfct_acute_plac155kfct_acute_patient_level_activity_and_costing151kstg_procurement_contracts_finder_releases151kstg_contracts_finder_notices150kstg_cf_supplierscontext
144kfct_context_public_healthactivity
136kfct_activity_hospital_activitycontext
134kfct_context_census_migration_birthplaceactivity
123kfct_activity_bed_occupancyother
121kstg_cf_awardsoutcome
120kfct_outcome_screeningactivity
119kfct_activity_cancer_waiting_times_walesdemand
119kdim_activity_cancer_waiting_times_walesprescribing
119kfct_activity_dispensingother
117kstg_rtt_ni_trust_specialtyprescribing
117kfct_activity_prescribing_bnf_chapter_demog_foiactivity
117kfct_activity_bnf_chapter_demogcontext
117kfct_context_census_rm_general_health117kdim_context_census_rm_general_health116kfct_context_smokingother
116kstg_foi_antidepressants_patientsprescribing
116kfct_prescribing_foi_antidepressantsactivity
107kfct_activity_iucadccontext
93kfct_context_personal_wellbeing_ons_apiactivity
92kfct_activity_outpatient_referrals92kfct_activity_ereferralcontext
91kfct_context_adhd_stimulantactivity
89kfct_activity_vte87kfct_activity_discharge_delay85kfct_activity_pharmacy_first_payments_foi84kfct_activity_outpatient_transformationprescribing
83kepd_roll_month_chemcontext
83kfct_context_liver_diseaseactivity
82kfct_activity_dementia_screeningcontext
80kfct_context_palliative_careactivity
79kfct_activity_iuc111context
79kfct_context_census_rm_multivariateactivity
78kfct_activity_mixed_sex77kfct_activity_gp_extended_access_historicaldemand
75kfct_demand_wlmsworkforce
74kfct_workforce_vacanciescontext
74kfct_context_private_adhd_cns_foiother
73kstg_did_test_to_reportactivity
71kfct_activity_dentalcontext
71kfct_context_nimdm17_niactivity
66kfct_activity_community_discharge64kfct_activity_shmi64kfct_activity_smi_health_checks62kfct_activity_ed_wait_times_wales61kfct_activity_mhsds61kfct_activity_cyped60kfct_activity_pharmacy_first_referrals_foi58kfct_activity_pharmacy_child_flu_pilotcontext
58kdim_bnf_rawoutcome
55kfct_outcome_qof54kfct_outcome_mortality54kfct_outcome_ons_monthly_deaths53kfct_outcome_breastfeeding_walesprescribing
52kfct_dispensing_pharmacy_misother
51kmart_rtt_incomplete_trust_monthlycontext
50kfct_context_uk_labour_marketactivity
50kfct_activity_cdccontext
48kfct_context_gp_profileother
48kstg_innovateuk_awardsoutcome
47kfct_outcome_mh_measure_walescontext
46kfct_context_census_rm_economic_activity46kdim_context_census_rm_economic_activityother
46kfct_innovateuk_awardsprescribing
46kfct_context_nhsbsa_prescription_dispensingcontext
43kdim_national_life_tables_long_rawoutcome
42kfct_outcome_nod_auditcontext
40kfct_context_census_caring_identity39kfct_context_sti_surveillanceactivity
38kfct_activity_nhs_claims_historycontext
37kfct_context_litigation37kdim_population_estimatesprescribing
36kfct_prescribing_hrt_nhsbsaoutcome
35kfct_outcome_shingles_immunisationcontext
34kdim_provider_org_register_rawactivity
33kfct_activity_fft32kfct_activity_mh_community_teamsoutcome
31kfct_outcome_lung_cancer_auditother
29kstg_ctgov_uk_trialsoutcome
28kfct_outcome_screening_kpi_quarterlycontext
26kfct_context_children_looked_after_wales_stock_flowoutcome
25kfct_outcome_death_cause_summaryother
25kmart_cancer_trust_monthlycontext
25kfct_context_contraception_patients_foiactivity
25kfct_activity_wheelchairoutcome
24kfct_outcome_hcai_all_cause_fatalityactivity
24kfct_activity_nhs_resolution_claimsoutcome
23kfct_outcome_cancer_experienceother
22kmart_ae_trust_monthlyprescribing
21kdim_chemical_bnfcontext
21kfct_context_older_people_sex_ratioother
21kfct_drug_alcohol_initial_assessments_scotcontext
21kfct_context_dementia_profileoutcome
21kfct_outcome_child_flying_start_wales20kfct_outcome_noids_weekly19kfct_outcome_personal_wellbeingactivity
19kfct_activity_gp_extended_accessworkforce
19kfct_workforce_vacancies_ingestother
18kfct_older_people_sex_ratioactivity
17kfct_activity_estates_ericcontext
16kfct_context_cancer_servicesoutcome
16kfct_outcome_cancer_experience_trustprescribing
16kfct_activity_scottish_dispensingcontext
16kfct_context_ageing_population_estimatesoutcome
16kfct_outcome_nela_emergency_laparotomyactivity
15kfct_activity_dental_new_patient_premiumother
15krq_03_trials_raw15kfct_clinical_trialscontext
14kfct_context_pcn_debt_recoveryactivity
14kfct_activity_acute_provider_performancecontext
14kfct_context_wimd_walesoutcome
14kfct_outcome_maternity_child_wales13kfct_outcome_vaccinationother
13kstg_ctgov_uk_industry_interventionalworkforce
13kmart_workforce_wte_trust_monthlyother
13kmart_percapita_trust_monthlyprescribing
13kfct_context_prescribing_diabetes_pfdcontext
12kfct_context_better_care_fund12kfct_context_census_caring_identity_rm191outcome
12kfct_outcome_stroke_scotactivity
11kfct_activity_genomic_testingcontext
11kfct_context_census_dwelling_stockoutcome
11kfct_outcome_ons_child_mortalityactivity
11kfct_activity_virtual_wardoutcome
11kfct_outcome_hfea_fertilitycontext
10kdim_national_cost_collection_long_rawoutcome
10kfct_outcome_pancreatic_cancer_auditcontext
10kfct_context_adult_obesityprescribing
10kfct_activity_prescribing_dispenser_linkage_foioutcome
10kfct_outcome_shmi_trustcontext
10kfct_context_birthsother
10kstg_ctgov_industry_trialsoutcome
10kfct_outcome_heart_failure_auditprescribing
10kfct_context_ed_prescribingactivity
9kfct_activity_post_covidcontext
9kfct_context_population_fingertips9kdim_practiceactivity
9kfct_outcome_gp_survey_dentalother
9kmap_pcn_trustoutcome
9kfct_outcome_smoking_cessation_quits_walescontext
9kfct_context_ncsp_chlamydia_trends8kfct_context_amr_local_indicatorsoutcome
8kfct_outcome_cancer_experience_icb8kfct_outcome_shmi_siteother
7kvaccination_rawactivity
7kfct_activity_maternity_services_monthly7kfct_activity_ucrcontext
7kfct_context_qof_disease_registers_walesworkforce
7kstg_workforce_scot_vacanciescontext
7kdim_nhsbsa_contract_long_rawactivity
7kfct_activity_cancelled_elective_ops6kfct_workforce_dental_workforce6kdim_workforce_dental_workforceprescribing
6kfct_activity_prescribing_nondispensedother
6keric_rawactivity
6kfct_activity_ericother
6kfct_gp_registered_totalscontext
6kdim_gp_practice_map6kdim_pcnoutcome
6kfct_outcome_ons_wellbeing_quarterlydemand
6kfct_demand_cancelled_ops6kfct_demand_vaccinationoutcome
6kfct_outcome_screening_aaacontext
6kfct_context_census_veterans_householdsoutcome
5kfct_outcome_kidney_cancer_auditprescribing
5kfct_prescribing_trustactivity
5kfct_activity_npda_audit5kfct_dental_patients_wales5kfct_activity_dental_patients_walesoutcome
5kfct_outcome_smoking_cessation_scot5kfct_outcome_conceptionscontext
4kfct_context_opioid_hypnotic_gender_monthlyoutcome
4kfct_outcome_oesophago_gastric_cancer_audit4kfct_outcome_alcohol_deathscontext
4kdim_pharmacy_fp57_refunds_long_rawactivity
4kfct_activity_corridor_careoutcome
4kfct_outcome_covid19_wider_impacts_cardiovascular_scotactivity
4kfct_activity_msdsoutcome
4kfct_outcome_deaths_by_cause4kfct_outcome_patient_safetyother
4kiuk_awards_aggworkforce
3kmart_workforce_by_staffgroup_monthlyother
3kfft_rawactivity
3kfct_activity_dental_treatment_detail_walescontext
3kfct_context_hepatitis_b_surveillanceother
3kfct_drug_related_hospital_statistics_scotcontext
3kfct_context_children_looked_after_wales_extactivity
3kfct_activity_dental_walesoutcome
3kfct_outcome_cancer_experience_ca3kfct_outcome_influenza_annual_uk2kfct_outcome_picanet_auditother
2kgovt_funded_researchoutcome
2kfct_outcome_screening_deswactivity
2kfct_activity_critical_carecontext
2kfct_context_census_general_healthoutcome
2kfct_outcome_coroners_statisticscontext
2kfct_context_ecds_investigationsoutcome
2kfct_outcome_hiv_action_plan_mef2kmart_excess_mortality_weeklyother
2kfct_pharmacy_walesactivity
2kfct_activity_pharmacy_walesoutcome
2krq02b_deaths2kfct_rq02b_deaths2kfct_outcome_maternal_mortality_data_brief2kfct_outcome_prostate_cancer_auditcontext
2kfct_context_antidepressant_sicbl_age_foiprescribing
2kepd_roll_month_icb2krq02b_epd2kfct_rq02b_epdother
2krq02b_panel_merged2krq02b_panel2kfct_rq02b_panel_mergedcontext
1kdim_trust_rawactivity
1kfct_activity_england_nhse_community_bed_auditcontext
1kdim_pcn_rawworkforce
1krq02b_workforce1kfct_rq02b_workforcecontext
1kfct_context_pharmacy_openings_closuresother
1kstg_rq27911_fda_510k_openfdacontext
1kdim_fingertips_indicators1kdim_trust1kdim_trust_sitesactivity
1kfct_activity_bed_kh031kfct_activity_orthodontic_children_adults_foiprescribing
971dim_dispensing_practice_rawdemand
892fct_demand_fftoutcome
823fct_outcome_mpox_vaccinationcontext
823dim_outcome_mpox_vaccination779fct_context_hypnotics_sicbl_foiactivity
735fct_activity_wgos_ophthalmics_walesoutcome
714fct_outcome_shmiactivity
710fct_activity_community_bed_auditcontext
692dim_asc_social_care673fct_context_hypnotics_age_cuts_2023655fct_context_legionellosis_surveillanceactivity
624fct_activity_dental_uda_performercontext
567fct_context_hypnotics_age_cuts_2023_foiother
543stg_rq27916_fda_radiology_aioutcome
520mart_mortality_by_imd_monthly513fct_outcome_vaccination_seasonalactivity
494fct_activity_dental_antibioticprescribing
465fct_prescribing_strength_pair465fct_context_prescribing_strength_pair_foiactivity
448fct_activity_dtocoutcome
412fct_outcome_hpv_vaccine_coverageother
403stg_rq27910_fda_ai_devices381_ingest_manifestcontext
372fct_context_notifiable_diseasesprescribing
365fct_context_cannabis_prescribing_foiother
364meta_dataset357rq27917_h_stg_openfda_510k_aiprescribing
357mart_prescribing_per_capitacontext
299fct_context_vdps298fct_context_ssbbv_sentinel_blood_borne_virusactivity
294fct_activity_ihs_reimbursement_students279fct_activity_dental_treatment_walesoutcome
278fct_outcome_maternal_mortality_audit_databrief264fct_outcome_pregnancy_screening_scotcontext
252dim_dateoutcome
237fct_outcome_enterococcus_bacteraemiaworkforce
231mart_workforce_per_capita_region_monthlyoutcome
209fct_outcome_flu_vaccinationother
188stg_rq27916_imaging_procurementcontext
162dim_specialty_codes_scot_long_rawoutcome
144fct_outcome_maternal_mortality_auditcontext
140fct_context_pension_payment_delaysprescribing
139fct_prescribing_trust_weightscontext
125fct_context_charge_complianceoutcome
122fct_outcome_cancer_experience_nationalcontext
115fct_context_baby_loss_certificate94fct_context_gp_pension_employment_foi93dim_legacy_org_mapping90fct_context_liothyronineother
87fct_productivity_onscontext
85fct_context_metformin_foi85dim_context_metformin_foiother
84scmd_monthly_national67mart_critical_care_beds_dailycontext
62dim_region_aliasother
53isrctn_commercial_by_dimension52rq27917_vendor_clearances49rq02b_icb_bridgeoutcome
49rq02b_deaths_by_e54prescribing
48epd_roll_monthcontext
44dim_fingertips_area_typesother
42rq02b_bridge_cleancontext
42dim_icb_raw38dim_fingertips_profilesother
29ctgov_uk_industry_by_year28stg_rq27910_ai_imaging_trials26isrctn_commercial_by_yearactivity
25fct_activity_polio_vaccination_londoncontext
20fct_context_pension_transfers_out_foiother
20isrctn_commercial_top_funders19rq_26_domain26_digital_maturity_dashboard__digital_maturitycontext
18dim_regionother
16rq_25298__cpv_health_tech16ingest_manifest15ctgov_uk_industry_top_sponsors15ctgov_uk_industry_top_conditions13rq16_ichp12rq16_hin_south_london12ctgov_uk_industry_by_status11rq_25299__london_icb_benchmark_seed10rq16_scorecard_add10rq16_mhra_performanceactivity
9fct_activity_hrt_ppcother
8rq_25299__ahsn_spread_seed8rq_25298__ols_healthtech_companies8rq16_uclpartners8rq16_scorecard_headline
dim_specialty_codes_scot_long_raw
nhs_raw · context Public Health Scotland
162rows
3.6KBsize
17columns
2026-09-29updated
varieslicence — see publisher
Query this dataset
SELECT * FROM nhs_raw.dim_specialty_codes_scot_long_raw 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) |
| specialty_code | Nullable(String) |
| specialty_name | Nullable(String) |
| value | Nullable(Int64) |
| unit | Nullable(String) |
| vintage_date | Nullable(String) |
| date | Nullable(String) |
| period | Nullable(String) |
| source_pub | Nullable(String) |
| source_url | Nullable(String) |
| source_file | Nullable(String) |
Sample rows
| reference | specialty_codes_sc | specialty | A1 | General Medicine | 1 | specialty | 2026-09-03 | 2026-09-03 | 2026-09 | Public Health Scot | https://www.openda | specialty_codes.cs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| reference | specialty_codes_scot | specialty | A1 | General Medicine | 1 | specialty | 2026-09-03 | 2026-09-03 | 2026-09 | Public Health Scotland | https://www.opendata.nhs.scot/datase | specialty_codes.csv | ||||
| reference | specialty_codes_scot | specialty | A11 | Acute Medicine | 1 | specialty | 2026-09-03 | 2026-09-03 | 2026-09 | Public Health Scotland | https://www.opendata.nhs.scot/datase | specialty_codes.csv | ||||
| reference | specialty_codes_scot | specialty | A2 | Cardiology | 1 | specialty | 2026-09-03 | 2026-09-03 | 2026-09 | Public Health Scotland | https://www.opendata.nhs.scot/datase | specialty_codes.csv |
Cited by papers
- none yet