Logo

Introduction

Trial Tap provides clinical trials data on tap, literally. This tap currently provides clean and normalized data from clinicaltrials.gov, although we plan on expanding the list of registries over time. Having spent a significant amount of time working with clinical trials data as healthcare consultants, we thought we'd do some of the leg work for you, so you can more easily analyze this data.

We care a great deal about protecting patient safety and providing the highest-quality data we can. While we try our best to stick to the guidlines and provide error-free data, we are human and make mistakes. Please email us with any questions/concerns. Please also note that we follow the clinicaltrials.gov terms of service, and you must as well. There are a few stipulations to working with the data, and you implicitly agree to them if you end up using data from this site.

Per the terms, here are some details on the data set at a global level:

  • -The source of the data is from clinicaltrials.gov
  • -The data is current as of 2018-07-20
  • -Each line item in the clinical_study table contains the date the data was processed by ClinicalTrials.gov
  • -We have made few direct changes to the data, however, we do remove line breaks from the eligibility criteria and reformat all dates.
  • -This data is tapped frequently (e.g. we grab the data daily for new and updated studies).
  • Explorer

    This section will be used to help you explore the data. We hope this will provide further clarification on the contents of each field and our interpretation of the field, as we understand it.

    clinical_studies

    This is the central table in the data set. All elements in the data set map back to the National Clinical Trial (NCT) number in a 1-to-1 fashion. The primary / foreign key in this data set is the NCT_ID, which can be joined to any table in this data set.

    Here is an example data set.

    Data Dictionary for clinical_studies
    Trial Tap Id for Clinical Studies (id) This is the unique identifier for the trial tap clinical studies table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Alternate NCT_ID (nct_alias) The NCT_alias contains alternate NCT_ID numbers. Studies were formerly associated with these IDs at one time.
    Download (download_date) Date of download from NLM
    clinicaltrials.gov link (link_text) Descriptive link to record.
    URL (url) A Web site directly relevant to the protocol may be entered, if desired. Do not include sites whose primary goal is to advertise or sell commercial products or services. Links to educational, research, government, and other non-profit Web pages are acceptable. All submitted links are subject to review by ClinicalTrials.gov. complete URL, including http:// (Limit: 254 characters)
    Organization's Unique Protocol id (org_study_id) Unique identification assigned to the protocol by the sponsoring organization, usually an accession number or a variation of a grant number. Multiple studies conducted under the same grant must each have a unique number. (Limit: 30 characters)
    Secondary ids (secondary_id) Other identification numbers assigned to the protocol, including unique identifiers from other registries and NIH grant numbers, if applicable. (Limit: 30 characters)
    Lead Sponsor Agency (lead_sponsor_agency) Lead Sponsor
    Lead Sponsor Agency Class (lead_sponsor_agency_class) Class of lead sponsor agency
    Collaborator Agency (collaborator_agency) Collaborator
    Collaborator Agency Class (collaborator_agency_class) Class of lead collaborator agency
    Data Monitoring Committee? (has_dmc) Indicate whether a data monitoring committee has been appointed for this study. The data monitoring committee (board) is a group of independent scientists who are appointed to monitor the safety and scientific integrity of a human research intervention, and to make recommendations to the sponsor regarding the stopping of the trial for efficacy, for harms or for futility. The composition of the committee is dependent upon the scientific skills and knowledge required for monitoring the particular study.
    Is FDA Regulated Drug? (is_fda_regulated_drug) Does this trial involve an FDA-Regulated Drug?
    Is FDA Regulated Device? (is_fda_regulated_device) Does this trial involve an FDA-Regulated Device?
    Is Unapproved Device? (is_unapproved_device) Does this trial involve an Unapproved Device?
    Is PPSD? (is_ppsd)
    Is US Export? (is_us_export) Does this trial involve a product that exported out of the US?
    Brief Title (brief_title) Protocol title intended for the lay public. (Limit: 300 characters)
    Acronym (acronym) Acronym or initials used to identify this study, if applicable. Enter only the acronym. If supplied, the acronym is automatically displayed in parentheses following the brief title. (Limit: 14 characters)
    Official Title (official_title) Official name of the protocol provided by the study principal investigator or sponsor. (Limit: 600 characters)
    Source (source) Similar to Lead sponsor, but may indicate who the data was submitted on behalf of, or a subsidiary of the sponsor.
    Brief Summary (brief_summary) Short description of the protocol intended for the lay public. Include a brief statement of the study hypothesis. (Limit: 5000 characters)
    Detailed Description (detailed_description) Extended description of the protocol, including more technical information (as compared to the Brief Summary) if desired. Do not include the entire protocol; do not duplicate information recorded in other data elements, such as eligibility criteria or outcome measures. (Limit: 32,000 characters)
    Overall Recruitment Status (overall_status) Overall accrual activity for the protocol.
    Last Known Status (last_known_status) Last time the clinical trial was verfied in the Protocol Registration System
    Why Study Stopped (why_stopped) For suspended, terminated or withdrawn studies, provide a brief explanation of why the study has been halted or terminated. If desired, use brief summary or detailed description to provide additional information. (Limit: 160 characters)
    Study Start Date (start_date) Date that enrollment to the protocol begins.
    Study Completion Date (completion_date) Final date on which data was (or is expected to be) collected. Use the Type menu (Anticipated/Actual).
    Study Completion Date Type (completion_date_type) A "Type" menu is also included, with options Anticipated and Actual. For active studies, set Type to Anticipated and specify the expected completion date, updating the date as needed over the course of the study. Upon study completion, change Type to Actual and update the date if necessary.
    Primary Completion Date (primary_completion_date) As specified in US Public Law 110-85, Title VIII, Section 801, with respect to an applicable clinical trial, the date that the final subject was examined or received an intervention for the purposes of final collection of data for the primary outcome, whether the clinical trial concluded according to the prespecified protocol or was terminated. A "Type" menu is also included, with options Anticipated and Actual. For active studies, set Type to Anticipated and specify the expected completion date, updating the date as needed over the course of the study. Upon study completion, change Type to Actual and update the date if necessary.
    Primary Completion Date Type (primary_completion_date_type) A "Type" menu is also included, with options Anticipated and Actual. For active studies, set Type to Anticipated and specify the expected completion date, updating the date as needed over the course of the study. Upon study completion, change Type to Actual and update the date if necessary.
    Study Phase (phase) Phase of investigation, as defined by the US FDA for trials involving investigational new drugs
    Study Type (study_type) * Interventional: studies in human beings in which individuals are assigned by an investigator based on a protocol to receive specific interventions. Subjects may receive diagnostic, therapeutic or other types of interventions. The assignment of the intervention may or may not be random. The individuals are then followed and biomedical and/or health outcomes are assessed. * Observational: studies in human beings in which biomedical and/or health outcomes are assessed in pre-defined groups of individuals. Subjects in the study may receive diagnostic, therapeutic, or other interventions, but the investigator does not assign specific interventions to the subjects of the study. * Expanded Access: records describing the procedure for obtaining an experimental drug or device for patients who are not adequately treated by existing therapy, who do not meet the eligibility criteria for enrollment, or who are otherwise unable to participate in a controlled clinical study. Expanded Access records are used to register all types of non- protocol access to experimental treatments, including protocol exception, single-patient
    Has Expanded Access? (has_expanded_access) Indicate whether any non-protocol access is to be provided for the investigational drug or device. If so, an Expanded Access record should also be created for this IND/IDE.
    Expanded Access Info (expanded_access_info) Expanded Access Info
    Expanded Access Individual Type (expanded_access_type_individual) Expanded Access Individual Type
    Expanded Access Intermediate Type (expanded_access_type_intermediate) Expanded Access Intermediate Type
    Expanded Access Treatment Type (expanded_access_type_treatment) Expanded Access Treatment Type
    Target Duration (target_duration) Target Duration of trial
    Number of Arms (number_of_arms) Number of intervention groups (enter 1 for single-arm study).
    Number of Groups (number_of_groups) Number of study groups/cohorts. Enter 1 for a single-group study. Many observational studies have one group/cohort; case control studies typically have two.
    Enrollment (enrollment) Target or Actual Number of Subjects. Number of subjects in the trial.
    Enrollment Type (enrollment_type) A "Type" menu is also included, with options Anticipated and Actual. For active studies, set Type to Anticipated and specify the expected enrollment, updating the number as needed over the course of the study. Upon study completion, change Type to Actual and update the enrollment if necessary.
    Record Verification Date (verification_date) Date the protocol information was last verified. Verification date is shown along with organization name on ClinicalTrials.gov to indicate to the public whether the information is being kept current, particularly recruiting status and contact information. Update verification date when reviewing the record for accuracy and completeness, even if no other changes are made.
    Last Changed Date (lastchanged_date) Date of last entry change.
    First Received Date (firstreceived_date) Date of data first available to public (approximate)
    First Received Results Date (firstreceived_results_date) This tag is available only of those studies that have results and indicates the date when the results were first received.
    First Received Results Disposition Date (firstreceived_results_disposition_date) First disposed date the trial results were received by clinicaltrials.gov from sponsor
    Responsible Party Type (responsible_party_type) Type of Sponsor
    Responsible Party Investigator Affiliation (responsible_party_investigator_affiliation) Affiliation of responsible party
    Responsible Party Investigator Full Name (responsible_party_investigator_full_name) Full name of responsible party
    Responsible Party Investigator Type (responsible_party_investigator_title) Investigator responsible party type
    Sharing IPD? (sharing_ipd) Will the sponsor share individual participant data collected in this study, including data dictionaries, available to other researchers (typically after the end of the study).
    IPD Description? (ipd_description) Description of the IPD and data elements to be shared.
    Overall Contact Last Name (overall_contact_last_name) Last name of person(s) responsible for the overall scientific leadership of the protocol including study principal investigator.
    Overall Contact First Name (overall_contact_first_name) First name of person(s) responsible for the overall scientific leadership of the protocol including study principal investigator.
    Overall Contact Phone (overall_contact_phone) Phone number of person(s) responsible for the overall scientific leadership of the protocol including study principal investigator.
    Overall Contact Email (overall_contact_email) Email of person(s) responsible for the overall scientific leadership of the protocol including study principal investigator.
    Allocation (allocation) Allocation
    Intervention Model (intervention_model) Intervention Model
    Intervention Model Description (intervention_model_description) Intervention Model Description
    Primary Purpose (primary_purpose) Primary Purpose
    Masking (masking) Masking
    Masking Description (masking_description) Masking Description
    Eligibility Criteria (eligibility_textblock) Eligibility Criteria
    Gender (gender) Physical gender of individuals who may participate in the protocol.
    Gender Based (gender_based) Gender Based
    Gender Description (gender_description) Gender Description
    Minimum Age (minimum_age) Minimum age of participants. Provide a number and select a unit of time (years, months, weeks, days, hours or minutes). Select "N/A (No limit)" if no minimum age is indicated.
    Maximum Age (maximum_age) Maximum age of participants. Provide a number and a unit of time (years, months, weeks, days, hours or minutes). Select "N/A (No limit)" if no maximum age is indicated.
    Study Population Description (study_pop) For observational studies only, a description of the population from which the groups or cohorts will be selected (e.g., primary care clinic, community sample, residents of a certain town). (Limit: 1000 characters)
    Sampling Method (sampling_method) For observational studies only, select one and explain in Detailed Description.
    Accepts Healthy Volunteers? (healthy_volunteers) Indicate if persons who have not had the condition(s) being studied or otherwise related conditions or symptoms, as specified in the eligibility requirements, may participate in the study.
    Trial Tap Created Date for Clinical Studies (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Clinical Studies (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    publications

    This is a 1-to-many table containing all associated publications listed on the study.

    Here is an example data set.

    Data Dictionary for publications
    Trial Tap Id for Publications (id) This is the unique identifier for the publications table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Publications (pub_index) This is the unique line item number for each NCT ID of record.
    Publication Citation (pub_citation) Publication Citation
    Publication PubMed Id (pub_pmid) Publication PubMed Id
    Publicaton Name and Title (pub_name_title) Publicaton Name and Title
    Publication Organization (pub_organization) Publication Organization
    Trial Tap Created Date for Publications (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Publications (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    secondary_ids

    This is a 1-to-many table containing all the secondary ids for the study.

    Here is an example data set.

    Data Dictionary for secondary_ids
    Trial Tap Id for Secondary Ids (id) This is the unique identifier for the trial tap secondary ids table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Secondary Ids (sec_index) This is the unique line item number for each NCT ID of record.
    Secondary ids (secondary_id) Other identification numbers assigned to the protocol, including unique identifiers from other registries and NIH grant numbers, if applicable. (Limit: 30 characters)
    Trial Tap Created Date for Secondary Ids (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Secondary Ids (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    primary_oms

    This is a 1-to-many table containing all the primary outcome measures for the study.

    Here is an example data set.

    Data Dictionary for primary_oms
    Trial Tap Id for Primary Outcome Measures (id) This is the unique identifier for the trial tap primary outcome measures table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Primary Outcome Measures (pom_index) This is the unique line item number for each NCT ID of record.
    Primary Outcome Measure (p_measure) Primary Outcome Measure
    Primary Outcome Measure Description (p_description) Primary Outcome Measure Description
    Primary Outcome Measure Safety Issue (p_safety_issue) Primary Outcome Measure Safety Issue
    Trial Tap Created Date for Primary Outcome Measures (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Primary Outcome Measures (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    secondary_oms

    This is a 1-to-many table containing all the secondary outcome measures for the study.

    Here is an example data set.

    Data Dictionary for secondary_oms
    Trial Tap Id for Secondary Outcome Measures (id) This is the unique identifier for the trial tap secondary outcome measures table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Secondary Outcome Measures (som_index) This is the unique line item number for each NCT ID of record.
    Secondary Outcome Measure (s_measure) Secondary Outcome Measure
    Secondary Outcome Measure Description (s_description) Secondary Outcome Measure Description
    Secondary Outcome Measure Safety Issue (s_safety_issue) Secondary Outcome Measure Safety Issue
    Trial Tap Created Date for Secondary Outcome Measure (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Secondary Outcome Measure (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    officials

    This is a 1-to-many table containing overall contact information for the principal investigator.

    Here is an example data set.

    Data Dictionary for officials
    Trial Tap Id for Officials (id) This is the unique identifier for the trial tap officials table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Officials (off_index) This is the unique line item for each NCT ID of record.
    Overall Official Last Name (overall_official_last_name) Last name of person(s) responsible for the overall scientific leadership of the protocol, including study principal investigator.
    Overall Official Middle Name (overall_official_middle_name) Overall Official Middle Name
    Overall Official Degree (overall_official_degrees) Overall Official Degree
    Overall Official Phone (overall_official_phone) Overall Official Phone
    Overall Official Phone Ext (overall_official_phone_ext) Overall Official Phone Ext
    Overall Official Email (overall_official_email) Overall Official Email
    Overall Official Affiliation (overall_official_affiliation) Full name of the overall study official's organization.
    Overall Official Role (overall_official_role) Position or function of the official responsible for the overall scientific leadership of the protocol. Select one of the following: Study Chair; Study Director; Study Principal Investigator.
    Trial Tap Created Date for Officials (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Officials (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    arms

    This is a 1-to-many table containing all the arms for the study.

    Here is an example data set.

    Data Dictionary for arms
    Trial Tap Id for Arms (id) This is the unique identifier for the trial tap arms table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Arms (arm_index) This is the unique line item number for each NCT ID of record.
    Arm or Group Label (arm_group_label) Arm Label - the short name used to identify the arm. (Limit: 62 characters). * (FDAAA) Group/Cohort Label - the short name used to identify the group. (Limit: 62 characters) *
    Arm Type (arm_group_type) Arm Type (Experimental, Active Comparator, Placebo Comparator, Sham Comparator, No intervention, Other)
    Arm Group Description (arm_group_description) For arms, a brief description of the arm. For groups, explanation of the nature of the study group.
    Trial Tap Created Date for Arms (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Arms (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    conditions

    This is a 1-to-many table containing all the conditions for the study.

    Here is an example data set.

    Data Dictionary for conditions
    Trial Tap Id for Conditions (id) This is the unique identifier for the trial tap conditions table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Conditions (con_index) This is the unique line item number for each NCT ID of record.
    Condition (condition) Primary disease or condition being studied, or focus of the study. Diseases or conditions should use the National Library of Medicine's Medical Subject Headings (MeSH) controlled vocabulary when possible.
    Trial Tap Created Date for Conditions (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Conditions (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    interventions

    This is a 1-to-many table containing all the interventions for the study.

    Here is an example data set.

    Data Dictionary for interventions
    Trial Tap Id for Interventions (id) This is the unique identifier for the trial tap interventions table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Interventions (int_index) This is the unique line item number for each NCT ID of record.
    Intervention Name (intervention_name) For drugs use generic name; for other types of interventions provide a brief descriptive name. (Limit: 160 characters) For investigational new drugs that do not yet have a generic name, a chemical name, company code or serial number may be used on a temporary basis. As soon as the generic name has been established, update the associated protocol records accordingly. For non-drug intervention types, provide an intervention name with sufficient detail so that it can be distinguished from other similar interventions.
    Intervention Type (intervention_type) Type of intervention: Drug (including placebo), Device (including sham), Biological/Vaccine, Procedure/Surgery, Radiation, Behavioral (e.g., Psychotherapy, Lifestyle Counseling), Genetic (including gene transfer, stem cell and recombinant DNA), Dietary Supplement (e.g., vitamins, minerals), Other
    Other Names (other_name) list other names used to identify the intervention, past or present (e.g., brand name for a drug). These names will be used to improve search results in ClinicalTrials.gov. (Limit: 160 characters per name)
    Trial Tap Created Date for Interventions (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Interventions (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    intervention_browses

    This is a 1-to-many table containing all the intervention MeSH terms for the study.

    Here is an example data set.

    Data Dictionary for intervention_browses
    Trial Tap Id for Intervention Browse (id) This is the unique identifier for the trial tap intervention browses table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Intervention Browse (int_bro_index) This is the unique line item number for each NCT ID of record.
    Intervention Browse Term (intervention_browse)
    Trial Tap Created Date for Intervention Browse (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Intervention Browse (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    condition_browses

    This is a 1-to-many table containing all the condition MeSH terms for the study.

    Here is an example data set.

    Data Dictionary for condition_browses
    Trial Tap Id for Condition Browse (id) This is the unique identifier for the trial tap condition browses table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Condition Browse (con_bro_index) This is the unique line item number for each NCT ID of record.
    Condition Browse Term (condition_browse) Condition Browse Term
    Trial Tap Created Date for Condition Browse (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Condition Browse (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    facilities

    This is a 1-to-many table containing all of the facilities. Please note that if a study is not currently recruiting, locations and contact information will be hidden and/or removed.

    Here is an example data set.

    Data Dictionary for facilities
    Trial Tap Id for Facilities (id) This is the unique identifier for the trial tap facilities table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Facilities (fac_index) This is the unique line item number for each NCT ID of record.
    Facility Name (facility_name) Facility Name
    Facility Status (facility_status) Facility Status
    Facility City (facility_city) Facility City
    Facility Zip (facility_zip) Facility Zip
    Facility State (facility_state) Facility State
    Facility Country (facility_country) Facility Country
    Facility Contact Last Name (facility_contact_last_name) Facility Contact Last Name
    Facility Contact Phone (facility_contact_phone) Facility Contact Phone
    Facility Contact Email (facility_contact_email) Facility Contact Email
    Trial Tap Created Date for Facilities (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Facilities (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    keywords

    This is a 1-to-many table containing all the keywords for the study.

    Here is an example data set.

    Data Dictionary for keywords
    Trial Tap Id for Keywords (id) This is the unique identifier for the trial tap keywords table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Keywords (key_index) This is the unique line item number for each NCT ID of record.
    Keywords (keyword) Words or phrases that best describe the protocol. Keywords help users find studies in the database. Use NLM's Medical Subject Heading (MeSH) controlled vocabulary terms where appropriate. Be as specific and precise as possible. Avoid acronyms and
    Trial Tap Created Date for Keywords (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Keywords (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    location_countries

    This is a 1-to-many table containing all the location countries for the study.

    Here is an example data set.

    Data Dictionary for location_countries
    Trial Tap Id for Location Countries (id) This is the unique identifier for the trial tap location countries table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Location Countries (loc_con_index) This is the unique line item number for each NCT ID of record.
    Location Countries (location_countries) Countries added to the trial.
    Trial Tap Created Date for Location Countries (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Location Countries (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.

    location_country_removes

    This is a 1-to-many table containing all the removed location countries for the study.

    Here is an example data set.

    Data Dictionary for location_country_removes
    Trial Tap Id for Location Countries Removed (id) This is the unique identifier for the trial tap location country removes table.
    ClinicalTrials.gov registry number (nct_id) This is the foreign key.
    Trial Tap Index for Location Countries Removed (loc_rem_index) This is the unique line item number for each NCT ID of record.
    Removed Countries (removed_countries) Countries removed from the trial.
    Trial Tap Created Date for Location Countries Removed (created_at) Date this trial was pulled from clinicaltrials.gov
    Trial Tap Updated Date for Location Countries Removed (updated_at) Date this trial was updated from clinicaltrials.gov
    For the Protocol Registration System Definitions, please visit PRS Definitions.