Name: DMH Veterans Provider Enrollment
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

DMH Veterans Provider Enrollment

Data populates the DMH Veterans Services-Mental Health Services Map which helps to connect service members, veteran and their families to behavioral health services. Visit http://dmh.mo.gov/veterans/
Organization: State of Missouri
Last updated: 2020-11-10T17:23:33.752746
Tags: dmh, provider-map

Tables

Table 1

@usgov.state_of_missouri_dmh_veterans_provider_enrollment.table_1

41.17 kB
195 rows
36 columns

CREATE TABLE table_1 (
  "company_name" VARCHAR,
  "ban" VARCHAR,
  "cgdc" VARCHAR,
  "rd" VARCHAR,
  "substance_abuse" VARCHAR,
  "lcsw" VARCHAR,
  "lpc" VARCHAR,
  "mft" VARCHAR,
  "lmsw" VARCHAR,
  "plpc" VARCHAR,
  "psychiatric_nurse_practitioner" VARCHAR,
  "psychiatrist" VARCHAR,
  "psychologist" VARCHAR,
  "alcohol_and_substance_use" VARCHAR,
  "anger_management" VARCHAR,
  "child_adolescent" VARCHAR,
  "compulsive_gambling" VARCHAR,
  "domestic_violence" VARCHAR,
  "eating_disorder" VARCHAR,
  "faith_based" VARCHAR,
  "family_marriage" VARCHAR,
  "general_mental_health" VARCHAR,
  "post_traumatic_stress" VARCHAR,
  "sexual_assault" VARCHAR,
  "suicide_prevention" VARCHAR,
  "traumatic_brain_injury" VARCHAR,
  "telehealth" VARCHAR,
  "website" VARCHAR,
  "phone_number" DOUBLE,
  "zip_code" BIGINT,
  "country" VARCHAR,
  "tricare" VARCHAR,
  "military_culture" VARCHAR,
  "admin_notes" VARCHAR,
  "location_1" VARCHAR,
  "suite_no" VARCHAR  -- Suite No.
);