AACT Database | Clinical Trials Transformation Initiative

Download CSV

Active

Table

Column

Type

Description

CTGov Data Point

Yes

provided_documents

has_protocol

boolean

Indicate if document includes Study Protocol (Yes/No)

Large Doc Has Protocol

Yes

provided_documents

has_icf

boolean

Indicate if document includes Informed Consent Form (Yes/No)

Large Doc Has ICF

Yes

provided_documents

has_sap

boolean

Indicate if document includes Statistical Analysis Plan (Yes/No)

Large Doc Has SAP

Yes

provided_documents

document_date

date

Large Doc Date

Yes

provided_documents

url

character varying

Document file name (by data provider)

Large Doc Filename

Yes

reported_event_totals

integer

primary key

Yes

reported_event_totals

nct_id

character varying

foreign key referencing studies.nct_id

Yes

reported_event_totals

ctgov_group_code

character varying

Internal group id

Event Group Id

Yes

reported_event_totals

event_type

character varying

Yes

reported_event_totals

classification

character varying

Yes

reported_event_totals

subjects_affected

integer

Event Group Deaths Num Affected

Yes

reported_event_totals

subjects_at_risk

integer

Event Group Deaths Num At Risk

Yes

reported_event_totals

created_at

timestamp without time zone

Yes

reported_event_totals

updated_at

timestamp without time zone

Yes

reported_events

integer

primary key

Yes

reported_events

nct_id

character varying

foreign key referencing studies.nct_id

Yes

reported_events

result_group_id

integer

Yes

reported_events

ctgov_group_code

character varying

Internal Arm/Group ID

Other Event Stats Group Id

Yes

reported_events

time_frame

text

Events Time Frame

Yes

reported_events

event_type

character varying