crash_reports

1 row where keywords contains "Pictures" and "retrieved" is on date 2022-05-31

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

22000447

Date:

2022-05-25

Time:

12:09

Address:

WALNUT ST & WATERTOWN ST

Speed limit:

25

Violation cited:

no

Narrative:

oper #1 stated he was turning right from Walnut onto Watertown Street when he took out the traffic lights on the corner. Dagle was contacted to fix light pole. Pictures taken and sent to IT. No damage to truck.

Keywords:

Pictures

Dcc:

Improper turn

Report url:

report

Image url:

image

Latitude:

42.3558631

Longitude:

-71.2090326

Location:

Watertown St & Walnut St, Newton, MA 02460, 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);