Natural Gas Utilities Revenue, Units Sold and Customers by Year

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.iowa.gov
Id 4zs6-cs59
Name Natural Gas Utilities Revenue, Units Sold and Customers by Year
Attribution Teresa McConnell
Category Transportation & Utilities
Tags utilities, energy, natural gas
Created 2016-09-30T19:39:20Z
Publication Date 2016-09-30T20:16:07Z

Description

Beginning in 2015, the dataset shows the revenue, units sold, and average number of customers by customer class for each natural gas utility operating in Iowa.

Columns

| Included | Schema Type    | Field Name                     | Name                                               | Data Type | Render Type |
| ======== | ============== | ============================== | ================================================== | ========= | =========== |
| Yes      | time           | reporting_year                 | Reporting Year                                     | number    | number      |
| Yes      | series tag     | utility_type                   | Type of Utility                                    | text      | text        |
| Yes      | series tag     | utility                        | Utility                                            | text      | text        |
| Yes      | numeric metric | revenues_residential           | Operating Revenues - Residential Sales             | money     | money       |
| Yes      | numeric metric | revenues_comm_industrial       | Operating Revenues - Commercial & Industrial       | money     | money       |
| Yes      | numeric metric | revenues_sales_for_resale      | Operating Revenues - Sales for Resale              | money     | money       |
| Yes      | numeric metric | revenues_all_other             | Operating Revenues - All Other Sales               | money     | money       |
| Yes      | numeric metric | revenues_transportation        | Revenues from Transportation of Gas for Others     | money     | money       |
| Yes      | numeric metric | mcf_sold_residential           | MCF of Natural Gas Sold - Residential              | number    | number      |
| Yes      | numeric metric | mcf_sold_comm_industrial       | MCF of Natural Gas Sold - Commercial & Industrial  | number    | number      |
| Yes      | numeric metric | mcf_sold_sales_for_resale      | MCF of Natural Gas Sold - Sales for Resale         | number    | number      |
| Yes      | numeric metric | mcf_sold_all_other             | MCF of Natural Gas Sold - All Other                | number    | number      |
| Yes      | numeric metric | mcf_transportation             | MCF of Natural Gas Transported for Others          | number    | number      |
| Yes      | numeric metric | avg_customers_residential      | Average No. of Customers - Residential             | number    | number      |
| Yes      | numeric metric | avg_customers_comm_industrial  | Average No. of Customers - Commercial & Industrial | number    | number      |
| Yes      | numeric metric | avg_customers_sales_for_resale | Average No. of Customers - Sales for Resale        | number    | number      |
| Yes      | numeric metric | avg_customers_all_other        | Average No. of Customers - All Other               | number    | number      |
| Yes      | numeric metric | avg_customers_transportation   | Average No. of Customers - Gas Transportation      | number    | number      |

Time Field

Value = reporting_year
Format & Zone = yyyy

Data Commands

series e:4zs6-cs59 d:2015-01-01T00:00:00.000Z t:utility="Interstate Power and Light Company" t:utility_type="Investor owned" m:avg_customers_transportation=357 m:avg_customers_sales_for_resale=0 m:revenues_all_other=1704750 m:mcf_sold_sales_for_resale=0 m:mcf_sold_comm_industrial=12030031 m:mcf_transportation=32248435 m:mcf_sold_all_other=1785089 m:avg_customers_all_other=5 m:mcf_sold_residential=13996150 m:avg_customers_comm_industrial=25399 m:revenues_transportation=16913793 m:revenues_residential=116797862 m:revenues_sales_for_resale=0 m:avg_customers_residential=198685 m:revenues_comm_industrial=76256600

