crash_reports

1 row where keywords = "["Snow"]" and "retrieved" is on date 2021-11-16

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

2100000916

Date:

2021-11-08

Time:

10:51

Address:

JACKSON & WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of vehicle 1 stated he was on Washington St (eastbound) at a complete stop for the red light at Jackson Rd when he was struck from behind by vehicle 2. Operator of vehicle 2 stated she took a left turn off of Adams St on to Washington St then suddenly saw vehicle 1 stopped in front of her and rear ended him. Operator believes her snow tires are to blame because there was no snow on the road. Both vehicles were towed by Todys. Both operators were seen by medics and signed patient refusals.

Keywords:

Snow

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3549582

Longitude:

-71.1952442

Location:

Jackson Rd & Washington 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);