crash_reports

1 row where "date" is on date 2019-02-03 and dcc_code = "[3]"

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

1900000140

Date:

2019-02-03

Time:

09:18

Address:

WASHINGTON ST & CENTRE AVE

Speed limit:

30

Violation cited:

no

Narrative:

OPERATOR #1 STATED HE WAS GOING N/B ON WASHINGTON ST WAS CROSSING THE INTERSECTION OF CENTRE AVE(GREEN LIGHT) VEHICLE#2 FAILED TO STOP FOR HIS RED LIGHT CAUSING THE CRASH. OPERATOR #2 STATED HE WAS GOING E/B ON CENTRE AVE HEADING TOWARDS THE MASS PIKE EAST WHEN HE DIDN'T REALIZE HIS LIGHT HAD TURNED RED WHEN HE WAS GOING THROUGH THE INTERSECTION OF WASHINGTON ST. HE THEN CRASHED INTO VEHICLE #1 IN THE INTERSECTION.

Keywords:

Crash

Dcc:

Signs/Signals

Report url:

report

Image url:

image

Latitude:

42.3557988

Longitude:

-71.1865324

Location:

Centre St & Washington St, Newton, MA 02458, 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);