About this Dataset

Open Parking And Camera Violations

The Open Parking and Camera Violations dataset was initially loaded with all violations contained in the mainframe database as of May 2016. Subsequent new violation issuance and updates to existing violations are applied to this data set on the following schedule:

New or open violations will be updated weekly (Sunday). Violations satisfied by having been paid, dismissed via hearing, statutorily expired, or had other changes to its status, will be updated daily (Tuesday through Sunday). Violations that have been written-off because they have statutorily expired and are no longer valid are indicated with blank financials. Summons images will not be available during scheduled downtime on Sundays from 5:00 am to 10:00 am.

Initial dataset loaded 05/14/2016.
Organization: City of New York
Last updated: 2020-11-10T17:04:22.959322
Tags: dof, parking, summons, violation

Tables

Table 1

@usgov.city_of_new_york_open_parking_and_camera_violations.table_1

55.39 MB
1,314,222 rows
19 columns

CREATE TABLE table_1 (
  "plate" VARCHAR,
  "state" VARCHAR,
  "license_type" VARCHAR,
  "summons_number" DOUBLE,
  "issue_date" VARCHAR,
  "violation_time" VARCHAR,
  "violation" VARCHAR,
  "judgment_entry_date" VARCHAR,
  "fine_amount" DOUBLE,
  "penalty_amount" DOUBLE,
  "interest_amount" DOUBLE,
  "reduction_amount" DOUBLE,
  "payment_amount" DOUBLE,
  "amount_due" DOUBLE,
  "precinct" DOUBLE,
  "county" VARCHAR,
  "issuing_agency" VARCHAR,
  "violation_status" VARCHAR,
  "summons_image" VARCHAR
);