crash_reports

Table actions

1 row where "date" is on date 2019-02-12 and street1 = "SOUTH BRYON RD"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date)

Case number:
1900000179
Date:
2019-02-12
Time:
15:45
Address:
BRYON RD & LAGRANGE ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 states he was traveling eastbound on Lagrange St approaching Bryon Rd when MV2 made an "unusual" left turn attempting to travel southbound on Bryon Rd. Operator of MV1 states when MV2 made the left turn, MV2 collided with MV1 causing damage to the left front corner panel and drivers side door. Operator of MV2 states he was traveling westbound on Lagrange St approaching Bryon Rd to take a left turn traveling southbound on Bryon Rd. Operator of MV2 states while making the left turn, MV1 looked like it attempted to come to a stop but slid due to the snow and slippery road conditions. Operator of MV2 states his tires spun out attempting to make the turn and struck MV1 with the front left corner panel causing significant damage. It should be noted the weather during this time was heavy snow with wet and slippery road conditions, which is a determining factor on how the accident happened.
Keywords:
Crash, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3017711
Longitude:
-71.1689697
Location:
Bryon Rd & Lagrange St, Newton, 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);