crash_reports
2 rows where "datetime" is on date 2019-01-07 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-07
Time:
08:21
Address:
PEARL ST & WASHBURN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 STATED HE WAS TRAVELING NORTHBOUND ON PEARL ST AND AS HE APPROACHED WASHBURN STREET, MV 2 ENTERED THE INTERSECTION ATTEMPTING TO CROSS PEARL ST AND CONTINUE STRAIGHT ON WASHBURN STREET. MV 1 AND MV 2 COLLIDED WHICH RESULTED IN MV 2 STRIKING MV 3 WHICH WAS ALSO STOPPED AT THE OTHER STOP SIGN AT WASHBURN AND PEARL ST. MV 1 SUSTAINED FRONT END DAMAGE AND NO INJURIES REPORTED. MV 2 SUSTAINED MODERATE SIDE DAMAGE AND BOTH OCCUPANTS OF THE VEHICLE SIGNED PATIENT REFUSALS FROM MEDICS. MV 3 SUSTAINED FRONT END DAMAGE AND NO INJURIES REPORTED. OPERATOR OF MV 2 WAS ISSUED MA UNIFORM CITATION T1441116 FOR CH. 89 S. 9 FTC STOP SIGN.
Keywords:
Citation, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.359719
Longitude:
-71.1957
Location:
Case
number:
Date:
2019-01-07
Time:
14:28
Address:
BULLOUGH PK & MILL ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Michelle Lee was operating vehicle #2 N/B on Bullough Pk at Mill St. Lee states that she stopped at the stop sign and then attempted to take a left turn onto Mill St. At that time Lee states that vehicle #1 struck her on the left side. Luis Aguilar was operating vehicle #1 E/B on Mill St. Aguilar states that vehicle #2 pulled out in front of him as he was driving straight. A check with the RMV revealed that Aguilars license is supnded. Aguilar was issued citation # T1272109 Ch. 90 Sec 23 Operating after suspension. No injures both vehicles towed.
Keywords:
Citation
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3423383
Longitude:
-71.203341
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);