Provides data related to a distributor’s annual billings and energy- related determinants (i.e., total consumption (kWh) and demand (kW)) for customers and connections broken down by generic rate class. Note that the start year for this data file is 2015.
The data points that were left blank by distributors have been populated with zeros.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.5.4 Demand and Revenue.xml
Archive:
Provides data regarding a distributor’s licensed service area (both rural and urban), maximum monthly peak load (summer and winter peak load with and without embedded generation), average peak load (with and without embedded generation), average load factor (with and without embedded generation), and overheard and underground circuit kilometers broken down by primary and secondary lines. Note that primary and secondary breakdown is only available after 2019. The other data points are available from 2015 onwards.
The data points that were left blank by the distributors have been populated with zeros.
Archive:
Provides data related to a distributor’s regulated return on equity (ROE). The ROE is calculated on the same basis as was used in establishing the distributor’s base rates. Note that the start year for this data file is 2015.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.5.6 ROE Calculation Analysis.xml
Archive:
Provides data related to a distributor’s balance sheet and income statement as well as trial balance data for all of the accounts (and sub-accounts as applicable) set out in the Accounting Procedures Handbook. Note that the start year for this data file is 2015.
Table 1: The first table provides a balance sheet view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.7 Table 1 Balance Sheet Analysis.xml
Table 2: The second table contains an income statement view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.7 Table 2 Income Statement Analysis.xml
Table 3: The third table provides trial balance data for all of the accounts (and sub-accounts as applicable) set out in the Accounting Procedures Handbook.
Note: Some files are large and are best viewed in a data application. Right-click and download the files to your computer. Then open them in the data application of your choice (Excel or other BI tool).
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.7 Table 3 All Accounts Analysis (all year).xlsx (7 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2015.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2016.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2017.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2018.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2019.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2020.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2021.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2022.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.7 Table 3 All Accounts 2023.xml (10 MB)
Archive:
Table 1: The first table provides a balance sheet view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2.1.7 Balance Sheet.xml
Table 2: The second table contains an income statement view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2.1.7 Income Statement.xml
Table 3: The third table provides trial balance data for all of the accounts (and sub-accounts as applicable) set out in the Accounting Procedures Handbook.
Note: Some files are large and are best viewed in a data application. Right-click and download the files to your computer. Then open them in the data application of your choice (Excel or other BI tool).
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis (all years).xlsx (9 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2015.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2016.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2017.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2018.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2019.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2020.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2021.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2022.xml (10 MB)
Table 1: The first table provides a balance sheet view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 Balance Sheet.xml
Table 2: The second table contains an income statement view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 Income Statement Analysis.xml
Table 3: The third table provides trial balance data for all of the accounts (and sub-accounts as applicable) set out in the Accounting Procedures Handbook.
Note: Some files are large and are best viewed in a data application. Right-click and download the files to your computer. Then open them in the data application of your choice (Excel or other BI tool).
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis (all years).xlsx (7 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2015.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2016.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2017.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2018.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2019.xml (8 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2020.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2021.xml (12 MB)
Provides information related to number of eligible low-income customer accounts, disconnections for non-payment, arrears, write offs, equal billing, security deposits and load control devices for both residential customers and eligible low-income customers. Note that the start year for this data file is 2015.
Archive:
Provides data related to distributor’s provision of the OESP. Note that the start year for this data file is 2016.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.9 OESP Analysis.xml
Archive:
Provides data related to net metered generators and embedded generation facilities connected to an electricity distributor’s distribution system.
The data points that were left blank by the distributors have been populated with zeros.
Table 1: The first table provides data related to the number of net metered generators connected to an electricity distributor’s distribution system, the total installed capacity (kW) of net metered generators , the total installed capacity (kW) of storage devices used by net metered generators, as well as the cumulative installed capacity (kW ) , all broken down by renewable energy source. Note that the start year for this data file is 2015.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.14 Table 1 Net Metering.xml
Table 2: The second table provides data related to the number of signed declarations received from generators who wish to participate in third party net metering and the total installed capacity (kW) of net metered generation associated with the signed declarations. Note that the start year for this data file is 2023.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.14 Table 2 Third Party Net Metering.xml
Table 3: The third table provides data related to the number of embedded generation facilities (excluding net metered generators) connected to an electricity distributor’s distribution system and the total installed capacity (kW) of the embedded generation facilities. Note that the start year for this data file is 2017.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.14 Table 3 Embedded Generation.xml
Table 4: The fourth table provides data related to the number of embedded generation facilities (excluding net metered generators) connected to an electricity distributor’s distribution system and the total installed capacity (kW) of the embedded generation facilities, each broken down by facility type. Note that the start year for this data file is 2023.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.14 Table 4 Embedded Generation by Type.xml
Table 5: The third table provides information related to the electricity distributor’s maximum cumulative generation capacity from net metered generators. Note that the start year for this data file is 2017.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.14 Table 5 Net Metering Totals (max. cumulative capacity).xml
Archive:
Table 1: The first table provides data related to the number of net metered generators connected to an electricity distributor’s distribution system, the total installed capacity (kW) of net metered generators, and the total installed capacity (kW) of storage devices used by net metered generators, all broken down by renewable energy source. Note that the start year for this data file is 2015.
https://www.oeb.ca/documents/opendata/rrr/2.1.14 Net Metering Analysis.xml
Table 2: The second table provides data related to the number of embedded generation facilities (excluding net metered generators) connected to an electricity distributor’s distribution system and the total installed capacity (kW) of the embedded generation facilities. Note that the start year for this data file is 2015.
https://www.oeb.ca/documents/opendata/rrr/2.1.14 Embedded Generation Analysis.xml
Table 3: The third table provides information related to the electricity distributor’s maximum cumulative generation capacity from net metered generators. Note that the start year for this data file is 2017.
https://www.oeb.ca/documents/opendata/rrr/2.1.14 Net Metering Totals (max. cumulative capacity) Analysis.xml
Table 1: The first table provides data related to the number of net metered generators connected to an electricity distributor’s distribution system, the total installed capacity (kW) of net metered generators, and the total installed capacity (kW) of storage devices used by net metered generators, all broken down by renewable energy source. Note that the start year for this data file is 2015.
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.14 Net Metering Analysis.xml
Table 2: The second table provides data related to the number of embedded generation facilities (excluding net metered generators) connected to an electricity distributor’s distribution system and the total installed capacity (kW) of the embedded generation facilities. Note that the start year for this data file is 2015.
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.14 Embedded Generation Analysis.xml
Table 3: The third table provides information related to the electricity distributor’s maximum cumulative generation capacity from net metered generators. Note that the start year for this data file is 2017.
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.14 Net Metering Totals (max. cumulative capacity) Analysis.xml
Provides data related to the provision of LEAP emergency financial assistance. Note that the data points related to number of LEAP emergency financial assistance applicants are available from 2016 onwards.
The data points that were left blank by distributors have been populated with zeros.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.16 LEAP Analysis.xml
Archive:
Provides data related to a distributor’s billing accuracy, public safety and non-prescriptive scorecard measures.
Note that the start year for this data file is 2017.
Archive:
Provides the total number of customers and connections reported by each distributor broken down by generic rate class. Note that the start year for this data file is 2015.
Note: Detailed rate class reported by distributors have been omitted for reasons of confidentiality.
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.2 Customers and Connections.xml
Archive:
Use it to find case-related documents: Regulatory Document Search (RDS)
We want to hear from you. Learn more here.
We have programs that can help. See if you qualify.
