crash_reports

1 row where date = "2019-05-17", dcc contains "Inattention" and speed_limit = 15

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

1900000503

Date:

2019-05-17

Time:

19:24

Address:

165 NEEDHAM ST

Speed limit:

15

Violation cited:

no

Narrative:

Vehicle 1 parked in the parking lot at approximately 1830 hours, and the owner was shopping inside of Stop and Shop. When she returned at 1930 hours, she noticed that the left rear of the vehicle had a dent in it. It appeared that vehicle 2 backed into vehicle 1, and fled the scene. I spoke with the manager of Stop and Shop, and asked if I could view the surveillance footage of the accident. She stated that loss prevention needed to view it first, and that they would contact us after reviewing it.

Keywords:

Crash

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3121478

Longitude:

-71.2138224

Location:

165 Needham St, Newton, MA 02461, 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);