crash_reports
2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-01-22
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-01-01
Time:
23:17
Address:
420 WALTHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was driving southbound on Waltham St when he lost control of his vehicle due to the snow on the road. MV1 struck Verizon pole 43 outside of 420 Waltham St, no damage to the pole. The vehicle then bounced off the pole and back onto Waltham St. Vehicle sustained damage to the front bumper making it inoperable. Operator and passenger declined medical attention. MV1 was towed by Todys. Operator of MV1 took all valuables out of the car prior to his departure.
Keywords:
Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3526924
Longitude:
-71.2242876
Location:
Case
number:
Date:
2021-01-14
Time:
08:24
Address:
200 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 (13'6'' box truck) was travelling on Commonwealth Ave W/B in the area of #200. The passenger side roof struck an overhanging limb from a city tree on the median. The limb ripped off most of the roof in this area leaving shards of unsecured roof and debris sticking upward. The truck was unsafe to operate in this condition. Traffic Ofc Gaudet took photos of the area. Tody's Towing was notified to respond. Tody's was required to cut sections of the protruding roof on scene before being able to safely tow it away.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3369839
Longitude:
-71.174233
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);