crash_reports
2 rows where dcc = "["Inattention"]", intersection = 0 and "retrieved" is on date 2022-04-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-03-17
Time:
18:12
Address:
45 WESTBOURNE RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 said her vehicle was parked in front of 45 Westbourne Rd since approximately 08:00hrs and she had not moved it. Operator of MV1 said when she attempted to leave at approximately 18:12hrs she observed that there was damage done to her driver side door and driver side quarter panel. Operator of MV1 observed a note on her windshield with a phone number to call regarding the accident. Operator of MV1 said after attempting to call the phone number numerous times she called the Newton Police to assist. I was able to contact the Operator of the second vehicle and speak to him regarding the accident. Operator of MV2 said he was backing out of the driveway of 40 Westbourne rd when he bumped into MV1. Operator of MV2 said he did not know who owned MV1 and left his phone number to speak with the owner of MV1. There was a small amount of damage done to the driver side door along with the driver side quarter panel of MV1 and no damage to MV2. There were no injuries and MV1 was able to drive away from the scene.
Keywords:
Crash, Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3372258
Longitude:
-71.1877623
Location:
Case
number:
Date:
2022-03-21
Time:
15:28
Address:
437 CHERRY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 said she was traveling Southbound on Cherry Street and was slowly merging into the left turn lane. Operator of MV1 said MV2 exited the parking lot next to 437 Cherry Street and was attempting to turn Southbound onto Cherry Street and struck MV1. Operator of MV1 said MV2 left prior to my arrival and that they loosely exchanged information. There was minimal damage to the front passenger bumper of MV1. I attempted to contact the owner of MV2 numerous times yielding negative results. There were no injuries and both vehicles were able to drive away from the scene.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.349509
Longitude:
-71.2287428
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);