home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2019-01-19, intersection = 0 and keywords contains "Moderate"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000071
Date:
2019-01-19
Time:
18:30
Address:
423 LEXINGTON ST
Speed limit:
25
Violation cited:
yes
Narrative:
On 1/19/19 I responded to 25 Normandy Rd for a report of a past hit and run. I spoke with the Operator of MV#1 who stated the accident had taken place in front of Tom's Pizza, 423 Lexington St, at approximately 1830 hrs. Operator of MV#1 stated she parked her vehicle in a parking spot directly in front of the restaurant and went inside. When she returned approximately 5 minutes later she realized her vehicle had been rear ended. Two witnesses provided her with information about the accident and the plate number. (See witness narratives.) MV#1 suffered moderate damage to the rear and was driven from the scene. Waltham PD responded to the address listed for MV#2 and were not able to locate the vehicle. At approximately 2000 hrs, I was contacted at the police station by the owner of MV#2's wife. After further investigation (see incident report #19002425) it was determined that the operator of MV#2 at the time of the accident was the vehicle owner's brother. I spoke with Operator of MV#2 on the phone and he stated that the road was icy and slippery due to snow and he crashed into the back of MV#1. He stated he was nervous and thought he had only hit the sidewalk curb. Operator of MV#2 was issued citation T1440626 by mail for 90/24C Leaving the Scene of Property Damage, 90/10A Unlicensed Operation and 90/24 Use of MV Without Authority. He stated the vehicle suffered minor damage to the front.
Keywords:
Citation, Crash, Ice, Moderate, Phone, Snow
Dcc:
Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3473356
Longitude:
-71.2472474
Location:
423 Lexington St, Auburndale, MA 02466, USA
Case number:
1900000072
Date:
2019-01-19
Time:
19:13
Address:
173 GRANT AVE
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle #1 stated she was traveling south bound on Grant Ave. Vehicle #1 stated that in the area where Grant Ave. bends to the left the roadway is dark and she had trouble seeing the road. Vehicle #1 stated at the last second she saw the road bending left and attempted to turn but skid on the snow and struck a small boulder in the front lawn of 173 Grant Ave. moving the rock a few feet. Vehicle #1 then skidded and came to a stop in the middle of the lawn of 173 Grant Ave. Vehicle # 1 then pulled off the lawn and to the side of the road. The owner of the property of 173 Grant Ave. was also present and was notified of the accident. Vehicle #1 had moderate damage to the front of the vehicle but was still able to be driven and was driven home. Both the operator and passenger in Vehicle #1 stated they were uninjured in the accident and refused any medical treatment.
Keywords:
Crash, Moderate, Snow
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3340429
Longitude:
-71.1883194
Location:
173 Grant Ave, 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 300.423ms