crash_reports
2 rows where "datetime" is on date 2021-07-07, dcc = "["Unknown"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-07-07
Time:
09:55
Address:
320 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper V1 stated she was traveling west on Washington Street in the middle lane with her left turn signal activated, to turn into 320 Washington Street entrance ( Four Points Hotel). She stated while turning left, V2 sped up and had contact with V2. Oper V2 stated he was traveling west on Washington Street in the left lane, he observed V1 with signal on but her vehicle turned into his vehicle in his lane. There was no reported injuries, both vehicles were towed by Todys towing. All parties advised of accident reporting process.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3563932
Longitude:
-71.1872752
Location:
Case
number:
Date:
2021-07-07
Time:
07:12
Address:
2101 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
There was a medical emergency at 2101 Washington Street (Care One) so Fire, Medics, and Police were all parked by the front entrance. The OP. of MV#1 states that she was trying to park correctly in her spot. She backed out and her attention was drawn to an ambulance and didn't realize there was a second ambulance behind her. That's when she collided with MV#2. MV#2 is an unoccupied ambulance with its emergency lights on while medics were out assisting a patient. Medic J. Spratt was nearby and observed his truck shake and walked around and noticed MV#1 pulling away from the ambulance with damage to the corner of the vehicle. Pictures have been taken of both MV#1 and MV#2. Ambulance MV#2 has some old damage not related to this current accident. There doesn't appear to be any new damage to MV#2 from this current accident.
Keywords:
Crash, Ems, Fire, Pictures, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3303129
Longitude:
-71.2500201
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);