crash_reports

1 row where keywords = "["Pictures"]" and "retrieved" is on date 2021-04-12

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

2100000236

Date:

2021-04-06

Time:

12:20

Address:

HARVARD ST & NEWTONVILLE AVE

Speed limit:

25

Violation cited:

no

Narrative:

The reporting person(unknown) said that a truck with a crane on the back struck the mailbox and traffic lights at Harvard and Newtonville. The truck kept going towards Newton Corner. RP stated Indiana Plate 261934, didn't come back to anything. Dagle was called over a broken traffic light. USPS was called due to green mailbox being knocked over and opened. Postal worker responded to take possession of the mail. 526 took pictures.

Keywords:

Pictures

Dcc:

Lane departure

Report url:

report

Image url:

image

Latitude:

42.351149

Longitude:

-71.201654

Location:

Harvard St & Newtonville Ave, Newton, MA 02460, 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);