Data

The European Pollutant Release and Transfer Register (E-PRTR), Member States reporting under Article 7 of Regulation (EC) No 166/2006

Data

Prod-ID: DAT-26-en

Created 30 May 2016 Published 31 May 2016 Last modified 29 Nov 2016

11 min read

This page was archived on 29 Nov 2016 with reason: Other (New version data-and-maps/data/member-states-reporting-art-7-under-the-european-pollutant-release-and-transfer-register-e-prtr-regulation-13 was published)

The European Pollutant Release and Transfer Register (E-PRTR) is a web-based register established by Regulation (EC) No 166/2006 which implements the UNECE PRTR Protocol, signed in May 2003 in Kiev.

Data and maps

Menu

European data

European Pollutant Release and Transfer Register (E-PRTR) - Microsoft Access database and text format

E-PRTR data covering reporting for 2007 to 2014 by EU Member States, Iceland, Liechtenstein, Norway, Serbia and Switzerland. The Access file represents the status of the E-PRTR database as of May 2016. It provides corrected data from many countries within the period 2007 to 2014. Refer to table below under "Additional information" for the specific details of the countries and years that have been updated as compared to version 8.

[+] Show table definition

ACTIVITY (2611970 records)

The table lists all industrial activities that a facility is operating with.

Field name	Field definition	Data type
ActivityID	Primary key. Required.	int
FacilityReportID	Facility report unique identifier	int
FacilityReportName	Name of reporting facility	nvarchar (255)
AnnexIActivityCode	Industrial activity code	nvarchar (255)
AnnexIActivityName	Industrial activity name	nvarchar (255)
AnnexIActivityIPPCCode	Industrial activity IPPC code	nvarchar (255)
RankingNumeric	Importance ranking of respective activity	int
MainActivityIndicator	Indicator whether this activity is the facilities main activity	bit

POLLUTANTRELEASE (316444 records)

The table lists the reported releases of pollutants for a facility. It covers both releases to air, water and land.

Field name	Field definition	Data type
PollutantReleaseID	Primary key. Required.	int
FacilityReportID	Identifies the facility report that the data belongs to. Required.	int
ReleaseMediumCode	Identifies the environmental medium (air, water etc) code	nvarchar(255)
ReleaseMediumName	Identifies the environmental medium name.	nvarchar(255)
PollutantCode	Identifies the pollutant code	nvarchar(255)
PollutantName	Identifies the pollutant name	nvarchar(255)
PollutantGroupCode	Identifies the pollutant group code	nvarchar(255)
PollutantGroupName	Identifies the pollutant group name	nvarchar(255)
PollutantCAS	Pollutant CAS description	nvarchar(20)
MethodBasisCode	Identifies the method basis code of the main method used (M/C/E).	nvarchar(255)
MethodBasisName	Identifies the method basis name of the main method used	nvarchar(255)
TotalQuantity	Total quantity including accidental quantity [t/year]	float
AccidentalQuantity	Accidental quantity [t/year]	float
UnitCode	Identities the unit code of the quantity	nvarchar(255)
UnitName	Identifies the unit name of the quantity	nvarchar(255)
ConfidentialIndicator	Indicates if confidentiality is claimed. Required.	bit
ConfidentialityReasonCode	Identifies the reason code for confidentiality. Required if confidentiality is claimed for mandatory data.	nvarchar(255)
ConfidentialityReasonName	Identifies the reason name for confidentiality. Required if confidentiality is claimed for mandatory data.	nvarchar(255)
RemarkText	Remark	nvarchar(255)

POLLUTANTRELEASEMETHODUSED (289300 records)

The table lists the methods used for measuring quantities of pollutant releases.

Field name	Field definition	Data type
PollutantReleaseMethodUsedID	Primary key. Required.	int
PollutantReleaseID	Identifies the pollutant report that the data belongs to. Required.	int
MethodTypeCode	Identifies the method type code	nvarchar(255)
MethodTypeName	Identifies the method type name	nvarchar(255)
MethodDesignation	Identifies the method designation	nvarchar(255)

POLLUTANTTRANSFER (32459 records)

The table lists all reported pollutant transfers for a facility. This covers all releases into waste-water.

