crash_reports
2 rows where intersection = 0, keywords contains "Fire" and "retrieved" is on date 2021-05-24
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-05-18
Time:
08:30
Address:
105 RUMFORD AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 states that he was exiting #105 Rumford Ave when the top of his freight caught the wires across the driveway to that address. The force of the crash snapped Edison pole #866/6 in half and took down the wires. MV#1 also sustained damage to the front windshield and cab. The Newton Fire, Waltham Fire and Waltham PD also responded as well as Eversource. There were no tows and no injuries.
Keywords:
Crash, Fire
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.358273
Longitude:
-71.242456
Location:
Case
number:
Date:
2021-05-22
Time:
22:16
Address:
242 OTIS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
MV1 was driving EASTbound on Otis St when the operator, Philip Dare, drove into a fence belonging to 242 Otis Street. Operator showed signed of impairment and was arrested for OUI Liquor, Marked Lanes, and Negligent Operation. MV1 was towed by Tody's. MV1 sustained heavy front end and undercarriage damage. No injuries were reported by Dare. Medics and Fire arrived at the scene and Fire made the scene safe with yellow caution tape and cleared debris. Pictures taken of the damage, refer to NPD Incident #21022013.
Keywords:
Fire, Impairment, Pictures
Dcc:
Reckless driving, Physical impairment
Report
url:
Image
url:
Latitude:
42.3457125
Longitude:
-71.2173959
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);