crash_reports
1 row where dcc contains "Unknown", dcc_code = "[10, 99]" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-07-27
Time:
17:52
Address:
LEXINGTON ST & WOLCOTT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 states that he was taking a left onto Lexington St from Wolcott St when his vehicle (vehicle #1), MA 1ZDP33, was hit by a white Chevrolet pickup with unknown plates. Operator #1 states that he had a had a green light but was able to swerve out of the way to minimize contact when the white truck ran the red light southbound on Lexington St. Damage is to the front right corner of vehicle #1. The white pickup did not stop. It turned right onto Commonwealth Ave towards Weston. I spoke to witness Sean Murphy (508-661-9329) who heard the crash and observed the immediate aftermath of the pickup taking off. He provided a further description of a 2 door white Chevrolet pickup, early 00's model, occupied 2x, with the name Empire Concrete on the passenger side. I attempted to locate an Empire Concrete, however limited search results were available. A possible business address of 54 Forest St Mllford was found and I had Milford PD respond to the address to look for the pickup. It was not there, and I was informed that the address itself is an apartment complex. It should be noted that there is no phone number or website for an Empire Concrete out of MA, although there are several other businesses that have the word Empire in the company name. The camera facing Lexington St at Gregorio Jewelers (corner of River and Lexington) did not yield any matching results for the appropriate time frame. Starbucks (corner of Commonwealth and Lexington) doesn't have outdoor surveillance equipment. Vehicle #1 did not need to be towed and no medical attention was requested by the operator. He was advised that if I am able to obtain further information or verify the company, I will contact him.
Keywords:
Bus, Crash, Phone
Dcc:
Reckless driving, Unknown
Report
url:
Image
url:
Latitude:
42.3485624
Longitude:
-71.247254
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);