Enforcement Data - Enforcement Reports
Food Standards Agency
@ukgov.enforcement_data_enforcement_reports
Food Standards Agency
@ukgov.enforcement_data_enforcement_reports
CREATE TABLE enforcement_data_2018 (
"dateserved" TIMESTAMP,
"id852_2004" BIGINT,
"id1099_2009" BIGINT,
"id853_2004" BIGINT,
"id2996_2013" BIGINT,
"id1069_2009" BIGINT,
"id999_2001" BIGINT,
"id2952_2013" BIGINT,
"id142_2011" BIGINT,
"id178_2002" BIGINT,
"id1724_2003" BIGINT,
"id2073_2005" BIGINT,
"id854_2004" BIGINT,
"id931_2011" BIGINT,
"id1774_2002" BIGINT,
"id882_2004" BIGINT,
"id2075_2005" BIGINT
);
CREATE TABLE enforcement_data_enforcement_reports (
"dateserved" TIMESTAMP,
"n_852_2004" BIGINT,
"n_1099_2009" BIGINT,
"n_853_2004" BIGINT,
"n_2996_2013" BIGINT,
"n_1069_2009" BIGINT,
"n_999_2001" BIGINT,
"n_2952_2013" BIGINT,
"n_142_2011" BIGINT,
"n_178_2002" BIGINT,
"n_1724_2003" BIGINT,
"n_2073_2005" BIGINT,
"n_854_2004" BIGINT,
"n_931_2011" BIGINT,
"n_1774_2002" BIGINT,
"n_882_2004" BIGINT,
"n_2075_2005" BIGINT
);
Anyone who has the link will be able to view this.