home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "datetime" is on date 2019-06-26 and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: hit_run, 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:
1900000657
Date:
2019-06-26
Time:
09:49
Address:
160 STANTON AVE
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV#1 stated that she was sitting in her parked MV in front of #160 Stanton Ave when MV#2 side swiped her MV. The operator of MV#2 stated that she was traveling south on Stanton Ave and attempting to park her MV when she side swiped MV#1. Operator #2 was questioning whether MV#1 had prior damage to the area of the MV were the crash occurred. Operator #1 stated that its a new rental that had no prior damage. No injuries, no tows.
Keywords:
Crash
Dcc:
Improper turn
Report url:
report
Image url:
image
Latitude:
42.3338908
Longitude:
-71.2428273
Location:
160 Stanton Ave, Auburndale, MA 02466, USA
Case number:
1900000658
Date:
2019-06-26
Time:
09:58
Address:
148 PARKER ST
Speed limit:
35
Violation cited:
no
Narrative:
Operator of Vehicle # 1 states that he was traveling straight ahead (NB) at 148 Parker Street when he stopped for approximately five children who signaled the cross walk signal to cross there. While completely stopped, he was rear ended by Vehicle # 2 and his vehicle was pushed forward approximately ten feet. His vehicle sustained major rear end damage and it was towed by Tody's. There is a functioning crosswalk signal there which has overhead lights that flash yellow before turning red. Operator of Vehicle # 2 states she was traveling straight ahead (NB) on Parker Street when she observed the above mentioned children on the side of the road. Next she says that she saw the crosswalk lights above flashing yellow but never saw Vehicle # 1 stopped there until the last second. She was then not able to stop in time striking # 1 in the rear end. Her vehicle sustained heavy front end damage and it was towed by Tody's. The operator complained of neck pain but signed a patient refusal with Cataldo.
Keywords:
Crosswalk, Walk
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3223464
Longitude:
-71.1938425
Location:
148 Parker St, Newton, MA 02459, USA
Case number:
1900000661
Date:
2019-06-26
Time:
18:42
Address:
49 BOYLSTON ST
Speed limit:
5
Violation cited:
no
Narrative:
MV1 was parked in the parking stall in front of Tender Greens. An unknown vehicle struck the rear quarter panel of MV1 causing minor paint damage. MV1 was parked from approximately 1645, until approximately 1842 when police were dispatched. No tows were needed and no injuries were recorded. There is a camera directly in front of the vehicles. I spoke to Andy McWilliams (617-405-8400) at Tender Greens who stated the footage would be available for at least two weeks, however was unable to retrieve it at this time.
Keywords:
[]
Dcc:
Lane departure
Report url:
report
Image url:
image
Latitude:
42.3226142
Longitude:
-71.1696843
Location:
49 Boylston 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 350.041ms