crash_reports
1 row where date = "2021-11-03" and "retrieved" is on date 2021-11-22
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-03
Time:
12:21
Address:
112 GORDON RD
Speed
limit:
25
Violation
cited:
no
Narrative:
When I arrived on the scene I observed a tractor trailer stopped in the middle of Gordon Rd (#112) with wires across the top of MV#1 and a city owned tree down on the ground next to the roadway. The operator of MV#1 states that his tractor trailer was detoured to Gordon Rd (south bound) from Chestnut St when he believes the top of his truck caught some low hanging wires and also took down a tree. After further observations of the downed tree and viewing additional damage to MV#1, it appears to me that the passengers side of MV#1 struck the city owned tree, knocking it down which then took down the wires. There also appeared to be damage houses (#111) in the area and at least one MV parked in the driveway at #112.
Keywords:
Tree
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3318245
Longitude:
-71.221387
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);