crash_reports
2 rows where date = "2019-09-09"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-09
Time:
05:17
Address:
DEDHAM ST & NAHANTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Monday 9/9/19 at approximately 0517 hours while assigned to n499 I was dispatched to the intersection of Dedham and Nahanton Street for a report of a Motor Vehicle Crash. Upon arrival I spoke with the operator of MV1, KAUFMAN Judith, who states that she was travelling eastbound on Dedham Street approaching the traffic light at the intersection of Nahanton Street that was displaying a green light. Kaufman states as she attempted to proceed through the green signal MV2 turned into her lane attempting to make a left turn causing MV1 to strike MV2. MV2 Operator, COLON Marie, states she was travelling Westbound on Dedham Street attempting to turn left onto Nahanton Street. she states the traffic signal displayed a green light with a flashing yellow left turn signal. She attempted to turn left and proceeded into the path of MV1 causing the crash between MV1 and MV2. Neither party was injured and both vehicles were driven away from the crash
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3003288
Longitude:
-71.1881827
Location:
Case
number:
Date:
2019-09-09
Time:
08:08
Address:
WALTHAM ST & ELIOT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated she was traveling south on Waltham St when she stopped her MV due to traffic in front of her and was rear ended by MV#2. The operator of MV#2 stated that she was also traveling south on Waltham St directly behind MV#1 when according to her MV#1 stopped suddenly while she was adjusting her AC and crash occurred. No injuries, no tows.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.354265
Longitude:
-71.2239
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);