crash_reports

1 row where "datetime" is on date 2019-01-13, 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), dcc (array), dcc_code (array)

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

Case number:

1900000049

Date:

2019-01-13

Time:

17:55

Address:

1136 CHESTNUT ST

Speed limit:

25

Violation cited:

no

Narrative:

The operator of MV1 stated that she was traveling southbound on Chestnut street when she lost control of her vehicle causing the vehicle to jump the curb and run over a city speed limit sign breaking it at the base. The city was notified of the broken sign and pictures were taken and placed in ITs mailbox to be attached to the report. The vehicle sustained a right rear flat tire and was towed by AAA. All parties reported no injuries and signed a patient refusal.

Keywords:

Pictures, Speed

Dcc:

Over-steering

Report url:

report

Image url:

image

Latitude:

42.3103168

Longitude:

-71.2238119

Location:

1136 Chestnut 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);