Contents Menu Expand Light mode Dark mode Auto light/dark, in light mode Auto light/dark, in dark mode Skip to content
PUDL 2024.8.1.dev41+gb05ee89.d20241007 documentation
Logo
PUDL 2024.8.1.dev41+gb05ee89.d20241007 documentation
  • About PUDL
  • Data Access
  • Data Sources
    • EIA Form 860 – Annual Electric Generator Report
    • EIA Form 861 – Annual Electric Power Industry Report
    • EIA Form 923 – Power Plant Operations Report
    • EIA Form 930 – Hourly and Daily Balancing Authority Operations Report
    • EPA Hourly Continuous Emission Monitoring System (CEMS)
    • FERC Form 1 – Annual Report of Major Electric Utilities
    • FERC Form 714 – Annual Electric Balancing Authority Area and Planning Area Report
    • Pipelines and Hazardous Materials Safety Administration (PHMSA) Annual Natural Gas Report
    • GridPath Resource Adequacy Toolkit Data
    • Other Data in PUDL
    • High Priority Target Datasets
  • Data Dictionaries
    • PUDL Data Dictionary
    • Raw FERC Form 1 Data Dictionary
    • PUDL Code Metadata
  • Contributing
  • Development
    • Development Setup
    • Running the ETL Pipeline
    • Developing with Dagster
    • Project Management
    • Testing PUDL
    • Building the Documentation
    • Working with the Datastore
    • Converting raw FERC data to SQLite
    • Existing Data Updates
    • Run a Versioned Release
    • PUDL ID Mapping
    • Naming Conventions
    • Data and ETL Design Guidelines
    • Nightly Data Builds
    • Infrastructure as Code
  • Licensing
  • Code of Conduct
  • Release Notes
  • API Reference
    • pudl
      • pudl.analysis
        • pudl.analysis.ml_tools
          • pudl.analysis.ml_tools.experiment_tracking
          • pudl.analysis.ml_tools.models
        • pudl.analysis.record_linkage
          • pudl.analysis.record_linkage.classify_plants_ferc1
          • pudl.analysis.record_linkage.eia_ferc1_inputs
          • pudl.analysis.record_linkage.eia_ferc1_model_config
          • pudl.analysis.record_linkage.eia_ferc1_record_linkage
          • pudl.analysis.record_linkage.eia_ferc1_train
          • pudl.analysis.record_linkage.embed_dataframe
          • pudl.analysis.record_linkage.link_cross_year
          • pudl.analysis.record_linkage.name_cleaner
        • pudl.analysis.allocate_gen_fuel
        • pudl.analysis.epacamd_eia
        • pudl.analysis.fuel_by_plant
        • pudl.analysis.mcoe
        • pudl.analysis.plant_parts_eia
        • pudl.analysis.service_territory
        • pudl.analysis.spatial
        • pudl.analysis.state_demand
        • pudl.analysis.timeseries_cleaning
      • pudl.convert
        • pudl.convert.censusdp1tract_to_sqlite
        • pudl.convert.metadata_to_rst
      • pudl.etl
        • pudl.etl.check_foreign_keys
        • pudl.etl.cli
        • pudl.etl.eia_bulk_elec_assets
        • pudl.etl.epacems_assets
        • pudl.etl.glue_assets
        • pudl.etl.static_assets
      • pudl.extract
        • pudl.extract.csv
        • pudl.extract.dbf
        • pudl.extract.eia176
        • pudl.extract.eia191
        • pudl.extract.eia757a
        • pudl.extract.eia860
        • pudl.extract.eia860m
        • pudl.extract.eia861
        • pudl.extract.eia923
        • pudl.extract.eia930
        • pudl.extract.eia_bulk_elec
        • pudl.extract.eiaaeo
        • pudl.extract.epacems
        • pudl.extract.excel
        • pudl.extract.extractor
        • pudl.extract.ferc
        • pudl.extract.ferc1
        • pudl.extract.ferc2
        • pudl.extract.ferc6
        • pudl.extract.ferc60
        • pudl.extract.ferc714
        • pudl.extract.gridpathratoolkit
        • pudl.extract.nrelatb
        • pudl.extract.parquet
        • pudl.extract.phmsagas
        • pudl.extract.xbrl
      • pudl.ferc_to_sqlite
        • pudl.ferc_to_sqlite.cli
      • pudl.glue
        • pudl.glue.ferc1_eia
        • pudl.glue.ferc714
      • pudl.metadata
        • pudl.metadata.resources
          • pudl.metadata.resources.allocate_gen_fuel
          • pudl.metadata.resources.eia
          • pudl.metadata.resources.eia860
          • pudl.metadata.resources.eia860m
          • pudl.metadata.resources.eia861
          • pudl.metadata.resources.eia923
          • pudl.metadata.resources.eia930
          • pudl.metadata.resources.eia_bulk_elec
          • pudl.metadata.resources.eiaaeo
          • pudl.metadata.resources.epacems
          • pudl.metadata.resources.ferc1
          • pudl.metadata.resources.ferc1_eia_record_linkage
          • pudl.metadata.resources.ferc714
          • pudl.metadata.resources.glue
          • pudl.metadata.resources.gridpathratoolkit
          • pudl.metadata.resources.mcoe
          • pudl.metadata.resources.nrelatb
          • pudl.metadata.resources.pudl
        • pudl.metadata.classes
        • pudl.metadata.codes
        • pudl.metadata.constants
        • pudl.metadata.dfs
        • pudl.metadata.enums
        • pudl.metadata.fields
        • pudl.metadata.helpers
        • pudl.metadata.labels
        • pudl.metadata.sources
      • pudl.output
        • pudl.output.sql
          • pudl.output.sql.helpers
        • pudl.output.censusdp1tract
        • pudl.output.eia
        • pudl.output.eia860
        • pudl.output.eia923
        • pudl.output.eia_bulk_elec
        • pudl.output.epacems
        • pudl.output.ferc1
        • pudl.output.ferc714
        • pudl.output.pudltabl
      • pudl.package_data
        • pudl.package_data.eia176
          • pudl.package_data.eia176.column_maps
        • pudl.package_data.eia191
          • pudl.package_data.eia191.column_maps
        • pudl.package_data.eia757a
          • pudl.package_data.eia757a.column_maps
        • pudl.package_data.eia860
          • pudl.package_data.eia860.column_maps
        • pudl.package_data.eia860m
          • pudl.package_data.eia860m.column_maps
        • pudl.package_data.eia861
          • pudl.package_data.eia861.column_maps
        • pudl.package_data.eia923
          • pudl.package_data.eia923.column_maps
        • pudl.package_data.eia930
          • pudl.package_data.eia930.column_maps
        • pudl.package_data.epacems
        • pudl.package_data.ferc1
          • pudl.package_data.ferc1.row_maps
        • pudl.package_data.glue
        • pudl.package_data.phmsagas
          • pudl.package_data.phmsagas.column_maps
        • pudl.package_data.settings
        • pudl.package_data.test
          • pudl.package_data.test.column_maps
      • pudl.transform
        • pudl.transform.params
          • pudl.transform.params.ferc1
        • pudl.transform.classes
        • pudl.transform.eia
        • pudl.transform.eia860
        • pudl.transform.eia860m
        • pudl.transform.eia861
        • pudl.transform.eia923
        • pudl.transform.eia930
        • pudl.transform.eia_bulk_elec
        • pudl.transform.eiaaeo
        • pudl.transform.epacems
        • pudl.transform.ferc
        • pudl.transform.ferc1
        • pudl.transform.ferc714
        • pudl.transform.gridpathratoolkit
        • pudl.transform.nrelatb
      • pudl.workspace
        • pudl.workspace.datastore
        • pudl.workspace.resource_cache
        • pudl.workspace.setup
      • pudl.__main__
      • pudl.helpers
      • pudl.io_managers
      • pudl.logging_helpers
      • pudl.resources
      • pudl.settings
      • pudl.validate
  • Bibliography
Back to top
View this page

pudl.output.sql¶

A module of python helper functions and sql files for creating SQL views.

Submodules¶

  • pudl.output.sql.helpers
Next
pudl.output.sql.helpers
Previous
pudl.output
Copyright © 2016-2024, Catalyst Cooperative, CC-BY-4.0
Made with Sphinx and @pradyunsg's Furo
On this page
  • pudl.output.sql
    • Submodules