crash_reports

1 row where "datetime" is on date 2022-07-15, intersection = 0 and keywords contains "Severe"

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

22000636

Date:

2022-07-15

Time:

17:32

Address:

514 LOWELL AVE

Speed limit:

25

Violation cited:

no

Narrative:

MV1 stated she was traveling southbound on Lowell Ave when she locked up the brakes and came to an abrupt stop due to a turkey coming into the roadway. MV2 was travelling southbound behind MV1 and his vehicle struck MV1 in the rear causing severe front end damage to his vehicle (MV2) and heavy damage to the rear of her vehicle (MV1). MV1 spoke with Fallon Ambulance and signed a patient refusal. MV1 did not require a tow. Both front seat airbags in MV2 deployed and required a tow. MV2 also spoke with Fallon Ambulance and signed a patient refusal.

Keywords:

Airbag, Ems, Severe

Dcc:

Followed too closely, Other improper action

Report url:

report

Image url:

image

Latitude:

 

Longitude:

 

Location:

None

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);