Data Dictionary: Clean Employee API

data dictionary for data retrieved using clean employee api endpoints this data dictionary shows all available data points, explains their values, and provides data samples from the clean employee api data other employee data variations base employee data docid\ ugn n 15oufcqaxwbou1y employee api docid\ pfqia6rfqaechowmzd0dc data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo data dictionary clean employee api docid\ gcduhhoqjyt6fyfx6qdyo the data provided in the samples is strictly intended for illustrative purposes, allowing you to visualize its appearance and format metadata data point processing description data type last updated cleaned date the record was last updated s tring is deleted raw indicates whether the profile was accessible 1 – d eleted or private 0 – publicly available integer data sample meta data "last updated" "2023 07 29", "is deleted" 0 cleaning actions data point cleaning action last updated value is converted to the yyyy mm dd format identifiers data point processing description data type id raw employee record identification key in our database integer full name cleaned full name s tring name first raw first name s tring name middle enriched middle name s tring name last enriched last name s tring websites professional network raw professional network profile url s tring shorthand names raw historical shorthand name list array of strings picture url raw profile picture url string follower count raw profile follower count integer data sample identifiers { "id" 4290, "full name" "john leonardo doe", "name first" "john", "name middle" "leonardo", "name last" "doe", "websites professional network" "https //www professional network com/in/john leonardo doe", "shorthand names" \[ "john leonardo doe" ], "picture url" "https //static lnk com/sc/h/9c8pery4andzj6ohjkjp54ma2", "follower count" 445, cleaning actions data point cleaning action full name special characters/emojis are removed; any words that follow a comma or in parentheses are removed; titles (preceding or following the name) are removed name middle parsed from member full name name last parsed from member full name skills data point processing description data type skills enriched skill list array of strings data sample skills "skills" \[ "3d", "3d printing", "creative", "design", "electronics", "photography", "programming" ] enriching action data point enriching action skills enriched with our ml model from different description fields experience data point processing description data type description raw job position description s tring company id enriched employer's identification key integer headline raw title found in the profile headline string generated headline raw a user written headline that can be found in web search, also viewed and other publicly available spaces it serves the same purpose as the title but is derived from a different source, potentially providing more accurate and up to date profile information this field should be used in place title as it reflects the latest user activity string job title cleaned current job position title s tring is decision maker enriched indicates whether the employee is a decision maker based on job title 1 – employee is marked a decision maker in the current role 0 – employee is not marked a decision maker in the current role integer job description raw current job position description s tring total experience duration enriched summed up experience converted to professional network like text, e g , 2 years 11 months string total experience duration months enriched summed up experience (displayed as months) integer data sample experience "company id" 10101010, "description" "examples engineer, with a master's degree in examples ", "headline" "examples engineer @ example company", "generated headline" "examples engineer @ example company", "job title" "examples engineer", "job description" "advice on the examples generation \\\\\\\nwe develop examples modeling and custom examples", "total experience duration" "2 years 11 months" "total experience duration months" 35, cleaning and enriching actions data point cleaning/enriching action company id company id from an active experience record from member experience job title special characters are removed date from value is converted to the yyyy mm dd format total experience duration values converted to readable text total experience duration months field aggregated from duration values the experience table is mapped with our historical data due to source's policy of hiding the work experience on certain employees' profiles data point processing description data type experience work experience details array of objects company id raw workplace (company) identifier in our database integer date from cleaned employment start date string (date) date from year cleaned employment start year integer date from month cleaned employment start month integer date to cleaned employment end date string (date) date to year cleaned employment end year integer date to month cleaned employment end month integer company url raw employer's professional network profile url string company name raw employer company title raw job title string department enriched associated department string management level enriched management level string description cleaned job description string order in profile raw record order as seen on the employee's profile integer duration enriched employment duration string (date) duration months cleaned employment duration in months integer location cleaned job/workplace location string data sample experience "experience" \[ { "title" "product owner, sr salesforce administrator", "description" "best practice declarative management of salesforce for the organization responsible for security protocols, permissions and profiles and daily maintenance of salesforce custom declarative development for the organization ", "order in profile" 9, "company id" 9975614, "company name" "example company", "company url" "https //www professional network com/company/example company", "date from" "2013 10 01", "date from year" 2013, "date from month" 10, "date to" "2015 07 01", "date to year" 2015, "date to month" 7, "duration" "1 year 10 months", "duration months" 22, "department" "product", "management level" "senior" } ], cleaning and enriching actions data point cleaning/enriching action company id company id from an active experience record from member experience job title special characters are removed total experience duration values converted to readable text total experience duration months field aggregated from duration values information in the table below is enriched using clean and base company datasets data point description data type experience employer (company) details array of objects company type type string company founded founding year string company followers count follower count integer company website official website string company facebook url facebook profile url array of strings company twitter url twitter profile url array of strings company professional network url professional network profile url string company size range size (as a range) string company size employees count headcount integer company industry associated industry string company location hq full address full address of company headquarters string company location hq country headquarters location (country) string company location hq regions headquarters location (regions) array of strings company location hq country iso2 headquarters location (country, iso alpha 2 code) string company location hq country iso3 headquarters location (country, iso alpha 3 code) string company location hq city headquarters location (city) string company location hq state headquarters location (state) string company location hq street headquarters location (street) string company location hq zipcode headquarters location (zipcode) string company last updated the last update date of the company profile string company categories and keywords categories and keywords assigned to the profile array of strings company stock ticker stock ticker array of strings company is b2b marks if the company sells b2b or b2c products 1 – b2b company 0 – b2c company integer company annual revenue annual revenue integer company annual revenue currency annual revenue currency string company employees count change yearly percentage percentage of employee count change string company last funding round announced date date of last funding round string (date) company last funding round amount raised amount of last funding round integer data sample experience + company "experience" \[ { "company type" "privately held", "company founded" "1939", "company followers count" 256699, "company website" "www example company com", "company facebook url" \[ "https //www facebook com/example company" ], "company twitter url" \[ "https //www twitter com/example company" ], "company professional network url" "https //www professional network com/company/example company", "company size range" "5001 10,000 employees", "company size employees count" 4488, "company industry" "truck transportation", "company location hq full address" "15047; lima, lima perú, pe", "company location hq country" "peru", "company location hq regions" \[ "americas", "latin america and the caribbean", "south america", "amer" ], "company location hq country iso2" "pe", "company location hq country iso3" "per", "company location hq city" "lima", "company location hq state" "example state", "company location hq street" "example street", "company location hq zipcode" "0033", "company last updated" "2024 08 29", "company categories and keywords" \[ "logistics" ], "company stock ticker" \[ "exmp" ], "company is b2b" 1, "company annual revenue" 2500000000, "company annual revenue currency" "$", "company employees count change yearly percentage" 9 463414634146341, "company last funding round announced date" "2023 06 05", "company last funding round amount raised" 15600000 } ] data point processing description data type department enriched departments derived from the job title s tring management level enriched management levels identified from the job title s tring is working enriched current employment marker 1 – currently employed 0 – currently unemployed b oolean data sample experience "department" "project", "management level" "other", "is working" 1 enriching actions data point cleaning/enriching action department enriched with our ml model management level enriched with our ml model is working based on date to and date from values of employee experience education data point processing description data type education education details array of objects major cleaned field of study s tring title cleaned educational institution s tring date to cleaned graduation date integer date from cleaned enrolment date integer institution url cleaned institution's profile url s tring description cleaned education description s tring activities and societies cleaned details about activities and societies s tring data sample education "education" \[ { "major" "associate's degree, business administration and management, general", "title" "example college", "date to" "1997", "date from" "1996", "institution url" "https //www professional network com/school/example college", "description" "attended business college from 1996 to 1997", "activities and societies" "activities and societies chess" } ], cleaning actions data point cleaning action title values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none; values are capitalized major values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none date from value is converted to the yyyy format date to value is converted to the yyyy format institution url values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none description values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none text styling tags are removed; multiple spaces are replaced with single ones activities and societies values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none text styling tags are removed; multiple spaces are replaced with single ones hidden collections data point description data type is hidden marks if the profile has a hidden education/experience collection 0 – education/experience information was available at the time of profile scraping 1 – education/experience information was not available at the time of profile scraping boolean data sample is hidden + experience "experience" \[ { "title" "it project manager", "description" "lead cross functional teams to deliver complex software solutions on time and within budget, overseeing all phases of project lifecycle from conception to deployment ", "order in profile" 1, "company id" 11110108, "company name" "example company", "professional network company url" "https //www professional network com/company/example company", "date from" "2022 06 01", "date to" null, "duration" "1 year" } ], "is hidden" 0, is hidden + education "education" \[ { "title" "massachusetts institute of technology", "major" "master of science ms, information technology project management", "date from" 2021, "date to" 2022 } ], "is hidden" 0, location data point processing description data type location raw address cleaned associated location s tring location country cleaned parsed country s tring location regions cleaned geographical regions parsed from associated location a rray of strings data sample location "location raw address" "peru", "location country" "peru", "location regions" \[ "amer", "south america", "latin america and the caribbean" ], cleaning actions data point cleaning action location raw address values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none ; special trailed characters are trimmed; value is set to none if it is shorter than three characters; the value of member location country is added at the end of the string location country values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none recommendations and connections data point processing description data type recommendations cleaned recommendations from other users array of objects recommendation cleaned recommendation text s tring referee name raw referee's name s tring referee url raw referee's profile url s tring recommendations count cleaned number of received recommendations integer connections count raw n umber of connections with other users integer data sample recommendations and connections "recommendations" \[ { "recommendation" "“john was a great asset in collaborating the tasks in different departments to produce the same goal he was great at providing advice and asking questions to avoid even a tiny error during the process great to work with him!”", "referee name" "marry moe", "referee url" "www professional network com/in/marry moe", "order in profile" 1 } ], "recommendations count" 1, "connections count" 65535, cleaning actions data point cleaning action recommendations deleted rows are filtered out recommendation values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none ; value is set to none if it is shorter than three characters; text styling tags are removed; multiple spaces are replaced with single ones; empty recommendations are filtered out recommendations count values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none ; none values are replaced with 0 and made an integer languages data point processing description data type languages language knowledge array of objects language cleaned language s tring proficiency cleaned language proficiency s tring order in profile raw record order in the section integer data sample languages "languages" \[ { "language" "english", "proficiency" "intermediate", "order in profile" 1 } ], cleaning actions data point cleaning action language values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none proficiency values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none certifications data point processing description data type certifications held certifications array of objects title cleaned certificate title s tring issuer cleaned certificate issuer s tring credential id cleaned record order in the section integer certificate url cleaned certificate url s tring date from cleaned issue date s tring date to cleaned expiration date s tring issuer url cleaned issuer profile url s tring order in profile raw section record order integer date from year cleaned issue year integer date from month cleaned issue month integer date to year cleaned expiration year integer date to month cleaned expiration month integer data sample certifications "certifications" \[ { "title" "yellow certificate", "issuer" "example studio", "credential id" 3344, "certificate url" "http //example studio com/public profile certification title", "date from" "2020 08 01", "date from year" 2020, "date from month" 8, "date to" "2023 08 01", "date to year" 2023, "date to year" 8, "issuer url" "https //www professional network com/company/example studio", "order in profile" 1 } ], cleaning actions data point cleaning action title values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none issuer values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none date from value is converted to the yyyy mm dd format date to value is converted to the yyyy mm dd format issuer url values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none date from year date to year year v alue from date is converted to an integer date from month date to month month v alue from date is converted to an integer courses data point processing description data type courses attended courses array of objects organizer cleaned course organizer s tring title cleaned course title s tring order in profile raw record order in the section integer data sample courses "courses" \[ { "organizer" "example academy", "title" "microsoft certified excel expert", "order in profile" 1 } ], cleaning actions data point cleaning action organizer values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none title values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none awards data point processing description data type awards held awards array of objects title cleaned award s tring issuer cleaned award issuer s tring description cleaned award description string date cleaned issue date s tring order in profile raw section record order integer date year cleaned issue year integer date month cleaned issue month integer data sample awards "awards" \[ { "title" "certified in example management", "issuer" "example association", "description" "certification in example management", "date" "2011 08 01", "order in profile" 4, "date year" 2011, "date month" 8 } ], cleaning actions data point cleaning action title values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none ; values are capitalized issuer values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none date value is converted to the yyyy mm dd format date year year v alue from date is converted to an integer date month month v alue from date is converted to an integer activity data point processing description data type activity interaction with posts on professional network array of objects activity url raw post url s tring title cleaned post title s tring action cleaned interaction type s tring order in profile raw section record order integer data sample activity "activity" \[ { "activity url" "https //www professional network com/posts/example company post1", "title" "example company would like to introduce our \\"team spotlight”, john doe @example company #example #company", "action" "liked by", "order in profile" 1 } ], cleaning actions data point cleaning action title values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none ; text styling tags removed; multiple spaces are replaced with single ones organizations data point description data type member organizations memberships in organizations array of structs organization organization title s tring position position in the organization s tring description description of the activity/experience in the organization s tring date from membership start date string date from year membership start year integer date from month membership start month integer date to membership end date string date to year membership end year integer date to month membership end month integer order in profile the exact position of the organization in the profile integer data sample organizations "member public profile id" "123456789", "member organizations" \[ { "organization" "example organization", "position" "lead software engineer", "description" "led a team of developers providing great services ", "date from" "2019 06", "date from year" 2019, "date from month" 6, "date to" "2023 09", "date to year" 2023, "date to month" 9, "order in profile" 1 } ], patents data point description data type member patents authored patents array of structs title patent title s tring status patent status s tring inventors inventors of the patent array of structs full name full name of the inventor string profile url profile url string order in profile order in profile integer date patent filing date string date year filling year integer date month filling month integer date day filling day integer patent url patent url string description patent description string patent or application number patent or application number string order in profile the exact position of the patent in the profile integer data sample patents "member patents" \[ { "title" "data synchronization system", "status" "granted", "inventors" \[ { "full name" "john doe", "profile url" "https //www professional network com/profile/johndoe", "order in profile" 1 }, { "full name" "jane smith", "profile url" "https //www professional network com/profile/janesmith", "order in profile" 2 } ], "date" "2022 01 01", "date year" 2022, "date month" 1, "date day" 1, "patent url" "https //wwww patents example com/us1234567", "description" "a method for efficient synchronization of distributed systems in real time environments ", "patent or application number" "us1234567b2", "order in profile" 1 } publications data point description data type member publications memberships in organizations array of structs title publication title s tring publisher publisher name s tring date publication release date s tring date year release year integer date month release month integer date day release day integer description publication description string authors authors of the publication array of structs full name full name of the author string profile url profile url string order in profile order in the profile integer publication url publication website url string order in profile the exact position of the publication in the profile integer data sample publications "member publications" \[ { "title" "microservices architecture in cloud environments", "publisher" "journal of software systems", "date" "2024 08 01", "date year" 2024, "date month" 8, "date day" 1, "description" "an in depth analysis of architectural patterns and scalability challenges in cloud native microservices ", "authors" \[ { "full name" "john doe", "profile url" "https //www professional network com/profile/johndoe", "order in profile" 1 } ], "publication url" "https //www publications example com/microservices architecture", "order in profile" 1 } ] }