home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where "datetime" is on date 2019-10-25, intersection = 0 and "retrieved" is on date 2020-10-07

✎ 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)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900001093
Date:
2019-10-25
Time:
14:17
Address:
361 WASHINGTON ST
Speed limit:
5
Violation cited:
no
Narrative:
Operator of vehicle #1 stated he was parked at RS gas on 10/24/2019 at 1500 hrs when Vehicle # 2 Backed into his vehicle, causing minor damage. Operator #1 had dashcam video of the crash identifying Vehicle #2 which had left the gas station. Operator #2 was contacted by me and stated he had been at the gas station and backed up close to vehicle #1 but was unaware that he had made contact with vehicle #1.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3566992
Longitude:
-71.1882034
Location:
361 Washington St, Newton, MA 02458, USA
Case number:
1900001094
Date:
2019-10-25
Time:
14:43
Address:
1321 WASHINGTON ST
Speed limit:
10
Violation cited:
no
Narrative:
The operator of MV1 (MA: 249AB2) stated he was operating his vehicle Westbound through the parking lot behind 1321 Washington Street, Newton. The operator stated he was attempting to pull over to the right side of the roadway to allow a vehicle traveling Eastbound through the parking lot by him. In doing so, MV1's passenger side door area made contact with the front crash guard of Newton Police cruiser N506 ( MA MVN: MP506B). I observed minor damage to the passenger side door area of MV1 and minor damage to the front crash guard of MV2. No injuries reported. Photos were taken and submitted to the IT Bureau.
Keywords:
Crash, Pictures
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3494467
Longitude:
-71.2276058
Location:
1321 Washington St, Newton, MA 02465, USA
Case number:
1900001095
Date:
2019-10-25
Time:
16:35
Address:
300 BOYLSTON ST
Speed limit:
5
Violation cited:
no
Narrative:
On Friday, October25th, 2019 at approximately 1635 hours I, Officer Newton and Officer Coletti, were dispatched to the parking garage at 300 Boylston St. for a motor vehicle accident. Upon arrival I spoke with the operator of vehicle 1. He stated as he was heading towards the exit, vehicle 2 suddenly stopped in front of him. Vehicle 2 then backed into him and started moving forward again. The operator of vehicle 1 then exited the car to stop vehicle 2. The Operator of vehicle 2 then got out of her vehicle. The operator of motor vehicle 2 stated she was driving and she stopped to back up, as she backed up she thought she hit a curb but then the operator of vehicle 1 was at her window saying she hit him. As a result of the crash vehicle one sustained very minor front end damage and vehicle 2 had no noticable damage.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3185796
Longitude:
-71.179849
Location:
300 Boylston St, Newton, MA 02459, USA
Case number:
1900001096
Date:
2019-10-25
Time:
18:47
Address:
574 AUBURN ST
Speed limit:
25
Violation cited:
no
Narrative:
On October 25, 2019 at approx. 1847 hours, I responded to 574 Auburn St for a report of a MVA. Upon arrival, I spoke with MV1 operator who stated he was travelling Westbound on Auburn St when his vehicles front axle suddenly broke causing the vehicle's front right wheel to turn outboard thus causing the MV to drive right. MV1 then collided with MV2 which was parked outside of 574 Auburn St. MV1 was towed by AAA. No injuries reported. Around 2130 hours, Mike Woods called the police station to receive information regarding the crash and MV2. He was updated and informed me that he would also be calling AAA for his vehicle.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3435858
Longitude:
-71.257393
Location:
574 Auburn St, Auburndale, MA 02466, 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 784.044ms