crash_reports
2 rows where dcc = "["Reckless driving", "Emotional"]", dcc contains "Emotional" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2020-08-09
Time:
14:43
Address:
197 CALIFORNIA ST
Speed
limit:
20
Violation
cited:
no
Narrative:
Opr of MC1 stated he was traveling straight attempting to leave the parking lot. Opr MC1 stated while he was trying to pull forward he was struck by V2. Opr of V2 stated he was attempting to leave the parking lot. Opr of V2 stated he was emotional and upset and tried to pass the two motorcycles. Opr of V2 stated he got too close and made contact with MC1. MC1 had minor damage and the Opr was seen by the Medics. V2 had minor damage and was seen by the Medics. Both signed patient refusals.
Keywords:
[]
Dcc:
Reckless driving, Emotional
Report
url:
Image
url:
Latitude:
42.3651092
Longitude:
-71.1963023
Location:
Case
number:
Date:
2022-05-30
Time:
14:31
Address:
200 BOYLSTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
Vehicle #1 was parked in a legal parking spot at level P1 of the Wegman's parking garage. Vehicle #2 was backing up the ramp after a verbal altercation and attempted to exit the parking garage. While backing and turning the vehicle, vehicle #2 struck vehicle #1. Vehicle #2 then left the scene. The vehicle is registered to Texano JR corp. See incident report # 22018894
Keywords:
[]
Dcc:
Reckless driving, Emotional
Report
url:
Image
url:
Latitude:
42.3189069
Longitude:
-71.1752159
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);