Active
Table
Column
Type
Description
CTGov Data Point
Yes
search_terms
created_at
timestamp without time zone
-
-
Yes
search_terms
updated_at
timestamp without time zone
-
-
Yes
sponsors
id
integer
primary key
-
Yes
sponsors
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
sponsors
agency_class
character varying
-
Collaborator Class
Yes
sponsors
lead_or_collaborator
character varying
-
-
Yes
sponsors
name
character varying
-
Collaborator Name
Yes
studies
nct_id
character varying
foreign key referencing studies.nct_id
-
No
studies
nlm_download_date_description
character varying
deprecated field, no longer in use
-
Yes
studies
study_first_submitted_date
date
-
Study First Submit Date
Yes
studies
results_first_submitted_date
date
-
Results First Submit Date
Yes
studies
disposition_first_submitted_date
date
-
Disp First Submit Date
Yes
studies
last_update_submitted_date
date
-
Last Update Submit Date
Yes
studies
study_first_submitted_qc_date
date
-
Study First Submit QC Date
Yes
studies
study_first_posted_date
date
-
Study First Post Date
Yes
studies
study_first_posted_date_type
character varying
-
Study First Post Date Type
Yes
studies
results_first_submitted_qc_date
date
-
Results First Submit QC Date
Yes
studies
results_first_posted_date
date
-
Results First Post Date
Yes
studies
results_first_posted_date_type
character varying
-
Results First Post Date Type
Yes
studies
disposition_first_submitted_qc_date
date
-
Disp First Submit QC Date