US Renewable Energy Programs by Kaggle | Environmental and Climate Sciences

About this Dataset

US Renewable Energy Programs

Generation, States, Programs, Contacts, and More

About this dataset

The Renewable Energy Program Database in the United States is a comprehensive source of quantitative information on renewable energy incentive and regulatory policies, program parameters, and generation data. It features a holistic overview of the production and utilization of renewable energy across all fifty states in the United States making it a terrific asset for anyone looking to understand sustainable energy practices and analyze how they can apply their knowledge to help create more robust policies. With this dataset, analysts can not only assess current usage and trends but also uncover potential development opportunities that would benefit from additional investment incentives or other regulatory solutions. Moreover, it also provides insight into how we could better use existing technologies to build a greener future for our planet!

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset enables you to explore and analyze the use of renewable energy programs in the US. It is organized into two main files: program_type.csv, which provides information on the types of renewable energy programs available in the United States; and parameter_set_sector.csv, which provides detailed quantitative information about renewable energy incentive and regulatory policies, program parameters and generation data across all fifty states. The dataset can be used to track trends in renewable energy policy across states, compare different types of renewable energy programs, explore financial incentives for green initiatives or identify high-performing practices at state levels.

To get started with this dataset, choose a file from either program_type or parameter set sectors and open it up in Kaggle Notebooks or some other data analysis platform of your choice. From there you will have access to all available parameters including name (name of the programme), primary technologies (the dominant technology used within that programme) as well as other variables related to those programmes like sectors (catergories based on geographical scope) total funding(total funding provided) etcetera.. Once you are familiar with that particular dataset look for relationships between different variables by creating visualizations such as scatterplots or bar graphs. In addition you can also view your analysis through geospatial maps by linking a map visualization application such as leaflet map box etcetera..

Research Ideas

Analyzing the effectiveness of renewable energy incentives and policies by state, to inform decisions about enacting new policies or reforming current programs.

Creating predictive models based on the dataset to estimate potential future trends in renewable energy use and investment in specific sectors or markets within each state.

Comparing across states in terms of their relative success with renewable energy programs, providing insight into best practices that other states could adopt or replicate

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: program_type.csv

Column name	Description
name	The name of the renewable energy program. (String)

File: parameter_set_sector.csv

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Annual Generation Sums

@kaggle.thedevastator_us_renewable_energy_programs.annual_generation_sums

5.07 KB
50 rows
4 columns


CREATE TABLE annual_generation_sums (
  "unnamed_0" BIGINT,
  "state" VARCHAR,
  "generation" DOUBLE,
  "renewable_pct" DOUBLE
);

Authority

@kaggle.thedevastator_us_renewable_energy_programs.authority

200.95 KB
2960 rows
13 columns


CREATE TABLE authority (
  "id" BIGINT,
  "program_id" BIGINT,
  "order" DOUBLE,
  "code" VARCHAR,
  "website" VARCHAR,
  "enacted" TIMESTAMP,
  "enactedtext" VARCHAR,
  "effective" TIMESTAMP,
  "effectivetext" VARCHAR,
  "expired" TIMESTAMP,
  "expiredtext" VARCHAR,
  "file_key" VARCHAR,
  "file_name" VARCHAR
);

City

@kaggle.thedevastator_us_renewable_energy_programs.city

386.53 KB
29789 rows
3 columns


CREATE TABLE city (
  "id" BIGINT,
  "name" VARCHAR,
  "state_id" BIGINT
);

Contact

@kaggle.thedevastator_us_renewable_energy_programs.contact

401.24 KB
5789 rows
14 columns


CREATE TABLE contact (
  "id" BIGINT,
  "created_ts" TIMESTAMP,
  "updated_ts" TIMESTAMP,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "organization_name" VARCHAR,
  "web_visible_default" BIGINT,
  "phone" VARCHAR,
  "email" VARCHAR,
  "website_url" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state_id" DOUBLE,
  "zip" VARCHAR
);

