crash_reports

1 row where "datetime" is on date 2022-07-18, "retrieved" is on date 2022-07-26 and speed_limit = 35

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

22000644

Date:

2022-07-18

Time:

12:32

Address:

777 WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

Vehicle 1 was traveling in the left hand lane of the westbound side of Washington St when Vehicle 2 pulled out of a driveway and struck her rear passenger side. Vehicle 2 was pulling out of 777 Washing St and a large truck was parked in the right lane blocking her view as she exited. As she proceeded she struck the rear passenger side of vehicle 1. No reported injuries. No tows.

Keywords:

[]

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

 

Longitude:

 

Location:

None

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