From a 500-row sample across 21 columns.
age_group:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+6age_group:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+6:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q:@computed_region_92fq_4b7q+1Mappable — Socrata point column `location_point`.
Open on the map →| evnt_key | occur_date | tour | law_code | law_desc | law_type | age_group | sex | race | precinct | jurisdition_code | city_nm |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 262969657 | 2023-02-03T00:00:00.000 | 2300-0659 | 16-118(6) | PUBLIC URINATION | ADMINCODE | 25-44 | M | BLACK | 032 | 00 | MANHATTAN |
| 311828405 | 2025-08-24T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
evnt_key | text | Unique Identifier; 13 character numeric string | 0% | 261181279261181444261181447 |
occur_date | datetime | Occurrence Date | 0% | 2026-06-28T00:00:00.0002025-05-24T00:00:00.0002025-08-10T00:00:00.000 |
tour | categorical | Time block associated with duty platoon | 0% | 1500-22592300-06590700-1459of 3 |
law_code | text | Numerical Law Code | 0% | 10-12516-118(6) |
GET /api/datasets/hxbk-grd3 GET /api/datasets/hxbk-grd3/quality GET /api/datasets/hxbk-grd3/related GET /api/columns?dataset=hxbk-grd3
:@computed_region_f5dn_yrer:@computed_region_yeji_bk3qy_coord_cd+7:@computed_region_f5dn_yrer:@computed_region_yeji_bk3qlatitude+3age_group:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+7age_group:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+7latitudelongitude| 0700-1459 |
| 16-118(6) |
| PUBLIC URINATION |
| ADMINCODE |
| 45-64 |
| M |
| WHITE HISPANIC |
| 110 |
| 00 |
| QUEENS |
| 267154704 | 2023-04-22T00:00:00.000 | 1500-2259 | 16-118(6) | PUBLIC URINATION | ADMINCODE | 45-64 | M | WHITE HISPANIC | 025 | 00 | MANHATTAN |
| 273161847 | 2023-08-20T00:00:00.000 | 2300-0659 | 16-118(1)(b) | SPITTING | ADMINCODE | 18-24 | M | WHITE | 006 | 00 | MANHATTAN |
| 262784412 | 2023-01-31T00:00:00.000 | 1500-2259 | 20-453 | UNLICENSED GENERAL VENDOR | ADMINCODE | 25-44 | M | BLACK | 108 | 00 | QUEENS |
| 264444330 | 2023-03-02T00:00:00.000 | 1500-2259 | 16-118(6) | PUBLIC URINATION | ADMINCODE | 45-64 | M | BLACK | 014 | 00 | MANHATTAN |
| 267923052 | 2023-05-08T00:00:00.000 | 1500-2259 | 16-118(1) | LITTERING | ADMINCODE | 25-44 | M | UNKNOWN | 079 | 00 | BROOKLYN |
| 273531193 | 2023-08-27T00:00:00.000 | 2300-0659 | 16-118(6) | PUBLIC URINATION | ADMINCODE | 25-44 | M | WHITE | 025 | 00 | MANHATTAN |
| 265874494 | 2023-03-29T00:00:00.000 | 1500-2259 | 16-118(1)(a) | LITTERING | ADMINCODE | 25-44 | M | BLACK | 081 | 00 | BROOKLYN |
| 269207352 | 2023-05-30T00:00:00.000 | 2300-0659 | 16-118(6) | PUBLIC URINATION | ADMINCODE | 25-44 | M | BLACK | 023 | 00 | MANHATTAN |
Showing 12 of 21 columns. All of them are listed below.
19-176(b)law_desc | text | Plain language offense description | 0% | UNLAWFUL CONSUMPTION/POS…PUBLIC URINATIONUNLAWFUL BICYCLE RIDING … |
law_type | categorical | Numerical Law Code | 0% | ADMINCODE56RCNYOTHERof 6 |
age_group | categorical | Ages grouped into blocks | 0% | 25-4445-6418-24of 6 |
sex | categorical | Sex of summons recipient | 0% | MF(null)of 4 |
race | categorical | Race of summons recipient | 0% | WHITE HISPANICBLACKWHITEof 9 |
precinct | text | Precinct of occurrence | 0% | 115014018 |
jurisdition_code | categorical | Coded jurisdiction number for patrol, transit and housing | 0% | 00(null)of 2 |
city_nm | categorical | City (borough) name of occurrence | 0% | BROOKLYNMANHATTANQUEENSof 7 |
x_coord_cd | text | X coordinate | 0% | 9857641018623988451 |
y_coord_cd | text | Y Coordinate | 0% | 213806214936217993 |
latitude | float | Latitude | 0% | 40.753532701263240.756567584637440.7650240788333 |
longitude | float | Longitude | 0% | -73.9945368920152-73.8759315341335-73.9848359497083 |
location_point | coordinate | — | 0% | {'coordinates': [-73.994…{'coordinates': [-73.875…{'coordinates': [-73.984… |