home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Inattention", "Unknown"]" and speed_limit = 10

✎ 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:
1900001177
Date:
2019-11-15
Time:
16:03
Address:
260 NEEDHAM ST
Speed limit:
10
Violation cited:
yes
Narrative:
OPMV#1 Was parked in the parking lot of Marshals located at 260 Needham St when she was attempting to exit her vehicle. When the OPMV#1 opened her car door, the door was struck by the OPMV#2. OPMV#1 Stated she was exiting her car and another vehicle wiped into the spot next to her. OPMV#2 Was attempting to pull into a parking spot in the Marshals parking lot located at 260 Needham St when she struck the left drivers side door of the OPMV#1. OPMV#2 Stated the person parked in the spot didn't even check to see if it was clear to open her car door before she pulled into her spot. OPMV#2 Was issued MA UNIFORM CITATION#T1442156 M.G.L. C.90 S.10 Unlicensed Operation. See INCIDENT REPORT#19049296.
Keywords:
Citation
Dcc:
Inattention, Unknown
Report url:
report
Image url:
image
Latitude:
42.3088013
Longitude:
-71.2144481
Location:
260 Needham St, Newton, MA 02461, USA
Case number:
22000072
Date:
2022-01-26
Time:
12:19
Address:
1250 WASHINGTON ST
Speed limit:
10
Violation cited:
no
Narrative:
ON 1-26-22 AT APPROX. 1219HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 1250 WASHINGTON ST. ( DUNKIN DONUTS PARKING LOT ) I SPOKE TO THE DRIVER OF VEHICLE #1. DRIVER STATES SHE WAS BACKING OUT OF HER PARKING STALL AND TURNING TO HEAD BACK TO WASHINGTON ST. SHE STATES VEHICLE #2 WOULD NOT MOVE AND SHE WAS UNABLE TO AVOID HITTING HER. VEHICLE #2 STATES SHE WAS IN THE PARKING LOT AND DID NOT GO INTO A STALL BECAUSE SHE WAS WATCHING HER SON WHO WAS IN DUNKIN DONUTS. SHE STATED SHE BEEPED AND TRIED TO GET VEHICLE #1 ATTENTION BUT SHE STILL BACKED INTO HER VEHICLE. VEHICLE #1 HAD NO DAMAGE. VEHICLE #2 HAD MINOR LEFT QTR. PANEL DAMAGE. BOTH VEHICLES WERE OPERATIONAL AND LEFT THE SCENE ON THEIR OWN. I CHECKED WITH DUNKIN DONUTS FOR THE VIDEO FOOTAGE OF THE PARKING LOT. EMPLOYEE COULD NOT GET THE VIDEO TO WORK. AS OF THIS WRITING FROM BOTH STATEMENTS IT IS UNCLEAR WHO WAS AT FAULT. WILL CHECK WITH THE MANAGER IN THE MORNING. CLEARED WITHOUT FURTHER INCIDENT. ON 2-1-22- AFTER SEVERAL ATTEMPTS TO GET THE VIDEO FOOTAGE FROM THE DUNKIN DONUTS ( 1250 WASHINGTON ST ) I WAS UNSUCCESSFUL SINCE THEY WERE STILL HAVING TECHNICAL DIFFICULTIES. AS A RESULT, WITH THE INFORMATION I HAD I FOUND DRIVER #1 RESPONSIBLE AND CLEARED THE AREA WITHOUT FURTHER INCIDENT.
Keywords:
Crash
Dcc:
Inattention, Unknown
Report url:
report
Image url:
image
Latitude:
42.3491465
Longitude:
-71.2248445
Location:
1250 Washington St, Newton, MA 02465, 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 314.313ms