crash_reports
3 rows where "datetime" is on date 2019-03-11 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-11
Time:
07:44
Address:
1897 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was traveling south on Washington St in the left hand lane when her MV was struck by MV#2. The operator of MV#2 stated that he was also traveling south on Washington St in the right hand lane directly next to MV#1 when his MV began to slide due to icy road conditions and his MV struck MV#1. No injuries & no citations
Keywords:
Citation, Ice
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3365452
Longitude:
-71.2460112
Location:
Case
number:
Date:
2019-03-11
Time:
09:56
Address:
DEDHAM ST & GREENWOOD ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
OPER OF MV#1 STATED THAT SHE WAS TRAVELLING (WB) ON DEDHAM ST, WHEN MV#2 PULLED OUT OF GREENWOOD ST, AND STRUCK HER VEHICLE. OPER OF MV#2 STATED THAT HE DID NOT SEE AN APPROACHING MV#1, AND PULLED OUT FROM GREENWOOD ST ON TO DEDHAM ST. MV #2 AND MV# 1 THEN COLLIDED. OPER OF MV#2 WAS CITED FOR 89/9 FAIL TO COMPLY WITH A STOP SIGN.
Keywords:
Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3035739
Longitude:
-71.192085
Location:
Case
number:
Date:
2019-03-11
Time:
11:02
Address:
ADAMS ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Monday, March 11, 2019 while assigned to Traffic unit N525, I responded to the area of Watertown Street and Adams Street, Newton for a report of a motor vehicle/pedestrian accident. The accident was reported to Newton Police Dispatch by Newton Police Officer Charles Guarino. Officer Guarino identified the pedestrian involved in the accident as Newton Police Officer James Selig. Watertown Street and Adams Street are both public ways maintained by the City of Newton. After completing my investigation, the operator of MV1, Colleen Butaney (S20012566) was issued Massachusetts Uniform Citation T1272995 for Chapter 90, Section 25 (Fail to Stop for a Police Officer) and Chapter 89, Section 4A (Marked Lanes Violation). Butaney was advised and the citation was placed in her property in Locker #4 in the NPD holding area prior to her release. Officer T. McCarthy completed and submitted a criminal application for Butaney for Chapter 265, Section 15b (Assault with a Dangerous Weapon, MV). Please refer to incident report #19009204 for statements from all parties involved. Photos were taken of the area/vehicle and submitted to the IT Bureau. The vehicle involved, (MA: 531PX6) was removed from the roadway by Tody's towing. Officer Marini completed a towed motor vehicle report form. Surveillance footage of the incident was recovered from a local business and was submitted to the IT Bureau/Support Services. A property and evidence form was completed and submitted to Officer Manouk.
Keywords:
Bus, Citation, Crash, Ped, Pictures
Dcc:
Lane departure, Other improper action
Report
url:
Image
url:
Latitude:
42.3599932
Longitude:
-71.202353
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);