crash_reports

1 row where dcc = "["Failed to yield"]", keywords contains "Citation" and "retrieved" is on date 2022-04-23

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

22000294

Date:

2022-04-09

Time:

18:23

Address:

1211 CENTRE ST

Speed limit:

25

Violation cited:

yes

Narrative:

Operator of MV1 states he was traveling northbound on Centre Street when MV2 pulled out of a parking spot without yielding to oncoming traffic and struck MV1. MV1 sustained damage to the right side front and rear passenger doors. No injuries. Operator of MV2 states he was parked at a parking spot facing northbound on Centre Street when he attempted to pull out of the parking spot to make a U-Turn heading southbound on Centre Street, which is prohibited, and struck MV1. MV2 sustained damage to the front left fender. No injuries. The operator of MV2 was issued in hand Massachusetts Uniform Citation #T2012869 for Ch. 89 Sec. 8 Failure to yield (oncoming traffic).

Keywords:

Citation

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3313666

Longitude:

-71.1950428

Location:

1211 Centre St, Newton Centre, 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);