About this Dataset

Water Abstraction Data Sets

This series is an amalgamation of all the water abstraction data sets previously held on Data.Gov.UK (DGUK), thus consolidating all abstraction statistical data into one location on DGUK. Data source is the Environment Agency (EA). The record includes the following datasets: Abstraction licences in force and new licences determined 2000-2010 The consumption of water abstracted from non-tidal surface and groundwater in England and Wales has fallen from an estimated 41.2 thousand megalitres/day in 2000 to 34 thousand megalitres/day in 2010. Latest figures for 2010 show a very slight increase compared to 2009. A megalitre is one million litres. This publication covers the abstraction of water from non tidal, surface water and groundwater in England and Wales (from 2015 onwards just England). Water is a vital resource that needs to be managed carefully to ensure that people have access to affordable and safe drinking water and sanitation. Furthermore, to ensure that the needs of industry are met, without depleting water resources or damaging ecosystems. Status: Official Statistic Total estimated abstractions and licensed abstractions from all sources by purpose, England and Wales (2000-2010) Estimated abstractions from groundwaters by purpose and Environment Agency region: 2000 - 2010 Estimated abstractions from non-tidal surface waters by purpose and Environment Agency region: 2000-2010 Estimated abstractions from tidal waters by purpose and Environment Agency region: 2000 - 2010 Estimated licensed and actual abstractions from all surface and groundwater sources by purpose: 2000-2010 Number of abstraction licences in force by purpose: England and Wales (2010) Number of abstraction licences in force by purpose: Environment Agency regional charge area (2012 and 2015) Estimated abstractions from all sources except tidal by purpose and Environment Agency regional charge area: 2000 - 2015
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2024-06-14T04:01:29Z

Tables

Abstraction Licences In Force And New Licences Determined: 2000 - 2010

@ukgov.water_abstraction_data_sets.abstraction_licences_in_force_and_new_licences_determi_702f7ae0

12.54 kB
42 rows
14 columns

CREATE TABLE abstraction_licences_in_force_and_new_licences_determi_702f7ae0 (
  "title" VARCHAR  -- Title:,
  "abstraction_licences_in_force_and_new_licences_determi_702f7ae0" VARCHAR  -- Abstraction Licences In Force And New Licences Determined: 2000 - 2010,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" DOUBLE  -- Unnamed: 10,
  "unnamed_11" DOUBLE  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);

Abstraction Licences In Force And New Licences Determined: 2000 - 2015

@ukgov.water_abstraction_data_sets.abstraction_licences_in_force_and_new_licences_determi_d8f62ba2

17.59 kB
42 rows
18 columns

CREATE TABLE abstraction_licences_in_force_and_new_licences_determi_d8f62ba2 (
  "title" VARCHAR  -- Title:,
  "abstraction_licences_in_force_and_new_licences_determi_d8f62ba2" VARCHAR  -- Abstraction Licences In Force And New Licences Determined: 2000 - 2015,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" DOUBLE  -- Unnamed: 10,
  "unnamed_11" DOUBLE  -- Unnamed: 11,
  "unnamed_12" DOUBLE  -- Unnamed: 12,
  "unnamed_13" DOUBLE  -- Unnamed: 13,
  "unnamed_14" DOUBLE  -- Unnamed: 14,
  "unnamed_15" DOUBLE  -- Unnamed: 15,
  "unnamed_16" DOUBLE  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17
);

Abstractions From Non-tidal Surface Water And Groundwater By Use: 2000 To 2010

@ukgov.water_abstraction_data_sets.abstractions_from_non_tidal_surface_water_and_groundwa_257d1527

8.7 kB
30 rows
7 columns