series e:4zs6-cs59 d:2015-01-01T00:00:00.000Z t:utility="MidAmerican Energy Company" t:utility_type="Investor owned" m:avg_customers_transportation=1488 m:avg_customers_sales_for_resale=28 m:revenues_all_other=665217 m:mcf_sold_sales_for_resale=26907959 m:mcf_sold_comm_industrial=20757300 m:mcf_transportation=70737937 m:mcf_sold_all_other=955868 m:avg_customers_all_other=51 m:mcf_sold_residential=36163910 m:avg_customers_comm_industrial=50947 m:revenues_transportation=27230197 m:revenues_residential=292558259 m:revenues_sales_for_resale=72963854 m:avg_customers_residential=519821 m:revenues_comm_industrial=117030768

series e:4zs6-cs59 d:2015-01-01T00:00:00.000Z t:utility=Allerton t:utility_type="Investor owned" m:avg_customers_transportation=0 m:avg_customers_sales_for_resale=0 m:revenues_all_other=0 m:mcf_sold_sales_for_resale=0 m:mcf_sold_comm_industrial=200460 m:mcf_transportation=0 m:mcf_sold_all_other=0 m:avg_customers_all_other=0 m:mcf_sold_residential=12935 m:avg_customers_comm_industrial=30 m:revenues_transportation=0 m:revenues_residential=109107 m:revenues_sales_for_resale=0 m:avg_customers_residential=169 m:revenues_comm_industrial=908387

Meta Commands

metric m:revenues_residential p:integer l:"Operating Revenues - Residential Sales" t:dataTypeName=money

metric m:revenues_comm_industrial p:integer l:"Operating Revenues - Commercial & Industrial" t:dataTypeName=money

metric m:revenues_sales_for_resale p:integer l:"Operating Revenues - Sales for Resale" t:dataTypeName=money

metric m:revenues_all_other p:integer l:"Operating Revenues - All Other Sales" t:dataTypeName=money

metric m:revenues_transportation p:integer l:"Revenues from Transportation of Gas for Others" t:dataTypeName=money

metric m:mcf_sold_residential p:integer l:"MCF of Natural Gas Sold - Residential" t:dataTypeName=number

metric m:mcf_sold_comm_industrial p:integer l:"MCF of Natural Gas Sold - Commercial & Industrial" t:dataTypeName=number

metric m:mcf_sold_sales_for_resale p:integer l:"MCF of Natural Gas Sold - Sales for Resale" t:dataTypeName=number

metric m:mcf_sold_all_other p:integer l:"MCF of Natural Gas Sold - All Other" t:dataTypeName=number

metric m:mcf_transportation p:integer l:"MCF of Natural Gas Transported for Others" t:dataTypeName=number

metric m:avg_customers_residential p:integer l:"Average No. of Customers - Residential" t:dataTypeName=number

metric m:avg_customers_comm_industrial p:integer l:"Average No. of Customers - Commercial & Industrial" t:dataTypeName=number

metric m:avg_customers_sales_for_resale p:integer l:"Average No. of Customers - Sales for Resale" t:dataTypeName=number

metric m:avg_customers_all_other p:integer l:"Average No. of Customers - All Other" t:dataTypeName=number

metric m:avg_customers_transportation p:integer l:"Average No. of Customers - Gas Transportation" t:dataTypeName=number

entity e:4zs6-cs59 l:"Natural Gas Utilities Revenue, Units Sold and Customers by Year" t:attribution="Teresa McConnell" t:url=https://data.iowa.gov/api/views/4zs6-cs59

property e:4zs6-cs59 t:meta.view v:id=4zs6-cs59 v:category="Transportation & Utilities" v:attributionLink=https://efs.iowa.gov v:averageRating=0 v:name="Natural Gas Utilities Revenue, Units Sold and Customers by Year" v:attribution="Teresa McConnell"

property e:4zs6-cs59 t:meta.view.license v:name="Public Domain"

property e:4zs6-cs59 t:meta.view.owner v:id=3wc4-hb8a v:profileImageUrlMedium=/api/users/3wc4-hb8a/profile_images/THUMB v:profileImageUrlLarge=/api/users/3wc4-hb8a/profile_images/LARGE v:screenName="Iowa Utilities Board" v:profileImageUrlSmall=/api/users/3wc4-hb8a/profile_images/TINY v:displayName="Iowa Utilities Board"

