From a 500-row sample across 41 columns.
bblwork_typeblock+7bblapplicant_business_namefiling_representative_business_name+22bblblocklot+3Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| job_filing_number | work_permit | filing_reason | house_no | street_name | borough | lot | bin | block | c_b_no | work_on_floor | work_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Permit is no | Permit is not yet issued | Initial Permit | 43-30 | PARSONS BOULEVARD | QUEENS | 21 | 4117367 | 5198 | 407 | Open Space | Construction Fence |
| M01360498-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% | Permit is noM08004166-I1M00707919-I1 |
work_permit | text | — | 0% | Permit is not yet issuedX00598750-I1-GC-CXX00598191-I1-GC-CX |
sequence_number | text | — | 0% | 123 |
filing_reason | categorical | — | 0% | Initial PermitRenewal Permit Without C…Renewal Permit with Chan…of 5 |
GET /api/datasets/rbx6-tga4 GET /api/datasets/rbx6-tga4/quality GET /api/datasets/rbx6-tga4/related GET /api/columns?dataset=rbx6-tga4
blockhouse_nolot+6blocklotbinbblblocklot+4bblblockhouse_no+8bblcouncil_districtcensus_tract+6| M01360498-I1-GC |
| Initial Permit |
| 115 |
| NORFOLK STREET |
| Manhattan |
| 7503 |
| 1088708 |
| 353 |
| 103 |
| Facade |
| General Construction |
| M01248246-I1 | M01248246-I1-EW-SP | Initial Permit | 12 | EAST 52 STREET | MANHATTAN | 62 | 1035477 | 1287 | 105 | Cellar, Floor Number(s) 1 through 7 | Sprinklers |
| S01254881-S4 | S01254881-S4-PL | Initial Permit | 14 | BAYARD STREET | Staten Island | 6 | 5074036 | 5596 | 503 | Basement-SO-9948-S01254881-I1, Floor Number(s)-1-SO-9688-S01254881-I1, Cellar-SO-3570-S01254881-I1, Floor Number(s)-2-SO-9550-S01254881-I1, Open Space | Plumbing |
| M00714391-I1 | M00714391-I1-ST | Renewal Permit Without Changes | 301 | WEST 130 STREET | MANHATTAN | 1 | 1084087 | 1958 | 110 | Facade | Structural |
| B00755883-I1 | B00755883-I1-FN | Renewal Permit Without Changes | 545 | WILLOUGHBY AVENUE | BROOKLYN | 13 | 3048818 | 1759 | 303 | Open Space | Sidewalk Shed |
| X00970025-I1 | X00970025-I1-CC | Initial Permit | 2258 | BRUCKNER BOULEVARD | BRONX | 35 | 2130739 | 3694 | 209 | Ground Floor | Curb Cut |
| B01009515-I1 | B01009515-I1-FO | Renewal Permit Without Changes | 1550 | EAST 57 STREET | Brooklyn | 61 | 3429748 | 8377 | 318 | Cellar, Cellar, Floor Number(s) 1, Floor Number(s) 1, Floor Number(s) 2, Floor Number(s) 3 | Structural |
| Q01292720-S1 | Q01292720-S1-FN | Initial Permit | 239-26 | 147 ROAD | Queens | 61 | 4291651 | 13739 | 413 | Open Space | Construction Fence |
| B01114444-S1 | B01114444-S1-MS | Initial Permit | 180 | LIVINGSTON STREET | BROOKLYN | 7501 | 3000484 | 164 | 302 | Floor Number(s) 2 through 2 | Mechanical Systems |
Showing 12 of 40 columns. All of them are listed below.
house_no | text | — | 0% | 120010 |
street_name | text | — | 0% | BROADWAYPARK AVENUE5 AVENUE |
borough | categorical | — | 0% | MANHATTANBROOKLYNQUEENSof 10 |
lot | text | — | 0% | 175017502 |
bin | text | — | 0% | 101438710889611036082 |
block | text | — | 0% | 169621280 |
c_b_no | text | — | 1% | 105108102 |
apt_condo_no_s | text | — | 100% | OSPNAN/A |
work_on_floor | text | — | 2% | Open SpaceGround FloorRoof |
work_type | text | — | 0% | General ConstructionPlumbingSidewalk Shed |
permittee_s_license_type | categorical | — | 0% | GCPFof 11 |
applicant_license | text | — | 0% | 607447620254617232 |
applicant_first_name | text | — | 0% | MICHAELJOHNJOSEPH |
applicant_middle_name | text | — | 91% | JAM |
applicant_last_name | text | — | 0% | SINGHKAURLAFFEY |
applicant_business_name | text | — | 0% | SPRING SCAFFOLDING LLCPLATINUM SERVICES NY LLCCORE SCAFFOLD SYSTEMS IN… |
applicant_business_address | text | — | 3% | 53-28 11TH STREET 2ND FL49-30 31ST PLACE417 MYRTLE AVE SUITE 14 |
filing_representative_first_name | text | — | 46% | ELYSTEVENBIBI |
filing_representative_middle_initial | text | — | 99% | MJK |
filing_representative_last_name | text | — | 46% | SEPULVEDAR LALBIHARIITWARIE |
filing_representative_business_name | text | — | 46% | AE DESIGN SOLUTION INC.JENNY FLORES EXPEDITINGA1 EXPEDITING SERVICE CO… |
approved_date | datetime | — | 0% | 2024-03-26T00:00:00.0002022-05-31T00:00:00.0002022-06-22T00:00:00.000 |
issued_date | datetime | — | 0% | 2026-06-22T00:00:00.0002025-02-27T00:00:00.0002022-11-09T00:00:00.000 |
expired_date | datetime | — | 0% | 2026-12-31T00:00:00.0002020-08-06T00:00:00.0002026-12-31T05:00:00.000 |
job_description | text | — | 0% | PROPOSED INSTALLATION OF…INSTALLATION OF TEMPORAR…PROPOSED INSTALLATION OF… |
estimated_job_costs | text | — | 0% | 100050000 |
owner_business_name | text | — | 4% | PRNot ApplicableNYCHA |
owner_name | text | — | 1% | CHIRAG PATELCHARLESTON ALBERTWILLIAM KNIGHT |
owner_street_address | text | — | 100% | — |
owner_city | text | — | 100% | — |
owner_state | text | — | 100% | — |
owner_zip_code | text | — | 100% | — |
permit_status | categorical | — | 0% | Signed-offPermit Issuedof 2 |
tracking_number | text | — | 0% | 518523982260488496854321281 |
zip_code | text | — | 0% | 100221001111201 |
latitude | float | — | 1% | 40.75161440.75304540.762495 |
longitude | float | — | 1% | -73.992121-74.000282-73.973366 |
community_board | integer | — | 1% | 105108102 |
council_district | integer | — | 1% | 431 |
bbl | integer | — | 2% | 100783007010126600011021380040 |
census_tract | integer | — | 1% | 33137102 |
nta | text | — | 1% | Midtown-Times SquareUpper East Side-Carnegie…Midtown South-Flatiron-U… |