crash_reports
2 rows where "datetime" is on date 2019-11-27, dcc contains "Unknown" and intersection = 0
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:
14:11
Address:
1 BOYLSTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
MV#1 was parked next to handicapped stalls by the front doors of 1 Boyston Street when it was struck by MV#2. -OpMV1 stated he left his vehicle next to the handicapped stalls by the front doors of 1 Boylston Street approximately 1630hrs. He stated he returned to the stall, approximately 1730, where he discovered his vehicle had been struck in the rear right panel. OpMv#1 showed me the pictures of the damage to the vehicle on his phone. He stated he wanted to get the video surveillance of the parking lot before reporting the incident. His vehicle was not towed from the scene and no other incidents matching his collision were reported to the police.
Keywords:
Phone, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3237109
Longitude:
-71.166296
Location:
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);