crash_reports

1 row where dcc contains "Unknown", "retrieved" is on date 2021-11-12 and speed_limit = 15

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2100000882

Date:

2021-10-30

Time:

14:24

Address:

165 NEEDHAM ST

Speed limit:

15

Violation cited:

no

Narrative:

The owner of MV1 stated she went into Stop and Shop at 1350 hrs and when she came back outside to her vehicle at 1408 hrs, her vehicle had been hit on the rear driver side. Her vehicle was parked, facing southbound. There was minor damage to the rear driver side of the bumper. Unknown who had struck her vehicle.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3121478

Longitude:

-71.2138224

Location:

165 Needham 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);