home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2021-04-12, dcc_code = "[9]" and "retrieved" is on date 2021-04-28

✎ 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:
2100000259
Date:
2021-04-12
Time:
11:15
Address:
CENTRE AVE & CENTRE ST
Speed limit:
30
Violation cited:
no
Narrative:
On April 12th, 2021 at approximately 11:15 hours I responded to a report of a MV crash in the area of Centre St near Marathon Physical Therapy. On my arrival I located both involved vehicles on Centre Ave @ Centre St. Vehicle #1 was a White flat bed HINO Truck model325826. The operator was identified as Amanda Sprague. She reported being stopped on Centre Ave at Centre St waiting to make a right turn onto Centre St. According to her there was a funeral procession in the right turn only lane so she was waiting for it to pass before proceeding. The procession cleared vehicle#1 then proceeded to turn right when she struck vehicle #2. She further reported due to her height of her truck she never saw vehicle #2 on her right side. Vehicle #2 was a blue Prius station wagon, MA reg 9TM360 that sustained heavy rear quarter drivers side damage. The operator/owner identified as Binnie Estrada. She stated that she was stopped for the traffic light on Centre Ave at Centre St in the second lane. She indicated that she did see vehicle #2 with its right turn signal on but the truck was to her left in the third lane. She did wait at first to yield to the truck to turn right in front of her but when it didn't go she began to go straight ahead. The truck then began to make its right turn simultaneously which led to the crash. Operator #2 later said she never saw any funeral procession in the right turn only lane.
Keywords:
Crash
Dcc:
Lane departure
Report url:
report
Image url:
image
Latitude:
42.3293773
Longitude:
-71.1950856
Location:
Centre St, Newton, MA, 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 373.415ms