crash_reports

1 row where "date" is on date 2022-03-01, keywords contains "Pictures" and speed_limit = 25

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

22000192

Date:

2022-03-01

Time:

10:35

Address:

308 HOMER

Speed limit:

25

Violation cited:

no

Narrative:

oper stated he was turning from Walnut St to Homer Street when his coffee spilled and lost control driving up the snow bank at 308 Homer Street. Vehicle also caused minor damage to city tree. When vehicle was towed away there was a fire hydrant that had been knocked out of place. No Injuries. Vehicle was towed by Tody's City notified about fire hydrant. Photos taken by traffic Officer Gaudet.

Keywords:

Fire, Pictures, Snow, Tree

Dcc:

Over-steering

Report url:

report

Image url:

image

Latitude:

42.3358364

Longitude:

-71.2067912

Location:

308 Homer St, Newton, MA 02459, 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);