crash_reports
3 rows where "datetime" is on date 2019-03-09, intersection = 0 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-09
Time:
01:28
Address:
135 WINCHESTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she parked her vehicle on the street in front of 135 Winchester Street at approximately 8:00pm and when she came out to her vehicle at 1:28am there was damage to the front left fender and tire. No witnesses to the accident. MV1 was disabled due to the damage and towed by Tody's. UPDATE: On 03/10/2019, Timothy Grady came to the Newton Police Station to report he hit a vehicle on Winchester Street. He stated he thought he hit snow, but with the damage on the front right he realized he hit another vehilce and wanted to report it. Grady's statements (date, time, and location) matched with this hit and run. Grady was advised of the process.
Keywords:
Crash, Snow
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3154113
Longitude:
-71.209198
Location:
Case
number:
Date:
2019-03-09
Time:
02:23
Address:
2401 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
On Saturday March 9, 2019, at approximately 0230 hours, I, Officer Brandon, responded to the Weston/Newton line on Commonwealth Ave to assist Weston PD with field sobriety. On arrival Weston PD had concluded field sobriety and determined that the party, Glenn Matot, was not under the influence. Weston PD then explained that they had been contacted by AAA stating that a single vehicle accident occurred in Weston's jurisdiction. After further review, Weston PD and I determined that the accident was in fact in Newton. I then spoke with the operator of MV1, Glenn Matot, who stated that he was on his way home from work traveling westbound on Commonwealth ave in front of the Charles River Canoe and Kayak when he became distracted by a text message. Mr. Matot further explained that while texting, his car drifted to the right causing him to drive up on the snow bank and up onto the guard rail before then falling off back into the road. MV1 sustained major damage to both the passenger side and undercarriage. Mr. Matot did not sustain any injuries and denied any medical attention. AAA arrived on scene and removed the vehicle from the road and Mr. Matot took an Uber home. Two pictures were taken of the damaged City of Newton guard rail and submitted to IT to be attached to the report.
Keywords:
Crash, Distracted, Phone, Pictures, Snow
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.344638
Longitude:
-71.2598115
Location:
Case
number:
Date:
2019-03-09
Time:
11:30
Address:
108 JACKSON RD
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR#1 REPORTS THAT SHE WAS GOING N/B ON JACKSON RD WHEN SHE OBSERVED VEHICLE #2 BACKING UP IN HER DIRECTION. OPERATOR#1 THEN STOPPED AND ATTEMPTED TO REVERSE HER DIRECTION WHILE BEEPING HER HORN. VEHICLE #2 STILL ENDED UP BACKING INTO HER VEHICLE. OPERATOR #2 REPORTED THAT SHE HAD JUST BACKED OUT OF HER DRIVEWAY TO #108 JACKSON RD TO ALLOW HER MOTHER TO GET HER VEHICLE OUT OF SAME DRIVEWAY. VEHICLE #2 BACKED OUT S/B BUT WAS FACING N/B ON JACKSON RD. SHE FURTHER REPORTED THAT SHE WAS STOPPED PRIOR TO THE CRASH AND VEHICLE#1 DROVE INTO HER VEHICLE AS SHE WAS STOPPED WAITING FOR HER MOM TO BACK OUT OF THE DRIVEWAY. SHE DENIES BACKING UP INTO VEHICLE #1.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3592482
Longitude:
-71.1945851
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);