About this Dataset

Study Interventions

The Study Interventions dataset includes information about each of the specific treatment arms that were studied in all RCTs. Each study arm was coded to indicate the type of intervention or comparison condition. This dataset includes the study-level Study Class as well as individual variables for each category of treatment, coded as Yes or No for each arm. Study arm treatment category variables are as follows: Pharmacotherapy (as well as a subclass such as antidepressant, antianxiety, etc.); Psychotherapy (as well as a subclass to identify trauma-focused or non-trauma-focused therapy); Complementary and Integrative Health (CIH; as well as a subclass such as relaxation or meditation); Nonpharmacologic Biological; Nonpharmacologic Cognitive; Collaborative Care; Other Treatments; Control
The Study Intervention dataset also includes information on the format of the treatment (individual, group, couples, mixed); treatment delivery method (in person, by phone, by video, technology alone, technology assisted, written or mixed); dose or amount of treatment and, treatment completion and adherence. Use this dataset to learn about treatment studies of a particular type

Each record is an arm of the study, labeled as A, B, C, or D. Values abstracted as not applicable ("NA") or not reported ("NR") from the study are null values (empty cells).
Organization: Department of Veterans Affairs
Last updated: 2023-09-28T20:08:22.392628
Tags: ptsd-repository

Tables

Table 1

@usgov.va_gov_study_interventions_78076.table_1

385.01 kB
1,210 rows
57 columns

CREATE TABLE table_1 (
  "study_id" VARCHAR,
  "study_class" VARCHAR,
  "study_publication_year" BIGINT,
  "treatment_focus_study_level" VARCHAR  -- Treatment Focus (Study Level),
  "treatment_focus_arm_level" VARCHAR  -- Treatment Focus (Arm Level),
  "treatment_focus_subclass_arm_level" VARCHAR  -- Treatment Focus Subclass (Arm Level),
  "total_n_randomized" BIGINT,
  "intervention_group" VARCHAR,
  "arm_n_randomized" DOUBLE,
  "arm_n_randomized_detail" VARCHAR,
  "treatment_name" VARCHAR,
  "standardized_treatment_name" VARCHAR,
  "treatment_description" 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,
  "dose" VARCHAR,
  "session_length" VARCHAR,
  "frequency" VARCHAR,
  "treatment_duration" VARCHAR,
  "treatment_duration_detail" VARCHAR,
  "treatment_completion_definition" VARCHAR,
  "completed_psychotherapy_percent" DOUBLE,
  "completed_psychotherapy_percent_detail" VARCHAR,
  "treatment_adherence_definition" VARCHAR,
  "adhered_pharmacotherapy_percent" DOUBLE,
  "adhered_pharmacotherapy_percent_detail" VARCHAR,
  "psychotherapy_sessions_completed_mean" DOUBLE,
  "psychotherapy_sessions_completed_standard_deviation" DOUBLE,
  "psychotherapy_sessions_completed_detail" VARCHAR,
  "dose_at_study_end_point_mean" VARCHAR,
  "dose_at_study_end_point_standard_deviation" VARCHAR,
  "dose_at_study_end_point_detail" VARCHAR,
  "race_ethnicity_reported" 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,
  "geocoded_point" VARCHAR
);