crash_reports
2 rows where "datetime" is on date 2021-08-20, intersection = 0 and keywords contains "Phone"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-08-20
Time:
14:37
Address:
199 BOYLSTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 was backing out of a parking space in front of 199 Boylston St when he struck vehicle 2 which was traveling eastbound in the parking lot. Vehicle 2 did not stop and left the area. The plate given for vehicle 2 was 962WNZ and I had two phone numbers for the vehicle owner (h:617-558-7264 and C:617-834-7806). I made several unsuccessful attempts to contact the owner of vehicle two and will follow up on my next tour of duty. On 08/23/2021 I spoke to Julia over the phone who stated she was operating the vehicle and did not realize she had been involved in an accident until she got home. While driving through the parking lot she did notice the other vehicle was clost to her but did not realize they had made contact.
Keywords:
Crash, Phone
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3213853
Longitude:
-71.175966
Location:
Case
number:
Date:
2021-08-20
Time:
21:17
Address:
96 WARWICK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Upon arrival, I observed damage on the rear bumper of vehicle 2 which was parked and unoccupied. A witness, Paul Shoemaker, stated he saw vehicle 1, a white Chrysler PT Cruiser, operated by a male party back into vehicle 2 which was parked in front of 96 Warwick Rd. He stated a female party then got out of the vehicle to observe the damage. She then got in vehicle 1 and drove away towards Waltham St. The witness was unable to view the license plate. Mr. Shoemaker stated that his neighbor, the owner of vehicle 2, Marcelo Chaves, is away in Brazil and did not have a phone number for him.
Keywords:
Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3558568
Longitude:
-71.2191038
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);