AACT Database | Clinical Trials Transformation Initiative

Download CSV

Active

Table

Column

Type

Description

CTGov Data Point

Yes

retractions

id

bigint

primary key

-

Yes

retractions

reference_id

integer

-

-

Yes

retractions

pmid

character varying

-

Retraction PMID

Yes

retractions

source

character varying

-

Retraction Source

Yes

retractions

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

search_results

id

integer

primary key

-

Yes

search_results

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

search_results

name

character varying

-

-

Yes

search_results

created_at

timestamp without time zone

-

-

Yes

search_results

updated_at

timestamp without time zone

-

-

Yes

search_results

grouping

character varying

-

-

Yes

search_results

study_search_id

integer

-

-

Yes

search_term_results

id

bigint

primary key

-

Yes

search_term_results

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

search_term_results

search_term_id

bigint

-

-

Yes

search_term_results

created_at

timestamp without time zone

-

-

Yes

search_term_results

updated_at

timestamp without time zone

-

-

Yes

search_terms

id

bigint

primary key

-

Yes

search_terms

term

character varying

-

-

Yes

search_terms

group

character varying

-

-