crash_reports

1 row where "datetime" is on date 2019-05-22, 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:

1900000523

Date:

2019-05-22

Time:

20:06

Address:

230 COMMONWEALTH AVE

Speed limit:

30

Violation cited:

no

Narrative:

Operator 1 stated that he was driving eastbound on Commonwealth Ave in the right lane. He stated that operator 2 had driven into the side of his truck out of nowhere. He reported no injuries and the truck had minor damage. Operator 2 stated that he was driving eastbound on Commonwealth ave and had thought the truck was pulling into the first entrance to the Speedway and he merged over in the left lane to enter in the second entrance. The truck had continued straight and had not turned. No injuries reported and operator 2 vehicle was towed by Triple A

Keywords:

Speed

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3370323

Longitude:

-71.1751383

Location:

230 Commonwealth Avenue, Chestnut Hill, MA 02467, 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);