From a 500-row sample across 57 columns.
oil_gasself_certspecial_district_1+39community_boardlotlongitude+8boroughMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| borough | bin | house | street_name | job | job_doc | job_type | block | lot | community_board | zip_code | bldg_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| BRONX | 2124254 | 2922 | THROOP AVENUE | 210107944 | 1 | NB | 4563 | 19 | 211 | 10469 | 1 |
| BRONX | 2001880 | 615 | COURTLANDT AVE |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | — | 0% | MANHATTANBROOKLYNQUEENSof 5 |
bin | text | — | 0% | 101586210762621014387 |
house | text | — | 0% | 1200100 |
street_name | text | Street Name | 0% | BROADWAYPARK AVENUEMADISON AVENUE |
job | text | — |
GET /api/datasets/bty7-2jhb GET /api/datasets/bty7-2jhb/quality GET /api/datasets/bty7-2jhb/related GET /api/columns?dataset=bty7-2jhb
lotbinblockcouncil_districtcommunity_boardlot+9ntabinbbllotbinblocklotfiling_datebin+4| 220206907 |
| 1 |
| A2 |
| 2411 |
| 49 |
| 201 |
| 10451 |
| 2 |
| BRONX | 2002452 | 650 | GRAND CONCOURSE | 220286107 | 1 | A3 | 2443 | 53 | 204 | 10451 | 2 |
| BRONX | 2063396 | 757 | EAST 224TH STREET | 220193957 | 1 | A2 | 4838 | 20 | 212 | 10466 | 2 |
| BRONX | 2127651 | 2017 | VALENTINE AVE | 220245811 | 1 | NB | 3149 | 65 | 205 | 10457 | 2 |
| BRONX | 2017983 | 201 | EAST MOSHOLU PARKWAY NORTH | 240023880 | 1 | A3 | 3335 | 1 | 207 | 10467 | 2 |
| BRONX | 2127427 | 2388 | CRESTON AVENUE | 220150440 | 3 | NB | 3165 | 10 | 205 | 10468 | 2 |
| BRONX | 2094151 | 1141 | EAST 229TH STREET | 220199121 | 1 | A2 | 4905 | 1 | 212 | 10466 | 2 |
| BRONX | 2011289 | 441 | EAST 180TH STREET | 220044066 | 1 | A1 | 3037 | 1 | 206 | 10457 | 2 |
| BRONX | 2084160 | 3555 | JOHNSON AVENUE | 220257512 | 1 | A2 | 5794 | 501 | 208 | 10463 | 2 |
Showing 12 of 52 columns. All of them are listed below.
| 0% |
200718330103297521102318804 |
job_doc | categorical | — | 0% | 123of 12 |
job_type | categorical | — | 0% | A2NBA1of 6 |
self_cert | text | — | 63% | Yof 1 |
block | text | — | 0% | 169725141 |
lot | text | — | 0% | 1750129 |
community_board | text | — | 0% | 105108102 |
zip_code | text | — | 0% | 100221001910013 |
bldg_type | categorical | — | 2% | 21of 2 |
residential | text | — | 68% | YESof 1 |
special_district_1 | text | — | 92% | MIDSROP |
special_district_2 | categorical | — | 100% | LH-1APILH-1of 14 |
work_type | categorical | — | 19% | OTPLEQof 13 |
permit_status | categorical | — | 0% | ISSUEDRE-ISSUEDIN PROCESSof 4 |
filing_status | categorical | — | 0% | INITIALRENEWALof 2 |
permit_type | categorical | — | 0% | EWPLEQof 8 |
permit_sequence | text | — | 0% | 123 |
permit_subtype | categorical | — | 42% | OTFNMHof 15 |
oil_gas | categorical | — | 99% | OILGASof 2 |
site_fill | categorical | — | 7% | NONENOT APPLICABLEON-SITEof 5 |
filing_date | datetime | — | 0% | 2007-03-29T00:00:002007-03-30T00:00:002006-12-28T00:00:00 |
issuance_date | datetime | — | 0% | 2007-03-29T00:00:002007-03-30T00:00:002006-12-28T00:00:00 |
expiration_date | datetime | — | 0% | 2007-12-31T00:00:002006-12-31T00:00:002005-12-31T00:00:00 |
job_start_date | datetime | — | 0% | 2008-06-27T00:00:002008-06-25T00:00:002007-07-17T00:00:00 |
permittee_s_first_name | text | — | 0% | JOHNMICHAELROBERT |
permittee_s_last_name | text | — | 0% | SINGHWHITELEE |
permittee_s_business_name | text | — | 0% | N/AROCKLEDGE SCAFFOLDSTRUCTURE TONE INC |
permittee_s_phone | text | — | 0% | 212481610071839249219144230400 |
permittee_s_license_type | categorical | — | 10% | GENERAL CONTRACTORMASTER PLUMBERFIRE SUPPRESSION CONTRAC…of 11 |
permittee_s_license | text | — | 9% | 026601982 |
act_as_superintendent | categorical | — | 34% | YNof 2 |
permittee_s_other_title | text | — | 89% | GCG.C.G.C |
hic_license | text | — | 99% | 0999999945141 |
site_safety_mgr_s_first_name | text | — | 100% | N/AJOHNMICHAEL |
site_safety_mgr_s_last_name | text | — | 100% | N/AWAIVERESPOSITO |
site_safety_mgr_business_name | text | — | 100% | N/ATOTAL SAFETY CONSULTINGSITE SAFETY LLC |
superintendent_first_last_name | text | — | 33% | N/AROCKLEDGE SCAFFOLDSTRUCTURE TONE INC |
superintendent_business_name | text | — | 33% | N/AROCKLEDGE SCAFFOLDSTRUCTURE TONE INC |
owner_s_business_type | categorical | — | 7% | CORPORATIONINDIVIDUALPARTNERSHIPof 14 |
non_profit | text | — | 94% | Yof 1 |
owner_s_business_name | text | — | 10% | N/ANANY SCHOOL CONSTRUCTION A… |
owner_s_first_name | text | — | 6% | ROBERTMICHAELJOHN |
owner_s_last_name | text | — | 6% | COHENSINGHJoseph |
owner_s_house | text | — | 6% | 10030-301 |
owner_s_house_street_name | text | — | 6% | BROADWAYTHOMSON AVENUEGOLD STREET |
owner_s_house_city | text | — | 6% | NEW YORKBROOKLYNNY |
owner_s_house_state | text | — | 6% | NYNJCT |
owner_s_house_zip_code | text | — | 7% | 100381002210017 |
owner_s_phone | text | — | 8% | 718472800021286376252128637490 |
dobrundate | datetime | — | 0% | 2016-01-03T00:00:00of 1 |
latitude | float | — | 0% | 40.75416240.74834240.751098 |
longitude | float | — | 0% | -73.976557-73.984643-73.992926 |
council_district | integer | — | 0% | 431 |
census_tract | integer | — | 0% | 733102 |
bbl | integer | — | 1% | 100972000110126600011012809010 |
nta | text | — | 0% | Midtown-Midtown South …Upper East Side-Carnegie…SoHo-TriBeCa-Civic Cente… |