crash_reports

1 row where dcc_code = "["99"]" and speed_limit = 10

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900000004

Date:

2019-01-02

Time:

10:15

Address:

250 BROOKLINE ST

Speed limit:

10

Violation cited:

no

Narrative:

MV1 was parked in the corner spot in the center island of the parking lot. MV2 was turning right around the MV to approach the dumpster and misjudged the distance and struck MV1. MV2 is a Waste Management truck contracted by the City of Newton. I took pictures and they were TOT IT.

Keywords:

Pictures

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3020871

Longitude:

-71.177714

Location:

250 Brookline 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);