.. warning::
    This database is under active development. Additionally, the data is reported by utilities to the Alaska Energy Authority and may contain errors. While we take steps to minimize obviously erroneous data in our cleaned version of the data, errors may persist. We make no guarantees about the accuracy of this data.


*********
Downloads
*********

This page contains download links for the Power Cost Equalization (PCE) Utility Monthly Report (UMR) data. The data is available with and without data processing.

Individual Datasets
###################

.. list-table:: 
    :widths: 15 45 10
    :header-rows: 1

    * - Dataset
      - Description
      - Download
    * - Cleaned PCE UMR Data
      - A ``.zip`` file containing the Monthly Power Cost Equalization Utility Monthly Report data and data dictionary. This data has gone through significant processing. Information on the data cleaning process can be found on the Data Cleaning page. FY2001-2023.
      - :download:`Download <https://github.com/acep-uaf/pce-database/raw/refs/heads/main/src/database/data/derived/individual-data-package/pce-umr-cleaned.zip>`
    * - Original PCE UMR Data
      - A ``.zip`` file containing the Monthly Power Cost Equalization Utility Monthly Report data and data dictionary. This data has gone through minimal processing. Column names have been standardized. Calendar dates have been added. FY2001-2023.
      - :download:`Download <https://github.com/acep-uaf/pce-database/raw/refs/heads/main/src/database/data/derived/individual-data-package/pce-umr-uncleaned.zip>`
    * - Community Codes
      - A ``.zip`` file containing a list of PCE eligible communities and their associated PCE community code. Includes data dictionary.
      - :download:`Download <https://github.com/acep-uaf/pce-database/raw/refs/heads/main/src/database/data/derived/individual-data-package/identities.zip>`
    * - Interconnections
      - A ``.zip`` file containing a list of PCE communities that have undergone an interconnection and when. Includes data dictionary.
      - :download:`Download <https://github.com/acep-uaf/pce-database/raw/refs/heads/main/src/database/data/derived/individual-data-package/interties.zip>`

Grouped Datasets
################

.. list-table:: 
    :widths: 15 45 10
    :header-rows: 1

    * - Dataset
      - Description
      - Download
    * - Datapackage
      - This is a zip file including all individual datasets (as ``.csv`` files) with their respective data dictionaries.
      - :download:`Download <https://github.com/acep-uaf/pce-database/raw/refs/heads/main/src/database/data/derived/pce-umr-datapackage.zip>`
    * - SQLite Database
      - This is an SQLite database of all individual datasets (as a single ``.db`` file). No metadata is provided.
      - :download:`Download <https://github.com/acep-uaf/pce-database/raw/refs/heads/main/src/database/data/derived/sqlite/pce-umr.db>`