crash_reports

1 row where keywords contains "Walk" and "retrieved" is on date 2021-01-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:

2100000015

Date:

2021-01-08

Time:

16:28

Address:

141 NEEDHAM ST

Speed limit:

5

Violation cited:

no

Narrative:

On January 8, 2021 at approximately 16:28 hours I, Officer Guarino, responded to the parking lot of 141 Needham St for a report of a MVA hit and run. Upon arraival, I spoke with the operator of MV1, who showed me a dent on the front driver's side of her vehicle. There was minor scratches and no visible paint transfer around the dent. The vehicle was parked in a handicapped parking spot adjacent to a cross walk. The operator of MV1 said that she had washed the vehicle last week and had just noticed the dent when she exited the store and that she would have noticed the damage when she entered. There were no visible cameras in the area that would have footage of the incident.

Keywords:

Walk

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3131214

Longitude:

-71.212987

Location:

141 Needham St, Newton, MA 02464, 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);