crash_reports

1 row where "datetime" is on date 2019-08-22, dcc = "["Failed to yield"]" and intersection = 0

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

1900000865

Date:

2019-08-22

Time:

16:08

Address:

249 CENTRE ST

Speed limit:

30

Violation cited:

no

Narrative:

On Thursday 8/22/2019 at approx 1608hrs, while assigned to N-494, I responded to 249 Centre St in Newton for a 2 car MVA. Operator of MV1 states he was travelling straight on Centre St SB when MV2, entered his lane of traffic and struck the driver side of his vehicle. Operator of MV2 states that she was taking a left onto Centre St from the Sunoco gas station heading SB. She states that before entering traffic she saw no cars in the SB lane closest to her. She also states the operator of MV1 was distracted while talking to his wife.

Keywords:

Distracted, Solar

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3592861

Longitude:

-71.1856051

Location:

249 Centre St, Watertown, MA 02472, 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);