CARMEL

201 - 250 of 292

CARMEL RICHMOND NURSING HOME

#

PHYSICIAN

CARMEL-YORK INC

#0007078

EQUIPMENT WORK

MANHATTAN

MT CARMEL ASSOCIATES LTD

#

INCORRECT LICENSE

MANHATTAN

DAN CARMEL FOOD, INC.

#

RETAIL FOOD PROCESS

QUEENS

CARMEL - MD DONOVAN

#

PHYSICIAN

CARMEL PALACE, INC.

#

FOOD SERVICE EST.

BROOKLYN

MT CARMEL PIZZERIA CORP

#

FOOD SERVICE EST.

MANHATTAN

CARMEL BAKERY, INC.

#

FOOD SERVICE EST.

BROOKLYN

DONOVAN (OWNER) CARMEL

#

PHYSICIAN

MANHATTAN

MT CARMEL PIZZERIA CORP

#

FOOD SERVICE EST.

MANHATTAN

DONOVAN CARMEL - MD

#

PHYSICIAN

DONOVAN CARMEL - MD

#

PHYSICIAN

CARMEL-YORK INC

#0007078

EQUIPMENT WORK

QUEENS

ARCHDIOCESE OF NEW YORK-OUR LADY OF MOUNT CARMEL ST. BENEDICT

#

CHILD CARE APPLICATION TRACKING SYSTEM

STATEN ISLAND

MONT CARMEL BAKERY INC

#

FOOD SERVICE EST.

BROOKLYN

CARMEL-YORK INC

#0007078

EQUIPMENT WORK

MANHATTAN

CARMEL/HOLY ROS MT

#

FOOD SVC ESTAB. NON

CARMEL/HOLY ROS MT

#

FOOD SVC ESTAB. NON

CARMEL/HOLY ROS MT

#

FOOD SVC ESTAB. NON

MT CARMEL BAPTIST CHURCH

#

INCORRECT LICENSE

BRONX

DR. CARMEL DONOVAN

#

PHYSICIAN

CARMEL DONOVAN (OWNER)

#

PHYSICIAN

CARMEL-YORK INC

#0007078

EQUIPMENT WORK

MANHATTAN

HALL, CARMEL

#

TEMP FOOD SERV ESTAB

MT CARMEL PIZZERIA CORP

#

FOOD SERVICE EST.

MANHATTAN

CARMEL HAIR STYLISTS,LTD.

#

BEAUTY PARLOR

CARMEL STATEN

#

INCORRECT LICENSE

CARMEL EQUITIES LLC

#

INCORRECT LICENSE

BROOKLYN

CLASSIC RESTAUR CARMEL

#

FOOD SERVICE EST.

MT CARMEL ASSOCIATES

#

INCORRECT LICENSE

MANHATTAN

CARMEL JOURDAN

#

BEAUTY PARLOR

BROOKLYN

CARMEL STATEN

#

INCORRECT LICENSE

HALL, CARMEL

#

TEMP FOOD SERV ESTAB

MT. CARMEL BAPTIST CHURCH INC.

#

DOHMH permit not required

CARMEL HALL

#

TEMP FOOD SERV ESTAB

CARMEL ENTERPRISES

#

INCORRECT LICENSE

CARMEL APARTMENTS CO

#

INCORRECT LICENSE

BROOKLYN

CARMEL REAL ESTATE

#

INCORRECT LICENSE

BRONX

MT. CARMEL BAPTIST CHURCH

#

INCORRECT LICENSE

MANHATTAN

CARMEL REAL ESTATE EQ

#

INCORRECT LICENSE

BRONX

2206 CARMEL RLTY CORP

#

INCORRECT LICENSE

OUR LADY OF MOUNT CARMEL R C

#

INCORRECT LICENSE

QUEENS

MT CARMEL BAPTIST CHURCH

#

INCORRECT LICENSE

MONT CARMEL BAKERY INC

#

FOOD SERVICE EST.

BROOKLYN

CARMEL DONOVAN DR.

#

PHYSICIAN

MANHATTAN

CARMEL - MD DONOVAN

#

PHYSICIAN

MANHATTAN

CARMEL/HOLY ROS MT

#

FOOD SVC ESTAB. NON

CARMEL/HOLY ROS MT

#

FOOD SVC ESTAB. NON

CARMEL CHRISTIAN NURSERY AND GRADE SCHOOL

#

CHILD CARE APPLICATION TRACKING SYSTEM

DONOVAN CARMEL - MD

#

PHYSICIAN

(default) 2 queries took 56 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Permit`.`id`, `Permit`.`Source`, `Permit`.`License_Permit_Holder`, `Permit`.`Business_Description`, `Permit`.`License/Permit_Number`, `Permit`.`Permit_Type_Description`, `Permit`.`Permit_Subtype_Description`, `Permit`.`Permit_Issuance_Date`, `Permit`.`Permit_Expiration_Date`, `Permit`.`Permit_Status_Date`, `Permit`.`Permit_Status_Description`, `Permit`.`Address`, `Permit`.`Street`, `Permit`.`City`, `Permit`.`Zip_Code`, `Permit`.`Borough`, `Permit`.`Building_ID_No`, `Permit`.`Borough_Block_Lot`, `Permit`.`Latitude_WGS84`, `Permit`.`Longitude_WGS84`, `Permit`.`License/Permit_Holder_Name`, `Permit`.`DOB_Skilled_Trades_Lic_Num`, `Permit`.`DOB_Skilled_Trades_Lic_Type` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+CARMEL)' IN BOOLEAN MODE) LIMIT 200, 50		50	50	47
2	SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+CARMEL)' IN BOOLEAN MODE)		1	1	9