EDC Data Big Table
City of Austin
@usgov.city_of_austin_edc_data_big_table
City of Austin
@usgov.city_of_austin_edc_data_big_table
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
);
Anyone who has the link will be able to view this.