About this Dataset

NYPD B Summons (Historic)

Moving violation summonses issued by the NYPD. This dataset documents the issuance of moving violations (B summonses) by the NYPD. The data is collected from members of service upon completion of the New York State form. Each record represents a summons (vioaltion). The data can be used for analyzing traffic enforcement activity by the NYPD.
Organization: City of New York
Last updated: 2021-08-07T16:46:14.125480
Tags: b-summons, driver, moving-violation, nypd, traffic, traffic-ticket, transportation, vision-zero, vz

Tables

Table 1

@usgov.city_of_new_york_nypd_b_summons_historic.table_1

106.77 MB
4,994,560 rows
14 columns

CREATE TABLE table_1 (
  "evnt_key" BIGINT,
  "violation_date" TIMESTAMP,
  "violation_time" VARCHAR,
  "chg_law_cd" VARCHAR,
  "violation_code" VARCHAR,
  "veh_category" VARCHAR,
  "city_nm" VARCHAR,
  "rpt_owning_cmd" BIGINT,
  "x_coord_cd" DOUBLE,
  "y_coord_cd" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR,
  "juris_cd" DOUBLE
);