home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2022-02-13, dcc_code = "[]" and "retrieved" is on date 2022-02-23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
22000145
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:
report
Image url:
image
Latitude:
42.3062052
Longitude:
-71.1776676
Location:
49 Baldpate Hill Rd, Newton, MA 02459, USA
Case number:
22000147
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:
report
Image url:
image
Latitude:
42.3292814
Longitude:
-71.2066984
Location:
935 Walnut St, Newton, MA 02461, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 451.987ms