crash_reports
3 rows where "datetime" is on date 2022-02-01, dcc contains "Unknown" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-02-01
Time:
15:23
Address:
191 DEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 parked at 0810 to 1500 hours on Dedham Street. At unknown time unknown vehicle struck driverside rearview mirror. MV1 not towed. Owner MV1 not in vehicle at time of collision and did not require EMTs
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3125048
Longitude:
-71.2025447
Location:
Case
number:
Date:
2022-02-01
Time:
17:48
Address:
210 NAHANTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 was traveling northbound in the area of 210 Nahanton St. when he reports a deer ran out into the roadway. The operator of MV#1 stated he "slammed" on his brakes to prevent a collision with the animal. MV#2, which was traveling directly behind MV#1 was unable to come to a stop his in time, resulting in a rear end collision. MV#1 sustained significant damage to its rear end, while MV#2 sustained some damage to its front end. No injuries were reported and both vehicles were driven from the roadway.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.2967953
Longitude:
-71.1969289
Location:
Case
number:
Date:
2022-02-01
Time:
18:31
Address:
275 GROVE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
I responded to 275 Grove St for a report of a two car MVA/no injuries. I arrived on location and observed the two involved vehicles pulled into the parking lot of 275 Grove St. V1; MA Reg. 2JNS36, 2022 Hyun/Kona SUV color blue. V1 operator; Magazine, Jerod, MA OLN #SA2390987. V2; MA Reg. 341CE8, 2008 Jeep/GRACHE util. color black. V2 Operator; Davis, Michael, MA OLN#S12649728. The crash occurred on Grove St. directly in front of the entrance to 275 Grove St./Riverside Center and directly across from the Woodland Park Apt. complex. V2 operator stated he was exiting the apt complex turning left onto Grove St. (southbound). At that time V1 travelling southbound on Grove St. collided into the passenger side of V2. The roadway is two way divided by a median island. There is a traffic light that set on flash at the time of the crash. Both operators stated their visibility was obstructed by the snow bank on the median island. Neither of the operator's were injured as a result of the collision. there was no airbag deployment in either vehicle. Both vehicles were driveable and did not require towing services. The operators were advised and left the area in their vehicles without further incident.
Keywords:
Airbag, Crash, Snow
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3387098
Longitude:
-71.2527598
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);