crash_reports
2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2020-12-21
Time:
15:14
Address:
13 FAXON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated while traveling south on Faxon Street and approaching his residence, 13 Faxon Street, he struck MV2 while pulling into his driveway. MV2 was unoccupied at the time of the accident. MV1 had minor scratch on the rear bumper. MV2 had minor damage to the front driver side bumper along with the front bumper. The license plate mount was also damaged on MV2. Operator of MV1 was not injured.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3643176
Longitude:
-71.1997368
Location:
Case
number:
Date:
2020-12-21
Time:
16:23
Address:
235 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was traveling southbound on Needham Street in congested traffic when MV2 struck MV1 in the rear bumper. MV1 sustained very minor damage to the rear bumper. Operator of MV2 states she was traveling southbound on Needham Street in congested traffic when MV3 struck MV2 in the rear bumper causing MV2 to collide with MV1. MV2 sustained damage to the front and rear bumper. Operator of MV3 states she was traveling southbound on Needham Street in congested traffic when she experienced mechanical failure with her brakes causing MV3 to collide with MV2, which also caused MV2 to collide with MV1. MV3 sustained damage to the front of the vehicle, which disabled the transmission. MV3 was towed by Tody's towing and a towed motor vehicle inventory form was completed. No injuries reported by all three operators.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3099663
Longitude:
-71.2150428
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);