Field name	Field definition	Data type
PollutantTransferID	Primary key. Required.	int
FacilityReportID	Identifies the facility report that the data belongs to. Required.	int
PollutantCode	Identifies the pollutant code	nvarchar(255)
PollutantName	Identifies the pollutant name	nvarchar(255)
PollutantGroupCode	Identifies the pollutant group code	nvarchar(255)
PollutantGroupName	Identifies the pollutant group name	nvarchar(255)
PollutantCAS	Pollutant CAS description	nvarchar(255)
MethodBasisCode	Identifies the method basis code of the main method used (M/C/E).	nvarchar(255)
MethodBasisName	Identifies the method basis name of the main method used.	nvarchar(255)
Quantity	Total quantity of reported pollutant [t/year]	float
QuantityUnitCode	Identities the unit code of the quantity	nvarchar(255)
QuantityUnitName	Identifies the unit name of the quantity	nvarchar(255)
ConfidentialIndicator	Indicates if confidentiality is claimed. Required.	bit
ConfidentialityReasonCode	Identifies the reason code for confidentiality. Required if confidentiality is claimed for mandatory data.	nvarchar(255)
ConfidentialityReasonName	Identifies the reason name for confidentiality. Required if confidentiality is claimed for mandatory data.	nvarchar(255)
RemarkText	Remark	nvarchar(255)

POLLUTANTTRANSFERMETHODUSED (26585 records)

The table lists the methods used for measuring quantities of pollutant transfers.

Field name	Field definition	Data type
PollutantTransferMethodUsedID	Primary key. Required.	int
PollutantTransferID	Identifies the pollutant report that the data belongs to. Required.	int
MethodTypeCode	Identifies the method type code	nvarchar(255)
MethodTypeName	Identifies the method type name	nvarchar(255)
MethodDesignation	Identifies the method designation	nvarchar(255)

WASTETRANSFER (367697 records)

The table lists the reported data on off-site transfers of waste for a facility, except transfers of pollutants in waste-water, which is stored in the PollutantTransfer table. As for pollutants more than one method could be used for determination of the quantity.

Field name	Field definition	Data type
WasteTransferID	Primary key. Required.	int
FacilityReportID	Identifies the facility report that the data belongs to. Required.	int
WasteTypeCode	Identifies the type of waste code (NON-HW, HWIC, HWOC etc.). Required.	nvarchar(255)
WasteTypeName	Identifies the waste type name (non hazardous, hazardous within country etc.)	nvarchar(255)
WasteTreatmentCode	Identifies the waste treatment code (R, D). Required unless confidentiality is claimed.	nvarchar(255)
WasteTreatmentName	Identifies the waste treatment operation name (recovery or disposal).	nvarchar(255)
MethodBasisCode	Identifies the basis code of the main method used (M/C/E). Required unless confidentiality is claimed.	nvarchar(255)
MethodBasisName	Identifies the basis name of the main method used	nvarchar(255)
Quantity	Quantity [t/year]. Required unless confidentiality is claimed	float
QuantityUnitCode	Identities the unit code of the quantity (Must correspond to ton) Required unless confidentiality is claimed.	nvarchar(255)
QuantityUnitName	Identities the unit name of the quantity	nvarchar(255)
WasteHandlerPartyName	Identifies the recoverer/disposer of the waste. Required for transfer of hazardous waste outside the country unless confidentiality is claimed.	nvarchar(255)
WasteHandlerPartyAddressStreetName	The street name of the waste handler party (WHP)	nvarchar(255)
WasteHandlerPartyAddressBuildingNumber	The building number of the WHP	nvarchar(255)
WasteHandlerPartyAddressCity	Name of city where the WHP is located	nvarchar(255)
WasteHandlerPartyAddressPostalCode	The postal code of the WHP	nvarchar(50)
WasteHandlerPartyAddressCountryCode	Country code of WHP	nvarchar(255)
WasteHandlerPartyAddressCountryName	Country name of WHP	nvarchar(255)
WasteHandlerPartySiteAddressStreetName	Site street name of the WHP	nvarchar(255)
WasteHandlerPartySiteAddressBuildingNumber	Site building number of the WHP	nvarchar(255)
WasteHandlerPartySiteAddressCity	Name of city, where the WHP site is located	nvarchar(255)
WasteHandlerPartySiteAddressPostalCode	The postal code of the WHP site	nvarchar(50)
WasteHandlerPartySiteAddressCountryCode	Country code of the WHP site	nvarchar(255)
WasteHandlerPartySiteAddressCountryName	Country name of the WHP site	nvarchar(255)
ConfidentialIndicator	Indicates if confidentiality is claimed. Required.	bit
ConfidentialityReasonCode	Identifies the reason code for confidentiality. Required if confidentiality is claimed.	nvarchar(255)
ConfidentialityReasonName	Identifies the reason name for confidentiality.	nvarchar(255)
RemarkText	Remark	nvarchar(255)

WASTETRANSFERMETHODUSED (356388 records)

