home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where "datetime" is on date 2019-02-12 and keywords contains "Citation"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, hit_run, violation_cited, 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:
1900000176
Date:
2019-02-12
Time:
14:59
Address:
PEARL ST & WATERTOWN ST
Speed limit:
25
Violation cited:
no
Narrative:
Oper of vehicle # 1 stated that he was traveling EB on Watertown Street and was going through intersection when MV # 2 came into intersection from Pearl Street. Both streets are public ways maintained by the city of Newton. Unsure if it slid on ice or just went through red light. Oper 1 swerved in an attempt to avoid collision but vehicles still collided. Vehicle # 2 immediately left the area. Bumper was hanging off of vehicle # 1. And Oper # 2 stated he had a witness that I was unable to talk too. MV 2 was described as a gray Nissan Pathfinder with RI reg XS837. Dispatch ran XS837 and it came back registered to a gray 2007 Nissan Pathfinder. Due to amount of damage and description given I mailed the owner of MV 2 a citation for Leaving the Scene of Property Damage. No injuries. No tows.
Keywords:
Citation, Ice
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3614737
Longitude:
-71.1969079
Location:
Watertown St & Pearl St, Newton, MA 02458, USA
Case number:
1900000181
Date:
2019-02-12
Time:
23:20
Address:
292 CENTRE ST
Speed limit:
25
Violation cited:
yes
Narrative:
The operator of Vehicle #1 stated that his vehicle was struck from behind by Vehicle #2. Operator #2 then stated, "there is no damage", and left the area. Operator #1 then took down the registration of Vehicle #2, and notified the police. I observed significant fresh damage to the rear bumper of Vehicle #1. Vehicle #2 is registered to a Ms. Jessica Gavell. I was later able to learn that the vehicle was being operated by her cousin, a Mr. Michael Gavell. Mr. Gavell was issued a citation for a violation of M.G.L. Ch.90/24-Leaving the Scene of Property Damage, and Ch.90/23-Operating MV after suspension due to OUI. (See Incident#19005785). None of the parties involved complained of injury, when asked.
Keywords:
Citation
Dcc:
Other improper action
Report url:
report
Image url:
image
Latitude:
42.358291
Longitude:
-71.184698
Location:
292 Centre St, Newton, MA 02458, USA
Case number:
1900000182
Date:
2019-02-12
Time:
14:50
Address:
BOYLSTON ST & CHESTNUT ST
Speed limit:
15
Violation cited:
yes
Narrative:
MV1 was coming down the Rte 9 West off ramp to Chestnut St. Operator was traveling too fast for the snowy road conditions and failed to stop for the stop sign at the bottom of the ramp. A snow storm had started 2 hours prior to the accident and road conditions were slippery. MV1 struck MV2 broadside who was traveling north on Chestnut St with the right of way. MV1 struck MV2 hard enough that MV2 was pushed across the lane and into MV3 that was stopped at the stop sign southbound. According to the operator of MV2, MV1 was traveling "way too fast for conditions" over 30mph. Operator MV1 was cited for 89/9 failed to stop for stop sign and 90/17 speeding too fast for road conditions. Operator was also cited on Citation T1272992 for 90/23 operating after suspended license. Boylston St and Chestnut St are public ways in the city of Newton.
Keywords:
Citation, Crash, Snow, Speed
Dcc:
Signs/Signals, Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3169482
Longitude:
-71.2257627
Location:
Chestnut St & Boylston St, Newton, MA 02464, 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 431.822ms