Dataset: Inspection Score - Restaurant Inspection

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

708.7 KB
45006 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
);