crash_reports
2 rows where "datetime" is on date 2021-07-20 and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-20
Time:
17:07
Address:
399 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that as she was attempting to make a left turn from the parking lot of 399 Washington St, Vehicle 2 stopped for her to cross the lane of traffic. Vehicle #2 then accelerated into her vehicle as she was stopped in the roadway. The operator of Vehicle #2 stated that as she was travelling Westbound on Washington St, she collided with Vehicle #1 as it was attempting to pull out of the parking lot. Both parties declined medical attention when it was offered.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3563569
Longitude:
-71.1896886
Location:
Case
number:
Date:
2021-07-20
Time:
17:09
Address:
330 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 07/20/2021 while assigned to marked cruiser #493 at 17:09, responded to intersection of Walnut St and Highland Ave for MVA with parked vehicle. Upon arrival we met with MV1 driver Ms. Yelena Margolin, who stated that she was traveling northbound on Walnut St. when she felt a thud against her car on the right/passenger side. Ms. Margolin stated that she then realized that her car crashed into open door of MV2 which was parked on Walnut St. Ms. Margolin stated that she did not see MV2 to open the door before the collision because she was focused on driving and oncoming traffic. MV1 had minor damage to right front corner, right side mirror, and moderate damage to right rear door. Then we spoke to MV2 operator Mr. Adam Ruttenberg. Mr. Ruttenberg stated that he parked on Walnut St. and sat in his car for a minute before he decided to open the door to get out. Mr. Ruttenberg could not recall whether or not he checked his mirrors before opening the door. Mr. Ruttenberg stated that as soon as he opened his door, MV1 crashed into his door. Due to the damage caused by collision, Mr. Ruttenberg was not able to close his door and he requested a tow through AAA. All parties involved denied any medical complaints or need for EMS.
Keywords:
Crash, Ems, Moderate
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3496903
Longitude:
-71.2065592
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);