About this Dataset

Eminent Domain Data

The Eminent Domain Data table includes information about the entities that have reported to the Comptroller’s office, their contact information, and whether they have used their eminent domain authority through filing a condemnation petition. Each report includes a unique ID number that can be used to reference data in the Provision Data and Project Data tables. The data included in the reports was submitted by the entities, and entities are required to update the data within 90 days of changes to their information. The Comptroller’s office is not able to guarantee the accuracy of the data.
The table is updated daily and includes entity names, entity types, phone numbers, addresses, email and web addresses, and points of contact. Each report specifies whether the entity used their eminent domain authority by filing a condemnation petition in the preceding year. If the report was filed by a third party, the third party’s name, contact information, and relationship to the entity is also listed.
Organization: City of Austin
Last updated: 2023-08-25T22:38:26.466154
Tags: eminent-domain

Tables

Table 1

@usgov.city_of_austin_eminent_domain_data.table_1

3.92 MB
58,383 rows
48 columns

CREATE TABLE table_1 (
  "report_id" BIGINT,
  "entity_name" VARCHAR,
  "tpid" BIGINT,
  "entity_category" VARCHAR,
  "entity_type" VARCHAR,
  "other_entity_desc" VARCHAR,
  "entity_phone_number" BIGINT,
  "entity_website" VARCHAR,
  "contact_first_name" VARCHAR,
  "contact_last_name" VARCHAR,
  "contact_title" VARCHAR,
  "contact_phone_number" BIGINT,
  "contact_email" VARCHAR,
  "authority_grant_year" BIGINT,
  "authority_grant_month" VARCHAR,
  "parent_company_name" VARCHAR,
  "report_year" BIGINT,
  "entry_date" TIMESTAMP,
  "condemnation_petition" VARCHAR,
  "third_party_name" VARCHAR,
  "third_party_email" VARCHAR,
  "third_party_phone_number" DOUBLE,
  "third_party_website" VARCHAR,
  "third_party_relationship" VARCHAR,
  "other_third_party_desc" VARCHAR,
  "mailing_address_line_1" VARCHAR,
  "mailing_address_line_2" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip" BIGINT,
  "mailing_zip_4" DOUBLE,
  "mailing_county" VARCHAR,
  "physical_address_line_1" VARCHAR,
  "physical_address_line_2" VARCHAR,
  "physical_city" VARCHAR,
  "physical_state" VARCHAR,
  "physical_zip" BIGINT,
  "physical_address_zip_4" DOUBLE,
  "physical_county" VARCHAR,
  "third_party_address_line_1" VARCHAR,
  "third_party_address_line_2" VARCHAR,
  "third_party_city" VARCHAR,
  "third_party_state" VARCHAR,
  "third_party_zip" DOUBLE,
  "third_party_zip_4" DOUBLE,
  "third_party_county" VARCHAR,
  "eminent_domain_entity_id" BIGINT,
  "last_updated" VARCHAR
);