crash_reports

Table actions

1 row where address = "DUNSTAN ST & WASHINGTON ST" and date = "2019-10-23"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900001085
Date:
2019-10-23
Time:
15:13
Address:
DUNSTAN ST & WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
On 10/23/2019, while assigned to N493, I, Officer Conary, responded to a MVA at Washington Street and Dunstan Street. Upon arrival, I met with Operator of MV1, who stated that she was traveling Westbound on Washington Street when she attempted to make a right turn onto Dunstan Street and hit MV2. Operator of MV2 stated that she was traveling Westbound on Washington Street when she was hit by MV1. Operator of MV2 stated that she was driving under the speed limit because she was looking to make a right turn. Operator of MV1 stated that she saw that MV2 was stopped and thought was parked. Both parties were offered and declined medical attention. Both vehicles were driven from scene. No further incident to report.
Keywords:
Speed
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3491797
Longitude:
-71.2222113
Location:
Dunstan St & Washington 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);