clinical_trial_design_id |
int8 |
19 |
√ |
|
null |
|
|
ref_article_protocol_id |
varchar |
4000 |
√ |
|
null |
|
|
ref_record_id |
varchar |
4000 |
√ |
|
null |
|
|
ref_back_reference |
varchar |
4000 |
√ |
|
null |
|
|
ref_article_pmid |
varchar |
4000 |
√ |
|
null |
|
|
ref_protocol_id |
varchar |
4000 |
√ |
|
null |
|
|
ref_title |
varchar |
4000 |
√ |
|
null |
|
|
study_type |
varchar |
4000 |
√ |
|
null |
|
|
common_name |
varchar |
4000 |
√ |
|
null |
|
|
icd10 |
varchar |
4000 |
√ |
|
null |
|
|
mesh |
varchar |
4000 |
√ |
|
null |
|
|
disease_type |
varchar |
4000 |
√ |
|
null |
|
|
physiology_name |
varchar |
4000 |
√ |
|
null |
|
|
trial_status |
varchar |
4000 |
√ |
|
null |
|
|
trial_phase |
varchar |
4000 |
√ |
|
null |
|
|
nature_of_trial |
varchar |
4000 |
√ |
|
null |
|
|
randomization |
varchar |
4000 |
√ |
|
null |
|
|
blinded_trial |
varchar |
4000 |
√ |
|
null |
|
|
trial_type |
varchar |
4000 |
√ |
|
null |
|
|
run_in_period |
varchar |
4000 |
√ |
|
null |
|
|
treatment_period |
varchar |
4000 |
√ |
|
null |
|
|
washout_period |
varchar |
4000 |
√ |
|
null |
|
|
open_label_extension |
varchar |
4000 |
√ |
|
null |
|
|
sponsor |
varchar |
4000 |
√ |
|
null |
|
|
trial_nbr_of_patients_studied |
varchar |
4000 |
√ |
|
null |
|
|
source_type |
varchar |
4000 |
√ |
|
null |
|
|
trial_age |
varchar |
4000 |
√ |
|
null |
|
|
disease_severity |
varchar |
4000 |
√ |
|
null |
|
|
difficult_to_treat |
varchar |
4000 |
√ |
|
null |
|
|
asthma_diagnosis |
varchar |
4000 |
√ |
|
null |
|
|
inhaled_steroid_dose |
varchar |
4000 |
√ |
|
null |
|
|
laba |
varchar |
4000 |
√ |
|
null |
|
|
ocs |
varchar |
4000 |
√ |
|
null |
|
|
xolair |
varchar |
4000 |
√ |
|
null |
|
|
ltra_inhibitors |
varchar |
4000 |
√ |
|
null |
|
|
asthma_phenotype |
varchar |
4000 |
√ |
|
null |
|
|
fev1 |
varchar |
4000 |
√ |
|
null |
|
|
fev1_reversibility |
varchar |
4000 |
√ |
|
null |
|
|
tlc |
varchar |
4000 |
√ |
|
null |
|
|
fev1_fvc |
varchar |
4000 |
√ |
|
null |
|
|
fvc |
varchar |
4000 |
√ |
|
null |
|
|
dlco |
varchar |
4000 |
√ |
|
null |
|
|
sgrq |
varchar |
4000 |
√ |
|
null |
|
|
hrct |
varchar |
4000 |
√ |
|
null |
|
|
biopsy |
varchar |
4000 |
√ |
|
null |
|
|
dyspnea_on_exertion |
varchar |
4000 |
√ |
|
null |
|
|
concomitant_med |
varchar |
4000 |
√ |
|
null |
|
|
trial_smokers_pct |
varchar |
4000 |
√ |
|
null |
|
|
trial_former_smokers_pct |
varchar |
4000 |
√ |
|
null |
|
|
trial_never_smokers_pct |
varchar |
4000 |
√ |
|
null |
|
|
trial_pack_years |
varchar |
4000 |
√ |
|
null |
|
|
exclusion_criteria |
text |
2147483647 |
√ |
|
null |
|
|
minimal_symptoms |
varchar |
4000 |
√ |
|
null |
|
|
rescue_medication_use |
varchar |
4000 |
√ |
|
null |
|
|
control_details |
varchar |
4000 |
√ |
|
null |
|
|
blinding_procedure |
varchar |
4000 |
√ |
|
null |
|
|
number_of_arms |
varchar |
4000 |
√ |
|
null |
|
|
description |
text |
2147483647 |
√ |
|
null |
|
|
arm |
varchar |
4000 |
√ |
|
null |
|
|
arm_nbr_of_patients_studied |
varchar |
4000 |
√ |
|
null |
|
|
arm_classification_type |
varchar |
4000 |
√ |
|
null |
|
|
arm_classification_value |
varchar |
4000 |
√ |
|
null |
|
|
arm_asthma_duration |
varchar |
4000 |
√ |
|
null |
|
|
arm_geographic_region |
varchar |
4000 |
√ |
|
null |
|
|
arm_age |
varchar |
4000 |
√ |
|
null |
|
|
arm_gender |
varchar |
4000 |
√ |
|
null |
|
|
arm_smokers_pct |
varchar |
4000 |
√ |
|
null |
|
|
arm_former_smokers_pct |
varchar |
4000 |
√ |
|
null |
|
|
arm_never_smokers_pct |
varchar |
4000 |
√ |
|
null |
|
|
arm_pack_years |
varchar |
4000 |
√ |
|
null |
|
|
minority_participation |
varchar |
4000 |
√ |
|
null |
|
|
baseline_symptom_score |
varchar |
4000 |
√ |
|
null |
|
|
baseline_rescue_medication_use |
varchar |
4000 |
√ |
|
null |
|
|
clinical_variable |
varchar |
4000 |
√ |
|
null |
|
|
clinical_variable_pct |
varchar |
4000 |
√ |
|
null |
|
|
clinical_variable_value |
varchar |
4000 |
√ |
|
null |
|
|
prior_med_drug_name |
varchar |
4000 |
√ |
|
null |
|
|
prior_med_pct |
varchar |
4000 |
√ |
|
null |
|
|
prior_med_value |
varchar |
4000 |
√ |
|
null |
|
|
biomarker_name |
varchar |
4000 |
√ |
|
null |
|
|
biomarker_pct |
varchar |
4000 |
√ |
|
null |
|
|
biomarker_value |
varchar |
4000 |
√ |
|
null |
|
|
cellinfo_type |
varchar |
4000 |
√ |
|
null |
|
|
cellinfo_count |
varchar |
4000 |
√ |
|
null |
|
|
cellinfo_source |
varchar |
4000 |
√ |
|
null |
|
|
pulmonary_pathology_name |
varchar |
4000 |
√ |
|
null |
|
|
pulmpath_patient_pct |
varchar |
4000 |
√ |
|
null |
|
|
pulmpath_value_unit |
varchar |
4000 |
√ |
|
null |
|
|
pulmpath_method |
varchar |
4000 |
√ |
|
null |
|
|
runin_ocs |
varchar |
4000 |
√ |
|
null |
|
|
runin_ics |
varchar |
4000 |
√ |
|
null |
|
|
runin_laba |
varchar |
4000 |
√ |
|
null |
|
|
runin_ltra |
varchar |
4000 |
√ |
|
null |
|
|
runin_corticosteroids |
varchar |
4000 |
√ |
|
null |
|
|
runin_anti_fibrotics |
varchar |
4000 |
√ |
|
null |
|
|
runin_immunosuppressive |
varchar |
4000 |
√ |
|
null |
|
|
runin_cytotoxic |
varchar |
4000 |
√ |
|
null |
|
|
runin_description |
varchar |
4000 |
√ |
|
null |
|
|
trtmt_ocs |
varchar |
4000 |
√ |
|
null |
|
|
trtmt_ics |
varchar |
4000 |
√ |
|
null |
|
|
trtmt_laba |
varchar |
4000 |
√ |
|
null |
|
|
trtmt_ltra |
varchar |
4000 |
√ |
|
null |
|
|
trtmt_corticosteroids |
varchar |
4000 |
√ |
|
null |
|
|
trtmt_anti_fibrotics |
varchar |
4000 |
√ |
|
null |
|
|
trtmt_immunosuppressive |
varchar |
4000 |
√ |
|
null |
|
|
trtmt_cytotoxic |
varchar |
4000 |
√ |
|
null |
|
|
trtmt_description |
varchar |
4000 |
√ |
|
null |
|
|
drug_inhibitor_common_name |
varchar |
4000 |
√ |
|
null |
|
|
drug_inhibitor_standard_name |
varchar |
4000 |
√ |
|
null |
|
|
drug_inhibitor_cas_id |
varchar |
4000 |
√ |
|
null |
|
|
drug_inhibitor_dose |
varchar |
4000 |
√ |
|
null |
|
|
drug_inhibitor_route_of_admin |
varchar |
4000 |
√ |
|
null |
|
|
drug_inhibitor_trtmt_regime |
varchar |
4000 |
√ |
|
null |
|
|
comparator_name |
varchar |
4000 |
√ |
|
null |
|
|
comparator_dose |
varchar |
4000 |
√ |
|
null |
|
|
comparator_time_period |
varchar |
4000 |
√ |
|
null |
|
|
comparator_route_of_admin |
varchar |
4000 |
√ |
|
null |
|
|
treatment_regime |
varchar |
4000 |
√ |
|
null |
|
|
placebo |
varchar |
4000 |
√ |
|
null |
|
|
experiment_description |
varchar |
4000 |
√ |
|
null |
|
|
primary_endpoint_type |
varchar |
4000 |
√ |
|
null |
|
|
primary_endpoint_definition |
varchar |
4000 |
√ |
|
null |
|
|
primary_endpoint_change |
varchar |
4000 |
√ |
|
null |
|
|
primary_endpoint_time_period |
varchar |
4000 |
√ |
|
null |
|
|
primary_endpoint_stat_test |
varchar |
4000 |
√ |
|
null |
|
|
primary_endpoint_p_value |
varchar |
4000 |
√ |
|
null |
|
|
secondary_type |
varchar |
4000 |
√ |
|
null |
|
|
secondary_type_definition |
varchar |
4000 |
√ |
|
null |
|
|
secondary_type_change |
varchar |
4000 |
√ |
|
null |
|
|
secondary_type_time_period |
varchar |
4000 |
√ |
|
null |
|
|
secondary_type_p_value |
varchar |
4000 |
√ |
|
null |
|
|
secondary_type_stat_test |
varchar |
4000 |
√ |
|
null |
|
|
clinical_variable_name |
varchar |
4000 |
√ |
|
null |
|
|
pct_change_from_baseline |
varchar |
4000 |
√ |
|
null |
|
|
abs_change_from_baseline |
varchar |
4000 |
√ |
|
null |
|
|
rate_of_change_from_baseline |
varchar |
4000 |
√ |
|
null |
|
|
average_over_treatment_period |
varchar |
4000 |
√ |
|
null |
|
|
within_group_changes |
varchar |
4000 |
√ |
|
null |
|
|
stat_measure_p_value |
varchar |
4000 |
√ |
|
null |
|
|
definition_of_the_event |
varchar |
4000 |
√ |
|
null |
|
|
number_of_events |
varchar |
4000 |
√ |
|
null |
|
|
event_rate |
varchar |
4000 |
√ |
|
null |
|
|
time_to_event |
varchar |
4000 |
√ |
|
null |
|
|
event_pct_reduction |
varchar |
4000 |
√ |
|
null |
|
|
event_p_value |
varchar |
4000 |
√ |
|
null |
|
|
event_description |
varchar |
4000 |
√ |
|
null |
|
|
discontinuation_rate |
varchar |
4000 |
√ |
|
null |
|
|
response_rate |
varchar |
4000 |
√ |
|
null |
|
|
downstream_signaling_effects |
varchar |
4000 |
√ |
|
null |
|
|
beneficial_effects |
varchar |
4000 |
√ |
|
null |
|
|
adverse_effects |
varchar |
4000 |
√ |
|
null |
|
|
pk_pd_parameter |
varchar |
4000 |
√ |
|
null |
|
|
pk_pd_value |
varchar |
4000 |
√ |
|
null |
|
|
effect_description |
varchar |
4000 |
√ |
|
null |
|
|
biomolecule_name |
varchar |
4000 |
√ |
|
null |
|
|
biomolecule_id |
varchar |
4000 |
√ |
|
null |
|
|
biomolecule_type |
varchar |
4000 |
√ |
|
null |
|
|
biomarker |
varchar |
4000 |
√ |
|
null |
|
|
biomarker_type |
varchar |
4000 |
√ |
|
null |
|
|
baseline_expr_pct |
varchar |
4000 |
√ |
|
null |
|
|
baseline_expr_number |
varchar |
4000 |
√ |
|
null |
|
|
baseline_expr_value_fold_mean |
varchar |
4000 |
√ |
|
null |
|
|
baseline_expr_sd |
varchar |
4000 |
√ |
|
null |
|
|
baseline_expr_sem |
varchar |
4000 |
√ |
|
null |
|
|
baseline_expr_unit |
varchar |
4000 |
√ |
|
null |
|
|
expr_after_trtmt_pct |
varchar |
4000 |
√ |
|
null |
|
|
expr_after_trtmt_number |
varchar |
4000 |
√ |
|
null |
|
|
expr_aftertrtmt_valuefold_mean |
varchar |
4000 |
√ |
|
null |
|
|
expr_after_trtmt_sd |
varchar |
4000 |
√ |
|
null |
|
|
expr_after_trtmt_sem |
varchar |
4000 |
√ |
|
null |
|
|
expr_after_trtmt_unit |
varchar |
4000 |
√ |
|
null |
|
|
expr_chg_source_type |
varchar |
4000 |
√ |
|
null |
|
|
expr_chg_technique |
varchar |
4000 |
√ |
|
null |
|
|
expr_chg_description |
varchar |
4000 |
√ |
|
null |
|
|
clinical_correlation |
varchar |
4000 |
√ |
|
null |
|
|
statistical_test |
varchar |
4000 |
√ |
|
null |
|
|
statistical_coefficient_value |
varchar |
4000 |
√ |
|
null |
|
|
statistical_test_p_value |
varchar |
4000 |
√ |
|
null |
|
|
statistical_test_description |
varchar |
4000 |
√ |
|
null |
|
|
drug_inhibitor_time_period |
varchar |
4000 |
√ |
|
null |
|
|