2002 NI Water Customer Tap Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2002_ni_water_customer_tap_results

110.78 KB
18997 rows
11 columns


CREATE TABLE n_2002_ni_water_customer_tap_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2003 NI Water Customer Tap Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2003_ni_water_customer_tap_results

90.34 KB
16037 rows
11 columns


CREATE TABLE n_2003_ni_water_customer_tap_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2004 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2004_ni_water_customer_tap_authorised_supply_point_results

235.06 KB
46368 rows
11 columns


CREATE TABLE n_2004_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2005 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2005_ni_water_customer_tap_authorised_supply_point_results

241.22 KB
52264 rows
11 columns


CREATE TABLE n_2005_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2006 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2006_ni_water_customer_tap_authorised_supply_point_results

257.63 KB
55653 rows
11 columns


CREATE TABLE n_2006_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2007 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2007_ni_water_customer_tap_authorised_supply_point_results

282.78 KB
57224 rows
11 columns


CREATE TABLE n_2007_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2008 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2008_ni_water_customer_tap_authorised_supply_point_results

280.15 KB
59802 rows
11 columns


CREATE TABLE n_2008_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2009 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2009_ni_water_customer_tap_authorised_supply_point_results

318.32 KB
67462 rows
11 columns


CREATE TABLE n_2009_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2010 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2010_ni_water_customer_tap_authorised_supply_point_results

286.73 KB
58450 rows
11 columns


CREATE TABLE n_2010_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2011 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2011_ni_water_customer_tap_authorised_supply_point_results

273.92 KB
58853 rows
11 columns


CREATE TABLE n_2011_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2012 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2012_ni_water_customer_tap_authorised_supply_point_results

300.7 KB
59516 rows
11 columns


CREATE TABLE n_2012_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2013 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2013_ni_water_customer_tap_authorised_supply_point_results

378.98 KB
65506 rows
11 columns


CREATE TABLE n_2013_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2014 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2014_ni_water_customer_tap_authorised_supply_point_results

385.86 KB
68191 rows
11 columns


CREATE TABLE n_2014_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2015 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2015_ni_water_customer_tap_authorised_supply_point_results

362.46 KB
63892 rows
11 columns


CREATE TABLE n_2015_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2016 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2016_ni_water_customer_tap_authorised_supply_point_results

379.25 KB
67091 rows
11 columns


CREATE TABLE n_2016_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2017 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2017_ni_water_customer_tap_authorised_supply_point_results

388.73 KB
68108 rows
11 columns


CREATE TABLE n_2017_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2018 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2018_ni_water_customer_tap_authorised_supply_point_results

376.94 KB
69221 rows
11 columns


CREATE TABLE n_2018_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2019 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2019_ni_water_customer_tap_authorised_supply_point_results

406.93 KB
75548 rows
11 columns


CREATE TABLE n_2019_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2020 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2020_ni_water_customer_tap_authorised_supply_point_results

324.56 KB
62527 rows
11 columns


CREATE TABLE n_2020_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2021 NI Water Customer Tap Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2021_ni_water_customer_tap_results

373.28 KB
71007 rows
11 columns


CREATE TABLE n_2021_ni_water_customer_tap_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2022 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2022_ni_water_customer_tap_authorised_supply_point_results

374.34 KB
72705 rows
11 columns


CREATE TABLE n_2022_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2023 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2023_ni_water_customer_tap_authorised_supply_point_results

415.18 KB
77314 rows
11 columns


CREATE TABLE n_2023_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

2024 NI Water Customer Tap & Authorised Supply Point Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2024_ni_water_customer_tap_authorised_supply_point_results

440.62 KB
80487 rows
11 columns


CREATE TABLE n_2024_ni_water_customer_tap_authorised_supply_point_results (
  "year" BIGINT,
  "sample_location" VARCHAR,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "sample_id_text" VARCHAR,
  "sample_date" VARCHAR,
  "postcode" VARCHAR,
  "parameter" VARCHAR,
  "pcv_limit" DOUBLE,
  "result" VARCHAR,
  "units" VARCHAR
);

Postcode V Zone Public Register Lookup By Year

@ukgov.ni_water_customer_tap_authorised_supply_point_results.postcode_v_zone_public_register_lookup_by_year

606.1 KB
50459 rows
24 columns


CREATE TABLE postcode_v_zone_public_register_lookup_by_year (
  "postcode" VARCHAR,
  "n_2024" VARCHAR,
  "n_2023" VARCHAR,
  "n_2022" VARCHAR,
  "n_2021" VARCHAR,
  "n_2020" VARCHAR,
  "n_2019" VARCHAR,
  "n_2018" VARCHAR,
  "n_2017" VARCHAR,
  "n_2016" VARCHAR,
  "n_2015" VARCHAR,
  "n_2014" VARCHAR,
  "n_2013" VARCHAR,
  "n_2012" VARCHAR,
  "n_2011" VARCHAR,
  "n_2010" VARCHAR,
  "n_2009" VARCHAR,
  "n_2008" VARCHAR,
  "n_2007" VARCHAR,
  "n_2006" VARCHAR,
  "n_2005" VARCHAR,
  "n_2004" VARCHAR,
  "n_2003" VARCHAR,
  "n_2002" VARCHAR
);

Northern Ireland Water Drinking Water Quality Public Registers, Individual Customer Tap & Authorised Supply Point Results, & Drinking Water Quality Annual Reports

About this Dataset