Data for the Fit Now members 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).

get_fit_now_member

Format

A data set with five variables: id, person_id, name, membership_start_date and membership_status.

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: get_fit_now_member head(get_fit_now_member)
#> # A tibble: 6 x 5 #> id person_id name membership_start_date membership_status #> <chr> <int> <chr> <int> <chr> #> 1 NL318 65076 Everette Koepke 20170926 gold #> 2 AOE21 39426 Noe Locascio 20171005 regular #> 3 2PN28 63823 Jeromy Heitschmidt 20180215 silver #> 4 0YJ24 80651 Waneta Wellard 20171206 gold #> 5 3A08L 32858 Mei Bianchin 20170401 silver #> 6 6W6I2 69510 Paris Accurso 20170613 regular