From a 500-row sample across 55 columns.
doc__job_statusapplicant_professional_title+43owner_s_first_namejob_typecity+13proposed_occupancydoc__job_status+38Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| job__ | doc__ | borough | house__ | street_name | block | lot | bin__ | job_type | job_status | job_status_descrp | latest_action_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 120538597 | 01 | 1 | 20 | WEST 20 STREET | 00821 | 00055 | 1015480 | A3 | R | PERMIT ISSUED - ENTIRE JOB/WORK | 02/10/2014 00:00:00 |
| 120568395 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
job__ | text | Number assigned by DOB to Job Filing | 0% | 321267892122438745421198484 |
doc__ | text | Document Number | 0% | 01 EGRESS USE |
borough | text | 1= Manhattan, 2= Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island | 0% | 134 |
house__ | text | House Number of Residence or Commercial Property | 1% | 2 300 600 |
street_name |
GET /api/datasets/iz2q-9x8d GET /api/datasets/iz2q-9x8d/quality GET /api/datasets/iz2q-9x8d/related GET /api/columns?dataset=iz2q-9x8d
zip_codejob_descriptionlotborough+3lotboroughblock+1applicant_professional_titlejob_typebuilding_type+12building_typeowner_typelot+3| 01 |
| 1 |
| 66 |
| WEST 9 STREET |
| 00572 |
| 00008 |
| 1009410 |
| A3 |
| R |
| PERMIT ISSUED - ENTIRE JOB/WORK |
| 05/08/2013 00:00:00 |
| 120747745 | 01 | 1 | 395 | HUDSON STREET | 00600 | 07501 | 1010382 | A3 | R | PERMIT ISSUED - ENTIRE JOB/WORK | 05/08/2013 00:00:00 |
| 120796585 | 01 | 1 | 305 | WEST END AVENUE | 01184 | 00077 | 1031008 | A3 | R | PERMIT ISSUED - ENTIRE JOB/WORK | 05/22/2013 00:00:00 |
| 120804200 | 01 | 1 | 797 | 3 AVENUE | 01323 | 00001 | 1038223 | A3 | R | PERMIT ISSUED - ENTIRE JOB/WORK | 05/08/2013 00:00:00 |
| 120911521 | 01 | 1 | 160 | BLEEKER STREET | 00525 | 07501 | 1083503 | A3 | R | PERMIT ISSUED - ENTIRE JOB/WORK | 05/13/2013 00:00:00 |
| 120952512 | 01 | 1 | 170 | CENTRAL PARK WEST | 01129 | 00029 | 1028816 | A3 | R | PERMIT ISSUED - ENTIRE JOB/WORK | 04/07/2014 00:00:00 |
| 121026718 | 01 | 1 | 816 | 6 AVENUE | 00830 | 00001 | 1015709 | A3 | R | PERMIT ISSUED - ENTIRE JOB/WORK | 05/08/2013 00:00:00 |
| 121026727 | 01 | 1 | 600 | WEST 139 STREET | 02087 | 00036 | 1062302 | A3 | R | PERMIT ISSUED - ENTIRE JOB/WORK | 06/12/2013 00:00:00 |
| 121048231 | 01 | 1 | 370 | MANHATTAN AVENUE | 01848 | 00036 | 1055850 | A3 | R | PERMIT ISSUED - ENTIRE JOB/WORK | 05/01/2013 00:00:00 |
Showing 12 of 50 columns. All of them are listed below.
| text |
| Street Name where Property is located |
| 1% |
BROADWAY …LEXINGTON AVENUE …MADISON AVENUE … |
block | text | Tax block assigned by Department of Finance | 2% | 021390014200809 |
lot | text | Tax lot assigned by Department of Finance | 2% | 000010750100006 |
bin__ | text | Number assigned by City Planning to a specific building | 2% | 103451510271931001357 |
job_type | categorical | Job Type, based on DOB Job Code (NB-New Building, A1, A2, A3- Alterations 1-3, SG-Sign, etc.) | 2% | A3 320505761of 2 |
job_status | categorical | DOB Status code of job (A-Pre Filed, I-Sign Off, P- Approved, R-Permit Entire) Complete List - http://www.nyc.gov/html/dob/downloads/pdf/bisjobstatus.pdf | 2% | R 320923809of 2 |
job_status_descrp | categorical | Status code description | 2% | PERMIT ISSUED - ENTIRE J… 321527497. ALL IN CONF…of 2 |
latest_action_date | date | Latest status date | 2% | 06/08/2015 00:00:0007/06/2015 00:00:0006/05/2015 00:00:00 |
building_type | categorical | 1-2-3 Family or Other | 2% | OTHER1-2-3 FAMILY OR EGRESS.|05/12/2018 0…of 3 |
community___board | text | 3-digit identifier: Borough code = first position, last 2 = community board | 2% | 105104106 |
landmarked | text | L code indicates that the building has been assigned landmark status | 95% | Yof 1 |
little_e | text | Hazardous | 100% | Hof 1 |
pc_filed | text | Application Filed electronically, rather than manually | 2% | of 1 |
other | text | Other (X=Yes, Blank=No) | 2% | Xof 1 |
other_description | categorical | Other Description | 2% | ANTENNA ANTENNA REMOVALANT of 3 |
applicant_s_first_name | text | First Name of Applicant | 2% | STEPHEN JOHN ANTONIO |
applicant_s_last_name | text | Last Name of Applicant | 2% | BRAY …ADELY …GUALTIERI … |
applicant_professional_title | categorical | Applicant's Professional Title | 2% | PERAof 2 |
applicant_license__ | text | Number assigned to the skilled trade person/contractor or licensed professional | 2% | 086064063658071249 |
professional_cert | text | Job is Professionally Certified by Licensed Professional instead of having it reviewed by Department of Building's Plan Examiners | 99% | Yof 1 |
pre_filing_date | datetime | Date when job is prefiled | 2% | 2015-05-22T00:00:00.0002015-04-21T00:00:00.0002015-05-07T00:00:00.000 |
paid | datetime | Date when job is paid | 2% | 2015-05-22T00:00:00.0002015-04-21T00:00:00.0002015-05-07T00:00:00.000 |
fully_paid | datetime | Date when job is paid and entered | 2% | 2015-05-07T00:00:00.0002015-05-22T00:00:00.0002015-04-21T00:00:00.000 |
assigned | datetime | Date when job is assigned to plan examiner | 3% | 2015-05-26T00:00:00.0002015-05-18T00:00:00.0002015-05-11T00:00:00.000 |
approved | datetime | Date when job is approved | 2% | 2015-06-01T00:00:00.0002015-08-07T00:00:00.0002015-05-21T00:00:00.000 |
fully_permitted | datetime | Date when job is fully permitted | 2% | 2015-06-08T00:00:00.0002015-07-06T00:00:00.0002015-06-05T00:00:00.000 |
initial_cost | integer | Estimated cost of job | 2% | 100002000015000 |
total_est_fee | float | Estimated fee of job | 2% | 286.5389.5338 |
fee_status | categorical | Type of Fee | 2% | STANDARDEXEMPTof 2 |
existing_occupancy | text | Existing Occupancy | 2% | RES COM J-2 |
proposed_occupancy | text | Proposed Occupancy | 2% | RES COM J-2 |
zoning_distr_1 | text | Zoning Distr 1 | 2% | R6 R5 R7-2 |
zoning_distr_2 | text | Zoning Distr 2 | 87% | R8B R5 R6 |
zoning_distr_3 | categorical | Zoning Distr 3 | 100% | R8B C1-7 R9 of 12 |
special_distr_1 | text | Special Distr 1 | 81% | MID LM CL |
special_distr_2_ | categorical | Special Distr 2 | 95% | IBZ JAM POPS of 7 |
owner_type | categorical | Owner Type | 2% | 030201of 12 |
owner_type_description | categorical | Owner Type Description | 2% | PARTNERSHIP …CORPORATION …INDIVIDUAL …of 13 |
non_profit | categorical | Non-Profit | 2% | NYof 2 |
owner_s_first_name | text | First Name of property owner | 2% | ROBERT MARK GREGG |
owner_s_last_name | text | Last Name of property owner | 2% | CIAGLIA …BISHOP …BAILEY … |
owner_s_business_name | text | Business Name of Property Owner | 2% | T-MOBILE …T-MOBILE NORTHEAST LLC …AT&T MOBILITY … |
owner_s__house__ | text | House # of Property Owner | 2% | 4 ONE 1 |
owner_s__house_street | text | House Street of Property Owner | 2% | SYLVAN WAY …AT&T WAY …AT&T WAY, 3A212F … |
city | text | City | 2% | NEW YORK PARSIPPANY BROOKLYN |
state | text | State | 2% | NYNJFL |
zip_code | text | Zip Code | 2% | 07054 07921 10016 |
owner_s__phone__ | text | Owner's Phone # | 2% | 973397481491443893269738971375 |
first_permit_date | datetime | Date of first issuance of permit | 2% | 2015-06-08T00:00:00.0002015-07-06T00:00:00.0002015-06-05T00:00:00.000 |
job_description | text | Job Description | 2% | INSTALL NEW TELECOMMUNIC…MODIFICATION TO EXISTING…INSTALLATION OF TELECOMM… |
dobrundate | date | Date when query is run and pushed to Open Data. Could be used to differentiate report dates. | 2% | 12/28/2015 00:00:0006/09/2015 00:00:0007/07/2015 00:00:00 |