crash_reports

1 row where dcc = "["Lane departure"]", hit_run = 0 and "retrieved" is on date 2020-10-20

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

2000000586

Date:

2020-10-08

Time:

11:53

Address:

546 PARKER ST

Speed limit:

25

Violation cited:

no

Narrative:

THE OPER OF MV#1 WAS TRAVELLING SB ON PARKER ST (#546), WHEN HE COLLIDED WITH THE REAR OF MV#2 ( PARKED LANDSCAPE TRAILER). ONLOOKERS, FIRE AND MEDICS, ATTENDED TO THE DRIVER PRIOR TO MY ARRIVAL. THE OPERATOR APPEARED TO BE HAVING SOME SORT OF MEDICAL EPISODE (SEIZURE LIKE) AFTER THE CRASH. IT IS UNKNOWN IF THE PARTY WAS HAVING THE MEDICAL EPISODE PRIOR TO THE CRASH. MV1 WAS TOWED WITH FRONT END/WHEEL DAMAGE. THE OPERATOR WAS TRANSPORTED TO THE HOSPITAL.

Keywords:

Crash, Fire, Hospital

Dcc:

Lane departure

Report url:

report

Image url:

image

Latitude:

42.3089195

Longitude:

-71.197509

Location:

546 Parker St, Newton, MA 02459, 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);