From a 500-row sample across 75 columns.
job_filing_numberjob_numberowner_addressfiling_fee+19filing_dateblockbbl+4building_typefiling_datelatitude+12Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| job_filing_number | job_number | filing_number | filing_date | filing_type | elevatordevicetype | filing_status | filingstatus_or_filingincludes | building_code | bin | house_number | street_name |
|---|---|---|---|---|---|---|---|---|---|---|---|
| X00608233-I1 | X00608233 | I1 | 2021-10-12T00:00:00.000 | New Filing | Elevator | Signed Off | Remove | 1968 | 2071889 | 4770 | WHITE PLAINS ROAD |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
job_filing_number | text | A unique identifier assigned to a job filing. It consists of job number (a letter indicating the borough followed by an 8-digit number) hyphenated with Filing Number (a 2-digit code identifying the filing type). Once the permit is issued, a suffix "-VT" is added to the job filing number. (Example: B00016701-I1-VT) | 0% | Q00641359-B8M00723903-B6X01170053-P1 |
job_number | text | A 9-digit identifier for the job. The first letter indicates the borough for which the filing is associated, followed by an 8-digit ID number | 0% | X00513466M08015986M08013214 |
filing_number | text | A 2-digit code identifying the filing type | 0% | I1P1P2 |
filing_date | datetime | Filing Date; Date and Time Format: '2018-04-25 21:52:00.000' |
GET /api/datasets/kfp4-dz4h GET /api/datasets/kfp4-dz4h/quality GET /api/datasets/kfp4-dz4h/related GET /api/columns?dataset=kfp4-dz4h
building_typeblockbbl+5job_numberfiling_datelatitude+5filing_dateowner_cityowner_zip+8latitudeowner_cityblock+9| M08010801-I1 |
| M08010801 |
| I1 |
| 2022-11-03T00:00:00.000 |
| New Filing |
| Elevator |
| Permit Entire |
| Alteration/Replacement |
| 1968 |
| 1015405 |
| 50 |
| WEST 17 STREET |
| B00531676-S9 | B00531676 | S9 | 2022-09-29T00:00:00.000 | Subsequent Filing | Elevator | Signed Off | New Installation | 2014 | 3429986 | 89 | THROOP AVENUE |
| M00569227-I1 | M00569227 | I1 | 2021-08-02T00:00:00.000 | New Filing | Escalator | Signed Off | Remove | 1968 | 1001033 | 78 | TRINITY PLACE |
| M00401198-P2 | M00401198 | P2 | 2022-06-28T00:00:00.000 | PAA | Elevator | Approved | New Installation | 2014 | 1091604 | 501 | WEST 35 STREET |
| B00653276-A1 | B00653276 | A1 | 2024-06-25T00:00:00.000 | PAA | Elevator | Approved | New Installation | 2014 | 3429307 | 99 | FLEET PLACE |
| B00924918-I1 | B00924918 | I1 | 2023-09-11T00:00:00.000 | New Filing | Elevator | Signed Off | New Installation | 2022 | 3183035 | 1520 | KINGS HIGHWAY |
| Q00787703-I1 | Q00787703 | I1 | 2023-04-21T00:00:00.000 | New Filing | Accessibility Lift | Signed Off | New Installation | 2022 | 4433323 | 29-50 | 137 STREET |
| X00664191-I1 | X00664191 | I1 | 2022-01-24T00:00:00.000 | New Filing | Elevator | Signed Off | Alteration/Replacement | 2014 | 2117663 | 1551 | EAST 172 STREET |
| B01022101-I1 | B01022101 | I1 | 2024-03-19T00:00:00.000 | New Filing | Elevator | Signed Off | Alteration/Replacement | 2022 | 3001943 | 63 | MONTAGUE STREET |
Showing 12 of 73 columns. All of them are listed below.
| 0% |
2019-12-30T00:00:00.0002020-03-04T00:00:00.0002019-07-17T00:00:00.000 |
filing_type | categorical | Indicates whether this filing is new, subsequent or Post Approval Amendment (PAA) filing | 0% | New FilingPAASubsequent Filingof 3 |
elevatordevicetype | categorical | Expected Values: Accessibility Lift, Conveyor, Dumbwaiter, Elevator, Escalator, Moving Walk, Personnel Hoist | 0% | ElevatorPersonnel HoistAccessibility Liftof 7 |
filing_status | categorical | Indicates status of the permit application. Example: Permit Issued | 0% | Signed OffApprovedPermit Entireof 15 |
filingstatus_or_filingincludes | categorical | Indicates if the filing status includes any other filings | 0% | Alteration/ReplacementNew InstallationRemoveof 5 |
building_code | categorical | Building code which is single select value | 0% | 196820142022of 4 |
electrical_permit_number | text | Electrical Permit Number | 57% | M00059517-I1-ELs00013087-i1-elM00113252-I1-EL |
bin | text | Building Identification Number (BIN) of the job location. Assigned by Department of City Planning. | 0% | 109027410857351090122 |
house_number | text | The house number of the job location | 0% | 1200100 |
street_name | text | The Street Name of the job location | 0% | BROADWAY5 AVENUEPARK AVENUE |
zip | text | Zip code of the job location | 0% | 100221000110019 |
borough | categorical | Borough of job location | 0% | ManhattanBrooklynQueensof 5 |
block | text | Tax block number of the job location. Assigned by the Department of Finance. | 0% | 169721280 |
lot | text | Tax lot number of the job location. Assigned by the Department of Finance. | 0% | 175017502 |
building_type | categorical | Category of Building - used for Inconjunction fee. 1,2,3 family - 130$ or other - 225$ | 0% | Other3 Family2 Familyof 3 |
buildingstories | text | Number of Stories in the Building | 0% | 765 |
is_in_conjunction | boolean | Flag: Yes or No | 0% | FalseTrueof 2 |
associatedjobnumber | text | Associated BIS Job Number if applicable; | 88% | 122885422121191414500731611 |
total_construction_floor | text | — | 0% | 20040020 |
plan_examiner_assigned_date | datetime | Plan Examiner Assigned Date | 8% | 2019-11-06T00:00:00.0002019-12-10T00:00:00.0002019-11-20T00:00:00.000 |
incomplete_date | date | Incomplete Date | 100% | 2022-12-012022-09-292022-11-03of 16 |
last_incomplete_submission | date | Last Incomplete Submission Date | 100% | 2022-12-012022-07-192022-09-29of 18 |
first_objection_date | datetime | First Objection Date | 74% | 2022-11-29T00:00:00.0002022-12-14T00:00:00.0002022-11-28T00:00:00.000 |
last_objection_date | datetime | Last Objection date | 74% | 2024-02-05T00:00:00.0002022-12-05T00:00:00.0002026-10-05T00:00:00.000 |
resubmission_date | datetime | Re-submission Date | 74% | 2022-12-07T00:00:00.0002023-01-05T00:00:00.0002024-06-24T00:00:00.000 |
permit_entire_date | datetime | Permit Entire Date | 15% | 2019-11-06T00:00:00.0002019-12-31T00:00:00.0002019-11-18T00:00:00.000 |
signedoff_date | datetime | Signed Off Date | 27% | 2021-09-22T00:00:00.0002020-09-25T00:00:00.0002021-04-06T00:00:00.000 |
applicant_firstname | text | First name of the applicant | 0% | JOSEPHRICHARDGEORGE |
applicant_lastname | text | Last name of the applicant | 0% | RISIEVELKINZIUGZDA |
applicant_businessname | text | Name of Applicant Business | 0% | OTIS ELEVATOR COMPANYSCHINDLER ELEVATOR CORPKONE, INC |
applicant_address | text | Street address of the applicant's firm | 65% | 1 PENN PLAZA, 250 W 34ST2618 AVENUE Z 1ST FLOOR59-40 QUEENS BLVD. |
applicant_city | text | City of the applicant's firm | 1% | NEW YORKBROOKLYNLONG ISLAND CITY |
applicant_state | text | State of the applicant's firm | 100% | — |
applicant_zip | text | ZIP code of the applicant's firm | 0% | 111011011910018 |
applicant_license_number | text | Applicant's license number, DOB issues licenses to qualified individuals working in the construction trades in New York City. | 2% | L - 038001L - 556001L - 366001 |
designprofessional_firstname | text | First Name of Design Professional | 44% | WILLIAMFREDCHANG |
designprofessional_lastname | text | Last Name of Design Professional | 44% | MADDENTORRICOPARK |
designprofessional | text | Design Professional Business Name | 44% | WILLIAM MADDEN ENGINEER …FRED W. TORRICO ARCHITEC…CHANG PARK ARCHITECT, P.… |
designprofessional_address | text | Street address of the Design Professional | 44% | 33-16 104TH STREET24-09 38TH AVENUE177 E. MAIN STREET |
designprofessional_city | text | City of Design Professional's firm | 44% | CORONALONG ISLAND CITYNEW ROCHELLE |
designprofessional_state | categorical | State of Design Professional's State | 44% | NYNJNEW YORKof 5 |
designprofessional_zip | text | Zip code of Design Professional's State | 44% | 113681110110801 |
designprofessional_license | text | Design Professional License number, DOB issues licenses to qualified design professionals working in the construction trades in New York City. | 44% | PE - 063923RA - 023257RA - 024582 |
owner_firstname | text | First Name of Owner | 0% | MICHAELRICHARDKATHERINE |
owner_lastname | text | Last Name of Owner | 0% | EDDERSL'ESPERANCEORZEL |
owner_title | text | Title information for Owner | 71% | AGENTAgentrep |
owner_businessname | text | Owner Information Business Name | 1% | PRNOUVEAU ELEVATORCENTENNIAL ELEVATOR INDU… |
owner_address | text | Street Address of the Owner | 100% | — |
owner_city | text | City of the Owner | 100% | — |
owner_state | text | State of the Owner | 100% | — |
owner_zip | text | Zip of the Owner | 100% | — |
owner_type | categorical | Owner Type | 0% | PrivatePrivate-Tax ExemptNYCHAof 7 |
asbestosabatementcompliance | categorical | Asbestos Abatement Compliance | 0% | The scope of work is exe…The scope of work is not…The scope of work requir…of 3 |
depacp5controlno | text | DEP ACP-5 Control No. | 98% | 1125606332786511556246 |
descriptionofwork | text | Scope of Work | 0% | Provide door lock monito…PROVIDE NEW DOOR LOCK MO…FURNISH AND INSTALL DOOR… |
gl_company | text | Name of the company providing General Liability insurance to the applicant's firm | 0% | GREAT AMERICAN INS COLLOYDS OF LONDONOLD REPUBLIC INS CO |
gl_policy | text | Policy number of the General Liability insurance covering the applicant's firm | 0% | MYZY 57732BO595XN6662021CSU0093329 |
gl_expirationdate | datetime | Expiration date of the General Liability insurance policy covering the applicant's firm | 0% | 2021-01-01T00:00:00.0002022-03-01T00:00:00.0002020-04-01T00:00:00.000 |
worker_compensation_company | text | Name of the company providing Workers Compensation insurance to the applicant's firm | 0% | NEW YORK STATE INS FUNDNYSIFAIU INSURANCE COMPANY |
worker_compensation_policy | text | Policy number of the Workers Compensation insurance covering the applicant's firm | 0% | Q2180 468-7Z1470 006-6X2252 883-0 |
worker_compensation | datetime | Expiration date of the Workers Compensation insurance policy covering the applicant's firm | 0% | 2021-01-01T00:00:00.0002022-01-01T00:00:00.0002020-04-01T00:00:00.000 |
disability_company | text | Insurance Information Disability | 0% | SHELTERPOINT LIFE INS COLIBERTY LIFE ASSURANCEWESCO INSURANCE COMPANY |
disability_policy | text | Insurance Information Disability Certification/Policy No | 0% | 120137DBL247852DBL602180 |
disability_expirationdate | datetime | Insurance Information Disability Expiration Date | 0% | 2020-12-31T00:00:00.0002021-12-31T00:00:00.0002026-12-31T00:00:00.000 |
estimated_cost | integer | Estimated Cost | 0% | 10000200005000 |
filing_fee | float | Fee required for the job filing | 0% | 0225195 |
no_good_check | categorical | A fee required if first check payment to DOB was rejected / returned | 99% | 204060of 5 |
total_fee | float | Indicates total fee amount (quantity * cost) | 0% | 0225325 |
amount_paid | float | Amount paid by applicant | 0% | 0225325 |
amount_due | categorical | Balance remaining | 0% | 0120100of 8 |
review_type_ppn | categorical | Whether filed as minor/ordinary repair work Policy and Procedure Notice and will be self-certified by the elevator company. | 0% | NoYesof 2 |
permit_expiration_date | datetime | The date of the latest permit expiration | 15% | 2021-12-31T00:00:00.0002020-12-31T00:00:00.0002026-12-31T00:00:00.000 |
latitude | float | — | 1% | 40.75401340.75150240.754162 |
longitude | float | — | 1% | -73.999552-73.976557-73.999083 |
community_district_number | text | — | 1% | 105108104 |
city_council_district | text | — | 1% | 040301 |
census_tract | text | — | 1% | 73733 |
bbl | text | — | 1% | 100972000110070500391012809010 |
nta_name | text | — | 1% | Midtown-Times SquareUpper East Side-Carnegie…Midtown South-Flatiron-U… |