Data for the Fit Now checkins 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_check_in

Format

A data set with four variables: membership_id, check_in_date, check_in_time and check_out_time.

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_check_in head(get_fit_now_check_in)
#> # A tibble: 6 x 4 #> membership_id check_in_date check_in_time check_out_time #> <chr> <int> <int> <int> #> 1 NL318 20180212 329 365 #> 2 NL318 20170811 469 920 #> 3 NL318 20180429 506 554 #> 4 NL318 20180128 124 759 #> 5 NL318 20171027 418 1019 #> 6 NL318 20171018 608 1074