crash_reports

1 row where keywords = "["Pictures"]" and "retrieved" is on date 2022-01-21

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

22000052

Date:

2022-01-17

Time:

06:11

Address:

260 CONCORD ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 states he was traveling south on Concord Street and attempted to stop for the red light at Washington Street when MV1 would not stop. MV1 slid across Concord Street, striking a City of Newton no parking sign pole and the wall in front of 260 Concord Street. City notified to replace/repair sign pole. Photos taken and submitted to IT. Operator of MV1 evaluated by the medics and signed a refusal. Todys towed MV1.

Keywords:

Pictures

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3258685

Longitude:

-71.2577001

Location:

260 Concord St, Newton, MA 02462, 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);