home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Distracted", intersection = 0 and keywords contains "Moderate"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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:
1900000094
Date:
2019-01-22
Time:
09:08
Address:
241 NEEDHAM ST
Speed limit:
25
Violation cited:
yes
Narrative:
On 01/22/19 I responded to a three vehicle crash on Needham St. in front on #241- Marshalls Plaza. The operator of veh #1 stated she was driving due West on Needham St. when she looked right at a car waiting to pull out of the parking lot. When she looked back to Needham St., the traffic was stopped and she hit her brakes and snow slid covered her windshield. Operator of veh #1 never saw the impact, but veh #1 struck stopped veh #2 which was pushed into stopped veh #3. Moderate damage to veh #1 and 2 but no damage at all to veh #3. Operator of veh #2 said she was going "2-3 MPH " when she was pushed into veh #3. Operator of veh #3 claimed she was dizzy from the accident and signed a patient refusal from Ambulance #1. Engine #7 was also on scene assisting. Operator of veh #1 was cited in hand Mass citation #T1441211 for Ch 90/ Sec 13- failure to remove snow from vehicle . All vehicles were driven away from the scene.
Keywords:
Citation, Crash, Ems, Moderate, Snow
Dcc:
Distracted
Report url:
report
Image url:
image
Latitude:
42.3097858
Longitude:
-71.2156787
Location:
241 Needham St, Newton, MA 02464, USA
Case number:
1900001004
Date:
2019-10-03
Time:
21:24
Address:
84 PARKER ST
Speed limit:
30
Violation cited:
no
Narrative:
MV#1 stated while traveling northbound on Parker St, she stopped at the intersection of Browning Rd and Parker. She initiated the left turn signal, prior to taking a left, MV#2 struck the rear of her vehicle causing moderate damage. MV#2 stated while traveling northbound on Parker St, his attention was taken off the road due to a bug crawling on his neck. MV#2 stated while his attention was diverted from the road he struck MV#1 with the front end of his vehicle. Both parties stated they did not sustain any injuries at this time and refused medical attention at this time. MV#1 was not towed from the scene due to minor damage. MV#2 awaited for his own tow from AAA. MV#2 was placed on the side of Browning Rd in a safe location to await his tow.
Keywords:
Moderate
Dcc:
Inattention, Distracted
Report url:
report
Image url:
image
Latitude:
42.324433
Longitude:
-71.1936569
Location:
84 Parker St, Newton, MA 02459, 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 269.946ms