crash_reports

1 row where keywords = "["Pictures"]" and "retrieved" is on date 2021-07-04

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

2100000459

Date:

2021-06-23

Time:

09:22

Address:

1314 CENTRE ST

Speed limit:

5

Violation cited:

no

Narrative:

On Wednesday 6/23/21 at approx 0922hrs, while assigned to N495, I responded to 1314 Centre St, Holly's Cleaners, for a single car MVA into a building. There I met the operator of MV1, Ellen Silver, who stated she was just pulling into the parking lot when she stepped on the brakes but the car did not stop. MV1 made contact with the building damaging a wall and breaking a window. Newton City Inspector Jeff Johnson arrived on scene and deemed the building to be safe. Medics evaluated the operator who signed a refusal. Pictures were taken by Off. Wilson. Vehicle was towed by Tody's.

Keywords:

Pictures

Dcc:

Lane departure

Report url:

report

Image url:

image

Latitude:

42.3286696

Longitude:

-71.1953045

Location:

1314 Centre St, 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);