crash_reports

1 row where "datetime" is on date 2021-09-02, dcc = "["Reckless driving"]" and intersection = 1

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

2100000661

Date:

2021-09-02

Time:

11:15

Address:

CENTRE ST & TYLER TER

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV#1 stated she was parked in a metered parking spot in the soutbound lane of Centre St just before Tyler Terrace. She left her vehicle at approximately 1115hrs. Upon returning to her vehicle at approximately 1300hrs there was damage to the entire driver side of the vehicle. It appears a white vehicle sideswiped her parked vehicle and left the scene causing moderate damage to the left back, left side, and left front mirror. The vehicle was able to be driven from the scene.

Keywords:

Moderate

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3324137

Longitude:

-71.194177

Location:

Tyler Terrace & Centre St, 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);