crash_reports
2 rows where dcc contains "Lane departure" and "retrieved" is on date 2021-10-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-09
Time:
07:58
Address:
232 CALIFORNIA
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 while proceeding East bound on California Street struck parked MV2. MV1 continued straight and struck parked MV3. Owner of MV2 and MV3 were notified and completed an exchange of information with owner of MV1 Driver MV1 transported via Medic #3 to Newton-Wellesley Hospital for evaluation. MV1 towed to Tody's and a towed motor vehicle form was completed and filed.
Keywords:
Hospital
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3646105
Longitude:
-71.1977411
Location:
Case
number:
Date:
2021-10-13
Time:
09:10
Address:
320 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 stated he was travelling westbound on Washington St passing the Sheraton Four Points Hotel, 320 Washington St, when he was hit by another vehicle. Operator #1 stated the operator of a white sedan ( Operator #2) was attempting to change lanes behind him and hit the rear driver side of his vehicle. Operator #2 fled the area without stopping. Vehicle #1 had minor damage to the rear of his vehicle. He stated Vehicle #2 would have damage to the front of their vehicle but unsure what side. He stated Vehicle #2 was a white sedan with a black male driver and a person in the back seat, possibly a rideshare service. Operator #1 was able to drive his vehicle away from the scene.
Keywords:
[]
Dcc:
Lane departure, Inattention
Report
url:
Image
url:
Latitude:
42.3563932
Longitude:
-71.1872752
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);