About this Dataset

Workers’ Compensation Maximum Medical Improvement Doctors And Designated Doctors’ Address Information

The Texas Department of Insurance, Division of Workers' Compensation (DWC) maintains a database of health care providers with current maximum medical improvement (MMI) and designated doctor certifications in Texas. This list includes doctors’ certification periods, phone numbers, fax numbers, and addresses. For more information about designated doctors, go to https://www.tdi.texas.gov/wc/dd/index.html. For a list of health care providers’ MMI and designated doctors’ certifications only, go to Workers’ Compensation Maximum Medical Improvement Doctors and Designated Doctors List.
Organization: City of Austin
Last updated: 2023-12-25T10:41:14.565776
Tags: address, dd, ddl, designated-doctor, ir, location, mmi, mmi-ir, primary, traveling, workers-compensation

Tables

Table 1

@usgov.city_of_austin_workers_compensation_maximum_medical_im_472b344e.table_1

180.46 kB
8,149 rows
30 columns

CREATE TABLE table_1 (
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_name" VARCHAR,
  "suffix" VARCHAR,
  "license" VARCHAR,
  "ddl" BOOLEAN,
  "ddl_start_date" TIMESTAMP,
  "ddl_end_date" TIMESTAMP,
  "mmi" BOOLEAN,
  "mmi_start_date" TIMESTAMP,
  "mmi_end_date" TIMESTAMP,
  "primary_phone" VARCHAR,
  "primary_fax" VARCHAR,
  "address_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city_name" VARCHAR,
  "state_code" VARCHAR,
  "postal_code" VARCHAR,
  "country_name" VARCHAR,
  "province_region" VARCHAR,
  "primary_address_flag" BOOLEAN,
  "dd_non_traveling_address" BOOLEAN,
  "dd_traveling_address" BOOLEAN,
  "designated_doctor_address" BOOLEAN,
  "practice_address" BOOLEAN,
  "mailing_address" BOOLEAN,
  "physical_shipping_address" BOOLEAN,
  "address_phone_number" VARCHAR,
  "address_fax_number" VARCHAR
);