Energy Storage Solutions (ESS) Enrollment
State of Connecticut
@usgov.state_of_connecticut_energy_storage_solutions_ess_enrollment
State of Connecticut
@usgov.state_of_connecticut_energy_storage_solutions_ess_enrollment
CREATE TABLE table_1 (
"project_name" VARCHAR,
"project_counter" BIGINT,
"stage" VARCHAR,
"project_status" VARCHAR,
"host_city" VARCHAR,
"host_zip" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"census_tract_code" VARCHAR,
"county" VARCHAR,
"cog_name" VARCHAR,
"state_house_district" VARCHAR,
"state_senate_district" VARCHAR,
"congressional_district" VARCHAR,
"opportunity_zone" VARCHAR,
"usda_rurality" VARCHAR,
"cost_membership" VARCHAR,
"vintage_msa_ami_band" VARCHAR,
"vintage_msa_smi_band" VARCHAR,
"vintage_msa_cra_ami_band" VARCHAR,
"vintage_msa_cra_smi_band" VARCHAR,
"vintage_distressed" VARCHAR,
"vintage_ej_poverty_level" BOOLEAN,
"vintage_vulnerable_community" VARCHAR,
"vulnerable_community_category" VARCHAR,
"vintageejcommunity" VARCHAR,
"vintagejustice40" VARCHAR,
"cra_qualified" VARCHAR,
"lmi_qualified" VARCHAR,
"cra_qualified_smi" VARCHAR,
"lmi_qualified_smi" VARCHAR,
"contractor_name" VARCHAR,
"eligible_system_owner" VARCHAR,
"third_party_owner" VARCHAR,
"edc" VARCHAR,
"utility_rate_code" VARCHAR,
"sector" VARCHAR,
"customer_type" VARCHAR,
"customer_class" VARCHAR,
"naics_code" VARCHAR,
"resi_customer_type" VARCHAR,
"residential_sector" VARCHAR,
"priority_customer_indicator" BOOLEAN,
"priority_customer" VARCHAR,
"critical_facilities" VARCHAR,
"grid_edge" VARCHAR,
"small_business" BOOLEAN,
"multifamily_affordable_housing" VARCHAR,
"low_income" VARCHAR,
"underserved" VARCHAR,
"fcm_participant" VARCHAR,
"on_site_fossil_fuel_replacement" VARCHAR,
"pre_existing_storage_system" VARCHAR,
"program_dispatch" VARCHAR,
"total_system_power_kw" DOUBLE,
"total_system_power_mw" DOUBLE,
"total_system_power_watts" BIGINT,
"total_system_energy_capacity_kwh" DOUBLE,
"total_system_max_cont_discharge_rate_kw" VARCHAR,
"total_system_quantity" DOUBLE,
"annual_peak_demand_kw" DOUBLE,
"installed_location" VARCHAR,
"system_pairing_original" VARCHAR,
"system_pairing" VARCHAR,
"paired_pv_system_size" VARCHAR,
"up_front_incentive" DOUBLE,
"batteries_storage_cost" DOUBLE,
"engineering_and_design_cost" DOUBLE,
"installation_labor_cost" DOUBLE,
"interconnection_cost" DOUBLE,
"inverter_cost" DOUBLE,
"monitoring_cost" DOUBLE,
"permitting_cost" DOUBLE,
"solar_pv_inverter_s_cost" DOUBLE,
"balance_of_system_cost" DOUBLE,
"total_battery_cost" DOUBLE,
"total_solar_pv_cost" DOUBLE,
"total_contract_price" DOUBLE,
"gross_cost" DOUBLE,
"total_capital_deployed" DOUBLE,
"cgb_incentive_amount" DOUBLE,
"total_cgb_investment" DOUBLE,
"total_private_investment" DOUBLE,
"total_investment" DOUBLE,
"incentive_step" DOUBLE,
"created_date" VARCHAR,
"application_date" TIMESTAMP,
"submitted_date" TIMESTAMP,
"approval_date" TIMESTAMP,
"energize_date" TIMESTAMP,
"completed_date" TIMESTAMP,
"individualincometaxesgenerated" DOUBLE,
"corporatetaxesgenerated" DOUBLE,
"salestaxesgenerated" DOUBLE,
"totaltaxrevenuegenerated" DOUBLE,
"direct_jobs" DOUBLE,
"indirect_and_induced_jobs" DOUBLE,
"total_jobs" DOUBLE,
"expectedusefullife" BIGINT,
"kwh_kw" DOUBLE
);
Anyone who has the link will be able to view this.