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 Api Results

@kaggle.utkarshx27_lovoo_dating_app_dataset.lovoo_v3_users_api_results

445.84 KB
3973 rows
42 columns

gender Gender	genderlooking GenderLooking	age Age	name Name	counts_details Counts Details	counts_pictures Counts Pictures	counts_profilevisits Counts ProfileVisits	counts_kisses Counts Kisses	counts_fans Counts Fans	counts_g Counts G	flirtinterests_chat FlirtInterests Chat	flirtinterests_friends FlirtInterests Friends	flirtinterests_date FlirtInterests Date	country Country	city City	location Location	distance Distance	ismobile IsMobile	isonline IsOnline	lang_count Lang Count	lang_fr Lang Fr	lang_en Lang En	lang_de Lang De	lang_it Lang It	shareprofileenabled ShareProfileEnabled	lastonlinedate LastOnlineDate	lastonlinetime LastOnlineTime	freetext Freetext	whazzup Whazzup	pictureid PictureId	userid UserId
F	M	25	daeni	1	4	8279	239		3	true	true	true	CH	Rothenburg	Rümlang	175	1		1			true		1	2015-04-25T20:43:26Z	1429994606	Nur tote Fisch schwimmen mit dem Strom	Nur tote fische schwimmen mit dem strom	4e3842f79b70e7ea57000064	55303fc3160ba0eb728b4575
F	M	22	italiana 92	0.85	5	663	13			true	true	true	CH	Sissach	Sissach	138	1		3	true		true	true	1	2015-04-26T09:19:35Z	1430039975	nan	Primaveraaa<3	4e3d34bf5d2bce7b160006a3	552e7b61c66da10d1e8b4c82
F	M	21	Lauraaa		4	1369	88		2			true	CH	Bâle	Bâle	137		1						1	2015-04-06T14:24:07Z	1428330247	nan	nan	4ec96c090dc82cb25d00000a	54a584ecc56da128638b4674
F	none	20	Qqkwmdowlo	0.12	3	22187	1015	2	3	true	true		CA	Montréal	Berne	77.3			2	true	true			1	2015-04-07T11:21:01Z	1428405661	nan	Je pense donc je suis. Instagram quedev	4eef8b81ebf2c8f64000000c	54c92738076ea1b5338b4735
F	M	21	schaessie {3	0.15	12	35262	1413	9	12	true			DE	Rastatt	Rastatt	286		1	1			true		1	2015-04-06T14:25:20Z	1428330320	nan	Instagram: JESSSIESCH	4ef3cc5aa9d0b3d07d000017	54e1a6f6c76da135748b4a3a
F	M	24	Baby dee	0.81	18	7339	180		2	true		true	DE	Titisee-Neustadt	Titisee-Neustadt	194	1	1	2		true	true		1	2015-04-08T14:37:51Z	1428503871	nan	Wicked Wonderland💕❤️	4ef9434cca61bece6a000002	54f2b4ce0b6ea1177e8b4d18
F	none	24	Anna	0.65	13	18672	492		1		true		DE	Stuttgart	Stuttgart	318	1	1	5		true	true		1	2015-04-27T19:29:58Z	1430162998	nan	💚 ✅ Instagram : anna_lem0n	4f10cbc1883fa97a5f000015	54ecbb39170ba08b488b4aa5
F	M	23	Feelinchen	0.81	6	19091	1348		20	true		true	DE	Eisenhüttenstadt	Bad Krozingen	175	1		2		true	true			2015-04-08T14:18:11Z	1428502691	nan	🌸🗻🌸	4f317525883fa9636900000e	54fc1786170ba041758b4577
F	M	20	chantal	0.88	14	29984	2389	10	11	true	true	true	CH	Gstaad	Steffisburg	81.4	1		3	true	true	true		1	2015-04-07T20:01:55Z	1428436915	nan	🙊🙉🙈	4f3516420c84d3dd23000001	550c8310066ea13f808b4b35
F	M	24	rina1990	0.81	1	5979	147	1	2	true	true	true	DE	Stuttgart	Stuttgart	315		1	2		true	true		1	2015-04-06T16:10:49Z	1428336649	nan	:-)	4fa0fb54883fa90e0d0005d6	53745af3150ba023158b4588


CREATE TABLE lovoo_v3_users_api_results (
  "gender" VARCHAR,
  "genderlooking" VARCHAR,
  "age" BIGINT,
  "name" VARCHAR,
  "counts_details" DOUBLE,
  "counts_pictures" BIGINT,
  "counts_profilevisits" BIGINT,
  "counts_kisses" BIGINT,
  "counts_fans" BIGINT,
  "counts_g" BIGINT,
  "flirtinterests_chat" BOOLEAN,
  "flirtinterests_friends" BOOLEAN,
  "flirtinterests_date" BOOLEAN,
  "country" VARCHAR,
  "city" VARCHAR,
  "location" VARCHAR,
  "distance" DOUBLE,
  "isflirtstar" BIGINT,
  "ishighlighted" BIGINT,
  "isinfluencer" BIGINT,
  "ismobile" BIGINT,
  "isnew" BIGINT,
  "isonline" BIGINT,
  "isvip" BIGINT,
  "lang_count" BIGINT,
  "lang_fr" BOOLEAN,
  "lang_en" BOOLEAN,
  "lang_de" BOOLEAN,
  "lang_it" BOOLEAN,
  "lang_es" BOOLEAN,
  "lang_pt" BOOLEAN,
  "verified" BIGINT,
  "shareprofileenabled" BIGINT,
  "lastonlinedate" VARCHAR,
  "lastonlinetime" DOUBLE,
  "birthd" BIGINT,
  "crypt" DOUBLE,
  "freetext" VARCHAR,
  "whazzup" VARCHAR,
  "pictureid" VARCHAR,
  "userid" VARCHAR,
  "issystemprofile" DOUBLE
);