crash_reports

1 row where "date" is on date 2021-11-20, dcc = "["Unknown"]" and "retrieved" is on date 2021-11-29

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

2100000963

Date:

2021-11-20

Time:

19:41

Address:

3 BORDER ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was unoccupied and parked facing westbound on Border St. The owner of MV1 came out and noticed damage on the left rear of the vehicle. It appears as if an unknown MV struck the vehicle then left the area.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3493025

Longitude:

-71.2297173

Location:

3 Border St, Newton, MA 02465, 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);