crash_reports

1 row where keywords = "["Pictures"]" and "retrieved" is on date 2021-03-05

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

2100000155

Date:

2021-03-01

Time:

05:54

Address:

CALIFORNIA ST & CRAFTS ST

Speed limit:

30

Violation cited:

no

Narrative:

Vehicle #1 a City of Newton Street Sweeper was traveling east on California St. at the intersection of California and Crafts when it stopped and reversed to go west in the east bound travel lane. At the same time Vehicle #2 was traveling south on Crafts St. and took a right turn to go east on California St. Once Vehicle #2 Made the turn onto California St. Vehicle #1 Reversed into its front end. Vehicle #1 sustained minor damage to its rear end. Vehicle #2 sustained minor damage to its front end. There were no injuries. Photos were taken of the damage and passed along to The Newton Police IT Bureau.

Keywords:

Pictures

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.359357

Longitude:

-71.212863

Location:

California St & Crafts St, Newton, MA 02460, 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);