
Dataset Name: srs_fac_us_electricity
Group: altdata
Vendor: Spatial Risk Systems
Data Starts at: 2010-01-01 00:00:00
Symbol Set: US Equities
Asset Class: Equity, ADRs, ETFs,Fixed Income,Options,FX,Futures,Crypto,Commodity,Options on Futures
Data Update Frequency: week
Facility Level Datasets
Facility Locations by Sector/Classification (Power, Energy, Superfund Sites, etc..)
- srs_fac_us_electricity
- srs_fac_us_energy
- srs_fac_us_sfs - Super Fund Sites
- Datasets can be generated for dozens of sectors and industries ie...
Facility-level data includes:
- Location
- Sector/industry Classification
- Corporate Ownership (where currently available)
- Toxic Release
- GHG Emissions
- EPA Inspection Reports
Investable Universe:
US Municipal Finance ESG/Sustainable Investing Corporate Fixed Income/Equities Insurance/Reinsuracne Real Estate/Property Development
Dataset Asset Classes:
Equities - Stocks, ADRs, ETFs etc;Fixed Income
Data Update Frequency:
Weekly/Monthly
Date Range
Sample datasets are for one day 2022/10/04
Full Datasets go back to 2010/01/01
About Spatial Risk Systems
SRS is an innovative data and analytics company focused on building a playing field level data base enabling institutions to accurately assess risks and opportunities at the underlying asset locations of their investment, transaction, and operating activities.
Founded by data science leaders from the financial sector, SRS quantifies risk by unifying, standardizing, and analyzing empirical data sources, helping investors to better understand ESG and sustainable investing outcomes, from a facility to a large-scale geographic perspective.
Spatial Risk Systems created and operates a massive cloud-based data management infrastructure hosting hundreds of complex data sets with billions of interconnected data records.
The technical architecture, operations and information governance policies of the SRS data management platform have been established by the team of seasoned industry professionals with combined 100 years of experience designing and operating commercial data products.
Particular attention has been given to ensure content integrity by applying the stringent system of quality controls on each of the steps of data collection, ingest and transformation. The SRS team has implemented sound operational resilience, data access and security practices to ensure integrity and effective performance.
Spatial Risk Systems (SRS) has engineered a massive cloud-based data network connecting and standardizing fact-based spatial-level data sources into a single publishing solution.
Spatial Risk Scores measures and quantifies hundreds of location-specific factors that can have a long-term effect on asset value, environmental impact, operational effectiveness, and social sustainability.
10 Different Spatial Layers:
- Census Tract
- Postal Code
- City
- School District
- County
- Congressional District
- State
- Core-Based Statistical Areas (CBSA)
- Corporate
- Municipal Revenue Authorities
Five Major Data Dimensions:
1) Climate
- 18 Natural Disaster Risks
- Expected Annual Losses (EAL)
- 1.5 million+ Weather Events and Impacts
2) Environmental
- Scope I Carbon Emissions
- Toxic Releases
- Air and Water Quality Measures
3) Socio-Economic
- Community Vulnerability-Related Factors
- Community Resiliency-Related Factors
4) Carbon Emissions/Accounting
- Scope I
- Scope II
- Social Costs of Carbon
5) Facility Location, Function, and Ownership
Scope 1 - direct emissions
Scope 1 (direct) emissions are an immediate product of entity activities such as energy generated by burning fossil or other organic fuels, fuels used for transportation, cement production, etc.
Scope 2 - indirect emissions
Scope 2 emissions (indirect) result from energy consumption, heating and cooling, food preparation, and other needs.
Data Contained in this Dataset
Column | Type | Description |
---|---|---|
_seq | uint | Internal sequence number used to keep data rows in order |
timestamp | string | Timestamp of the Data (underlying field is nc_publish_date_actual) |
muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. (underlying field is nc_publish_date_actual) |
symbol | string | Trading Symbol |
ISO | string | ISO |
Entity Name | string | Entity Name |
Latitude | double | Latitude |
Longitude | double | Longitude |
Tax II Code | string | Tax II Code |
Tax II | string | Tax II |
Tax III Code | string | Tax III Code |
Tax III | string | Tax III |
Tax IV Code | string | Tax IV Code |
Tax IV | string | Tax IV |
Street | string | Street |
Census Tract ID | double | Census Tract ID |
Census Tract | double | Census Tract |
Tract Code | double | Tract Code |
City ID | double | City ID |
City GEOID | double | City GEOID |
City | string | City |
County ID | int64 | County ID |
County FIPS | double | County FIPS |
County | string | County |
State ID | int64 | State ID |
State FIPS | double | State FIPS |
State | string | State |
Postal Code | int64 | Postal Code |
Parent ID | int64 | Parent ID |
Parent Name | string | Parent Name |
Ult ID | int64 | Ult ID |
Ult Name | string | Ult Name |
2015 Net MW | double | 2015 Net MW |
2016 Net MW | double | 2016 Net MW |
2017 Net MW | double | 2017 Net MW |
2018 Net MW | double | 2018 Net MW |
2019 Net MW | double | 2019 Net MW |
2020 Net MW | double | 2020 Net MW |
2016 MW/GHG | double | 2016 MW/GHG |
2017 MW/GHG | double | 2017 MW/GHG |
2018 MW/GHG | double | 2018 MW/GHG |
2019 MW/GHG | double | 2019 MW/GHG |
2020 MW/GHG | double | 2020 MW/GHG |
2011 GHG | double | 2011 GHG |
2012 GHG | double | 2012 GHG |
2013 GHG | double | 2013 GHG |
2014 GHG | double | 2014 GHG |
2015 GHG | double | 2015 GHG |
2016 GHG | double | 2016 GHG |
2017 GHG | double | 2017 GHG |
2018 GHG | double | 2018 GHG |
2019 GHG | double | 2019 GHG |
2020 GHG | double | 2020 GHG |
EPA Major Facility | string | EPA Major Facility |
EPA Active Facility | string | EPA Active Facility |
Last Inspection Date | string | Last Inspection Date |
Last Inspection Date by EPA | string | Last Inspection Date by EPA |
Last Inspection Date by State Agency | string | Last Inspection Date by State Agency |
Inspection Count | double | Inspection Count |
Days Since Last Inspection | double | Days Since Last Inspection |
Informal Action Count | double | Informal Action Count |
Last Informal Action Date | string | Last Informal Action Date |
Last Informal Action Date by EPA | string | Last Informal Action Date by EPA |
Last Informal Action Data by State Agency | string | Last Informal Action Data by State Agency |
Formal Action Count | double | Formal Action Count |
Last Formal Action Date | string | Last Formal Action Date |
Last Formal Action Date by EPA | string | Last Formal Action Date by EPA |
Last Formal Action Date by State Agency | string | Last Formal Action Date by State Agency |
Total Penalties USD | double | Total Penalties USD |
Facility Penalty Count | double | Facility Penalty Count |
Facility Last Penalty Date | string | Facility Last Penalty Date |
Facility Last Penalty Amount USD | double | Facility Last Penalty Amount USD |
Facility # of Qtrs w/Non-Compliance | double | Facility # of Qtrs w/Non-Compliance |
Facility Significant Non-Compliance Flag | string | Facility Significant Non-Compliance Flag |
Facility 3 yr Compliance History S=Serious Violation, V=Violation, U=Unknown, _=No Violation | string | Facility 3 yr Compliance History S=Serious Violation, V=Violation, U=Unknown, _=No Violation |
Facility has a Toxic Release Inventory (TRI) | string | Facility has a Toxic Release Inventory (TRI) |
Facility was a Previous Toxic Release Inventory (TRI) Reporter | string | Facility was a Previous Toxic Release Inventory (TRI) Reporter |
Total TRI Releases in Lbs for latest Reporting Year | double | Total TRI Releases in Lbs for latest Reporting Year |
Total TRI Releases in Lbs Kept Onsite for latest Reporting Year | double | Total TRI Releases in Lbs Kept Onsite for latest Reporting Year |
Total TRI Releases in Lbs Transferred Offsite for latest Reporting Year | double | Total TRI Releases in Lbs Transferred Offsite for latest Reporting Year |
Facility has Greenhouse Gas (GHG) Reporting Tool ID | string | Facility has Greenhouse Gas (GHG) Reporting Tool ID |
GHG Emissions in Metric Tons for latest Reporting Year | double | GHG Emissions in Metric Tons for latest Reporting Year |
Facility has a Clean Air Permit Flag | string | Facility has a Clean Air Permit Flag |
Clean Air Act (CAA) Evaluation Count | double | Clean Air Act (CAA) Evaluation Count |
Facility is a CAA High Priority Violator | string | Facility is a CAA High Priority Violator |
CAA 3 yr Compliance History S=Serious Violation, V=Violation, U=Unknown, _=No Violation | string | CAA 3 yr Compliance History S=Serious Violation, V=Violation, U=Unknown, _=No Violation |
CAA Day since Last Evaluation | double | CAA Day since Last Evaluation |
CAA Informal Action Count | double | CAA Informal Action Count |
CAA Formal Action Count | double | CAA Formal Action Count |
CAA Date of Last Formal Action | string | CAA Date of Last Formal Action |
CAA Date of Last Penalty | string | CAA Date of Last Penalty |
CAA Last Penalty Amount USD | double | CAA Last Penalty Amount USD |
CAA Qtrs w/Non-Compliance | double | CAA Qtrs w/Non-Compliance |
CAA Compliance Status | string | CAA Compliance Status |
Facility has NPDES - National Pollutant Discharge Elimination System Permit | string | Facility has NPDES - National Pollutant Discharge Elimination System Permit |
Clean Water Act (CWA) Inspection Count | double | Clean Water Act (CWA) Inspection Count |
CWA Significant Non-Complinace Flag | string | CWA Significant Non-Complinace Flag |
CWA 3 yr Compliance History S=Serious Violation, V=Violation, U=Unknown, _=No Violation | string | CWA 3 yr Compliance History S=Serious Violation, V=Violation, U=Unknown, _=No Violation |
CWA Days since Last Inspection | double | CWA Days since Last Inspection |
CWA Informal Action Count | double | CWA Informal Action Count |
CWA Formal Action Count | double | CWA Formal Action Count |
CWA Date of Last Formal Action | string | CWA Date of Last Formal Action |
CWA Last Penalty Date | string | CWA Last Penalty Date |
CWA Last Penalty Amount USD | double | CWA Last Penalty Amount USD |
CWA Qtrs w/Non-Compliance | double | CWA Qtrs w/Non-Compliance |
CWA Complinace Status | string | CWA Complinace Status |
CWA The number of effluent exceedance violations for Past 13 Qtrs | double | CWA The number of effluent exceedance violations for Past 13 Qtrs |
Facility has RCRA - Resource Conservation and Recovery Act Permit | string | Facility has RCRA - Resource Conservation and Recovery Act Permit |
RCRA Inspection Count | double | RCRA Inspection Count |
RCRA Significant Non-Compliance Flag | string | RCRA Significant Non-Compliance Flag |
RCRA 3 yr Compliance History S=Serious Violation, V=Violation, U=Unknown, _=No Violation | string | RCRA 3 yr Compliance History S=Serious Violation, V=Violation, U=Unknown, _=No Violation |
RCRA Days since Last Evaluation | double | RCRA Days since Last Evaluation |
RCRA Informal Action Count | double | RCRA Informal Action Count |
RCRA formal Action Count | double | RCRA formal Action Count |
RCRA Data of Last Formal Action | string | RCRA Data of Last Formal Action |
RCRA Data of Last Penalty | string | RCRA Data of Last Penalty |
RCRA Last Penaly Amount USD | double | RCRA Last Penaly Amount USD |
RCRA Qtrs w/Non-Compliance | double | RCRA Qtrs w/Non-Compliance |
RCRA Compliance Status | string | RCRA Compliance Status |
Facility has SDWA - Safe Drinking Water Information System Permit | string | Facility has SDWA - Safe Drinking Water Information System Permit |
SDWA System Types | string | SDWA System Types |
SDWA Significant Non-Compliance Flag | string | SDWA Significant Non-Compliance Flag |
SDWA Informal Action Count | double | SDWA Informal Action Count |
SDWA Formal Action Count | double | SDWA Formal Action Count |
SDWA Compliance Status | string | SDWA Compliance Status |