property e:4zs6-cs59 t:meta.view.tableauthor v:id=3wc4-hb8a v:profileImageUrlMedium=/api/users/3wc4-hb8a/profile_images/THUMB v:profileImageUrlLarge=/api/users/3wc4-hb8a/profile_images/LARGE v:screenName="Iowa Utilities Board" v:profileImageUrlSmall=/api/users/3wc4-hb8a/profile_images/TINY v:roleName=editor v:displayName="Iowa Utilities Board"

Top Records

| reporting_year | utility_type   | utility                                                        | revenues_residential | revenues_comm_industrial | revenues_sales_for_resale | revenues_all_other | revenues_transportation | mcf_sold_residential | mcf_sold_comm_industrial | mcf_sold_sales_for_resale | mcf_sold_all_other | mcf_transportation | avg_customers_residential | avg_customers_comm_industrial | avg_customers_sales_for_resale | avg_customers_all_other | avg_customers_transportation | 
| ============== | ============== | ============================================================== | ==================== | ======================== | ========================= | ================== | ======================= | ==================== | ======================== | ========================= | ================== | ================== | ========================= | ============================= | ============================== | ======================= | ============================ | 
| 2015           | Investor owned | Interstate Power and Light Company                             | 116797862            | 76256600                 | 0                         | 1704750            | 16913793                | 13996150             | 12030031                 | 0                         | 1785089            | 32248435           | 198685                    | 25399                         | 0                              | 5                       | 357                          | 
| 2015           | Investor owned | MidAmerican Energy Company                                     | 292558259            | 117030768                | 72963854                  | 665217             | 27230197                | 36163910             | 20757300                 | 26907959                  | 955868             | 70737937           | 519821                    | 50947                         | 28                             | 51                      | 1488                         | 
| 2015           | Investor owned | Allerton                                                       | 109107               | 908387                   | 0                         | 0                  | 0                       | 12935                | 200460                   | 0                         | 0                  | 0                  | 169                       | 30                            | 0                              | 0                       | 0                            | 
| 2015           | Investor owned | Liberty Energy (Midstates) Corporation d/b/a Liberty Utilities | 2179354              | 1233890                  | 0                         | 0                  | 776225                  | 272018               | 201897                   | 0                         | 0                  | 5248382            | 3662                      | 459                           | 0                              | 0                       | 17                           | 
| 2015           | Investor owned | Black Hills/Iowa Gas Utility Company, LLC                      | 90865256             | 41533343                 | 0                         | 406498             | 4762101                 | 9648973              | 5915393                  | 0                         | 58596              | 19867265           | 137880                    | 15475                         | 0                              | 77                      | 376                          | 
| 2015           | Municipal Gas  | Bloomfield                                                     | 278498               | 135150                   | 0                         | 106508             | 0                       | 60193                | 62714                    | 0                         | 1363               | 0                  | 956                       | 178                           | 0                              | 1                       | 0                            | 
| 2015           | Municipal Gas  | Cascade                                                        | 591603               | 285201                   | 0                         | 88378              | 0                       | 54136                | 30080                    | 0                         | 9486               | 0                  | 872                       | 137                           | 0                              | 21                      | 0                            | 
| 2015           | Municipal Gas  | Cedar Falls                                                    | 6292647              | 4048770                  | 0                         | 1296719            | 0                       | 794781               | 730900                   | 0                         | 224571             | 0                  | 12893                     | 1133                          | 0                              | 131                     | 0                            | 
| 2015           | Municipal Gas  | Coon Rapids                                                    | 316653               | 98110                    | 0                         | 55168              | 0                       | 34205                | 10345                    | 0                         | 6367               | 0                  | 539                       | 89                            | 0                              | 18                      | 0                            | 
| 2015           | Municipal Gas  | Corning                                                        | 356013               | 281219                   | 0                         | 146322             | 0                       | 42274                | 41982                    | 0                         | 22060              | 0                  | 696                       | 139                           | 0                              | 35                      | 0                            |