About this Dataset

Iowa Elevator Permits

This dataset includes permits for the installation or alteration of an elevators, escalators, dumbwaiters, and other equipment covered by Iowa Code Chapter 89A by in the State of Iowa. There may be multiple records associated with a permit number where an elevator is updated, but has not been fully replaced.
Organization: State of Iowa
Last updated: 2024-06-28T13:39:55.396019
Tags: alteration, dumbwaiters, elevators, escalators, installation, permits

Tables

Table 1

@usgov.state_of_iowa_iowa_elevator_permits.table_1

1.21 MB
16,330 rows
30 columns

CREATE TABLE table_1 (
  "permit" VARCHAR  -- Permit #,
  "permit_status" VARCHAR,
  "phase" VARCHAR,
  "owner_name" VARCHAR,
  "owner_address_1" VARCHAR,
  "owner_address_2" VARCHAR,
  "property_name" VARCHAR,
  "property_address" VARCHAR,
  "property_city" VARCHAR,
  "property_zip" DOUBLE,
  "property_county" VARCHAR,
  "application_date" TIMESTAMP,
  "issue_date" TIMESTAMP,
  "code_year" VARCHAR,
  "year_installed" VARCHAR,
  "year_altered" VARCHAR,
  "conveyance_type" VARCHAR,
  "type_of_equipment" VARCHAR,
  "landings" VARCHAR,
  "front_openings" VARCHAR,
  "rear_openings" VARCHAR,
  "capacity" VARCHAR,
  "rated_speed" VARCHAR,
  "manufacturer" VARCHAR,
  "firefighters_service" VARCHAR,
  "annual_test_date" TIMESTAMP,
  "annual_test_performed_by" VARCHAR,
  "n_5_year_test_date" VARCHAR  -- 5 Year Test Date,
  "n_5_year_test_performed_by" VARCHAR  -- 5 Year Test Performed By,
  "property_location" VARCHAR
);