crash_reports
2 rows where dcc = "["Defective equipment"]", intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-02
Time:
15:19
Address:
84 PARKER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The Operator of vehicle 1 stated she was stopped in traffic in the Northbound lane on Parker Street when her vehicle was struck from behind by vehicle 2. This caused the bumper to partly detach and was half hanging on the ground. In order to drive the vehicle away the owner requested I remove the bumper completely. The Operator of vehicle 2 stated he was traveling Northbound on Parker Street and slowing down due to traffic stopped in front of him when he felt his brakes give way, this caused his vehicle to bump into vehicle 1. Vehicle 2 sustained no damage. Vehicle 2 was towed by AAA due to possible brake malfunction.
Keywords:
[]
Dcc:
Defective equipment
Report
url:
Image
url:
Latitude:
42.324433
Longitude:
-71.1936569
Location:
Case
number:
Date:
2020-06-02
Time:
13:35
Address:
819 WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 was traveling east on Watertown Street when he was stopped by Newton Fire informing him he had pulled down several wires. -Op MV#1 stated he was traveling east on Watertown Street when the Newton Fire informing him he had pulled down several wires. He stated he observed the cargo cover arm had retacted and was sticking up, which caused electrical wires from#819 Waterown st to be pulled down from the house. -I next spoke to NM#1, the property owner of #819 Watertown St, who stated she was in her house and heard what she thought was truck speeding. she next stated that she heard a loud band and the lights in her house went out. -There were no injuries reported at this time and no further property damage Eversource was notified and responded to area.
Keywords:
Fire, Speed
Dcc:
Defective equipment
Report
url:
Image
url:
Latitude:
42.3525161
Longitude:
-71.2188578
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);