crash_reports

1 row where "date" is on date 2021-06-14 and dcc = "["Failed to yield", "Inattention"]"

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

2100000429

Date:

2021-06-14

Time:

18:25

Address:

BEETHOVEN AVE & WOODWARD ST

Speed limit:

35

Violation cited:

no

Narrative:

Operator of MV1 said he was traveling Eastbound on Woodward Street and was struck on the rear driver side by MV2. Operator of MV2 said she was stopped at the stop side on Beethoven Ave and proceeded prematurely and struck MV1. Both parties exchanged information and there were no injuries. There was damage done to the rear driver side of MV1. There was damage done to the front driver side of MV2. Both parties made their own arrangements to remove their respective vehicles.

Keywords:

[]

Dcc:

Failed to yield, Inattention

Report url:

report

Image url:

image

Latitude:

42.3232389

Longitude:

-71.2210598

Location:

Beethoven Ave & Woodward St, Newton, MA 02468, 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);