About this Dataset

Study Characteristics

The Study Characteristics dataset includes basic information about study design. In addition to study class, the dataset includes clinical setting, whether the study looked at PTSD symptom clusters, whether there were any subgroup analyses, type of diagnostic measure used (e.g., diagnostic interview, self-report), and provider credentials. Use this dataset to better understand the variety of RCT designs employed, compare studies by study class or to identify gaps in the literature for potential new RCTs. Visualizations made from this dataset will be based on the 550 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-28T20:58:30.953690
Tags: ncptsd, ptsd, study-characteristics

Tables

Table 1

@usgov.va_gov_study_characteristics_7e3c5.table_1

261.84 kB
550 rows
45 columns

CREATE TABLE table_1 (
  "study_id" VARCHAR,
  "study_class" VARCHAR,
  "treatment_focus_study_level" VARCHAR  -- Treatment Focus (Study Level),
  "study_publication_year" BIGINT,
  "ptsdpubs_id" DOUBLE,
  "countries" VARCHAR,
  "geometric_point" VARCHAR,
  "clinical_setting" VARCHAR,
  "study_design" VARCHAR,
  "subscale_symptom_cluster_data" VARCHAR,
  "subgroup_analysis" VARCHAR,
  "providers_have_grad_degrees" VARCHAR,
  "allowed_ptsd_psychotherapy_co_intervention" VARCHAR,
  "allowed_other_psychotherapy_co_intervention" VARCHAR,
  "allowed_psychotropic_med_co_intervention" VARCHAR,
  "diagnosis_assessment_type" VARCHAR,
  "diagnostic_measure" VARCHAR,
  "diagnostic_measure_detail" VARCHAR,
  "depression_outcome_assessed" VARCHAR,
  "anxiety_outcome_assessed" VARCHAR,
  "sleep_outcome_assessed" VARCHAR,
  "anger_outcome_assessed" VARCHAR,
  "functioning_outcome_assessed" VARCHAR,
  "substance_use_outcome_assessed" VARCHAR,
  "quality_of_life_outcome_assessed" VARCHAR,
  "suicide_or_self_harm_related_outcomes" VARCHAR,
  "serious_harms_assessed" VARCHAR,
  "risk_of_bias_rating" VARCHAR,
  "study_comments" VARCHAR,
  "citation" VARCHAR,
  "year_added_to_ptsd_repository" BIGINT,
  "patients_with_suicidality_excluded" VARCHAR,
  "suicide_and_self_directed_violence_related_inclusion_a_e8eceace" VARCHAR  -- Suicide And Self-Directed Violence Related Inclusion And Exclusion Criteria,
  "psychotic_disorder_and_symptom_related_inclusion_and_e_000a0c28" VARCHAR  -- Psychotic Disorder And Symptom Related Inclusion And Exclusion Criteria,
  "active_control" VARCHAR,
  "inactive_control" VARCHAR,
  "military_status" VARCHAR,
  "active_duty_military" DOUBLE,
  "veteran" DOUBLE,
  "community" DOUBLE,
  "female_percent" DOUBLE,
  "male_percent" DOUBLE,
  "trauma_type" VARCHAR,
  "trauma_detail" VARCHAR,
  "race_ethnicity_reported" VARCHAR  -- Race/Ethnicity. Reported
);