AACT Database | Clinical Trials Transformation Initiative

Download CSV

Active

Table

Column

Type

Description

CTGov Data Point

Yes

study_records

type

character varying

-

-

Yes

study_records

content

json

-

-

Yes

study_records

sha

character varying

-

-

Yes

study_records

created_at

timestamp without time zone

-

-

Yes

study_records

updated_at

timestamp without time zone

-

-

Yes

study_references

id

integer

primary key

-

Yes

study_references

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

study_references

pmid

character varying

-

Reference PMID

Yes

study_references

reference_type

character varying

-

Reference Type

Yes

study_references

citation

text

-

Reference Citation

Yes

study_searches

id

integer

primary key

-

Yes

study_searches

save_tsv

boolean

-

-

Yes

study_searches

query

character varying

-

-

Yes

study_searches

grouping

character varying

-

-

Yes

study_searches

name

character varying

-

-

Yes

study_searches

beta_api

boolean

-

-

Yes

study_searches

created_at

timestamp without time zone

-

-

Yes

study_searches

updated_at

timestamp without time zone

-

-

Yes

study_searches

active

boolean

-

-