crash_reports

1 row where "date" is on date 2019-03-24, intersection = 0 and keywords contains "Ems"

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

1900000314

Date:

2019-03-24

Time:

15:50

Address:

15 CYPRESS ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was stopped in traffic waiting to turn left into the Cypress St Municipal lot when she was struck from behind by MV2. Operator 2 states she did not see MV1 stopped and bumped her from behind. No injuries to eithier parties, Newton Ambulance 1 obtained medical refusals. MV1 sustained minor rear end damage and was driven from the scene. MV2 sustained minor front end damage and had to be towed due to air bad deployment.

Keywords:

Ems

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3285638

Longitude:

-71.1951188

Location:

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