Parking Violations Issued - Fiscal Year 2019
City of New York
@usgov.city_of_new_york_parking_violations_issued_fiscal_year_2019
City of New York
@usgov.city_of_new_york_parking_violations_issued_fiscal_year_2019
CREATE TABLE table_1 (
"summons_number" BIGINT,
"plate_id" VARCHAR,
"registration_state" VARCHAR,
"plate_type" VARCHAR,
"issue_date" TIMESTAMP,
"violation_code" BIGINT,
"vehicle_body_type" VARCHAR,
"vehicle_make" VARCHAR,
"issuing_agency" VARCHAR,
"street_code1" BIGINT,
"street_code2" BIGINT,
"street_code3" BIGINT,
"vehicle_expiration_date" BIGINT,
"violation_location" DOUBLE,
"violation_precinct" BIGINT,
"issuer_precinct" BIGINT,
"issuer_code" BIGINT,
"issuer_command" VARCHAR,
"issuer_squad" VARCHAR,
"violation_time" VARCHAR,
"time_first_observed" VARCHAR,
"violation_county" VARCHAR,
"violation_in_front_of_or_opposite" VARCHAR,
"house_number" VARCHAR,
"street_name" VARCHAR,
"intersecting_street" VARCHAR,
"date_first_observed" DOUBLE,
"law_section" DOUBLE,
"sub_division" VARCHAR,
"violation_legal_code" VARCHAR,
"days_parking_in_effect" VARCHAR,
"from_hours_in_effect" VARCHAR,
"to_hours_in_effect" VARCHAR,
"vehicle_color" VARCHAR,
"unregistered_vehicle" DOUBLE,
"vehicle_year" DOUBLE,
"meter_number" VARCHAR,
"feet_from_curb" DOUBLE,
"violation_post_code" VARCHAR,
"violation_description" VARCHAR,
"no_standing_or_stopping_violation" VARCHAR,
"hydrant_violation" VARCHAR,
"double_parking_violation" VARCHAR
);
Anyone who has the link will be able to view this.