crash_reports
2 rows where dcc_code = "[19]" and "retrieved" is on date 2022-05-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2022-04-25
Time:
09:12
Address:
2322 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of MV#1 stated she was reversing out of her parking spot (Starbucks parking lot at 2322 Washington St) when MV#1 reversed out of her parking spot and struck her. MV#1 sustained minor damages to its passenger side front and rear bumpers. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated she was reversing out of her parking spot when someone next to her flagged her down to get her attention and she continued to reverse striking MV#1. MV#2 sustained minor damage to its driver's side rear bumper. There were no reported injuries to the operator of MV#2.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3254451
Longitude:
-71.2564178
Location:
Case
number:
Date:
2022-04-27
Time:
12:49
Address:
CENTRE ST & LYMAN ST
Speed
limit:
5
Violation
cited:
no
Narrative:
MV#1 was southbound, slowed or stopped in traffic, in the area of Centre St. by Lyman St. when it was rear ended by MV#2. The operator of MV#2 stated they accelerated while in traffic causing the rear end collision. MV#1 sustained damage to its rear bumper, while MV#2 sustained heavy damage to its front end. All damage consistent with a rear end collision. No injuries reported, MV#1 was drive from scene, while MV#2 was towed by private tow.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3321554
Longitude:
-71.1943425
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);