AACT Database | Clinical Trials Transformation Initiative

Download CSV

Active

Table

Column

Type

Description

CTGov Data Point

Yes

provided_documents

has_protocol

boolean

-

Large Doc Has Protocol

Yes

provided_documents

has_icf

boolean

-

Large Doc Has ICF

Yes

provided_documents

has_sap

boolean

-

Large Doc Has SAP

Yes

provided_documents

document_date

date

-

Large Doc Date

Yes

provided_documents

url

character varying

-

Large Doc Filename

Yes

reported_event_totals

id

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

-

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

id

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

-

Other Event Stats Group Id

Yes

reported_events

time_frame

text

-

Events Time Frame

Yes

reported_events

event_type

character varying

-

-