crash_reports

1 row where date = "2022-06-04", "datetime" is on date 2022-06-04 and "retrieved" is on date 2022-06-17

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

22000487

Date:

2022-06-04

Time:

17:55

Address:

22 LANGLEY RD

Speed limit:

10

Violation cited:

no

Narrative:

The operator of MV1 was turning left exiting the parking lot at the rear of 22 Langley Rd onto Lyman St when she struck a fire hydrant and two concrete column's protecting the hydrant. MV1 sustained minor damage to the front drivers side fender and drivers door. Two concrete column's were knocked over as well as the hydrant being dislodged. The operator of MV1 was uninjured. MV1 was able to drive away from the scene. Photos of the damage to the vehicle as well as the hydrant and concrete column's were submitted to the IT Bureau. DPW was notified to replace the hydrant and concrete column's.

Keywords:

Fire, Pictures

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3311629

Longitude:

-71.1933552

Location:

22 Langley Rd, Newton Centre, 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);