Industrial Development Agencies' Project Data
State of New York
@usgov.state_of_new_york_industrial_development_agencies_project_data
State of New York
@usgov.state_of_new_york_industrial_development_agencies_project_data
CREATE TABLE table_1 (
"authority_name" VARCHAR,
"fiscal_year_end_date" TIMESTAMP,
"project_code" VARCHAR,
"project_type" VARCHAR,
"project_name" VARCHAR,
"part_of_or_related_to_multi_phase_project" VARCHAR,
"original_project_code" VARCHAR,
"project_address_line_1" VARCHAR,
"project_address_line2" VARCHAR,
"project_city" VARCHAR,
"project_state" VARCHAR,
"project_postal_code" BIGINT,
"project_country" VARCHAR,
"project_purpose" VARCHAR,
"total_project_amount" DOUBLE,
"benefited_project_amount" DOUBLE,
"bond_note_amount" DOUBLE,
"annual_lease_payment" DOUBLE,
"federal_tax_status_of_bonds" VARCHAR,
"applicant_not_for_profit_corporation" VARCHAR,
"date_project_approved" TIMESTAMP,
"ida_took_title_to_property" VARCHAR,
"date_ida_took_title_to_property" TIMESTAMP,
"planned_end_year" BIGINT,
"applicant_name" VARCHAR,
"applicant_city" VARCHAR,
"applicant_state" VARCHAR,
"applicant_country" VARCHAR,
"applicant_postal_code" VARCHAR,
"state_sales_tax_exemption_amount" DOUBLE,
"local_sales_tax_exemption_amount" DOUBLE,
"county_real_property_tax_exemption_amount" DOUBLE,
"local_property_tax_exemption_amount" DOUBLE,
"school_property_tax_exemption_amount" DOUBLE,
"mortgage_recording_tax_exemption_amount" DOUBLE,
"total_exemptions" DOUBLE,
"total_exemptions_net_of_rptl_section_485_b_exemptions" DOUBLE,
"county_pilot_due" DOUBLE,
"county_pilot_made" DOUBLE,
"local_pilot_due" DOUBLE,
"local_pilot_made" DOUBLE,
"school_district_pilot_due" DOUBLE,
"school_district_pilot_made" DOUBLE,
"total_pilot_due" DOUBLE,
"total_pilot_made" DOUBLE,
"net_exemptions" DOUBLE,
"number_of_ftes_before_ida_status" DOUBLE,
"original_estimate_of_jobs_to_be_created" DOUBLE,
"estimated_average_annual_salary_of_jobs_to_be_created" DOUBLE,
"minimum_salary_of_jobs_to_be_created" DOUBLE,
"maximum_salary_of_jobs_to_be_created" DOUBLE,
"original_estimate_of_jobs_to_be_retained" DOUBLE,
"estimated_average_annual_salary_of_jobs_to_be_retained" DOUBLE,
"current_number_of_ftes" DOUBLE,
"number_fte_construction_jobs_during_the_fiscal_year" DOUBLE,
"net_employment_change" DOUBLE,
"current_year_is_last_year_of_project" VARCHAR
);
Anyone who has the link will be able to view this.