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

Sponsor organization type: Type of lead sponsor

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

The date on which the study sponsor or investigator first submitted a study record to ClinicalTrials.gov. There is typically a delay of a few days between the first submitted date and the record's availability on ClinicalTrials.gov (the first posted date).

Study First Submit Date

Yes

studies

results_first_submitted_date

date

The date on which the study sponsor or investigator first submits a study record with summary results information. There is typically a delay between the results first submitted date and when summary results information becomes available on ClinicalTrials.gov (the results first posted date).

Results First Submit Date

Yes

studies

disposition_first_submitted_date

date

The date on which the study sponsor or investigator first submitted a certification or an extension request to delay submission of results. A sponsor or investigator who submits a certification can delay results submission up to 2 years after this date, unless certain events occur sooner. There is typically a delay between the date the certification or extension request was submitted and the date the information is first available on ClinicalTrials.gov (certification/extension first posted).

Disp First Submit Date

Yes

studies

last_update_submitted_date

date

The most recent date on which the study sponsor or investigator submitted changes to a study record to ClinicalTrials.gov. There is typically a delay of a few days between the last update submitted date and when the date changes are posted on ClinicalTrials.gov (the last update posted date).

Last Update Submit Date

Yes

studies

study_first_submitted_qc_date

date

The date on which the study sponsor or investigator first submits a study record that is consistent with National Library of Medicine (NLM) quality control (QC) review criteria. The sponsor or investigator may need to revise and submit a study record one or more times before NLM's QC review criteria are met. It is the responsibility of the sponsor or investigator to ensure that the study record is consistent with the NLM QC review criteria.

Study First Submit QC Date

Yes

studies

study_first_posted_date

date

The date on which the study record was first available on ClinicalTrials.gov after National Library of Medicine (NLM) quality control (QC) review has concluded. There is typically a delay of a few days between the date the study sponsor or investigator submitted the study record and the first posted 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

The date on which the study sponsor or investigator first submits a study record with summary results information that is consistent with National Library of Medicine (NLM) quality control (QC) review criteria. The sponsor or investigator may need to revise and submit results information one or more times before NLM's QC review criteria are met. It is the responsibility of the sponsor or investigator to ensure that the study record is consistent with the NLM QC review criteria.

Results First Submit QC Date

Yes

studies

results_first_posted_date

date

The date on which summary results information was first available on ClinicalTrials.gov after National Library of Medicine (NLM) quality control (QC) review has concluded. There is typically a delay between the date the study sponsor or investigator first submits summary results information (the results first submitted date) and the results first posted date. Some results information may be available at an earlier date if Results First Posted with QC Comments.

Results First Post Date

Yes

studies

results_first_posted_date_type

character varying

Results first posted date type. Due to historical reasons, some studies have date type "Estimate"

Results First Post Date Type

Yes

studies

disposition_first_submitted_qc_date

date

Certification/extension first submitted that met QC criteria

Disp First Submit QC Date