crash_reports

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

1900000974

Date:

2019-09-24

Time:

16:49

Address:

257 PEARL ST

Speed limit:

25

Violation cited:

no

Narrative:

On 09/24/2019 at 1649 hours, I responded to the area of 257 Pearl St for a two car MVA. Upon arrival I did not observe any damage to either vehicle. The passenger of MV1 was out of her vehicle yelling at the driver of MV2 and repeatedly walked back and forth between the vehicles confronting the driver of MV2. Both the driver of MV1 and MV2 stated that a vehicle backed out of a driveway in front of them. MV1 slowed down and MV2 rear ended MV1. No injuries were reported and Cataldo Ambulance received 3 patient refusals.

Keywords:

Ems, Walk

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3606984

Longitude:

-71.1963487

Location:

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