crash_reports
2 rows where dcc = "["Illness"]", intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-20
Time:
12:09
Address:
8 KIRKSTALL RD
Speed
limit:
25
Violation
cited:
no
Narrative:
OPERATOR STATED SHE TURNED RIGHT ONTO KIRKSTALL RD FRON WALNUT ST N/B AND MUST OF MADE TO WIDE OF A TURN AND CRASHED INTO A EDISON POLE IN FRONT OF #8 KIRKSTALL RD. THE POLE SUSTAINED ONLY MINOR DAMAGE. THE OPERATOR DENIES IT BUT ITS POSSIBLE SHE MIGHT OF BEEN HAVING A MEDICAL ISSUE PRIOR TO CRASH. SHE DID GO WITH THE MEDICS FOR AN EVALUATION. VEHICLE WAS TOWED BY TODYS.
Keywords:
Crash
Dcc:
Illness
Report
url:
Image
url:
Latitude:
42.3443228
Longitude:
-71.2053525
Location:
Case
number:
Date:
2019-10-15
Time:
10:54
Address:
73 LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV #1 was traveling southbound on Lexington St. just passing Rumford Ave. when the operator suffered a medical emergency and collided with the curb causing the passenger side tire to rupture. MV #1 then rolled forward slightly colliding into the rear bumper of MV #2 (unknown if it caused new damage). MV #2 was parked, unoccupied facing southbound on Lexington St. MV #1 was towed from the scene and the operator of MV #1 was transported to the hospital. The owner of MV #2 was made aware of the incident.
Keywords:
Hospital
Dcc:
Illness
Report
url:
Image
url:
Latitude:
42.3577593
Longitude:
-71.2398573
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);