From a 500-row sample across 54 columns.
bbllatitudecensus_tract+5Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| requestid | indexnumber | tenantname | tenantfloor | tenantbuildingnumber | tenantstreetname | tenantcity | tenantstatecode | tenantpostcode | tenantborough | ownername | ownerstreetaddress |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2710 | BIB18000088 | Amazon | 10 | 450 | West 33rd Street | New York | NY | 10001 | Manhattan | Brookfield Properties | 450 West 33rd Street |
| 449 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
requestid | integer | — | 0% | 259127472482 |
indexnumber | text | — | 0% | BIB10000257BIB13000156BIB13000011 |
tenantname | text | — | 0% | United NationsBank of AmericaLoeb Enterprises |
tenantfloor | text | — | 0% | 71712 |
tenantbuildingnumber | text |
GET /api/datasets/scjj-6yaf GET /api/datasets/scjj-6yaf/quality GET /api/datasets/scjj-6yaf/related GET /api/columns?dataset=scjj-6yaf
bbllatitudenta+2| BIB10000372 |
| United Nations |
| FF-220 |
| 330 |
| E42 Street |
| New York |
| NY |
| 10017 |
| Manhattan |
| ULM ll Holding Corporation |
| 1776 Broadway |
| 688 | BIB10000611 | Stuart A. Dtisky, CPA PC | 24th Floor | 475 | Park Avenue South | New York | NY | 10016 | Manhattan | Cohen Brothers Realty | 475 Park Avenue South |
| 462 | BIB10000385 | Baker & McKenzie LLP | 4th Floor | 1114 | Avenue of the Americas | New York | NY | 10036 | Manhattan | Brookfield Properties | 1114 Avenue of the Americas |
| 2792 | BIB18000170 | MQS Management LLC | 34th Floor | 41 | Madison Ave. | New York | NY | 10010 | Manhattan | Rudin Management | 41 Madison Ave |
| 2391 | BIB16000143 | Soros Fund Management LLC | C1 | 250 | West 55th Street | New York City | NY | 10019 | Manhattan | Boston Properties | 250 W 55th Street |
| 485 | BIB10000408 | First American Title Insurance of New York | 16 | 633 | Third Avenue | New York | NY | 10017 | Manhattan | Sandhurst Associates, LTD. | 633 Third Avenue |
| 1235 | BIB12000173 | Chase Manhattan Bank | Ground Flr | 4 | MetroTech Center | Brooklyn | NY | 11245 | Brooklyn | Chase Manhattan Bank | 3 Chase MetroTech Center |
| 1868 | BIB14000117 | Shearman & Sterling LLP | 1604 | 599 | Lexington Avenue | New York | NY | 10022 | Manhattan | Boston Properties | 599 Lexington Avenue, C2 Level |
| 743 | BIB11000016 | Earth Day New York | Suite 3200 | 201 | East 42nd st. | New York | NY | 10017 | Manhattan | Royal Realty | 1 Bryant Park |
Showing 12 of 51 columns. All of them are listed below.
| — |
| 0% |
420250360 |
tenantstreetname | text | — | 0% | BroadwayThird AvenueAvenue of the Americas |
tenantcity | text | — | 0% | New YorkNew York CityBrooklyn |
tenantstatecode | text | — | 0% | NYof 1 |
tenantpostcode | integer | — | 0% | 100171002210019 |
tenantborough | categorical | — | 0% | ManhattanBrooklynQueensof 3 |
ownername | text | — | 0% | SL GreenBoston PropertiesTishman Speyer |
ownerfloor | text | — | 36% | Lobby131 |
ownerstreetaddress | text | — | 0% | 420 Lexington Avenue225 Liberty Street611 Broadway |
ownercity | text | — | 0% | New YorkBrooklynNEW YORK |
ownerstatecode | categorical | — | 0% | NYMAILof 7 |
ownerzipcode | integer | — | 0% | 100171002210019 |
floorsuiterequested | text | — | 0% | 1717th Floor7th Floor |
noofbicyclerequested | integer | — | 0% | 125 |
bbl | integer | — | 0% | 101280006010052300481012960014 |
bin | integer | — | 0% | 103538510082401036152 |
dateofrequest | datetime | — | 46% | 2009-12-11T00:00:00.0002009-12-14T00:00:00.0002010-03-10T00:00:00.000 |
requestdateofentry | datetime | — | 32% | 2009-12-11T00:00:00.0002009-12-14T00:00:00.0002010-05-13T00:00:00.000 |
implementdate | datetime | — | 46% | 1999-01-31T00:00:00.0001999-10-09T00:00:00.0001900-01-31T00:00:00.000 |
planpostdate | datetime | — | 46% | 1999-02-05T00:00:00.0001999-10-14T00:00:00.0001900-02-05T00:00:00.000 |
plansubmitdate | datetime | — | 46% | 1999-02-10T00:00:00.0001999-10-19T00:00:00.0001900-02-10T00:00:00.000 |
exceptionrequestduedate | datetime | — | 46% | 1999-01-16T00:00:00.0001999-09-24T00:00:00.0001900-01-16T00:00:00.000 |
tenantnotificationexcept | datetime | — | 46% | 1999-01-31T00:00:00.0001999-10-09T00:00:00.0001900-01-31T00:00:00.000 |
locationofentrances | text | — | 54% | Loading DockEntrance to the Van/Load…54th Street and 6th Aven… |
routetoelevators | text | — | 54% | The freight elevator is …Elevators are at the lef…Cyclists will enter at t… |
regularhoursofoperation | text | — | 55% | 7:00AM - 5:30PM8:00 a.m. to 5:00 p.m., …Monday - Friday 7am - 6p… |
planddatereceived | datetime | — | 61% | 2013-06-18T00:00:00.0002013-03-05T00:00:00.0002010-06-21T00:00:00.000 |
alternateparkinglocation | text | — | 95% | Alternate bicycle parkin…Secure storage space off…Alternate bicycle parkin… |
alternateparkingdescription | text | — | 95% | Sufficient bicycle parki…Sufficient bicycle parki…A secure room off the lo… |
noofbicycleaccomodate | text | — | 95% | FifteenThe attached bicycle par…50 |
routetoalternateparking | text | — | 95% | From the main lobby entr…Access to the loading do…From the main lobby entr… |
parkingexceptiondatereceived | coordinate | — | 99% | 19990101000000.00000000020101104000000.00000000020150210000000.000000000of 18 |
parkingexceptiondateofentry | datetime | — | 95% | 2011-06-03T00:00:00.0002009-12-28T00:00:00.0002010-07-19T00:00:00.000 |
dobdevicenumber | text | — | 98% | 1p19081N/A1F3288 |
dateofbuilding | datetime | — | 98% | 1929-01-01T00:00:00.0001927-01-01T00:00:00.0001920-06-15T00:00:00.000 |
dateofelevator | datetime | — | 98% | 1929-01-01T00:00:00.0002009-01-01T00:00:00.0001905-01-01T00:00:00.000 |
methodofelevator | text | — | 98% | AutomaticautomaticManual |
selfserviceoroperator | categorical | — | 98% | Operatoroperatorself serviceof 14 |
iscartop | categorical | — | 98% | YesNoof 2 |
iscardoor | categorical | — | 98% | YesNoof 2 |
elevatorexceptiondatereceived | datetime | — | 99% | 1999-01-01T00:00:00.0001999-09-09T00:00:00.0002010-05-17T00:00:00.000of 16 |
elevatorexceptionhardcop | text | — | 98% | Noof 1 |
elevatorexceptiondateofentry | datetime | — | 99% | 2011-01-11T00:00:00.0002011-01-06T00:00:00.0002011-01-07T00:00:00.000of 19 |
requeststatus | categorical | — | 0% | PendingHoldof 2 |
latitude | float | — | 0% | 40.75226240.725640.751601 |
longitude | float | — | 0% | -73.975464-73.996641-73.97645 |
community_board | categorical | — | 0% | 105106101of 13 |
council_district | categorical | — | 0% | 413of 12 |
census_tract | integer | — | 0% | 9210280 |
nta | text | — | 0% | MN0502MN0604MN0101 |