Permit # issued to ARK 27TH STREET,INC/ALBUQUERQUE EATS of type RETAIL FOOD PROCESS (FOOD SERVICE ESTABL WITH MFD MACHINE) -
201
3 AVENUE
NEW YORK
MANHATTAN
10003
Source | DOHMH Permit |
License Permit Holder | ARK 27TH STREET,INC/ALBUQUERQUE EATS |
Business Description | N/A |
License/permit Number | 285579 |
Permit Type Description | RETAIL FOOD PROCESS |
Permit Subtype Description | FOOD SERVICE ESTABL WITH MFD MACHINE |
Permit Issuance Date | 0000-00-00 |
Permit Expiration Date | 0000-00-00 |
Permit Status Date | 0000-00-00 |
Permit Status Description | |
Address | 201 |
Street | 3 AVENUE |
City | NEW YORK |
Zip Code | 10003 |
Borough | MANHATTAN |
Building Id No | 1019868 |
Borough Block Lot | 1009080001 |
Latitude Wgs84 | 40.74133400 |
Longitude Wgs84 | -73.98098200 |
License/permit Holder Name | MICHAEL WEINSTEIN |
Dob Skilled Trades Lic Num | |
Dob Skilled Trades Lic Type |
Leave your comments, questions and feedback on this listing below. You can also correct any listing errors or omissions.
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 `Permit`.`id` = 2712222 LIMIT 1 | 1 | 1 | 1 | |
2 | 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 `Permit`.`id` < 2712222 ORDER BY `Permit`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
3 | 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 `Permit`.`id` >= 2712221 AND `Permit`.`id` != 2712222 ORDER BY `Permit`.`id` ASC LIMIT 2 | 2 | 2 | 0 |