crash_reports

1 row where date = "2019-03-05" and keywords contains "Walk"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900000238

Date:

2019-03-05

Time:

18:50

Address:

1296 WASHINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

On Tuesday, March 5th 2019, at 7pm, I, Officer Brooks, responded to 33 Walker street for a past hit and run. On my arrival I spoke with the operator of MV1(MA REG 28DG82), who stated his vehicle was struck at 3pm this afternoon in front of 1296 Washington street. His vehicle was alledgedly struck by a bus, unknown plate or company, that was traveling eastbound on Washington street. The bus casued the front drivers side quarter panel to be ripped from the vehicle. MV1 was towed by AAA.

Keywords:

Bus, Walk

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.348961

Longitude:

-71.226492

Location:

1296 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);