crash_reports
1 row where "date" is on date 2019-07-09 and dcc = "["Wrong way"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-07-09
Time:
08:39
Address:
CABOT ST & CENTRE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV1 (ma reg RWH529) was traveling Southbound on Centre St when he observed a disabled truck in the middle of the street. The truck was stopped in the middle of the road at the intersection of Cabot St. Operator of MV1 stated he attempted to go around the truck entering the NB lane but had to quickly cut back into his lane because of oncoming traffic. Operator of MV1 caught the corner of the metal foot bar of the traffic ripping his whole left passenger side open. Operator of MV2 (CT apportioned 49135A) stated while driving his vehicle SB on Centre St on his way to Needham he could feel the truck start to have issues. Operator of MV2 stated while stopped at the light at Centre and Cabot he heard a piece from his truck break off. The break became disabled at this time and could not be moved. Operator of MV2 called the police to report the issue, before we arrived Operator of MV1 had caught the edge of the metal foot hold. Both vehicles were towed by Tody's. Neither driver reported any injuries at this time. There was no visual damage to MV2. MV1 sustained heavy body damage all along the passenger side.
Keywords:
[]
Dcc:
Wrong way
Report
url:
Image
url:
Latitude:
42.3470298
Longitude:
-71.1891713
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);