Dictionary: Base Company Data

contains explanations and examples of all data fields available in the base company dataset all company information mentioned in this data dictionary is fictional and is solely intended for illustrative purposes dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda dictionary base company data docid\ m5tdydz7augdyhszf tda this dataset contains legacy tables that are either no longer filled or have low fill rates also viewed https //docs coresignal com/source documentation/professional network companies data dictionary#ez sx company information repeat fields data point description data type example values id identification key for a company profile record each record in the dataset has its id value id in the company table becomes company id later in the other tables of the dataset number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point description data type url company's profile on the professional network s tring hash profile url processed by the md5 algorithm s tring name n ame s tring website website s tring size size category s tring industry associated industry s tring description description s tring followers profile f ollower count integer founded f ounding year integer headquarters city headquarters location (city) note legacy field that is rarely filled s tring headquarters country headquarters location (country) note legacy field that is rarely filled s tring headquarters state headquarters location (state) note legacy field that is rarely filled s tring headquarters street1 headquarters location (street address) note legacy field that is rarely filled s tring headquarters street2 headquarters location (street address) note legacy field that is rarely filled s tring headquarters zip headquarters location (zip code) note legacy field that is rarely filled s tring logo url l ogo url s tring last response code response code to the last scraping request integer type company t ype s tring headquarters new address newly exposed company headquarters address s tring employees count number of employees on the professional network who associated their experience with the company integer headquarters country restored country the company is based in (from our restored database) note legacy field that is rarely filled s tring headquarters country parsed country the company is based in (as parsed by our in house country parser) s tring company shorthand name dynamic part of the url used to update the profile and identify companies s tring company shorthand name hash shorthand name of the company processed by the md5 algorithm s tring canonical url most recent profile url s tring canonical hash canonical url processed by the md5 algorithm s tring canonical shorthand name dynamic part of a canonical url , used to identify companies (the part of the professional network url that has the company name) s tring canonical shorthand name hash canonical shorthand name processed by the md5 algorithm s tring last updated ux date and time when the record was last updated (unix timestamp) integer source id i n house company id (static) on the professional network integer the main company table data sample main company data { "id" 111371, "url" "https //www professional network com/company/luxury store brand", "hash" "83627f1b6ccb868ce2450d63124a1562", "name" "luxury store brand", "website" "http //www luxury store brand com", "size" "1,001 5,000 employees", "industry" "retail apparel and fashion", "description" "luxury store brand is the go to destination for chic, contemporary fashion the brand evokes a mindset an attitude, not an age it's a true original, always defining fashion's next stride forward designed for the confident, sexy, modern woman, luxury store brand is a global label that embodies a sensual, sophisticated lifestyle \n\nchairman and founder john doe opened the first luxury store brand boutique in 1980 in san francisco recognizing a demographic that was neither junior nor bridge, manny created the first contemporary fashion brand over 35 years later, luxury store brand has established itself as one of the world's top fashion retailers \n\nluxury store brand stores\n\nwithin its stores and on luxurystorebrand com, luxury store brand seeks to create an upscale, visually stimulating boutique environment while providing top notch service to ensure an exceptional shopping experience stylists are knowledgeable, passionate about fashion and skilled at addressing clients' styling needs luxury store brand also offers a line of merchandise branded with the distinctive luxury store brand logo for those who love to wear the luxury store brand name \n\nluxury store brand markets its merchandise under the luxury store brand and luxury store brand outlet names through more than 200 retail stores, more than 100 international licensee operated stores and luxury store brand com \n\nluxury store brand com\nlaunched in 1998, luxury store brand com continues the luxury store brand store experience and provides a complete assortment of luxury store brand merchandise to clients in the united states and internationally ", "followers" 23288, "founded" 1976, "headquarters city" null, "headquarters country" null, "headquarters state" null, "headquarters street1" null, "headquarters street2" null, "headquarters zip" null, "logo url" "https //media prof ntwk com/dms/image/c560baqfmmrv6bz4u a/company logo 200 200/0/1519856046980?e=2147483647\&v=beta\&t=pihtlecpzqhcpsujfpylpci kxunwqovzjqwgkr7sty", "created" "2016 06 17 20 08 21", "last updated" "2023 09 09 18 08 29", "last response code" 200, "type" "public company", "headquarters new address" "los angeles, california", "employees count" 1246, "headquarters country restored" "united states", "headquarters country parsed" "united states", "company shorthand name" "luxury store brand", "company shorthand name hash" "44584e20693d123abce7729e4a2b9acb", "canonical url" "https //www professional network com/company/luxury store brand", "canonical hash" "83627f1b6ccb868ce2450d63124a1562", "canonical shorthand name" "luxury store brand", "canonical shorthand name hash" "44584e20693d123abce7729e4a2b9acb", "deleted" 0, "last updated ux" 1694282909, "source id" 16753, affiliated repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point description data type company affiliated collection profiles of affiliated companies a rray of objects affiliated company url affiliate company profile url s tring affiliated company id identification key relating to the company table for the affiliate company note legacy field integer affiliated table data sample afiiliated table "company affiliated collection" \[ { "id" 735765, "company id" 7410562, "affiliated company url" "https //www professional network com/company/rental company", "affiliated company id" 7125453, "created" "2020 02 04 08 32 23", "last updated" "2022 09 21 08 16 07", "deleted" 1 } ], also viewed repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 a legacy table that is no longer filled data point description data type company also viewed collection company profiles that were viewed in tandem with the record company profile a rray of objects viewed company url company profile url s tring viewed company id identification key relating to the company table integer also viewed table data sample also viewed table "company also viewed collection" \[ { "id" 448146, "company id" 111371, "viewed company url" "https //www professional network com/company/fashion brand", "viewed company id" null, "created" "2016 06 17 20 08 21", "last updated" "2019 11 14 01 07 39", "deleted" 1 } ], financial website info repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point description data type company financial website info collection company profile on the financial website a rray of objects financial website url profile url on the financial website s tring financial website info table data sample financial website info "company financial website url info collection" \[ { "id" 258123, "company id" 111371, "financial website url" "https //www financial website com/organization/luxury store brand", "created" "2023 02 06 14 06 55", "last updated" "2023 09 09 18 08 29", "deleted" 0 } ], featured employees repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point description data type company featured employees collection list of associated employees a rray of objects url employee profile url s tring featured employees table data sample featured employees table "company featured employees collection" \[ { "id" 26392978, "company id" 111371, "url" "https //www professional network com/john doe", "created" "2019 11 14 01 07 39", "last updated" "2020 02 22 12 17 32", "deleted" 1 } ], investors repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point data point data type company featured investors collection consists of record metadata and company investors list objects a rray of objects investor id identification key relating to the company investors list table integer round id identification key relating to the company funding rounds table integer company investors list list of company investors o bject name investor's name string hash investor's name processed by the md5 algorithm string financial website url investor's profile url on the financial website string featured investors table data sample featured investors table "company featured investors collection" \[ { "id" 812666, "company id" 111371, "investor id" 5311, "round id" 1822807, "created" "2021 11 29 16 02 04", "last updated" "2021 12 28 09 06 11", "deleted" 1, "company investors list" { "id" 5311, "name" "the investor company", "hash" "7b1fcd743ad2e20a8f72819749131678", "financial website url" "https //www financial website com/organization/the investor company", "created" "2020 09 10 00 02 42", "last updated" "2022 02 07 10 32 06" } } ], funding rounds repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point description data type company funding rounds collection last funding round details a rray of objects last round investors count number of investors who have participated in the funding round integer total rounds count total number of completed funding rounds integer last round type l ast funding round type s tring last round date l ast funding round date s tring last round money raised amount of money raised in the last funding round s tring financial website url funding round record url on financial website s tring funding rounds table data sample funding rounds table "company funding rounds collection" \[ { "id" 2, "last round investors count" 0, "total rounds count" 4, "last round type" "seed", "last round date" "2016 06 01 00 00 00", "last round money raised" "us$ 224 2k", "financial website url" "https //www financial website com/funding round/software company seed 92e35c7f", "created" "2020 09 07 13 01 57", "last updated" "2020 09 26 16 29 54", "deleted" 1 } ], locations repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point description data type company locations collection company l ocations a rray of objects location address company address s tring is primary denotes if the location is the company's primary location 0 not a primary location 1 primary location b oolean locations table data sample locations table "company locations collection" \[ { "id" 11612582, "company id" 111371, "location address" "los angeles, california, us", "is primary" 1, "created" "2019 11 14 01 07 39", "last updated" "2023 09 09 18 08 29", "deleted" 0 }, { "id" 11612583, "company id" 111371, "location address" "new york, us", "is primary" 0, "created" "2019 11 14 01 07 39", "last updated" "2023 09 09 18 08 29", "deleted" 0 } ], similar companies repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point description data type company similar collection companies similar to the record company a rray of objects url similar company profile url s tring similar table data sample similar table "company similar collection" \[ { "id" 45310284, "company id" 111371, "url" "https //www professional network com/company/luxury clothing brand", "created" "2019 11 14 01 07 39", "last updated" "2021 06 22 02 08 26", "deleted" 0 } ], specialties repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point description data type company specialties collection list of c ompany specialties a rray of objects specialty specialty s tring specialties table data sample specialties table "company specialties collection" \[ { "id" 160305, "company id" 111371, "specialty" "luxury store brand stores", "created" "2016 06 17 20 08 21", "last updated" "2022 07 25 04 42 17", "deleted" 1 } ], stock info repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point filter name data type company stock info collection stock details ar ray of objects ticker stock ticker s tring exchange stock exchange s tring stock info table data sample stock info table "company stock info collection" \[ { "id" 2789, "company id" 111371, "ticker" "lsb", "exchange" "otcm", "created" "2020 05 07 14 38 14", "last updated" "2020 07 19 09 39 38", "deleted" 1 } ], company updates repeat fields data point description data type example values id identification key for the record number (integer) 62195 company id company record id assigned in the database number (integer) 30707 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the company page, the page not found was returned 0 we successfully scraped the company profile boolean deleted 0 data point description data type company updates collection company's posts/updates on professional network a rray of objects urn string based identifier s tring followers number of followers integer date publish date (e g , 1 month ago) s tring description published text note may contain control characters s tring reactions count number of reactions on the post integer comments count number of comments on the post integer reshared post author reshared post author s tring reshared post author url profile url of the reshared post author s tring reshared post author headline headline of the reshared post author s tring reshared post description reshared post text s tring reshared post followers the number of followers of the reshared post author integer reshared post date date the reshared post was published (e g , 1 month ago) s tring company updates table data sample company updates table "company updates collection" \[ { "id" 193, "company id" 12695930, "urn" "urn\ li\ activity 6991335602751201281", "followers" 1371, "date" "1mo", "description" "we are delighted to share with you our success at the expo 2022 prime minister spent the highest time in the expo at our virtual reality aircraft simulator, took an entire sortie on the virtual alh mk iii, experienced it to the fullest \n\nkudos to the entire team of the tech company for this remarkable achievement ! hands down by far the best show we've ever had !", "reactions count" 22, "comments count" 2, "reshared post author" "john doe", "reshared post author url" "https //www professional network com/john doe", "reshared post author headline" "co founder at tech company, vr/ar training facilitator, tedx & keynote speaker", "reshared post description" "we are delighted to share with you our success at the expo 2022 prime minister spent the highest time in the expo at our virtual reality aircraft simulator, took an entire sortie on the virtual alh mk iii, experienced it to the fullest \n\nkudos to the entire team of the tech company for this remarkable achievement ! hands down by far the best show we've ever had !", "reactions count" 22, "reshared post followers" 30, "reshared post date" "1mo", "last updated" "2023 01 04 10 09 34", "deleted" 1 } ],