crash_reports

1 row where "datetime" is on date 2022-04-26, intersection = 0 and "retrieved" is on date 2022-05-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

22000360

Date:

2022-04-26

Time:

14:50

Address:

191 DEDHAM ST

Speed limit:

25

Violation cited:

no

Narrative:

MV2 was parked behind unoccupied MV1 facing Northbound, when MV2 attempted to pull out onto Dedham St. The front right bumper of MV2 struck the left rear of MV1. Minor damage to both vehicles. No injuries or tows.

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3125048

Longitude:

-71.2025447

Location:

191 Dedham St, Newton Highlands, MA 02461, 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);