LinkedIn Profiles And Jobs Data

Predict when people change jobs based on social media data

@kaggle.killbot_linkedin_profiles_and_jobs_data

Table List

1 table(3.42 MB)

Dump

@kaggle.killbot_linkedin_profiles_and_jobs_data.dump

3.42 MB
39537 rows
27 columns

unnamed_0 Unnamed: 0	ageestimate AgeEstimate	companyfollowercount CompanyFollowerCount	companyhaslogo CompanyHasLogo	companyname CompanyName	companystaffcount CompanyStaffCount	companyurl CompanyUrl	companyurn CompanyUrn	connectionscount ConnectionsCount	country Country	enddate EndDate	followable Followable	followerscount FollowersCount	genderestimate GenderEstimate	haspicture HasPicture	mbrlocation MbrLocation	mbrlocationcode MbrLocationCode	mbrtitle MbrTitle	memberurn MemberUrn	poslocation PosLocation	poslocationcode PosLocationCode	postitle PosTitle	positionid PositionId	startdate StartDate	avgmemberposduration AvgMemberPosDuration	avgcompanyposduration AvgCompanyPosDuration
	41	198859	5a92c12e-0a20-482b-95ec-e705a6294730-2.png	Commonwealth Bank	32905	http://www.commbank.com.au/	urn:li:company:2848	500	au		1	506	male	nan	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Portfolio Executive at Commonwealth Bank	urn:li:member:10013136	nan	nan	Portfolio Executive	240345	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	760.5	989.9361
1	41	198859	5a92c12e-0a20-482b-95ec-e705a6294730-2.png	Commonwealth Bank	32905	http://www.commbank.com.au/	urn:li:company:2848	500	au	Sun Jun 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1	506	male	nan	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Portfolio Executive at Commonwealth Bank	urn:li:member:10013136	Sydney, Australia	urn:li:fs_region:(au,4910)	Solution Delivery Executive	240346	Fri Nov 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	760.5	989.9361
2	41	10047	b1c3fd9a-8f21-48f8-8321-d773b1ff3cb7-2.png	CommSec	619	http://www.commsec.com.au	urn:li:company:2851	500	au	Sat Dec 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	1	506	male	nan	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Portfolio Executive at Commonwealth Bank	urn:li:member:10013136	nan	nan	Project Manager	240348	Fri Aug 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	760.5	747.2308
3	41	198859	5a92c12e-0a20-482b-95ec-e705a6294730-2.png	Commonwealth Bank	32905	http://www.commbank.com.au/	urn:li:company:2848	500	au	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	1	506	male	nan	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Portfolio Executive at Commonwealth Bank	urn:li:member:10013136	nan	nan	Project Manager	240350	Thu Feb 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	760.5	989.9361
4	30	300723	0f982557-a907-409e-af20-1feb0e0813cd-2.png	PayPal	22522	http://www.paypal.com	urn:li:company:1482	500	au		1	951	female	RTMZ0-46bTjK4V_MGFDG6i5g0yZmFp5oS0S9liWvpWg.jpg	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Senior Marketing Manager, PayPal	urn:li:member:100186032	nan	nan	Senior Marketing Manager	229893	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	395.2857	683.3496
5	30	71403	b976d16b-b41f-401c-952c-d5bd2aaac7b0-2.png	Optus	10913	http://www.optus.com.au	urn:li:company:2711	500	au	Thu Dec 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1	951	female	RTMZ0-46bTjK4V_MGFDG6i5g0yZmFp5oS0S9liWvpWg.jpg	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Senior Marketing Manager, PayPal	urn:li:member:100186032	Sydney, Australia	urn:li:fs_region:(au,4910)	Digital and Social Engagement Leader, Optus Business	229894	Fri Jan 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	395.2857	977.6553
6	30	4385293	e8d29e8b-1601-462c-b780-0f8c19f97157-2.png	IBM	568533	http://www.ibm.com	urn:li:company:1009	500	au	Tue Dec 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1	951	female	RTMZ0-46bTjK4V_MGFDG6i5g0yZmFp5oS0S9liWvpWg.jpg	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Senior Marketing Manager, PayPal	urn:li:member:100186032	Greater New York City Area	urn:li:fs_region:(us,70)	Social Brand Marketing	229895	Sat Nov 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	395.2857	1188.7339
7	30	4385293	e8d29e8b-1601-462c-b780-0f8c19f97157-2.png	IBM	568533	http://www.ibm.com	urn:li:company:1009	500	au	Wed Oct 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1	951	female	RTMZ0-46bTjK4V_MGFDG6i5g0yZmFp5oS0S9liWvpWg.jpg	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Senior Marketing Manager, PayPal	urn:li:member:100186032	Australia	urn:li:fs_region:(au,0)	Brand Strategist	229896	Sat Jun 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	395.2857	1188.7339
8	30	4385293	e8d29e8b-1601-462c-b780-0f8c19f97157-2.png	IBM	568533	http://www.ibm.com	urn:li:company:1009	500	au	Sat Jun 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	1	951	female	RTMZ0-46bTjK4V_MGFDG6i5g0yZmFp5oS0S9liWvpWg.jpg	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Senior Marketing Manager, PayPal	urn:li:member:100186032	Australia	urn:li:fs_region:(au,0)	Brand Expression Lead	229897	Sat Sep 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	395.2857	1188.7339
9	30	4385293	e8d29e8b-1601-462c-b780-0f8c19f97157-2.png	IBM	568533	http://www.ibm.com	urn:li:company:1009	500	au	Sat Sep 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	1	951	female	RTMZ0-46bTjK4V_MGFDG6i5g0yZmFp5oS0S9liWvpWg.jpg	Sydney Area, Australia	urn:li:fs_region:(au,4910)	Senior Marketing Manager, PayPal	urn:li:member:100186032	St Leonards, Australia	nan	Brand System Graduate	229898	Thu Sep 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	395.2857	1188.7339


CREATE TABLE dump (
  "unnamed_0" BIGINT,
  "ageestimate" DOUBLE,
  "companyfollowercount" DOUBLE,
  "companyhaslogo" VARCHAR,
  "companyname" VARCHAR,
  "companystaffcount" DOUBLE,
  "companyurl" VARCHAR,
  "companyurn" VARCHAR,
  "connectionscount" DOUBLE,
  "country" VARCHAR,
  "enddate" TIMESTAMP,
  "followable" DOUBLE,
  "followerscount" DOUBLE,
  "genderestimate" VARCHAR,
  "haspicture" VARCHAR,
  "ispremium" DOUBLE,
  "mbrlocation" VARCHAR,
  "mbrlocationcode" VARCHAR,
  "mbrtitle" VARCHAR,
  "memberurn" VARCHAR,
  "poslocation" VARCHAR,
  "poslocationcode" VARCHAR,
  "postitle" VARCHAR,
  "positionid" DOUBLE,
  "startdate" TIMESTAMP,
  "avgmemberposduration" DOUBLE,
  "avgcompanyposduration" DOUBLE
);