crash_reports
3 rows where "datetime" is on date 2019-12-21 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-21
Time:
07:57
Address:
64 HOMER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was parked at the street bend of 64 Homer St when he was struck from behind by MV#2. MV#1 sustained heavy damages to its driver's side rear bumper area. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated he was travelling eastbound on Homer St when his visibility was obstructed by the solar glare and struck MV#1. MV#2 sustained heavy front end damages with both front airbags deployment. The operator of MV#2 sustained a cut lower lip. He was evaluated by Newton Paramedics and signed a patient refusal of treatment. It should be noted when this accident occurred, there was a solar glare obstruction that faced all oncoming eastbound traffic. Tody's Towing took possession of MV#2.
Keywords:
Airbag, Crash, Glare, Solar
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3350688
Longitude:
-71.1962327
Location:
Case
number:
Date:
2019-12-21
Time:
15:22
Address:
421 WOLCOTT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of v1 stated he was traveling west on Wolcott St, while traveling near the bend in the road he looked down for a second and crash into a City tree. I took pictures of the crash site and will have them downloaded at the I.T. Bureau. Todys towing arrived on scene and transported the vehicle to their tow lot. The operator had a laceration to his nose due to the impact of the tree Air bag deployment was on the front and right side. Medics arrived on scene, oper signed patient refusal Oper of v1 was advised of the process.
Keywords:
Crash, Pictures, Tree
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3491561
Longitude:
-71.2447763
Location:
Case
number:
Date:
2019-12-21
Time:
15:41
Address:
1201 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 12-21-19 AT APPROX. 1541HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 1201 COMMONWEALTH AVE. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES SHE WAS TRAVELING E-BOUND ON COMM AVE. WHEN SHE SAW VEHICLE #2 CROSS THE DOUBLE YELLOW LINE AND HIT HER VEHICLE. VEHICLE #2 STATES HE WAS TRAVELING W-BOUND ON COMM AVE. HE REACHED FOR AN ITEM ON HIS PASSENGER SIDE FLOOR. HE STATES WHILE DOING SO HE LOST CONTROL OF HIS VEHICLE, CROSSED THE YELLOW LINE AND HIT VEHICLE #1. THERE WAS A WITNESS ON SCENE WHO STATED HE WAS TRAVELING E-BOUND ON COMM AVE. BEHIND VEHICLE #1. WHILE DRIVING HE SAW VEHICLE #2 CROSS THE YELLOW LINE AND HIT VEHICLE #1. VEHICLE #1 HAD EXTENSIVE LEFT SIDE DAMAGE AND AIRBAG DEPLOYMENT. VEHICLE #2 HAD EXTENSIVE LEFT SIDE DAMAGE AND AIRBAG DEPLOYMENT. ALL PARTIES REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. BOTH VEHICLES WERE TOWED BY TODYS. BASED ON THE TESTIMONIES OF BOTH DRIVERS AS WELL AS THE WITNESS OBSERVATIONS THE OPERATOR OF VEHICLE #2 WAS MAILED A CITATION ( T2079756, 89/4A, MARKED LANES VIOLATION ). ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES.
Keywords:
Airbag, Citation, Crash, Severe
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3372756
Longitude:
-71.216166
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);