From a 500-row sample across 21 columns.
cent_latitudecitycouncildistrictcent_longitude+11cent_latitudecitycouncildistrictcent_longitude+10cent_latitudecent_longitudebbl+2cent_latitudeHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| vio_id | acct_num | acct_owner | violation_num | vio_law_num | vio_law_desc | vio_date | action | prem_addr | bin | number | street |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 28209732 | MTA NYC TRANSIT | E494287 | SPK 40 | PROVIDE/POST VALVES SIGNS SPK SY | 2017-04-20T00:00:00.000 | OPEN | 1 SO FERRY STATION | 0 | 1 | SO FERRY STATION |
| 2 | 28209732 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vio_id | integer | Record Key | 0% | 163361005148498 |
acct_num | integer | Permit Account Number | 0% | 290771042816732834227066 |
acct_owner | text | Permint Account Owner | 0% | NYC DEPT OF EDUCATIONMTA NYC TRANSITNYC DCAS |
violation_num | text | Violation Document Number | 0% | E522781E236013E469656 |
vio_law_num |
GET /api/datasets/bi53-yph3 GET /api/datasets/bi53-yph3/quality GET /api/datasets/bi53-yph3/related GET /api/columns?dataset=bi53-yph3
citycouncildistrictcent_longitudebblbinborough| MTA NYC TRANSIT |
| E494287 |
| SPK 36 |
| OBTAIN A COF SPRINKLER SYSTEM |
| 2017-04-20T00:00:00.000 |
| OPEN |
| 1 SO FERRY STATION |
| 0 |
| 1 |
| SO FERRY STATION |
| 3 | 28209732 | MTA NYC TRANSIT | E494287 | SPK 38 | RECORDSYSINSPS,TESTS,OTHER MAINTENANCE | 2017-04-20T00:00:00.000 | OPEN | 1 SO FERRY STATION | 0 | 1 | SO FERRY STATION |
| 4 | 38373478 | NYC DEPT OF EDUCATION | E561065 | SPPA 4 | NO PA PERMIT | 2018-11-07T00:00:00.000 | OPEN | 21 WEST END AVE | 0 | 21 | WEST END AVE |
| 5 | 87008421 | CHURCH OF JESUS CHRIST | E402518 | SPPA 4 | NO PA PERMIT | 2014-10-10T00:00:00.000 | OPEN | 343 COURT ST | 0 | 343 | COURT ST |
| 6 | 34241299 | NYC DEPT OF CORRECTION | E425128 | OTHER0001 | SEE FOLDER INFORMATION | 2014-12-09T00:00:00.000 | OPEN | 17-19 HAZEN ST | 0 | 17-19 | HAZEN ST |
| 7 | 37092749 | NYCDEPT OF PARKS STRATIS | E495697 | OTHER0001 | SEE FOLDER INFORMATION | 2017-02-23T00:00:00.000 | OPEN | 301 SHORE RD | 0 | 301 | SHORE RD |
| 8 | 32276305 | AUDBON | E34679907 | OTHER0001 | SEE FOLDER INFORMATION | 2012-07-05T00:00:00.000 | OPEN | 2323 ADAM CLAYTON BLVD | 0 | 2323 | ADAM CLAYTON BLVD |
| 9 | 28029114 | MTA NYC TRANSIT | E520247 | SPK 36 | OBTAIN A COF SPRINKLER SYSTEM | 2018-07-25T00:00:00.000 | OPEN | 1 BEACH 116 ST STAT | 0 | 1 | BEACH 116 ST STAT |
| 10 | 28029114 | MTA NYC TRANSIT | E520247 | SPK 37 | PROVIDE /MAINTAIN RECORDS INSP SPK SYS | 2018-07-25T00:00:00.000 | OPEN | 1 BEACH 116 ST STAT | 0 | 1 | BEACH 116 ST STAT |
| text |
| Violation Citation |
| 0% |
OTHER0001RH-7SPPA 4 |
vio_law_desc | text | Violation Citation | 3% | SEE FOLDER INFORMATIONARRANGE FOR TEST OR RETE…NO PA PERMIT |
vio_date | datetime | Date of Violation | 0% | 2018-12-03T00:00:00.0002018-11-08T00:00:00.0002018-11-14T00:00:00.000 |
action | text | Status of Violation | 0% | OPENof 1 |
prem_addr | text | Premises Address | 0% | 245 MESEROLE AVE211 CONVENT AVE350 5 AVE |
bin | integer | Building Identification Number | 0% | 306544210856703347326 |
communitydistrict | integer | Building Community Board | 4% | 105101104 |
citycouncildistrict | integer | Buidling Council District | 4% | 431 |
bbl | integer | Builing Block Lot | 4% | 302604000140651700011019570105 |
cent_latitude | float | Latitude of Building Centroid | 4% | 40.72936240.81982840.63176 |
cent_longitude | float | Longitude of Building Centroid | 4% | -73.946552-73.948562-73.953481 |
zipcode | integer | Building ZIP Code | 4% | 100161000110019 |
borough | categorical | Building Borough | 0% | MNBKQNof 5 |
number | text | — | 0% | 1245200 |
street | text | — | 0% | BROADWAY5 AVE3 AVE |
census_tract | integer | — | 0% | 8457333 |
nta | text | — | 0% | Midtown-Midtown SouthHudson Yards-Chelsea-Fla…SoHo-TriBeCa-Civic Cente… |