crash_reports
2 rows where "date" is on date 2022-03-17, 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-17
Time:
21:23
Address:
305 WATERTOWN STREET
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 states she was traveling straight ahead, eastbound on Watertown Street when MV2 attempted to make an illegal U-turn. Operator of MV1 states she then struck the front left of MV2. Operator of MV2 states he made an illegal U-turn on Watertown Street when MV1 struck the front left of his vehicle. MV1 sustained damage to the front right of the vehicle and MV2 sustained damage to the front left of the vehicle. MV1 and MV2 were both towed by Tody's Service Inc. Operator of MV1 had no injuries. Operator of MV2 was checked by medics on scene but denied medical attention. Operator of MV2 was mailed a citation for his illegal U-turn.
Keywords:
Citation
Dcc:
Improper turn
Report
url:
Image
url:
Latitude:
42.3612403
Longitude:
-71.198944
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);