County

@kaggle.thedevastator_us_renewable_energy_programs.county

44.83 KB
3372 rows
3 columns


CREATE TABLE county (
  "id" BIGINT,
  "name" VARCHAR,
  "state_id" BIGINT
);

Dsire Program Data

@kaggle.thedevastator_us_renewable_energy_programs.dsire_program_data

2.26 MB
6339 rows
29 columns


CREATE TABLE dsire_program_data (
  "programid" BIGINT,
  "name" VARCHAR,
  "code" VARCHAR,
  "lastupdate" TIMESTAMP,
  "published" BOOLEAN,
  "state" VARCHAR,
  "implementingsectorid" DOUBLE,
  "implementingsectorname" VARCHAR,
  "categoryid" DOUBLE,
  "categoryname" VARCHAR,
  "typeid" DOUBLE,
  "typename" VARCHAR,
  "websiteurl" VARCHAR,
  "administrator" VARCHAR,
  "fundingsource" VARCHAR,
  "budget" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "utilities" VARCHAR,
  "counties" VARCHAR,
  "cities" VARCHAR,
  "zipcodes" VARCHAR,
  "technologies" VARCHAR,
  "sectors" VARCHAR,
  "contacts" VARCHAR,
  "programparameters" VARCHAR,
  "details" VARCHAR,
  "authorities" VARCHAR,
  "fromsir" VARCHAR
);

Eia A Raw Data

@kaggle.thedevastator_us_renewable_energy_programs.eia_a_raw_data

158.37 KB
13595 rows
14 columns


CREATE TABLE eia_a_raw_data (
  "unnamed_0" BIGINT,
  "n_0" BIGINT,
  "n_1" DOUBLE,
  "copyright" VARCHAR,
  "description" VARCHAR,
  "end" BIGINT,
  "f" VARCHAR,
  "geography" VARCHAR,
  "iso3166" VARCHAR,
  "name" VARCHAR,
  "series_id" VARCHAR,
  "source" VARCHAR,
  "start" BIGINT,
  "units" VARCHAR
);

Eia Dsire Data

@kaggle.thedevastator_us_renewable_energy_programs.eia_dsire_data

283.12 KB
13595 rows
26 columns


CREATE TABLE eia_dsire_data (
  "unnamed_0" BIGINT,
  "index" BIGINT,
  "date" TIMESTAMP,
  "generation" DOUBLE,
  "copyright" VARCHAR,
  "description" VARCHAR,
  "end" BIGINT,
  "f" VARCHAR,
  "geography" VARCHAR,
  "iso3166" VARCHAR,
  "name" VARCHAR,
  "series_id" VARCHAR,
  "source" VARCHAR,
  "start" BIGINT,
  "units" VARCHAR,
  "state" VARCHAR,
  "solar_financial_incentive" BIGINT,
  "solar_regulatory_policy" BIGINT,
  "wind_financial_incentive" BIGINT,
  "wind_regulatory_policy" BIGINT,
  "biomass_financial_incentive" BIGINT,
  "biomass_regulatory_policy" BIGINT,
  "geothermal_financial_incentive" BIGINT,
  "geothermal_regulatory_policy" BIGINT,
  "hydro_financial_incentive" BIGINT,
  "hydro_regulatory_policy" BIGINT
);

Eia Dsire Data Tech

@kaggle.thedevastator_us_renewable_energy_programs.eia_dsire_data_tech

644.74 KB
13595 rows
188 columns


