crash_reports
1 row where "datetime" is on date 2019-10-04 and latitude = "42.3344554"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-04
Time:
12:46
Address:
CENTRE ST & HOMER ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
M/V 2 was stopped on Homer Street (East Bound) at the intersection of Homer and Centre Street, she was stopped at the stop sign. The uninvolved wittiness was stopped (North Bound) on Center Street with his left directional on waiting to make a left turn. Operator of M/V 1 traveling (South Bound) on Centre Street slowed while driving, the vehicle did not have any headlights on when the operator flashed her high beam twice indurating she was letting the stopped vehicles waiting to turn to proceed and make their turns. When the operator of M/V 1 flashed her high beams twice Operator of M/V2 thought the operator of M/V 1 signaled her to proceed and made the turn (North Bound) onto Centre Street. Operator of M/V 2 started into the intersection and was hit by M/V 1 who did not stop. While writing this report it was discovered that the operator of M/V 2 had an expired Drivers License (Straight Expiration) as of 09/15/2019. Citation was issued.
Keywords:
Citation
Dcc:
Other improper action
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);