Download CSV
Active
Table
Column
Type
Description
CTGov Data Point
Yes
facilities
id
integer
primary key
-
Yes
facilities
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
facilities
status
character varying
-
Location Status
Yes
facilities
name
character varying
-
Location Facility
Yes
facilities
city
character varying
-
Location City
Yes
facilities
state
character varying
-
Location State
Yes
facilities
zip
character varying
-
Location Zip
Yes
facilities
country
character varying
-
Location Country
Yes
facilities
latitude
numeric
-
-
Yes
facilities
longitude
numeric
-
-
Yes
facility_contacts
id
integer
primary key
-
Yes
facility_contacts
nct_id
character varying
foreign key referencing studies.nct_id
-
Yes
facility_contacts
facility_id
integer
-
-
Yes
facility_contacts
contact_type
character varying
-
-
Yes
facility_contacts
name
character varying
-
Location Contact Name
Yes
facility_contacts
email
character varying
-
Location ContactE Mail
Yes
facility_contacts
phone
character varying
-
Location Contact Phone
Yes
facility_contacts
phone_extension
character varying
-
Location Contact Phone Ext
Yes
facility_investigators
id
integer
primary key
-
Yes
facility_investigators
nct_id
character varying
foreign key referencing studies.nct_id
-

Connect
Download
Learn
Shared Data