home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Visibility obstructed" and latitude = "42.3469722"

✎ 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:
2000000330
Date:
2020-06-15
Time:
15:30
Address:
2040 COMMONWEALTH AVE
Speed limit:
30
Violation cited:
no
Narrative:
On 6/15/2020 at approximately 1540 hours, I responded to 2040 Commonwealth ave for a report of a two car accident. Upon arrival, I spoke with MV 1 who stated that he was reversing his tractor trailer into the shaws loading dock area when he struck MV2 with the backend of his cab. There is minimal damage and no injuries reported. I then spoke MV2 who stated that he was behind MV1 driving westbound on Commonwealth ave. He stopped to let the tractor trailer back into the loading dock. He realized he did not leave the trailer enough room to make the turn and that is when MV1 and MV2 struck. He reports no injuries and minor damage to his vehicle.
Keywords:
Crash
Dcc:
Followed too closely, Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
2040 Commonwealth Avenue, Auburndale, MA 02466, USA
Case number:
2100000627
Date:
2021-08-23
Time:
21:52
Address:
2040 COMMONWEALTH AVE
Speed limit:
5
Violation cited:
no
Narrative:
MV#1 Was dropping off a passenger from his Lyft vehicle when he struck a pole in the parking lot of the Star Market located at 2040 Commonwealth Ave. OPMV#1 Stated after he dropped the passenger off he attempted to drive away and didn't see the pole because it was in his blind spot. Vehicle was towed.
Keywords:
[]
Dcc:
Visibility obstructed, Inattention
Report url:
report
Image url:
image
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
2040 Commonwealth Avenue, Auburndale, MA 02466, 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 263.9ms