home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "datetime" is on date 2020-07-15 and "retrieved" is on date 2020-10-06

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, 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:
2000000380
Date:
2020-07-15
Time:
01:19
Address:
2014 WASHINGTON ST
Speed limit:
5
Violation cited:
no
Narrative:
On 7/15/2020 the operator of MV 1 was parked in the parking garage and as she was reversing the drivers side corner of her vehicle hit the concrete column. The column had pulled off the bumper and caused major damage. No injuries reported. Vehicle was towed by Todys
Keywords:
[]
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
2014 Washington St, Newton, MA 02462, USA
Case number:
2000000381
Date:
2020-07-15
Time:
15:59
Address:
CENTRE ST & CHURCH STREET
Speed limit:
25
Violation cited:
no
Narrative:
On 07/15/2020, while assigned to N494, I, Officer Conary, responded to the intersection of Centre Street at Church Street for a motor vehicle accident. Upon arrival, I spoke with Operator of MV1 who stated that he was driving Southbound on Centre Street when the car in front of him stopped suddenly at the green signal. At this time, MV1 hit MV2 rear. Operator of MV1 said that he believes she was distracted with a hand held device. Operator of MV2 explained to me that she at the intersection of Centre Street and Church Street traveling Southbound. She got the green signal and she let the car traveling Northbound take a left turn onto Church Street before she continued through the intersection. At this time, MV2 was hit by MV1 from the rear. She stated she was not using her phone. It should be noted that the signal traveling Northbound on Centre is a green left signal to turn onto Church Street. After the green arrow, cars yield to oncoming traffic to turn. Fire and Medics arrived on scene and all parties involved signed patient refusals. MV1 was towed by AAA. MV1 had minor damage to the front bumper. MV2 was able to be driven from scene with minor damage to the rear bumper. No further incident to report.
Keywords:
Crash, Distracted, Fire, Phone
Dcc:
Followed too closely
Report url:
report
Image url:
image
Latitude:
42.3542225
Longitude:
-71.1864936
Location:
Church St & Centre St, Newton, MA 02458, USA
Case number:
2000000382
Date:
2020-07-15
Time:
19:32
Address:
140 BEACON ST
Speed limit:
25
Violation cited:
no
Narrative:
Motor vehicle 1 (MV1) was traveling westbound on Beacon Street when motor vehicle 2 (MV2), which was parked in front of 140 Beacon Street, attempted to pull out into traffic and crashed into MV1. As a result of the crash MV1 sustained significant front end passengers side damage, while MV2 sustained significant front end drivers side damage.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3338552
Longitude:
-71.1701433
Location:
140 Beacon St, Chestnut Hill, MA 02467, 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 1231.472ms