Name: Inspection Score - Restaurant Inspection
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Inspection Score - Restaurant Inspection

Content

This dataset consists of information about various business in USA regarding their inspection, inspection type, inspection score, location, business type...
Column Description

Name of the columns

Business ID : Id of the business

Business Name: Name of the busines

Business Adress : Adress of the business

Business city : City

Business State: 2 letters States code

Business postal code : number serie

Business phone number : Phone number of the business

Inspection date: specific date

Inspection Score : Score between 0 and 100

Inspection Description : Tips and unexpected discover from the inspector

Inspection_type : Regular inspection or no

Violation Description : explenation of the violation

violation code : 4 letters

Business entire location : adresse, city and state

Acknowledgements
https://www.wikipedia.org/
https://data.muni.org/d/6sdz-r9ba

Tables

Restaurant And Food Inspections 1

@kaggle.loulouashley_inspection_score_restaurant_inspection.restaurant_and_food_inspections_1

725.71 kB
45,006 rows
14 columns

CREATE TABLE restaurant_and_food_inspections_1 (
  "business_id" VARCHAR,
  "business_name" VARCHAR,
  "business_address" VARCHAR,
  "business_city" VARCHAR,
  "business_state" VARCHAR,
  "business_postal_code" BIGINT,
  "business_phone_number" DOUBLE,
  "inspection_date" TIMESTAMP,
  "inspection_score" DOUBLE,
  "inspection_description" VARCHAR,
  "inspection_type" VARCHAR,
  "violation_description" VARCHAR,
  "violation_code" VARCHAR,
  "business_location" VARCHAR
);