crash_reports

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

1900000301

Date:

2019-03-19

Time:

16:03

Address:

CHURCH ST & WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

MV1 stated she was stopped on Washington St attempting to turn left onto Church St when she was rear ended by MV2 causing minor damage. MV1 did not require a tow, was evaluated and cleared by Cataldo Ambulance and departed the scene. MV2 stated she was "trying to get in the right lane but couldn't and when I came back I hit that car" causing minor damage. The operator of MV2 complained of pain to her head from striking the windshield and was transported by Cataldo to Newton Wellesley Hospital for an evaluation. Her vehicle was left parked legally on Washington St.

Keywords:

Ems, Hospital

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3558456

Longitude:

-71.1904222

Location:

Church St & Washington St, Newton, MA 02458, 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);