crash_reports

1 row where "datetime" is on date 2020-06-17, dcc contains "Reckless driving" and speed_limit = 30

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

2000000332

Date:

2020-06-17

Time:

14:22

Address:

27 LINCOLN ST

Speed limit:

30

Violation cited:

no

Narrative:

Op Mv#2 came to the police station to report that she was parked on Lincoln Street, went to pick up food and discovered that her vehicle's left side bumper had been struck by an unknown MV. OpMV#1 stated she this was her first motor vehicle Collision and did not call the police to respond to the scene. She stated she discovered a slip with an illegible phone number written on it. Several attempts were made to contact the Op Mv#1to no avail. There were no injuries reported and neither vehicle was towed from the scene.

Keywords:

Phone

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3217805

Longitude:

-71.2072785

Location:

27 Lincoln St, Newton Highlands, 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);