From a 500-row sample across 21 columns.
boroughbinlot+1boroughboroughbinHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| requestid | applicationid | requesttype | house | street | borough | bin | block | lot | ownername | expirationdate | make |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 396557 | CA126496 | CERTIFICATE TO OPERATE | 4915 | BROADWAY | MANHATTAN | 1064985 | 02241 | 0025 | 4915 BROADWAY REALTY LLC. | 2026-08-01T00:00:00.000 | FEDERAL |
| 54696 | CA059089 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
requestid | integer | ID Representing Request | 0% | 388033415390429464 |
applicationid | text | Application ID for the Premise Address | 0% | CA066681CB270100CA383272 |
requesttype | categorical | Type of Request Submitted | 0% | REGISTRATIONCERTIFICATE TO OPERATEREGISTRATION INSPECTIONof 5 |
house | text | House Number of Premises | 0% | VARIOUS1200 |
GET /api/datasets/f4rp-2kvy GET /api/datasets/f4rp-2kvy/quality GET /api/datasets/f4rp-2kvy/related GET /api/columns?dataset=f4rp-2kvy
boroughbinborough| REGISTRATION |
| 142 |
| FULTON STREET |
| MANHATTAN |
| 1001224 |
| 00079 |
| 0026 |
| CENTURY REALTY INC. |
| 1995-03-10T00:00:00.000 |
| HYDROTHERM MR600 |
| 378827 | CA022047 | CERTIFICATE TO OPERATE | 70 | — | MANHATTAN | 3000000 | 00080 | 00837 | 64-36 REALTY ASSOC. | 1986-10-21T00:00:00.000 | KEWANEE-538 |
| 478391 | CR002517 | REGISTRATION | 31 | EAST 1ST STREET | MANHATTAN | 1006069 | 00442 | 0011 | BAJA 31 LLC | 2029-02-04T00:00:00.000 | H.B. SMITH |
| 392804 | CA278585 | REGISTRATION INSPECTION | 1774 | EASTBURN AVENUE | BRONX | 2007422 | 02796 | 0019 | ANN-GUR REALTY CORP. | 2025-09-24T00:00:00.000 | ROCKMILLS |
| 118102 | CA026270 | CERTIFICATE TO OPERATE | 2419 | DAVIDSON AVENUE | BRONX | 2014310 | 03199 | 0031 | EVROPA REALTY LLC | 2006-11-27T00:00:00.000 | FEDERAL FST 70 SP |
| 456474 | CA062298 | REGISTRATION | 19-47 | 80 STREET | QUEENS | 4444701 | 00949 | 7501 | GARDEN BAY MANOR CONDO. | 2028-04-09T00:00:00.000 | WEIL MCLAIN |
| 457425 | CA159692 | REGISTRATION | 310 | WEST 116 STREET | MANHATTAN | 1055856 | 01848 | 0059 | 310-314 W. 116 STREET CORPORATION | 2028-05-21T00:00:00.000 | PEERLESS |
| 111252 | CA025887 | CERTIFICATE TO OPERATE | 504 | EAST 81 STREET | MANHATTAN | 1050877 | 01577 | 0045 | MEMORIAL HOSPITAL FOR CANCER | 2005-05-05T00:00:00.000 | FEDERAL FST-100 |
| 29111 | CR608614 | REGISTRATION | 55-20 | METROPOLITAN AVENUE | QUEENS | 4080234 | 03365 | 0027 | JOHN SHEA C/O D.O.E. | 2017-07-16T00:00:00.000 | LOCHINVAR |
Showing 12 of 21 columns. All of them are listed below.
street |
| text |
| Street Name of Premises |
| 0% |
BROADWAYLOCATIONSPARK AVENUE |
borough | categorical | Borough Name of Premises | 0% | MANHATTANBROOKLYNQUEENSof 7 |
bin | integer | Bin of Premises | 2% | 300000033351381000000 |
block | text | block number of Premises | 2% | 021800213902179 |
lot | text | lot number of Premises | 2% | 000175010006 |
ownername | text | Name of owner who own the building | 3% | NYC DEPT OF EDUCATION (D…VARIOUS LOCATIONSNYC HOUSING AUTHORITY (N… |
expirationdate | datetime | Permit Expiration Date | 1% | 2027-07-01T00:00:00.0002027-06-30T00:00:00.0001997-07-01T00:00:00.000 |
make | text | Boiler Make | 4% | FEDERALWEIL MCLAINH.B. SMITH |
model | text | Boiler Model | 4% | /FST-125FST-100 |
burnermake | text | Burner Make | 14% | INDUSTRIAL COMBUSTIONCARLINPOWERFLAME |
burnermodel | text | Burner Model | 14% | INTEGRALMMG-42P301-CRD |
primaryfuel | categorical | Primary Fuel: NaturalGas No2Fuel No2FuelB2 No4Fuel No6Fuel | 5% | NATURALGASNO2FUELNO6FUELof 10 |
secondaryfuel | categorical | Secondary Fuel: NaturalGas No2Fuel No2FuelB2 No4Fuel No6Fuel | 13% | NONENO2FUELNATURALGASof 9 |
quantity | integer | Number of Boilers | 2% | 123 |
issuedate | datetime | Permit Issue Date | 0% | 1900-01-01T00:00:00.0001899-12-30T00:00:00.0001986-10-25T00:00:00.000 |
status | categorical | Status of the Application | 0% | CURRENTEXPIREDCANCELLEDof 3 |
premisename | text | Name of Premises | 53% | VARIOUS LOCATIONSMOBILE BOILERNYC HPD |