crash_reports

1 row where keywords contains "Ped" and latitude = "42.3300068"

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

22000203

Date:

2022-03-04

Time:

12:22

Address:

BEACON ST & WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

THE OPERATOR OF MV 1 STATED SHE WAS TRAVELING WEST ON WASHINGTON TURNING ONTO BEACON ST AND DUE TO A PEDESTRIAN CROSSING THE STREET THAT SHE DIDN'T SEE, SHE SWERVED ONTO THE ISLAND AT THE INTERSECTION AND RAN OVER A CITY STREET SIGN. THE SIGN WAS WEDGED UNDERNEATH THE VEHICLE SO TODY'S RESPONDED AND FREED UP THE VEHICLE. TRAFFIC OFFICER IAROSSI TOOK PICTURES OF THE CRASH AND THE OPERATOR OF MV 1 CHOSE TO DRIVE THE VEHICLE HOME.

Keywords:

Crash, Ped, Pictures

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3300068

Longitude:

-71.2484874

Location:

Beacon St & Washington St, Newton, MA 02462, 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);