| 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 |
