crash_reports
2 rows where "datetime" is on date 2019-02-08, intersection = 0 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-08
Time:
11:02
Address:
6 BEECH ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Owner of vehicle #1 reports that a waste management driver alerted her that he observed a blue F250 pickup truck back up from the driveway across from her and hit her vehicle on the rear drivers side. operator of suspect truck then pulled back into the driveway before backing out again heading east towards jasett st. witness gave possible ma registration of 969-wr4 but the plate didn't match the description of the vehicle. I will check with residents of property of #15 jasett to see if they know anyone who operates a blue F250. There was no answer at the door at this time. On February 10th, i went back to #15 jasett st and spoke with Jesse Grillo and told her about this accident. i asked her if she new anyone who drove a blue ford f250 that might have came to her home looking for her or her husband? She stated no.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3639587
Longitude:
-71.1982856
Location:
Case
number:
Date:
2019-02-08
Time:
19:08
Address:
741 BEACON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 was driving westbound on Beacon St in the area of 741 Beacon. Operator of MV1 stated his tire blew out and the car swerved into the side of MV2 and then the rear of MV3 which were both parked legally. Witness 1 stated she heard the crash but did not see the impact. She stated she heard the crashing noise first, and then heard a loud popping noise of the tire blowing out shortly after. Witness 1 identified Cesar Ramirez Rodriguez as the Operator of MV1. Operator of MV1 was uninjured, and the other two vehicles were unoccupied. Todys responded and towed MV1 and MV2. Operator of MV1 was issued, in hand, MA citation T1440439 for 90/23 Operating after suspension and 89/4A marked lanes violation. I was eventually able to locate the owners/drivers of the parked vehicles and they were given the report number. Beacon St is a public way in the City of Newton.
Keywords:
Citation, Crash
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3307801
Longitude:
-71.1912925
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);