Dataset: Sport Services Dataset

About this Dataset

Sport Services Dataset

Context

This dataset corresponds to actual data from the functioning of a sports facility and refers to all new users who signed up between June 1st 2014 and October 31st 2019.
Demographic and service level agreement (SLA) data is collected by operators in the process of enrolling users in the activities they intend to practice.
The data regarding the frequency of the sports facility and classes were obtained by the access control system where each user identifies himself with an RFID card to access the facilities on the days and times agreed in his SLA.

Acknowledgements

Pinheiro, Paulo; Cavique, Luis (2020), “Sport Services Dataset”, Mendeley Data, V1, doi: 10.17632/yprk4jdgnv.1

Tables

Dadosv3

@kaggle.saurabhshahane_sport_services_dataset.dadosv3

1.22 MB
14942 rows
47 columns


CREATE TABLE dadosv3 (
  "id" VARCHAR,
  "age" BIGINT,
  "ageclass" VARCHAR,
  "gender" VARCHAR,
  "enrollmentstart" TIMESTAMP,
  "enrollmentfinish" TIMESTAMP,
  "enrollmentduration" BIGINT,
  "enrollmentdurationclass1" BIGINT,
  "enrollmentdurationclass2" VARCHAR,
  "lastperiodstart" TIMESTAMP,
  "lastperiodfinish" TIMESTAMP,
  "datelastvisit" TIMESTAMP,
  "dayswithoutfrequency" BIGINT,
  "dayswithoutfrequencyclass1" BIGINT,
  "dayswithoutfrequencyclass2" VARCHAR,
  "lifetimevalue" DOUBLE,
  "lifetimevalueclass1" BIGINT,
  "averagefrequency" DOUBLE,
  "averagefrequencyclass1" BIGINT,
  "averagefrequencyclass2" VARCHAR,
  "usebytime" BIGINT,
  "athleticsactivities" BIGINT,
  "wateractivities" BIGINT,
  "fitnessactivities" BIGINT,
  "danceactivities" BIGINT,
  "teamactivities" BIGINT,
  "racketactivities" BIGINT,
  "combatactivities" BIGINT,
  "natureactivities" BIGINT,
  "specialactivities" BIGINT,
  "otheractivities" BIGINT,
  "numberofactivities" BIGINT,
  "numberoffrequencies" BIGINT,
  "numberoffrequenciesclass1" BIGINT,
  "attendedclasses" BIGINT,
  "attendedclassesclass1" BIGINT,
  "attendedclassesaverage" DOUBLE,
  "attendedclassesaverageclass1" BIGINT,
  "allowedweeklyvisitsbysla" DOUBLE,
  "allowednumberofvisitsbysla" DOUBLE,
  "realnumberofvisits" BIGINT,
  "ratio" DOUBLE,
  "ratioclass2" VARCHAR,
  "numberofrenewals" BIGINT,
  "hasreferences" BIGINT,
  "numberofreferences" BIGINT,
  "dropout" BIGINT
);