crash_reports

1 row where "datetime" is on date 2022-06-25, intersection = 0 and keywords contains "Hospital"

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

22000568

Date:

2022-06-25

Time:

20:57

Address:

78 LEXINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was traveling southbound on Lexington Street. Operator of MV1 said she looked down to grab her phone and struck MV2. MV2 was unoccupied and parked legally in front of 78 Lexington Street. Operator of MV1 sustained a minor cut on the top of her head and was transported to Newton Wellesley Hospital by Fallon Medics. MV1 had damage to the front right bumper and was towed by Tody's. MV2 had damage done to the left rear bumper and was able to drive away from the scene.

Keywords:

Hospital, Phone

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3573578

Longitude:

-71.2395881

Location:

78 Lexington St, Auburndale, MA 02466, 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);