From a 500-row sample across 24 columns.
:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+20:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+6:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+9Mappable — Socrata point column `lon_lat`.
Open on the map →| arrest_key | arrest_date | pd_cd | pd_desc | ky_cd | ofns_desc | law_code | law_cat_cd | arrest_boro | arrest_precinct | jurisdiction_code | age_group |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 318178742 | 2025-12-31T00:00:00.000 | 922 | TRAFFIC,UNCLASSIFIED MISDEMEAN | 348 | VEHICLE AND TRAFFIC LAWS | VTL0511001 | M | Q | 105 | 0 | (null) |
| 318194574 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
arrest_key | text | Randomly generated persistent ID for each arrest | 0% | 100034391000344010003441 |
arrest_date | datetime | Exact date of arrest for the reported event | 0% | 2010-01-20T00:00:00.0002009-05-13T00:00:00.0002012-03-07T00:00:00.000 |
pd_cd | integer | Three digit internal classification code (more granular than Key Code) | 0% | 101567478 |
pd_desc | text | Description of internal classification corresponding with PD code (more granular than Offense Description) | 0% | ASSAULT 3 |
GET /api/datasets/8h9b-rp9u GET /api/datasets/8h9b-rp9u/quality GET /api/datasets/8h9b-rp9u/related GET /api/columns?dataset=8h9b-rp9u
:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+6:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+12:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+12:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+4jurisdiction_codelatitudex_coord_cd+2| 2025-12-31T00:00:00.000 |
| 339 |
| LARCENY,PETIT FROM OPEN AREAS, |
| 341 |
| PETIT LARCENY |
| PL 1552500 |
| M |
| M |
| 18 |
| 0 |
| (null) |
| 318200238 | 2025-12-31T00:00:00.000 | 339 | LARCENY,PETIT FROM OPEN AREAS, | 341 | PETIT LARCENY | PL 1552500 | M | M | 28 | 0 | (null) |
| 318200226 | 2025-12-31T00:00:00.000 | 109 | ASSAULT 2,1,UNCLASSIFIED | 106 | FELONY ASSAULT | PL 1200502 | F | K | 63 | 0 | 18-24 |
| 318208177 | 2025-12-31T00:00:00.000 | 419 | LARCENY,GRAND FROM PERSON,UNCL | 109 | GRAND LARCENY | PL 1553005 | F | M | 14 | 0 | 25-44 |
| 318207869 | 2025-12-31T00:00:00.000 | 419 | LARCENY,GRAND FROM PERSON,UNCL | 109 | GRAND LARCENY | PL 1553005 | F | M | 14 | 0 | 45-64 |
| 318192912 | 2025-12-31T00:00:00.000 | 579 | CANNABIS POSSESSION, 2&1 | 250 | CANNABIS RELATED OFFENSES | PL 2224001 | F | Q | 113 | 3 | 18-24 |
| 318191330 | 2025-12-31T00:00:00.000 | 779 | PUBLIC ADMINISTRATION,UNCLASSI | 126 | MISCELLANEOUS PENAL LAW | PL 215510B | F | Q | 115 | 0 | 18-24 |
| 318209017 | 2025-12-31T00:00:00.000 | 681 | CHILD, ENDANGERING WELFARE | 233 | SEX CRIMES | PL 2601001 | M | Q | 114 | 2 | 25-44 |
| 318172859 | 2025-12-31T00:00:00.000 | 101 | ASSAULT 3 | 344 | ASSAULT 3 & RELATED OFFENSES | PL 1200001 | M | K | 90 | 0 | 18-24 |
Showing 12 of 24 columns. All of them are listed below.
MARIJUANA, POSSESSION 4 …THEFT OF SERVICES, UNCLA…ky_cd | integer | Three digit internal classification code (more general category than PD code) | 0% | 235344343 |
ofns_desc | text | Description of internal classification corresponding with KY code (more general category than PD description) | 0% | DANGEROUS DRUGSASSAULT 3 & RELATED OFFE…PETIT LARCENY |
law_code | text | Law code charges corresponding to the NYS Penal Law, VTL and other various local laws | 0% | PL 1200001PL 2211001PL 1552500 |
law_cat_cd | categorical | Level of offense: felony, misdemeanor, violation | 0% | MFVof 6 |
arrest_boro | categorical | Borough of arrest. B(Bronx), S(Staten Island), K(Brooklyn), M(Manhattan), Q(Queens) | 0% | KMBof 5 |
arrest_precinct | integer | Precinct where the arrest occurred | 0% | 147544 |
jurisdiction_code | integer | Jurisdiction responsible for arrest. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD whilst codes 3 and more represent non NYPD jurisdictions | 0% | 012 |
age_group | text | Perpetrator’s age within a category | 0% | 25-4418-2445-64 |
perp_sex | categorical | Perpetrator’s sex description | 0% | MF(null)of 4 |
perp_race | categorical | Perpetrator’s race description | 0% | BLACKWHITE HISPANICWHITEof 8 |
x_coord_cd | coordinate | Midblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 987220.01017119.0962822.0 |
y_coord_cd | coordinate | Midblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 212676.0183909.0174282.0 |
latitude | float | Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | 40.7504307680000540.6714116630000740.645022746000045 |
longitude | float | Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | -73.98928217599996-73.88151172399995-74.077216847 |
lon_lat | coordinate | Georeferenced Point Column based on Longitude and Latitude fields | 0% | {'coordinates': [-73.989…{'coordinates': [-73.881…{'coordinates': [-74.077… |