home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

5 rows where "datetime" is on date 2019-12-20 and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, violation_cited, 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:
1900001317
Date:
2019-12-20
Time:
13:14
Address:
1309 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator #1 was driving w/b on Washington St just past Waltham St when his rear passenger decided to open the passenger side door attempting to exit into traffic causing a crash with vehicle #2. The rear passenger door as it opened struck vehicle #2's passenger side mirror and door as it was passing vehicle #1. Operator #2 reports he was driving W/B on Washington St just passing Waltham St when vehicle #1s rear passenger door opened up into traffic striking his passenger side mirror and door.
Keywords:
Crash
Dcc:
Other improper action
Report url:
report
Image url:
image
Latitude:
42.349591
Longitude:
-71.2271417
Location:
1309 Washington St, Newton, MA 02465, USA
Case number:
1900001318
Date:
2019-12-20
Time:
12:39
Address:
175 BOYLSTON ST
Speed limit:
25
Violation cited:
yes
Narrative:
Operator of vehicle one, Christopher Sermak, stated that while turning north bound in the parking lot of 175 Boylston St he was blinded by solar glare. Sermak stated that the diver's side visor was down and the he was not wearing sun glasses. Sermak stated that he heard a loud bang coming from the front driver's side of his vehicle and realized that his vehicle had stuck something. Sermak stated that he stopped his vehicle and saw a male identified as John Baker laying on his back on the ground. Baker stated that he had step off the side walk in front of 175 Boylston St and was walking to his car when he saw Sermak's vehicle approaching him and realized it was not slowing, Baker sated that the front driver's side of Sermak's vehicle struck his right arm and shoulder causing him to be knocked to the ground on his back. Baker stated that his head struck the ground but he did not lose consciousness. Baker was transported to Newton Wellesley Hospital via EMS for treatment. While on scene I observed that the rear passenger side brake light of Sermak's vehicle was out. I issued Sermak MA Citation T 2012527 and cited him for violations of City of Newton City Ordnance 19-75, failure to use care while tuning , and MGL 90/7 , defective lights.
Keywords:
Citation, Ems, Glare, Hospital, Solar, Walk
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.3216347
Longitude:
-71.1749764
Location:
175 Boylston St, Chestnut Hill, MA 02467, USA
Case number:
1900001320
Date:
2019-12-20
Time:
08:39
Address:
146 WALNUT ST
Speed limit:
10
Violation cited:
no
Narrative:
Owner of vehicle reports that unk vehicle struck her vehicle while it was parked in her assigned parking space at #146 Walnut st, The hit and run occurred stb 19:30 hours and 21:30 hours last nite, 12/19/2019.
Keywords:
[]
Dcc:
Other improper action
Report url:
report
Image url:
image
Latitude:
42.3547212
Longitude:
-71.2084309
Location:
146 Walnut St, Newtonville, MA 02460, USA
Case number:
1900001322
Date:
2019-12-20
Time:
23:33
Address:
40 PARK ST
Speed limit:
30
Violation cited:
yes
Narrative:
MV 1 was traveling Northbound on Park St when she drove off the road and crashed into a telephone pole at 40 Park St. Park St is a public way in Newton. There was major damage to the front center, front left, and front right of MV 1. Powerlines covered the vehicle and entrapped the operator. The operator of MV was arrested for OUI (see incident report 19055618) Tody's towed the vehicle.
Keywords:
Crash
Dcc:
Lane departure, Other improper action
Report url:
report
Image url:
image
Latitude:
42.3554507
Longitude:
-71.1819377
Location:
40 Park St, Newton, MA 02458, USA
Case number:
1900001324
Date:
2019-12-20
Time:
14:41
Address:
2281 WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
The operator of MV#1 stated that he was traveling west on Washington St (#2281) in the left hand lane when MV#2 entered his travel lane from the entrance/exit of #2281 Washington St and crash occurred. The operator of MV#2 stated that she was attempting to exit the property at #2281 Washington St and turn left when the MV in the right hand lane (west bound) had stopped to allow her to enter. MV#2 proceeded to enter Washington St when crash occurred with MV#1. No injuries, no tows.
Keywords:
Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3267587
Longitude:
-71.2549391
Location:
2281 Washington St, Newton, MA 02462, 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 326.213ms