About this Dataset

Sample Characteristics

The Sample Characteristics dataset includes information on the participants who are included in the studies. This information is provided at the study level—meaning, data are not broken down into the specific treatment arms such as the intervention or control groups. Use this dataset if you want to learn more about the number of participants in the study; inclusion and exclusion criteria related to substance use and suicidality; baseline clinical characteristics such as PTSD severity, trauma type, military status, and comorbidities; and, basic demographic information such as age, gender or race for the sample as a whole (not individual participants). Visualizations made from this dataset will be based on the 496 RCTs included in the PTSD-Repository. Values reported as "NA" or not reported "NR" by the study are null values (empty cells). Data is at the study level.
Organization: Department of Veterans Affairs
Last updated: 2023-09-29T00:20:34.140797
Tags: demographic, ncptsd, population, population-characteristics, ptsd

Tables

Table 1

@usgov.va_gov_sample_characteristics_ff235.table_1

256.38 kB
550 rows
78 columns

CREATE TABLE table_1 (
  "study_id" VARCHAR,
  "study_publication_year" BIGINT,
  "study_class" VARCHAR,
  "treatment_focus_study_level" VARCHAR  -- Treatment Focus (Study Level),
  "n_randomized" BIGINT,
  "n_randomized_detail" VARCHAR,
  "ptsd_criteria_met_at_baseline_percent" DOUBLE,
  "ptsd_criteria_met_at_baseline_percent_detail" VARCHAR,
  "ptsd_severity_at_baseline_definition" VARCHAR,
  "ptsd_severity_at_baseline_mean" DOUBLE,
  "ptsd_severity_at_baseline_standard_deviation" DOUBLE,
  "ptsd_severity_at_baseline_detail" VARCHAR,
  "additional_ptsd_severity_data" VARCHAR,
  "duration_of_symptoms_diagnosis_mean" DOUBLE,
  "duration_of_symptoms_diagnosis_standard_deviation" DOUBLE,
  "duration_of_symptoms_diagnosis_detail" VARCHAR,
  "active_duty_military_percent" DOUBLE,
  "service_connected_veteran_percent" DOUBLE,
  "service_connected_veteran_percent_detail" VARCHAR,
  "veteran_percent" DOUBLE,
  "community_percent" DOUBLE,
  "military_status" VARCHAR,
  "military_status_detail" VARCHAR,
  "age_mean" DOUBLE,
  "age_standard_deviation" DOUBLE,
  "age_detail" VARCHAR,
  "female_percent" DOUBLE,
  "male_percent" DOUBLE,
  "race_ethnicity_reported" VARCHAR,
  "race_white" DOUBLE  -- Race, White,
  "race_black" DOUBLE  -- Race, Black,
  "race_aian" DOUBLE  -- Race, AIAN,
  "race_asian" DOUBLE  -- Race, Asian,
  "race_nhpi" DOUBLE  -- Race, NHPI,
  "race_other" DOUBLE  -- Race, Other,
  "race_detail" VARCHAR  -- Race, Detail,
  "ethnicity_hispanic" DOUBLE  -- Ethnicity, Hispanic,
  "ethnicity_hispanic_detail" VARCHAR  -- Ethnicity, Hispanic Detail,
  "percent_treatment_naive" VARCHAR,
  "percent_treatment_naive_detail" VARCHAR,
  "percent_with_depression" DOUBLE,
  "percent_with_depression_detail" VARCHAR,
  "percent_with_tbi_history" VARCHAR,
  "percent_with_tbi_history_detail" VARCHAR,
  "trauma_type" VARCHAR,
  "trauma_detail" VARCHAR,
  "trauma_types_mean" DOUBLE,
  "trauma_types_standard_deviation" DOUBLE,
  "trauma_types_detail" VARCHAR,
  "trauma_events_mean" DOUBLE,
  "trauma_events_standard_deviation" DOUBLE,
  "trauma_events_detail" VARCHAR,
  "sud_substance_class" VARCHAR,
  "sud_specific_substance_target" VARCHAR,
  "current_sud_inclusion_exclusion_criteria" VARCHAR,
  "percent_with_any_sud_detail" VARCHAR,
  "patients_with_suicidality_excluded" VARCHAR,
  "suicide_or_self_directed_violence_exclusion_inclusion_criteria" VARCHAR,
  "suicide_or_self_directed_violence_definition" VARCHAR,
  "suicide_or_self_directed_violence_percent" DOUBLE,
  "suicide_or_self_directed_violence_detail" VARCHAR,
  "psychotic_disorder_or_symptom_inclusion_exclusion_criteria" VARCHAR,
  "psychotic_disorder_or_symptom_related_definition" VARCHAR,
  "psychotic_disorder_or_symptom_related_percent" DOUBLE,
  "psychotic_disorder_or_symptom_related_detail" VARCHAR,
  "personality_disorder_definition" VARCHAR,
  "personality_disorder_percent" DOUBLE,
  "personality_disorder_detail" VARCHAR,
  "anxiety_disorder_definition" VARCHAR,
  "anxiety_disorder_percent" DOUBLE,
  "anxiety_disorder_detail" VARCHAR,
  "prior_inpatient_hospitalization_percent" DOUBLE,
  "prior_inpatient_hospitalization_percent_detail" VARCHAR,
  "geometric_point" VARCHAR,
  "risk_of_bias_rating" VARCHAR,
  "citation" VARCHAR,
  "ptsdpubs_id" DOUBLE,
  "year_added_to_ptsd_repository" BIGINT
);