crash_reports
2 rows where "date" is on date 2019-11-06 and speed_limit = 30
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-06
Time:
06:10
Address:
15 NEEDHAM ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On 11/6/19 at approximately 0610 hrs I responded to 15 Needham St., the National Lumber for a MVA involving a pedestrian. Upon arrival I spoke to the pedestrian who was lying on the street who stated he landed on his back and couldn't feel if anything was hurting. I advised him to stay put until the medics responded. The pedestrian was wearing brown pants and a black jacket and stated he was listening to his head phones when he attempted to cross the street. Where he attempted to cross was down Needham St from the main intersection and there was no crosswalk. He attempted to cross from the National Lumber side crossing the S/SW travel lane first. I then talked to the operator of MV#1 who stated he turned right onto Needham St from Winchester St and didn't see anybody attempting to cross until the last second. At this time he stated he jammed on his brakes and saw pedestrian on the hood of his Pickup before he fell to the ground. There was minor damage to the hood of the vehicle on the passenger side. The pedestrian was evaluated by the Medics and transported to NWH for further evaluation. Pictures were taken on scene and turned over to the IT bureau.
Keywords:
Crosswalk, Ped, Phone, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3168424
Longitude:
-71.2097042
Location:
Case
number:
Date:
2019-11-06
Time:
10:17
Address:
BEETHOVEN AVE & BEACON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV#1 stated she was travelling eastbound on Beacon St just past the intersection at Beethoven Ave when she was struck from behind by MV#2. MV#1 sustained moderate damages to its rear bumper area. The operator of MV#1 was "Shaken up" and was evaluated by Newton Paramedics with a patient refusal of treatment. AAA Towing took possession of MV#1. The operator of MV#2 stated she was travelling eastbound on Beacon St directly behind MV#1 when she could not stop in time striking MV#1 from behind. MV#2 sustained heavy front end damages with driver's side air bag deployment. There no reported injuries to the operator of MV#2. MV#2 was towed by her insurance provider GEICO. Based on the statements made to me I issued in hand MA uniform citation #T2079231 for violation of C.O 19-71 following too closely.
Keywords:
Citation, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3305583
Longitude:
-71.2188664
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);