About this Dataset

Harms

The Harms dataset includes information on serious adverse events and participant withdrawals from the studies due to adverse events. Adverse events are reported as the percent of participants within a treatment group that experienced an adverse event or who withdrew from the study. Detail on the specific adverse event or reason for withdrawal is provided when available. This dataset also reports on the percentage of patients who attempted or completed suicide (when available).
Values abstracted as "NA" or "NR" from the study are represented as null values/empty cells in this dataset.
Study level variables like military status and percent female are included for filtering purposes
Organization: Department of Veterans Affairs
Last updated: 2023-09-28T21:15:33.224700
Tags: harms, ptsd-repository

Tables

Table 1

@usgov.va_gov_harms_6498e.table_1

181.09 kB
1,094 rows
49 columns

CREATE TABLE table_1 (
  "study_id" VARCHAR,
  "study_class" VARCHAR,
  "treatment_focus_study_level" VARCHAR  -- Treatment Focus (Study Level),
  "intervention_group" VARCHAR,
  "treatment_focus_arm_level" VARCHAR  -- Treatment Focus (Arm Level),
  "treatment_focus_subclass" VARCHAR,
  "treatment_name" VARCHAR,
  "ncptsd_treatment_name" VARCHAR,
  "psychotherapy" VARCHAR,
  "psychotherapy_subclass" VARCHAR,
  "pharmacotherapy" VARCHAR,
  "pharmacotherapy_subclass" VARCHAR,
  "cih" VARCHAR,
  "cih_subclass" VARCHAR,
  "nonpharmacologic_biologic" VARCHAR,
  "nonpharmacologic_cognitive" VARCHAR,
  "control" VARCHAR,
  "other" VARCHAR,
  "collaborative_care" VARCHAR,
  "format" VARCHAR,
  "delivery_method" VARCHAR,
  "arm_n_randomized" DOUBLE,
  "serious_adverse_event_percent" DOUBLE,
  "serious_adverse_event_detail" VARCHAR,
  "withdrawal_due_to_adverse_events_percent" DOUBLE,
  "withdrawal_due_to_adverse_events_detail" VARCHAR,
  "attempted_suicide_percent" DOUBLE,
  "attempted_suicide_detail" VARCHAR,
  "completed_suicide_percent" DOUBLE,
  "completed_suicide_detail" VARCHAR,
  "harms_comment" VARCHAR,
  "military_status_study_level" VARCHAR  -- Military Status (Study Level),
  "active_duty_military_percent_study_level" DOUBLE  -- Active Duty Military Percent (Study Level),
  "veteran_percent_study_level" DOUBLE  -- Veteran Percent (Study Level),
  "community_percent_study_level" DOUBLE  -- Community Percent (Study Level),
  "female_percent_study_level" DOUBLE  -- Female Percent (Study Level),
  "male_percent_study_level" DOUBLE  -- Male Percent (Study Level),
  "trauma_type_study_level" VARCHAR  -- Trauma Type (Study Level),
  "trauma_detail_study_level" VARCHAR  -- Trauma Detail (Study Level),
  "risk_of_bias_rating_study_level" VARCHAR  -- Risk Of Bias Rating (Study Level),
  "citation" VARCHAR,
  "ptsdpubs_id" DOUBLE,
  "year_added_to_ptsd_repository" BIGINT,
  "serious_adverse_events_numerator" DOUBLE,
  "serious_adverse_events_denominator" DOUBLE,
  "withdrawal_due_to_adverse_events_numerator" DOUBLE,
  "withdrawal_due_to_adverse_events_denominator" DOUBLE,
  "attempted_suicide_numerator" DOUBLE,
  "attempted_suicide_denominator" DOUBLE
);