crash_reports

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

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

22000393

Date:

2022-05-12

Time:

15:05

Address:

CRAFTS ST & NORTH ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 states he was traveling on North st and turning west on to Crafts Street when he sideswiped a traffic light pole, taking the pole down. No damage to MV1. Ofc Donahue took photos to submit to IT. Lights were placed on flash, city requested for stop signs and Dagle notified.

Keywords:

Pictures

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.35977

Longitude:

-71.2156285

Location:

North St & Crafts 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);