Name: US Renewable Energy Programs
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

US Renewable Energy Programs

Generation, States, Programs, Contacts, and More

By [source]

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.19 kB
50 rows
4 columns

CREATE TABLE annual_generation_sums (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "state" VARCHAR,
  "generation" DOUBLE,
  "renewable_pct" DOUBLE
);

Authority

@kaggle.thedevastator_us_renewable_energy_programs.authority

205.78 kB
2,960 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

395.81 kB
29,789 rows
3 columns

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

Contact

@kaggle.thedevastator_us_renewable_energy_programs.contact

410.87 kB
5,789 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

45.9 kB
3,372 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.37 MB
6,339 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

162.17 kB
13,595 rows
14 columns

CREATE TABLE eia_a_raw_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "n_0" BIGINT  -- 0,
  "n_1" DOUBLE  -- 1,
  "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

289.92 kB
13,595 rows
26 columns

CREATE TABLE eia_dsire_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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

660.21 kB
13,595 rows
188 columns

CREATE TABLE eia_dsire_data_tech (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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 Financial Incentive,
  "solar_passive_regulatory_policy" BIGINT  -- Solar - Passive Regulatory Policy,
  "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) Financial Incentive,
  "wind_all_regulatory_policy" BIGINT  -- Wind (All) Regulatory Policy,
  "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 \u0026 Power Financial Incentive,
  "combined_heat_power_regulatory_policy" BIGINT  -- Combined Heat \u0026 Power Regulatory Policy,
  "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.19 kB
4 rows
2 columns

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

Export

@kaggle.thedevastator_us_renewable_energy_programs.export

8.48 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.9 kB
11 rows
3 columns

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

Modelinput

@kaggle.thedevastator_us_renewable_energy_programs.modelinput

256.85 kB
763 rows
261 columns

CREATE TABLE modelinput (
  "solar_passive_financial_incentive" BIGINT  -- Solar - Passive Financial Incentive,
  "solar_passive_regulatory_policy" BIGINT  -- Solar - Passive Regulatory Policy,
  "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) Financial Incentive,
  "wind_all_regulatory_policy" BIGINT  -- Wind (All) Regulatory Policy,
  "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 \u0026 Power Financial Incentive,
  "combined_heat_power_regulatory_policy" BIGINT  -- Combined Heat \u0026 Power Regulatory Policy,
  "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 Financial Incentive,
  "energy_mgmt_systems_building_controls_regulatory_policy" BIGINT  -- Energy Mgmt. Systems/Building Controls Regulatory Policy,
  "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

93.3 kB
7,210 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.99 kB
4,758 rows
2 columns

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

Parameter Set Sector

@kaggle.thedevastator_us_renewable_energy_programs.parameter_set_sector

43.06 kB
10,762 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

37.83 kB
6,995 rows
2 columns

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

Program

@kaggle.thedevastator_us_renewable_energy_programs.program

4.02 MB
4,994 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.16 kB
2 rows
2 columns

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

Program City

@kaggle.thedevastator_us_renewable_energy_programs.program_city

11.6 kB
2,456 rows
2 columns

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

Program Contact

@kaggle.thedevastator_us_renewable_energy_programs.program_contact

103.82 kB
7,129 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.48 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

906.08 kB
22,528 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.6 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

46.06 kB
15,166 rows
2 columns

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