crash_reports

1 row where "datetime" is on date 2020-06-27, dcc = "["Reckless driving"]" and intersection = 0

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

2000000348

Date:

2020-06-27

Time:

04:04

Address:

564 HAMMOND ST

Speed limit:

25

Violation cited:

yes

Narrative:

MV1 was travelling NB on Hammond St and crossed the southbound lane and drove off the side of the road and struck fire hydrant as shown in diagram. MV1 was towed from scene by Tody's towing. No injuries reported. MV1 operator was subsequently arrested for OUI. See incident report #20031376 for full narrative regarding this accident. Photos will be attached to the incident narrative. City was also notified of damaged hydrant.

Keywords:

Crash, Fire, Pictures

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.325196

Longitude:

-71.1646483

Location:

564 Hammond St, Chestnut Hill, MA 02467, 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);