crash_reports
1 row where dcc contains "Unknown" and latitude = "42.3469722"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-25
Time:
09:09
Address:
2040 COMMONWEALTH AVE
Speed
limit:
5
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was backing out of a parking spot in the Star Market Parking lot, #2040 Commonwealth Ave when she was involved in a MV crash. Operator #1 stated that she and the other operator both exited their MV's and even though there was obvious damage to MV#1, the operator of MV#2 refused to provide any information, got back into his MV and left the area. Operator #1 describes MV#2 as a large yellow backhoe that did not display a MV plate and she didn't observe a company name anywhere on the MV. The operator id described as W/M, approx. 40 YOA with brown hair. There is a backhoe type MV presently in the Star Market parking lot and operator #1 stated that is not the other MV involved. I also spoke with a Star Market manager who will view their exterior video footage of the parking area and notify me if it provides any information.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
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);