Data Share Usage Example Q1: How do I pull recievables of all companies in Texas for the last two fiscal years? SELECT SNL_ENERGYREGULATORY_CORPORATE.”1_SNLInstitutionKey”, SNL_ENERGYREGULATORY_CORPORATE.”2_CompanyName”, SNL_ENERGYREGULATORY_CORPORATE.”33_City”, SNL_ENERGYREGUL
Analyze over 450 power and mid-stream companies including revenue, volume and customer counts by customer class. Revenue and expenses are broken down by operations; production, transmission and distribution. – Operational and financial data on US electric and natural gas utilities from the FERC Form 1, FERC Form 2, FERC Form 3, FERC Form 714, EIA 861 and EIA 176 as well as SEC 10Ks and 10Qs – US Power plant data from the FERC Form 1, EIA 923, EIA 860, EPA CEMS and NRC – Power plant new builds and retirements sourced from research on web sites and contacts at developers or operators – US natural gas operational data is from the FERC Form 549B, FERC Form 552, and pipeline companies bulletin boards (EBBs) – Coal operational data is sourced from MSHA and EIA 923. Power prices and loads sourced from the following ISOs: Alberata Power Pool, California ISO, ERCOT ISO, ISO New England, New York ISO, Midwest ISO, Ontario ISO, PJM ISO and SPP ISO Dataset Overview: – Primary Entity Type: Physical Asset – Coverage Count: 100,000 – Geographic Coverage: United States and Canada – Industry Coverage: Energy and Utilities – History Initiated: 1994 – Data Source: Federal Energy Regulatory Commission (FERC), Energy Information Administration (EIA), Environmental Protection Agency (EPA), Company Electronic Bulletin Boards (EBBs), Independent System Operators (ISOs), State Public Utilities Commission, and more