CREATE TABLE eia_dsire_data_tech (
  "unnamed_0" BIGINT,
  "index" BIGINT,
  "date" TIMESTAMP,
  "generation" DOUBLE,
  "copyright" VARCHAR,
  "description" VARCHAR,
  "end" BIGINT,
  "f" VARCHAR,
  "geography" VARCHAR,
  "iso3166" VARCHAR,
  "name" VARCHAR,
  "series_id" VARCHAR,
  "source" VARCHAR,
  "start" BIGINT,
  "units" VARCHAR,
  "state" VARCHAR,
  "solar_passive_financial_incentive" BIGINT,
  "solar_passive_regulatory_policy" BIGINT,
  "solar_water_heat_financial_incentive" BIGINT,
  "solar_water_heat_regulatory_policy" BIGINT,
  "solar_space_heat_financial_incentive" BIGINT,
  "solar_space_heat_regulatory_policy" BIGINT,
  "geothermal_electric_financial_incentive" BIGINT,
  "geothermal_electric_regulatory_policy" BIGINT,
  "solar_thermal_electric_financial_incentive" BIGINT,
  "solar_thermal_electric_regulatory_policy" BIGINT,
  "solar_thermal_process_heat_financial_incentive" BIGINT,
  "solar_thermal_process_heat_regulatory_policy" BIGINT,
  "solar_photovoltaics_financial_incentive" BIGINT,
  "solar_photovoltaics_regulatory_policy" BIGINT,
  "wind_all_financial_incentive" BIGINT,
  "wind_all_regulatory_policy" BIGINT,
  "biomass_financial_incentive" BIGINT,
  "biomass_regulatory_policy" BIGINT,
  "hydroelectric_financial_incentive" BIGINT,
  "hydroelectric_regulatory_policy" BIGINT,
  "hydrogen_financial_incentive" BIGINT,
  "hydrogen_regulatory_policy" BIGINT,
  "geothermal_heat_pumps_financial_incentive" BIGINT,
  "geothermal_heat_pumps_regulatory_policy" BIGINT,
  "municipal_solid_waste_financial_incentive" BIGINT,
  "municipal_solid_waste_regulatory_policy" BIGINT,
  "combined_heat_power_financial_incentive" BIGINT,
  "combined_heat_power_regulatory_policy" BIGINT,
  "fuel_cells_using_non_renewable_fuels_financial_incentive" BIGINT,
  "fuel_cells_using_non_renewable_fuels_regulatory_policy" BIGINT,
  "renewable_fuel_vehicles_financial_incentive" BIGINT,
  "renewable_fuel_vehicles_regulatory_policy" BIGINT,
  "renewable_fuels_financial_incentive" BIGINT,
  "renewable_fuels_regulatory_policy" BIGINT,
  "landfill_gas_financial_incentive" BIGINT,
  "landfill_gas_regulatory_policy" BIGINT,
  "tidal_financial_incentive" BIGINT,
  "tidal_regulatory_policy" BIGINT,
  "wave_financial_incentive" BIGINT,
  "wave_regulatory_policy" BIGINT,
  "ocean_thermal_financial_incentive" BIGINT,
  "ocean_thermal_regulatory_policy" BIGINT,
  "refueling_stations_financial_incentive" BIGINT,
  "refueling_stations_regulatory_policy" BIGINT,
  "daylighting_financial_incentive" BIGINT,
  "daylighting_regulatory_policy" BIGINT,
  "solar_pool_heating_financial_incentive" BIGINT,
  "solar_pool_heating_regulatory_policy" BIGINT,
  "clothes_washers_financial_incentive" BIGINT,
  "clothes_washers_regulatory_policy" BIGINT,
  "dishwasher_financial_incentive" BIGINT,
  "dishwasher_regulatory_policy" BIGINT,
  "refrigerators_freezers_financial_incentive" BIGINT,
  "refrigerators_freezers_regulatory_policy" BIGINT,
  "dehumidifiers_financial_incentive" BIGINT,
  "dehumidifiers_regulatory_policy" BIGINT,
  "ceiling_fan_financial_incentive" BIGINT,
  "ceiling_fan_regulatory_policy" BIGINT,
  "equipment_insulation_financial_incentive" BIGINT,
  "equipment_insulation_regulatory_policy" BIGINT,
  "water_heaters_financial_incentive" BIGINT,
  "water_heaters_regulatory_policy" BIGINT,
  "lighting_financial_incentive" BIGINT,
  "lighting_regulatory_policy" BIGINT,
  "lighting_controls_sensors_financial_incentive" BIGINT,
  "lighting_controls_sensors_regulatory_policy" BIGINT,
  "chillers_financial_incentive" BIGINT,
  "chillers_regulatory_policy" BIGINT,
  "furnaces_financial_incentive" BIGINT,
  "furnaces_regulatory_policy" BIGINT,
  "boilers_financial_incentive" BIGINT,
  "boilers_regulatory_policy" BIGINT,
  "heat_pumps_financial_incentive" BIGINT,
  "heat_pumps_regulatory_policy" BIGINT,
  "air_conditioners_financial_incentive" BIGINT,
  "air_conditioners_regulatory_policy" BIGINT,
  "heat_recovery_financial_incentive" BIGINT,
  "heat_recovery_regulatory_policy" BIGINT,
  "steam_system_upgrades_financial_incentive" BIGINT,
  "steam_system_upgrades_regulatory_policy" BIGINT,
  "compressed_air_financial_incentive" BIGINT,
  "compressed_air_regulatory_policy" BIGINT,
  "programmable_thermostats_financial_incentive" BIGINT,
  "programmable_thermostats_regulatory_policy" BIGINT
);

