crash_reports
8 rows where date = "2019-08-20"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-20
Time:
08:23
Address:
400 CENTRE AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR#1 STATED SHE WAS GOING E/B ON CENTRE AVE JUST EAST OF CENTRE ST IN THE FAR LEFT LANE WHEN VEHICLE #2 CHANGED INTO HER LANE CAUSING THE CRASH. OPERATOR #2 STATED SHE WAS IN THE LANE NEXT TO VEHICLE #1 ALSO HEADING EAST ON CENTRE AVE WHEN SHE ATTEMPTED TO CHANGE INTO THAT LANE THINKING SHE HAD ENOUGH CLEARANCE. VEHICLE #2 STRUCK VEHICLE #1 AS SHE CHANGED LANES.
Keywords:
Crash
Dcc:
Failed to yield, Lane departure
Report
url:
Image
url:
Latitude:
42.3559661
Longitude:
-71.18448
Location:
Case
number:
Date:
2019-08-20
Time:
08:18
Address:
ALBEMARLE RD & CRAFTS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 stopped suddenly for a pedestrian in a crosswalk. vehicle 2 did not stop in time and rear ended vehicle 1. Vehicle#2 was towed away by tody's. There were no injuries due to this accident.
Keywords:
Crash, Crosswalk, Ped
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3598454
Longitude:
-71.2170818
Location:
Case
number:
Date:
2019-08-20
Time:
08:10
Address:
1479 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 STATED SHE WAS TRAVELING IN THE RIGHT HAND LAND, GOING WEST ON WASHINGTON STREET COMING OVER THE WEST NEWTON BRIDGE BY BURKE AND BLACKINGTON'S FUNERAL HOME (1479 WASHINGTON STREET) WHEN MV 2 CHANGED LANES FROM THE MIDDLE LANE , TO THE RIGHT LANE. DUE TO MV 2 CHANGING LANES, THE REAR PASSENGER SIDE OF MV 2 STRUCK MV 1 ON THE DRIVERS SIDE BUMPER CAUSING MINOR DAMAGE. IT APPEARS AS THOUGH THE OPERATOR OF MV 2 DID NOT REALIZE THEY HAD STRUCK MV 1 AND THEY CONTINUED ON THEIR WAY WITHOUT EXCHANGING INFORMATION. OPERATOR OF MV 1 WAS ABLE TO WRITE DOWN MV 2'S LICENSE PLATE. I ATTEMPTED TO CONTACT THE OPERATOR WITH NO SUCCESS AT THIS TIME AND ALSO CONTACTED BPD TO SEE IF THEY COULD GO BY THE OWNERS ADDRESS AND NOTIFY THEM TO CONTACT ME REGARDING THE ACCIDENT. I HAVE NOT HEARD BACK AS OF 9/3/2018.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3467789
Longitude:
-71.2322834
Location:
Case
number:
Date:
2019-08-20
Time:
09:04
Address:
CENTRE ST BRIDGE
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED SHE WAS GOING N/B OVER THE CENTRE ST BRIDGE FROM WASHINGTON ST WHEN VEHICLE #2 CHANGED INTO HER LANE CAUSING THE CRASH. OPERATOR #2 STATED HE WAS GOING N/B MERGING INTO TRAFFIC ON THE CENTRE ST BRIDGE WHEN HE STRUCK VEHICLE #1. THERE WERE NO INJURIES DUE TO THIS ACCIDENT AND NEITHER VEHICLE WAS TOWED.
Keywords:
Crash
Dcc:
Failed to yield, Lane departure
Report
url:
Image
url:
Latitude:
42.3725498
Longitude:
-71.2287451
Location:
Case
number:
Date:
2019-08-20
Time:
11:39
Address:
600 CENTRE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED SHE WAS TRAVELLING N/B ON CENTRE ST WHEN VEHICLE #2 WHICH WAS PARKED ON CENTRE ST, OPENED THE DRIVERS SIDE DOOR STRIKING HER VEHICLE'S PASSENGER SIDE MIRROR. OWNER OF VEHICLE #2 STATED HE PARKED HIS TRUCK(FORD F250) N/B ON CENTRE ST NEAR BELLEVUE ST WHILE HE WAS WORKING(LANDSCAPING). HE OPENED HIS DRIVERS SIDE DOOR AND HIS DOOR STRUCK VEHICLE #1'S MIRROR AS IT PASSED HIS TRUCK N/B. THERE WERE NO INJURIES DUE TO THIS ACCIDENT AND NEITHER VEHICLE WAS TOWED.
Keywords:
Crash
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3504905
Longitude:
-71.1858523
Location:
Case
number:
Date:
2019-08-20
Time:
12:09
Address:
8 KIRKSTALL RD
Speed
limit:
25
Violation
cited:
no
Narrative:
OPERATOR STATED SHE TURNED RIGHT ONTO KIRKSTALL RD FRON WALNUT ST N/B AND MUST OF MADE TO WIDE OF A TURN AND CRASHED INTO A EDISON POLE IN FRONT OF #8 KIRKSTALL RD. THE POLE SUSTAINED ONLY MINOR DAMAGE. THE OPERATOR DENIES IT BUT ITS POSSIBLE SHE MIGHT OF BEEN HAVING A MEDICAL ISSUE PRIOR TO CRASH. SHE DID GO WITH THE MEDICS FOR AN EVALUATION. VEHICLE WAS TOWED BY TODYS.
Keywords:
Crash
Dcc:
Illness
Report
url:
Image
url:
Latitude:
42.3443228
Longitude:
-71.2053525
Location:
Case
number:
Date:
2019-08-20
Time:
14:14
Address:
16 WINTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OPER OF MV#1, STATED THAT SHE GOT INTO HER VEHICLE AND PROCEEDED TO DRIVE FORWARD (EB) ON WINTER ST, WHEN SHE DROVE INTO A METAL, DIGGING, CONSTRUCTION BUCKET. THE BUCKET WAS LOCATED ON THE STREET IN FRONT OF HER VEHICLE PRIOR TO THE ACCIDENT. THE BUCKET WAS NOT MARKED WITH CONES, AND THE OPERATOR (MV#1) STATED THAT THE BUCKET WAS NOT VISIBLE FROM HER DRIVER SEAT. MV#1 SUSTAINED MINOR DAMAGE TO THE FRONT LEFT BUMPER/LIGHT AREA. THE CONSTRUCTION BUCKET WAS NOT DAMAGED.
Keywords:
Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3145269
Longitude:
-71.2244732
Location:
Case
number:
Date:
2019-08-20
Time:
16:59
Address:
CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that vehicle #2 merged into his travel lane as they began to cross the bridge. His vehicle sustained heavy damage to the passenger side, as a result of the collision. The operator of Vehicle #2 stated that Vehicle #1 attempted to pass him on the inside prior to the collision. No injuries were reported at the time, and both vehicles were able to drive away from the scene.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.329368
Longitude:
-71.1950954
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);