crash_reports
2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-05-24
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (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-20
Time:
19:12
Address:
RIVER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was driving westbound on River St when he nicked the curb at the intersection of Henshaw St and blew both passenger side tires. He lost control of the vehicle when the tires blew and his vehicle laid to rest on the eastbound lane. Front airbags deployed. Operator, David English signed a refusal with the medics. MV1 was towed by Tody's towing.
Keywords:
Airbag
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3539632
Longitude:
-71.2335722
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);