Facebook checkin event

Data for the facebook checkin events 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).

facebook_event_checkin

Format

A data set with four variables: person_id, event_id, event_name and date.

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: facebook_event_checkin
head(facebook_event_checkin)
#> # A tibble: 6 x 4
#>   person_id event_id event_name                                             date
#>       <int>    <int> <chr>                                                 <int>
#> 1     28508     5880 "Nudists are people who wear one-button suits.\n"    2.02e7
#> 2     63713     3865 "but that's because it's the best book on anything~  2.02e7
#> 3     63713     3999 "        If Murphy's Law can go wrong, it will.\n"   2.02e7
#> 4     63713     6436 "Old programmers never die.  They just branch to a~  2.02e7
#> 5     82998     4470 "Help a swallow land at Capistrano.\n"               2.02e7
#> 6     82998     6186 "Good day to let down old friends who need help.\n"  2.02e7