crash_reports
2 rows where dcc = "["Unknown"]", intersection = 0 and "retrieved" is on date 2021-09-24
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-22
Time:
13:50
Address:
244 NEEDHAM ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On Wednesday 9/22/2021 at approx 1350hrs, while assigned to N-498, I responded to 244 Needham St for a 2 car MVA. Operator of MV1 states he was backing up his vehicle when he struck the rear passenger side of MV2 which was parked and unoccupied. I observed minor damage to both vehicles. I was later able to locate the owner of MV2 and notified him of the accident.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3095933
Longitude:
-71.2143933
Location:
Case
number:
Date:
2021-09-23
Time:
16:08
Address:
140 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
BCPD1 was exiting BC Property at 140 Commonwealth ave, the officers sight line was obstructed by the car in front who swerved to avoid the pedestrian in the roadway. BC PD Officer states he had no time to react to the pedestrian in front of him. BC PD Officer attended to the pedestrian and did not stop the motor vehicle in front of him that failed to yield to the pedestrian in the roadway. It should be noted that there are stairs leading from Commonwealth carriage Rd to Commonwealth ave, but there is not pedestrian crossing in the roadway. Pedestrian stated she was coming down the stairs and trying to cross over Commonwealth ave to get onto BC campus. Pedestrian was medically evaluated by BC Ambulance and signed a patient refusal.
Keywords:
Ems, Ped
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3361186
Longitude:
-71.1692165
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);