crash_reports
1 row where "datetime" is on date 2019-02-01 and dcc_code = "[7, 97]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-01
Time:
17:01
Address:
MASSACHUSETTS TPK WEST & WASHINGTON ST
Speed
limit:
35
Violation
cited:
yes
Narrative:
MV1 stated he was "driving to fast around the corner and hit the pole." MV1 actually hit a curb, took down a street light, went up on the island hitting another street light prior to hitting the curb. The second light he struck fell on MV2. MV1 sustained heavy front end damage and was removed from the scene by Tody's Towing. MV2 stated that MV1 "came flying across the intersection, crashed into 2 poles, one of which hit my car and he crashed over there." I then observed minor damage to MV2, however it did not require a tow. Both parties signed patient refusals with Cataldo Ambulance. Operator of MV1 was arrested and charged with the following: M.G.L. 90/24/J OUI Liquor M.G.L. 90//24/E Negligent Operation M.G.L. 89/4A Marked Lanes Photos of the scene were captured and turned over to the IT Bureau. Daigle Electric notified of the damaged lights.
Keywords:
Crash, Ems, Pictures
Dcc:
Too fast for conditions, Other improper action
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);