crash_reports

1 row where keywords contains "Ems" and speed_limit = 40

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

1900001211

Date:

2019-11-25

Time:

20:05

Address:

300 WASHINGTON ST

Speed limit:

40

Violation cited:

no

Narrative:

MV 1 was changing lanes northbound from the far left lane to the second lane when he rear ended MV 2. All air bags were deployed on all sides to MV 1 and it was towed away by Tody's due to it being disabled on a public way. MV 2 was traveling straight Northbound in the second lane when MV 1 rear ended him. MV 2 was towed due to it being disabled on a public way. Newton Fire Department responded with Cataldo ambulance due to air bags being deployed. There were no injuries to either party. Both parties were advised with crash report numbers.

Keywords:

Crash, Ems, Fire

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.3567319

Longitude:

-71.1859798

Location:

300 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);