Electric Utility Companies and Rates

**Overview**
The data package provides average residential, commercial, and industrial electricity rates by zip code for both investor-owned utilities (IOU) and non-investor owned utilities. The datasets include information such as peak load, generation, electric purchases, sales, revenues, customer counts and demand-side management programs, green pricing and net metering programs, and distributed generation capacity.

**Description**
This data package contains the Information on monthly electric consumption and cost data by borough and development, utility vendor and meter information. Information on utility or customer-owned distributed and dispersed generation such as the number, capacity, and types of generators. Data include the number of generators, number of generators less than one megawatt, total aggregate capacity, aggregate capacity used only for backup, and capacity by technology type. Information on Electric Retail Revenue Sales Customer Counts By State And Class Of Service contains information on retail revenue, sales, and customer counts. Information on the Control Area Operators or entity (usually electric utility) is responsible for the application of a common, automatic generation and transmission control scheme within a specific electrically bordered area.

Control Area Operators balance demand with available capacity, maintain system frequency and voltage within strict parameters and control power flows into, and out of, the region. Information on aggregate data of the number of customers by State and sector for Green Pricing (for 2007 forward) the revenue and sales from Green Pricing programs and (for 2010 and forward) installed capacity by generation type: photovoltaic; wind; CHP/cogen; and other. Green Pricing programs allow customers to purchase power generated from renewable resources and to pay for renewable energy development. Information on aggregate data of the number of customers by State and sector for Net Metering programs, the energy displaced by Net Metering programs, and (for 2010 and forward) installed capacity by generation type: photovoltaic; wind; CHP/cogen; and other. Net Metering programs allow customers to sell excess power they generate back to the electrical grid to offset consumption.

**Benefits**
- Useful to evaluate the utilization and costs/revenues related to electricity provision. useful also to evaluate and improve electrical infrastructure and electricity provision. contains data that can serve to evaluate electricity production-related aspects of as well.

