Inspectional Services Department, City of Boston: Food Establishment Inspections

Category Inference

Food establishments (restaurants, cafes, food vendors, bakeries, etc.) in the City of Boston that have undergone health and sanitary inspections by the Inspectional Services Department

Fallback category: eat_and_drink›restaurant

Source Schema

(27 columns)

Name	Type	Null %	Unique	Sample values
_id	int64	0.0%	10000	`34` `153` `234`
businessname	object	0.0%	3961	`100 Federal Market & Barista- 11th Floor` `100 Percent Delicia Food` `100 Percent Delicias Express`
dbaname	object	99.0%	53	`Ariana Cuisine of Afghanistan` `HSI MCA BOS FB LLC` `Neptune Liquors`
legalowner	object	35.0%	1766	`ONE HUNDRED FEDERAL ST LPS` `BRENNAN PATRICK E` `STAMATOS GEORGE C`
namelast	object	0.0%	3862	`Compass Group USA Inc` `Marte` `100 Percent Delicias Express LLC`
namefirst	object	43.2%	1828	`Attn:Licensing` `Civelis` `Lewis Crespo`
licenseno	int64	0.0%	4498	`443880` `87059` `351943`
issdttm	object	0.1%	4492	`2021-11-04 16:59:15+00` `2013-04-05 16:47:23+00` `2018-11-26 14:59:52+00`
expdttm	object	0.1%	24	`2027-01-01 04:59:00+00` `2021-01-01 04:59:00+00` `2023-01-01 04:59:00+00`
licstatus	object	0.0%	3	`Active` `Inactive` `Inactive`
licensecat	object	0.0%	4	`FT` `FS` `FT`
descript	object	0.0%	4	`Eating & Drinking w/ Take Out` `Eating & Drinking` `Eating & Drinking w/ Take Out`
result	object	0.0%	15	`HE_Filed` `HE_FailExt` `HE_Fail`
resultdttm	object	0.8%	9266	`2021-11-03 14:47:15+00` `2017-11-21 19:14:41+00` `2020-09-25 16:47:12+00`
violation	object	7.0%	302	`590.006/6-201.12-C` `23-4-602.13` `590.006/6-202.14-C`
viol_level	object	7.0%	4	`` `` `*`
violdesc	object	7.7%	297	`Floors Walls and Ceilings Utility Lines (C)` `Non-Food Contact Surfaces Clean` `Toilet Rooms Enclosed (C)`
violdttm	object	7.0%	8830	`2021-11-03 14:47:15+00` `2017-11-21 19:14:41+00` `2020-09-25 16:47:12+00`
viol_status	object	7.0%	3	`Fail` `Pass` `Fail`
status_date	object	58.5%	3906	`2017-11-21 20:48:57+00` `2024-05-01 19:10:45+00` `2022-09-08 18:33:24+00`
comments	object	10.1%	8682	`The ceiling is an exposed ceiling. Provide a cleanable surface (will talk to heatlh department supervisors about the ceiling)` `Clean shelves in walk in. Visibly soiled. Clean exterior of bulk foods container in walk in. Clean exterior and interior of deep fryer. Visibly soiled. Clean interior of freezers in hasement.` `restroom/provide self closing door`
address	object	0.1%	3099	`100 FEDERAL ST` `635 HYDE PARK AV` `656 CENTRE ST`
city	object	0.0%	25	`BOSTON` `ROSLINDALE` `JAMAICA PLAIN`
state	object	0.2%	3	`MA` `MA` `MA`
zip	object	0.1%	36	`02110` `02131` `02130`
property_id	float64	18.3%	2683	`57150.0` `77476.0` `28152.0`
location	object	9.2%	2937	`(42.354770000088834, -71.0561300019333)` `(42.27859000007066, -71.11944000169517)` `(42.312829999643, -71.11386000152196)`

Quality Report

✅ Dataset is usable

Geographic Bounds

Coordinates: Southwest (-71.1742, 42.2314) - Northeast (-70.9967, 42.3952)

Inspectional Services Department, City of BostonFood Establishment Inspections

Categories

Category Inference

Source Schema

Quality Report

Geographic Bounds