crash_reports

1 row where "datetime" is on date 2020-03-02, dcc contains "Physical impairment" and hit_run = 0

✎ 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:

2000000203

Date:

2020-03-02

Time:

01:31

Address:

BEACON ST & LANGLEY RD

Speed limit:

25

Violation cited:

yes

Narrative:

Vehicle #1 was traveling southbound on Langley Rd. and was attempting to turn left onto Beacon St. when they struck the traffic light pole on the traffic island. Vehicle #1 stated they don't remember hitting the traffic light post. Vehicle #1 had moderate damage to the front and front right of the vehicle and was unable to be driven. Vehicle #1 was towed by Tody's towing. Both the operator and passengers were asked if they were injured in the crash to which they stated they were not hurt and refused any medical treatment. This accident report is in regards to incident report #20011285. Please see incident report for further details.

Keywords:

Crash, Moderate

Dcc:

Reckless driving, Physical impairment

Report url:

report

Image url:

image

Latitude:

42.3304423

Longitude:

-71.1922769

Location:

Beacon St & Langley Rd, Newton, MA 02459, USA

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);