About this Dataset

Other Outcomes

The Other Outcomes dataset includes information on whether the trial includes measures of depression, anxiety, substance use, sleep, anger, quality of life and functioning. Results in this dataset are provided for each treatment arm. The name of the measure is included as well as the between-group effect sizes. Use this dataset to learn how about the effects of PTSD treatments on other outcomes.
Values abstracted as not applicable ("NA") or not reported ("NR") from the study are null values (empty cells).
Study level variables, like military status and percent female, are included for ease of filtering. These columns are not individual arm or arm comparison level data.
Organization: Department of Veterans Affairs
Last updated: 2023-09-28T23:13:43.954473
Tags: other-outcomes, ptsd-repository

Tables

Table 1

@usgov.va_gov_other_outcomes_f8aa2.table_1

206.46 kB
2,201 rows
39 columns

CREATE TABLE table_1 (
  "study_id" VARCHAR,
  "unique_row_identifier" VARCHAR,
  "study_class" VARCHAR,
  "treatment_focus_study_level" VARCHAR  -- Treatment Focus (Study Level),
  "total_n_randomized_study_level" BIGINT  -- Total N Randomized (Study Level),
  "outcome" VARCHAR,
  "outcome_measure" VARCHAR,
  "comparison" VARCHAR,
  "ncptsd_treatment_names" VARCHAR,
  "assessment_point_category" VARCHAR,
  "assessment_point" VARCHAR,
  "follow_up_assessment_in_weeks" VARCHAR,
  "analysis_type" VARCHAR,
  "effect_size_1_detail" VARCHAR,
  "effect_size_1_type" VARCHAR,
  "effect_size_1_value" VARCHAR,
  "effect_size_1_type_of_variance_measure" VARCHAR,
  "effect_size_1_variance_value_or_lower_bound" VARCHAR,
  "effect_size_1_variance_upper_bound" VARCHAR,
  "effect_size_1_p_value" VARCHAR,
  "effect_size_2_detail" VARCHAR,
  "effect_size_2_type" VARCHAR,
  "effect_size_2_value" DOUBLE,
  "effect_size_2_type_of_variance_measure" VARCHAR,
  "effect_size_2_variance_value_or_lower_bound" DOUBLE,
  "effect_size_2_variance_upper_bound" DOUBLE,
  "effect_size_2_p_value" VARCHAR,
  "military_status_study_level" VARCHAR  -- Military Status (Study Level),
  "active_duty_military_study_level" DOUBLE  -- Active Duty Military (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
);