The table lists the methods used for measuring waste quantities.

Field name	Field definition	Data type
WasteTransferMethodUsedID	Primary key. Required.	int
WasteTransferID	Identifies the waste transfer report that the data belongs to. Required.	int
MethodTypeCode	Identifies the method type code	nvarchar(255)
MethodTypeName	Identifies the method type name	nvarchar(255)
MethodDesignation	Identifies the method designation	nvarchar(255)

FACILITYREPORT (231455 records)

The table lists the reported data for a given facility as part of a PollutantAndTransferReport for a given reporting year. A unique E-PRTR identification of a facility is introduced by FacilityID, which is used to hold track of identical facilities across different reporting years, even though national identifier might have changed.

Field name	Field definition	Data type
FacilityReportID	Primary key. Required.	int
PollutantReleaseAndTransferReportID	Identifies the report that the facility report is a part of. Required.	int
FacilityID	Unique identification of the facility. Required.	int
NationalID	National Identification of the facility. Required.	nvarchar(255)
ParentCompanyName	Name of the parent company, i.e. the company that owns or controls the company operating the facility. Required unless confidentiality is claimed.	nvarchar(255)
FacilityName	Name of the facility (operator or owner)	nvarchar(255)
StreetName	The street name of the facility	nvarchar(255)
BuildingNumber	The building number of the facility	nvarchar(255)
City	Name of city, where facility is located	nvarchar(255)
PostalCode	The postal code of the facility	nvarchar(50)
CountryCode	Country code	nvarchar(255)
CountryName	Country name	nvarchar(255)
Lat	Latitude	float
Long	Longitude	float
RBDGeoCode	Identifies the river basin district code computed by geo-coding	nvarchar(255)
RBDGeoName	Identifies the river basin district name computed by geo-coding	nvarchar(255)
NUTSRegionGeoCode	Identifies the NUTS region code at level 2 computed by geo-coding	nvarchar(255)
NUTSRegionGeoName	Identifies the NUTS region name at level 2 computed by geo-coding	nvarchar(255)
RBDSourceCode	Identifies the river basin district code as reported by the RS	nvarchar(255)
RBDSourceName	Identifies the river basin district name as reported by the RS	nvarchar(255)
NUTSRegionSourceCode	Identifies the NUTS region code as reported by the RS	nvarchar(255)
NUTSRegionSourceName	Identifies the NUTS region name as reported by the RS	nvarchar(255)
NACEMainEconomicActivityCode	Main economic activity Code for NACE reported as NACE Code	nvarchar(255)
NACEMainEconomicActivityName	Main economic activity Name for NACE reported as NACE Code	nvarchar(255)
CompetentAuthorityName	Name of competent authority party	nvarchar(255)
CompetentAuthorityAddressStreetName	Street of competent authority party	nvarchar(255)
CompetentAuthorityAddressBuildingNumber	Building number of competent authority party	nvarchar(255)
CompetentAuthorityAddressCity	City of competent authority party	nvarchar(255)
CompetentAuthorityAddressPostalCode	Postal code of competent authority party	nvarchar(50)
CompetentAuthorityAddressCountryCode	Country code of competent authority party	nvarchar(255)
CompetentAuthorityAddressCountryName	Country name of competent authority party	nvarchar(255)
CompetentAuthorityTelephoneCommunication	Telephone number of competent authority party	nvarchar(50)
CompetentAuthorityFaxCommunication	Fax number of competent authority party	nvarchar(50)
CompetentAuthorityEmailCommunication	Email of competent authority party	nvarchar(255)
CompetentAuthorityContactPersonName	Contact person at competent authority party	nvarchar(255)
ProductionVolumeProductName	Name of primary product	nvarchar(255)
ProductionVolumeQuantity	Production quantity of primary product	float
ProductionVolumeUnitCode	Unit code of quantity	nvarchar(255)
ProductionVolumeUnitName	Unit name of quantity	nvarchar(255)
TotalIPPCInstallationQuantity	The total number of IPPC installations covered by the facility	int
OperatingHours	The number of operating hours in reporting year	int
TotalEmployeeQuantity	Number of employees	int
WebsiteCommunication	The website address of Facility	nvarchar(255)
PublicInformation	Textual information	nvarchar(255)
ConfidentialIndicator	Indicates if confidentiality for mandatory data is claimed or not. Required.	bit
ConfidentialityReasonCode	Identifies the reason Code for confidentiality. Required if confidentiality is claimed for mandatory data.	nvarchar(255)
ConfidentialityReasonName	Identifies the reason Name for confidentiality. Required if confidentiality is claimed for mandatory data.	nvarchar(255)
ProtectVoluntaryData	Indicates if voluntary data should be protected or not	bit
RemarkText		nvarchar(255)
MainIASectorCode	Sector Code of main industrial activity	nvarchar(255)
MainIASectorName	Sector Name of main industrial activity	nvarchar(255)
MainIAActivityCode	Activity Code of main industrial activity	nvarchar(255)
MainIAActivityName	Activity Name of main industrial activity	nvarchar(255)
MainIASubActivityCode	Subactivity Code of main industrial activity	nvarchar(255)
MainIASubActivityName	Subactivity Name of main industrial activity	nvarchar(255)