Energy Category

@kaggle.thedevastator_us_renewable_energy_programs.energy_category

2.14 KB
4 rows
2 columns


CREATE TABLE energy_category (
  "id" BIGINT,
  "name" VARCHAR
);

Export

@kaggle.thedevastator_us_renewable_energy_programs.export

8.29 KB
208 rows
5 columns


CREATE TABLE export (
  "id" BIGINT,
  "key" VARCHAR,
  "created_ts" TIMESTAMP,
  "type" VARCHAR,
  "size" BIGINT
);

Implementing Sector

@kaggle.thedevastator_us_renewable_energy_programs.implementing_sector

2.83 KB
11 rows
3 columns


CREATE TABLE implementing_sector (
  "id" BIGINT,
  "name" VARCHAR,
  "active" BIGINT
);

Modelinput

@kaggle.thedevastator_us_renewable_energy_programs.modelinput

250.83 KB
763 rows
261 columns


CREATE TABLE modelinput (
  "solar_passive_financial_incentive" BIGINT,
  "solar_passive_regulatory_policy" BIGINT,
  "solar_water_heat_financial_incentive" BIGINT,
  "solar_water_heat_regulatory_policy" BIGINT,
  "solar_space_heat_financial_incentive" BIGINT,
  "solar_space_heat_regulatory_policy" BIGINT,
  "geothermal_electric_financial_incentive" BIGINT,
  "geothermal_electric_regulatory_policy" BIGINT,
  "solar_thermal_electric_financial_incentive" BIGINT,
  "solar_thermal_electric_regulatory_policy" BIGINT,
  "solar_thermal_process_heat_financial_incentive" BIGINT,
  "solar_thermal_process_heat_regulatory_policy" BIGINT,
  "solar_photovoltaics_financial_incentive" BIGINT,
  "solar_photovoltaics_regulatory_policy" BIGINT,
  "wind_all_financial_incentive" BIGINT,
  "wind_all_regulatory_policy" BIGINT,
  "biomass_financial_incentive" BIGINT,
  "biomass_regulatory_policy" BIGINT,
  "hydroelectric_financial_incentive" BIGINT,
  "hydroelectric_regulatory_policy" BIGINT,
  "hydrogen_financial_incentive" BIGINT,
  "hydrogen_regulatory_policy" BIGINT,
  "geothermal_heat_pumps_financial_incentive" BIGINT,
  "geothermal_heat_pumps_regulatory_policy" BIGINT,
  "municipal_solid_waste_financial_incentive" BIGINT,
  "municipal_solid_waste_regulatory_policy" BIGINT,
  "combined_heat_power_financial_incentive" BIGINT,
  "combined_heat_power_regulatory_policy" BIGINT,
  "fuel_cells_using_non_renewable_fuels_financial_incentive" BIGINT,
  "fuel_cells_using_non_renewable_fuels_regulatory_policy" BIGINT,
  "renewable_fuel_vehicles_financial_incentive" BIGINT,
  "renewable_fuel_vehicles_regulatory_policy" BIGINT,
  "renewable_fuels_financial_incentive" BIGINT,
  "renewable_fuels_regulatory_policy" BIGINT,
  "landfill_gas_financial_incentive" BIGINT,
  "landfill_gas_regulatory_policy" BIGINT,
  "tidal_financial_incentive" BIGINT,
  "tidal_regulatory_policy" BIGINT,
  "wave_financial_incentive" BIGINT,
  "wave_regulatory_policy" BIGINT,
  "ocean_thermal_financial_incentive" BIGINT,
  "ocean_thermal_regulatory_policy" BIGINT,
  "refueling_stations_financial_incentive" BIGINT,
  "refueling_stations_regulatory_policy" BIGINT,
  "daylighting_financial_incentive" BIGINT,
  "daylighting_regulatory_policy" BIGINT,
  "solar_pool_heating_financial_incentive" BIGINT,
  "solar_pool_heating_regulatory_policy" BIGINT,
  "clothes_washers_financial_incentive" BIGINT,
  "clothes_washers_regulatory_policy" BIGINT,
  "dishwasher_financial_incentive" BIGINT,
  "dishwasher_regulatory_policy" BIGINT,
  "refrigerators_freezers_financial_incentive" BIGINT,
  "refrigerators_freezers_regulatory_policy" BIGINT,
  "dehumidifiers_financial_incentive" BIGINT,
  "dehumidifiers_regulatory_policy" BIGINT,
  "ceiling_fan_financial_incentive" BIGINT,
  "ceiling_fan_regulatory_policy" BIGINT,
  "equipment_insulation_financial_incentive" BIGINT,
  "equipment_insulation_regulatory_policy" BIGINT,
  "water_heaters_financial_incentive" BIGINT,
  "water_heaters_regulatory_policy" BIGINT,
  "lighting_financial_incentive" BIGINT,
  "lighting_regulatory_policy" BIGINT,
  "lighting_controls_sensors_financial_incentive" BIGINT,
  "lighting_controls_sensors_regulatory_policy" BIGINT,
  "chillers_financial_incentive" BIGINT,
  "chillers_regulatory_policy" BIGINT,
  "furnaces_financial_incentive" BIGINT,
  "furnaces_regulatory_policy" BIGINT,
  "boilers_financial_incentive" BIGINT,
  "boilers_regulatory_policy" BIGINT,
  "heat_pumps_financial_incentive" BIGINT,
  "heat_pumps_regulatory_policy" BIGINT,
  "air_conditioners_financial_incentive" BIGINT,
  "air_conditioners_regulatory_policy" BIGINT,
  "heat_recovery_financial_incentive" BIGINT,
  "heat_recovery_regulatory_policy" BIGINT,
  "steam_system_upgrades_financial_incentive" BIGINT,
  "steam_system_upgrades_regulatory_policy" BIGINT,
  "compressed_air_financial_incentive" BIGINT,
  "compressed_air_regulatory_policy" BIGINT,
  "programmable_thermostats_financial_incentive" BIGINT,
  "programmable_thermostats_regulatory_policy" BIGINT,
  "energy_mgmt_systems_building_controls_financial_incentive" BIGINT,
  "energy_mgmt_systems_building_controls_regulatory_policy" BIGINT,
  "caulking_weather_stripping_financial_incentive" BIGINT,
  "caulking_weather_stripping_regulatory_policy" BIGINT,
  "duct_air_sealing_financial_incentive" BIGINT,
  "duct_air_sealing_regulatory_policy" BIGINT,
  "building_insulation_financial_incentive" BIGINT,
  "building_insulation_regulatory_policy" BIGINT,
  "windows_financial_incentive" BIGINT,
  "windows_regulatory_policy" BIGINT,
  "doors_financial_incentive" BIGINT,
  "doors_regulatory_policy" BIGINT,
  "siding_financial_incentive" BIGINT,
  "siding_regulatory_policy" BIGINT,
  "roofs_financial_incentive" BIGINT,
  "roofs_regulatory_policy" BIGINT
);

