crash_reports
2 rows where latitude = "42.3344554" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-06
Time:
08:27
Address:
CENTRE ST & HOMER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper # 1 stated she was driving NB on Centre Street and was turning left onto Homer Street. During the turn she was reaching for something in her car and turned into snow bank and struck a city pole with a parking restriction sign on it. Traffic Officer Wade took photos. No tows. No citations
Keywords:
Citation, Pictures, Snow
Dcc:
Lane departure, Over-steering
Report
url:
Image
url:
Latitude:
42.3344554
Longitude:
-71.1934235
Location:
Case
number:
Date:
2019-04-11
Time:
16:09
Address:
CENTRE ST & HOMER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle #1 stated they were traveling northbound on Centre St. when Vehicle #2 was stoped infront of him and was attempting to take a left on Homer St. Vehicle #1 stated he attempted to pass Vehicle #2 on the right to continue going straight when Vehicle #2 cut his wheel and pulled out infront of him. Vehicle #1 stated he continued around Vehicle #2 and continued to drive. Vehicle #1 stated that Vehicle #2 started to follow him and at some point his vehicle was struck by Vehicle #2 on the side of the rear left bumper. Vehicle #2 stated he was attempting to turn left onto Homer St. and was allowing a pedestrian to cross the road infront of him. Vehicle #2 stated he saw Vehicle #1 passing him on his right and attempted to get his attention. Vehicle #2 stated that when Vehicle #1 was passing him he clipped the front right of his vehicle. Vehicle #1 had minor damage to the side of his rear left bumper and was able to be driven away. Vehicle #2 had minor damage to the front right corner of his vehicle and was able to be driven. Both operators were asked if they were injured in the accident and both stated they were uninjured. Due to many inconsistancys in the stories from both operators and the statements from witnesses I am unable to determine who is at fault in the accident. Please see incident # 19013829 for additional information regarding the accident.
Keywords:
Crash, Ped
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3344554
Longitude:
-71.1934235
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);