crash_reports
3 rows where "datetime" is on date 2019-04-12 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: address, street1, intersection, dcc, dcc_code, geocoded_address, latitude, longitude, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-12
Time:
14:59
Address:
680 WALNUT ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
OPERATOR OF MV 1 STATED HE WAS TRAVELING NORTHBOUND ON WALNUT ST AND WASN'T PAYING ATTENTION. HE STRUCK MV 2 FROM BEHIND WHO WAS STOPPED IN TRAFFIC IN FRONT OF HIM. DUE TO THE IMPACT OF THE CRASH, MV 2 REAR ENDED MV 3. THERE WERE NO INJURIES REPORTED (5 PATIENT REFUSALS SIGNED) AND MODERATE DAMAGE SUSTAINED TO ALL THREE VEHICLES, FRONT END DAMAGE TO M/V 2. MV'S 1 AND 2 WERE TOWED FROM THE SCENE BY TODYS TOWING TO THEIR LOT IN WEST NEWTON SQUARE AFTER ALL VALUABLES WERE SECURED FROM THE VEHICLES. OPERATOR OF MV 1 WAS CITED MASS UNIFORM CITATION T1268379 FOR C.O. 19/75 FAILURE TO USE CARE.
Keywords:
Citation, Crash, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3381455
Longitude:
-71.2066056
Location:
Case
number:
Date:
2019-04-12
Time:
20:32
Address:
WASHINGTON ST & CENTRE ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV1 stated he was attempting to "turn left" when the car to his left "went straight instead of left" subsequently striking his vehicle. MV1 was spun sideways and MV2 continued into Watertown. I then made contact with the operator of MV2 who admitted to striking MV1, however thought they weren't going to stop so he kept going as well. MV2 was cited for Leaving the Scene of Property Damage & Marked Lanes See incident report 19014042 for further information.
Keywords:
Citation
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Case
number:
Date:
2019-04-12
Time:
22:26
Address:
WASHINGTON ST & CENTRE ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On Friday 4/12/2019 at approx 2226hrs, while assigned N-494, I responded to the intersection of Washington St and Centre St (public way)for a 2 vehicle MVA. Upon arrival all parties stated they were uninjured. Operator of MV1 stated that he was in the Left Turn Only lane onto Washington St. He immediately stopped when he noticed a car to his left collide with his trailer. Operator of MV2 states that he was also in the Left Turn Only lane onto Washington St. and that MV1 came over from Left Turn/Straight lane on his right. Given that both operators stated that their vehicles had not been moved from where the collision occurred it is evident that MV2 was in the Left Turn Only lane onto I-90 and attempted to change lanes. It should be noted that the crash diagram is accurate to what I observed on scene. Operator of MV2 was cited for marked lanes MGL c89s 4C citation #T1268551 No damage visible to MV1. MV2 had passenger side paint damage.
Keywords:
Citation, Crash
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
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);