Datasets 81 datasets

all prescribingactivitydemandworkforceoutcomecontextother
other
16.6mfct_scmd637kstg_contracts_finder_tender_items326kfct_gp_registered_patients297kstg_cf_parties155kfct_acute_plac155kfct_acute_patient_level_activity_and_costing151kstg_procurement_contracts_finder_releases151kstg_contracts_finder_notices150kstg_cf_suppliers121kstg_cf_awards117kstg_rtt_ni_trust_specialty116kstg_foi_antidepressants_patients73kstg_did_test_to_report51kmart_rtt_incomplete_trust_monthly48kstg_innovateuk_awards46kfct_innovateuk_awards29kstg_ctgov_uk_trials25kmart_cancer_trust_monthly22kmart_ae_trust_monthly21kfct_drug_alcohol_initial_assessments_scot18kfct_older_people_sex_ratio15krq_03_trials_raw15kfct_clinical_trials13kstg_ctgov_uk_industry_interventional13kmart_percapita_trust_monthly10kstg_ctgov_industry_trials9kmap_pcn_trust7kvaccination_raw6keric_raw6kfct_gp_registered_totals4kiuk_awards_agg3kfft_raw3kfct_drug_related_hospital_statistics_scot2kgovt_funded_research2kfct_pharmacy_wales2krq02b_panel_merged2krq02b_panel2kfct_rq02b_panel_merged1kstg_rq27911_fda_510k_openfda543stg_rq27916_fda_radiology_ai403stg_rq27910_fda_ai_devices381_ingest_manifest364meta_dataset357rq27917_h_stg_openfda_510k_ai188stg_rq27916_imaging_procurement87fct_productivity_ons84scmd_monthly_national67mart_critical_care_beds_daily53isrctn_commercial_by_dimension52rq27917_vendor_clearances49rq02b_icb_bridge42rq02b_bridge_clean29ctgov_uk_industry_by_year28stg_rq27910_ai_imaging_trials26isrctn_commercial_by_year20isrctn_commercial_top_funders19rq_26_domain26_digital_maturity_dashboard__digital_maturity16rq_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_performance8rq_25299__ahsn_spread_seed8rq_25298__ols_healthtech_companies8rq16_uclpartners8rq16_scorecard_headline8rq16_oecd_hcqi8ctgov_uk_industry_by_phase7stg_aidoc_funding6rq_25298__nhsbsa_pipeline6isrctn_commercial_results_reporting4rq_25298__contracts_health_tech4rq16_hin_network4ctgov_uk_industry_results_reporting3_t21nspl_meta

stg_ctgov_uk_industry_interventional

nhs_raw · other NHS England

13krows
199.1MBsize
34columns
2026-09-30updated
varieslicence — see publisher
Query this dataset
SELECT * FROM nhs_raw.stg_ctgov_uk_industry_interventional LIMIT 100

In-warehouse SQL · raw on S3 (limoja-nhs-warehouse) · JSON metadata · or ask the copilot

Schema

ColumnType
nct_idNullable(String)
org_study_idNullable(String)
brief_titleNullable(String)
official_titleNullable(String)
overall_statusNullable(String)
why_stoppedNullable(String)
start_dateNullable(String)
start_yearNullable(Float64)
completion_dateNullable(String)
first_postedNullable(String)
last_updateNullable(String)
lead_sponsor_nameNullable(String)
lead_sponsor_classNullable(String)
responsible_partyTuple( type Nullable(String), oldNameTitle Nullable(String), oldOrganization Nullable(String), investigatorFullName Nullable(String), investigatorTitle Nullable(String), investigatorAffiliation Nullable(String))
study_typeNullable(String)
phasesNullable(String)
enrollmentNullable(Float64)
allocationNullable(String)
primary_purposeNullable(String)
maskingNullable(String)
sexNullable(String)
minimum_ageNullable(String)
maximum_ageNullable(String)
healthy_volunteersNullable(Bool)
conditionsNullable(String)
condition_countNullable(Int64)
intervention_countNullable(Int64)
arm_group_countNullable(Int64)
primary_outcome_countNullable(Int64)
secondary_outcome_countNullable(Int64)
location_countNullable(Int64)
has_uk_locationNullable(Bool)
source_fileNullable(String)
raw_jsonNullable(String)

Sample rows

NCT04633187EDP 938-103Effects of EDP-938A Phase 2b, RandomTERMINATEDStudy was terminat2021-07-0720212023-05-312020-11-182024-08-22Enanta PharmaceutiINDUSTRY{'type': 'SPONSOR'INTERVENTIONALPHASE29RANDOMIZEDTREATMENTDOUBLEALL16 Years75 YearsFalseRespiratory Syncyt1221464TrueS001.json{"protocolSection"
NCT04633187EDP 938-103Effects of EDP-938 in Hematopoietic A Phase 2b, Randomized, Double-BlindTERMINATEDStudy was terminated due to a strate2021-07-0720212023-05-312020-11-182024-08-22Enanta Pharmaceuticals, IncINDUSTRY{'type': 'SPONSOR', 'oldNameTitle': INTERVENTIONALPHASE29RANDOMIZEDTREATMENTDOUBLEALL16 Years75 YearsFalseRespiratory Syncytial Virus Infectio1221464TrueS001.json{"protocolSection":{"identificationM
NCT04862663D361DC00001Capivasertib + CDK4/6i + FulvestrantA Phase Ib/III, Open-label, RandomisACTIVE_NOT_RECRUITINGNone2021-05-1020212029-08-142021-04-282026-08-17AstraZenecaINDUSTRY{'type': 'SPONSOR', 'oldNameTitle': INTERVENTIONALPHASE3893RANDOMIZEDTREATMENTNONEALL18 Years99 YearsFalseLocally Advanced (Inoperable) or Met155422225TrueS001.json{"protocolSection":{"identificationM
NCT00160693C87015Open Label Long-Term Safety Study ofA Phase III, Multicenter, Open-LabelCOMPLETEDNone2003-0320032011-022005-09-122018-08-01UCB PharmaINDUSTRY{'type': 'SPONSOR', 'oldNameTitle': INTERVENTIONALPHASE3402NATREATMENTNONEALL18 YearsNoneFalseRheumatoid Arthritis11121261TrueS001.json{"protocolSection":{"identificationM

Cited by papers

  • none yet
Copilotdeep · LLM + SQL