home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "datetime" is on date 2019-01-25 and hit_run = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000106
Date:
2019-01-25
Time:
09:09
Address:
2040 COMMONWEALTH AVE
Speed limit:
5
Violation cited:
no
Narrative:
The operator of MV#1 stated that she was backing out of a parking spot in the Star Market Parking lot, #2040 Commonwealth Ave when she was involved in a MV crash. Operator #1 stated that she and the other operator both exited their MV's and even though there was obvious damage to MV#1, the operator of MV#2 refused to provide any information, got back into his MV and left the area. Operator #1 describes MV#2 as a large yellow backhoe that did not display a MV plate and she didn't observe a company name anywhere on the MV. The operator id described as W/M, approx. 40 YOA with brown hair. There is a backhoe type MV presently in the Star Market parking lot and operator #1 stated that is not the other MV involved. I also spoke with a Star Market manager who will view their exterior video footage of the parking area and notify me if it provides any information.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
2040 Commonwealth Avenue, Auburndale, MA 02466, USA
Case number:
1900000107
Date:
2019-01-25
Time:
13:35
Address:
74 BOWERS ST
Speed limit:
25
Violation cited:
no
Narrative:
On Friday 01/25/2019 at appx. 1:30 PM while on patrol in N 491 I was dispatched to 74 Bowers St for a report of a past hit and run. On arrival I spoke to Jamie Juskiewicz who stated she parked her vehicle legally around 11:30 AM. When she came back to her vehicle around 1:30 PM she realized that an unknown person struck her vehicle causing moderate damage to the drivers side and bumper. I did not observe any surveilance cameras and there were no witnesses. The other operator did not leave a note.
Keywords:
Moderate
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3511174
Longitude:
-71.2054164
Location:
74 Bowers St, Newton, MA 02460, USA
Case number:
1900000108
Date:
2019-01-25
Time:
17:45
Address:
1743 BEACON ST
Speed limit:
25
Violation cited:
no
Narrative:
On January 25, 2019 at approximately 17:46 I responded to a motor vehicle hit and run. It was reported that a white pick-up truck crashed into a parked car and left the scene. I checked the area and was unable to find a vehicle matching the description. I responded to the crash location and spoke with the owner of MV1, who was not with his vehicle when it was struck. MV1 was parked legally on the shoulder of by 1743 Beacon St. The vehicle that struck MV1 left the travel lane and struck MV1 in the driver's side rear, causing damage. I spoke with the reporting party, Tim Leary, who heard the crash and saw a white Ford F-150 leaving the scene with damage on front passenger side. Leary did not see the license plate of the truck but thinks it was the 2006-2012 body style. The owner of MV1 was going to arrange for a private tow at a later time.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3268914
Longitude:
-71.2349317
Location:
1743 Beacon St, Waban, MA 02468, 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 457.348ms