2002 NI Water Customer Tap Results

@ukgov.ni_water_customer_tap_authorised_supply_point_results.n_2002_ni_water_customer_tap_results

113.44 kB
18,997 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

92.5 kB
16,037 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

240.7 kB
46,368 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

247.01 kB
52,264 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

263.81 kB
55,653 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

289.56 kB
57,224 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

286.87 kB
59,802 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

325.95 kB
67,462 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

293.61 kB
58,450 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

280.49 kB
58,853 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

307.92 kB
59,516 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

388.07 kB
65,506 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

395.12 kB
68,191 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

371.16 kB
63,892 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

388.35 kB
67,091 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

398.06 kB
68,108 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

385.99 kB
69,221 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

416.7 kB
75,548 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

332.35 kB
62,527 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

382.24 kB
71,007 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

383.32 kB
72,705 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

425.15 kB
77,314 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

451.19 kB
80,487 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

620.64 kB
50,459 rows
24 columns

CREATE TABLE postcode_v_zone_public_register_lookup_by_year (
  "postcode" VARCHAR,
  "n_2024" VARCHAR  -- 2024,
  "n_2023" VARCHAR  -- 2023,
  "n_2022" VARCHAR  -- 2022,
  "n_2021" VARCHAR  -- 2021,
  "n_2020" VARCHAR  -- 2020,
  "n_2019" VARCHAR  -- 2019,
  "n_2018" VARCHAR  -- 2018,
  "n_2017" VARCHAR  -- 2017,
  "n_2016" VARCHAR  -- 2016,
  "n_2015" VARCHAR  -- 2015,
  "n_2014" VARCHAR  -- 2014,
  "n_2013" VARCHAR  -- 2013,
  "n_2012" VARCHAR  -- 2012,
  "n_2011" VARCHAR  -- 2011,
  "n_2010" VARCHAR  -- 2010,
  "n_2009" VARCHAR  -- 2009,
  "n_2008" VARCHAR  -- 2008,
  "n_2007" VARCHAR  -- 2007,
  "n_2006" VARCHAR  -- 2006,
  "n_2005" VARCHAR  -- 2005,
  "n_2004" VARCHAR  -- 2004,
  "n_2003" VARCHAR  -- 2003,
  "n_2002" VARCHAR  -- 2002
);

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

About this Dataset