crash_reports
1 row where dcc_code = "[3]" and "retrieved" is on date 2021-08-14
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-07-27
Time:
07:40
Address:
NAHANTON ST & WELLS AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator #1 stated that he was travelling Eastbound on Nahanton St. in the center lane. Operator #1 had a green light to proceed through the intersection of Nahanton St. and Wells Ave. Operator #1 stated that vehicle #2 was directly in front of his vehicle in the center lane. Operator #1 stated that vehicle #2 suddenly slammed on her brakes and attempted to make a left turn into the Jewish Community Centre entrance from the center lane. Operator #1 stated it happened so quickly he was unable to stop in time to avoid colliding with vehicle #2. (cid:31)(cid:31)(cid:31)Operator #2 stated she was in the center lane travelling Eastbound. Operator #2 stated she was following her GPS which instructed her to turn left. Operator #2 stated she slowed suddenly and attempted to make a left hand turn from the center lane, causing vehicle #1 to collide with Vehicle #2. Vehicle #2 was then pushed forward into vehicle #3. (cid:31)(cid:31)(cid:31)(cid:31)Operator of vehicle #3 stated she was in the left hand lane waiting fro traffic to make a left turn into the JCC entrance. Operator #3 stated she was struck by vehicle #2 from behind. Medics arrived on scene and patient refusals were signed by all occupants.
Keywords:
[]
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.2971091
Longitude:
-71.2040054
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);