crash_reports

1 row where "datetime" is on date 2020-10-05, intersection = 0 and "retrieved" is on date 2020-10-14

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

2000000576

Date:

2020-10-05

Time:

12:53

Address:

1763 COMMONWEALTH AVE

Speed limit:

25

Violation cited:

no

Narrative:

On 10/05/20 Sgt Giardina notified me that he was flagged down by a person who wished to remain anonymous that stated they had seen a niisan maxima strike a tree and two trash barrels in front of 1763 Commonwealth Ave. On arrival I saw two City of Newton trash barrels destroyed and a city tree down on its side on the sidewalk. There were skid marks going back out onto the road westbound on Commonwealth Ave. I was able to notify the homeowner, Melissa Woythaoer who stated she was upstairs and never heard anything. Units canvassed the area with negative results. Officer Gaudet took pictures of the damage.

Keywords:

Pictures, Tree

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.341503

Longitude:

-71.2385206

Location:

1763 Commonwealth Avenue, Auburndale, MA 02466, 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);