ADDISON

1 - 50 of 57

BLAKE ADDISON

#0011063

EQUIPMENT WORK

NEW YORK

MANHATTAN


BLAKE ADDISON

#0016110

EQUIPMENT WORK

NEW YORK

MANHATTAN


BLAKE ADDISON

#0016110

EQUIPMENT WORK

NEW YORK

MANHATTAN


HOLLAND ADDISON LLC

#0033386

EQUIPMENT WORK

NEW YORK

MANHATTAN


HOLLAND ADDISON LLC

#0033386

EQUIPMENT WORK

NEW YORK

MANHATTAN


HOLLAND ADDISON LLC

#0033386

EQUIPMENT WORK

NEW YORK

MANHATTAN


HOLLAND ADDISON LLC

#0033386

EQUIPMENT WORK

NEW YORK

MANHATTAN


HOLLAND ADDISON LLC

#0033386

EQUIPMENT WORK

NEW YORK

MANHATTAN


HOLLAND ADDISON LLC

#0033386

EQUIPMENT WORK

NEW YORK

MANHATTAN


NEW YORK

MANHATTAN


T. ADDISON

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN



ADDISON DOLORES J.H

#

INCORRECT LICENSE

BRONX

BRONX


T. ADDISON

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN


CROMWELL, COLIA & NOEL, ADDISON

#

TEMP FOOD SERV ESTAB


DAWKINS,ADDISON

#

DENTIST


DAWKINS ADDISON

#

PHYSICIAN


H ADDISON

#

DOHMH permit not required

JAMAICA

QUEENS




MARISSA ADDISON & JAYNE ROSOVICH

#

INCORRECT LICENSE


ADDISON, NOEL

#

TEMP FOOD SERV ESTAB

BROOKLYN

BROOKLYN


ADDISON CRAWFORD

#

INCORRECT LICENSE


BOWMAN ADDISON V.-PC

#

PHYSICIAN


COLIN CROMWELL & ADDISON NOEL

#

TEMP FOOD SERV ESTAB


CROMWELL, COLIA & NOEL, ADDISON

#

TEMP FOOD SERV ESTAB




ADDISON MICHAEL

#

INCORRECT LICENSE



NEW YORK

MANHATTAN


ADDISON JAMES R

#

INCORRECT LICENSE


ADDISON A BRANCH JR

#

INCORRECT LICENSE

STATEN ISLAND

STATEN ISLAND


ADDISON HALL OWNER CORP

#

INCORRECT LICENSE


Crab Addison Inc.

#

FOOD SERVICE EST.


CRAB ADDISON, INC.

#

FOOD SERVICE EST.


CRAB ADDISON, INC.

#

RETAIL FOOD PROCESS


CRAB ADDISON, INC.

#

RETAIL FOOD PROCESS


CRAB ADDISON, INC.

#

RETAIL FOOD PROCESS


CRAB ADDISON, INC.

#

FOOD SERVICE EST.


CRAB ADDISON, INC.

#

RETAIL FOOD PROCESS


Crab Addison Inc.

#

FOOD SERVICE EST.


CRAB ADDISON, INC.

#

RETAIL FOOD PROCESS


CRAB ADDISON, INC.

#

RETAIL FOOD PROCESS


Crab Addison Inc.

#

FOOD SERVICE EST.


Crab Addison Inc.

#

FOOD SERVICE EST.


CRAB ADDISON, INC.

#

RETAIL FOOD PROCESS


CRAB ADDISON, INC.

#

RETAIL FOOD PROCESS


Crab Addison Inc.

#

FOOD SERVICE EST.


Crab Addison Inc.

#

FOOD SERVICE EST.


(default) 2 queries took 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 ( '(+ADDISON)' IN BOOLEAN MODE) LIMIT 5050509
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+ADDISON)' IN BOOLEAN MODE)113