crash_reports

1 row where date = "2021-11-18" and "retrieved" is on date 2021-11-22

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

2100000954

Date:

2021-11-18

Time:

16:34

Address:

BALLARD ST & CENTRE ST

Speed limit:

25

Violation cited:

no

Narrative:

Opr. of MV1 stated that he was traveling southbound on Centre Street when he was struck from the rear by MV2. Opr. of MV1 stated he was a little shaken up from the accident but his parents would take him to the hospital if need be. MV1 was not towed. MV1 suffered minor damage. Opr. of MV2 stated he was traveling southbound on Centre Street when he rear ended MV1. Opr. of MV2 stated he was looking at his cell phone when he struck MV2. MV2 was not towed. MV2 suffered minor damage. No injuries

Keywords:

Crash, Hospital, Phone

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3395841

Longitude:

-71.1927993

Location:

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