crash_reports
5 rows where "datetime" is on date 2019-02-12 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, violation_cited, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-12
Time:
14:30
Address:
140 BRANDEIS RD
Speed
limit:
30
Violation
cited:
no
Narrative:
VEHICLE #1 WAS DRIVING DOWN BRANDEIS RD IN FRONT OF NEWTON SOUTH HIGH SCHOOL.IN A SNOW STORM. AS HE WAS TURNING THE CORNER IN FRONT OF THE TENNIS COURTS, HIS CAR SKIDDED ON THE UNTREATED AND UNPLOWED ROAD, INTO VEHICLE #2 WHO WAS HEADED IN THE OPPOSITE DIRECTION. NO INJURIES REPORTED. BOTH VEHICLES TOWED BY TODYS'S TOWING OF NEWTON.
Keywords:
School, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3135234
Longitude:
-71.1865424
Location:
Case
number:
Date:
2019-02-12
Time:
14:32
Address:
2345 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she had just made a U-Turn from the east bound side of Commonwealth Ave (#2345) to the west bound side when her MV started to slide in the fresh snow. MV then slid across Commonwealth Ave and hit the curb and then head on into a large tree. Operator arranged for their own tow.
Keywords:
Snow, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.346364
Longitude:
-71.2584662
Location:
Case
number:
Date:
2019-02-12
Time:
21:32
Address:
85 CHARLESBANK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 was travelling northbound on St James Street. As he approached the intersection of Charlesbank Rd, he began to brake to turn right. Due to the slippery snow and ice conditions, his brakes locked up and he skidded straight into the median in front of 85 Charlesbank Rd. The vehicle sustained major damage to the drivers side front axle, hood and under carriage. Operator of MV1 stated he was not injured and declined medical attention. He had called for a private tow. Tonys Towing responded to towed the vehicle.
Keywords:
Ice, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3588929
Longitude:
-71.1800115
Location:
Case
number:
Date:
2019-02-12
Time:
23:20
Address:
292 CENTRE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of Vehicle #1 stated that his vehicle was struck from behind by Vehicle #2. Operator #2 then stated, "there is no damage", and left the area. Operator #1 then took down the registration of Vehicle #2, and notified the police. I observed significant fresh damage to the rear bumper of Vehicle #1. Vehicle #2 is registered to a Ms. Jessica Gavell. I was later able to learn that the vehicle was being operated by her cousin, a Mr. Michael Gavell. Mr. Gavell was issued a citation for a violation of M.G.L. Ch.90/24-Leaving the Scene of Property Damage, and Ch.90/23-Operating MV after suspension due to OUI. (See Incident#19005785). None of the parties involved complained of injury, when asked.
Keywords:
Citation
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.358291
Longitude:
-71.184698
Location:
Case
number:
Date:
2019-02-12
Time:
14:45
Address:
659 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 2/12/2018 at approx 1445hrs while assigned to 497 I responded to the area of 659 Chestnut St for a report of a two car crash . Upon arrival Ma Reg 9VA441 being operated by Steven HUTCHINSON and Ma Reg 98NL90 being operated by Vi DANG were pulled to the side of the road, there was a heavy snowfall and the road had accumulated a thick layer of snow and multiple crashes were occurring. NFD was on scene , DANG was crying and hysterical despite the minor nature of the crash and zero damage to either vehicle. HUTCHINSON stated they were creeping along NB on Chestnut St when DANG stopped, HUTCHINSON attempted to stop and his 4wd engaged and he slid slightly into the back of DANGS car, no marks or damage to either car. DANG elected to go to NWH with Cataldo . DANGs veh towed so as not to obstruct roadway.
Keywords:
Crash, Fire, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3272407
Longitude:
-71.2264688
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);