**License Information**
The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the [Data Library](https://www.johnsnowlabs.com/marketplace/) on John Snow Labs website. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes.

**Included Datasets**
- [Dispersed Electric Generation Data By Capacity Number Type Generator](https://www.johnsnowlabs.com/marketplace/dispersed-electric-generation-data-by-capacity-number-type-generator)
- The dataset contains information on utility or customer-owned dispersed generation (NOT grid-connected) such as the number, capacity and types of generators.
- [Distributed Electric Generation Data By Capacity Number Type Generator](https://www.johnsnowlabs.com/marketplace/distributed-electric-generation-data-by-capacity-number-type-generator)
- The dataset includes information on distributed electric generation (grid-connected) by the number of generators, number of generators less than one megawatt, total aggregate capacity, aggregate capacity used only for backup, and capacity by technology type.
- [Electric Consumption And Cost 2010 to 2020](https://www.johnsnowlabs.com/marketplace/electric-consumption-and-cost-2010-to-2020)
- This Dataset contains the monthly consumption and cost data by borough and development from 2010 to 2020. The dataset also includes utility vendor and meter information.
- [Electric Investor Owned Utilities Companies and Rates 2011-2018](https://www.johnsnowlabs.com/marketplace/electric-investor-owned-utilities-companies-and-rates-2011-2018)
- The Energy Information Administration data files include information such as peak load, generation, electric purchases, sales, revenues, customer counts and demand-side management programs, green pricing and net metering programs, and distributed generation capacity.
- [Electric Investor Owned Utilities Companies and Rates 2011-2020](https://www.johnsnowlabs.com/marketplace/electric-investor-owned-utilities-companies-and-rates-2011-2020)
- The Energy Information Administration data files include information such as peak load, generation, electric purchases, sales, revenues, customer counts and demand-side management programs, green pricing and net metering programs, and distributed generation capacity.
- [Electric Non Investor Owned Utilities Companies and Rates 2011-2018](https://www.johnsnowlabs.com/marketplace/electric-non-investor-owned-utilities-companies-and-rates-2011-2018)
- The Energy Information Administration data files include information such as peak load, generation, electric purchases, sales, revenues, customer counts and demand-side management programs, green pricing and net metering programs, and distributed generation capacity.
- [Electric Non Investor Owned Utilities Companies and Rates 2011-2020](https://www.johnsnowlabs.com/marketplace/electric-non-investor-owned-utilities-companies-and-rates-2011-2020)
- The Energy Information Administration data files include information such as peak load, generation, electric purchases, sales, revenues, customer counts and demand-side management programs, green pricing and net metering programs, and distributed generation capacity.
- [Electric Power Annual Utilization Sales And Revenue](https://www.johnsnowlabs.com/marketplace/electric-power-annual-utilization-sales-and-revenue)
- The Energy Information Administration data files includes demand, generation, electric purchases, sales, revenues, source of energy and losses of electric power for the year of 2011.
- [Electric Power Utilization Sales And Revenue By Class Of Service](https://www.johnsnowlabs.com/marketplace/electric-power-utilization-sales-and-revenue-by-class-of-service)
- Electric Retail Revenue Sales Customer Counts By State And Class Of Service contains information on retail revenue, sales, and customer counts, by State and class of service (including the Transportation sector, new in 2003), for each electric distribution utility, or energy service provider in all 50 States, the District of Columbia, the Dominion of Puerto Rico, and the Territories of American Samoa, Guam, and the Virgin Islands.
- [Electricity Control Area Operator Data 2011](https://www.johnsnowlabs.com/marketplace/electricity-control-area-operator-data-2011)
- The Energy Information Administration data files include information such as peak load, generation, electric purchases, sales, revenues, customer counts and demand-side management programs, green pricing and net metering programs, and distributed generation capacity.
- [Green Pricing Revenue Sales Capacity By Generation Type State Sector](https://www.johnsnowlabs.com/marketplace/green-pricing-revenue-sales-capacity-by-generation-type-state-sector)
- The Energy Information Administration dataset files include information such as peak load, generation, electric purchases, sales, revenues, customer counts and demand-side management programs, green pricing and net metering programs, and distributed generation capacity.
- [Net Metering Energy Displaced Capacity By Generation Type State Sector](https://www.johnsnowlabs.com/marketplace/net-metering-energy-displaced-capacity-by-generation-type-state-sector)
- The Energy Information Administration dataset files include information such as peak load, generation, electric purchases, sales, revenues, customer counts and demand-side management programs, green pricing and net metering programs, and distributed generation capacity.

**Data Engineering Overview**
**We deliver high-quality data**
- Each dataset goes through 3 levels of quality review
- 2 Manual reviews are done by domain experts
- Then, an automated set of 60+ validations enforces every datum matches metadata & defined constraints
- Data is normalized into one unified type system
- All dates, unites, codes, currencies look the same
- All null values are normalized to the same value
- All dataset and field names are SQL and Hive compliant
- Data and Metadata
- Data is available in both CSV and Apache Parquet format, optimized for high read performance on distributed Hadoop, Spark & MPP clusters
- Metadata is provided in the open Frictionless Data standard, and its every field is normalized & validated
- Data Updates
- Data updates support replace-on-update: outdated foreign keys are deprecated, not deleted

**Our data is curated and enriched by domain experts**

Each dataset is manually curated by our team of doctors, pharmacists, public health & medical billing experts:
- Field names, descriptions, and normalized values are chosen by people who actually understand their meaning
- Healthcare & life science experts add categories, search keywords, descriptions and more to each dataset
- Both manual and automated data enrichment supported for clinical codes, providers, drugs, and geo-locations
- The data is always kept up to date – even when the source requires manual effort to get updates
- Support for data subscribers is provided directly by the domain experts who curated the data sets
- Every data source’s license is manually verified to allow for royalty-free commercial use and redistribution.

**Need Help?**
If you have questions about our products, contact us at [[e-mail]](mailto:[e-mail]).