crash_reports

1 row where "datetime" is on date 2019-01-03 and street1 = "WEST AUBURNDALE AVE"

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

1900000009

Date:

2019-01-03

Time:

08:32

Address:

AUBURNDALE AVE & ROWE ST

Speed limit:

25

Violation cited:

no

Narrative:

Motor Vehicle 1 was traveling westbound on Aburndale Ave when it was struck in the rear drivers side by vehicle 2. Motor Vehicle 2 was stopped at the stop sign on Rowe St @ Auburndale Ave and proceeded to pull forward when it struck the rear drivers side of Motor Vehicle 1. Neither operators reported any injuries. Both vehicles only had very minor damage. No tows were required.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3501907

Longitude:

-71.2405242

Location:

Rowe St & Auburndale Ave, Newton, MA 02466, 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);