crash_reports
2 rows where dcc_code = "["97"]", 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), dcc_code (array)
Case
number:
Date:
2019-01-05
Time:
14:13
Address:
111 NEEDHAM ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Veh #1 was stopped on Needham St. at Columbia Ave red light, when veh #2 hit her from behind. Operator of veh #1 complained she hit her head on the back rest and wrist on steering wheel. She was evaluated by Amb #1 but signed a patient refusal and declined to go to the hospital. Minor damage to rear of veh #1. The operator of veh #2 stated he was stopped behind veh #1 at the red light when his foot slipped off. He then struck the gas instead of the brake. The operator was cited in hand Mass# T1441206-Failure to use care in stopping. No visible damage to veh #2.
Keywords:
Citation, Hospital
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3137685
Longitude:
-71.2121457
Location:
Case
number:
Date:
2019-01-07
Time:
17:45
Address:
1781 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The OP. of MV#1 states she was parked on Arapahoe Rd facing eastbound. She wanted to do a U-turn to get back onto Commonwealth Ave. so she drove into the driveway belonging to 1781 Commonwealth Ave. She felt her steering wheel lock up and panicked, then didn't have time to brake. She ended up colliding into a wooden retainer wall belonging to 1781 Commonwealth Ave.
Keywords:
[]
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3419136
Longitude:
-71.2391844
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);