CREATE TABLE abstractions_from_non_tidal_surface_water_and_groundwa_257d1527 (
  "title" VARCHAR  -- Title:,
  "abstractions_from_non_tidal_surface_water_and_groundwa_257d1527" VARCHAR  -- Abstractions From Non-tidal Surface Water And Groundwater By Use: 2000 To 2010,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

Estimated Abstractions From All Sources Except Tidal By Purpose And Environment Agency Regional Charge Area: 2000 - 2015

@ukgov.water_abstraction_data_sets.estimated_abstractions_from_all_sources_except_tidal_b_75b9a932

15.46 kB
163 rows
12 columns

CREATE TABLE estimated_abstractions_from_all_sources_except_tidal_b_75b9a932 (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_all_sources_except_tidal_b_75b9a932" VARCHAR  -- Estimated Abstractions From All Sources Except Tidal By Purpose And Environment Agency Regional Charge Area: 2000 - 2015,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Estimated Abstractions From All Sources Except Tidal By Purpose And EA Charge Region 2000 To 2015

@ukgov.water_abstraction_data_sets.estimated_abstractions_from_all_sources_except_tidal_b_c23c366c

15.32 kB
154 rows
12 columns

CREATE TABLE estimated_abstractions_from_all_sources_except_tidal_b_c23c366c (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_all_sources_except_tidal_b_75b9a932" VARCHAR  -- Estimated Abstractions From All Sources Except Tidal By Purpose And Environment Agency Regional Charge Area: 2000 - 2015,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Estimated Abstractions From All Surface And Ground Waters By Purpose And Source 2000 To 2015

@ukgov.water_abstraction_data_sets.estimated_abstractions_from_all_surface_and_ground_wat_c5e16572

17.97 kB
72 rows
18 columns

CREATE TABLE estimated_abstractions_from_all_surface_and_ground_wat_c5e16572 (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_all_surface_and_groundwate_55c26194" VARCHAR  -- Estimated Abstractions From All Surface And Groundwaters By Purpose And Source: 2000 - 2015,
  "unnamed_2" DOUBLE  -- Unnamed: 2,
  "unnamed_3" DOUBLE  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4,
  "unnamed_5" DOUBLE  -- Unnamed: 5,
  "unnamed_6" DOUBLE  -- Unnamed: 6,
  "unnamed_7" DOUBLE  -- Unnamed: 7,
  "unnamed_8" DOUBLE  -- Unnamed: 8,
  "unnamed_9" DOUBLE  -- Unnamed: 9,
  "unnamed_10" DOUBLE  -- Unnamed: 10,
  "unnamed_11" DOUBLE  -- Unnamed: 11,
  "unnamed_12" DOUBLE  -- Unnamed: 12,
  "unnamed_13" DOUBLE  -- Unnamed: 13,
  "unnamed_14" DOUBLE  -- Unnamed: 14,
  "unnamed_15" DOUBLE  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" DOUBLE  -- Unnamed: 17
);

Estimated Abstractions From All Surface And Groundwaters By Purpose And Environment Agency Regional Charge Area: 2000 - 2015

@ukgov.water_abstraction_data_sets.estimated_abstractions_from_all_surface_and_groundwate_6a2fc5dc

15.39 kB
159 rows
12 columns

CREATE TABLE estimated_abstractions_from_all_surface_and_groundwate_6a2fc5dc (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_all_surface_and_groundwate_6a2fc5dc" VARCHAR  -- Estimated Abstractions From All Surface And Groundwaters By Purpose And Environment Agency Regional Charge Area: 2000 - 2015,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Estimated Abstractions From Groundwaters By Purpose And Environment Agency Regional Charge Area: 2000 - 2015

@ukgov.water_abstraction_data_sets.estimated_abstractions_from_groundwaters_by_purpose_an_4c6e3507

13.57 kB
154 rows
12 columns

CREATE TABLE estimated_abstractions_from_groundwaters_by_purpose_an_4c6e3507 (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_groundwaters_by_purpose_an_4c6e3507" VARCHAR  -- Estimated Abstractions From Groundwaters By Purpose And Environment Agency Regional Charge Area: 2000 - 2015,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Estimated Abstractions From Non-tidal Surface Waters By Purpose And Environment Agency Regional Charge Area: 2000-2015

@ukgov.water_abstraction_data_sets.estimated_abstractions_from_non_tidal_surface_waters_b_42b73967

15.2 kB
165 rows
12 columns

CREATE TABLE estimated_abstractions_from_non_tidal_surface_waters_b_42b73967 (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_non_tidal_surface_waters_b_42b73967" VARCHAR  -- Estimated Abstractions From Non-tidal Surface Waters By Purpose And Environment Agency Regional Charge Area: 2000-2015,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Estimated Abstractions From Tidal Waters By Purpose And Environment Agency Regional Charge Area: 2000 - 2015

@ukgov.water_abstraction_data_sets.estimated_abstractions_from_tidal_waters_by_purpose_an_60435173

13.44 kB
165 rows
12 columns

CREATE TABLE estimated_abstractions_from_tidal_waters_by_purpose_an_60435173 (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_tidal_waters_by_purpose_an_60435173" VARCHAR  -- Estimated Abstractions From Tidal Waters By Purpose And Environment Agency Regional Charge Area: 2000 - 2015,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Iwtb21 Abstraction By Purpose 201205

@ukgov.water_abstraction_data_sets.iwtb21_abstraction_by_purpose_201205

9.76 kB
27 rows
11 columns

CREATE TABLE iwtb21_abstraction_by_purpose_201205 (
  "title" VARCHAR  -- Title:,
  "number_of_abstraction_licences_in_force_by_purpose_eng_f3b94188" VARCHAR  -- Number Of Abstraction Licences In Force By Purpose: England And Wales (2010),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

Iwtb22 Abstraction Surface Waters By Purpose 201205

@ukgov.water_abstraction_data_sets.iwtb22_abstraction_surface_waters_by_purpose_201205

19.25 kB
68 rows
26 columns

CREATE TABLE iwtb22_abstraction_surface_waters_by_purpose_201205 (
  "title" VARCHAR  -- Title:,
  "total_estimated_abstractions_and_licensed_abstractions_0db49279" VARCHAR  -- Total Estimated Abstractions And Licensed Abstractions From All Sources By Purpose, England And Wales (2000-2010),
  "unnamed_2" DOUBLE  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25
);

Iwtb23a Abstraction Purpose EA 201205

@ukgov.water_abstraction_data_sets.iwtb23a_abstraction_purpose_ea_201205

14.58 kB
132 rows
12 columns

CREATE TABLE iwtb23a_abstraction_purpose_ea_201205 (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_all_surface_and_groundwate_68a00741" VARCHAR  -- Estimated Abstractions From All Surface And Groundwaters By Purpose And Environment Agency Region: 2000 - 2010,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Iwtb23b Abstraction Tidal EA 201205

@ukgov.water_abstraction_data_sets.iwtb23b_abstraction_tidal_ea_201205

12.46 kB
132 rows
12 columns

CREATE TABLE iwtb23b_abstraction_tidal_ea_201205 (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_tidal_waters_by_purpose_an_41b7c25c" VARCHAR  -- Estimated Abstractions From Tidal Waters By Purpose And Environment Agency Region: 2000 - 2010,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Iwtb23c Abstraction Non Tidal EA 201205

@ukgov.water_abstraction_data_sets.iwtb23c_abstraction_non_tidal_ea_201205

14.52 kB
135 rows
12 columns

CREATE TABLE iwtb23c_abstraction_non_tidal_ea_201205 (
  "title" VARCHAR  -- Title:,
  "n__estimated_abstractions_from_non_tidal_surface_water_65cb70b1" VARCHAR  -- Estimated Abstractions From Non-tidal Surface Waters By Purpose And Environment Agency Region: 2000-2010,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Iwtb23d Abstraction Ground Waters EA 201205

@ukgov.water_abstraction_data_sets.iwtb23d_abstraction_ground_waters_ea_201205

13.19 kB
122 rows
12 columns

CREATE TABLE iwtb23d_abstraction_ground_waters_ea_201205 (
  "title" VARCHAR  -- Title:,
  "n__estimated_abstractions_from_groundwaters_by_purpose_e1254e86" VARCHAR  -- Estimated Abstractions From Groundwaters By Purpose And Environment Agency Region: 2000 - 2010,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

Iwtb23f Abstraction All Purposes 201205

@ukgov.water_abstraction_data_sets.iwtb23f_abstraction_all_purposes_201205

26.64 kB
71 rows
37 columns

CREATE TABLE iwtb23f_abstraction_all_purposes_201205 (
  "title" VARCHAR  -- Title:,
  "estimated_abstractions_from_all_surface_and_groundwate_4ff50423" VARCHAR  -- Estimated Abstractions From All Surface And Groundwaters By Purpose And Source: 2000 - 2010,
  "unnamed_2" DOUBLE  -- Unnamed: 2,
  "unnamed_3" DOUBLE  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4,
  "unnamed_5" DOUBLE  -- Unnamed: 5,
  "unnamed_6" DOUBLE  -- Unnamed: 6,
  "unnamed_7" DOUBLE  -- Unnamed: 7,
  "unnamed_8" DOUBLE  -- Unnamed: 8,
  "unnamed_9" DOUBLE  -- Unnamed: 9,
  "unnamed_10" DOUBLE  -- Unnamed: 10,
  "unnamed_11" DOUBLE  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36
);

Number Of Abstraction Licences In Force By Purpose: Environment Agency Regional Charge Area (2012 And 2015)

@ukgov.water_abstraction_data_sets.number_of_abstraction_licences_in_force_by_purpose_env_76367211

12.41 kB
56 rows
11 columns

CREATE TABLE number_of_abstraction_licences_in_force_by_purpose_env_76367211 (
  "title" VARCHAR  -- Title:,
  "number_of_abstraction_licences_in_force_by_purpose_env_76367211" VARCHAR  -- Number Of Abstraction Licences In Force By Purpose: Environment Agency Regional Charge Area (2012 And 2015),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

Number Of Licences In Force By Purpose And EA Charge Region 2000 To 2015

@ukgov.water_abstraction_data_sets.number_of_licences_in_force_by_purpose_and_ea_charge_r_9cf21e66

12.39 kB
51 rows
11 columns

CREATE TABLE number_of_licences_in_force_by_purpose_and_ea_charge_r_9cf21e66 (
  "title" VARCHAR  -- Title:,
  "number_of_abstraction_licences_in_force_by_purpose_env_76367211" VARCHAR  -- Number Of Abstraction Licences In Force By Purpose: Environment Agency Regional Charge Area (2012 And 2015),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

Total Estimated Abstractions And Licensed Abstractions From All Sources By Purpose(2000-2015)

@ukgov.water_abstraction_data_sets.total_estimated_abstractions_and_licensed_abstractions_10edd5a8

12.9 kB
55 rows
13 columns

CREATE TABLE total_estimated_abstractions_and_licensed_abstractions_10edd5a8 (
  "title" VARCHAR  -- Title:,
  "total_estimated_abstractions_and_licensed_abstractions_10edd5a8" VARCHAR  -- Total Estimated Abstractions And Licensed Abstractions From All Sources By Purpose(2000-2015),
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12
);