The following 6 quality tests were made against this table - WISE-SOE 2014: TCM - Hazardous Substances in Seawater - Disaggregated Data

View detailed data definitions in Data Dictionary

1. Mandatory values

This test checked the presence of mandatory elements - CountryCode, NationalStationID, Year, Month, Day, DeterminandHazSubsName, CASNumber, Unit_HazSubs, Concentration, SampleDepth

ERROR - the test was not passed. Missing mandatory values have been found.

17490 records detected.

Element nameNumber of records detected
763
16924
Show records

2. Country codes

This test checked the correctness of country code. All CountryCodes has to match the one of the reporting Country.

OK - the test was passed successfully.

3. Duplicates 1

This test checked the uniqueness of primary keys. The combination of the elements: CountryCode, NationalStationID, Year, Month, Day, SampleID, DeterminandHazSubsName, SampleDepth must create a unique record in the table. No duplicate records should exist with this combination.

ERROR - the test was not passed. Duplicate records have been identified.

1184 records detected.

Show records

4. Duplicates 2

This test checked the uniqueness of primary keys. The combination of the elements: CountryCode, NationalStationID, Year, Month, Day, SampleID, SampleDepth, CASNumber must create a unique record in the table. No duplicate records should exist with this combination.

ERROR - the test was not passed. Duplicate records have been identified.

1184 records detected.

5. Data types

This test checked that the format of reported elements matches the Data Dictionary specifications.

OK - the test was passed successfully.

6. Valid codes

This test checks the correctness of values against code lists (fixed values) - CountryCode, CASNumber, Unit_HazSubs, LOQ_Flag, ThermoPos, HaloPos.

WARNING - Some of the provided values do not exist in the relevant code lists.

11768 records detected.

Element nameNumber of records with incorrect codesList of incorrect codes
116887440-38-2_dossolved, 120-44-0, 218-01-01, 192-97-2, 198-55-0, 131860-33-8, no CAS 35, 7440-39-3_dissolved, 7440-41-7_dissolved, 7440-48-4_dissolved, 7782-49-2_dissolved, 205-82-3, 38379-99-6, 38380-01-7, 38380-03-9, 51908-16-8, 38380-04-0, 52663-63-5, 52663-70-4, 52663-69-1, 52663-68-0, 542-75-6, 74-87-3, 30560-19-1, 2212-67-1, 13194-48-4, 28044-83-9, 133-07-3, 19666-30-9, 1031-07-8, 36734-19-7, 86-50-0, 13457-18-6, 23560-59-0, 333-41-5, 57018-04-9, 55-38-9, 57646-30-7, 5103-74-2, 5103-71-9, 41483-43-6, 33213-65-3, 18181-80-1, 60168-88-9, 188425-85-6, 298-02-2, 1897-45-6, 32809-16-8, 950-37-8, 88671-89-0, 69327-76-0, 143390-89-0, 732-11-6, 116-29-0, 2642-71-9, 99-30-9, 131341-86-1, 999-81-5, 23135-22-0, 82097-50-5, 116-06-3, 10605-21-7, 111988-49-9, 77732-09-3, 94361-06-5, 110488-70-5, 121552-61-2, 55179-31-2, 56-72-4, 118134-30-8, 66215-27-8, 2032-65-7, 24579-73-5, 57966-95-7, 114-26-1, 126833-17-8, 66246-88-6, 53112-28-0, 298-04-4, 69806-50-4, 95465-99-9, 1646-87-3, 1646-88-4, 81334-34-1, 101200-48-0, 63-25-2, 153719-23-4, 105512-06-9, 22224-92-6, 55219-65-3, 24017-47-8, 78587-05-0, 2312-35-8, 42874-03-3, 135410-20-7, 105827-78-9, 7786-34-7, 1746-81-2, 35554-44-0, 107534-96-3, 731-27-1, 80844-07-1, 43121-43-3, 101007-06-1, 140923-17-7, 38380-07-3, 78763-54-9, 89-21-4, 88-73-3, 121-73-3, 95-51-2, 95-57-8, 95-76-1, 108-42-9, 108-43-0, 108-41-8, 106-47-8, 106-48-9, 25567-68-4, 298-03-3, 93-65-2, 301-12-2, 818-08-6, 9072-35-9, 71626-11-4, 101-21-3, 1134-23-2, 3060-89-7, 892-20-6
80pH, °C

Codelist values:

