crash_reports
1 row where "datetime" is on date 2019-11-27, dcc contains "Unknown" 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:
2019-11-27
Time:
16:11
Address:
69 WALTHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 11/27/2019, at 1611 hours, I responded to the area of 69 Waltham St, Highlander Farms, for a two car hit and run accident. Upon arrival, I observed MV1 to have damage along the drivers side. The operator stated that she was traveling southbound on Waltham St when MV2, which was parked facing southbound in front of Highlander Farms, abruptly pulled out and hit her. The operator of MV2 then pulled a U-turn and fled northbound into Waltham. MV2 was described as a small light grey car with drivers side damage and a popped front right tire. The operator of MV2 is believed to be female. Waltham PD was notified and searched the area with negative results. There are no exterior cameras on any of the businesses in the area nor was I able to locate any witnesses. No injuries were reported and MV1 was driven from the scene.
Keywords:
Bus, Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3636814
Longitude:
-71.2262367
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);