crash_reports

1 row where dcc contains "Other improper action", intersection = 0 and "retrieved" is on date 2020-10-14

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

2000000571

Date:

2020-10-01

Time:

12:18

Address:

260 NEEDHAM ST (LOT)

Speed limit:

5

Violation cited:

no

Narrative:

OPER OF MV1, WAS PULLING INTO A PARKING SPOT OF #260 NEEDHAM ST, AND CONTINUED THROUGH THE SPOT STRIKING A LIGHT POLE. OPER OF MV1 STATED THAT SHE AND THE VEHICLE DID NOT BREAK IN TIME. THE POLE WAS KNOCKED TO THE GROUND. MV1 SUSTAINED MINOR FRONT DAMAGE. POLE OWNED BY NORTHLAND GROUP.

Keywords:

[]

Dcc:

Other improper action

Report url:

report

Image url:

image

Latitude:

42.3088013

Longitude:

-71.2144481

Location:

260 Needham St, Newton, MA 02461, 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);