Table about all food businesses including home kitchen, mobile, restaurants, cafe .. registered with council.
Column_InfoAccount_Number, varchar : Unique Identifier of a food premise. Also used as PRIMARY KEY of this tableFood_Premise_Name, varchar : Trading name of businessStatus, varchar : Shows whether the premise is active or notExternal_Reference_Number, varchar : Unique registration number with MPIDetermination_Code, varchar : Code to define the status of registrationInspection_Area, int : Defines the area of premisePremise_Type, varchar : Type of food business eg: diary, takeaway ..Modified_Date, datetime : Last modified date of this recordRMP_Type, varchar : Type of registration under food actInitial_Visit_Date, datetime : Date of recent audit/inspectionSite_Number, int : Site number of registrationVerification_Frequency, int : Shows how often the premise is auditedVerification_Frequency_Description, varchar : Description of audit frequencyNZBN, varchar : Unique identifier of the company owning the food premise
Relationship
This table is referenced by Food_Premise_To_Food_Premise_RegistrationThis table is referenced by Food_Premise_To_ParcelThis table is referenced by Food_Premise_TransactionThis table is referenced by Food_Premise_Verification
Analytics
For convenience Hamilton City Council has also built a Quick Analytics Dashboard over this dataset that you can access here.
Disclaimer
Hamilton City Council does not make any representation or give any warranty as to the accuracy or exhaustiveness of the data released for public download. Levels, locations and dimensions of works depicted in the data may not be accurate due to circumstances not notified to Council. A physical check should be made on all levels, locations and dimensions before starting design or works.
Hamilton City Council shall not be liable for any loss, damage, cost or expense (whether direct or indirect) arising from reliance upon or use of any data provided, or Council's failure to provide this data.
While you are free to crop, export and re-purpose the data, we ask that you attribute the Hamilton City Council and clearly state that your work is a derivative and not the authoritative data source. Please include the following statement when distributing any work derived from this data:
‘This work is derived entirely or in part from Hamilton City Council data; the provided information may be updated at any time, and may at times be out of date, inaccurate, and/or incomplete.'
