crash_reports
2 rows where address = "2345 COMMONWEALTH AVE" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-12-27
Time:
15:19
Address:
2345 COMMONWEALTH AVE
Speed
limit:
10
Violation
cited:
no
Narrative:
Witness said between 0930 to 1430 hours this date she was out of the hotel running errands. Witness stated her husband's MV (MV1) was parked unoccupied within the lines of 2345 Commonwealth Ave (Marriott Hotel) between those hours. Witness stated when she came back at 1430 hours she observed new damage done to MV1. Witness said during that time period an unknown MV sideswiped MV1 and left the scene without giving information. Witness believes the unknown MV must have scratched their car while attempting to back up from their space. Witness said the minor damage (scratch to the rear passenger side) was not there before today. Witness does not know who may have caused the damage. No injuries reported, no tow required, and no security camera recordings. Witness was advised for the registered owner to contact their insurance.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.346364
Longitude:
-71.2584662
Location:
Case
number:
Date:
2021-01-19
Time:
13:32
Address:
2345 COMMONWEALTH AVE
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was attempting to exit the parking area at the Marriott Hotel, #2345 Commonwealth Ave when MV#2 backed out of a parking space and struck MV#1. The operator of MV#2 stated that she was attempting to back out of a parking space near the exit of the parking area when her MV struck MV#1. No injuries, no tows.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3460745
Longitude:
-71.2578827
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);