crash_reports

1 row where "datetime" is on date 2019-05-13, dcc = "["Reckless driving"]" and intersection = 1

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

1900000487

Date:

2019-05-13

Time:

20:23

Address:

CENTRE ST & COMMONWEALTH AVE

Speed limit:

 

Violation cited:

no

Narrative:

Operator of MV1 (Ma Reg 8DB266) stated while stopped on Centre street and Commonwealth Ave at the red light, MV2 rear ended her vehicle. Operator of MV2 (Ma Red 4YX377) stated he rear ended MV1. Both parties were not injured and MV1 had minor damage to rear trunk and bumper. MV2 had damage to the license plate. After further investigation Operator of MV#2 was arrested for OUI Liquor. MV2 was towed by Todys's,( see arrest report 19019005.)

Keywords:

[]

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3365124

Longitude:

-71.1932597

Location:

Commonwealth Avenue & 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);