Yes
browse_interventions
character varying
-
Intervention Ancestor Term
Yes
browse_interventions
character varying
-
-
Yes
calculated_values
integer
primary key
-
Yes
calculated_values
character varying
ClinicalTrials.gov identifier (NCT number) for the study; links this row to the studies table.
-
Yes
calculated_values
integer
Number of locations (facilities) where the study is conducted, based on the facilities table.
-
Yes
calculated_values
integer
Sum of affected participants across all non-serious adverse events reported for the study.
-
Yes
calculated_values
integer
Sum of affected participants across all serious adverse events reported for the study.
-
Yes
calculated_values
integer
Calendar year the study was first registered on ClinicalTrials.gov.
-
Yes
calculated_values
date
-
-
Yes
calculated_values
integer
Number of full months from the study start date to its primary completion date. Set only when both dates are actual rather than estimated; otherwise empty.
-
Yes
calculated_values
boolean
True when the study has posted results (it has at least one outcome record), false otherwise.
-
Yes
calculated_values
integer
Number of full months between the study's primary completion date and the date its results were first submitted to ClinicalTrials.gov.
-
Yes
calculated_values
boolean
True when at least one study location is in the United States or a U.S. territory. Empty when the study has no recorded locations.
-
Yes
calculated_values
boolean
True when the study runs at exactly one facility. Empty when the study has no recorded locations.
-
Yes
calculated_values
integer
Minimum eligible age for study participants, as a number. The unit is in minimum_age_unit.
-
Yes
calculated_values
integer
Maximum eligible age for study participants, as a number. The unit is in maximum_age_unit.
-
Yes
calculated_values
character varying
Unit for the minimum eligible age (e.g. year, month). Pairs with minimum_age_num.
-
Yes
calculated_values
character varying
Unit for the maximum eligible age (e.g. year, month). Pairs with maximum_age_num.
-
Yes
calculated_values
integer
Number of primary outcome measures defined for the study, from the design_outcomes table.
-
Yes
calculated_values
integer
Number of secondary outcome measures defined for the study, from the design_outcomes table.
-