Download CSV
Active
Table
Column
Type
Description
CTGov Data Point
Yes
result_agreements
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
result_agreements
pi_employee
boolean
-
Agreement PI Sponsor Employee
Yes
result_agreements
agreement
text
-
-
Yes
result_agreements
restriction_type
character varying
-
Agreement Restriction Type
Yes
result_agreements
other_details
text
-
Agreement Other Details
Yes
result_agreements
restrictive_agreement
boolean
-
Agreement Restrictive Agreement
Yes
result_contacts
id
integer
primary key
-
Yes
result_contacts
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
result_contacts
organization
character varying
-
Point Of Contact Organization
Yes
result_contacts
name
character varying
-
Point Of Contact Title
Yes
result_contacts
phone
character varying
-
Point Of Contact Phone
Yes
result_contacts
email
character varying
-
Point Of ContactE Mail
Yes
result_contacts
extension
character varying
-
Point Of Contact Phone Ext
Yes
result_groups
id
integer
primary key
-
Yes
result_groups
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
result_groups
ctgov_group_code
character varying
-
Outcome Group Id
Yes
result_groups
result_type
character varying
-
-
Yes
result_groups
title
character varying
-
Outcome Group Title
Yes
result_groups
description
text
-
Outcome Group Description
Yes
result_groups
outcome_id
integer
-
-

Connect
Download
Learn
Shared Data