crash_reports

1 row where date = "2021-12-23", keywords contains "Citation" and latitude = "42.3553475"

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

2100001079

Date:

2021-12-23

Time:

21:54

Address:

135 RANDLETT PK

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was traveling westbound on Randlett Park and struck MV2 which was parked in front of 135 Randlett Park. There was damage to the front passenger side of MV1 and there was damage to the driver side front and rear bumper along with damage to both doors on the driver side. Operator of MV1 admitted to texting and driving. Both MV1 and MV2 were towed away from the scene and operator of MV1 was handed Massachusetts Uniformed Citation T1446550 in hand. Fallon Medics arrived on scene and operator of MV1 signed a patient refusal. MV1 was revoked for insurance I mailed Massachusetts Uniform Citation T1446551 to Jason Markle at 25 Linnet Street, West Roxbury. Jason Markle is the registered owner of MV1.

Keywords:

Citation, Phone

Dcc:

Distracted

Report url:

report

Image url:

image

Latitude:

42.3553475

Longitude:

-71.2221992

Location:

135 Randlett Park, West 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);