home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Signs/Signals", "Lane departure"]", dcc contains "Lane departure" 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:
1900000522
Date:
2019-05-22
Time:
06:53
Address:
ALBEMARLE RD & CRAFTS ST
Speed limit:
30
Violation cited:
yes
Narrative:
On Wednesday, May 22nd 2019, at approximately 6:53am, I, Officer Brooks, responded to Crafts street at Albemarle road for a report of a 2 car MVA. Upon my arrival I spoke with the operator of MV1(MA REG 9MJ713 ), who stated he was traveling northbound on Albemarle road. He stated he stopped at the stop sign at the intersection with Crafts street, and traffic traveling Eastbound on Crafts street stopped to let him cross over Crafts street and continue on Albemarle road. As he proceeded through the stop sign, he was struck on the drivers side front end by MV2(MA REG 7HJ262), which had crossed over the center line of Crafts street traveling Eastbound, passing the cars which had stopped to let MV1 out. MV1 had damage to the drivers side front quarter panel and front bumper. The operator was not injured. I then spoke with the operator of MV2 who stated she was traveling Eastbound on Crafts street, and was attempting to take a left hand turn onto North street, so she was driving in the center lane. The center lane the operator is referring to is actually a left hand turn lane for vehicles traveling Westbound on Crafts street for vehicles who wish to turn onto Albemarle road. There is no right of way in that center lane for vehicles traveling Eastbound. MV2 had damage to the passenger side front quarter panel. The operator was uninjured. The operator of MV2 was issued a citation in hand for 89/4A Marked lanes violation. She notified AAA for a tow. MV1 was towed by Tody's. Both operators were provided the crash report number.
Keywords:
Citation, Crash
Dcc:
Signs/Signals, Lane departure
Report url:
report
Image url:
image
Latitude:
42.3598454
Longitude:
-71.2170818
Location:
Crafts St & Albemarle Rd, Newton, MA 02460, USA
Case number:
1900000598
Date:
2019-06-10
Time:
07:22
Address:
1126 CENTRE ST
Speed limit:
30
Violation cited:
yes
Narrative:
VEHICLE #1 WAS TRAVELING STRAIGHT AHEAD ON CENTRE ST, HEADING NORTHBOUND. VEHICLE #2 WAS ALSO ON CENTRE ST, HEADING NORTHBOUND. AS BOTH VEHICLES PASSED BY WILLOW ST, VEHICLE #2, WHO WAS IN THE RIGHT LANE, TRIED TO PASS VEHICLE #1 ON THE RIGHT, WHEN VEHICLE #2 TRIED TO GET IN FRONT OF VEHICLE #1 IT STRUCK THAT VEHICLE, WHICH WAS A COMMERCIAL TRUCK. OPERATOR OF VEHICLE #1 STATED THAT HE NEVER SAW VEHICLE #2. NO INJURIES REPORTED. OFF DUTY NEWTON POLICE OFFICER LAU WITNESSED THE ACCIDENT, WHO WAS STOPPED ON WILLOW ST @ CENTRE ST AND NOTICED VEHICLE #2 TRY TO PASS VEHICLE #1 ON THE RIGHT. VEHICLE #2 OPERATOR WILL BE ISSUED CITATION #T0645460 BY MAIL FOR IMPROPER PASSING AND MARKED LANES VIOLATION.
Keywords:
Citation, Crash
Dcc:
Signs/Signals, Lane departure
Report url:
report
Image url:
image
Latitude:
42.3337491
Longitude:
-71.1932117
Location:
1126 Centre St, Newton, MA 02459, 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 305.463ms