Name: DataSet-01-All Licenses
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

DataSet-01-All Licenses

A listing of all TMB licenses. Additional licensee information can be found at https://www.tmb.state.tx.us/page/look-up-a-license.
Organization: City of Austin
Last updated: 2023-08-25T23:32:38.877060
Tags: permits-and-licensing

Tables

Table 1

@usgov.city_of_austin_dataset_01_all_licenses.table_1

19.99 MB
485,293 rows
23 columns

CREATE TABLE table_1 (
  "license_type" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "suffix" VARCHAR,
  "year_of_birth" DOUBLE,
  "license_number" VARCHAR,
  "license_issue_date" VARCHAR,
  "license_expiration_date" VARCHAR,
  "registration_status" VARCHAR,
  "registration_status_date" VARCHAR,
  "disciplinary_status" VARCHAR,
  "disciplinary_status_date" VARCHAR,
  "license_status" VARCHAR,
  "license_status_date" VARCHAR,
  "degree" VARCHAR,
  "specialties" VARCHAR,
  "practice_address" VARCHAR,
  "practice_city" VARCHAR,
  "practice_state" VARCHAR,
  "practice_zip" VARCHAR,
  "currently_licensed" VARCHAR,
  "current_board_action_date" TIMESTAMP,
  "current_board_action_description" VARCHAR
);