crash_reports

1 row where intersection = 0, keywords contains "Airbag" and "retrieved" is on date 2021-05-24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)

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

Case number:

2100000366

Date:

2021-05-20

Time:

19:12

Address:

RIVER ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was driving westbound on River St when he nicked the curb at the intersection of Henshaw St and blew both passenger side tires. He lost control of the vehicle when the tires blew and his vehicle laid to rest on the eastbound lane. Front airbags deployed. Operator, David English signed a refusal with the medics. MV1 was towed by Tody's towing.

Keywords:

Airbag

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3539632

Longitude:

-71.2335722

Location:

River St, Newton, MA, 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);