Personal tools

next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / The European Pollutant Release and Transfer Register (E-PRTR), Member States reporting under Article 7 of Regulation (EC) No 166/2006

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

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.

European data

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

E-PRTR data covering reporting for 2007 to 2010 by EU Member States, Iceland, Liechtenstein, Norway, Serbia and Switzerland. The Access file is an update to the previous version (4.1) and represents the status of the E-PRTR database as of 07 October 2012. It provides corrected data from many countries within the period 2007 to 2010. Refer to table below under "Additional information" for the specific details of the countries and years that have been updated as compared to version 4.1.

[+] Show table definition

ACTIVITY (152671 records)

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

Field nameField definitionData 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 (191917 records)

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

Field nameField definitionData 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)

 

POLLUTANTRELEASEMETHODUSED (164239 records)

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

Field nameField definitionData 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 (21726 records)

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

Field nameField definitionData 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)

 

POLLUTANTTRANSFERMETHODUSED (15480 records)

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

Field nameField definitionData 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 (191917 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 nameField definitionData 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)

 

WASTETRANSFERMETHODUSED (181284 records)

The table lists the methods used for measuring waste quantities.

Field nameField definitionData 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 (135546 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 nameField definitionData 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
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 (169 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 nameField definitionData 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)
CdrReleased The time when the report was released in Reportnet. datetime
Published The time when the report was released to public view datetime

 

FACILITYID_CHANGES (135546 records)

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

Field nameField definitionData 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
European Pollutant Release and Transfer Register (E-PRTR) - Aggregate and summary data files (CSvs)

Additional information

Metadata

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 about 29000 facilities in 32 countries (EU27, Iceland, Liechtenstein, Norway, Switzerland and Serbia).
    • Version 4.2 and re-submission overview:
Country

2007

Resubmission

2008

Resubmission

2009

Resubmission

2010

Resubmission

Austria X X X X
Belgium X X X X
Bulgaria X
Cyprus X
Czech Republic X
Denmark X
Estonia X
Finland
France X X X
Germany X X X X
Greece X
Hungary X X
Iceland
Ireland X X X X
Italy
Latvia
Liechtenstein
Lithuania X
Luxembourg X
Malta
Netherlands
Norway X X X X
Poland X X X X
Portugal X
Romania X X X X
Serbia
Slovakia
Slovenia
Spain X
Sweden X X X
Switzerland X X
United Kingdom X X X X
 

Related content

Figures produced

Used in indicators

Emission intensity of manufacturing industries in Europe Emission intensity of manufacturing industries in Europe The indicator is used to illustrate emission intensity of manufacturing industries expressed as amount of pollutant discharged in water per unit of production of manufacturing industries (expressed as one million Euro gross value added). Furthermore, indicator shows decoupling of economic growth (GVA) from the environmental impact (emission of pollutants).Decoupling indicator displays the percentage of change in emission of pollutants from manufacturing plotted together with the change in the gross value added (GVA) of the manufacturing industry over the same period of time (between 2004-2010). Absolute decoupling occurs when the environmentally relevant variable is stable or decreasing while the economic driving force is growing. Relative decoupling occurs when the growth rate of the emission is positive, but less than the growth rate of the GVA. In line with Statistical classification of economic activities in the European Community NACE Rev. 2 Section C  (divisions 10-33) the following industries : are considered in the „manufacturing“:” Division 10: Manufacture of food products Division 11: Manufacture of beverages Division 12: Manufacture of tobacco products Division 13: Manufacture of textiles Division 14: Manufacture of wearing apparel Division 15: Manufacture of leather and related products Division 16: Manufacture of wood and of products of wood and cork, except furniture; manu- facture of articles of straw and plaiting materials Division 17: Manufacture of paper and paper products Division 18: Printing and reproduction of recorded media Division 19: Manufacture of coke, refined petroleum products Division 20: Manufacture of chemicals, chemical products Division 21: Manufacture of basic pharmaceutical products and pharmaceutical preparations Division 22: Manufacture of rubber and plastic products Division 23: Manufacture of other non-metallic mineral products Division 24: Manufacture of basic metals Division 25: Manufacture of fabricated metal products, except machinery and equipment Division 26: Manufacture of computer, electronic and optical products Division 27: Manufacture of electrical equipment Division 28: Manufacture of machineryand equipment n.e.c. Division 29: Manufacture of motor vehicles, trailers and semi-trailers Division 30: Manufacture of other transport equipment Division 31: Manufacture of furniture Division 32: Other manufacturing Division 33: Repair and installation of machinery and equipment   The following divisions from NACE Rev. 2 Section C were considered for: Food industry: division 10, 11 Chemical industry: division 20, groups 20.1-20.6 Metal industry:division 24, 25    
Document Actions
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100