crash_reports

1 row where date = "2020-01-03", dcc contains "Visibility obstructed" and speed_limit = 25

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

2000000008

Date:

2020-01-03

Time:

11:26

Address:

SUMNER ST & WILLOW ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator 1 states she was backing into a parking spot at Sumner St @ Willow St. While backing up she struck a City Of Newton parking meter knocking it to the ground. There was minor damage to the meter and to the vehicle. There were no injuries. Photos of the scene were taken and sent to IT.

Keywords:

Pictures

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3318937

Longitude:

-71.1921686

Location:

Willow St & Sumner St, Newton, MA 02459, 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);