以下为卖家选择提供的数据验证报告:
数据描述
Context
- This is an analysis of the parking violations committed in New York City during between the fiscal years of 2017-2020.
- The information contained in this dataset includes summons numbers, license plate ID/Type, vehicle information, violation codes and their respective descriptions.
Acknowledgment
We wouldn't be here without the help of others. The data is pulled from the NYC Open Data site.
Content
- Plate ID: REGISTERED PLATE ID
- Summons Number: UNIQUE IDENTIFIER OF SUMMONS
- Registration State: STATE OF PLATE REGISTRATION
- Plate Type: TYPE OF PLATE
- Issue Date: ISSUE DATE
- Violation Code: TYPE OF VIOLATION
- Vehicle Body Type: VEHICLE BODY TYPE WRITTEN ON SUMMONS (SEDAN, ETC.)
- Vehicle Make: MAKE OF CAR WRITTEN ON SUMMONS
- Issuing Agency: ISSUING AGENCY CODE
- Street Code1: GEOGRAPHICAL STREET CODE
- Street Code2: GEOGRAPHICAL STREET CODE
- Street Code3: GEOGRAPHICAL STREET CODE
- Vehicle Expiration Date: VEHICLE EXPIRATION DATE ON SUMMONS
- Violation Location: GENERAL VIOLATION LOCATION
- Violation Precinct: PRECINCT OF VIOLATION
- Issuer Precinct: PRECINCT OF ISSUANCE
- Issuer Code: UNIQUE CODE IDENTIFYING ISSUING OFFICER
- Issuer Command: COMMAND OF ISSUING OFFICER
- Issuer Squad: ISSUING OFFICER'S SQUAD
- Violation Time: TIME VIOLATION OCCURRED
- Time First Observed: TIME OF INITIAL VIOLATION OBSERVATION
- Violation County: COUNTY OF VIOLATION
- Violation In Front Of Or Opposite: VIOLATION IN FRONT OF OR OPPOSITE
- House Number: ADDRESS NUMBER OF VIOLATION
- Street Name: STREET NAME OF SUMMONS ISSUED
- Intersecting Street: VIOLATION NEAR INTERSECTING STREET
- Date First Observed: DATE OF INITIAL VIOLATION OBSERVATION
- Law Section: SECTION OF VEHICLE & TRAFFIC LAW
- Sub Division: SUB DIVISION ON SUMMONS IMAGE
- Violation Legal Code: TYPE OF LEGAL CODE
- Days Parking In Effect: DAYS PARKING IN EFFECT
- From Hours In Effect: START TIME POSTED FOR METER AND SIGN VIOLATIONS
- To Hours In Effect: END TIME POSTED FOR METER AND SIGN VIOLATIONS
- Vehicle Color: CAR COLOR WRITTEN ON SUMMONS
- Unregistered Vehicle?: UNREGISTERED VEHICLE INDICATOR
- Vehicle Year: YEAR OF VEHICLE WRITTEN ON SUMMONS
- Meter Number: PARKING METER NUMBER FOR METER VIOLATIONS
- Feet From Curb: NUMBER OF FEET FROM CURB FOR HYDRANT VIOLATION
- Violation Post Code: NUMBER OF FEET FROM CURB FOR HYDRANT VIOLATION
- Violation Description: DESCRIPTION OF VIOLATION
- No Standing or Stopping Violation: SUMMONS INDICTOR FOR NO STANDING OR STOPPING
- Hydrant Violation: SUMMONS INDICTOR FOR NO STANDING OR STOPPING
- Double Park: SUMMONS INDICATOR FOR DOUBLE PARKING VIOLATION
Inspiration
I'm a huge fan of visiting Manhattan...and of course its surrounding areas. Making the journey into New York is pretty simple given that I am only a forty minute train ride from Penn. However, I often wonder whether driving into the city is a better option (Usually isn't). Before even opening the car door, I always ask myself one question, "am I getting a ticket?" What factors increase the chance of finding a ticket on my windshield. Being curious about the violations we all might face parking anywhere within New York's 5 boroughs, I decided to use this dataset to answer the following questions:
- Who gets the most tickets? What are the most common car types and make years that receive the most tickets. (Is there a correlation between vehicle color and # of violations). Any Repeat offenders? Who is offensive vehicle owner of 2020 (Based on # offenses). Any Repeat offenders? Most offensive vehicle owner of 2020 (Based on # offenses).
- Where are most tickets issued. (Which borough's receive the most tickets.)
- When are most tickets issued.
