crash_reports

Table actions

1 row where dcc = "["Failed to yield"]", keywords contains "Citation" and "retrieved" is on date 2022-05-09

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

Case number:
22000300
Date:
2022-04-11
Time:
16:05
Address:
COMMONWEALTH AVE & VALENTINE ST
Speed limit:
30
Violation cited:
yes
Narrative:
MV1 was traveling WESTBOUND on Commonwealth Ave when it collided with MV2 at the intersection of Valentine St. MV2 was traveling NORTHBOUND on Valentine St when it entered the intersection of Commonwealth Ave and collided with MV1. There was major damage to MV1 front bumper specifically the driver side front. There was major damage to MV2 driver's side rear wheel area. Tody's towed MV2 and MV1 used a private tow. No injuries and all parties signed a refusal. A witness who was driving EASTBOUND on Commonwealth Ave watched MV2 "bomb the stop sign" on Valentine St entering Commonwealth Ave. Another witness who was driving WESTBOUND directly behind MV1 saw MV2 roll through the stop sign, hesitate and then accelerated into the intersection. MV2 operator was given in-hand, monetary citation, T2080936 for Stop Sign, Fail (c89/s9) (the stop sign on Valentine St before the intersection at Commonwealth Ave).
Keywords:
Citation
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.337888
Longitude:
-71.2135742
Location:
Commonwealth Ave & Valentine St, Newton, MA 02465, 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);