crash_reports
2 rows where "datetime" is on date 2019-10-09, intersection = 0 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-09
Time:
17:17
Address:
169 EAST SIDE PKWY
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV 1 was traveling southbound on East side pkwy when she struck the curb on the right side of the street. At this time she swerved completely across the double yellow lines and struck MV 2 head on. MV 2 was traveling northbound and observed MV 1 cross into his lane and strike him head on. Both operators were evaluated by Cataldo ambulance who cleared with patient refusals. Both vehicles were removed from the scene by Tody's towing. Operator of MV 1 was cited for a marked lanes violation.
Keywords:
Citation, Ems
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.349089
Longitude:
-71.1969107
Location:
Case
number:
Date:
2019-10-09
Time:
20:09
Address:
180 NEEDHAM ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV1 states that she was traveling northbound on Needham Street with flow of traffic when she struck a pedestrian with the right front corner of her vehicle. The operator of MV1 stated that she did not see the pedestrian in the cross walk until after she hit her and that there was poor lighting in the area. Through the help of coworker from Anthony's Coal Fired Pizza, the victim stated that she was crossing Needham Street in the crosswalk and was almost on the side walk when she was struck by MV1 from behind. MV1 sustained minor front end damage while the victim sustained noticeable injuries and was transported to Newton Wellesley Hospital by Cataldo. Photographs of the scene were taken and submitted to IT to be attached to the report. The operator of MV1 was issued a Massachusetts Uniform Citation (T2079284) for 89-11, failure to yield to a pedestrian in a crosswalk.
Keywords:
Citation, Crosswalk, Fire, Hospital, Ped, Pictures, Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3116053
Longitude:
-71.2130334
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);