AACT Database | Clinical Trials Transformation Initiative

Download CSV

Active

Table

Column

Type

Description

CTGov Data Point

Yes

calculated_values

number_of_other_outcomes_to_measure

integer

-

-

Yes

central_contacts

id

integer

primary key

-

Yes

central_contacts

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

central_contacts

contact_type

character varying

-

-

Yes

central_contacts

name

character varying

-

Central Contact Name

Yes

central_contacts

phone

character varying

-

Central Contact Phone

Yes

central_contacts

email

character varying

-

Central ContactE Mail

Yes

central_contacts

phone_extension

character varying

-

Central Contact Phone Ext

Yes

central_contacts

role

character varying

-

Central Contact Role

Yes

conditions

id

integer

primary key

-

Yes

conditions

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

conditions

name

character varying

-

-

Yes

conditions

downcase_name

character varying

-

-

Yes

countries

id

integer

primary key

-

Yes

countries

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

countries

name

character varying

-

-

Yes

countries

removed

boolean

-

-

Yes

design_group_interventions

id

integer

primary key

-

Yes

design_group_interventions

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

design_group_interventions

design_group_id

integer

-

-