crash_reports
2 rows where "datetime" is on date 2022-04-10, intersection = 0 and "retrieved" is on date 2022-04-21
This data as json, CSV (advanced)
Suggested facets: 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:
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);