Microbiological Official Control Sampling Schedule

CREATE TABLE fsa_northern_ireland_official_control_shellfish_sampli_b473ebe9 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofbedsbeingsampled" DOUBLE
);

CREATE TABLE microbiological_official_control_sampling_schedule_apr_5cea4bd9 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofbedsbeingsampled" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_apr_a94ce959 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_apr_ceff2665 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_apr_ee37c5e7 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_apr_f289a9b6 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofbedsbeingsampled" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_jan_03ac1b97 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_jan_73005f31 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" VARCHAR,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_jan_733afad7 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_jan_f6b30c6a (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_jul_70e301ab (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_jul_8bd24dc0 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" DOUBLE
);

CREATE TABLE microbiological_official_control_sampling_schedule_jul_9b8da1e1 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_jul_f75be53d (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_oct_008a22d7 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_oct_008fdd44 (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofbedsbeingsampled" BIGINT
);

CREATE TABLE microbiological_official_control_sampling_schedule_oct_b5f5da3c (
  "weekbeginning" TIMESTAMP,
  "location" VARCHAR,
  "dateofsample" TIMESTAMP,
  "noofsamples" BIGINT
);