crash_reports

1 row where "date" is on date 2019-02-12 and street1 = "NORTH 85 CHARLESBANK RD"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900000180

Date:

2019-02-12

Time:

21:32

Address:

85 CHARLESBANK RD

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 was travelling northbound on St James Street. As he approached the intersection of Charlesbank Rd, he began to brake to turn right. Due to the slippery snow and ice conditions, his brakes locked up and he skidded straight into the median in front of 85 Charlesbank Rd. The vehicle sustained major damage to the drivers side front axle, hood and under carriage. Operator of MV1 stated he was not injured and declined medical attention. He had called for a private tow. Tonys Towing responded to towed the vehicle.

Keywords:

Ice, Snow

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3588929

Longitude:

-71.1800115

Location:

85 Charlesbank Rd, Newton, MA 02458, 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);