crash_reports
2 rows where "datetime" is on date 2019-05-11 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-11
Time:
19:33
Address:
345 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Opr of V1 stated he was pulling out of the parking spot onto Washington Street. At this time, he stated he thought he had enough room but did not and struck V2. V1 suffered significant damage to the front right side of the vehicle. V2 was parked in front of V1. The uninvolved owner was not around during the crash , but came to the car eventually. V2 suffered significant damage to the rear right side of the vehicle. No cars were towed and there were no injuries.
Keywords:
Crash
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3569087
Longitude:
-71.1878411
Location:
Case
number:
Date:
2019-05-11
Time:
17:36
Address:
780 BEACON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Vehicle #1 stated they were traveling east bound on Beacon St. and was attempting to continue through the intersection of Langley Rd. with a green light. Vehicle #1 stated he was struck on the right side by Vehicle #2. Vehicle #2 stated they were pulling out of 780 Beacon St. and was attempting to turn left. When turning they saw Vehicle #1 drive by and was un able to stop in time and struck Vehicle #1 in the side passenger door. Vehicle #1 had moderate damage to the right side of the vehicle and was able to be driven away. Vehicle #2 had moderate damage to the front of the vehicle and was able to be driven away. Both operators were asked if they were injured which they stated they were not hurt and refused any medical evaluation.
Keywords:
Moderate
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3301182
Longitude:
-71.1928911
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);