Postal code |
International country code (ISO 3166-1-Alpha-2 code elements) |
|
varchar(2) |
Nope |
monitoringSiteIdentifier |
Internationally unique identifier of the monitoring site from which the data was obtained |
|
varchar(24) |
Yes |
bathingWaterName |
Name of bathing water provided by a Member State |
|
varchar(100) |
Nope |
bwWaterCategory |
Water body category code, as defined in the code list |
CW – Coastal Water Body; LW – Lake water body; RW – Mass of river water; TW – Transitional water body; |
varchar(2) |
Nope |
waterBodyId |
Identifier of the surface water body or marine region or sub-region being monitored |
|
varchar(100) |
Nope |
bwProfileUrl |
Hyperlink to documents or web pages with bathing water profile, if available |
|
varchar(max) |
Nope |
latitude |
Geographic latitude coordinate of a monitoring site in decimal degrees |
|
decimal(8) |
Nope |
longitude |
Longitude geographic coordinate of a monitoring site in decimal degrees |
|
decimal(8) |
Nope |
quality1990 |
Classification of bathing water quality for the 1990 season |
|
nvarchar(50) |
Nope |
quality1991 |
Classification of bathing water quality for the 1991 season |
|
nvarchar(50) |
Nope |
quality1992 |
Classification of bathing water quality for the 1992 season |
|
nvarchar(50) |
Nope |
quality1993 |
Classification of bathing water quality for the 1993 season |
|
nvarchar(50) |
Nope |
quality1994 |
Classification of bathing water quality for the 1994 season |
|
nvarchar(50) |
Nope |
quality1995 |
Classification of bathing water quality for the 1995 season |
|
nvarchar(50) |
Nope |
quality1996 |
Classification of bathing water quality for the 1996 season |
|
nvarchar(50) |
Nope |
quality1997 |
Classification of bathing water quality for the 1997 season |
|
nvarchar(50) |
Nope |
quality1998 |
Classification of bathing water quality for the 1998 season |
|
nvarchar(50) |
Nope |
quality1999 |
Classification of bathing water quality for the 1999 season |
|
nvarchar(50) |
Nope |
quality2000 |
Classification of bathing water quality for the 2000 season |
|
nvarchar(50) |
Nope |
quality2001 |
Classification of bathing water quality for the 2001 season |
|
nvarchar(50) |
Nope |
quality2002 |
Classification of bathing water quality for the 2002 season |
|
nvarchar(50) |
Nope |
quality2003 |
Classification of bathing water quality for the 2003 season |
|
nvarchar(50) |
Nope |
quality2004 |
Classification of bathing water quality for the 2004 season |
|
nvarchar(50) |
Nope |
quality2005 |
Classification of bathing water quality for the 2005 season |
|
nvarchar(50) |
Nope |
quality2006 |
Ranking of bathing water quality for the 2006 season |
|
nvarchar(50) |
Nope |
quality2007 |
Ranking of bathing water quality for the 2007 season |
|
nvarchar(50) |
Nope |
quality2008 |
Ranking of bathing water quality for the 2008 season |
|
nvarchar(50) |
Nope |
quality2009 |
Ranking of bathing water quality for the 2009 season |
|
nvarchar(50) |
Nope |
quality2010 |
Ranking of bathing water quality for the 2010 season |
|
nvarchar(50) |
Nope |
quality2011 |
Ranking of bathing water quality for the 2011 season |
|
nvarchar(50) |
Nope |
quality2012 |
Ranking of bathing water quality for the 2012 season |
|
nvarchar(50) |
Nope |
quality2013 |
Ranking of bathing water quality for the 2013 season |
|
nvarchar(50) |
Nope |
quality2014 |
Ranking of bathing water quality for the 2014 season |
|
nvarchar(50) |
Nope |
quality2015 |
Ranking of bathing water quality for the 2015 season |
|
nvarchar(50) |
Nope |
quality2016 |
Ranking of bathing water quality for the 2016 season |
|
nvarchar(50) |
Nope |
quality2017 |
Ranking of bathing water quality for the 2017 season |
|
nvarchar(50) |
Nope |
quality2018 |
Ranking of bathing water quality for the 2018 season |
|
nvarchar(50) |
Nope |
monitoringCalendar2018 |
Ranking of the monitoring calendar for the 2018 season |
|
nvarchar(50) |
Nope |
management2018 |
Management ranking for the 2018 season |
|
nvarchar(50) |
Nope |
quality2019 |
Ranking of bathing water quality for the 2019 season |
|
nvarchar(50) |
Nope |
monitoringCalendar2019 |
Ranking of the tracking calendar for the 2019 season |
|
nvarchar(50) |
Nope |
management2019 |
Management ranking for the 2019 season |
|
nvarchar(50) |
Nope |
quality2020 |
Ranking of bathing water quality for the 2020 season |
|
nvarchar(50) |
Nope |
monitoringCalendar2020 |
Management ranking for the 2020 season |
|
nvarchar(50) |
Nope |
management2020 |
Ranking of the tracking calendar for the 2020 season |
|
nvarchar(50) |
Nope |