crash_reports
2 rows where "datetime" is on date 2022-05-11 and "retrieved" is on date 2022-05-20
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-11
Time:
15:28
Address:
152 RIVER ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV1 was traveling east on River Street. Operator of MV1 states a large truck was traveling west on River Street. Operator of MV1 states he could not fit between the oncoming traffic and MV2 which was parked on the shoulder in front of 152 River Street. MV1 struck the rear of MV2, pushing MV2 into MV3. MV3 was parked in front of MV2. MV2 was parked, but had an occupant in the drivers seat. The door to MV2 could not be opened and had to be opened by NFD. MV3 was unoccupied. Operator of MV1 signed a patient refusal and the occupant of MV2 was transported to NWH. Todys towed all 3 vehicles.
Keywords:
Fire
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3533248
Longitude:
-71.2329864
Location:
Case
number:
Date:
2022-05-11
Time:
20:21
Address:
CENTRE ST & COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
On 5/11/22 I responded to Commonwealth Ave. and Center St. for a 2 car accident. Upon arrival I spoke with the operator of MV1 who stated he was at fault for the accident. He stated that he was on the center lane of Comm. Ave. heading w/b when he noticed that he had to take a right turn. He stated that he checked his mirror and reversed to merge onto the right lane, and that is when he hit MV2 which was behind him. The operator of MV2 stated that he was driving e/b on the center lane when MV1 backed up and hit him causing moderate damage to the right front of the vehicle. Both parties stated they had no injuries and denied medical attention. Both parties were given the report number and gieven information on how to get a copy of the report.
Keywords:
Crash, Moderate
Dcc:
Reckless driving, Inattention
Report
url:
Image
url:
Latitude:
42.3365124
Longitude:
-71.1932597
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);