Northern Ireland Microbiological Results

CREATE TABLE northern_ireland_microbiological_results_2025 (
  "lough" VARCHAR,
  "representativemonitoringpoints" VARCHAR,
  "sampledate" TIMESTAMP,
  "species" VARCHAR,
  "current_classification" VARCHAR,
  "category" VARCHAR,
  "ecoli" VARCHAR,
  "currentstatus" VARCHAR,
  "comments" VARCHAR,
  "column1" VARCHAR,
  "column2" VARCHAR,
  "column3" VARCHAR,
  "unnamed_12" VARCHAR  -- Unnamed: 12
);