crash_reports
4 rows where "datetime" is on date 2019-02-19
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-19
Time:
09:03
Address:
CRAFT ST & ALBEMARLE RD
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED SHE WAS GOING S/B ON CRAFT ST WHEN VEHICLE #2 PULLED OUT FROM ALBEMARLE RD INTO THE INTERSECTION CAUSING THE CRASH. OPERATOR #2 WAS STOPPED FACING E/B ON ALBEMARLE RD AND WAS ATTEMPTING TO CROSS THE INTERSECTION TO GET TO THE OTHER SIDE OF ALBEMARLE RD WHEN HE CRASHED INTO VEHICLE #1 IN THE INTERSECTION. OPERATOR #2 FURTHER REPORTED NOT SEEING VEHICLE #1 COMING DOWN CRAFT ST.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3598454
Longitude:
-71.2170818
Location:
Case
number:
Date:
2019-02-19
Time:
07:39
Address:
FRANKLIN ST & WAVERLEY AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 (Mass reg. 8928AN) states he was traveling south bound on Waverly Ave when MV2 went through the stop sign and entered the intersection causing him to collide with MV2. Operator of MV2 (Mass reg. 7SH894) states she does not have much recollection from the accident. She states she had glare in her eyes when she was traveling east bound on Franklin Street and stopped at the intersection with Waverly Ave and proceeded through the intersection and collided with MV1. All parties were evaluated by Cataldo paramedics, operator of MV2 was transported to Saint Elizabeth's Hospital with minor injuries. Tody's towed both motor vehicles.
Keywords:
Crash, Glare, Hospital
Dcc:
Failed to yield, Glare
Report
url:
Image
url:
Latitude:
42.3492419
Longitude:
-71.1804564
Location:
Case
number:
Date:
2019-02-19
Time:
07:32
Address:
84 JACKSON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator 1 states she was traveling Eastbound on Jackson St when she was blinded by the sun. Unable to see Operator 1 struck vehicle 2 which was parked from behind. Vehicle 1 sustained major damage and was towed by Tody's. Vehicle 2 sustained minor damage. There were no injuries.
Keywords:
Solar
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3193464
Longitude:
-71.1862309
Location:
Case
number:
Date:
2019-02-19
Time:
12:53
Address:
1269 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated she was at a complete stop in traffic on Centre St N/B opposite #1269. #1 stated she was suddenly rear ended by Mv#2. No injuries reported. #1 appeared to sustain moderate damage and was driven away from the scene. #2 operator stated she was travelling straight ahead on Centre St N/B passing through the Beacon St intersection. #2 stated she was distracted by watching a pedestrian nearby and as a result rear ended #1 ahead of her. No injuries. #1 sustained heavy front damage and was towed by AAA towing.
Keywords:
Distracted, Moderate, Ped
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3302456
Longitude:
-71.1950254
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);