crash_reports

1 row where "date" is on date 2022-03-21, intersection = 0 and "retrieved" is on date 2022-04-04

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

22000239

Date:

2022-03-21

Time:

15:28

Address:

437 CHERRY ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 said she was traveling Southbound on Cherry Street and was slowly merging into the left turn lane. Operator of MV1 said MV2 exited the parking lot next to 437 Cherry Street and was attempting to turn Southbound onto Cherry Street and struck MV1. Operator of MV1 said MV2 left prior to my arrival and that they loosely exchanged information. There was minimal damage to the front passenger bumper of MV1. I attempted to contact the owner of MV2 numerous times yielding negative results. There were no injuries and both vehicles were able to drive away from the scene.

Keywords:

[]

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.349509

Longitude:

-71.2287428

Location:

437 Cherry St, Newton, MA 02465, 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);