crash_reports
2 rows where date = "2021-02-09" and "retrieved" is on date 2021-02-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-09
Time:
13:23
Address:
BRIDGE ST & CHANDLER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On February 9th, 2021 at approximately 13:23 hours while working N491 I responded to the intersection of Bridge St @ Chandler St for a reported MV crash . On my arrival I identified operator #1 as Angelica Beker, operating a Black Volvo SUV. She reported going S/B on Bridge St when vehicle #2 came out into the intersection from Chandler St crashing into her vehicle. Operator #2 identified as Carly Lazarus was operating a grey 2015 Honda civic. She reported being on Chandler St E/B and as she approached the intersection of Bridge St she attempted to stop but due to the snowy surface slid out into the intersection striking vehicle #1. Neither vehicle needed to be towed.
Keywords:
Crash, Snow
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3615389
Longitude:
-71.202328
Location:
Case
number:
Date:
2021-02-09
Time:
11:06
Address:
164 VARICK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
I responded to the area of Varick Rd@Quinobequin Rd. on 02/09/2021 at approx. 1106 hrs for a report of a past MVA/HR. I arrived in the area and was flagged down by vehicle owner De-Souza, Fernanda MA OLN#S64319275. She was with her vehicle MA Reg. 7115ZS; 2016 Niss/Murano color Red. The vehicle was parked on Varick Rd. directly in front of #164 Varick Rd. The vehicle had visible damage all along the drivers side which was facing the street. The vehicle appeared to have been sideswiped (probably by a plow truck). According to De-Souza the vehicle was parked unoccupied since approximately 0900 hrs to present. The MVA was unwitnessed and as of the time of this report no witnesses have been identified. The vehicle sustained body damage along the full length of the drivers side. The vehicle did not require towing service. De-Sousza has been advised to contact her insurance co. and a MVA report would be documented.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3246288
Longitude:
-71.2446111
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);