ROOSEVELT

1 - 50 of 2120

ROOSEVELT HOTEL CORP

#

EQUIPMENT WORK

MANHATTAN

ST LUKE'S ROOSEVELT AVENUE

#0999991

EQUIPMENT WORK

MANHATTAN

ST. LUKE'S/ROOSEVELT HOSPITAL

#0999991

ALTERATION

MANHATTAN

ST. LUKES ROOSEVELT HOSPITAL

#0999991

EQUIPMENT WORK

MANHATTAN

ST.LUKE'S/ROOSEVELT HOSPITAL

#0008810

EQUIPMENT WORK

MANHATTAN

ST.LUKE'S/ROOSEVELT HOSPITAL

#0008810

EQUIPMENT WORK

MANHATTAN

ST.LUKE'S/ROOSEVELT HOSPITAL

#0008810

EQUIPMENT WORK

MANHATTAN

ST.LUKE'S/ROOSEVELT HOSPITAL CTR

#

ALTERATION

MANHATTAN

ST.LUKE'S /ROOSEVELT HOSPITAL

#0008810

EQUIPMENT WORK

MANHATTAN

ROOSEVELT SAVINGS BANK

#0048918

EQUIPMENT WORK

BROOKLYN

ROOSEVELT ST. MEDCL/DENTL CTR.

#0005170

EQUIPMENT WORK

STATEN ISLAND

ST. LUKE'S ROOSEVELT HOSP. CTR

#

ALTERATION

BRONX

86-01 ROOSEVELT AVENUE LLC

#0999994

EQUIPMENT WORK

JACKSON HEIGHTS

QUEENS

50 ROOSEVELT WOODSIDE CORP.

#0999994

ALTERATION

QUEENS

7918 ROOSEVELT LLC

#0999994

EQUIPMENT WORK

JACKSON HEIGHTS

QUEENS

60-19 ROOSEVELT AVE CORP

#

ALTERATION

QUEENS

52-20 ROOSEVELT AVENUE

#

EQUIPMENT WORK

QUEENS

ROOSEVELT ROOFING & SHEETMETAL

#

EQUIPMENT WORK

QUEENS

ROOSEVELT WARNER

#0017968

ALTERATION

QUEENS

ROOSEVELT WARNER

#0017968

ALTERATION

QUEENS

ST.LUKE'S/ROOSEVELT HOSPITAL

#0999991

ALTERATION

MANHATTAN

ST.LUKE'S/ROOSEVELT HOSPITAL CEN

#

EQUIPMENT WORK

MANHATTAN

ST.LUKE'S/ROOSEVELT HOSPITAL CEN

#

EQUIPMENT WORK

MANHATTAN

104-78 ROOSEVELT AVE. ACTION JAC

#0000718

PLUMBING

BRONX

CALLOWAY ROOSEVELT

#

DENTIST

QUEENS

ROOSEVELT AVE. 64-10 CORP

#

FOOD SERVICE EST.

QUEENS

ELENOR ROOSEVELT COMM. CENTER NYCHA

#

CONDUCT A DAY CAMP

ROOSEVELT HOTEL CORPORATION N.V.

#

FOOD SERVICE EST.

MANHATTAN

ROOSEVELT HOTEL CORP. N.V.

#

FOOD SERVICE EST.

MANHATTAN

ROOSEVELT ROBINSON

#

FOOD VENDOR LICENSE

BROOKLYN

ST. LUKE'S ROOSEVELT CLINICAL LABS

#

N/A

MANHATTAN

ROOSEVELT ISLAND RACQUET ASSOCIATES

#

FOOD SERVICE EST.

ST LUKES ROOSEVELT STAFF HOUSING COINC

#

N/A

MANHATTAN

ST LUKES ROOSEVELT STAFF HOUSING COINC

#

INCORRECT LICENSE

QUEENS

ST. LUKE'S ROOSEVELT HOSPITAL

#

INCORRECT LICENSE

MANHATTAN

ST. LUKES ROOSEVELT HOSPITAL CENTER

#

PHYSICIAN

ROOSEVELT LANE LIMITED

#

INCORRECT LICENSE

MANHATTAN

ROOSEVELT AVENUE FOODS INC

#

FOOD SERVICE EST.

JACKSON HEIGHTS

QUEENS

ROOSEVELT ISL. ASSOC. BY MANHATTAN PK

#

BATHING POOL ESTAB.

BURGIO,HARRY-DPM(HOTEL ROOSEVELT)

#

N/A

ST.LUKES / ROOSEVELT HOSPITAL CENTER

#

INCORRECT LICENSE

MANHATTAN

ST. LUKE'S ROOVT HOSP ROOSEVELT SITE

#

N/A

MANHATTAN

ROOSEVELT HOSPITAL BLOOD BANK

#

N/A

MANHATTAN

ST. LUKE'S -ROOSEVELT HOSPITAL CENTER

#

N/A

MANHATTAN

ST. LUKE'S ROOSEVELT HOSP CTR

#

N/A

MANHATTAN

ROOSEVELT HOSPITAL

#

PUBLIC SCH CAFETERIA

MANHATTAN

ST. LUKE'S-ROOSEVELT HOSP. COAG LAB

#

N/A

MANHATTAN

ROOSEVELT HOSP. RAD. LABORATORY

#

N/A

MANHATTAN

C/O DR. ABRAMS-ROOSEVELT HOSPITAL

#

N/A

MANHATTAN

ROOSEVELT HOSP COAG LAB

#

N/A

MANHATTAN

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