About this Dataset

NYPD OATH Summons Data

Incident-level summons data, each record representing one summons. This data may be used to gain insight into OATH summonses issued, basic demographic information of respondents, and geolocation data where violations were cited. Find Your Precinct and Sector tool at nyc.gov: https://www.nyc.gov/site/nypd/bureaus/patrol/find-your-precinct.page
Organization: City of New York
Last updated: 2024-07-20T21:16:11.702697
Tags: administrative, citation, enforcement, infraction, nyc-law, nypd, oath, summons, ticket, tickets, violation

Tables

Table 1

@usgov.city_of_new_york_nypd_oath_summons_data.table_1

3.76 MB
170398 rows
17 columns


CREATE TABLE table_1 (
  "evnt_key" BIGINT,
  "occur_date" TIMESTAMP,
  "tour" VARCHAR,
  "law_code" VARCHAR,
  "law_desc" VARCHAR,
  "law_type" VARCHAR,
  "age_group" VARCHAR,
  "sex" VARCHAR,
  "race" VARCHAR,
  "precinct" VARCHAR,
  "jurisdition_code" VARCHAR,
  "city_nm" VARCHAR,
  "x_coord_cd" VARCHAR,
  "y_coord_cd" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location_point" VARCHAR
);