crash_reports
2 rows where date = "2019-05-10"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-10
Time:
15:06
Address:
ALBEMARLE RD & CRAFTS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
VEHICLE #1 WAS TRAVELING STRAIGHT AHEAD ON CRAFTS ST HEADING EASTBOUND. VEHICLE #2 WAS AT THE STOP SIGN ON ALBERMARLE RD AT THE INTERSECTION OF CRAFT ST, FACING SOUTHBOUND. VEHICLE #2 OPERATOR STATED SHE LOOKED BOTH WAYS BEFORE ENTERING THE INTERSECTION. SHE STATES AS SHE ENTERED THE INTERSECTION HER VIEW WAS OBSTRUCTED, DUE HEAVY TRAFFIC DUE TO THE FACT THAT SCHOOL WAS GETTING OUT. AS VEHICLE #2 OPERATOR ENTERED THE INTERSECTION. SHE STRUCK VEHICLE #1 AS IT WAS PASSING BY. NO INJURIES REPORTED. BOTH VEHICLES WERE TOWED BY TODYS TOWING OF NEWTON.
Keywords:
School
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3598454
Longitude:
-71.2170818
Location:
Case
number:
Date:
2019-05-10
Time:
15:34
Address:
PLYMOUTH RD & WOODWARD ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 states she was driving westbound on Woodward St. MV1 stopped for a pedestrian in the crosswalk at Plymouth Rd. MV2 was traveling directly behind MV1 and did not stop in time. MV2 collided with the rear of MV1. Operator of MV2 states MV1 stopped quickly, and she was unable to stop behind her, causing the collision. Neither party was injured. Both vehicles were towed by Todys. Operator of MV2 admitted she did not have a license. She was issued MA citation T1444158, for 90/10 unlicensed operation, and city ordinance 19/71, following too closely. Woodward St is a public way in the City of Newton.
Keywords:
Citation, Crosswalk, Ped
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3213524
Longitude:
-71.2159709
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);