From a 500-row sample across 21 columns.
boroughpostcodelatitude+11boroughpostcodelatitude+11boroughpostcodelatitude+9Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| year | quarter | location | borough | center | nypd_called_on_scene | employee_witnessed_an_nypd | employee_witnessed_nypd | employee_witnessed_nypd_1 | employee_witnessed_nypd_2 | employee_witnessed_nypd_3 | employee_witnessed_nypd_4 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019 | 10/1/2019-12/31/2019 | 1 HONEYWELL ST | Queens | JOB CENTER 53 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
year | categorical | Calendar year of the reported period | 0% | 202020232022of 8 |
quarter | text | Reported time period | 0% | 10/1/2019-12/31/20191/1/2020-3/31/20207/1/2020-9/30/2020 |
location | text | Address of the location | 0% | 109 E 16 ST1 HONEYWELL ST888 -890-894 Garrison Av… |
borough | categorical | Borough name of the location | 0% | ManhattanBrooklynBronx |
GET /api/datasets/ejux-uh6h GET /api/datasets/ejux-uh6h/quality GET /api/datasets/ejux-uh6h/related GET /api/columns?dataset=ejux-uh6h
boroughpostcodelatitudeboroughpostcodelatitude+11boroughbbllatitudelongitude| 2019 |
| 10/1/2019-12/31/2019 |
| 1 HONEYWELL ST |
| Queens |
| REFUGEE & IMMIGRANT JC 47 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 2019 | 10/1/2019-12/31/2019 | 1 HONEYWELL ST | Queens | SNAP CENTER 53 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2019 | 10/1/2019-12/31/2019 | 1 HONEYWELL ST | Queens | JOB CENTER 53 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2019 | 10/1/2019-12/31/2019 | 1 HONEYWELL ST | Queens | REFUGEE & IMMIGRANT JC 47 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2019 | 10/1/2019-12/31/2019 | 1 HONEYWELL ST | Queens | SNAP CENTER 53 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2019 | 10/1/2019-12/31/2019 | 109 E 16 ST | Manhattan | JOB CENTER 39 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2019 | 10/1/2019-12/31/2019 | 109 E 16 ST | Manhattan | RAR / HVN 90 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2019 | 10/1/2019-12/31/2019 | 109 E 16 ST | Manhattan | RESIDENTIAL TREATMENT CENTER 52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2019 | 10/1/2019-12/31/2019 | 109 E 16 ST | Manhattan | SPECIAL PROJECTS CENTER 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Showing 12 of 21 columns. All of them are listed below.
center | text | Benefits Access Center or SNAP Center Name | 0% | RESIDENTIAL TREATMENT CE…SPECIAL PROJECTS CENTER …REFUGEE & IMMIGRANT JC 4… |
nypd_called_on_scene | categorical | If NYPD was called by an HRA employee and did show up to the location | 0% | 012of 11 |
employee_witnessed_an_nypd | categorical | Whether an HRA employee witnessed an arrest being made | 0% | 012of 6 |
employee_witnessed_nypd | text | Whether a department employee witnessed a police officer displaying a baton | 0% | 0of 1 |
employee_witnessed_nypd_1 | categorical | Whether a department employee witnessed a police officer displaying a Conducted Electrical Device | 0% | 031of 3 |
employee_witnessed_nypd_2 | categorical | Whether a department employee witnessed a police officer displaying a firearm | 0% | 03of 2 |
employee_witnessed_nypd_3 | text | Whether a department employee witnessed a police officer displaying oleoresin capsicum spray | 0% | 0of 1 |
employee_witnessed_nypd_4 | text | Whether a department employee witnessed a police officer displaying other weapon | 0% | 0of 1 |
postcode | text | Zipcode where the site is located | 17% | 100031120111206 |
latitude | float | Latitude of the site's location | 17% | 40.73568140.84693240.592902 |
longitude | float | Longitude of the site's location | 17% | -73.988713-73.93526-74.076212 |
community_board | integer | Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Community District. | 17% | 105302111 |
council_district | categorical | The City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District. | 17% | 23315of 18 |
bin | integer | The BIN (Building Identification Number) is a unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner. | 17% | 101782150132384210062 |
bbl | integer | The BBL (Borough, Block, and Lot) is a combination of three numeric codes -- a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) - designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. | 17% | 100872001341590000081017750033 |
ct2020 | integer | The Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. Note that as part of the geocoding process, leading and trailing zeros are dropped. | 17% | 50460242 |
nta2020 | text | The Neighborhood Tabulation Area (Census 2020) are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitiv | 17% | MN0602BK0202BK1302 |