About this Dataset

Plymouth Bathing Water Sites

Data showing the quality of Plymouth's three designated bathing water sites: Plymouth Hoe East, Plymouth Hoe West and Firestone Bay. Datasets are to be updated annually.
Publisher name: Plymouth City Council
Last updated: 2025-03-03T04:00:03Z

Tables

Bathing Water Sites Classifications

@ukgov.hoe_water_quality.bathing_water_sites_classifications

4.99 kB
96 rows
5 columns

CREATE TABLE bathing_water_sites_classifications (
  "eubwid" VARCHAR,
  "bathing_water_site" VARCHAR,
  "year_of_assessment" BIGINT,
  "classification" VARCHAR,
  "assessment_type" VARCHAR
);

Bathing Water Sites Details

@ukgov.hoe_water_quality.bathing_water_sites_details

10.8 kB
3 rows
14 columns

CREATE TABLE bathing_water_sites_details (
  "eubwid" VARCHAR,
  "bathing_water_site" VARCHAR,
  "sample_point_id" BIGINT,
  "year_of_designation" BIGINT,
  "district" VARCHAR,
  "county" VARCHAR,
  "country" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "start_of_season" TIMESTAMP,
  "end_of_season" TIMESTAMP,
  "sewage_service" VARCHAR
);

Plymouth Hoe East Sample Results 1988 - 2024

@ukgov.hoe_water_quality.plymouth_hoe_east_sample_results_1988_2024

23.94 kB
730 rows
14 columns

CREATE TABLE plymouth_hoe_east_sample_results_1988_2024 (
  "eubwid" VARCHAR,
  "bathing_water_site" VARCHAR,
  "sample_date" TIMESTAMP,
  "intestinal_enterococci_count_colonies_per_100ml" DOUBLE  -- Intestinal Enterococci Count (colonies Per 100ml),
  "escherichia_coli_count_colonies_per_100ml" DOUBLE  -- Escherichia Coli Count (colonies Per 100ml),
  "entrovirus_count_colonies_per_100ml" DOUBLE  -- Entrovirus Count (colonies Per 100ml),
  "total_coliform_count_colonies_per_100ml" DOUBLE  -- Total Coliform Count (colonies Per 100ml),
  "faecal_streptococci_count_colonies_per_100ml" DOUBLE  -- Faecal Streptococci Count (colonies Per 100ml),
  "faecal_coliform_count_colonies_per_100ml" DOUBLE  -- Faecal Coliform Count (colonies Per 100ml),
  "presence_of_salmonella" VARCHAR  -- Presence Of Salmonella?,
  "abnormal_weather_exception" VARCHAR  -- Abnormal Weather Exception?,
  "discountable_sample" VARCHAR  -- Discountable Sample?,
  "discount_reasoning" VARCHAR,
  "discounted" VARCHAR  -- Discounted?
);

Plymouth Hoe West Sample Results 1988 - 2024

@ukgov.hoe_water_quality.plymouth_hoe_west_sample_results_1988_2024

24.33 kB
729 rows
14 columns

CREATE TABLE plymouth_hoe_west_sample_results_1988_2024 (
  "eubwid" VARCHAR,
  "bathing_water_site" VARCHAR,
  "sample_date" TIMESTAMP,
  "intestinal_enterococci_count_colonies_per_100ml" DOUBLE  -- Intestinal Enterococci Count (colonies Per 100ml),
  "escherichia_coli_count_colonies_per_100ml" DOUBLE  -- Escherichia Coli Count (colonies Per 100ml),
  "entrovirus_count_colonies_per_100ml" DOUBLE  -- Entrovirus Count (colonies Per 100ml),
  "total_coliform_count_colonies_per_100ml" DOUBLE  -- Total Coliform Count (colonies Per 100ml),
  "faecal_streptococci_count_colonies_per_100ml" DOUBLE  -- Faecal Streptococci Count (colonies Per 100ml),
  "faecal_coliform_count_colonies_per_100ml" DOUBLE  -- Faecal Coliform Count (colonies Per 100ml),
  "presence_of_salmonella" VARCHAR  -- Presence Of Salmonella?,
  "abnormal_weather_exception" VARCHAR  -- Abnormal Weather Exception?,
  "discountable_sample" VARCHAR  -- Discountable Sample?,
  "discount_reasoning" VARCHAR,
  "discounted" VARCHAR  -- Discounted?
);