crash_reports

1 row where "datetime" is on date 2019-01-02, 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), dcc_code (array)

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

Case number:

1900000006

Date:

2019-01-02

Time:

18:33

Address:

414 WATERTOWN ST

Speed limit:

25

Violation cited:

no

Narrative:

On 1/2/19 I was working N503 when I responded to Watertown St. at West St. for a report of an MVA hit and run. Upon arrival I met with Jennifer Nave who stated that she had rear ended a white colored SUV style vehicle in front of 414 Watertown St. Nave stated after she struck the vehicle she pulled over to the side of the road and the other vehicle drove away. Nave stated she was uninjured however had minor front end damage. Nave was unable to give any other description besides white SUV style vehicle.

Keywords:

[]

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.3597079

Longitude:

-71.2023358

Location:

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