crash_reports

1 row where "datetime" is on date 2019-05-04, dcc contains "Followed too closely" and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900000453

Date:

2019-05-04

Time:

15:54

Address:

203 ADAMS ST

Speed limit:

25

Violation cited:

no

Narrative:

The owner of Vehicle #1, Ms. Africa Perkins wished to report that a vehicle had parked closely behind her vehicle, and possibly made contact with her bumper. The Vehicle in question came back to a Mr. Anthony Pellegrini. Mr. Pellegrini was located, and agreed to come back and move his vehicle so that Ms. Perkins could inspect her vehicle. Ms. Perkins, and Mr. Pellegrini inspected their vehicles, and agreed that there was no damage to report. Both parties requested this report be generated in order to document this.

Keywords:

[]

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.3580149

Longitude:

-71.2000153

Location:

203 Adams St, Newton, MA 02458, 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);