crash_reports
4 rows where "date" is on date 2019-06-27
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-27
Time:
10:17
Address:
99 WESTCHESTER RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of vehicle #1 who resides at 142 Cabot St. stated that due to construction being done on Cabot St. that she was unable to park her motor vehicle at 142 Cabot St. The vehicle was parked along with numerous other vehicles on Westchester RD. Vehicle #1 was parked in front of 99 Westchester Rd from approximately 2000 Hrs on 06/26/2019 until approximately 1000 hrs on 06/27/2019. Vehicle #1 was struck by an unknown vehicle during those hours. At vehicle owner one's request I spoke with detail Officer Stake who was on Westchester Rd. in the morning of the 06/27. Officer Stake stated he did not hear or see Vehicle #1 being struck by a vehicle while he was on scene.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3466153
Longitude:
-71.1947707
Location:
Case
number:
Date:
2019-06-27
Time:
11:19
Address:
BEACON ST & LAKE AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 operator states she was driving Eastbound on Beacon St when MV2 operator exited Lake Ave intersection and collided with MV1. Operator reported pain to leg. Signed a medical refusal on scene. Had private tow collect vehicle. I observed damage to the front end of MV1. MV2 operator states she was stopped at the stop sign in the Lake Ave and Beacon St intersection when she pulled out to cross over Beacon and continue on Lake Ave. Operator states she did not see MV1 in intersection during collision. No injuries reported on scene. I observed damage to the right side of MV2.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.330451
Longitude:
-71.1988513
Location:
Case
number:
Date:
2019-06-27
Time:
12:52
Address:
199 BOYLSTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
VEHICLE OPERATOR WAS DRIVING THROUGH THE PARKING LOT OF THE CHESTNUT HILL MALL. ALL OF A SUDDEN A BUG FLEW INTO HER EYE, SHE TRIED TO RUB HER EYE AND AT THAT TIME SHE STRUCK A CEMENT LIGHT POLE FOUNDATION ON MALL PROPERTY. VEHICLE HAD AIR BAG DEPLOYMENT, VEHICLE OPERATOR TRANSPORTED TO NEWTON WELLESLEY HOSPITAL WITH SHOULDER PAIN. VEHICLE TOWED BY TODYS TOWING OF NEWTON. CEMENT POLE FOUNDATION HAD NO DAMAGE.
Keywords:
Hospital
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3215125
Longitude:
-71.1756718
Location:
Case
number:
Date:
2019-06-27
Time:
13:01
Address:
DAY ST & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Vehicle 1 was traveling west on Washington St. Vehicle 1 wanted to make a left turn onto Day St. but went past the street. Vehicle 1 reversed traveling backwards in the westbound travel lane. At this time vehicle 1 reversed into vehicle 2. Both operators of both vehicle 1 and 2 state the same story. No reported injuries. Minor damage to the right rear of vehicle 1 and the left front of vehicle 2, both vehicles driveable.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3377662
Longitude:
-71.240903
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);