crash_reports

1 row where "datetime" is on date 2019-06-24, dcc = "["Inattention"]" and keywords contains "Crash"

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

1900000649

Date:

2019-06-24

Time:

18:57

Address:

256 ALBEMARLE RD

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was pulling into a parking spot outside of 256 Albemarle Rd (The Gaff Pool) when she collided with a parked car to her right. MV2, the parked vehicle was backed into a parking spot when it was struck by MV1. There was damage to MV1 on the front passenger side wheel area and front bumper. There was no visual damage done to MV2. It appears that MV1 made impact directly on the tire of MV2. MV1 (MA Reg: 6NH473; 2015 Subaru Outback) was being operated by Zhuoyan Xie. MV2 (MA Reg: 5VL268; 2006 Jeep Liberty) was unoccupied.

Keywords:

Crash

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3576147

Longitude:

-71.2159572

Location:

256 Albemarle Rd, Newton, MA 02460, 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);