Dating App Fame & Behavior
Understand people's fame and behavior's on a dating app platform
@kaggle.utkarshx27_lovoo_dating_app_dataset
Understand people's fame and behavior's on a dating app platform
@kaggle.utkarshx27_lovoo_dating_app_dataset
CREATE TABLE interests_of_users_by_age (
"age" BIGINT,
"nbusers" BIGINT,
"percentwantchats" DOUBLE,
"percentwantfriends" DOUBLE,
"percentwantdates" DOUBLE,
"meankissesreceived" BIGINT,
"meanvisitsreceived" DOUBLE,
"meanfollowers" DOUBLE,
"meanlanguagesknown" DOUBLE,
"totalwantchants" BIGINT,
"totalwantfriends" BIGINT,
"totalwantdates" BIGINT,
"totalkissesreceive" BIGINT,
"totalvisitsreceived" BIGINT,
"totalfollowers" BIGINT,
"totallanguagesspoken" BIGINT
);
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
);
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
);
Anyone who has the link will be able to view this.