crash_reports

1 row where "date" is on date 2021-02-17, keywords contains "Crash" and "retrieved" is on date 2021-03-01

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

2100000129

Date:

2021-02-17

Time:

14:14

Address:

38 ELLIS ST

Speed limit:

25

Violation cited:

no

Narrative:

Motor vehicle 1 (MV1) was traveling southbound on Ellis St. when the operator lost control of the vehicle, hit the curb and then crashed into a telephone pole in front of 38 Ellis St. As a result of the crash MV1 sustained significant front end damage. There did not appear to be any damage to the telephone pole, however, dispatch notified Eversource to come out to check the integrity of the pole. The Fallon medics responded to the scene, and the operator of MV1 signed a patient refusal. MV1 was towed by Todys.

Keywords:

Crash

Dcc:

Over-steering

Report url:

report

Image url:

image

Latitude:

42.3156373

Longitude:

-71.2264224

Location:

38 Ellis St, Newton, MA 02464, 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);