CROMWELL

1 - 50 of 56

CROMWELL COLLISION & TOWING

#0012925

EQUIPMENT WORK

BRONX

CROMWELL COLLISION & TOWING

#0012925

EQUIPMENT WORK

BRONX

CROMWELL COLLISION & TOWING

#0012925

EQUIPMENT WORK

BRONX

CROMWELL COLLISION & TOWING

#0012925

EQUIPMENT WORK

BRONX

CROMWELL & TISH BUILDING CONSTRU

#0039822

ALTERATION

QUEENS

PARKS NYC KIDS ON STAGE CROMWELL REC.

#

CONDUCT A DAY CAMP

RON BENCID CROMWELL ASSOC

#

INCORRECT LICENSE

MANHATTAN

1429 CROMWELL AVENUE

#

INCORRECT LICENSE

BRONX

STUART CROMWELL INC.

#

WELL WATER

MANHATTAN

1455 CROMWELL HOLDINGS CORP MGMT

#

INCORRECT LICENSE

BRONX

SULLIVAN & CROMWELL

#

FOOD SERVICE EST.

MANHATTAN

SULLIVAN & CROMWELL

#

FOOD SERVICE EST.

MANHATTAN

CROMWELL REALTY CORP

#

INCORRECT LICENSE

CROMWELL, COLIA & NOEL, ADDISON

#

TEMP FOOD SERV ESTAB

CROMWELL ENTERPRISES INC.

#

INCORRECT LICENSE

BRONX

INWOOD CROMWELL PROP

#

INCORRECT LICENSE

BRONX

INWOOD CROMWELL PROP

#

FULL TERM MFV PERMIT

BRONX

1429 CROMWELL AVENUE

#

INCORRECT LICENSE

BRONX

CROMWELL, JAMES JR

#

FOOD SVC ESTAB. NON

MANHATTAN

CROMWELL ASSOC

#

INCORRECT LICENSE

MANHATTAN

CROMWELL ENTERPRISES INC.

#

INCORRECT LICENSE

BRONX

COLIN CROMWELL & ADDISON NOEL

#

TEMP FOOD SERV ESTAB

1184 CROMWELL LLC

#

DOHMH permit not required

1160 CROMWELL AVE OWNER LLC

#

DOHMH permit not required

INWOOD CROMWELL PROP

#

INCORRECT LICENSE

BRONX

CROMWELL, COLIA & NOEL, ADDISON

#

TEMP FOOD SERV ESTAB

PARKS NYC KIDS ON STAGE CROMWELL REC.

#

MOBILE FOOD UNIT

BRONX

1160 CROMWELL AVE OWNER LLC

#

INCORRECT LICENSE

BRONX

CROMWELL ARMS CONDOMINIUM

#

INCORRECT LICENSE

SULLIVAN & CROMWELL

#

FOOD SERVICE EST.

MANHATTAN

CROMWELL ARMS CONDOMINIUM

#

INCORRECT LICENSE

1184 CROMWELL LLC

#

INCORRECT LICENSE

BRONX

CROMWELL ASSOCIATES

#

INCORRECT LICENSE

MANHATTAN

INWOOD CROMWELL PROP

#

INCORRECT LICENSE

BRONX

RAMSEY CROMWELL

#

INCORRECT LICENSE

SULLIVAN & CROMWELL

#

FOOD SERVICE EST.

MANHATTAN

STUART CROMWELL INC.

#

FOOD SERVICE EST.

MANHATTAN

SVS SYSTEMS CORP/SULLIVAN & CROMWELL

#

N/A

MANHATTAN

SVC SYSTEMS CORP.SULLIVAN & CROMWELL

#

N/A

STUART CROMWELL INC.

#

FOOD SERVICE EST.

MANHATTAN

CROMWELL, JAMES JR

#

N/A

SULLIVAN & CROMWELL

#

FOOD SERVICE EST.

MANHATTAN

CROMWELL CENTER

#

CONDUCT A DAY CAMP

CROMWELL ASSOC

#

INCORRECT LICENSE

MANHATTAN

CROMWELL ASSOCIATES

#

INCORRECT LICENSE

MELROSE MANAGEMENT / CROMWELL ASSOCIATES

#

INCORRECT LICENSE

MANHATTAN

CROMWELL ASSOCIATES

#

INCORRECT LICENSE

MANHATTAN

CROMWELL ARM CONDOMINIUM ASSC

#

INCORRECT LICENSE

CROMWELL ASSOC C/O BMC ELHONE

#

INCORRECT LICENSE

MANHATTAN

CROMWELL REALTY LLC

#

INCORRECT LICENSE

BRONX

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