Social Network Online Activity of 100+ Users Over Two Years

This dataset contains a precise (error margin is within 5 seconds) activity log of 138 users recorded over a period of approximately two years. It includes users' log in/log off timestamps as well as a device id which was used during the session. An activity heat map is also provided which can be used to determine the online time (in seconds) in a given hour for a given user. The dataset is completely anonymized and is not linked to real peoples' accounts. Russian social network VK was used to record the data.

The database is provided in SQLite3 format. The data format is the following:

'sessions' table:

Column Name
Data Type
Description

user_id
TEXT
Unique user's identifier.

platform
INTEGER
Device identifier for the session (refer to the table below).

time_from
DATE
Timestamp of the session's start.

time_to
DATE
Timestamp of the session's end.

'map' table:

Column Name
Data Type
Description

user_id
TEXT
Unique user's identifier.

hour
INTEGER
Hour from the 1st Jan 1970 (Unix Epoch / 3600).

time
INTEGER
Accumulated online time in the hour (in seconds).

Device identifiers:

0
Unknown

1
Web on Mobile 

2
iPhone App

3
iPad App

4
Android App

5
Windows Phone App

6
Windows App

7
Web on Desktop

This dataset is associated with the VKWatcher independent research project. The code used to gather the information can be found on GitHub.