Water bodies at risk of failure in achieving the good status (RNABE in French) has been reported in 2005 by each EU member state. The report can be found here : ​http://cdr.eionet.europa.eu/ then click on the member state / European Union (EU), obligations / Water Framework Directive: Art. 5 reporting / Deliveries under WFD Art. 5

direct link seems to be: ​http://cdr.eionet.europa.eu/fr/eu/wfdart5/ ; just replace fr by the code of the country (ie for Ireland for example)

Only river waterbody (not very small waterbody) are available at the moment, which is less than the coverage of the CCM layer.

From the PROTAREAE_FRA_region :
Eu_cd:
MS_CD:
LAT - LON : latitude and longitude:
NAME:
AREA: surface
LENGTH:longueur
BATHING - BIRDS - DRINKING - FISH - SHELLFISH - HABITATS - NITRATES - UWWT - ABSTRACTIO:Y (yes), N (no), I assume but no values
DIST_CD:
OGR_FID:
NAME_2:
MS_CD_2:
EU_CD_2:
AUTH_CD: