crash_reports
1 row where "date" is on date 2019-05-11 and dcc = "["Wrong way"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-11
Time:
14:56
Address:
BRUSH HILL RD & DEDHAM ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On 05/11/19 at approximately 14:56 I responded to a two car m.v. crash at the intersection of Dedham St and Brush Hill Rd. The operator of veh #1 stated he was traveling South bound on Dedham St when veh #2 crossed into his lane and struck the front of his car. The operator of veh #1 had right wrist pain but was checked out by the medics and signed a patient refusal. Heavy damage to veh #1 with the drivers side air bag deployed. The operator of veh #2 stated he was driving due North on Dedham St when the next thing he knew he collided with veh #1. The operator of veh #2 was traveling straight ahead when the crash happened. Heavy damage to veh #2 with front and side air bags deployed. The operator of veh #2 signed a patient refusal from Medics was cited in hand Mass #T1444233 for Ch 89/ SEC 4A- Marked Lanes Violation. Both vehicles were towed by Tody's towing.
Keywords:
Citation, Crash
Dcc:
Wrong way
Report
url:
Image
url:
Latitude:
42.3098745
Longitude:
-71.2025402
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);