crash_reports

1 row where keywords contains "Walk" and "retrieved" is on date 2021-05-15

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

2100000337

Date:

2021-05-12

Time:

16:47

Address:

CENTRE ST & BEACON ST

Speed limit:

25

Violation cited:

no

Narrative:

The juvenile victim, Antonella Rizzo, states while walking in the crosswalk on Beacon Street she was struck by a black volvo suv, no model or plate given operated by a white female (MV1), running over both of her feet. Ms. Rizzo states the vehicle fled the scene traveling westbound on Beacon Street towards Walnut Street. Officers canvassed the area yielding negative results. Ms. Rizzo was evaluated by Fallon Medic 1 and obtained a patient refusal by an adult staff member, Alex Parker, at the group home where she resides.

Keywords:

Crosswalk, Walk

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3300268

Longitude:

-71.1948254

Location:

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