Element nameFixed/suggestedValuesMultivalue delimiter *
CountryCodeFixedAL, AT, BA, BE, BG, CH, CY, CZ, DE, DK, DZ, EE, EG, ES, FI, FR, GB, GR, HR, HU, IE, IL, IS, IT, JO, LB, LI, LT, LU, LV, MA, ME, MK, MT, NL, NO, PL, PS, PT, RO, RS, SE, SI, SK, TN, TR, XK
CASNumberSuggested100-02-7, 100-41-4, 100-42-5, 1002-53-5, 10028-17-8, 10061-01-5, 10061-02-6, 1007-28-9, 101-55-3, 1014-69-3, 1024-57-3, 10265-92-6, 103-65-1, 104-35-8, 104-40-5, 104-51-8, 105-67-9, 106-42-3, 106-43-4, 106-44-4, 106-44-5, 106-46-7, 106-93-4, 1066-51-9, 107-06-2, 107-13-1, 107-46-0, 1070-78-6, 1071-83-6, 108-38-3, 108-67-8, 108-70-3, 108-86-1, 108-88-3, 108-90-7, 108-95-2, 1113-02-6, 112410-23-8, 115-29-7, 115-32-2, 1163-19-5, 117-81-7, 118-74-1, 118-96-7, 1194-65-6, 120-12-7, 120-36-5, 120-82-1, 120-83-2, 12002-48-1, 120928-09-8, 121-14-2, 121-75-5, 122-14-5, 122-34-9, 123-33-1, 124-48-1, 127-18-4, 12767-79-2, 129-00-0, 13071-79-9, 131-11-3, 131-16-8, 131-18-0, 1321-64-8, 1321-65-9, 133-06-2, 133-53-9, 1330-20-7, 1335-87-1, 1335-88-2, 13356-08-6, 1336-36-3, 133855-98-8, 135-19-3, 135-98-8, 136426-54-5, 136677-10-6, 13684-56-5, 137-26-8, 137-30-4, 139-13-9, 139-40-2, 140-57-8, 140-66-9, 142-28-9, 143-50-0, 144-49-0, 151-21-3, 15165-67-0, 156-52-9, 156-59-2, 156-60-5, 1563-66-2, 1570-64-5, 1570-65-6, 1582-09-8, 15972-60-8, 1610-18-0, 1634-04-4, 16478-18-5, 16484-77-8, 16655-82-6, 16672-87-0, 16752-77-5, 1689-83-4, 1689-84-5, 1689-99-2, 1698-60-8, 1702-17-6, 17040-19-6, 1746-01-6, 1806-26-4, 18181-70-9, 182346-21-0, 1825-21-4, 182677-30-1, 1836-75-5, 1861-40-1, 189084-64-8, 191-24-2, 1912-24-9, 1918-00-9, 1918-13-4, 193-39-5, 2008-58-4, 20427-84-3, 20461-54-5, 205-99-2, 2051-24-3, 206-44-0, 207-08-9, 207122-15-4, 208-96-8, 2104-64-5, 21087-64-9, 2163-68-0, 2164-08-1, 21725-46-2, 218-01-9, 2227-13-6, 2234-13-1, 2310-17-0, 23103-98-2, 23593-75-1, 2385-85-5, 23950-58-5, 2440-02-0, 24959-67-9, 25057-89-0, 25140-90-3, 25154-52-3, 25167-83-3, 2599-11-3, 262-12-4, 26225-79-6, 26259-45-0, 2921-88-2, 294-62-2, 297-78-9, 298-00-0, 30125-63-4, 309-00-2, 314-40-9, 31508-00-6, 319-84-6, 319-85-7, 319-86-8, 32241-08-0, 32534-81-9, 32536-52-0, 32598-13-3, 32598-14-4, 32774-16-6, 330-54-1, 330-55-2, 3307-39-9, 33213-65-9, 33693-04-8, 3397-62-4, 34123-59-6, 3424-82-6, 34256-82-1, 35065-27-1, 35065-28-2, 35065-29-3, 35065-30-6, 35693-99-3, 35694-08-7, 36065-30-2, 36355-01-8, 36643-28-4, 37680-73-2, 38380-08-4, 39635-31-9, 39765-80-5, 40487-42-1, 41318-75-6, 41394-05-2, 4234-79-1, 4636-83-3, 465-73-6, 470-90-6, 4901-51-3, 4904-61-4, 50-00-0, 50-29-3, 50-30-6, 50-32-8, 51000-52-3, 512-04-9, 51218-45-2, 51235-04-2, 52236-30-3, 526-75-0, 52645-53-1, 52663-72-6, 53-19-0, 53-70-3, 534-52-1, 540-59-0, 541-73-1, 5436-43-1, 55512-33-9, 55525-54-7, 5598-13-0, 56-23-5, 56-38-2, 56-55-3, 563-58-6, 56507-37-0, 56573-85-4, 57-12-5, 57-74-9, 57465-28-8, 576-26-1, 57837-19-1, 58-89-9, 58-90-2, 59-50-7, 5915-41-3, 594-20-7, 60-00-4, 60-51-5, 60-57-1, 60145-21-3, 60207-90-1, 603-35-0, 60328-60-9, 60348-60-9, 608-73-1, 608-93-5, 6108-10-07, 6164-98-3, 6190-65-4, 62-73-7, 630-20-6, 64902-72-3, 65510-44-3, 66753-07-9, 67-66-3, 67129-08-2, 67564-91-4, 68631-49-2, 688-73-3, 69782-90-7, 7012-37-5, 70124-77-5, 70362-41-3, 70362-50-4, 70630-17-0, 70776-03-3, 7085-19-0, 71-43-2, 71-55-6, 72-20-8, 72-43-5, 72-54-8, 72-55-9, 7286-69-3, 7287-19-6, 732-26-3, 74-83-9, 74-95-3, 74-97-5, 74233-64-6, 7429-90-5, 7429-90-5_dissolved, 7439-89-6, 7439-89-6_dissolved, 7439-92-1, 7439-92-1_dissolved, 7439-93-2, 7439-95-4, 7439-96-5, 7439-96-5_dissolved, 7439-97-6, 7439-97-6_dissolved, 7439-98-7, 7440-02-0, 7440-02-0_dissolved, 7440-09-7, 7440-22-4, 7440-23-5, 7440-24-6, 7440-28-0, 7440-31-5, 7440-32-6, 7440-33-7, 7440-36-0, 7440-38-2, 7440-38-2_dissolved, 7440-39-3, 7440-41-7, 7440-42-8, 7440-43-9, 7440-43-9_dissolved, 7440-47-3, 7440-47-3_dissolved, 7440-48-4, 7440-50-8, 7440-50-8_dissolved, 7440-61-1, 7440-62-2, 7440-66-6, 7440-66-6_dissolved, 7440-70-2, 74472-37-0, 75-01-4, 75-09-2, 75-25-2, 75-27-4, 75-34-3, 75-35-4, 75-69-4, 75-71-8, 75-99-0, 76-03-9, 76-44-8, 77-47-4, 7782-41-4, 7782-49-2, 78-87-5, 789-02-6, 79-00-5, 79-01-6, 79-34-5, 79-94-7, 793-24-8, 80-05-7, 8001-35-2, 81-15-2, 82-68-8, 83-32-9, 834-12-8, 84-66-2, 84-69-5, 84-74-2, 84852-15-3, 85-01-8, 85-22-3, 85-68-7, 85535-84-8, 85540-50-1, 86-73-7, 87-61-6, 87-65-0, 87-68-3, 87-86-5, 88-06-2, 88-85-7, 886-50-0, 90-12-0, 9016-45-9, 91-20-3, 91-57-6, 919-86-8, 93-72-1, 93-76-5, 94-74-6, 94-75-7, 94-81-5, 94-82-6, 95-47-6, 95-48-7, 95-49-8, 95-50-1, 95-63-6, 95-65-8, 95-87-4, 95-95-4, 959-98-8, 96-12-8, 96-18-4, 96-45-7, 98-06-6, 98-51-1, 98-82-8, 99-87-6, no CAS 1, no CAS 10, no CAS 11, no CAS 12, no CAS 13, no CAS 14, no CAS 15, no CAS 16, no CAS 17, no CAS 18, no CAS 19, no CAS 2, no CAS 20, no CAS 21, no CAS 22, no CAS 23, no CAS 24, no CAS 25, no CAS 26, no CAS 27, no CAS 28, no CAS 29, no CAS 3, no CAS 30, no CAS 32, no CAS 33, no CAS 34, no CAS 36, no CAS 4, no CAS 5, no CAS 6, no CAS 8, no CAS 9
Unit_HazSubsSuggestedBq, mg/g, mg/kg, mg/l, ng/g, ng/kg, ng/l, µg/g, µg/kg, µg/l
LOQ_FlagSuggested<
ThermoPosFixedAT, BT, IT
HaloPosFixedAH, BH, IH
* Note: Field where multivalue delimiter is defined can contain more than one code from the respective code list if the codes are separated by the delimiter character.