Name: EDC Data Big Table
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

EDC Data Big Table

EDC reporting 1997-current
Organization: City of Austin
Last updated: 2025-03-25T12:29:36.326507
Tags: economic-development, government

Tables

Table 1

@usgov.city_of_austin_edc_data_big_table.table_1

1.01 MB
18,477 rows
33 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "hq_city" VARCHAR,
  "edc_type_code" VARCHAR,
  "corporation_name" VARCHAR,
  "report_recieved_date" VARCHAR,
  "edc_city" VARCHAR,
  "edc_fiscal_year_start" VARCHAR,
  "edc_fiscal_year_end" VARCHAR,
  "revenue_bonds" DOUBLE,
  "revenue_grants" DOUBLE,
  "revenue_other" DOUBLE,
  "revenue_sales_tax" DOUBLE,
  "revenue_users_fees" DOUBLE,
  "revenue_total" DOUBLE,
  "expense_total" DOUBLE,
  "cash_total" DOUBLE,
  "sos_file_no" DOUBLE  -- SOS File No.,
  "edc_street" VARCHAR,
  "edc_state" VARCHAR,
  "edc_zip" VARCHAR,
  "assets_buildings" VARCHAR,
  "assets_commercial_buildings" VARCHAR,
  "assets_equipment" VARCHAR,
  "assets_industrial_parks_sites" VARCHAR  -- ASSETS Industrial Parks & Sites,
  "assets_land" VARCHAR,
  "assets_other" VARCHAR,
  "assets_recreational_facilities" VARCHAR,
  "objectives_infrastructure" VARCHAR,
  "objectives_job_creation_job_retention" VARCHAR  -- OBJECTIVES Job Creation & Job Retention,
  "objectives_sports_facilities_recreation" VARCHAR  -- OBJECTIVES Sports Facilities & Recreation,
  "objectives_tourism" VARCHAR,
  "objectives_other" VARCHAR,
  "location" VARCHAR
);