About this Dataset

Prescribed Person

Summarised and anonymised details of disclosures made to the FSA as a Prescribed Person under public interest disclosure legislation. The FSA’s main objective is to protect public health from risks that may arise in connection with the consumption of food and otherwise to protect the interests of consumers in relation to food. It acts as central competent authority for enforcement of EU food and feed law.
Publisher name: Food Standards Agency
Last updated: 2024-10-30T14:41:55Z

Tables

Prescribed Person

@ukgov.prescribed_person.prescribed_person

21.92 kB
60 rows
19 columns

CREATE TABLE prescribed_person (
  "number" BIGINT,
  "disclosure_madebyanemployeeorcontractorofthefbo" VARCHAR  -- Disclosure(MadeByAnEmployeeOrContractorOfTheFBO),
  "issue" VARCHAR,
  "hasthefsadecidedtotakeactionintheperiod1_4_2017_31_3_2018" VARCHAR  -- HasTheFSADecidedToTakeActionInThePeriod1/4/2017-31/3/2018?,
  "wastheactiondecidedupontakenintheperiod1_4_2017_31_3_2018" VARCHAR  -- WasTheActionDecidedUponTakenInThePeriod1/4/2017-31/3/2018?,
  "wasthedisclousurereferredtoanalternativebody" VARCHAR  -- WasTheDisclousureReferredToAnAlternativeBody?,
  "wastheissueresolvedafterfirstcontactwiththeemployer" VARCHAR  -- WasTheIssueResolvedAfterFirstContactWithTheEmployer?,
  "iftheissuewasresolvedafterfirstcontactwiththeemployerh_f0a84fe2" VARCHAR  -- IfTheIssueWasResolvedAfterFirstContactWithTheEmployerHowWasTheIssueResolved?,
  "didthedisclosurerequirefurtherinvestigation" VARCHAR  -- DidTheDisclosureRequireFurtherInvestigation?,
  "wherethedisclosurerequiredfurtherinvestigationgiveasum_ed689a9e" VARCHAR  -- WhereTheDisclosureRequiredFurtherInvestigationGiveASummaryOfTheInvestigationsCarriedOutAndTheOutcomes.,
  "didthedisclosureleadtoactionbeingtaken" VARCHAR  -- DidTheDisclosureLeadToActionBeingTaken?,
  "hasthefsamaderecommendationstotheemployeronhowtheycoul_4387fe9b" VARCHAR  -- HasTheFSAMadeRecommendationsToTheEmployerOnHowTheyCouldRectifyProblemsFoundEitherInRelationToTheEmployersDisclosurePoliciesAndProceduresOrInRelationToTheIssuesWhichFormTheSubstanceOfTheDisclosure?,
  "didtheorganisationinvestigatedhavewhistleblowingpolici_8a848527" VARCHAR  -- DidTheOrganisationInvestigatedHaveWhistleBlowingPoliciesInPlace?,
  "wasthereevidenceofwrongdoing" VARCHAR  -- WasThereEvidenceOfWrongdoing?,
  "wheretherewasevidenceofwrongdoingwasenforcementactiontaken" VARCHAR  -- WhereThereWasEvidenceOfWrongDoingWasEnforcementActionTaken?,
  "ifenforcementactionwastakenenterthenumberofactionstaken" VARCHAR,
  "detailsoftheactiontaken" VARCHAR,
  "whereenforcementactionsweretakenasaresultofdisclosures_ebbb4765" VARCHAR  -- WhereEnforcementActionsWereTakenAsAResultOfDisclosuresWhatWereTheOutcomes?,
  "givedetailsofanyimpactthedisclosurehadontheprescribedp_a6a8d352" VARCHAR  -- GiveDetailsOfAnyImpactTheDisclosureHadOnThePrescribedPersonsAbilityToPerformItsFunctionsAndMeetItsObjectives.
);