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.87 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.54 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.38 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,
  "escherichia_coli_count_colonies_per_100ml" DOUBLE,
  "entrovirus_count_colonies_per_100ml" DOUBLE,
  "total_coliform_count_colonies_per_100ml" DOUBLE,
  "faecal_streptococci_count_colonies_per_100ml" DOUBLE,
  "faecal_coliform_count_colonies_per_100ml" DOUBLE,
  "presence_of_salmonella" VARCHAR,
  "abnormal_weather_exception" VARCHAR,
  "discountable_sample" VARCHAR,
  "discount_reasoning" VARCHAR,
  "discounted" VARCHAR
);

Plymouth Hoe West Sample Results 1988 - 2024

@ukgov.hoe_water_quality.plymouth_hoe_west_sample_results_1988_2024

23.76 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,
  "escherichia_coli_count_colonies_per_100ml" DOUBLE,
  "entrovirus_count_colonies_per_100ml" DOUBLE,
  "total_coliform_count_colonies_per_100ml" DOUBLE,
  "faecal_streptococci_count_colonies_per_100ml" DOUBLE,
  "faecal_coliform_count_colonies_per_100ml" DOUBLE,
  "presence_of_salmonella" VARCHAR,
  "abnormal_weather_exception" VARCHAR,
  "discountable_sample" VARCHAR,
  "discount_reasoning" VARCHAR,
  "discounted" VARCHAR
);