Parameter

@kaggle.thedevastator_us_renewable_energy_programs.parameter

91.11 KB
7210 rows
6 columns


CREATE TABLE parameter (
  "id" BIGINT,
  "parameter_set_id" BIGINT,
  "source" VARCHAR,
  "qualifier" VARCHAR,
  "amount" DOUBLE,
  "units" VARCHAR
);

Parameter Set

@kaggle.thedevastator_us_renewable_energy_programs.parameter_set

39.05 KB
4758 rows
2 columns


CREATE TABLE parameter_set (
  "id" BIGINT,
  "program_id" BIGINT
);

Parameter Set Sector

@kaggle.thedevastator_us_renewable_energy_programs.parameter_set_sector

42.05 KB
10762 rows
2 columns


CREATE TABLE parameter_set_sector (
  "sector_id" BIGINT,
  "set_id" BIGINT
);

Parameter Set Technology

@kaggle.thedevastator_us_renewable_energy_programs.parameter_set_technology

36.94 KB
6995 rows
2 columns


CREATE TABLE parameter_set_technology (
  "technology_id" BIGINT,
  "set_id" BIGINT
);

Program

@kaggle.thedevastator_us_renewable_energy_programs.program

3.84 MB
4994 rows
23 columns


CREATE TABLE program (
  "id" BIGINT,
  "state_id" BIGINT,
  "is_entire_state" BIGINT,
  "implementing_sector_id" BIGINT,
  "program_category_id" BIGINT,
  "program_type_id" BIGINT,
  "created_by_user_id" BIGINT,
  "code" VARCHAR,
  "name" VARCHAR,
  "updated_ts" TIMESTAMP,
  "created_ts" TIMESTAMP,
  "published" BIGINT,
  "websiteurl" VARCHAR,
  "administrator" VARCHAR,
  "fundingsource" VARCHAR,
  "budget" VARCHAR,
  "start_date" TIMESTAMP,
  "start_date_text" VARCHAR,
  "end_date" TIMESTAMP,
  "end_date_text" VARCHAR,
  "summary" VARCHAR,
  "additional_technologies" VARCHAR,
  "fromsir" BIGINT
);

