From a 500-row sample across 58 columns.
statenon_profitspecial_district_1+20permit_statuszip_codework_type+7statefiling_dateowner_s_business_name+8Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | bin__ | house__ | street_name | job__ | job_doc___ | job_type | self_cert | block | lot | community_board | zip_code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| BROOKLYN | 3185434 | 60 | BAY 34 ST | 340733647 | 01 | A2 | Y | 06861 | 00067 | 311 | 11214 |
| QUEENS | 4623172 | 117 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | 1= Manhattan, 2= Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island | 0% | MANHATTANBROOKLYNQUEENSof 5 |
bin__ | text | Number assigned by City Planning to a specific building | 0% | 101586210143871076262 |
house__ | text | House Number of Residence or Commercial Property | 0% | 1200100 |
street_name | text | Street Name where Property is located | 0% | BROADWAYPARK AVENUEMADISON AVENUE |
GET /api/datasets/ipu4-2q9a GET /api/datasets/ipu4-2q9a/quality GET /api/datasets/ipu4-2q9a/related GET /api/columns?dataset=ipu4-2q9a
filing_datebblboroughstatenon_profitzip_code+13lotblockstatenon_profitzip_code+12bbllotblock| BEACH 215 STREET |
| 421538731 |
| 01 |
| NB |
| N |
| 16350 |
| 00400 |
| 414 |
| 11697 |
| STATEN ISLAND | 5174573 | 620 | RICHMOND TERRACE | 510113501 | 01 | NB | N | 00062 | 00056 | 501 | 10301 |
| BRONX | 2010402 | 1323 | CHISHOLM ST | 220723885 | 01 | DM | N | 02971 | 00036 | 203 | 10459 |
| MANHATTAN | 1014387 | 1 | PENN PLAZA | 123734717 | 02 | A2 | Y | 00783 | 00070 | 105 | 10119 |
| STATEN ISLAND | 5130986 | 1000 | WEST SERVICE ROAD | 510113315 | 01 | NB | N | 05900 | 00500 | 503 | 10309 |
| STATEN ISLAND | 5130986 | 1000 | WEST SERVICE ROAD | 510113315 | 01 | NB | N | 05900 | 00500 | 503 | 10309 |
| BRONX | 2078937 | 39 | PENNYFIELD CAMP | 240240565 | 01 | A2 | Y | 05519 | 00169 | 210 | 10465 |
| BROOKLYN | 3007326 | 420 | UNION STREET | 302576923 | 01 | A2 | Y | 00437 | 00001 | 306 | 11231 |
| QUEENS | 4100768 | 31-25 | DOWNING STREET | 421661320 | 03 | A2 | N | 04406 | 00028 | 407 | 11354 |
Showing 12 of 54 columns. All of them are listed below.
job__ | text | Number assigned by DOB to Job Filing | 0% | 401910438402885776122745100 |
job_doc___ | categorical | Document Number | 0% | 010203of 12 |
job_type | categorical | Job Type, based on DOB Job Code (NB-New Building, A1, A2, A3- Alterations 1-3, SG-Sign, etc.) | 0% | A2NBA1of 6 |
self_cert | categorical | Self_Cert | 34% | YNRof 5 |
block | text | Tax block assigned by Department of Finance | 0% | 000161635000972 |
lot | text | Tax lot assigned by Department of Finance | 0% | 000010750100029 |
community_board | text | 3-digit identifier: Borough code = first position, last 2 = community board | 0% | 105108102 |
zip_code | text | Tax lot Zip Code | 0% | 100221001910013 |
bldg_type | categorical | 1-2-3 Family or Other | 1% | 21of 2 |
residential | text | Residential | 59% | YESof 1 |
special_district_1 | text | Special District 1 | 89% | MIDSRDLM |
special_district_2 | categorical | Special District 2 | 97% | IBZPOPSMS4of 17 |
work_type | categorical | DOB Designated Work Types (PL-Plumbing, BL-Boiler, MH-Mechanical, OT-Other Constuction Equipment, etc.) | 18% | OTPLEQof 13 |
permit_status | categorical | Permit Status | 0% | ISSUEDRE-ISSUEDIN PROCESSof 4 |
filing_status | categorical | Filing Status | 0% | INITIALRENEWALof 2 |
permit_type | categorical | Permit Type (DM-Demolition, EW-Equipment Work, PL-Plumbing, etc.) Complete List - http://www.nyc.gov/html/dob/downloads/pdf/bisjobstatus.pdf | 0% | EWPLEQof 8 |
permit_sequence__ | text | Permit Sequence # | 0% | 010203 |
permit_subtype | categorical | Permit Subtype (Subset of Equipment Work Permit Type-- BL-Boiler, FA- Fire Alarm, Subset of Construction Equipment Permit Type-- CH-Chute, SF-Scaffold, etc.) Complete List - http://www.nyc.gov/html/dob/downloads/pdf/bisjobstatus.pdf | 40% | OTMHFNof 15 |
oil_gas | categorical | Oil Gas | 99% | OILGASof 2 |
site_fill | categorical | Site Fill | 12% | NONENOT APPLICABLEON-SITEof 5 |
filing_date | date | Filing Date | 0% | 03/29/201711/08/201711/09/2017 |
issuance_date | date | Issuance Date | 1% | 03/29/201711/08/201711/09/2017 |
expiration_date | date | Expiration Date | 0% | 12/31/200712/31/200612/31/2005 |
job_start_date | date | Job Start Date | 0% | 06/12/201506/27/200806/11/2015 |
permittee_s_first_name | text | Permittee's First Name | 0% | JOHNMICHAELROBERT |
permittee_s_last_name | text | Permittee's Last Name | 0% | SINGHLEELEVINE |
permittee_s_business_name | text | Permittee's Business Name | 0% | N/AEVEREST SCAFFOLDING INCSTRUCTURE TONE INC |
permittee_s_phone__ | text | Permittee's Phone # | 0% | 212481610071839249212129261088 |
permittee_s_license_type | categorical | Permittee's License Type | 7% | GCMPFSof 13 |
permittee_s_license__ | text | Permittee's License # | 6% | 000026600001982 |
act_as_superintendent | categorical | Permittee Acts as Superintendent | 58% | YNof 2 |
permittee_s_other_title | text | Permittee's Other Title | 93% | GCG.C.G.C |
hic_license | text | HIC License | 99% | 012560001118019 |
site_safety_mgr_s_first_name | text | Site Safety Mgr's First Name | 99% | MICHAELJOHNADMINISTRATIVE |
site_safety_mgr_s_last_name | text | Site Safety Mgr's Last Name | 99% | WAIVERN/ABROWN |
site_safety_mgr_business_name | text | Site Safety Mgr Business Name | 99% | TOTAL SAFETY CONSULTINGNYC DEPT. OF BUILDINGSSITE SAFETY LLC |
superintendent_first___last_name | text | Superintendent First & Last Name | 54% | JOHN WHITETHEODORE WAGNERPETER MARTINEZ |
superintendent_business_name | text | Superintendent Business Name | 55% | N/AROCKLEDGE SCAFFOLDSTRUCTURE TONE INC |
owner_s_business_type | categorical | Owner's Business Type | 4% | CORPORATIONINDIVIDUALPARTNERSHIPof 14 |
non_profit | categorical | Non-Profit | 4% | NY—of 4 |
owner_s_business_name | text | Business Name of Property Owner | 2% | N/ANANY SCHOOL CONSTRUCTION A… |
owner_s_first_name | text | First Name of property owner | 0% | MICHAELJOHNROBERT |
owner_s_last_name | text | Last Name of property owner | 0% | SINGHCOHENABNERI |
owner_s_house__ | text | Owner's House # | 98% | 100130-30 |
owner_s_house_street_name | text | Owner's House Street Name | 98% | BROADWAYTHOMSON AVENUEPARK AVENUE |
city | text | Owner’s House City | 98% | NEW YORKNYBROOKLYN |
state | text | Owner’s House State | 98% | NYNJCT |
owner_s_zip_code | text | Owner’s House Zip Code | 98% | 100381002210017 |
permit_si_no | text | — | 0% | 34385181767236352745 |
gis_latitude | coordinate | — | 0% | 40.74787840.75161440.762495 |
gis_longitude | coordinate | — | 0% | -73.984979-73.992121-73.978692 |
gis_council_district | text | — | 0% | 040301 |
gis_census_tract | text | — | 0% | 102337 |
bbl | integer | — | 3% | 416350040010097200011008350041 |
gis_nta_name | text | — | 0% | Midtown-Times SquareUpper East Side-Carnegie…Midtown South-Flatiron-U… |
dobrundate | datetime | Date when query is run and pushed to Open Data. Could be used to differentiate report dates. | 0% | 2026-10-12T00:00:00.0002017-11-03T00:00:00.0002020-07-29T00:00:00.000 |