Restaurants
This table captures all Wake County performs sanitations inspections from September 20, 2012 to present. This table is part of a set of data that combined will give you a picture of all restaurant inspections.  Those three tables are:Restaurants: This table captures all active facilities where Wake County performs sanitations inspections.  Facilities that are closed are removed from all three files in this dataset.  Per NC State regulations, facilities that have a change in ownership are considered closed and the restaurant re-opens under a new permit, even if there is not a change in the name of the restaurant.Inspections: This table captures all Wake County performs sanitations inspections at active restaurants since September 20, 2012Violations: This table captures all violations identified during specific Wake County sanitations inspections at active restaurants since September 20, 2012.  It reports the results in code violations and according to CDC Risk Factors.  You can find additional information about the CDC Risk Factors on the FDA website: Retail Risk Factor StudyThe tables can be connected through the HSISID field and the Permit ID field.
[]
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'OBJECTID', 'domain': None}, {'name': 'HSISID', 'type': 'esriFieldTypeString', 'alias': 'HSISID', 'length': 11, 'domain': None}, {'name': 'NAME', 'type': 'esriFieldTypeString', 'alias': 'NAME', 'length': 150, 'domain': None}, {'name': 'ADDRESS1', 'type': 'esriFieldTypeString', 'alias': 'ADDRESS1', 'length': 150, 'domain': None}, {'name': 'ADDRESS2', 'type': 'esriFieldTypeString', 'alias': 'ADDRESS2', 'length': 150, 'domain': None}, {'name': 'CITY', 'type': 'esriFieldTypeString', 'alias': 'CITY', 'length': 150, 'domain': None}, {'name': 'STATE', 'type': 'esriFieldTypeString', 'alias': 'STATE', 'length': 2, 'domain': None}, {'name': 'POSTALCODE', 'type': 'esriFieldTypeString', 'alias': 'POSTALCODE', 'length': 10, 'domain': None}, {'name': 'PHONENUMBER', 'type': 'esriFieldTypeString', 'alias': 'PHONENUMBER', 'length': 30, 'domain': None}, {'name': 'RESTAURANTOPENDATE', 'type': 'esriFieldTypeDate', 'alias': 'RestaurantOpenDate', 'length': 8, 'domain': None}, {'name': 'FACILITYTYPE', 'type': 'esriFieldTypeString', 'alias': 'FACILITYTYPE', 'length': 150, 'domain': None}, {'name': 'PERMITID', 'type': 'esriFieldTypeInteger', 'alias': 'PERMITID', 'domain': None}, {'name': 'X', 'type': 'esriFieldTypeDouble', 'alias': 'X', 'domain': None}, {'name': 'Y', 'type': 'esriFieldTypeDouble', 'alias': 'Y', 'domain': None}, {'name': 'GEOCODESTATUS', 'type': 'esriFieldTypeString', 'alias': 'GEOCODESTATUS', 'length': 1, 'domain': None}, {'name': 'SHAPE', 'type': 'esriFieldTypeGeometry', 'alias': 'SHAPE', 'domain': None}]
[{'name': 'GDB_10961_HSISID', 'fields': 'HSISID', 'isAscending': True, 'isUnique': False, 'description': ''}, {'name': 'R1419187_SDE_ROWID_UK', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'A4189_IX1', 'fields': 'SHAPE', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSMS', 'style': 'esriSMSCircle', 'color': [166, 0, 149, 255], 'size': 4, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'outline': {'color': [0, 0, 0, 255], 'width': 1}}}, 'scaleSymbols': True, 'transparency': 0, 'labelingInfo': None}
nan
nan