home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2019-01-19, intersection = 0 and keywords contains "Phone"

✎ 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

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 335.567ms