{ "cells": [ { "attachments": {}, "cell_type": "markdown", "id": "a3be1a5b", "metadata": {}, "source": [ "##
\n", " | restaurant_serial_number | \n", "restaurant_permit_number | \n", "restaurant_name | \n", "restaurant_location | \n", "restaurant_category | \n", "address | \n", "city | \n", "state | \n", "zip | \n", "current_demerits | \n", "current_grade | \n", "employee_count | \n", "median_employee_age | \n", "median_employee_tenure | \n", "inspection_time | \n", "inspection_type | \n", "inspection_demerits | \n", "violations_raw | \n", "record_updated | \n", "lat_long_raw | \n", "first_violation | \n", "second_violation | \n", "third_violation | \n", "first_violation_type | \n", "second_violation_type | \n", "third_violation_type | \n", "number_of_violations | \n", "target | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6478 | \n", "DA1546062 | \n", "PR0013888 | \n", "Pump N Snack Deli | \n", "Pump N Snack | \n", "Snack Bar | \n", "329 N Las Vegas Blvd | \n", "Las Vegas | \n", "Nevada | \n", "89101-2965 | \n", "8.0 | \n", "A | \n", "24.0 | \n", "32.953746 | \n", "6.272959 | \n", "7/1/2015 14:30 | \n", "Routine Inspection | \n", "15 | \n", "2,152,172,222,909,290,000,000,000 | \n", "7/6/2015 12:12 | \n", "(36.171985, 115.139176) | \n", "215.0 | \n", "217.0 | \n", "222.0 | \n", "Major | \n", "Major | \n", "Major | \n", "7 | \n", "0 | \n", "
14817 | \n", "DA0984229 | \n", "PR0022849 | \n", "Tortilleria San Diego | \n", "Tortilleria San Diego | \n", "Restaurant | \n", "235 N Eastern Ave 117 | \n", "Las Vegas | \n", "NaN | \n", "89101-4542 | \n", "0.0 | \n", "A | \n", "15.0 | \n", "28.561471 | \n", "2.513798 | \n", "5/30/2012 10:10 | \n", "Routine Inspection | \n", "19 | \n", "211,212,214,215,216,000,000,000,000 | \n", "2/21/2013 22:26 | \n", "(36.1651291, 115.1164481) | \n", "211.0 | \n", "212.0 | \n", "214.0 | \n", "Major | \n", "Major | \n", "Major | \n", "9 | \n", "0 | \n", "
10530 | \n", "DA0946895 | \n", "PR0002002 | \n", "Sbarros #551 at Boulevard Mall | \n", "Boulevard Mall - Sbarros #551 | \n", "Restaurant | \n", "3528 S Maryland Pkwy | \n", "Las Vegas | \n", "Nevada | \n", "89169-3054 | \n", "8.0 | \n", "A | \n", "24.0 | \n", "36.845926 | \n", "3.101600 | \n", "2/28/2012 12:00 | \n", "Routine Inspection | \n", "6 | \n", "222,229,230,233 | \n", "2/21/2013 22:26 | \n", "(36.1248998, 115.1350531) | \n", "222.0 | \n", "229.0 | \n", "230.0 | \n", "Major | \n", "Non-Major | \n", "Non-Major | \n", "4 | \n", "0 | \n", "