From a 500-row sample across 21 columns.
bblntabin+10boroughbblntabin+7Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| date_received | borough | block | lot | class | community_board | violation | osm | issue | address | resoultion | date_closed |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-01-11T00:00:00.000 | Brooklyn | 3930 | 9 | 1-3 Family | 5 | 104879 | 61 | Violation Inquiry | 125 Highland Place | Other | 2022-03-25T00:00:00.000 |
| 2022-01-11T00:00:00.000 | Brooklyn |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
date_received | datetime | — | 0% | 2024-11-25T00:00:00.0002011-12-12T00:00:00.0002024-11-27T00:00:00.000 |
borough | categorical | — | 0% | QueensBrooklynStaten Islandof 6 |
block | text | — | 22% | 326374223799 |
lot | text | — | 22% | 12510 |
class | text |
GET /api/datasets/bheb-sjfi GET /api/datasets/bheb-sjfi/quality GET /api/datasets/bheb-sjfi/related GET /api/columns?dataset=bheb-sjfi
boroughbblntabin+11bblntabin+6bblntabin+4| 5897 |
| 5 |
| Commerical |
| 10 |
| 102167 |
| 62 |
| Dismissal Inspection |
| 7013 Fort Hamiliton Pkwy |
| — |
| — |
| 2022-01-11T00:00:00.000 | Brooklyn | 8763 | 1 | 1-3 Family | 15 | 104502 | 63 | Violation Inquiry | 1101 Banner Avenue | Other | 2022-03-25T00:00:00.000 |
| 2022-01-11T00:00:00.000 | Brooklyn | 5352 | 22 | Commerical | 12 | 106468 | 64 | Dismissal Inspection | 524 McDonald Avenue | — | — |
| 2022-01-11T00:00:00.000 | Bronx | 4942 | 29 | 1-3 Family | 12 | 34105 | 65 | Requesting Permit | 3670 Varian Avenue | — | — |
| 2022-01-11T00:00:00.000 | Bronx | 5098 | 23 | 1-3 Family | 12 | 32054 | 66 | Dismissal Inspection | 4442 Hill Avenue | — | — |
| 2022-01-11T00:00:00.000 | Brooklyn | 7804 | 52 | 1-3 Family | 18 | 105475 | 67 | Dismissal Inspection | 1020 East 57th Street | — | — |
| 2022-01-11T00:00:00.000 | Brooklyn | 935 | 30 | 1-3 Family | 6 | 106541 | 68 | Tree Inquiry | 46 St. Marks Avenue | — | — |
| 2022-01-11T00:00:00.000 | Brooklyn | 7441 | 205 | 1-3 Family | 15 | 81330 | 69 | Violation Inquiry | 2014 Avenue Y | — | — |
| 2022-01-11T00:00:00.000 | Queens | 12178 | 4 | Commerical | 12 | 94412 | 70 | Violation Inquiry | 112-11 159th Street | — | — |
Showing 12 of 20 columns. All of them are listed below.
| — |
| 35% |
1-3 FamilyCommericalA1 |
community_board | text | — | 35% | 11123 |
violation | text | — | 46% | DismissedN/ANONE |
osm | text | — | 81% | 626365 |
ccu | text | — | 93% | 05-535305-622806-2023 |
sim | text | — | 100% | 06-25406-49606-512 |
bc | text | — | 96% | 09-171210-82909-1044 |
other_log | text | — | 26% | DOT-678396-C9P2DOT-526557-D7M8DOT-657426-C1N2 |
issue | text | — | 0% | Violation InquirySidewalk BrokenOther |
address | text | — | 1% | Citywide Concern1853 East 38th StreetCity Wide Concern |
cross_streets | text | — | 99% | 6th AvenueWilloughby Street and De…Lexington Avenue |
referred_routed_to | categorical | — | 100% | Brooklyn HIQACCUBay Parkwayof 13 |
resoultion | text | — | 29% | OtherViolation IssuedWill Inspect |
date_closed | datetime | — | 4% | 2001-01-01T00:00:00.0002024-05-29T00:00:00.0002022-03-09T00:00:00.000 |
results_of_inspection | text | — | 99% | Location was inspected.Location inspected.PIR submitted for proces… |
postcode | integer | — | 26% | 103141031211234 |
latitude | float | — | 26% | 40.61304440.59527140.71413 |
longitude | float | — | 26% | -73.9325-73.910757-73.880987 |
council_district | integer | — | 26% | 195051 |
census_tract | integer | — | 26% | 751381479 |
bin | integer | — | 27% | 300000040000001000000 |
bbl | integer | — | 27% | 308482001830715500013024160010 |
nta | text | — | 26% | Douglas Manor-Douglaston…Bayside-Bayside HillsPark Slope-Gowanus |