CHICAGO

1 - 50 of 118

ARA SERV.INC-NATIONAL BANK OF CHICAGO

#

MANUF FROZEN DESSERT

ARA SVCES INC IST NTNL BANK CHICAGO

#

FOOD SERVICE EST.

FIRST NATIONAL BANK CHICAGO

#

INCORRECT LICENSE

MANHATTAN

MORTON'S OF CHICAGO/CEDAR STREET, LLC

#

FOOD SERVICE EST.

CHICAGO CITY LIMITS PERFORMING CORP

#

FOOD SERVICE EST.

MANHATTAN

CHICAGO CITY LIMITS PERFORMING CORP

#

FOOD SERVICE EST.

MANHATTAN

FIRST NATIONAL BANK CHICAGO

#

INCORRECT LICENSE

MANHATTAN

FIRST NAT'L BANK CHICAGO

#

INCORRECT LICENSE

MANHATTAN

FIRST NAT'L BANK OF CHICAGO

#

INCORRECT LICENSE

MANHATTAN

MORTON'S OF CHICAGO FIFTH AVENUE, INC

#

FOOD SERVICE EST.

MORTON'S OF CHICAGO FIFTH AVENUE, INC

#

FOOD SERVICE EST.

CHICAGO INVESTORS INC/CR

#

INCORRECT LICENSE

MANHATTAN

ARA SVCES INC IST NTNL BANK CHICAGO

#

FOOD SERVICE EST.

MANHATTAN

CHICAGO CITY LIMITS PERFORMING CORP

#

FOOD SERVICE EST.

MANHATTAN

CHICAGO RESTAURANT INC.

#

FOOD SERVICE EST.

MANHATTAN

CHICAGO 60, INC

#

FOOD SERVICE EST.

FIRST NATIONAL BANK OF CHICAGO

#

INCORRECT LICENSE

BRONX

FIRST NAT'L BANK CHICAGO

#

INCORRECT LICENSE

BIG AL'S CHICAGO PIZZA INC

#

FOOD SERVICE EST.

STATEN ISLAND

FIRST NAT'L BANK CHICAGO

#

INCORRECT LICENSE

BROOKLYN

FIRST NAT'L BANK CHICAGO

#

INCORRECT LICENSE

CHICAGO STYLE PIZZA INC.

#

FOOD SERVICE EST.

BROOKLYN

ARA SERV.INC-NATIONAL BANK OF CHICAGO

#

MANUF FROZEN DESSERT

MANHATTAN

ARA SERV.INC-NATIONAL BANK OF CHICAGO

#

MANUF FROZEN DESSERT

MANHATTAN

CHICAGO CITY LIMITS PERFORMING CORP

#

FOOD SERVICE EST.

MANHATTAN

ARA SVCES INC. 1ST NTNL BANK CHICAGO

#

N/A

MANHATTAN

CHICAGO 60, INC

#

FOOD SERVICE EST.

CHICAGO DELI-N-GRILL, INC.

#

FOOD SERVICE EST.

SOUTH RICHMOND HILL

QUEENS

FIRST NAT'L BANK CHICAGO

#

INCORRECT LICENSE

MORTON'S OF CHICAGO/BROOKLYN, LLC

#

FOOD SERVICE EST.

FIRST NATIONAL BANK OF CHICAGO

#

INCORRECT LICENSE

BRONX

MORTON'S OF CHICAGO/BROOKLYN, LLC

#

FOOD SERVICE EST.

MORTON'S OF CHICAGO/BROOKLYN, LLC

#

FOOD SERVICE EST.

CHICAGO DELI-N-GRILL, INC.

#

FOOD SERVICE EST.

SOUTH RICHMOND HILL

QUEENS

MORTONS OF CHICAGO

#

FOOD SERVICE EST.

FIRST NATIONAL BANK OF CHICAGO

#

INCORRECT LICENSE

BRONX

FIRST NAT'L BANK CHICAGO

#

INCORRECT LICENSE

BROOKLYN

FIRST NAT'L BANK CHICAGO

#

INCORRECT LICENSE

MANHATTAN

FIRST NAT'L BANK CHICAGO

#

INCORRECT LICENSE

MANHATTAN

MORTON'S OF CHICAGO FIFTH AVENUE, INC

#

FOOD SERVICE EST.

MORTON'S OF CHICAGO/BROOKLYN, LLC

#

TEMP FOOD SERV ESTAB

CHICAGO INVESTORS INC/CR

#

INCORRECT LICENSE

MANHATTAN

MORTONS OF CHICAGO

#

FOOD SERVICE EST.

MORTON'S OF CHICAGO FIFTH AVENUE, INC

#

FOOD SERVICE EST.

MORTON'S OF CHICAGO/CEDAR STREET, LLC

#

FOOD SERVICE EST.

ARA SERV.INC-NATIONAL BANK OF CHICAGO

#

MANUF FROZEN DESSERT

MANHATTAN

MORTON'S OF CHICAGO/CEDAR STREET, LLC

#

FOOD SERVICE EST.

CHICAGO 60, INC

#

FOOD SERVICE EST.

ARA SVCES INC IST NTNL BANK CHICAGO

#

FOOD SERVICE EST.

MANHATTAN

MORTON'S OF CHICAGO/CEDAR STREET, LLC

#

FOOD SERVICE EST.

(default) 2 queries took 16 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 ( '(+CHICAGO)' IN BOOLEAN MODE) LIMIT 50		50	50	7
2	SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+CHICAGO)' IN BOOLEAN MODE)		1	1	9