AACT Database | Clinical Trials Transformation Initiative

Download CSV

Active

Table

Column

Type

Description

CTGov Data Point

Yes

baseline_measurements

dispersion_value

character varying

-

Baseline Measurement Spread

Yes

baseline_measurements

dispersion_value_num

numeric

-

Baseline Measurement Spread

Yes

baseline_measurements

dispersion_lower_limit

numeric

-

Baseline Measurement Lower Limit

Yes

baseline_measurements

dispersion_upper_limit

numeric

-

Baseline Measurement Upper Limit

Yes

baseline_measurements

explanation_of_na

character varying

-

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

-

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

-

Condition Ancestor Term

Yes

browse_conditions

downcase_mesh_term

character varying

-

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

-

Intervention Ancestor Term