crash_reports

1 row where "date" is on date 2021-03-12, dcc contains "Visibility obstructed" and speed_limit = 15

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2100000175

Date:

2021-03-12

Time:

15:46

Address:

1321 WASHINGTON ST

Speed limit:

15

Violation cited:

no

Narrative:

Operator 1 was backing into a parking space behind 1321 Washington St when she struck unoccupied cruiser 492. Minor damage to the rear drivers quarter panel of N492. Minor damage to the rear passenger quarter panel of N526. No injuries reported, both vehicles were able to be driven from the scene.

Keywords:

[]

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3494467

Longitude:

-71.2276058

Location:

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