From a 500-row sample across 95 columns.
proposed_no_of_storiesowner_s_business_nameexisting_height+21lotfiling_representative_middle_initialborough+22owner_s_business_namelotborough+8Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| job_filing_number | filing_status | house_no | street_name | borough | block | lot | bin | commmunity_board | work_on_floor | applicant_professional_title | applicant_license |
|---|---|---|---|---|---|---|---|---|---|---|---|
| B00319790-I1 | LOC Issued | 367 | 12 STREET | Brooklyn | 1024 | 74 | 3023048 | 306 | Basement/Sub-basement, Cellar, Floor Number(s) 1 through 2, Roof | RA | 030377 |
| B00422847-I1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
job_filing_number | text | — | 0% | Q00657653-A9Q00479380-A4M00611352-A9 |
filing_status | text | — | 0% | LOC IssuedApprovedPermit Entire |
house_no | text | — | 0% | 120010 |
street_name | text | — | 0% | BROADWAYPARK AVENUE5 AVENUE |
borough | categorical |
GET /api/datasets/w9ak-ipjd GET /api/datasets/w9ak-ipjd/quality GET /api/datasets/w9ak-ipjd/related GET /api/columns?dataset=w9ak-ipjd
lotboroughblock+5lotbuilding_typeborough+12lotblockbinlotblockbinbin| Incomplete |
| 761 |
| MACON STREET |
| Brooklyn |
| 1493 |
| 48 |
| 3040031 |
| 303 |
| Floor Number(s) 001 through 02 |
| PE |
| 054573 |
| B00455182-I1 | Permit Entire | 281 | MONROE STREET | Brooklyn | 1814 | 73 | 3051205 | 303 | Ground Floor | PE | 086610 |
| B00244768-P3 | Approved | 22 | MONROE STREET | Brooklyn | 1987 | 21 | 3057064 | 303 | Cellar, Floor Number(s) 2 through 3, Floor Number(s) 1 through 2 | RA | 018485 |
| B00464221-S2 | Permit Entire | 29 | MARCONI PLACE | Brooklyn | 1566 | 4 | 3042533 | 316 | Cellar, Floor Number(s) 2 through 2 | PE | 076278 |
| B00451661-P2 | Approved | 164 | HALL STREET | Brooklyn | 1904 | 36 | 3054870 | 302 | Basement/Sub-basement, Floor Number(s) 1 through 3 | RA | 027604 |
| B00478927-I1 | Permit Entire | 11 | OLD FULTON STREET | Brooklyn | 35 | 9 | 3000076 | 302 | Floor Number(s) 001 through 001 | RA | 032438 |
| B00004392-I1 | Permit Entire | 1837 | EAST 17 STREET | Brooklyn | 6821 | 270 | 3184058 | 315 | Sid 001 thru 001 | RA | 035839 |
| B00124804-I1 | Permit Entire | 1252 | 54 STREET | Brooklyn | 5676 | 24 | 3139366 | 312 | OG - On Grade | RA | 023131 |
| B00165159-I1 | PA Certificate of Operation Issued | 5520 | GLENWOOD ROAD | Brooklyn | 7739 | 43 | 3213825 | 318 | Floor Number(s) 1 through 1 | RA | 021890 |
Showing 12 of 88 columns. All of them are listed below.
| — |
| 0% |
ManhattanBrooklynQueensof 5 |
block | text | — | 0% | 167021280 |
lot | text | — | 0% | 175017502 |
bin | text | — | 0% | 101438710889611015862 |
commmunity_board | text | — | 0% | 105108102 |
work_on_floor | text | — | 8% | Open SpaceCellarRoof |
apt_condo_no_s | text | — | 98% | 1OSPNA |
applicant_professional_title | categorical | — | 0% | PERARof 9 |
applicant_license | text | — | 0% | 072042086757088728 |
applicant_first_name | text | — | 0% | MichaelPaulEric |
applicants_middle_initial | text | — | 70% | JAM |
applicant_last_name | text | — | 0% | FosterPerdekSaigal |
owner_s_business_name | text | — | 6% | PRNot ApplicableN/A |
applicant_street_name | text | — | 0% | 85-75 SANTIAGO ST812 WYCKOFF AVE.19 WEST 44TH STREET |
city | text | — | 0% | NEW YORKBROOKLYNFLUSHING |
state | text | — | 0% | NYNJPA |
zip | text | — | 0% | 100181000111354 |
filing_representative_first_name | text | — | 21% | MUHAMMADELYJOEL |
filing_representative_middle_initial | text | — | 93% | A.JA |
filing_representative_last_name | text | — | 21% | SEPULVEDAKHEDARUCHEN |
filing_representative_business_name | text | — | 21% | MUNICIPAL BUILDING CONSU…AE DESIGN SOLUTION INC.PR |
filing_representative_street_name | text | — | 22% | 233 Broadway, Ste 205071 LEONARD STREET498 7th Aveune, 17th Flo… |
filing_representative_city | text | — | 21% | NEW YORKBROOKLYNNew York |
filing_representative_state | text | — | 21% | NYNJFL |
filing_representative_zip | text | — | 21% | 100181000110013 |
sprinkler_work_type | categorical | — | 0% | NOYESof 2 |
plumbing_work_type | categorical | — | 0% | NOYESof 2 |
standpipe | categorical | — | 0% | NOYESof 2 |
antenna | categorical | — | 0% | NOYESof 2 |
sign | categorical | — | 0% | NOYESof 2 |
curb_cut | categorical | — | 0% | NOYESof 2 |
fence | categorical | — | 0% | NOYESof 2 |
scaffold | categorical | — | 0% | NOYESof 2 |
shed | categorical | — | 0% | NOYESof 2 |
initial_cost | text | — | 0% | 010005000 |
total_construction_floor_area | text | — | 6% | 011000 |
review_building_code | categorical | — | 1% | 202220141968of 5 |
little_e | categorical | — | 0% | NoYesof 2 |
unmapped_cco_street | categorical | — | 36% | NoYesof 2 |
request_legalization | categorical | — | 100% | NoYesof 2 |
includes_permanent_removal | categorical | — | 100% | NoYesof 2 |
in_compliance_with_nycecc | categorical | — | 0% | NoYesof 2 |
exempt_from_nycecc | categorical | — | 0% | NoYesof 2 |
building_type | categorical | — | 2% | Other2 Family1 Familyof 6 |
existing_stories | text | — | 61% | 231 |
existing_height | text | — | 69% | 253060 |
existing_dwelling_units | text | — | 16% | 021 |
proposed_no_of_stories | text | — | 56% | 234 |
proposed_height | text | — | 65% | 302535 |
proposed_dwelling_units | text | — | 11% | 021 |
specialinspectionrequirement | text | — | 37% | Fire-Resistant Penetrati…Mechanical SystemsFire-Resistant Penetrati… |
special_inspection_agency_number | text | — | 44% | 005616000423000843 |
progressinspectionrequirement | text | — | 40% | FinalAir barrier - visual ins…Energy Code Compliance I… |
built_1_information_value | categorical | — | 90% | YesNoof 2 |
built_2_information_value | categorical | — | 90% | NoYesof 2 |
built_2_a_information_value | categorical | — | 90% | NoYesof 2 |
built_2_b_information_value | categorical | — | 90% | NoYesof 2 |
filing_date | datetime | — | 0% | 2022-11-04T00:00:00.0002026-03-27T00:00:00.0002026-03-26T00:00:00.000 |
current_status_date | datetime | — | 0% | 2020-12-28T00:38:38.0002020-12-28T00:04:19.0002020-12-28T00:06:59.000 |
first_permit_date | datetime | — | 40% | 2025-11-06T00:00:00.0002025-11-13T00:00:00.0002024-03-26T00:00:00.000 |
boiler_equipment_work_type_ | text | — | 0% | NOof 1 |
earth_work_work_type_ | categorical | — | 0% | NOYESof 2 |
foundation_work_type_ | categorical | — | 0% | NOYESof 2 |
general_construction_work_type_ | categorical | — | 0% | NOYESof 2 |
mechanical_systems_work_type_ | categorical | — | 0% | NOYESof 2 |
place_of_assembly_work_type_ | categorical | — | 0% | NOYESof 2 |
protection_mechanical_methods_work_type_ | categorical | — | 0% | NOYESof 2 |
sidewalk_shed_work_type_ | categorical | — | 0% | NOYESof 2 |
structural_work_type_ | categorical | — | 0% | NOYESof 2 |
support_of_excavation_work_type_ | text | — | 0% | Noof 1 |
temporary_place_of_assembly_work_type_ | categorical | — | 0% | NOYESof 2 |
green_roof_work_type_ | categorical | — | 0% | NOYESof 2 |
solar_work_type_ | categorical | — | 0% | NOYESof 2 |
full_demolition_work_type_ | categorical | — | 0% | NOYESof 2 |
suspended_scaffold_work_type_ | categorical | — | 0% | NOYESof 2 |
job_type | categorical | — | 0% | AlterationNew BuildingAlteration COof 6 |
latitude | coordinate | — | 0% | 40.75161440.75304540.747878 |
longitude | coordinate | — | 0% | -73.992121-74.000282-73.984979 |
postcode | text | — | 0% | 100221000110011 |
council_district | text | — | 0% | 040301 |
census_tract | text | — | 0% | 102104137 |
bbl | text | — | 2% | 100783007010070275011012660001 |
nta | text | — | 0% | Midtown-Times SquareUpper East Side-Carnegie…Midtown South-Flatiron-U… |
approved_date | datetime | — | 15% | 2025-12-19T16:05:49.0002025-02-25T20:38:23.0002025-02-25T21:05:29.000 |
signoff_date | datetime | — | 60% | 2022-11-09T00:00:00.0002022-11-05T23:00:00.0002023-11-13T00:00:00.000 |
applicant_business_name | text | — | 0% | ASHRAF CORPPAUL PERDEK, PROF. ENG. …ROBERT DERECTOR ASSOCIAT… |
owner_first_name | text | — | 0% | JOSEPHMICHAELMichael |
owner_last_name | text | — | 0% | SINGHCHENPatel |
owner_type | categorical | — | 0% | CorporationIndividualPartnershipof 10 |
job_description | text | — | 2% | PROPOSED INSTALLATION OF…PROPOSED INSTALLATION OF…INSTALLATION OF TEMPORAR… |
filing_review_type | categorical | — | 0% | Professional Certificati…Standard Plan Examinatio…of 2 |