crash_reports
3 rows where "datetime" is on date 2022-04-10 and "retrieved" is on date 2022-04-21
This data as json, CSV (advanced)
Suggested facets: intersection, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-10
Time:
08:06
Address:
70 WELLS AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
OP1 of MV 1 was traveling n/b on Wells ave when he was taking a right into 70 Wells ave. The Street was made a one way due to the bike race detail going on. OP1 had to cross over a set of cones to take a right into the parking lot and did not see the bicycle traveling. The bicycle his the passenger side of MV1. Minor damage to MV1. OP1 was not injured. Bicycle operator was traveling around Wells ave N/B when he saw the vehicle turn right, he was unable to stop in time and hit the side of MV1. Bicycle operator had a slight injury to his hand but refused medical treatment. At this time no citations issued at this time.
Keywords:
Bike, Citation
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.293806
Longitude:
-71.2001313
Location:
Case
number:
Date:
2022-04-10
Time:
12:43
Address:
CENTRE ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated she was stopped at the corner of Centre street and Washington Street, waiting for it to be safe to merge onto Washington Street. While stopped MV2 attempted to go around and struck the rear driver side of the vehicle. The operator of MV2 stated traffic was clear and while he attempted to merge onto Washington Street, MV1 stopped and he struck MV1. All parties involved were not injured. MV1 had damage to the rear bumper. MV2 had damage to the front passenger side head light and side.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Case
number:
Date:
2022-04-10
Time:
15:47
Address:
246 CALIFORNIA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was Eastbound on California St when he collided with MV#2 & MV#3 that were parked facing Eastbound. OPMV#1 Stated he doesn't know what happened and he possibly fell asleep as he was driving. No injuries. MV#1 & MV#3 were towed by Todys Towing. Uninvolved vehicle owners were notified on scene.
Keywords:
[]
Dcc:
Inattention, Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3646329
Longitude:
-71.1985301
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);