home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2019-02-03, intersection = 0 and "retrieved" is on date 2020-10-06

✎ 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:
1900000141
Date:
2019-02-03
Time:
14:57
Address:
33 AUSTIN ST
Speed limit:
15
Violation cited:
no
Narrative:
On 2/3/19, I was dispatched to 33 Austin St (Star Market) for an accident in the parking lot. On arrival I met with the operator of MV2 (MA Reg: 819VR6). MV2 stated that she was turning into the Star Market parking lot while someone was exiting the lot in the wrong direction. MV2 stated that due to the other vehicle going out the wrong way, she had to move over and collided with MV1. The operator of MV2 stated that her car came in contact with the drivers side front bumper of MV1. The operator of MV1 (MA Reg: 977GE4) was not on scene at the time of the accident. MV1 later arrived on scene and was appraised of what happened. MV1 was parked and unoccupied when it was hit by MV1. (cid:31)MV1 sustained damage to the passengers side. MV2 sustained damage to the front of the vehicle. Neither party was injured.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3498004
Longitude:
-71.2087985
Location:
33 Austin St, Newton, MA 02460, USA
Case number:
1900000143
Date:
2019-02-03
Time:
23:45
Address:
CHERRY ST
Speed limit:
30
Violation cited:
yes
Narrative:
On Sunday, February 3rd 2019, at approximately 11:45pm, I, Officer Brooks, responded to a single car MVA at the intersection of River street and Auburndale avenue. Upon arrival I observed MV1(MA REG 7TT558) in the travel lane with both tires broken free from the axle. I spoke with the operator who could not recall how the accident happened, or what was struck. After an investigation the operator was placed under arrest for 90/24 OUI Alcohol. Officer Boyle was able to assist in the accident investigation. It appears the operator had been traveling westbound on River street and struck a utility pole on the drivers side front tire. The vehicle continued to the intersection of River street and Auburndale avenue and struck a curb here on the passenger side tire. Both tires were broken free from the axles. The vehicle was towed by Tody's and an inventory form was filed. Eversource was notified about the pole.
Keywords:
Alcohol, Crash, Solar
Dcc:
Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3560826
Longitude:
-71.2279862
Location:
Cherry St, Newton, MA, 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 351.646ms