crash_reports
2 rows where "datetime" is on date 2019-11-01, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-11-01
Time:
13:52
Address:
350 BOYLSTON ST (LOT)
Speed
limit:
5
Violation
cited:
no
Narrative:
OPER OF MV1 STATED THAT HE WAS TURNING IN A CIRCLE IN THE DRIVEWAY, WHEN MV2 PULLED OUT FROM THE GARAGE, AND TRIED TO SQUEEZE BY. THE VEHICLES COLLIDED CAUSING MODERATE DAMAGE TO THE FRONT PASS OF MV1 AND MODERATED DAMAGE TO THE DRIVER SIDE DOOR AREA OF MV2. OPER OF MV2 STATED THAT SHE WAS PULLING OUT OF THE GARAGE, WHEN MV1 DIDNT SEE HER AND STRUCK THE DRIVER SIDE DOOR.
Keywords:
Moderate
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3191216
Longitude:
-71.1828395
Location:
Case
number:
Date:
2019-11-01
Time:
15:39
Address:
7 SPAULDING LA
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle #1 was parked facing south in front of 7 Spaulidng La. Vehicle #1 had a trailer with an excavator attached to it. Vehicle #1 was unoccupied but had one occupant in the excavator on the trailer. The operator/owner of vehicle #1 was moving the excavator off the trailer when the trailer and truck started to roll southbound down the hill on Spaulding La. The operator of vehicle #1 jumped out of the excavator onto the roadway. Vehicle #1 along with its trailer rolled down and veered off the road and over the curb. The rear driver side end of the of vehicle #1 collided with the rear end of vehicle #2 bringing the trailer and truck to a stop. The rear end of vehicle #2 had moderate damage. The rear end of vehicle #1 had minor damage. Vehicle #2 was parked facing southbound just south of the driveway of 7 Spaulding La. Vehicle #2 was parked on the side of the road on Spaulding La. and was crashed into by the unoccupied truck and trailer vehicle #1. The occupant of vehicle #2 was not injured. The occupant of vehicle #1 was transported to Beth Israel Boston by Newton Amb. 1. There were no tows needed. Reference incident report #19046951 for further details on this crash.
Keywords:
Crash, Moderate
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3022687
Longitude:
-71.176484
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);