crash_reports

1 row where dcc contains "Unknown", "retrieved" is on date 2021-01-29 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:

2100000044

Date:

2021-01-25

Time:

13:30

Address:

33 BOYLSTON ST

Speed limit:

15

Violation cited:

no

Narrative:

On Monday, 1/25/21, RYAN, Tim came to NPD headquarters to report a past hit and run. He stated his white 2015 Nissan work van, RI commercial reg 62477 (MV1), was struck by an unknown vehicle (MV2), while parked in the parking lot of 33 Boylston St. This occurred today at approximately 1330-1400 hrs, and the MV1 sustained a minor scratch and dent to the rear driver's side. RYAN stated there had been a white van next to him at the time he parked but was unable to provide any further information.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3227864

Longitude:

-71.1687194

Location:

33 Boylston St, Chestnut Hill, MA 02467, 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);