crash_reports

1 row where "datetime" is on date 2019-04-15 and speed_limit = 10

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900000380

Date:

2019-04-15

Time:

13:28

Address:

0 TROY LA

Speed limit:

10

Violation cited:

no

Narrative:

Mv#1 (truck) operator with Mv#2 (car trailer attached) was attempting to turn around on the dead end cul de sac on Troy Lane. The passenger side rear end of the trailer struck the vinyl fence abutting the back yard property owner of 41A Helene Rd. Damage appears minor to the end lower support post area and back yard birm between the fence and curbing.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.335877

Longitude:

-71.219654

Location:

Troy Ln, Newton, MA 02468, 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);