crash_reports
2 rows where keywords contains "Pictures" and "retrieved" is on date 2021-08-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-08-19
Time:
12:14
Address:
256 ALBEMARLE RD
Speed
limit:
25
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED THAT HE WAS TRAVELING N/B DOWN ALBEMARLE RD WHEN HIS VEHICLE FLOATED OFF THE ROADWAY INTO CHEESECAKE BROOKE. THE ROAD WAS COMPLETELY FLOODED AT THE TIME DUE TO HEAVY RAIN. THE VEHICLE WAS ALMOST COMPLETELY SUBMERGED UNDER WATER. THE OPERATOR GOT OUT OF THE VEHICLE THROUGH HIS SUN ROOF BECAUSE HE WAS TRAPPED. THE OPERATOR STATE ED THAT HE WAS NOT INJURED. MV#1 WAS FLOODED INSIDE AND WITH THE CURRENT IT WAS PUSHED UNDER THE FOOT BRIDGE WHICH CAUSED MAJOR DAMAGE TO IT. TRAFFIC RESPONDED AND TOOK PICTURES. TODY'S RESPONDED WITH THE FIRE DEPARTMENT TO LIFT MV#1 OUT OF THE BROOK. MV#1 WAS TOWED TO THE TOW YARD. MEDICS DID NOT RESPOND SO THERE WAS NO PATIENT REFUSAL.
Keywords:
Fire, Pictures, Rain, Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3576147
Longitude:
-71.2159572
Location:
Case
number:
Date:
2021-08-22
Time:
16:17
Address:
807 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV-1 stated she was driving northbound on Chestnut Street when she thought she saw something in the roadway and swerved. MV-1 struck City Tree (#7912) causing severe front end damage. MV-1 towed by Tody's. Photo of the tree submitted to the I.T bureau.
Keywords:
Pictures, Severe, Tree
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3218955
Longitude:
-71.2271649
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);