Related Topics:
Table Name: TRI_FACILITY_SIC_HISTORY
Description: Historical representation of the Standard Industrial Classification (SIC) code or codes which best describes the activities conducted at the facility or establishment. SIC codes are 4 digit numbers used by the Bureau of Census as part of a system to categorize and track the types of business activities conducted in the United States. The first two digits of the code represent the major industry group (e.g., SIC code 25XX indicates Furniture and Fixtures) and the second two digits represent the specific subset of that group (e.g., 2511 indicates wood household furniture). EPA instructs facilities to enter their primary SIC code first. Many facilities do not report their primary SIC code first. (Data in TRI_FACILITY_SIC_HISTORY were submitted on EPA Form R or Form A, Part I, Section 4, 'Facility Identification'. See specific 'Data Source' for each column.)
Columns:
Envirofacts Data Service API for TRI_FACILITY_SIC_HISTORY: Envirofacts has developed a RESTful data service API to all of its internal data holdings. This functionality provides a user of Envirofacts with the ability to query any table through the use of a URL. The default output is in XML, which can be utilized in other applications, as well as tools such as Microsoft Excel or Access. Output options of CSV and Excel can be requested in the URL. The entire Envirofacts database metadata is available online, so that all tables and columns within Envirofacts are documented. Having the table structures available in this manner makes most of Envirofacts data easily available through the service. More information is available on the Envirofacts Services page.
Below is a sample of the first 10 rows of data for the TRI_FACILITY_SIC_HISTORY table. The URL used to produce this output is:
https://data.epa.gov/efservice/TRI_FACILITY_SIC_HISTORY/ROWS/0:10/EXCEL
Contact Us
to ask a question, provide feedback, or report a problem.