Program Category

@kaggle.thedevastator_us_renewable_energy_programs.program_category

2.11 KB
2 rows
2 columns


CREATE TABLE program_category (
  "id" BIGINT,
  "name" VARCHAR
);

Program City

@kaggle.thedevastator_us_renewable_energy_programs.program_city

11.33 KB
2456 rows
2 columns


CREATE TABLE program_city (
  "program_id" BIGINT,
  "city_id" BIGINT
);

Program Contact

@kaggle.thedevastator_us_renewable_energy_programs.program_contact

101.38 KB
7129 rows
4 columns


CREATE TABLE program_contact (
  "id" BIGINT,
  "program_id" BIGINT,
  "contact_id" BIGINT,
  "webvisible" BIGINT
);

Program County

@kaggle.thedevastator_us_renewable_energy_programs.program_county

4.37 KB
385 rows
2 columns


CREATE TABLE program_county (
  "program_id" BIGINT,
  "county_id" BIGINT
);

Program Detail

@kaggle.thedevastator_us_renewable_energy_programs.program_detail

884.84 KB
22528 rows
6 columns


CREATE TABLE program_detail (
  "id" BIGINT,
  "program_id" BIGINT,
  "label" VARCHAR,
  "value" VARCHAR,
  "display_order" BIGINT,
  "template_id" DOUBLE
);

Program Detail Template

@kaggle.thedevastator_us_renewable_energy_programs.program_detail_template

