crash_reports
3 rows where dcc contains "Followed too closely", intersection = 0 and "retrieved" is on date 2022-04-21
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-04
Time:
17:33
Address:
951 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 stated she was traveling southbound on Walnut St when she had to abruptly stop because there was a bus ahead of her that pulled over. When she stopped she was rear ended by vehicle 2, right in front of 951 Walnut St. Operator 2 stated she was traveling southbound on Walnut St when vehicle 1 abruptly stopped and causing her to rear end vehicle 1 There was minor damage to the rear bumper of vehice 1 and heavy front end damage to vehicle 2. Vehicle 2 was towed by Tody's towing. All parties involved declined medical attention.
Keywords:
Bus
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3287162
Longitude:
-71.206652
Location:
Case
number:
Date:
2022-04-08
Time:
14:24
Address:
487 CALIFORNIA ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On April 8th 2022, at approximately 14:24 hours while assigned to N491 i responded to #495 California St for a report of a MV crash. On my arrival I located both involved vehicles just west of #495 California St. Vehicle #1 was a 2022 White Range Rover, Ma. reg. 3HML10, operated by a Nasim Lalehzarian. She stated she was going W/B on California St when she came to a stop due to a vehicle in front of her was stopped waiting to make a left turn onto Melville Ave. She was then rear ended by vehicle #2. Vehicle #2 was a Red Honda Accord Ma. plate 184-D10, operated by Michael Paniagua. He stated he was going W/B on California St when he observed the vehicle in front of him stopped ahead. He then applied his brakes but they didn't allow him to stop in time. He then crashed into the rear of vehicle #1. There was a possibility of an issue with the Hondas braking. Vehicle #2 sustained heavy front end damage and required a tow. There was no reported injuries.
Keywords:
Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.362614
Longitude:
-71.2080907
Location:
Case
number:
Date:
2022-04-13
Time:
10:28
Address:
1750 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that he was stopped at the red light at the intersection of Commonwealth Ave and Washington St when the rear-end of his vehicle was struck by Vehicle #2. The operator of Vehicle #2 stated that she attempted to pull forward prior to colliding with the rear-end of Vehicle #1. None of the parties complained of injury when asked. Vehicle #2 was towed from the scene by Tody's.
Keywords:
[]
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3405731
Longitude:
-71.2384715
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);