Dating App Fame & Behavior

Understand people's fame and behavior's on a dating app platform

@kaggle.utkarshx27_lovoo_dating_app_dataset

Table List

3 tables(787.8 KB)

Interests Of Users By Age

Lovoo V3 Users Api Results

Lovoo V3 Users Instances

Lovoo V3 Users Instances

@kaggle.utkarshx27_lovoo_dating_app_dataset.lovoo_v3_users_instances

329.06 KB
2919 rows
39 columns

gender Gender	age Age	name Name	counts_pictures Counts Pictures	counts_profilevisits Counts ProfileVisits	counts_kisses Counts Kisses	flirtinterests_chat FlirtInterests Chat	flirtinterests_friends FlirtInterests Friends	flirtinterests_date FlirtInterests Date	lastonline LastOnline	lastonlinets LastOnlineTs	lang_count Lang Count	lang_fr Lang Fr	lang_en Lang En	lang_de Lang De	lang_it Lang It	city City	locationcity LocationCity	locationcitysub LocationCitySub	countdetails CountDetails	distance Distance	mobile Mobile	online Online	whazzup Whazzup	pictureid PictureId	userid UserId
F	25	daeni	4	8279	239	true	true	true	Sat Apr 25 2015 20:43:26 GMT+0000 (Coordinated Universal Time)	1429994606	1			true		Rothenburg	Rümlang	nan	1	175	true		Nur tote fische schwimmen mit dem strom	4e3842f79b70e7ea57000064	55303fc3160ba0eb728b4575
F	22	italiana 92	5	663	13	true	true	true	Sun Apr 26 2015 09:19:35 GMT+0000 (Coordinated Universal Time)	1430039975	3	true		true	true	Sissach	Sissach	nan	0.8500000238418579	138	true		Primaveraaa<3	4e3d34bf5d2bce7b160006a3	552e7b61c66da10d1e8b4c82
F	20	Qqkwmdowlo	3	22187	1015	true	true		Tue Apr 07 2015 11:21:01 GMT+0000 (Coordinated Universal Time)	1428405661	2	true	true			Montréal	Berne	nan	0.1199999973177909	77.30000305175781			Je pense donc je suis. Instagram quedev	4eef8b81ebf2c8f64000000c	54c92738076ea1b5338b4735
F	24	Baby dee	18	7339	180	true		true	Wed Apr 08 2015 14:37:51 GMT+0000 (Coordinated Universal Time)	1428503871	2		true	true		Titisee-Neustadt	Titisee-Neustadt	nan	0.8100000023841858	194	true	true	Wicked Wonderland💕❤️	4ef9434cca61bece6a000002	54f2b4ce0b6ea1177e8b4d18
F	24	Anna	13	18672	492		true		Mon Apr 27 2015 19:29:58 GMT+0000 (Coordinated Universal Time)	1430162998	5		true	true		Stuttgart	Stuttgart	nan	0.6499999761581421	318	true	true	💚 ✅ Instagram : anna_lem0n	4f10cbc1883fa97a5f000015	54ecbb39170ba08b488b4aa5
F	23	Feelinchen	6	19091	1348	true		true	Wed Apr 08 2015 14:18:11 GMT+0000 (Coordinated Universal Time)	1428502691	2		true	true		Eisenhüttenstadt	Bad Krozingen	nan	0.8100000023841858	175	true		🌸🗻🌸	4f317525883fa9636900000e	54fc1786170ba041758b4577
F	20	chantal	14	29984	2389	true	true	true	Tue Apr 07 2015 20:01:55 GMT+0000 (Coordinated Universal Time)	1428436915	3	true	true	true		Gstaad	Steffisburg	nan	0.8799999952316284	81.4000015258789	true		🙊🙉🙈	4f3516420c84d3dd23000001	550c8310066ea13f808b4b35
F	24	rina1990	1	5979	147	true	true	true	Mon Apr 06 2015 16:10:49 GMT+0000 (Coordinated Universal Time)	1428336649	2		true	true		Stuttgart	Stuttgart	nan	0.8100000023841858	315		true	:-)	4fa0fb54883fa90e0d0005d6	53745af3150ba023158b4588
F	22	anniwhat	3	10450	421	true	true		Sun Apr 26 2015 11:23:41 GMT+0000 (Coordinated Universal Time)	1430047421	1			true		Bad Bellingen	Bad Bellingen	nan	0.5400000214576721	148	true	true	live louder and laught longer ♡	4fb4198f883fa90e04000031	53eb2d41ea6da1bb178b4aa0
F	20	Pierrette	5	2612	117	true	true		Wed Apr 08 2015 14:34:25 GMT+0000 (Coordinated Universal Time)	1428503665	1			true		Basel	Liestal	nan	0.9200000166893004	136	true	true	kamehameha	4fc51294ca61be3762000155	5501ff6bcc6da1e21e8b45b5


CREATE TABLE lovoo_v3_users_instances (
  "gender" VARCHAR,
  "age" BIGINT,
  "name" VARCHAR,
  "counts_pictures" BIGINT,
  "counts_profilevisits" BIGINT,
  "counts_kisses" BIGINT,
  "flirtinterests_chat" BOOLEAN,
  "flirtinterests_friends" BOOLEAN,
  "flirtinterests_date" BOOLEAN,
  "connectedtofacebook" BOOLEAN,
  "isvip" BOOLEAN,
  "isverified" BOOLEAN,
  "lastonline" TIMESTAMP,
  "lastonlinets" DOUBLE,
  "lang_count" BIGINT,
  "lang_fr" BOOLEAN,
  "lang_en" BOOLEAN,
  "lang_de" BOOLEAN,
  "lang_it" BOOLEAN,
  "lang_es" BOOLEAN,
  "lang_pt" BOOLEAN,
  "city" VARCHAR,
  "locationcity" VARCHAR,
  "locationcitysub" VARCHAR,
  "userinfo_visitdate" TIMESTAMP,
  "countdetails" DOUBLE,
  "crypt" BOOLEAN,
  "flirtstar" BOOLEAN,
  "freshman" BOOLEAN,
  "hasbirthday" BOOLEAN,
  "highlighted" BOOLEAN,
  "distance" DOUBLE,
  "locked" BOOLEAN,
  "mobile" BOOLEAN,
  "online" BOOLEAN,
  "whazzup" VARCHAR,
  "pictureid" VARCHAR,
  "userid" VARCHAR,
  "issystemprofile" BOOLEAN
);