crash_reports
2 rows where address = "165 NEEDHAM ST" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-20
Time:
15:08
Address:
165 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of vehicle 1 pulled forward out of their parking space, and struck vehicle 2 in the front right side. I noticed moderate damage to the front left side of vehicle 1, and moderate damage to the front right side of vehicle 1. No one was injured. Vehicle 2 was towed by Tody's to their lot.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
Location:
Case
number:
Date:
2020-02-02
Time:
14:10
Address:
165 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 02/02/20 at approximately 14:10 I met with Bobson Berleus who parked his fathers car (Mass Reg#542DV3 -2003 Toyota Camry Grey) in a parking spot outside of Boston Ballet School at around 06:00 while he went to work inside T.J. Maxx. When Berleus returned to the vehicle at around 14:00, he found that it had been struck on the front drivers side fender. I spoke with Stop & Shop Manager Jim Boucher (where Berleus also works) and he was going to look at security footage of today and try to see if he could locate the accident. There are no cameras from the Ballet School in the direction where Berleus parked. ************************UPDATE*************************** As of my 02/09/20 at approximately 11:00, I have yet to hear back from Manager Jim Boucher or anyone else from Stop & Shop. I will now consider this investigation closed unless I am contacted in the future with new information.
Keywords:
Crash, School
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
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);