Data used for http://apps.washingtonpost.com/investigative/homicides/

The data can be read with three queries:

http://apps.washingtonpost.com/investigative/homicides/api/v1/victim/?limit=0&offset=0&format=json
http://apps.washingtonpost.com/investigative/homicides/api/v1/victim/?limit=1000&offset=0&format=json
http://apps.washingtonpost.com/investigative/homicides/api/v1/victim/?limit=2000&offset=0&format=json

Merged data is in dcmurders.json.

Read in as data frame with jsonlite::fromJSON.

Read in as nested list with jsonlite::read_json

A plossible place to start:

select(dcm, contains("name"), contains("date"), motive, manner, location)