home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where keywords contains "Crash" and "retrieved" is on date 2021-02-01

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, speed_limit, hit_run, violation_cited, keywords, 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:
2100000030
Date:
2021-01-21
Time:
04:39
Address:
438 LEXINGTON ST
Speed limit:
25
Violation cited:
yes
Narrative:
On 1/21/21 I was working N493 when I responded to the area 450 Lexington St for a report of damage to city property from an MVA. Upon arrival I observed a parking sign that had been broken in half, Parking Meters that had been ripped from the ground and completely smashed, and 1 MA reg plate 8AH567. The plate came back to 398 Wolcott St. where I spoke to Dylan Crook. Crook stated he had been driving MA reg 8ah567 when he crashed and then went home. Crook stated he was distracted and reaching down to get something when he went off the road. Crook was given Ma unifrom citation T2080020 for 90/24/C Leaving the scene of an accident with property damage, which was explained to him. The city responded to clean up debris. See incident report 21002985.
Keywords:
Citation, Crash, Distracted
Dcc:
Lane departure, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3472265
Longitude:
-71.2467688
Location:
438 Lexington St, Auburndale, MA 02466, USA
Case number:
2100000039
Date:
2021-01-22
Time:
08:17
Address:
101 GRANT AVE
Speed limit:
25
Violation cited:
no
Narrative:
On January 22, 2021 at approximately 08:17 hours I responded to a single motor vehicle crash in the area of Commonwealth Ave at Grant Ave. It was reported that a motor vehicle struck a tree and a fire hydrant. Upon arrival I spoke with MV1, who said that she was traveling southbound on Grant Ave when she saw a vehicle traveling northbound traveling close to the solid double line. MV 1 got nervous and swerved to the right causing her to jump the curb and strike a city tree. MV1 then reversed into a fire hydrant, causing it to become dislodged. Traffic Officer Ciccone responded and took pictures of the damages and Tody's removed the vehicle from the scene.
Keywords:
Crash, Fire, Pictures, Tree
Dcc:
Over-steering
Report url:
report
Image url:
image
Latitude:
42.3360899
Longitude:
-71.1863701
Location:
101 Grant Ave, Newton, MA 02459, USA
Case number:
2100000059
Date:
2021-01-27
Time:
12:19
Address:
275 CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
On 01/27/2021, while assigned to N491, I, Officer Conary, responded to the 275 Centre Street for a minor motor vehicle accident. Upon arrival, I was met by Operator of MV3, who stated that he was driving Northbound on Centre Street in the far right lane. MV2 began to enter his lane of traffic to take a right turn into Brigham and Women's. At this time, MV3 thought MV2 was going to hit him so MV3 hit parked MV1. I spoke with Operator of MV2 who stated that he was traveling Northbound on Centre Street in the left side lane. Operator of MV2 merged into the far right lane to take right turn. He stated he did not see MV3 nor did he hit anyone. Operator of MV3 confirmed that MV2 did not hit another vehicle. I spoke to the owners of MV1 and they stated that the damage was minor and that they did not want to contact insurance. There was minor damage to the left front bumper. Operator of MV3 wanted an accident report due to the minor damage on the right side of his vehicle. All parties involved were asked if they needed medical attention in which the declined. All motor vehicles were driven from scene without issue.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.358572
Longitude:
-71.185233
Location:
275 Centre St, Newton, MA 02458, USA
Case number:
2100000060
Date:
2021-01-27
Time:
12:29
Address:
239 WATERTOWN ST
Speed limit:
10
Violation cited:
no
Narrative:
ON 1-27-21 AT APPROX. 1229HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN ACCIDENT. UPON ARRIVAL AT 239 WASHINGTON ST. ( ST. JEANS HOUSING ).I SPOKE TO THE OWNER OF VEHICLE #1 ( MARIO SALVUCCI ). OWNER STATES SOMETIME BETWEEN 0800 AND 1229HRS. SOMEONE HIT THE REAR RIGHT QTR. PANEL OF HIS MOTOR VEHICLE WHILE IT WAS PARKED IN THE ST JEANS PARKING LOT. THERE WERE SCRAPES TO THE VEHICLES RIGHT REAR QTR. PANEL CONSISTENT WITH A VEHICLE THAT WAS BACKING OUT OF THE NEIGHBORING STALL. THERE WAS NO OTHER VEHICLE IN THE STALL AT THE TIME OF THIS REPORT. OWNER STATES HE BELIEVES HE KNOWS WHO WAS PARKED THERE AND IS GOING TO QUESTION HIM LATER THIS EVENING. OWNER REPORTS NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3616456
Longitude:
-71.1960462
Location:
239 Watertown St, Watertown, MA 02472, 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 331.041ms