crash_reports

1 row where "datetime" is on date 2021-01-26 and dcc_code = "[99]"

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

2100000047

Date:

2021-01-26

Time:

11:09

Address:

CENTRE ST & COTTON ST

Speed limit:

35

Violation cited:

no

Narrative:

Operator # 1 stated she had stopped at the stop sign on Cotton Street and Centre Street. She saw that Centre Street was clear and she turned left onto Centre Street. She then stated that Vehicle # 2 "came out of nowhere" and didn't slow down before the crash. She believed vehicle # 2 was speeding. Oper # 2 stated she was travelling NB on Centre Street when vehicle # 1 pulled out in front of her from Cotton Street. Both vehicles towed by Todys. Operators 1 and 2 signed refusals. passenger 1 and 2 had been picked up prior to being evaluated.

Keywords:

Crash, Speed

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3414924

Longitude:

-71.192219

Location:

Cotton St & Centre 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);