From a 500-row sample across 20 columns.
prem_addrbincommunitydistrict+11prem_addrbincommunitydistrict+10binbblcent_longitude+2binHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| acct_id | alpha | acct_num | owner_name | last_visit_dt | last_full_insp_dt | last_insp_stat | prem_addr | bin | number | street |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | P | 4812798 | BEN RIC FUR FASHIONS INC | 2018-03-23T00:00:00.000 | 2018-03-23T00:00:00.000 | APPROVAL | 186-14 UNION TNPK | 0 | 186-14 | UNION TNPK |
| 2 | P | 6486682 | RICHAL INC. |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
acct_id | integer | Record Key | 0% | 461061366961174466 |
alpha | text | Hazardous Level | 0% | PAAG |
acct_num | integer | — | 0% | 8801448543647256492664 |
owner_name | text | Permit Account Owner Name | 0% | NYCHARESTAURANTNYC DEPT OF EDUCATION |
last_visit_dt | datetime | Latest Date of Bureau of Fire Prevention visit |
GET /api/datasets/ssq6-fkht GET /api/datasets/ssq6-fkht/quality GET /api/datasets/ssq6-fkht/related GET /api/columns?dataset=ssq6-fkht
bblborough| 2018-03-23T00:00:00.000 |
| 2018-03-23T00:00:00.000 |
| APPROVAL |
| 179-10 UNION TNPK |
| 0 |
| 179-10 |
| UNION TNPK |
| 3 | C | 6743934 | CROSSTOWN MGT. CORP. | 2017-03-29T00:00:00.000 | 2017-03-29T00:00:00.000 | NOV(HOLD) | 179-18 UNION TNPK | 0 | 179-18 | UNION TNPK |
| 4 | RR | 23012560 | F.D.N.Y. | 2016-01-25T00:00:00.000 | 2016-01-25T00:00:00.000 | APPROVAL | 34-11 HUNTERS POINT AVE | 0 | 34-11 | HUNTERS POINT AVE |
| 5 | G | 26087460 | MTA NYC TRANSIT | 2014-08-21T00:00:00.000 | 2014-08-21T00:00:00.000 | APPROVAL | 1 176 STREET STATION | 0 | 1 | 176 STREET STATION |
| 6 | G | 27149681 | ANTLER APARTMENT | 2014-06-10T00:00:00.000 | 2014-06-10T00:00:00.000 | NOT APPROVAL(W/REASON) | 2079 DOUGLAS BLVD | 0 | 2079 | DOUGLAS BLVD |
| 7 | G | 28029114 | MTA NYC TRANSIT | 2018-07-25T00:00:00.000 | 2018-07-25T00:00:00.000 | NOT APPROVAL(VIO) | 1 BEACH 116 ST STAT | 0 | 1 | BEACH 116 ST STAT |
| 9 | G | 28069136 | MTA NYC TRANSIT | 2018-06-30T00:00:00.000 | 2018-06-30T00:00:00.000 | NOT APPROVAL(VIO) | 3 CANAL ST STATION | 0 | 3 | CANAL ST STATION |
| 10 | F | 28084887 | BAINBRIDGE CLUSTER ASSOC | 2014-01-15T00:00:00.000 | 2014-01-15T00:00:00.000 | APPROVAL | 412 MCDONOUGH ST | 0 | 412 | MCDONOUGH ST |
| 11 | G | 28084895 | BAINBRIDGE CLUSTER ASSOC | 2014-12-10T00:00:00.000 | 2014-12-10T00:00:00.000 | APPROVAL | 412 MCDONOUGH ST | 0 | 412 | MCDONOUGH ST |
| 0% |
2018-11-07T00:00:00.0002018-10-10T00:00:00.0002018-11-14T00:00:00.000 |
last_full_insp_dt | datetime | Latest Date of Bureau of Fire Prevention full inspection | 0% | 2018-10-16T00:00:00.0002018-11-07T00:00:00.0002018-10-10T00:00:00.000 |
last_insp_stat | categorical | Status of latest Fire Prevention inspection | 0% | APPROVALNOT APPROVAL(W/REASON)NOT APPROVAL(VIO)of 7 |
prem_addr | text | Premises Address | 0% | 245 MESEROLE AVE9 METROTECH CENTER1 PENN PLZ |
bin | integer | Building Identification Number | 0% | 306544230581871014387 |
communitydistrict | integer | Building Community Board | 5% | 105301101 |
citycouncildistrict | integer | Buidling Council District | 5% | 431 |
bbl | integer | Building Block Lot | 6% | 302604000130204700111021380040 |
cent_latitude | float | Latitude of Building Centroid | 5% | 40.72936240.69449940.751157 |
cent_longitude | float | Longitude of Building Centroid | 5% | -73.946552-73.984505-73.992239 |
zipcode | integer | Building ZIP Code | 5% | 100191002210016 |
borough | categorical | Building Borough | 0% | MNBKQNof 5 |
number | text | — | 0% | 24519 |
street | text | — | 0% | BROADWAY5 AVE3 AVE |
census_tract | integer | — | 0% | 5739633 |
nta | text | — | 0% | Midtown-Midtown SouthHudson Yards-Chelsea-Fla…SoHo-TriBeCa-Civic Cente… |