Baselight

EDC Data Big Table

City of Austin

@usgov.city_of_austin_edc_data_big_table

Loading...
Loading...

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
  • 988.24 KB
  • 18477 rows
  • 33 columns
Loading...

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,
  "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_land" VARCHAR,
  "assets_other" VARCHAR,
  "assets_recreational_facilities" VARCHAR,
  "objectives_infrastructure" VARCHAR,
  "objectives_job_creation_job_retention" VARCHAR,
  "objectives_sports_facilities_recreation" VARCHAR,
  "objectives_tourism" VARCHAR,
  "objectives_other" VARCHAR,
  "location" VARCHAR
);

Share link

Anyone who has the link will be able to view this.