PHILADELPHIA [Permits for PHILADELPHIA]

1 - 20 of 20

HUGHES, FAY

Individual

Inactive


Davies, Andrew

Individual

Active


SLOW CRAFT

Business

Active


JALIL, MOHAMMAD

Individual

Inactive


MASCH, EZRA

Business

Inactive




Novak, Michael

Individual

Active


LANG, LAURENCE ROY

Individual

Inactive


SOLAR STATES LLC

Business

Inactive


HOPKINS, DAVID

Individual

Inactive


FELTON, LAUREN

Individual

Active


HERTZOG, LINDSAY

Individual

Inactive


YODER, JOSHUA

Individual

Active


Hensell, Jennifer

Individual

Active



GOLD-MARKEL, MICAH

Individual

Inactive


MARK GROUP OF NEW YORK

Business

Inactive


TATE & KIRLIN ASSOCIATES, INC.

Business

Inactive


LANG CONSTRUCTION LLC

Business

Inactive


(default) 1 query took 210 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+PHILADELPHIA)' IN BOOLEAN MODE) LIMIT 502020210