crash_reports
1 row where "datetime" is on date 2019-03-02, intersection = 0 and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-02
Time:
03:31
Address:
194 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
yes
Narrative:
MV#1 stated while traveling westbound on Commonwealth Ave he closed his eyes for a few moments causing his vehicle to veer to the right. MV#1 drove up on the curb and struck a overhanging street light. MV#1 sustained heavy front end damage as well as uprooting the overhanging street light. Operator of MV#1 stated he had minor injuries and signed a patient refusal. Operator of MV#1 was given the following roadside tests, due to the time and circumstances of the incident. Horizontal Gaze Nystagmus - Pass One Leg Stand - Pass Walk And Turn - Pass Operator of MV#1 showed no signs of impairment. Through my training and experience I calculated MV#1 had speeds of approximately +50MPH. Tody's towed the MV, a towed MV inventory form was completed. Pictures taken on scene submitted to IT.
Keywords:
Impairment, Pictures, Speed, Walk
Dcc:
Speeding, Lane departure
Report
url:
Image
url:
Latitude:
42.3369434
Longitude:
-71.1738848
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);