crash_reports
1 row where dcc contains "Defective equipment", intersection = 0 and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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);