crash_reports
4 rows where dcc_code = "[18, 19]", intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-31
Time:
13:40
Address:
294 TREMONT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper #1 stated he was backing out of the driveway of 294 Tremont Street. He stated he never saw veh #2 stating it must have been in a blind spot. Oper #2 stated he was stopped on Tremont Street waiting to tun into driveway for 294 Tremont Street when veh # 1 backed into him. Uber was arranging a tow for veh # 2. No injuries.
Keywords:
[]
Dcc:
Visibility obstructed, Inattention
Report
url:
Image
url:
Latitude:
42.3544548
Longitude:
-71.1803364
Location:
Case
number:
Date:
2020-03-19
Time:
14:43
Address:
125 WESTCHESTER RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of Vehicle #1 stated that he didn't see vehicle # 2 when he was backing MV# 1 out of his driveway at 125 Westchester Road. Accident was witnessed by Detail Officer in the street. Minor damage to both vehicles.
Keywords:
Crash
Dcc:
Visibility obstructed, Inattention
Report
url:
Image
url:
Latitude:
42.3458838
Longitude:
-71.1943995
Location:
Case
number:
Date:
2020-07-08
Time:
13:30
Address:
8 BELMONT STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was driving Northbound on Belmont St. when she struck MV2 that was parked. Operator of MV1 stated she attempted to drive around MV2, however stated she couldn't see out of one of her eyes due to a partial obstruction. MV2 was parked with no operators inside. Owner notified of accident. MV1 sustained moderate passenger side damage. MV2 sustained minor left rear damage. No injuries. No vehicles towed.
Keywords:
Crash, Moderate
Dcc:
Visibility obstructed, Inattention
Report
url:
Image
url:
Latitude:
42.3530854
Longitude:
-71.1777372
Location:
Case
number:
Date:
2020-08-08
Time:
09:41
Address:
310 PARKER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
#1 VEHICLE WAS STOPPED ON KENDALL RD, AT THE INTERSECTION OF PARKER ST. VEHICLE #2 WAS TRAVELING DOWN PARKER ST, HEADING SOUTHBOUND. SEEING THE COAST WAS CLEAR IN BOTH DIRECTIONS, VEHICLE #1 PULLED OUT ONTO PARKER ST, IN AN ATTEMPT TO TAKE A LEFT HAND TURN. AT THIS TIME VEHICLE #2 WAS NOT PAYING ATTENTION, WAS APPARENTLY DISTRACTED AND HIS VIEW WAS OBSTRUCTED BY A TREE PARTIALLY BLOCKING HIS VIEW THEN IN TURN, DROVE INTO VEHICLE #1. VEHICLE #2 OPERATOR STATED THAT THE ACCIDENT WAS HIS FAULT AS WAS NOT PAYING ATTENTION. NO INJURIES REPORTED, VEHICLE #2 TOWED BY TODYS TOWING OF NEWTON. THERE IS A TREE AT THE INTERSECTION OF KENDALL & PARKER ST, THAT NEEDS TRIMMING THAT OBSTRUCTED BOTH DRIVERS VIEW. CITY NOTIFIED TO TRIM TREE TO PREVENT FURTHER OBSTRUCTED VIEWS.
Keywords:
Crash, Distracted, Tree
Dcc:
Visibility obstructed, Inattention
Report
url:
Image
url:
Latitude:
42.31672
Longitude:
-71.1946315
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);