home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where date = "2019-12-20" and dcc contains "Other improper action"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, 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:
1900001319
Date:
2019-12-20
Time:
12:09
Address:
CENTRE ST & COMMONWEALTH AVE
Speed limit:
35
Violation cited:
yes
Narrative:
Mv#1 was traveling north on Centre Street when it was involved in an argument with Mv#2, resulting in the motor vehicles colliding(ref inc 19055516). -OpMv#1 stated that after the confrontation Mv#2 cut him off striking his vehicle. -OpMv#2 stated that after the confrontation Mv#1 was trying cut him off striking his vehicle. - Mv#2 Pass1 and Mv#2 Pass2 statements coincide with those made by OpMv#2. -Wit#1 he observed Mv#1 and Mv#2the at the intersection of Commonwealth Street and Centre Street. Mv#1 on the right lane and Mv#2 on the left turning lane. He stated the parties exchanging words at the intersection and a few minutes both parties spat on each other's vehicles. When the traffic control light changed he observed Mv#2 speed off and Mv#1 suddenly changed lanes after it. They stated that they observed that when both vehicle were on Commonwealth Avenue Mv#2 cut off Mv#1, causing the vehicles collided. Mv#1 threw a cup of coffee at Mv#2. Wit#1 and Wit#2 stated they intervened and de-escalated the situation until police arrived. - None of the parties reported injuries to them at the scene not either vehicle was towed. Op MV#1 was cited for Reckless Operation Ch 90s24. (Cit#2079508) by suddenly changing lanes and cutting across the intersection to follow Mv#2. Op MV#2 (Cit#2079507) was cited because his driving caused the collision by shifting lanes with out signaling, cutting off MV#1.
Keywords:
Citation, Speed
Dcc:
Other improper action
Report url:
report
Image url:
image
Latitude:
42.3365124
Longitude:
-71.1932597
Location:
Commonwealth Avenue & Centre St, Newton, MA 02459, 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

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 222.007ms