crash_reports

1 row where "date" is on date 2021-09-14 and geocoded_address = "141 Needham St, Newton, MA 02464, USA"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2100000699

Date:

2021-09-14

Time:

11:31

Address:

141 NEEDHAM ST

Speed limit:

15

Violation cited:

no

Narrative:

The owner of veh #1 stated she parked her vehicle in the parking lot of #141 Needham St (Sierra Trading Post & T.J. Maxx) at approximately 11:00. When she returned around 11:30, she noticed her rear drivers side quarter panel had been struck by a white vehicle. It appears the other vehicle struck her car as it was either pulling in or out of the parking space. I searched the lot for the other vehicle but was unable to locate it. I then went inside the Sierra Trading Post and spoke with the manager regarding security cameras. He stated that neither his store nor T.J. Maxx had cameras facing the parking lot.

Keywords:

[]

Dcc:

[]

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);