crash_reports
2 rows where dcc = "["Glare", "Unknown"]", intersection = 0 and keywords contains "Glare"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-12
Time:
18:50
Address:
865 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle #1 stated they were attempting to turn around on beacon St. and turned into the driveway at 865 Beacon St. Vehicle #1 stated they were reversing out into the road and was stopped and shifting into drive when they were struck from the rear by Vehicle #2. Vehicle #2 stated she was traveling westbound on Beacon St. when she lost sight in front of her due to the glare from the sun. Vehicle #2 stated she never saw Vehicle #1 until she struck the vehicle. Vehicle #1 had minor damage to the rear and was able to be driven away. Vehicle #2 had moderate damage to the front and was towed by Tody's Towing. Operator of Vehicle #1 stated she was not hurt in the crash and refused any medical treatment. Operator of Vehicle #2 stated she had chest pain and was evaluated by Medic 1. Operator of Vehicle #2 was cleared by the medics and refused any further treatment.
Keywords:
Crash, Glare, Moderate, Solar
Dcc:
Glare, Unknown
Report
url:
Image
url:
Latitude:
42.3304808
Longitude:
-71.1966736
Location:
Case
number:
Date:
2022-01-23
Time:
14:58
Address:
325 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On January 23, 2022 at approximately 1458 hours, I responded to the area of 325 Beacon St for a report of a 4 vehicle MVA with possible injury. Upon arrival with the Fire Department and EMS, I met with all the drivers. No injuries were reported on scene. MV1 operator states she was driving WB on Beacon St when MV2 came to a sudden stop and due to the sun's glare, did not see MV2 very well. MV1 operator then rear-ended MV2. I did not observe any damage to the front of MV1 or the rear of MV2. MV2 operator states she was driving WB on Beacon St when MV1 suddenly collided with her rear end. MV2 subsequently rear-ended MV3. I did observe damage to the front of MV2 and to the rear of MV3. MV3 operator states he was stopped, waiting for the cars to go since the light had just turned green, when he was suddenly rear-ended by MV2. MV3 subsequently rear-ended MV4. I did observe damage to the front of MV3 and the rear of MV4. MV4 operator states she was stopped in traffic when she was suddenly rear-ended by MV3. No vehicles were towed. No citations were issued.
Keywords:
Citation, Ems, Fire, Glare, Solar
Dcc:
Glare, Unknown
Report
url:
Image
url:
Latitude:
42.3333408
Longitude:
-71.1719303
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);