crash_reports

1 row where "datetime" is on date 2020-09-26 and dcc = "["Signs/Signals", "Inattention"]"

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

2000000556

Date:

2020-09-26

Time:

11:31

Address:

AUBURN ST & GROVE ST

Speed limit:

30

Violation cited:

yes

Narrative:

MV1 stated he was travelling straight on Auburn St when MV2 "ran the red light and I hit him" causing front end damage. No injuries reported or tow required. MV2 stated he just "wasn't paying attention and ran the light" causing drivers side damage. No injuries reported or tow required. Operator was cited for failure to stop @ red light.

Keywords:

Citation

Dcc:

Signs/Signals, Inattention

Report url:

report

Image url:

image

Latitude:

42.3458561

Longitude:

-71.2465491

Location:

Auburn St & Grove St, Newton, MA 02466, 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);