Person

Data for the person details 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).

person

Format

A data set with six variables: id, name, license_id, address_number, address_street_name and ssn.

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: person
head(person)
#> # A tibble: 6 x 6
#>      id name              license_id address_number address_street_name      ssn
#>   <int> <chr>                  <int>          <int> <chr>                  <int>
#> 1 10000 Christoper Peteu~     993845            624 Bankhall Ave          7.48e8
#> 2 10007 Kourtney Calderw~     861794           2791 Gustavus Blvd         4.78e8
#> 3 10010 Muoi Cary             385336            741 Northwestern Dr       8.29e8
#> 4 10016 Era Moselle           431897           1987 Wood Glade St         6.15e8
#> 5 10025 Trena Hornby          550890            276 Daws Hill Way         2.24e8
#> 6 10027 Antione Godbolt       439509           2431 Zelham Dr             4.92e8