crash_reports
2 rows where "datetime" is on date 2019-06-24 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-24
Time:
07:03
Address:
195 PARMENTER RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV#1 states that on 6/23/19 at approx. 11:30PM she heard a loud MV crash from her home. Owner was unaware which MV's were involved, but when she looked out her house window she observed a black pick up truck driving off towards Derby St. This morning she discovered that her parked and unoccupied MV was the other MV involved in the crash. MV#1 sustained heavy damage to the rear of her MV and her MV was pushed forward a few feet as a result of the crash. Owner is going to arrange for her own tow as it appears that her rear axel is broken. I searched the area for a black PU with front end damage on the passengers side with negative results.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3596891
Longitude:
-71.2321639
Location:
Case
number:
Date:
2019-06-24
Time:
15:03
Address:
ALBEMARLE RD & CRAFTS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV#1 stated she was travelling westbound on Crafts St when MV#2 took a left hand turn in front of her causing a collision. MV#1 suffered moderate damage to the front and right side. MV#2 suffered damage to the passenger side. Both operators exited the vehicles and agreed to move out of the roadway, park and exchange information. Operator of MV#2 then left the scene without providing any information. Operator of MV#1 responded to the station to report the accident. Operator of MV#2 was described as an older white woman possibly in her late 60s early 70s driving a white sedan. No further description or plate given. No cameras in the area.
Keywords:
Crash, Moderate
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3598454
Longitude:
-71.2170818
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);