crash_reports
2 rows where "datetime" is on date 2019-10-25, hit_run = 0 and speed_limit = 5
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-25
Time:
14:17
Address:
361 WASHINGTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
Operator of vehicle #1 stated he was parked at RS gas on 10/24/2019 at 1500 hrs when Vehicle # 2 Backed into his vehicle, causing minor damage. Operator #1 had dashcam video of the crash identifying Vehicle #2 which had left the gas station. Operator #2 was contacted by me and stated he had been at the gas station and backed up close to vehicle #1 but was unaware that he had made contact with vehicle #1.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3566992
Longitude:
-71.1882034
Location:
Case
number:
Date:
2019-10-25
Time:
16:35
Address:
300 BOYLSTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On Friday, October25th, 2019 at approximately 1635 hours I, Officer Newton and Officer Coletti, were dispatched to the parking garage at 300 Boylston St. for a motor vehicle accident. Upon arrival I spoke with the operator of vehicle 1. He stated as he was heading towards the exit, vehicle 2 suddenly stopped in front of him. Vehicle 2 then backed into him and started moving forward again. The operator of vehicle 1 then exited the car to stop vehicle 2. The Operator of vehicle 2 then got out of her vehicle. The operator of motor vehicle 2 stated she was driving and she stopped to back up, as she backed up she thought she hit a curb but then the operator of vehicle 1 was at her window saying she hit him. As a result of the crash vehicle one sustained very minor front end damage and vehicle 2 had no noticable damage.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3185796
Longitude:
-71.179849
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);