crash_reports
2 rows where "datetime" is on date 2022-02-13, dcc = "[]" and "retrieved" is on date 2022-02-23
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2022-02-13
Time:
18:32
Address:
49 BALDPATE HILL RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated they were coming down their very steep driveway at 40 Baldpate Hill Rd. when their vehicle slid across the street, and into the front exterior of 49 Baldpate Hill Rd. It should be noted it was snowing and there was snow on the driveway and roadway. There was front end damage to MV1 and damage to the exterior and garden of 49 Baldpate Hill Rd. Tody's responded to dislodge the vehicle from the home. MV1 was parked legally out front of 49 Baldpate Hill Rd. for the night. Both the operator and passenger of MV1 signed patient refusals. The homeowner of 49 Baldpate Hill Rd. was inside at the time of the crash but was unharmed. The homeowner took pictures of the damage, was made aware of the situation and advised to contact their insurance company regarding the damage to the home.
Keywords:
Crash, Night, Pictures, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3062052
Longitude:
-71.1776676
Location:
Case
number:
Date:
2022-02-13
Time:
18:51
Address:
935 WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Sunday 2/13/22 at approximately 1851 hours while assigned to marked unit n501 patrolling division n496 I was dispatched to the area of 935 Walnut Street. Upon arrival I spoke with the passenger, DELUCA Joseph, who states he was the passenger in Ma Reg 1ANK92 and his girlfriend, BISSANTI Alicia, was the operator. They were travelling northbound on Walnut Street and approaching their home at 935 Walnut Street when BISSANTI activated her left turn signal and slowed to make a left turn into their driveway when they were struck in the rear by a white mini van. The white mini van did not stop and continued Northbound on Walnut Street. BISSANTI tried to catch up to the van and thought it turned into the parking lot of Dominos Pizza. They confronted a white male in the parking lot who was driving a white mini van, however the operator stated it was not him. While at 935 Walnut Street I observed their motor vehicle parked in the back and there wasn't any damage to the car.
Keywords:
Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3292814
Longitude:
-71.2066984
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);