crash_reports
2 rows where "date" is on date 2019-10-19, hit_run = 0 and speed_limit = 15
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-19
Time:
04:51
Address:
38 COMMONWEALTH AVE
Speed
limit:
15
Violation
cited:
no
Narrative:
On Saturday, October 19th 2019, at approximately 4:20am, I took a report at the front desk for a past hit and run. I spoke with the operator of MV1(MA REG 1VMW94) who stated at approximately 1:20am he was dropping off an Uber passenger at 38 Commonwealth avenue, and he was backed into by MV2(CT REG 870XCH). MV1 sustained scrapes and a pushed in front bumper. The operator of MV2 did not stop to provide information, and as of the writing of this report the operator is not known. I left a message with the registered owner of MV2 to contact me. There were no injuries in the accident.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3392841
Longitude:
-71.1680599
Location:
Case
number:
Date:
2019-10-19
Time:
10:13
Address:
33 AUSTIN ST
Speed
limit:
15
Violation
cited:
no
Narrative:
MV1 was parked in a legal spot facing southbound in the parking lot of 33 Austin St. MV2 was attempting to back up when he struck MV1. Operator 2 states he did not know he was so close to MV1 and backed up into him. No injuries. No tows needed. MV1 sustianed minor damage to the rear. MV2 sustained minor damage to the rear passenger side. 6 photos taken and placed into IT.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3498004
Longitude:
-71.2087985
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);