Name: Bristol River Water Quality
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Bristol River Water Quality

River quality monitoring data (chemical,physical and bacteriological parameters tested) from 1994. The laboratory analysis & reporting can take up to a couple of months to be available.
Publisher name: Bristol City Council
Last updated: 2022-07-01T04:07:26Z

Tables

Bristol River Water Quality

@ukgov.bristol_river_water_quality.bristol_river_water_quality

98.51 kB
4,372 rows
19 columns

CREATE TABLE bristol_river_water_quality (
  "sample_date" VARCHAR,
  "weather" VARCHAR,
  "location" VARCHAR,
  "site_reference" VARCHAR,
  "temperature" VARCHAR,
  "ph" VARCHAR,
  "conductivity" VARCHAR,
  "dissolved_oxygen" VARCHAR,
  "turburdity" VARCHAR,
  "nitrite" VARCHAR,
  "nitrate" VARCHAR,
  "total_coliforms" VARCHAR,
  "e_coli" VARCHAR,
  "faecal_streptococci" VARCHAR,
  "ammonium_as_nh4" VARCHAR,
  "b_o_d" VARCHAR,
  "c_o_d" VARCHAR  -- C.O.D.,
  "phosphate_mg_l" VARCHAR,
  "salinity_ppt" VARCHAR  -- Salinity (ppt)
);