Data Dictionary: Clean Company API

data dictionary for data retrieved using clean company api endpoints in database api this data dictionary shows all available data points, explains their values, and provides data samples from the clean company api data data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg data dictionary clean company api docid\ l ly1lmc1ux5znq4md2cg 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 record update date s tring (date) professional network source id raw record identification key assigned by professional network s tring created at cleaned time and date when we created the company record s tring (date) data sample meta data "created at" "2019 04 07", "last updated" "2023 12 06", "professional network source id" "60191", cleaning actions data point cleaning action last updated value is converted to the yyyy mm dd format created at value is converted to the yyyy mm dd format identifiers data point processing description data type id raw company id in our database n umber (integer) name cleaned company name s tring logo cleaned base64 encoded jpeg image of the company's logo s tring ticker cleaned company's stock ticker s tring exchange cleaned company's stock exchange string data sample clean company data "id" 8039488, "name" "example company", "logo" "/9j/4aaqskzjrgabaqaaaqabad/2wbdaamcagmcagmdawmeawmebqgfbqqebqohbwyidaomdaskcwsndhiqdq4rdgslebyqermufruvda8xgbyugbiufrt/2wbdaqmebauebqkfbqkudqsnfbqufbqufbqufbqufbqufbqufbqufbqufbqufbqufbqufbqufbqufbqufbqufbqufbt/waarcaajacmdasiaahebaxeb/8qahwaaaqubaqebaqeaaaaaaaaaaaecawqfbgcicqol/8qatraaagedawieawufbaqaaaf9aqidaaqrbrihmuege1fhbyjxfdkbkaeii0kxwrvs0fakm2jyggkkfhcygroljicokso0nty3odk6q0rfrkdisuptvfvwv1hzwmnkzwznaglqc3r1dnd4exqdhiwgh4ijipktljwwl5izmqkjpkwmp6ipqrkztlw2t7i5usldxmxgx8jjytlt1nxw19jz2uhi4+tl5ufo6erx8vp09fb3+pn6/8qahweaawebaqebaqebaqaaaaaaaaecawqfbgcicqol/8qatreaagecbaqdbacfbaqaaqj3aaecaxeebsexbhjbuqdhcrmimoeifekrobhbcsmzuvavynlrchyknoel8rcygromjygpkju2nzg5okneruzhselku1rvvldywvpjzgvmz2hpann0dxz3ehl6gooehyahiimkkpoulzaxmjmaoqokpaanqkmqsro0tba3ulm6wspexcbhymnk0tpu1dbx2nna4upk5ebn6onq8vp09fb3+pn6/9oadambaairaxeapwd9u6k+k7p9rfx1cffg7smj00anhrbsltbbhd5qm8v/afm7o7hofxtivc9n/ahsllrr2612yui3t/efzosgxj83zgjdor7cgj5bybnkhhhttqyotttdxv2pr8dwrmeauhoklzjp3xd6/wbdlnsnfex+ep2i/cxjjxna6dpbxr6jcpngqsqbqpiunicd3ymp4zncmu/r/wbohw3rj3s21vqwlc7sz26gmd8cyhz5+9cr9cd/ssxqqp2cwenpkcftk4zoytst26ntl72n9zptak5tw78qypfglr6jyatqr2zysxayw6o26oro3bbbpdiwornwknzndpd1acncas1o0fl3wn8tfcbwhqhie68ez6by+jlfxjdzwzxsejzigkyhauho24jj39k0vgvn4g+jpg3xhq/hko1nu3jg/njkvoqfpthgaozeohbevz0gsd3r6ivvb2g6ndpc3ei6ddxd/emmti3dvqsutwjy2ftptrhbwlvfa28ywkukbex6accu+eljk7sd3bd3xyptczxhqr06kqdotqt5b80lkmvg+ky8qdn5s+cbp4vepro+iu49h0w2kjdqrarbqsm5/m2nsbvjg6od/s88yjzqhwq8u/2vz/yni0z7x5uinivetzgmqxpioabxkocee9epbj6yorl63o97i8nz5illmsx3p/m838fav4x0fw1a2dzbbqzxtjvx7qgytix3ywpabznhbppnfekuvzod3eypjnihum5uku9f61ciiiszkciiigaooooa/9k=", "ticker" "dhcc", "exchange" "nyse", cleaning and enriching actions data point cleaning/enriching action name values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none company logo image is resized to 50x50px ticker / exchange values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none firmographics data point processing description data type industry cleaned industry the company operates in s tring type cleaned company type s tring founded cleaned company founding year s tring size range cleaned company size range s tring size employees count enriched the number of employees working in the company n umber (integer) followers cleaned the number of company followers n umber (integer) description cleaned company description s tring specialities raw company specialties array of strings metadata title enriched company title parsed from additional sources s tring metadata description enriched company description parsed from additional sources s tring enriched summary enriched llm enriched company summary s tring enriched category enriched company category assigned with llm s tring enriched keywords enriched llm enriched company keywords a rray of strings enriched b2b enriched marks if the company offers b2b products/services enriched with the help of llm 1 – b2b company 0 – not b2b company number (double) data sample clean company data "type" "privately held", "founded" "2011", "followers" 1234, "size range" "11 50 employees", "size employees count" 5, "industry" "unique industry", "description" "digital example company offers very important services ", "specialities" \[ "example 1" ], "enriched summary" "digital example company offers services ", "enriched keywords" \[ "keyword 1", "keyword 2" ], "enriched b2b" 0 0, "enriched category" "example 2", "metadata title" "a great company for you", "metadata description" null, cleaning and enriching actions data point cleaning/enriching action industry values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none type values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none founded values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none ; values are replaced with none if the year is not between 500 and the current year followers values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value 0 ; every value is converted to an integer size range some inconsistencies are fixed with overlapping values size employees count if the size employees count is 0 , we count the number of company employees industry 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 removed; multiple spaces are replaced with single ones other updates product and services overview data point processing description data type pricing available enriched marks if the company service pricing is available online b oolean free trial available enriched marks if the company offers a free trial of their services b oolean demo available enriched marks if the company offers a demo b oolean is downloadable enriched marks if the company offers a downloadable file/service b oolean mobile apps exist enriched marks if the company has mobile apps for their service b oolean online reviews exist enriched marks if the company has any online reviews b oolean api docs exist enriched marks if the company has api docs published b oolean data sample clean company data "pricing available" false, "free trial available" false, "demo available" false, "is downloadable" false, "mobile apps exist" false, "online reviews exist" false, "api docs exist" false, e nriching actions data point e nriching action pricing available free trial available demo available is downloadable mobile apps exist online reviews exist api docs exist information is taken from the official company website contact information data point processing description data type phone numbers enriched publicly available company phone number a rray of strings emails enriched publicly available company email address array of strings data sample contact information "phone numbers" \[ "0000 111 222" ], "emails" \[ "service\@example company com" ], e nriching actions data point e nriching action phone numbers emails information taken from the official company website social media and websites data point processing description data type websites main original raw company website url s tring websites main cleaned cleaned and resolved company website url s tring websites resolved enriched resolved company website url string websites facebook enriched company facebook url s tring websites twitter enriched company twitter url s tring websites professional network raw company professional network url s tring websites professional network canonical raw canonical professional network profile url string social discord urls enriched company discord profile/channel array of strings social facebook urls enriched company facebook page array of strings social instagram urls enriched company instagram page array of strings social professional network urls enriched company professional network profile array of strings social pinterest urls enriched company pinterest page array of strings social tiktok urls enriched company tiktok profile array of strings social twitter urls enriched company twitter profile array of strings social x urls enriched company x profile array of strings social youtube urls enriched company youtube channel/profile array of strings social github urls enriched company github page/profile array of strings social reddit urls enriched company reddit profile array of strings data sample clean company data "websites main original" "http //www example company com ", "websites main" "https //example company com ", "websites facebook" "https //www facebook com/example company", "websites twitter" "https //www twitter com/example company", "websites professional network" "https //www professional network com/company/example company", "websites professional network canonical" "https //www professional network com/company/example company", company social links "social discord urls" \[ "https //discord gg/example company" ], "social facebook urls" \[ "https //www facebook com/example company" ], "social instagram urls" \[ "https //www instagram com/example company" ], "social professional network urls" \[ "https //www professional network com/company/example company" ], "social pinterest urls" \[ "https //www pinterest com/example company" ], "social tiktok urls" \[ "https //www tiktok com/@example company" ], "social twitter urls" \[ "https //twitter com/example company" ], "social x urls" \[ "https //www example company x com" ], "social youtube urls" \[ "https //www youtube com/c/example company" ], "social github urls" \[ "https //github com/example company" ], "social reddit urls" \[ "https //www reddit com/user/example company" ] cleaning and enriching actions data point cleaning/enriching action websites main every website main original url is resolved; each url we collect is parsed, parameters are removed and added to the websites main column only one company can have a unique \<domain> \<tld>/\<path> expired domains are removed websites twitter if \<domain> (from websites main ) == twitter , we move the url value to websites twitter websites facebook if \<domain> (from websites main ) == facebook , we move the url value to websites facebook websites professional network if \<domain> (from websites main ) == professional network , we move the url value to websites professional network social discord urls social facebook urls social instagram urls social professional network urls social pinterest urls social tiktok urls social twitter urls social x urls social youtube urls social github urls social reddit urls urls taken from the official company website location data point processing description data type location hq country cleaned company headquarters country s tring location hq raw address cleaned detailed company location s tring location hq regions enriched geographical region(s) the company is associated with based on the company location hq country value s tring locations full raw full company location information array of objects location adress raw full location of the company hq string is primary raw marks if the listed location is the primary boolean data sample locations "location hq raw address" "encinitas, ca, united states", "location hq country" "united states", "location hq regions" "\[northern america, northern america, amer]", full location "locations full" \[ { "location address" "1 example road examplewood; example town, a1 b2, ex", "is primary" false } ] cleaning actions data point cleaning action location hq country values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none location hq raw address values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value none ; special trailing characters trimmed; value location hq country added to the end of the string (separated by a comma) funding information data point processing description data type funding rounds information on company funding (rounds) array of objects last round investors count cleaned the n umber of investors that participated in the last funding round n umber (integer) total rounds count cleaned total number of funding rounds n umber (integer) last round type cleaned last funding round type s tring last round date cleaned last funding round date s tring last round money raised cleaned amount of money raised during the last funding round number (integer) financial website url raw last funding round financial website url s tring data sample clean company data "funding rounds" \[ { "last round investors count" 10, "total rounds count" 5, "last round type" "series a", "last round date" "2020 12 09", "last round money raised" 1230000, "financial website url" "https //www financial website com/funding round/example" } ] } cleaning actions data point cleaning action funding rounds duplicate data points filtered out; removed empty/irrelevant data points last round investors count values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value 0 ; every value is converted to an integer total rounds count values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value 0 every value is converted to an integer last round type values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value 0 last round date value is converted to the yyyy mm dd format last round money raised values \["none"; "unknown"; "nan"; "nan"; "na"; "null"; "null"; "null"; " "; " "] are replaced with value 0 ; every value is converted to an integer (integer value is parsed from the text value) technologies data point processing description data type technologies data type changed from array of strings to array of structs array of structs technology enriched technology name string first verified at cleaned date this technology was first assigned to the company string (date) last verified at cleaned date this technology was last assigned to the company string ( date) data sample technologies "technologies used" \[ { "technology" "react", "first verified at" "2022 03 15", "last verified at" "2024 10 15" } ] enriching and cleaning actions data point enriching action company technologies enriched by our ml model from multiple sources first verified at last verified at value is converted to the yyyy mm dd format supporting fields data point processing description data type expired domain enriched marks if the company websites main original url redirects to a domain dealer number (integer) unique domain enriched marks if only this company has the right to have this unique domain, e g , company websites main https //ibm com number (integer) unique website enriched marks if only this company has a unique website but not necessarily a unique domain, e g , company websites main https //ibm com/generation number (integer) data sample clean company data "expired domain" 0, "unique domain" 0, "unique website" 0, company updates data point processing description data type updates company posts and related details array of objects urn raw string based identifier string followers raw number of followers s tring date raw post p ublish date (e g , 1 month ago) s tring description raw published text note may contain control characters string reactions count raw number of reactions on the post integer comments count raw number of comments on the post integer reshared post author raw reshared post author string reshared post author url raw author's profile url string reshared post author headline raw author's headline s tring reshared post description raw reshared post text s tring reshared post followers raw the number of followers of the reshared post author integer reshared post date raw date the reshared post was published (e g , 1 month ago) s tring data sample company updates table "updates" \[ { "urn" "urn\ pn\ activity 0000000000000000000" "followers" 1371, "date" "1mo", "description" "example description", "reactions count" 22, "comments count" 2, "reshared post author" "john doe", "reshared post author url" "https //www professional network com/in/john doe", "reshared post author headline" "co founder at example company, tedx & keynote speaker", "reshared post description" "example description", "reshared post followers" 45, "reshared post date" "1mo" } ]