From a 500-row sample across 18 columns.
communitydistrictcensus_tractnta+10communitydistrictcensus_tractnta+10cent_longitudeboroughbin+2binbblHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| cof_id | cof_num | cof_type | holder_name | expires_on | prem_addr | bin | number | street |
|---|---|---|---|---|---|---|---|---|
| 1 | 83424457 | CON LOW PSI OIL BURN | JOHNSON CONNELL | 2020-01-09T00:00:00.000 | 141 W 156 ST | 0 | 141 | W 156 ST |
| 2 | 62932090 | COQ - REFRIGERATION ENGINEER | SHAPIRO IGOR | 2020-01-30T00:00:00.000 | 10 GRAND ARMY PLZ | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
cof_id | integer | Record Key | 0% | 234 |
cof_num | integer | Certificate of Fitness Number | 0% | 879803148527904084646090 |
cof_type | text | Type of Certificate of Fitness | 0% | INDOOR PLACE OF ASSEMBLY…SUPERVISION OF FIRE ALAR…SUPERVISING NON-PRODUCTI… |
holder_name | text | Certificate Holder Name | 0% | DAGNE EUEALBRUM MARKDIAMOND PLATE |
GET /api/datasets/pdiy-9ae5 GET /api/datasets/pdiy-9ae5/quality GET /api/datasets/pdiy-9ae5/related GET /api/columns?dataset=pdiy-9ae5
borough| 10 |
| GRAND ARMY PLZ |
| 3 | 84077783 | COQ - REFRIGERATION ENGINEER | DAVIS RONNELL B | 2020-12-31T00:00:00.000 | 10 GRAND ARMY PLZ | 0 | 10 | GRAND ARMY PLZ |
| 4 | 84825462 | COQ - REFRIGERATION ENGINEER | LASPINA STEPHEN A | 2018-12-15T00:00:00.000 | 10 GRAND ARMY PLZ | 0 | 10 | GRAND ARMY PLZ |
| 5 | 85746006 | COQ - REFRIGERATION ENGINEER | MACK DARVIN | 2020-02-03T00:00:00.000 | 10 GRAND ARMY PLZ | 0 | 10 | GRAND ARMY PLZ |
| 6 | 86574316 | COQ - REFRIGERATION ENGINEER | ALBINO JR ALBIN | 2018-10-16T00:00:00.000 | 10 GRAND ARMY PLZ | 0 | 10 | GRAND ARMY PLZ |
| 7 | 89768964 | FIRE & NONFIRE DRILL COND PUBLIC PRE-K-12 SCH | WEINSTEIN MICHAEL | 2020-09-01T00:00:00.000 | 30-20 THOMPSON AVE | 0 | 30-20 | THOMPSON AVE |
| 8 | 86874039 | FIRE AND EMERGENCY DRILL CONDUCTOR | DAVIS KARON | 2019-04-24T00:00:00.000 | 10 GRAND ARMY PLZ | 0 | 10 | GRAND ARMY PLZ |
| 9 | 86878659 | FIRE AND EMERGENCY DRILL CONDUCTOR | ISRAEL HAIM B | 2019-04-28T00:00:00.000 | 10 GRAND ARMY PLZ | 0 | 10 | GRAND ARMY PLZ |
| 10 | 87045993 | FIRE AND EMERGENCY DRILL CONDUCTOR | LOPEZ DANIEL | 2019-08-12T00:00:00.000 | 10 GRAND ARMY PLZ | 0 | 10 | GRAND ARMY PLZ |
expires_on | datetime | Certificate Expiration Date | 0% | 2019-09-01T00:00:00.0002018-09-01T00:00:00.0002020-06-30T00:00:00.000 |
prem_addr | text | Premises Address | 0% | 1 E 161 ST30 ROCKEFELLER PLZ125 WORTH ST |
bin | integer | Building Identification Number | 0% | 211449010762621809824 |
communitydistrict | integer | Building Community Board | 5% | 105108101 |
citycouncildistrict | integer | Buidling Council District | 5% | 431 |
bbl | integer | Building Block Lot | 5% | 202493000110213800401014800001 |
cent_latitude | float | Latitude of Building Centroid | 5% | 40.82962440.7591440.840906 |
cent_longitude | float | Longitude of Building Centroid | 5% | -73.926484-73.979667-73.941633 |
zipcode | integer | Building ZIP Code | 5% | 100191003610065 |
borough | categorical | Building Borough | 0% | MNBKQNof 5 |
number | text | — | 0% | 1130030 |
street | text | — | 0% | BROADWAY5 AVEE 161 ST |
census_tract | integer | — | 1% | 11663104 |
nta | text | — | 1% | Midtown-Midtown SouthLenox Hill-Roosevelt Isl…Hudson Yards-Chelsea-Fla… |