crash_reports

1 row where "datetime" is on date 2019-04-06, intersection = 0 and keywords contains "Pictures"

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

1900000342

Date:

2019-04-06

Time:

01:44

Address:

16 PEMBROKE ST

Speed limit:

25

Violation cited:

no

Narrative:

No vehicle was observed in the area of the incident. It was observed that a 2 hour parking sign had been struck. Visible tire marks were on the sidewalk/ curb of Pembroke St. It was observed that the tire marks from the vehicle and the way the street sign fell that the vehicle was possibly traveling southbound on Pembroke St and crossed over to the left side of the roadway striking the sign. 3 pictures were taken at the scene and submitted to IT. City of Newton notified about damages.

Keywords:

Pictures

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3523201

Longitude:

-71.1769482

Location:

16 Pembroke St, Newton, MA 02458, 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);