Active
Table
Column
Type
Description
CTGov Data Point
Yes
baseline_measurements
dispersion_value
character varying
Data per Arm/Group per Category. Based on Measure Type and Measure of Dispersion (e.g., Standard Deviation)
Baseline Measurement Spread
Yes
baseline_measurements
dispersion_value_num
numeric
Data per Arm/Group per Category. Based on Measure Type and Measure of Dispersion (e.g., Standard Deviation)
Baseline Measurement Spread
Yes
baseline_measurements
dispersion_lower_limit
numeric
Data per Arm/Group per Category. Based on Measure Type and Measure of Dispersion (e.g., lower limit of Full Range)
Baseline Measurement Lower Limit
Yes
baseline_measurements
dispersion_upper_limit
numeric
Data per Arm/Group per Category. Based on Measure Type and Measure of Dispersion (e.g., upper limit of Full Range)
Baseline Measurement Upper Limit
Yes
baseline_measurements
explanation_of_na
character varying
Explain why baseline measure data are not available, if "NA" is reported for Baseline Measure Data.
Baseline Measurement Comment
Yes
baseline_measurements
number_analyzed
integer
-
-
Yes
baseline_measurements
number_analyzed_units
character varying
-
Baseline Measure Denom Units Selected
Yes
baseline_measurements
population_description
character varying
-
Baseline Measure Population Description
Yes
baseline_measurements
calculate_percentage
character varying
percentage of BaselineMeasurementValue/BaselineMeasureDenomCountValue
Baseline Measure Calculate Pct
Yes
brief_summaries
id
integer
primary key
-
Yes
brief_summaries
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
brief_summaries
description
text
-
Brief Summary
Yes
browse_conditions
id
integer
primary key
-
Yes
browse_conditions
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
browse_conditions
mesh_term
character varying
MeSH Heading
Condition Ancestor Term
Yes
browse_conditions
downcase_mesh_term
character varying
MeSH Heading
Condition Ancestor Term
Yes
browse_conditions
mesh_type
character varying
-
-
Yes
browse_interventions
id
integer
primary key
-
Yes
browse_interventions
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
browse_interventions
mesh_term
character varying
MeSH Heading
Intervention Ancestor Term