From a 500-row sample across 69 columns.
little_estreet_namehouse__+36street_namehouse__borough+12zip_codeHas 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 122881346 | 01 | MANHATTAN | 1313 | BROADWAY | 00810 | 00040 | 1015220 | SG | X | SIGNED OFF | 05/17/2017 00:00:00 |
| 122003269 |
The machine field names SoQL needs, with the publisher's own description of each. Profiling runs nightly; null rates and sample values appear once it has.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
job__ | text | Number assigned by DOB to Job Filing | — | — |
doc__ | text | Document Number | — | — |
borough | text | 1= Manhattan, 2= Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island | — | — |
house__ | text | House Number of Residence or Commercial Property | — | — |
street_name | text | Street Name where Property is located | — | — |
block | text | Tax block assigned by Department of Finance | — |
GET /api/datasets/nyis-y4yr GET /api/datasets/nyis-y4yr/quality GET /api/datasets/nyis-y4yr/related GET /api/columns?dataset=nyis-y4yr
street_nameboroughlotlittle_estreet_nameborough+10street_nameboroughlot+3street_nameboroughlot+1street_namedobrundate| 01 |
| MANHATTAN |
| 183 |
| BROADWAY |
| 00063 |
| 00016 |
| 1001074 |
| SG |
| R |
| PERMIT ISSUED - ENTIRE JOB/WORK |
| 05/19/2014 00:00:00 |
| 421071887 | 01 | QUEENS | 53-07 | VAN DAM STREET | 00299 | 00022 | 4003587 | SG | R | PERMIT ISSUED - ENTIRE JOB/WORK | 10/27/2015 00:00:00 |
| 421089716 | 01 | QUEENS | 91-18 | 59 AVE | 01861 | 00010 | 4046001 | SG | H | PLAN EXAM - IN PROCESS | 03/05/2015 00:00:00 |
| 321038275 | 01 | BROOKLYN | 818 | 53 STREET | 05665 | 00014 | 3416939 | SG | X | SIGNED OFF | 02/24/2015 00:00:00 |
| 123341507 | 01 | MANHATTAN | 85 | 10TH AVENUE | 00687 | 00029 | 1012277 | SG | D | APPLICATION PROCESSED - ENTIRE | 10/13/2017 00:00:00 |
| 220619338 | 01 | BRONX | 220 | EAST 161 STREET | 02443 | 00090 | 2002456 | SG | D | APPLICATION PROCESSED - ENTIRE | 10/13/2017 00:00:00 |
| 421565363 | 01 | QUEENS | 162-01 | JAMAICA AVENUE | 09761 | 00001 | 4208877 | SG | J | PLAN EXAM - DISAPPROVED | 10/13/2017 00:00:00 |
| 520316710 | 01 | STATEN ISLAND | 245 | RICHMOND VALLEY ROAD | 07580 | 00021 | 5162677 | SG | D | APPLICATION PROCESSED - ENTIRE | 10/13/2017 00:00:00 |
| 421565210 | 01 | QUEENS | 30-35 | COLLEGE POINT BLVD | 04357 | 00100 | 4539230 | SG | R | PERMIT ISSUED - ENTIRE JOB/WORK | 10/13/2017 00:00:00 |
Showing 12 of 65 columns. All of them are listed below.
| — |
lot | text | Tax lot assigned by Department of Finance | — | — |
bin__ | text | Number assigned by City Planning to a specific building | — | — |
job_type | text | Job Type, based on DOB Job Code (NB-New Building, A1, A2, A3- Alterations 1-3, SG-Sign, etc.) | — | — |
job_status | text | 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 | — | — |
job_status_descrp | text | Status code description | — | — |
latest_action_date | text | Latest status date | — | — |
building_type | text | 1-2-3 Family or Other | — | — |
community___board | text | 3-digit identifier: Borough code = first position, last 2 = community board | — | — |
landmarked | text | L code indicates that the building has been assigned landmark status | — | — |
adult_estab | text | Adult Estab | — | — |
property_city_owned | text | Property City Owned | — | — |
little_e | text | Hazardous | — | — |
efiling_filed | text | Application Filed electronically, rather than manually | — | — |
equipment | text | Equipment Work Type | — | — |
other | text | Other (X=Yes, Blank=No) | — | — |
other_description | text | Other Description | — | — |
applicant_s_first_name | text | First Name of Applicant | — | — |
applicant_s_last_name | text | Last Name of Applicant | — | — |
applicant_professional_title | text | Applicant's Professional Title | — | — |
applicant_license__ | text | Number assigned to the skilled trade person/contractor or licensed professional | — | — |
professional_cert | text | Job is Professionally Certified by Licensed Professional instead of having it reviewed by Department of Building's Plan Examiners | — | — |
pre_filing_date | datetime | Date when job is prefiled | — | — |
paid | datetime | Date when job is paid | — | — |
fully_paid | datetime | Date when job is paid and entered | — | — |
plan_assigned_date | datetime | Date when job is assigned to plan examiner | — | — |
approved | datetime | Date when job is approved | — | — |
fully_permitted | datetime | Date when job is fully permitted | — | — |
initial_cost | numeric | Estimated cost of job | — | — |
total_est_fee | numeric | Estimated fee of job | — | — |
fee_status | text | Type of Fee | — | — |
sign_illumination | text | Sign Illumination | — | — |
sign_illumination_type | text | Sign Illumination Type (D-Direct, F-Flashing, I-Indirect) | — | — |
sign_type | text | Sign Type | — | — |
sign_height_roof | numeric | Sign Height Roof | — | — |
sign_height_curb | numeric | Sign Height Curb | — | — |
sign_weight | numeric | Sign Weight | — | — |
sign_projection | numeric | Sign Projection | — | — |
sign_sq_footage | numeric | Sign SQ Footage | — | — |
sign_const_type | text | Sign Const Type | — | — |
inside_building_line | text | Inside Building Line | — | — |
sign_non_conforming | text | Sign Non-Conforming | — | — |
sign_advertising | text | Sign Advertising | — | — |
sign_changeable_copy | text | Sign Changeable Copy | — | — |
sign_near_park | text | Sign Near Park | — | — |
sign_near_highway | text | Sign Near Highway | — | — |
sign_dist_from_highway | numeric | Sign Dist from Highway | — | — |
sign_dist_from_park | numeric | Sign Dist from Park | — | — |
sign_oac_no | text | Sign OAC No | — | — |
sign_oac_registration | text | Sign OAC Registration | — | — |
text_on_sign | text | Text on Sign | — | — |
owner_type | text | Owner Type-(01-Individual, 02-Corporation, 03-Partnership, etc.) | — | — |
non_profit | text | Non-Profit | — | — |
owner_s_first_name | text | First Name of property owner | — | — |
owner_s_last_name | text | Last Name of property owner | — | — |
owner_s__house__ | text | House # of Property Owner | — | — |
owner_s__house_street | text | House Streett of Property Owner | — | — |
city | text | City | — | — |
state | text | State | — | — |
zip_code | text | Zip Code | — | — |
owner_s__phone__ | text | Owner's Phone # | — | — |
zoning_distr_1 | text | Zoning Distr 1 | — | — |
zoning_distr_2 | text | Zoning Distr 2 | — | — |
zoning_distr_3 | text | Zoning Distr 3 | — | — |
special_dist_name | text | Special Distr 1 | — | — |
job_description | text | Job Description | — | — |
dobrundate | datetime | Date when query is run and pushed to Open Data. Could be used to differentiate report dates. | — | — |