crash_reports

1 row where "datetime" is on date 2019-08-07, intersection = 0 and keywords contains "Speed"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900000809

Date:

2019-08-07

Time:

07:13

Address:

1897 WASHINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

MV#1 was driving eastbound on washington st when the vehicle in front of him braked to turn left into the woodland golf course. He slowed his speed and stopped as he waited for them to turn. He then was rear-ended by MV#2 which was rear-ended by MV#3 Mv#2 states he was driving eastbound and had started to slow down for the vehicle turning left. MV# 2 was then rear-ended by MV#3 causing him to rear-end #1. MV#3 states he was driving eastbound and was slowing for the traffic. He then rear-ended Mv#2

Keywords:

Speed

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3365452

Longitude:

-71.2460112

Location:

1897 Washington St, Auburndale, 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);