crash_reports
3 rows where dcc = "["Followed too closely"]" and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-17
Time:
12:37
Address:
TREMONT ST & WAVERLEY AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
Oper # 1 admitted to rear ending Veh #2 who was stopped at the red light at Tremont (WB) @ Waverley. This caused both veh # 1 and Veh # 2 to rear end Vehicle # 3, who was also stopped at the red light. 3 tows by Tody's oper # 2 transported by medics (airbags) to St. Elizabeths Hospital Oper #3 signed refusal
Keywords:
Hospital
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3540073
Longitude:
-71.1790101
Location:
Case
number:
Date:
2022-06-22
Time:
10:57
Address:
WASHINGTON ST & 95 NORTH OFF RAMP
Speed
limit:
25
Violation
cited:
no
Narrative:
On 6/22/2022 at approx 1057Hrs while assigned to 497 i responded to Washington St at the 95N off ramp for a report of a two car crash. Upon arrival i spoke with the operators of Veh 1and Veh 2. Veh 1 was attempting to merge onto Washington St for the off ramp, stopped for an on coming car, Veh 2 ran into the back of Veh 1.
Keywords:
Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3553689
Longitude:
-71.1777858
Location:
Case
number:
Date:
2022-07-15
Time:
09:53
Address:
612 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV 1 WAS TRAVELING EAST ON WASHINGTON ST WHEN AN UNKNOWN MV TRAVELING IN THE OPPOSITE DIRECTION CROSSED THE DOUBLE YELLOW LINE INTO HIS LANE AND COMING RIGHT AT HIM. IN ORDER TO AVOID A POSSIBLE COLLISION MV 1 STEPPED ON THE BREAKS AND THAT IS WHEN MV 2 (WHO WAS TRAVELING BEHIND HIM) REAR ENDED HIS VEHICLE. DAMAGE SUSTAINED TO MV 1 AND NO INJURIES WERE REPORTED. MV 2 STATED THAT SHE WAS TRAVELING BEHIND MV 1 AND WHEN MV 1 STOPPED, SHE DIDN'T HAVE ENOUGH TIME TO REACT AND STRUCK HIS MV FROM BEHIND. DUE TO AIRBAG DEPLOYMENT IN MV 2, THE OPERATOR WAS EVALUATED BY MEDICS AND SIGNED A PATIENT REFUSAL. FRONT END DAMAGE SUSTAINED TO MV 2 AND THE VEHICLE WAS TOWED BY TODYS TO THEIR LOT.
Keywords:
Airbag
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3538657
Longitude:
-71.198379
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);