5.47 KB
133 rows
4 columns


CREATE TABLE program_detail_template (
  "id" BIGINT,
  "type_id" BIGINT,
  "label" VARCHAR,
  "display_order" BIGINT
);

Program Sector

@kaggle.thedevastator_us_renewable_energy_programs.program_sector

44.98 KB
15166 rows
2 columns


CREATE TABLE program_sector (
  "program_id" BIGINT,
  "sector_id" BIGINT
);

Program Technology

@kaggle.thedevastator_us_renewable_energy_programs.program_technology

70.47 KB
31038 rows
2 columns


CREATE TABLE program_technology (
  "program_id" BIGINT,
  "technology_id" BIGINT
);

Program Type

@kaggle.thedevastator_us_renewable_energy_programs.program_type

3.92 KB
45 rows
3 columns


CREATE TABLE program_type (
  "id" BIGINT,
  "name" VARCHAR,
  "program_category_id" BIGINT
);

Program Utility

@kaggle.thedevastator_us_renewable_energy_programs.program_utility

28.17 KB
6684 rows
2 columns


CREATE TABLE program_utility (
  "program_id" BIGINT,
  "utility_id" BIGINT
);

Program Zipcode

@kaggle.thedevastator_us_renewable_energy_programs.program_zipcode

2.39 KB
37 rows
2 columns


CREATE TABLE program_zipcode (
  "program_id" BIGINT,
  "zipcode_id" BIGINT
);

Sector

@kaggle.thedevastator_us_renewable_energy_programs.sector

4.89 KB
32 rows
5 columns


CREATE TABLE sector (
  "id" BIGINT,
  "name" VARCHAR,
  "fieldname" VARCHAR,
  "is_selectable" BIGINT,
  "parent_id" DOUBLE
);

Sectorcount

@kaggle.thedevastator_us_renewable_energy_programs.sectorcount

2.13 KB
6 rows
2 columns


CREATE TABLE sectorcount (
  "sector" VARCHAR,
  "count" BIGINT
);

State

@kaggle.thedevastator_us_renewable_energy_programs.state

4.54 KB
60 rows
4 columns


CREATE TABLE state (
  "id" BIGINT,
  "abbreviation" VARCHAR,
  "name" VARCHAR,
  "is_territory" BIGINT
);

Statecount2020

@kaggle.thedevastator_us_renewable_energy_programs.statecount2020

3.92 KB
60 rows
3 columns


CREATE TABLE statecount2020 (
  "unnamed_0" BIGINT,
  "state_id" VARCHAR,
  "counts" BIGINT
);

State Info Content

@kaggle.thedevastator_us_renewable_energy_programs.state_info_content

93.36 KB
25 rows
8 columns


CREATE TABLE state_info_content (
  "id" BIGINT,
  "state_id" BIGINT,
  "introduction" VARCHAR,
  "history" VARCHAR,
  "renewable_portfolio_standard" VARCHAR,
  "organizations" VARCHAR,
  "programs" VARCHAR,
  "footnotes" VARCHAR
);

Subscription Memo

@kaggle.thedevastator_us_renewable_energy_programs.subscription_memo

282.95 KB
6066 rows
5 columns


CREATE TABLE subscription_memo (
  "id" BIGINT,
  "program_id" BIGINT,
  "added_by_user" BIGINT,
  "added" TIMESTAMP,
  "memo" VARCHAR
);

Technology

@kaggle.thedevastator_us_renewable_energy_programs.technology

5.6 KB
101 rows
4 columns


CREATE TABLE technology (
  "id" BIGINT,
  "name" VARCHAR,
  "technology_category_id" BIGINT,
  "active" BIGINT
);

Technology Category

@kaggle.thedevastator_us_renewable_energy_programs.technology_category

3.39 KB
28 rows
3 columns


CREATE TABLE technology_category (
  "id" BIGINT,
  "name" VARCHAR,
  "energy_category_id" BIGINT
);