MEXICO

1 - 50 of 534

MEXICO CITY INC.

#0042244

EQUIPMENT WORK

MEXICO MECHANICAL MAINTENANCE CO

#0031134

EQUIPMENT WORK

BRONX

NUEVA VIVA MEXICO INC

#

EQUIPMENT WORK

JACKSON HEIGHTS

QUEENS

NUEVO VIVA MEXICO INC

#

EQUIPMENT WORK

JACKSON HEIGHTS

QUEENS

TACO MEXICO

#

EQUIPMENT WORK

JACKSON HEIGHTS

QUEENS

MEXICO MECHANICAL MAINTENANCE C

#0031134

EQUIPMENT WORK

BRONX

MEXICO MECHANICAL MAINTENANCE

#0031134

EQUIPMENT WORK

BRONX

NUEVO MEXICO LINDO SU ABARROTERA

#0999994

EQUIPMENT WORK

QUEENS

TACO MEXICO

#

EQUIPMENT WORK

JACKSON HEIGHTS

QUEENS

NUEVO VIVA MEXICO INC

#

EQUIPMENT WORK

JACKSON HEIGHTS

QUEENS

NUEVO VIVA MEXICO INC

#

EQUIPMENT WORK

JACKSON HEIGHTS

QUEENS

FRONTERA MEXICO DELI-FOOD & GROCERY CORP.

#

FOOD SERVICE EST.

QUEENS

T.J. INNOVATIONS INC/MEXICO CITY CAFE

#

RETAIL FOOD PROCESS

QUEENS

2004 VIVA MEXICO INC.

#

FOOD SERVICE EST.

MAN-RAY REST. CORP./MEXICO MAGICO RES

#

FOOD SERVICE EST.

MANHATTAN

GRAN ALIANZA MEXICO AMERICANA U.S.A.

#

TEMP FOOD SERV ESTAB

KING TACOS MEXICO CORP

#

FOOD SERVICE EST.

QUEENS

PLAZA MEXICO INC

#

MOBILE FOOD UNIT

MANHATTAN

PLAZA MEXICO INCORPORATED

#

N/A

QUEENS

NEW MEXICO REST. OP CORP

#

FOOD SERVICE EST.

GUITARRAS MEXICO RESTAURANT INC

#

FOOD SERVICE EST.

GRAN ALIANZA MEXICO AMERICANA USA

#

TEMP FOOD SERV ESTAB

MEXICO LINDO RESTAURANT,INC.

#

RETAIL FOOD PROCESS

MANHATTAN

TACOS MEXICO CORP

#

FOOD SERVICE EST.

QUEENS

MEXICO LINDO REST, CORP.

#

MANUF FROZEN DESSERT

MANHATTAN

EL NUEVO MEXICO REST CORP.

#

FOOD SERVICE EST.

MANHATTAN

TRES DE MEXICO, LLC

#

FOOD SERVICE EST.

EL PASTORCITO DEL MEXICO INCORPORATED

#

FOOD SERVICE ESTAB

MANHATTAN

H. MARTINEZ/GROCERY VALLE MEXICO AZTE

#

TEMP FOOD SERV ESTAB

MEXICO LINDO RESTAURANT,INC.

#

RETAIL FOOD PROCESS

MANHATTAN

MEXICO CITY INC

#

N/A

FRONTERA MEXICO DELI-FOOD & GROCERY CORP.

#

FOOD SERVICE EST.

QUEENS

SABOR A MEXICO RESTUARANT INC

#

FOOD SERVICE EST.

VALLE OF MEXICO AZTEC CORP

#

FOOD SERVICE EST.

GRAN ALIANZA MEXICO AMERICAN USA

#

TEMP FOOD SERV ESTAB

MEXICO INTERNATIONAL BUENA VISTA RESTAURANT INC

#

FOOD SERVICE EST.

BROOKLYN

NUEVO MEXICO 11, INC.

#

FOOD SERVICE EST.

TACOS NUEVO MEXICO II INC

#

FOOD SERVICE EST.

FAKARDDINE BEYROOTI-(MEXICO LEBANON)

#

FOOD SERVICE EST.

TACOS NUEVO MEXICO 11 INC.

#

FOOD SERVICE ESTAB

LAS MARAVILLAS DE MEXICO RESTAURANT CORP

#

FOOD SERVICE EST.

BRONX

FONDA MEXICO MAGICO L.L.C.

#

FOOD SERVICE EST.

BRONX

H. MARTINEZ/GROCERY VALLE MEXICO AZTE

#

TEMP FOOD SERV ESTAB

MEXICO DOS, INC.

#

FOOD SERVICE EST.

MANHATTAN

SABOR A MEXICO RESTUARANT INC

#

FOOD SERVICE EST.

NUEVO MEXICO, INC

#

FOOD SERVICE EST.

NUEVO MEXICO, INC

#

FOOD SERVICE EST.

TACOS MEXICO CORP

#

FOOD SERVICE EST.

QUEENS

VIVA MEXICO, INC.

#

FOOD SERVICE EST.

TAQUERIA NUEVO MEXICO, INC.

#

FOOD SERVICE EST.

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