crash_reports

1 row where "datetime" is on date 2021-03-17 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:

2100000190

Date:

2021-03-17

Time:

15:13

Address:

147 LOWELL AVE

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 stated he as traveling northbound on Lowell Ave and as he was approaching 147 Lowell Ave, a car was coming in the opposite direction. There were cars parked legally on both sides of the road. As a MV was driving southbound, it had to cross double yellow to pass, Operator of MV1 moved over to the right and struck the parked MV2. Due to airbag deployment, I requested the medics. The operator of MV1 was transported to NWH. He appeared to be confused. The passenger in MV1 was not injured. MV1 was towed by Todys. MV2 was parked in a legal spot and called for a private tow.

Keywords:

Airbag

Dcc:

Over-steering

Report url:

report

Image url:

image

Latitude:

42.3522945

Longitude:

-71.210339

Location:

147 Lowell Ave, 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);