crash_reports
4 rows where date = "2021-06-11" and "retrieved" is on date 2021-06-14
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-11
Time:
08:27
Address:
2061 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of Motor Vehicle #1 stated that she was exiting the Newton Wellesley Hospital West entrance and was taking a right turn Eastbound onto Washington Street and did not see motor vehicle # 2. Motor vehicle #1 struck motor vehicle #2 at the rear passenger side door and rear passengers side quarter panel causing moderate damage. Motor vehicle # 1 sustained moderate front end damage. Operator of Motor Vehicle #2 stated that she was traveling Eastbound on Washington Street and was struck by motor vehicle #1 as she was attempting to turn on Washington Street. All parties signed a medical refusal forms and reported no injuries. All units cleared without further incident.
Keywords:
Hospital, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3307823
Longitude:
-71.2483328
Location:
Case
number:
Date:
2021-06-11
Time:
09:20
Address:
CRAFTS ST & NORTH ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 6-11-21 AT APPROX. 0920HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN PROPERTY DAMAGE. UPON ARRIVAL AT THE INTERSECTION OF CRAFT AND NORTH ST. I NOTICED THAT THE TRAFFIC SIGNAL POLE HAD BEEN KNOCKED DOWN. REPORTING PARTY STATED THAT AN UNIDENTIFIABLE MOVING TRUCK HAD TAKEN A RIGHT TURN FROM NORTH ONTO CRAFT AND TOOK THE POLE DOWN. MOVING TRUCK WAS NO LONGER IN THE AREA. DAEGLE WAS NOTIFIED TO RESET THE TRAFFIC SIGNAL POLE. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.35977
Longitude:
-71.2156285
Location:
Case
number:
Date:
2021-06-11
Time:
15:19
Address:
129 ROWE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was travelling westbound on Rowe St. Operator 1 had a medical emergency, possibly a diabetic issue. Operator 1 lost control of the vehicle, and crashed into Eversource pole 385/15. Operator 1 was transported to NWH by Newton Medic 2, with minor injuries. I observed heavy damage to the front left of vehicle 1. Vehicle 1 was towed by Tody's to their lot. Eversource was notified to fix the pole, and arrived on scene.
Keywords:
Crash
Dcc:
Physical impairment
Report
url:
Image
url:
Latitude:
42.3478911
Longitude:
-71.2428969
Location:
Case
number:
Date:
2021-06-11
Time:
13:47
Address:
WASHINGTON TER & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of V1 stated she was traveling east on Washington Street, turned left onto Washington Terr and had contact with V2. Operator of V2 stated she just pulled out of the parking space on the westbound lane of Washington Street she was traveling straight and V1 turned into her vehicle. All parties advised of the process, and there were no reported injuries.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3512902
Longitude:
-71.2091542
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);