Sport Services Dataset

Frequency of the sports facility Dataset

@kaggle.saurabhshahane_sport_services_dataset

Table List

1 table(1.22 MB)

Dadosv3

@kaggle.saurabhshahane_sport_services_dataset.dadosv3

1.22 MB
14942 rows
47 columns

id Id	age Age	ageclass AgeClass	gender Gender	enrollmentstart EnrollmentStart	enrollmentfinish EnrollmentFinish	enrollmentduration EnrollmentDuration	enrollmentdurationclass1 EnrollmentDurationClass1	enrollmentdurationclass2 EnrollmentDurationClass2	lastperiodstart LastPeriodStart	lastperiodfinish LastPeriodFinish	datelastvisit DateLastVisit	dayswithoutfrequency DaysWithoutFrequency	dayswithoutfrequencyclass1 DaysWithoutFrequencyClass1	dayswithoutfrequencyclass2 DaysWithoutFrequencyClass2	lifetimevalue LifetimeValue	lifetimevalueclass1 LifetimeValueClass1	averagefrequency AverageFrequency	averagefrequencyclass1 AverageFrequencyClass1	averagefrequencyclass2 AverageFrequencyClass2	usebytime UseByTime	fitnessactivities FitnessActivities	teamactivities TeamActivities	combatactivities CombatActivities	specialactivities SpecialActivities	numberofactivities NumberOfActivities	numberoffrequencies NumberOfFrequencies	numberoffrequenciesclass1 NumberOfFrequenciesClass1	attendedclasses AttendedClasses	attendedclassesclass1 AttendedClassesClass1	attendedclassesaverage AttendedClassesAverage	attendedclassesaverageclass1 AttendedClassesAverageClass1	allowedweeklyvisitsbysla AllowedWeeklyVisitsBySLA	allowednumberofvisitsbysla AllowedNumberOfVisitsBySLA	realnumberofvisits RealNumberOfVisits	ratio Ratio	ratioclass2 RatioClass2	numberofrenewals NumberOfRenewals	dropout Dropout
1C7DEF50-F9F3-4B51-BBD8-35C8511F5FBE	60	[49,65[	Female	Tue Sep 03 2019 10:05:03 GMT+0000 (Coordinated Universal Time)	Thu Oct 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	[00,01]	Wed Oct 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 30 2019 18:47:43 GMT+0000 (Coordinated Universal Time)	1	1	[00,07]	89.35	2	1.07	4	]1.0,2.0]		1				1	9	2	7	4	0.83	5	2	6.28	2	31.85	]25,50]
804B9C2B-DD94-4CBF-BA18-510AE12F92E7	29	[20,35[	Female	Tue Aug 12 2014 11:59:51 GMT+0000 (Coordinated Universal Time)	Mon Sep 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	13	4	]12,inf[	Sun May 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 16 2015 20:43:21 GMT+0000 (Coordinated Universal Time)	60	4	]30,60]	479.2	5	0.47	3	]0.2,0.5]					1	1	23	3	1	4	0.02	4	2	17.42	1	5.74	]0,25]	2	1
9ABB61F3-81BA-446E-927F-3879BF62688A	23	[20,35[	Male	Tue May 02 2017 09:43:11 GMT+0000 (Coordinated Universal Time)	Thu Jun 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	[00,01]	Tue May 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 25 2017 11:29:39 GMT+0000 (Coordinated Universal Time)	7	1	[00,07]	37.6	1	1.35	5	]1.0,2.0]		1				1	6	2		1		1	7	30.03	6	19.98	]0,25]		1
C47452B2-29C5-4D6B-A28A-A2273D4158FA	9	[00,20[	Male	Wed Sep 05 2018 15:30:07 GMT+0000 (Coordinated Universal Time)	Tue Feb 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	5	2	]04,06]	Wed Dec 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 21 2019 18:11:50 GMT+0000 (Coordinated Universal Time)	22	2	]15,30]	155.4	3	0.87	4	]0.5,1.0]			1			1	20	3	2	4	0.09	4	2	17.72	3	16.93	]0,25]		1
EAFD54FD-CAFC-4DA8-8926-6ED0463F02DF	35	[35,49[	Male	Wed Apr 20 2016 18:33:21 GMT+0000 (Coordinated Universal Time)	Thu Jun 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	26	5	]12,inf[	Sat Apr 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 09 2017 09:02:47 GMT+0000 (Coordinated Universal Time)	210	5	]60,inf]	373.2	4	0.41	2	]0.2,0.5]		1				1	41	4		1		1	7	60.97			[0]	3	1
B36379D3-DADA-4192-B0C1-05CB107A2558	24	[20,35[	Female	Tue Dec 01 2015 19:47:59 GMT+0000 (Coordinated Universal Time)	Sun Jul 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	7	3	]06,09]	Thu Jun 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 28 2016 19:22:55 GMT+0000 (Coordinated Universal Time)	3	1	[00,07]	140	3	0.8	4	]0.5,1.0]		1				1	28	4		1		1	7	59.01	26	44.06	]25,50]		1
1F7936AA-9813-441B-B8D4-23E24DFD6E14	23	[20,35[	Male	Tue Oct 06 2015 16:33:47 GMT+0000 (Coordinated Universal Time)	Thu Apr 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	42	5	]12,inf[	Tue Mar 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 26 2019 19:12:04 GMT+0000 (Coordinated Universal Time)	16	2	]15,30]	143.5	3	0.13	1	]0.1,0.2]		1				1	22	3		1		1	7	30.03	3	9.99	]0,25]	3	1
BAAA6BF5-4C44-48E9-9338-C7EFC4DF6B26	23	[20,35[	Male	Wed Mar 25 2015 15:25:11 GMT+0000 (Coordinated Universal Time)	Wed Jul 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	53	5	]12,inf[	Mon Mar 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat May 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 23 2019 19:52:26 GMT+0000 (Coordinated Universal Time)	99	4	]60,inf]	233.9	4	0.16	1	]0.1,0.2]	1	1				1	34	4		1		1	7	60.97	11	18.04	]0,25]	5	1
132AFA32-6733-46E4-BBE1-239089C8533F	29	[20,35[	Male	Fri Apr 08 2016 20:26:06 GMT+0000 (Coordinated Universal Time)	Wed Jun 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	14	4	]12,inf[	Fri Apr 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 07 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 30 2017 18:19:30 GMT+0000 (Coordinated Universal Time)	69	4	]60,inf]	212.6	3	0.11	1	]0.1,0.2]				1		1	6	2		1		1	7	60.97			[0]	2	1
38D6EF6D-5B1A-4A87-8385-81E413C25A2A	14	[00,20[	Female	Thu Jul 07 2016 08:58:37 GMT+0000 (Coordinated Universal Time)	Wed Feb 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	7	3	]06,09]	Thu Dec 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Nov 19 2016 10:07:13 GMT+0000 (Coordinated Universal Time)	74	4	]60,inf]	253.5	4	0.27	2	]0.2,0.5]			1			1	6	2	6	4	0.27	5	2	17.72			[0]	2	1


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
);