About this Dataset

Clinical Trials (ClinicalTrials.gov)

ClinicalTrials.gov is a website and online database of clinical research studies and information about their results. The purpose of ClinicalTrials.gov is to provide information about clinical research studies to the public, researchers, and health care professionals.

Tables

Clinical Trials (ClinicalTrials.gov)

@owid.clinical_trials.owid_interventions_per_year

9.98 kB
50 rows
12 columns

CREATE TABLE owid_interventions_per_year (
  "year" INTEGER,
  "device" INTEGER,
  "procedure" INTEGER,
  "radiation" INTEGER,
  "other" INTEGER,
  "dietary_supplement" INTEGER,
  "diagnostic_test" INTEGER,
  "behavioral" INTEGER,
  "biological" INTEGER,
  "drug" INTEGER,
  "genetic" INTEGER,
  "combination_product" INTEGER
);

Clinical Trials (ClinicalTrials.gov)

@owid.clinical_trials.owid_length_per_year

4.58 kB
252 rows
3 columns

CREATE TABLE owid_length_per_year (
  "year" INTEGER,
  "country" VARCHAR,
  "avg_study_length_days" FLOAT
);

Clinical Trials (ClinicalTrials.gov)

@owid.clinical_trials.owid_participants_per_year

4.31 kB
252 rows
3 columns

CREATE TABLE owid_participants_per_year (
  "year" INTEGER,
  "country" VARCHAR,
  "avg_participants" FLOAT
);

Clinical Trials (ClinicalTrials.gov)

@owid.clinical_trials.owid_purpose_per_year

4.67 kB
292 rows
3 columns

CREATE TABLE owid_purpose_per_year (
  "year" INTEGER,
  "country" VARCHAR,
  "n_studies_purpose" INTEGER
);

Clinical Trials (ClinicalTrials.gov)

@owid.clinical_trials.owid_results_per_year

3.78 kB
85 rows
3 columns

CREATE TABLE owid_results_per_year (
  "year" INTEGER,
  "country" VARCHAR,
  "n_studies_results" INTEGER
);

Clinical Trials (ClinicalTrials.gov)

@owid.clinical_trials.owid_sponsor_per_year

4.13 kB
176 rows
3 columns

CREATE TABLE owid_sponsor_per_year (
  "year" INTEGER,
  "country" VARCHAR,
  "n_studies_sponsor" INTEGER
);

Clinical Trials (ClinicalTrials.gov)

@owid.clinical_trials.owid_status_per_year

5.24 kB
393 rows
3 columns

CREATE TABLE owid_status_per_year (
  "year" INTEGER,
  "country" VARCHAR,
  "n_studies_status" INTEGER
);

Clinical Trials (ClinicalTrials.gov)

@owid.clinical_trials.owid_study_type_per_year

3.78 kB
103 rows
3 columns

CREATE TABLE owid_study_type_per_year (
  "year" INTEGER,
  "country" VARCHAR,
  "n_studies_type" INTEGER
);

Clinical Trials (ClinicalTrials.gov)

@owid.clinical_trials.owid_trials_per_year

11.91 kB
2,928 rows
3 columns

CREATE TABLE owid_trials_per_year (
  "year" INTEGER,
  "country" VARCHAR,
  "n_studies_country" INTEGER
);