crash_reports
3 rows where dcc contains "Emotional", intersection = 0 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: hit_run, violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-05
Time:
20:23
Address:
WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV2 operator stated that she and the operator of MV1 were both in a road rage incident, operating eastbound on Washington St prior to Centre St at approximately 1910 hours. MV2 operator stated before she attempted to merge left, MV1 purposefully cut her off by merging right in front of her, and slammed on the breaks. Because MV1 slammed on the breaks by merging right, MV2 operator stated she struck the rear of MV1. MV2 operator reported no injuries at this time, and MV2 sustained minor front driver side hood and front driver side headlight damage. MV2 operator stated she believed MV1 may have sustained damage. MV1 operator stated he did not think he was involved in a motor vehicle accident. However, MV1 operator reported a road rage incident at that time and area, and stated he did recall MV2 taking up to travel lanes. MV1 reported no injuries at this time and upon looking at his vehicle, only reported very minor paint transfer. Please see incident report #21014753.
Keywords:
Crash
Dcc:
Emotional
Report
url:
Image
url:
Latitude:
42.3498391
Longitude:
-71.2179998
Location:
Case
number:
Date:
2021-09-24
Time:
21:51
Address:
28 AUSTIN ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The operator of MV1 stated as she was pulling out of the parking garage at 28 Austin Street she struck MV2 while it was parked in a parking spot. The operator of MV1 was involved in a domestic during this accident with the operator of MV2. After striking MV2 the operator drove out of the parking garage to the NPD to report the incident. MV1 sustained minor damage to the driver side front head light. The operator of MV2 and the vehicle have not been found and spoken too in regards to the accident, unknown damage at this time.
Keywords:
Crash
Dcc:
Emotional
Report
url:
Image
url:
Latitude:
42.3500754
Longitude:
-71.2082101
Location:
Case
number:
Date:
2022-06-26
Time:
03:20
Address:
919 WATERTOWN ST
Speed
limit:
35
Violation
cited:
yes
Narrative:
MV1 was traveling WESTBOUND on Watertown St when it collided with two parked cars. MV2 (NY Reg:KVE7969) was parked facing Westbound on Watertown St across from Dunstan St and MV3 (FL Reg:IGF7B) was parked in front of 919 Watertown St also facing Westbound. MV1 collided with MV2 and then continued Westbound, hit the curb and then collided with MV3. MV1 sustained heavy front end damage and airbag deployment. MV2 sustained heavy rear end driver's side damage. MV3 sustained minor rear end passenger side damage. MV1 operator signed a refusal with the medics. No medical issues. Operator was in a high emotional state due to a recent breakup with their partner. Tody's towed MV1. Owner of MV2, resides at 919 Watertown St, came out during the incident and was able to provide her information. MV2 was still driveable. A note was placed on MV3 with crash information. There was already existing damage to the stone wall and the fire hydrant outside of 919 Watertown St. There was no new damage from this accident to either wall of hydrant.
Keywords:
Airbag, Crash, Fire
Dcc:
Emotional
Report
url:
Image
url:
Latitude:
Longitude:
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);