Crime scene report

Data for the crime scene as per the SQL Murder (http://mystery.knightlab.com/walkthrough.html) and here (https://github.com/NUKnightLab/sql-mysteries). Simon Willison made an online version of the SQL game (https://sql-murder-mystery.datasette.io/sql-murder-mystery).

crime_scene_report

Format

A data set with four variables: date, type, description and city.

date: Incident date of form `YYYYMMDD`
type: Incident type category - robbery, murder etc.
description: More verbose description of crime
city: Where did the incident occur?

Details

How to play the game ....

This package makes the data of the SQL Murder Mystery available in R.

There's been a Murder in SQL City! The Murder Mystery is designed to be both a self-directed lesson to learn R concepts and is also a fun game for experienced R users to solve an intriguing crime. Please read the Readme file for the details!

Examples

# Load a bit of the dataset: crime_scene_report
head(crime_scene_report)
#> # A tibble: 6 x 4
#>       date type    description                                           city   
#>      <int> <chr>   <chr>                                                 <chr>  
#> 1 20180115 robbery A Man Dressed as Spider-Man Is on a Robbery Spree     NYC    
#> 2 20180115 murder  Life? Dont talk to me about life.                     Albany 
#> 3 20180115 murder  Mama, I killed a man, put a gun against his head...   Reno   
#> 4 20180215 murder  REDACTED REDACTED REDACTED                            SQL Ci~
#> 5 20180215 murder  Someone killed the guard! He took an arrow to the kn~ SQL Ci~
#> 6 20180115 theft   Big Bully stole my lunch money!                       Chicago

Format

Details

Examples

Contents