crash_reports
3 rows where "datetime" is on date 2019-08-16 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-16
Time:
07:36
Address:
95 SPIERS RD
Speed
limit:
30
Violation
cited:
no
Narrative:
Leonardo Orlando was operating vehicle #1. Leo states that he backed out of 85 Spiers Rd and then started to Dr N/B. Leo states that he did not see vehicle #2 parked and he struck the unoccupied vehicle. Stephen May owns vehicle #2 and was inside the residence at the time of the crash. No injures vehicle #1 towed by Todys.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.2892253
Longitude:
-71.1848121
Location:
Case
number:
Date:
2019-08-16
Time:
09:15
Address:
CRAFTS ST & LINWOOD AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 8-16-19 AT APPROX. 0915HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF LINWOOD AND CRAFT I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING W- BOUND ON LINWOOD CROSSING OVER CRAFT ST. DRIVER STATES WHILE CROSSING CRAFT HE WAS HIT IN THE LEFT FRONT SIDE BY VEHICLE #2 WHO WAS TRAVELING E-BOUND ON LINWOOD AND WAS TRYING TO TURN LEFT ONTO CRAFT. VEHICLE #2 STATES HE WAS TRAVELING E-BOUND ON LINWOOD AND WAS STOPPED WAITING TO TURN N-BOUND ONTO CRAFT. DRIVER STATES HE THOUGHT VEHICLE #1 WAS ALLOWING HIM TO GO AND AS HE PROCEEDED VEHICLE #1 ENTERED THE TRAFFIC LANE AND HE WAS UNABLE TO AVOID HITTING HIM. VEHICLE #1 HAD EXTENSIVE LEFT FRONT END DAMAGE AND WAS TOWED BY AAA. VEHICLE #2 HAD MINOR FRONT END DAMAGE AND HIS VEHICLE WAS STILL OPERATIONAL. BOTH PARTIES REPORTED NO INJURIES. BOTH PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES.
Keywords:
Crash, Severe
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.358132
Longitude:
-71.21015
Location:
Case
number:
Date:
2019-08-16
Time:
18:40
Address:
DUNSTAN ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday, August 16th 2019, at approximately 6:40pm, I, Officer Brooks, responded to Dunstan street at Washington street for a MVA pedestrian. Upon my arrival I spoke with the operator of MV1(294NZ5), who stated she was traveling southbound on Dunstan street and was attempting to pull out onto Washington street, when she made contact with a bicyclist traveling westbound on Washington street. The operator stated she never saw the bicyclist, and that she was traveling less than a mile per hour when she made contact. It should be noted that the sun was setting and the operators vision would have been impaired by the sun at the location of the accident. MV1 had a minor scuff mark on the front bumper. I spoke with the bicyclist who stated he was traveling westbound on Washington street and was crossing over Dunstan street when he was struck by MV1. He stated he was knocked off the bike, scraped his arm, and had minor back pain. The mirror on the right side of his bike was broken. The bicyclist was wearing greenish gray clothing, and was not wearing protective equipment such as a helmet. The bicyclist signed a refusal from Cataldo and was given a copy of the report number. Pictures were taken of the scene and all parties were sent on their way.
Keywords:
Bike, Crash, Helmet, Impairment, Ped, Pictures, Solar
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3491797
Longitude:
-71.2222113
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);