crash_reports

1 row where dcc = "["Reckless driving", "Other improper action"]", intersection = 0 and "retrieved" is on date 2022-03-21

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

22000228

Date:

2022-03-18

Time:

00:21

Address:

1255 WASHINGTON ST

Speed limit:

30

Violation cited:

yes

Narrative:

MV 1 was backing out of her parking spot when she backed onto the sidewalk and into a parking meter. The operator of MV1 (Ms. Pengwynne Blevins) sustained a possible neck injury and was transported to Newton Wellesley Hospital. MV 1 was towed for being on the sidewalk and no driver was available to pick it up. MV 1 sustained minor damage to the right front and right rear (few scratches). The passenger, Ms. Amanda Simeone, sustained no injuries and called an uber home. Pengwynne was issued citation T1445557 for OUI, Negligent operation of a motor vehicle, and marked lane violation. An immediate threat has been filled out and faxed over to the RMV.

Keywords:

Citation, Hospital

Dcc:

Reckless driving, Other improper action

Report url:

report

Image url:

image

Latitude:

42.349595

Longitude:

-71.2250448

Location:

1255 Washington 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);