POLLUTANTRELEASEANDTRANSFERREPORT (265 records)

The table lists common information about a report for a given reporting year. If a country has reported more than once then only the most recent report is shown. A unique E-PRTR identification of a facility is introduced by FacilityID, which is used to hold track of identical facilities across different reporting years, even though national identifier might have changed.

Field name	Field definition	Data type
PollutantReleaseAndTransferReportID	Primary key. Required.	int
CountryCode	The RS Code reporting. Required.	nvarchar(255)
CountryName	The RS Name reporting. Required.	nvarchar(255)
ReportingYear	The calendar year of which data on releases and transfers must be gathered. Required.	int
CoordinateSystemCode	The coordinate system code used in reporting of coordinates.	nvarchar(255)
CoordinateSystemName	The coordinate system name used in reporting of coordinates.	nvarchar(255)
RemarkText	Remarks	nvarchar(255)
CdrURL	URL of the envelope at within CDR	nvarchar(255)
CdrUploaded	The time when the report was uploaded in Reportnet.	datetime
CdrReleased	The time when the report was released in Reportnet.	datetime
ForReview		nvarchar(255)
Published	The time when the report was released to public view	datetime
ResubmitReason		nvarchar(255)

FACILITYID_CHANGES (231455 records)

The table lists the correspondance between newest FacilityID's and previous ones, by CountryCode and by ReportingYear

Field name	Field definition	Data type
CountryCode	The RS Code reporting	nvarchar(255)
ReportingYear	The calendar year of which data on releases and transfers must be gathered.	int
FacilityReportID	Facility report unique identifier.	int
NationalID	National Identification of the facility.	nvarchar(255)
NewFacilityID	Unique identification of the facility.	int
OldFacilityID	Unique identification of the facility.	int

eprtr_v9_csv.zip (ZIP archive)
44.04 MB Download file
eprtr_v9_mdb.zip (ZIP archive)
89.29 MB Download file

European Pollutant Release and Transfer Register (E-PRTR) - KMZ format

EPRTR_facilities_v9.kmz (ZIP archive)
2.99 MB Download file

Metadata

Reporting obligations (ROD)

E-PRTR data reporting

Related websites

http://prtr.ec.europa.eu/

Rights:

EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (https://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).

Data sources

European Commission Directorate-general for Environment

Owners:

European Environment Agency (EEA)

Additional information

Article 7 of the Regulation sets the requirements for the annual reporting by Member States which covers the releases to air and water for 91 substances, as well as the transfers of pollutants in water and the transfer of waste from industrial facilities across 65 sectors. The register includes information of more than 33 000 facilities in 33 countries (EU28, Iceland, Liechtenstein, Norway, Switzerland and Serbia).
Version 9 and re-submission overview:

Country	2007 Re-sub.	2008 Re-sub.	2009 Re-sub.	2010 Re-sub.	2011 Re-sub.	2012 Re-Sub.	2013 Re-Sub.	2014 Sub.
Austria	X	X	X	X	X	X	X	X
Belgium	X	X	X	X	X	X	X	X
Bulgaria						X	X	X
Croatia								X
Cyprus							X	X
Czech Republic			X	X		X	X	X
Denmark							X	X
Estonia								X
Finland						X	X	X
France				X	X	X	X	X
Germany	X	X	X	X	X	X	X	X
Greece							X	X
Hungary							X	X
Iceland					X	X	X	X
Ireland	X	X	X	X	X	X	X	X
Italy		X					X	X
Latvia								X
Liechtenstein								X
Lithuania							X	X
Luxembourg							X	X
Malta								X
Netherlands								X
Norway								X
Poland						X	X	X
Portugal						X	X	X
Romania							X	X
Serbia								X
Slovakia								X
Slovenia								X
Spain	X	X	X	X	X	X	X	X
Sweden	X				X	X	X	X
Switzerland	X	X	X	X	X	X	X	X
United Kingdom							X	X