home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "date" is on date 2019-03-04, dcc contains "Unknown" and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000234
Date:
2019-03-04
Time:
18:07
Address:
1917 COMMONWEALTH AVE
Speed limit:
30
Violation cited:
no
Narrative:
Operator of MV#1 stated he was travelling westbound on Commonwealth Ave with his dog in the front seat when he slid on ice and off the roadway. The roadway was wet from previous snow fall but was very well plowed and sanded. MV#1 hit a curb, drove through a snowbank, hit a tree with the left front of his vehicle and then hit a pole with the right front side of his vehicle. The car then came to a rest in the median. The operator appeared confused by the accident and did not realize the extent of the damage to his car.He asked what he had hit. He continuously asked if it was driveable even though the entire front end was totaled. He was able to provide me with his license and all pertinent information but spoke in a slow manner. There was no odor of alcohol. Operator declined medical attention. When asked if he was on any medication he stated he was on heart medication. We were able to contact the operator's son who was transported to the scene and stated the operator had previously suffered a stroke. David Donahue arrived on scene towed the vehicle to Tody's. A licensed driver picked up the operator. A search of the immediate area yielded negative results for ice in the roadway. A request for Immediate Threat License Suspension/Revocation was filed.
Keywords:
Alcohol, Crash, Ice, Snow, Tree
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3453735
Longitude:
-71.2405313
Location:
1917 Commonwealth Avenue, Auburndale, MA 02466, USA
Case number:
1900000279
Date:
2019-03-04
Time:
11:00
Address:
25 OAK ST
Speed limit:
0
Violation cited:
no
Narrative:
On 03/12/2019, while assigned to WN, I, Officer Conary, met with DRAGAT, who wanted to report a motor vehicle accident have occurred on 03/04/2019. MV1 was parked behind 25 Oak Street in a parking stall. MV2 with a plow attached hit MV1 right rear bumper while plowing the snow. Witness, RAYMOND, asked the plow driver if they wanted MV1 moved before the accident and they said no. RAYMOND saw MV2 hit MV1. DRAGAT did not get the information from the operator or passenger of MV2. Operator of MV2 told her to contact the owner of the MV2, who was the operator's boss. DRAGAT said that she notified her insurance and the owner PADILLAGONZALES. DRAGAT said PADILLAGONZALES failed to give more information regarding the incident and DRAGAT's insurance advised her to file a police report. DRAGAT said that her insurance and PADILLAGONZALES's insurance have been in contact with one another. I attempted to call PADILLAGONZALES with negative results. DRAGAT is going to update her insurance. No further incident to report.
Keywords:
Crash, Snow
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3116238
Longitude:
-71.2215959
Location:
25 Oak St, Newton Upper Falls, MA 02464, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 291.91ms