crash_reports
2 rows where "datetime" is on date 2019-05-02 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-02
Time:
11:40
Address:
CIRCUIT AVE & ELLIOT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 05/02/19 while on patrol I observed a Traffic Light Post knocked over and resting against a damaged wooden fence. The pole appears to have been struck by a vehicle as there are tire marks leading up to the base. The pole is resting against a new six (6) foot tall unpainted wooden fence belonging to #127 Elliot St. There was no response at the residence so I left a note for the homeowner on the front door. Pictures were taken by Traffic Officer Wade and dispatch notified the light company- Daigle Light . I caution taped off the area and pole to make it safe for passers by. There is no information on the vehicle that struck the pole and a canvass of the area revealed no further leads.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3145316
Longitude:
-71.2154916
Location:
Case
number:
Date:
2019-05-02
Time:
18:52
Address:
MASSACHUSETTS TPK EAST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV1 states the she was traveling westbound on Washington street when a blue Nissan Xterra cut in front of her attempting to enter the Mass Pike eastbound on ramp. MV1 subsequently struck the Xterra as it passed her. The Xterra then cut back across the traffic island and followed MV1 and when stopped at a red light got out and began banging on MV1's window before then driving away. The operator of MV1 was unable to get the other drivers information or registration. The car was a blue Nissan Xterra and the driver was described as a white male. MV1 sustained very minor damage and the damge to MV2 is unknown.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3364517
Longitude:
-71.0770265
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);