{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["File Info","Target Facilities","TRI detail","RCRA detail","GHGRP detail","NEI detail","NPDES DMR detail"],"not_rendered":{"external_links":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"File Info","index":0,"n_rows":30,"n_cols":5,"rows_kept":30}
["This file presents data for AS only."]
["January 2023"]
["Background:","This file is intended to assist P2 providers in identifying facilities in the state that may be interested in implementing P2 projects. The file consolidates data from six different EPA"]
[null,"datasystems (shown in green below); individual facilities may be present in one or all six datasystems. The file couples this facilty identification information with data on the demographics"]
[null,"of the area where the facility is located, as defined by the Census Block Group. A Census Block Group is an area, generally defined to contain between 600 and 3,000 people, which the Census"]
[null,"Bureau uses to present data on demographics. The demographics data helps P2 providers understand the population near each facility."]
["How to use this file:","The \"Target Facilities\" tab lists the facilities in the state that are present in at least one of the six EPA datasystems shown in green below. Use the arrow in any column heading to filter on a"]
[null,"column of interest. For example, users can filter by location (e.g., by filtering on the Facility City or Facility ZIP code columns), by industrial sector (e.g., by filtering the NEA Sectors or Sector"]
[null,"columns, with sectors designated by North American Industry Classification System (NAICS) codes), or by demographics (e.g., by filtering on the Demographic Index column). For facilities of"]
[null,"interest, use the remaining tabs in the file to see further details on each facility's environmental profile using the \"FRS ID\" as the common identifier across the datasystems. FRS mismatches "]
[null,"occur occasionally when there are inconsistencies across data systems."]
["Program","Data Source","Data Timeframe","Notes","For more information:"]
["TRI Detail","2021 TRI data (published October 2022)","Jan 1, 2021 - Dec 31, 2021","Based on data contained in flat files provided to ERG by EPA.","https://www.epa.gov/toxics-release-inventory-tri-program/common-tri-terms"]
["NEI Detail","2017 NEI (Jan 2021 Version)","Jan 1, 2017 - Dec 31, 2017","The EPA's FRS_PROGRAM_LINKS.csv file downloaded on 9/29/2021 was used to map EIS facility IDs to FRS facility IDs.","https://www.epa.gov/air-emissions-inventories/national-emissions-inventory-nei"]
["GHGRP Detail","2021 Data Summary Spreadsheets zip file","Jan 1, 2021 - Dec 31, 2021","Data downloaded on 11/20/2022 from https://www.epa.gov/ghgreporting/data-sets. Used the ghgrp_data_2021.xlsx file, Direct Emitters tab only.","https://www.epa.gov/ghgreporting/learn-about-greenhouse-gas-reporting-program-ghgrp"]
["RCRA Detail","RCRA e-Manifests shipped between July 1, 2021 and July 1, 2022","July 1, 2021 - July 1, 2022","Facility name, location information, and NAICS from e-Manifest data module on RCRA Metabase, while FRS information was linked with RCRAInfo data. Data queried November 8, 2022 and took 90 day \"soft embargo\" period into account.","https://www.epa.gov/e-manifest/frequent-questions-about-e-manifest#scope"]
["NPDES DMR Detail","2021 DMR ","Jan 1, 2021 - Dec 31, 2021","Data downloaded on November 8, 2022 using a Custom Search of EPA's Pollutant Loading Tool. Sector designation for these facilities often uses the Standard Industrial Classification (SIC) code instead of a NAICS code. Data includes facility-level total pollutant loading values (kg/yr) for non-POTW industrial point source facilities, excluding facilities with null pollutant loading values (null means DMR data were not reported, so a load cannot be calculated). Criteria used for the custom search were: \"Level of Detail= Facility\"; \"Reporting Year= 2021\"; \"Facility Type= NON_POTW\"; \"Data for Loading Calculations= DMR data only\"; \"Non-Detects Equal to= Zero\"; \"Estimation Function= On\"; \"Parameter Grouping Function= Off\"; \"Nutrient Aggregation Function= Off\"","https://echo.epa.gov/trends/loading-tool/resources/about-the-data#scopedmr"]
["Explanation of Select Columns","Column Description"]
["Demographic Index (US percentile)","The Demographic index (US percentile) is a national percentile based on the average of two demographic indicators for the Census Block Group: Percent People of Color and Percent Low Income. ​For example, if a Census Block Group has 70% People of Color and 50% of the population is in a low income household, the average of those two metrics is 60%. Nationally, an average of 60% is in the 83rd percentile, meaning 83% of Census Block Groups have an average of those two metrics that is less than 60%."]
["TRI Reporter (TRIFID)","This column contains the TRI facility IDs linked to the FRS ID. If blank, the facility did not report to TRI for 2021."]
["RCRA Shipments (RCRA ID)","This column contains the RCRA IDs linked to the FRS ID. If blank, the facility did not submit any RCRA e-manifest forms in the selected timeframe."]
["GHG Reporter (GHGRP ID)","This column contains the GHGRP IDs linked to the FRS ID. If blank, the facility did not report to GHGRP for 2021."]
["Air Emissions Source \n(EIS ID)","This column contains the EIS IDs linked to the FRS ID. If blank, the facility was not included as an identified point source in the 2017 NEI."]
["Water Discharger (NPDES ID)","This column contains the NPDES IDs linked to the FRS ID. If blank, the facility did not file any DMRs for 2021."]
["NEA?","This column indicates whether any NAICS code reported for the facility is in an NEA."]
["Manufacturing?","This column indicates whether any NAICS code reported for the facility is in the manufacturing sector. Only facilities in manufacturing or NEA sectors are included as potential targets in this file."]
["NEA Sectors","This column indicates which, if any, NEAs the facility may be in. This field is populated based on the NAICS codes from the five inventories included in this file. The inventory detail tabs show this field for reference, and it does not necessarily correspond to the primary NAICS for a single inventory."]
["Other NAICS Sectors","If only one NAICS code was reported across programs, this column indicates the facility's sector. If different NAICS codes were reported across programs or within a program, this is reported as \"multiple\""]
["Percent People of Color in Census Block Group","People of Color are all people in the Census block group except non-Hispanic white-alone"]
["Percent Low Income in Census Block Group","Low Income is the population in households in the Census block group where the household income is less than or equal to twice the federal poverty level."]

{"sheet":"Target Facilities","index":1,"n_rows":5,"n_cols":48,"rows_kept":5}
["State","Demographic Index (US percentile)","Flag for Census Block Group ≥80th percentile (US, demographic index)","FRS ID","Facility Name","Facility Street Address","Facility City","Facility State","Facility County","Facility ZIP Code","Has TRI Contact","Has RCRA contact","NEA?","Manufacturing?","NEA Sectors","Sector","TRI NAICS","RCRA NAICS","GHGRP NAICS","NEI NAICS","DMR NAICS","TRI Reporter (TRIFID)","RCRA Shipments (RCRA ID)","GHG Reporter (GHGRP ID)","Air Emissions Source (EIS ID)","Water Discharger (NPDES ID)","Census Block Group","Population of Census Block Group","Demographic Index for Census Block Group","Supplemental Demographic Index","Percent People of Color in Census Block Group","Percent Low Income in Census Block Group","Percent Less than High School in Census Block Group","Percent Linguistic Isolation in Census Block Group","Demographic Index for Census Block Group (US percentile)","US Percentile Supplemental Demographic Index","People of Color in Census Block Group (US percentile)","Low Income in Census Block Group (US percentile)","Less than High School in Census Block Group (US percentile)","Linguistic Isolation in Census Block Group (US percentile)","Demographic Index for Census Block Group (state percentile)","State Percentile Supplemental Demographic Index","Flag for Census Block Group ≥80th percentile (State, demographic index)","State 80th Percentile Supplemental Demographic Index","People of Color in Census Block Group (state percentile)","Low Income in Census Block Group (state percentile)","Less than High School in Census Block Group (state percentile)","Linguistic Isolation in Census Block Group (state percentile)"]
["AS",null,{"$f":"IF(Table1[[#This Row],[Demographic Index (US percentile)]]=\"\",\"No\",IF(Table1[[#This Row],[Demographic Index (US percentile)]]>=80,\"Yes\", \"No\"))","v":"No"},"110045691391","STARKIST SAMOA INC","MAIN ROAD","PAGO PAGO","AS","EASTERN","96799","Yes","No","Yes","Yes","Food & Beverage","Seafood Product Preparation and Packaging","311710","","","","311710","96799STRKSMAINS","","","","AS0000019","","","","","","","","","","","","","","","","","","","","","",""]
["AS",null,{"$f":"IF(Table1[[#This Row],[Demographic Index (US percentile)]]=\"\",\"No\",IF(Table1[[#This Row],[Demographic Index (US percentile)]]>=80,\"Yes\", \"No\"))","v":"No"},"110070265732","TUNA PROCESSING FACILITY","PO BOX 368","PAGO PAGO","AS","EASTERN","96799","No","No","Yes","Yes","Food & Beverage","Seafood Product Preparation and Packaging","","","","","311710","","","","","ASR05J000","","","","","","","","","","","","","","","","","","","","","",""]
["AS",null,{"$f":"IF(Table1[[#This Row],[Demographic Index (US percentile)]]=\"\",\"No\",IF(Table1[[#This Row],[Demographic Index (US percentile)]]>=80,\"Yes\", \"No\"))","v":"No"},"110010063787","AMERICAN SAMOA SHIPYARD SERVICES","MARINE RAILWAY FACILITIES","PAGO PAGO","AS","AMERICAN SAMOA","96799","No","No","No","Yes","None","Ship and Boat Building","","","","","336611","","","","","AS0020036","","","","","","","","","","","","","","","","","","","","","",""]
["AS",null,{"$f":"IF(Table1[[#This Row],[Demographic Index (US percentile)]]=\"\",\"No\",IF(Table1[[#This Row],[Demographic Index (US percentile)]]>=80,\"Yes\", \"No\"))","v":"No"},"110064600472","SAMOA TUNA PROCESSORS FACILITY","PO BOX 957","PAGO PAGO","AS","EASTERN","96799","No","No","Yes","Yes","Food & Beverage","Seafood Product Preparation and Packaging","","","","","311710","","","","","AS0000027","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"TRI detail","index":2,"n_rows":5,"n_cols":41,"rows_kept":5}
["TRI FACILITY ID","TRI Facility Report","FRS ID","Facility Name","Street Address","City","County","State","Zip Code","NEA Sectors (NEA designation is from the Target Facilities List)","Sector (3-digit NAICS)","Subsector (6-digit NAICS)","Primary NAICS Code","Primary NAICS Description","Submitted Parent Company","Document Control Number","Chemical Name","TRI Chemical ID","Fugitive Air Releases (lb, 2021)","Stack Air Releases (lb, 2021)","Total Onsite Air Releases (lb, 2021)","Onsite Water Releases (lb, 2021)","Total Onsite Land Releases (lb, 2021)","Total On-site Releases (lb, 2021)","Total Off-site Releases (gross) (lb, 2021)","Total On-and Off- Site Releases (gross) (lb, 2021)","On-site \"Contained\" Releases (8.1a) (lb, 2021)","Other On-site Releases (8.1b) (lb, 2021)","Off-site \"Contained\" Releases (8.1c) (lb, 2021)","Other Off-site Releases (8.1d) (lb, 2021)","On-site Energy Recovery (lb, 2021)","Off-site Energy Recovery (lb, 2021)","On-site Recycling (lb, 2021)","Off-site Recycling (lb, 2021)","On-site Treatment (lb, 2021)","Off-site Treatment (lb, 2021)","Total Production-Related Waste (lb, 2021)","Non-Production Related Waste (lb, 2021)","Public Contact Name","Public Contact Phone","Public Contact e-mail"]
["96799STRKSMAINS",{"$f":"HYPERLINK(_xlfn.CONCAT(\"https://enviro.epa.gov/facts/tri/ef-facilities/#/Facility/\",A2),\"TRI Facility Report\")","v":"TRI Facility Report"},"110045691391","STAR KIST SAMOA CO","ATUU","PAGO PAGO","EASTERN","AS","96799","Food & Beverage","Food Manufacturing","Seafood Product Preparation and Packaging","311710","Seafood Product Preparation and Packaging","STARKIST CO","1321219704259","Ammonia","0007664417",6090,0,6090,61758,0,67848,569,68417,null,67848,null,569,{"$nulls":6},68417,null,"MOLLY SCHUSTER","6842585595","MOLLY.SCHUSTER@STARKIST.COM"]
["96799STRKSMAINS",{"$f":"HYPERLINK(_xlfn.CONCAT(\"https://enviro.epa.gov/facts/tri/ef-facilities/#/Facility/\",A3),\"TRI Facility Report\")","v":"TRI Facility Report"},"110045691391","STAR KIST SAMOA CO","ATUU","PAGO PAGO","EASTERN","AS","96799","Food & Beverage","Food Manufacturing","Seafood Product Preparation and Packaging","311710","Seafood Product Preparation and Packaging","STARKIST CO","1321219705819","Formic acid","0000064186",968,0,968,0,0,968,0,968,null,968,{"$nulls":8},968,null,"MOLLY SCHUSTER","6842585595","MOLLY.SCHUSTER@STARKIST.COM"]
["96799STRKSMAINS",{"$f":"HYPERLINK(_xlfn.CONCAT(\"https://enviro.epa.gov/facts/tri/ef-facilities/#/Facility/\",A4),\"TRI Facility Report\")","v":"TRI Facility Report"},"110045691391","STAR KIST SAMOA CO","ATUU","PAGO PAGO","EASTERN","AS","96799","Food & Beverage","Food Manufacturing","Seafood Product Preparation and Packaging","311710","Seafood Product Preparation and Packaging","STARKIST CO","1321219705821","Nitric acid","0007697372",0,0,0,0,0,0,0,0,null,0,{"$nulls":8},0,null,"MOLLY SCHUSTER","6842585595","MOLLY.SCHUSTER@STARKIST.COM"]
["96799STRKSMAINS",{"$f":"HYPERLINK(_xlfn.CONCAT(\"https://enviro.epa.gov/facts/tri/ef-facilities/#/Facility/\",A5),\"TRI Facility Report\")","v":"TRI Facility Report"},"110045691391","STAR KIST SAMOA CO","ATUU","PAGO PAGO","EASTERN","AS","96799","Food & Beverage","Food Manufacturing","Seafood Product Preparation and Packaging","311710","Seafood Product Preparation and Packaging","STARKIST CO","1321219705833","Polycyclic aromatic compounds","N590",0,0.23,0.23,0,0,0.23,0,0.23,null,0.23,{"$nulls":8},0.23,null,"MOLLY SCHUSTER","6842585595","MOLLY.SCHUSTER@STARKIST.COM"]

{"sheet":"RCRA detail","index":3,"n_rows":1,"n_cols":16,"rows_kept":1}
["RCRA ID","FRS ID","Facility Name","Street Address","City","County","State","NEA Sectors (NEA designation is from the Target Facilities List)","Primary NAICS Code","Primary NAICS Description","Last Shipment date (as of July 1, 2022)","Waste Shipped (tons, July 1, 2021 - July 1, 2022)","Count of Manifests shipped (July 1, 2021 - July 1, 2022)","Contact Name","Contact Phone","Contact Email"]

{"sheet":"GHGRP detail","index":4,"n_rows":1,"n_cols":66,"rows_kept":1}
["GHGRP ID","FRS ID","Facility Name","Street Address","City","County","State","Zip Code","NEA Sectors (NEA designation is from the Target Facilities List)","Primary NAICS Code","Primary NAICS Description","Industry Type (subparts)","Industry Type (sectors)","Total Reported Direct Emissions (MTCO2e, 2021)","CO2 Emissions (non-biogenic) (MTCO2e, 2021)","Methane (CH4) Emissions (MTCO2e, 2021)","Nitrous Oxide (N2O) Emissions (MTCO2e, 2021)","HFC Emissions (MTCO2e, 2021)","PFC Emissions (MTCO2e, 2021)","SF6 Emissions (MTCO2e, 2021)","NF3 Emissions (MTCO2e, 2021)","Other Fully Fluorinated GHG Emissions (MTCO2e, 2021)","HFE Emissions (MTCO2e, 2021)","Very Short-lived Compounds Emissions (MTCO2e, 2021)","Other GHGs (MTCO2e, 2021)","Biogenic CO2 emissions (MTCO2e, 2021)","Stationary Combustion (MTCO2e, 2021)","Electricity Generation (MTCO2e, 2021)","Adipic Acid Production (MTCO2e, 2021)","Aluminum Production (MTCO2e, 2021)","Ammonia Manufacturing (MTCO2e, 2021)","Cement Production (MTCO2e, 2021)","Electronics Manufacture (MTCO2e, 2021)","Ferroalloy Production (MTCO2e, 2021)","Fluorinated GHG Production (MTCO2e, 2021)","Glass Production (MTCO2e, 2021)","HCFC–22 Production from HFC–23 Destruction (MTCO2e, 2021)","Hydrogen Production (MTCO2e, 2021)","Iron and Steel Production (MTCO2e, 2021)","Lead Production (MTCO2e, 2021)","Lime Production (MTCO2e, 2021)","Magnesium Production (MTCO2e, 2021)","Miscellaneous Use of Carbonates (MTCO2e, 2021)","Nitric Acid Production (MTCO2e, 2021)","Petroleum and Natural Gas Systems – Offshore Production (MTCO2e, 2021)","Petroleum and Natural Gas Systems – Processing (MTCO2e, 2021)","Petroleum and Natural Gas Systems – Transmission/Compression (MTCO2e, 2021)","Petroleum and Natural Gas Systems – Underground Storage (MTCO2e, 2021)","Petroleum and Natural Gas Systems – LNG Storage (MTCO2e, 2021)","Petroleum and Natural Gas Systems – LNG Import/Export (MTCO2e, 2021)","Petrochemical Production (MTCO2e, 2021)","Petroleum Refining (MTCO2e, 2021)","Phosphoric Acid Production (MTCO2e, 2021)","Pulp and Paper Manufacturing (MTCO2e, 2021)","Silicon Carbide Production (MTCO2e, 2021)","Soda Ash Manufacturing (MTCO2e, 2021)","Titanium Dioxide Production (MTCO2e, 2021)","Underground Coal Mines (MTCO2e, 2021)","Zinc Production (MTCO2e, 2021)","Municipal Landfills (MTCO2e, 2021)","Industrial Wastewater Treatment (MTCO2e, 2021)","Manufacture of Electric Transmission and Distribution Equipment (MTCO2e, 2021)","Industrial Waste Landfills (MTCO2e, 2021)","Is some CO2 collected on-site and used to manufacture other products and therefore not emitted from the affected manufacturing process unit(s)? (as reported under Subpart G or S)","Is some CO2 reported as emissions from the affected manufacturing process unit(s) under Subpart AA, G or P collected and transferred off-site or injected (as reported under Subpart PP)?","Does the facility employ continuous emissions monitoring? "]

{"sheet":"NEI detail","index":5,"n_rows":1,"n_cols":20,"rows_kept":1}
["EIS Facility ID","FRS ID","Facility Name","Street Address","City","County","State","Zip Code","NEA Sectors (NEA designation is from the Target Facilities List)","Primary NAICS Code","Primary NAICS Description","Source Classification Code (SCC)","SCC Description","CO Emissions (tons, 2017)","NH3 Emissions (tons, 2017)","NOX Emissions (tons, 2017)","PM10-PRI Emissions (tons, 2017)","SO2 Emissions (tons, 2017)","VOC Emissions (tons, 2017)","Total HAP Emissions (tons, 2017)"]

{"sheet":"NPDES DMR detail","index":6,"n_rows":5,"n_cols":28,"rows_kept":5}
["NPDES Permit Number","FRS ID","Facility Name","Street Address","City","County","State","Zip Code","NEA Sectors (NEA designation is from the Target Facilities List)","Primary SIC Code (when available)","Primary SIC Description","Primary NAICS Code (when available)","Primary NAICS Description","Total Facility Load (kg, 2020)","Max Allowable Load (kg/yr)","Total Facility Flow (Mgal, 2020)","Actual Average Facility Flow (MGD)","Permit Type","Has Permit Limits","Permit Effective Date","Permit Expiration Date","Major/Non-Major Status","Watershed Name","Water Body Name","Reach Code","Listed for Impairment","Has Loadings Data","Contains Potential Outliers?"]
["AS0000019","110045691391","STARKIST SAMOA INC","MAIN ROAD","PAGO PAGO","EASTERN","AS","96799","Food & Beverage","2091","Canned And Cured Fish And Seafoods",null,"",1228820.24466317,1138535.14739229,491.38,"2.9","NPD","Yes","2020-06-20","2025-06-19","Major","Tutuila Island-Frontal South Pacific Ocean","PAGO PAGO HARBOR","22030000000968",null,"Yes"]
["AS0000027","110064600472","SAMOA TUNA PROCESSORS FACILITY","P.O. BOX 957","PAGO PAGO","EASTERN","AS","96799","Food & Beverage","2091","Canned And Cured Fish And Seafoods",null,"",14457.0487826237,397171.44217687,37.03103,"0.1","NPD","Yes","2021-06-01","2026-05-31","Non-Major",null,"PAGO PAGO HARBOR","22030000001257",null,"Yes"]
["AS0020036","110010063787","AMERICAN SAMOA SHIPYARD SERVICES","VILLAGE OF SATALA","PAGO PAGO","AMERICAN SAMOA","AS","96799","None","3731","Ship Building And Repairing",null,"",1624.46750664342,674.427396368945,22.3164845,null,"NPD","Yes","2010-10-01","2015-09-30","Major","Tutuila Island-Frontal South Pacific Ocean","PAGO PAGO BAY, PAGO PAGO HARBOR","22030000000966",null,"Yes"]
["ASR05J000","110070265732","TUNA PROCESSING FACILITY","P.O. BOX 368","PAGO PAGO","EASTERN","AS","96799","Food & Beverage","2091","Canned And Cured Fish And Seafoods",null,"",0,{"$nulls":3},"GPC","Yes","2021-06-25","2026-02-28","Non-Major",null,"PAGO PAGO HABOR, PAGO PAGO HARBOR",null,null,"Yes"]