crash_reports

1 row where "date" is on date 2020-09-13, intersection = 0 and keywords contains "Airbag"

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

2000000516

Date:

2020-09-13

Time:

17:27

Address:

47 BUNKER LA

Speed limit:

25

Violation cited:

no

Narrative:

On Sunday, September 13th 2020, at approximately 5:30pm, I, Officer Brooks, responded to 47 Bunker lane for a single car MVA into a tree. Upon my arrival I spoke with the owner of MV1(MA REG 667PG8), who stated he was teaching his daughter how to drive. He stated they were traveling northbound on Fairway drive, and upon turnng eastbound onto Bunker Lane his daughter hit the gas instead of the brake and accelerated into a tree. The car sustained heavy front end damage with airbag deployment. Cataldo responded and cleared with 2 patient refusals. The vehicle was towed by Tody's.

Keywords:

Airbag, Solar, Tree

Dcc:

Lane departure

Report url:

report

Image url:

image

Latitude:

42.3554128

Longitude:

-71.2172102

Location:

47 Bunker Ln, Newton, MA 02465, 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);