About this Dataset

Food Hygiene Rating Scheme Camden

This dataset contains food hygiene ratings or inspection results given to businesses located in the London Borough of Camden, and reflect the standards of food hygiene found on the date of inspection or visit by Camden Borough Council. Businesses include restaurants, pubs, cafes, takeaways, hotels and other places consumers eat, as well as supermarkets and other food shops. Attribution includes the business name, address, rating value (0-5), rating date, ward name and spatial location. Please note, not every business has the correct spatial location - these are included in the data but omitted from the map.
Publisher name: London Borough of Camden
Last updated: 2025-06-30T04:00:28Z

Tables

Table 1

@ukgov.food_hygiene_rating_scheme_camden_1.table_1

359.49 KB
4280 rows
30 columns


CREATE TABLE table_1 (
  "business_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "address_line_3" VARCHAR,
  "postcode" VARCHAR,
  "business_type_id" BIGINT,
  "business_type_description" VARCHAR,
  "food_hygiene_rating_scheme_id" BIGINT,
  "food_hygiene_rating_scheme_type" VARCHAR,
  "hygiene_score" DOUBLE,
  "structural_score" DOUBLE,
  "confidence_in_management_score" DOUBLE,
  "rating_value" VARCHAR,
  "rating_date" TIMESTAMP,
  "new_rating_pending" BOOLEAN,
  "local_authority_business_id" BIGINT,
  "local_authority_code" BIGINT,
  "local_authority_name" VARCHAR,
  "local_authority_email_address" VARCHAR,
  "local_authority_website" VARCHAR,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" TIMESTAMP,
  "location" VARCHAR,
  "organisation_uri" VARCHAR
);