Company search fields
Every field in the companies search collection, usable in query_by, filter_by and sort_by of /search-public/companies.
These are the fields of the companies search collection behind /search-public/companies (GET, POST). Use them in query_by, filter_by and sort_by. The parameters, plan limits, Pro tier filtering, redacted properties and date handling that apply to every collection are described in Search, and the response schema on the endpoint pages.
Field guides for the other collections:
- Companies (you are here)
- Workplaces
- Bankruptcies
- Vehicles
- Properties
Fields indexed
The following fields are currently indexed in memory. These can be used in the query_by parameter and filter_by. Remember this is not the schema of the JSON response since it contains a large number of additional properties.
| Field | Type | Description |
|---|---|---|
companyId | int32 | Our global internal company identifier |
registrationNumber | string | The local registration number in the country |
legalEntityType | string | Type of legal entity as described in local market |
localCompanyCode | string | The local company code as known by the market (for example Aktiebolag = AB) |
elfCode | string | ISO Standard 20275 Entity Legal Form (ELF) |
registrationDate | int64 | Unix time (epoch) seconds since 1st January 1970 |
ceasedDate | int64 | Unix time (epoch) seconds since 1st January 1970, when the company ceased to exist (note date may be unknown by the flag isCeased will be set) |
isCeased | bool | A flag indicating the business have ceased |
mostRecentPurpose | string | The last purpose registered for the business |
names.nameOrIdentifier | string | Current and former names of the business (could be legalname, particularName etc) |
isRegisteredForVAT | bool | If the business is registered for VAT |
isRegisteredForFTax | bool | If the business is registered for F-tax |
isRegisteredForPayroll | bool | If the business is registered for payroll |
ftaxTerminationReason | string | If the termination of F-tax is known a description |
phoneNumbers.e164PhoneNumber | string | E164 formatted phone number |
phoneNumbers.numberPlanServiceType | string | Service type as described in local number plan |
phoneNumbers.orginalOperator | string | The original operator that held the number |
phoneNumbers.priorOperator | string | Last prior operator before the porting |
phoneNumbers.currentOperator | string | Current operator |
phoneNumbers.lastPortingDate | int64 | Last porting date in Unix time (epoch) seconds since 1st January 1970 |
emailAddresses.emailAddress | string | E-mail addresses to the business |
hyperlinks.hyperlink | string | Hyperlinks to the business |
sniCodes.sni_2007Name | string | SNI 2007 name |
sniCodes.sni_2007Code | string | SNI 2007 code |
sniCodes.sni_2007Section | string | SNI 2007 section |
sniCodes.sni_2025Name | string | SNI 2007 name |
sniCodes.sni_2025Code | string | SNI 2007 code |
sniCodes.sni_2025Section | string | SNI 2025 section |
sniCodes.rank | string | SNI 2007/2025 order |
bankAccounts.accountNumber | string | Bank accounts |
mostRecentRegisteredAddress.co | string | C/O = care of address |
mostRecentRegisteredAddress.streetAddress | string | Street address |
mostRecentRegisteredAddress.postalCode | string | The postalcode |
mostRecentRegisteredAddress.city | string | City |
mostRecentRegisteredAddress.countryCodeAlpha3 | string | Country code 3 char alpha |
mostRecentRegisteredAddress.location | geopoint | Allows geosearch |
mostRecentMailingAddress.co | string | C/O = care of address |
mostRecentMailingAddress.streetAddress | string | Street address |
mostRecentMailingAddress.postalCode | string | The postalcode |
mostRecentMailingAddress.city | string | City |
mostRecentMailingAddress.countryCodeAlpha3 | string | Country code 3 char alpha |
mostRecentMailingAddress.location | geopoint | Allows geosearch |
mostRecentVisitingAddress.co | string | C/O = care of address |
mostRecentVisitingAddress.streetAddress | string | Street address |
mostRecentVisitingAddress.postalCode | string | The postalcode |
mostRecentVisitingAddress.city | string | City |
mostRecentVisitingAddress.countryCodeAlpha3 | string | Country code 3 char alpha |
mostRecentVistingAddress.location | geopoint | Allows geosearch |
registeredOffices.municipality | string | The registered office municipality |
registeredOffices.municipalityCode | string | The registered office municipality code |
registeredOffices.county | string | The registered office county |
registeredOffices.countyCode | string | The registered office county code |
documents.documentTitle | string | Title of the document |
documents.documentVersion | string | Version of the document |
documents.documentValue3 | string | Used to provide additional data about the document |
intelligence.companyIntelligenceType | string | The specific enum (int) that you want to query by |
intelligence.companyIntelligenceSubType | string | A text enum describing the sub-type of the intelligence type (see documentation) |
intelligence.notes | string | The description of the discrepancy |
intelligence.score | int32 | A score rank between 0-255 where 0 means only for information and 255 is a serious mark |
intelligence.externalId | int32 | A reference for the intelligence type used to find the associated underlying document |
mostRecentFinancialSummary.annualReportPeriod | int32 | The endpoint report of the annual report in YYYYMM as Int32 |
mostRecentFinancialSummary.periodStart | int64 | Start period epoch seconds |
mostRecentFinancialSummary.periodEnd | int64 | End period epoch seconds |
mostRecentFinancialSummary.rs_NetSalesK | int32 | Net sales in K (thousands) |
mostRecentFinancialSummary.rs_OtherOperatingIncomeK | int32 | Other operating income in K (thousands) |
mostRecentFinancialSummary.rs_OperatingProfitOrLossK | int32 | Operating profit or loss in K (thousands) |
mostRecentFinancialSummary.rs_SumFinancialItemsK | int32 | Sum of financial items in K (thousands) |
mostRecentFinancialSummary.rs_ProfitAfterFinancialItemsK | int32 | Profit after financial items in K (thousands) |
mostRecentFinancialSummary.bs_TotalAssetsK | int32 | Total assets in balance sheet in K (thouands) |
mostRecentFinancialSummary.fn_NumberOfEmployees | float | Number of employees with one decimal |
mostRecentFinancialSummary.km_OperatingMargin | float | Operating margin with four decimals |
mostRecentFinancialSummary.km_NetProfitMargin | float | Net profit margin with four decimals |
mostRecentFinancialSummary.km_EquityAssetsRatio | float | Equity asset ratio with four decimals |
mostRecentFinancialSummary.km_GrossMargin | float | Gross margin with four decimals |
mostRecentFinancialSummary.software | string | Software used to generate the financial report (if known) |
mostRecentSignatory.signatureDescription | string | Description of the signature rights |
currentRepresentatives.personId | int32 | An internal id representing the person which makes it simpler to query |
mostRecentDebtorSummary.debtBalance.totalAmountInSEK | float | Holds the total amount, currency SEK, of outstanding debts of public vs. private debt cases |
mostRecentDebtorSummary.debtBalance.public.description | string | The public case debt type and creditor |
mostRecentDebtorSummary.debtBalance.public.numberOfCases | int32 | Number of public debt cases relating to public debt |
mostRecentDebtorSummary.debtBalance.public.totalAmountInSEK | float | Total amount outstanding debt for public debt cases |
mostRecentDebtorSummary.debtBalance.private.numberOfCases | int32 | Number of private debt cases relating to public debt |
mostRecentDebtorSummary.debtBalance.private.totalAmountInSEK | float | Total amount private debt for public debt cases |
currentRepresentatives.personalIdentityNumber | string | The local market personal identity number |
currentRepresentatives.positionType | string | The position of the representative |
currentRepresentatives.positionDescription | string | Text description of the position |
currentRepresentatives.fullName | string | Fullname of the person |
currentRepresentatives.roleByCompanyName | string | If the position is held by a company |
currentRepresentatives.roleByCompanyRegistrationNumber | string | If the position is held by a company |
currentRepresentatives.auditorType | string | Auditor type |
currentRepresentatives.bornYearMonthDay | string | For foreign persons |
currentBeneficialOwners.personId | int32 | An internal id representing the person which makes it simpler to query |
currentBeneficialOwners.personalIdentityNumber | string | The local market personal identity number |
currentBeneficialOwners.fullName | string | Fullname of the person |
currentBeneficialOwners.countryOfResidenceCode | string | ISO3166 Country code 2-char |
currentBeneficialOwners.citizenshipCountryCode | string | ISO3166 Country code 2-char |
currentBeneficialOwners.extentDescription | string | Description of the extent |
currentBeneficialOwners.governDescription | string | Description of the govern |
currentBeneficialOwners.throughName | string | If managed through a name / company |
currentBeneficialOwners.throughRegistrationNumber | string | If managed through a name / company |
currentBeneficialOwners.bornYearMonthDay | string | For foreign persons |
mostRecentSignatory.signatureDescription | string | The signature description |
mostRecentShareCapital.shareCapitalAmount | float | The current share capital amount |
franchisesOrLicences.linkedToName | string | From which company name is the franchise, licence or permit given |
franchisesOrLicences.actingUnderName | string | Under which name is the business providing services or sales of goods |
franchisesOrLicences.linkedToCompanyId | int32 | From which company id is the franchise, licence or permit given |
franchisesOrLicences.description | string | Description of the franchise, licence or permit given |
franchisesOrLicences.companyFranchiseOrLicenceType | string | Type of franchise, licence or permit (franchise, licence, membership, agent, other) |
currentWorkplaces.companyWorkplaceId | int32 | Our worldwide identifier for the workplace |
currentWorkplaces.workplaceCode | int32 | A code for the workplace |
currentWorkplaces.mostRecentName | int32 | The name of workplace |
currentWorkplaces.labelAddress | string | A label containing the street address, postalcode and city |
currentWorkplaces.location | geopoint | Allows geosearch |
trademarks.word | string | The word representing a word-trademark |
trademarks.expire | int64 | When the trademark expire in Unix time (epoch) seconds since 1st January 1970 |
stock.isin | string | ISIN |
stock.ticker | string | Ticker symbol on market |
stock.marketName | string | Market name |
stock.marketExchangeName | string | Market exchange name |
stock.sectorName | string | Business sector as provided on market |
stock.branchName | string | Business branch as provided on market |
stock.enterpriseValue | string | Enterprise value last closing day |
stock.nextReportDate | string | Next report date for the listed company |
stock.dividendExDate | string | Next X-date to receive the dividend |
stock.yahooSymbol | string | The Yahoo finance symbol |
lei.leiCode | string | LEI Code |
lei.registrationStatus | string | RETIRED, DUPLICATE, LAPSED, ANNULLED, PENDING_TRANSFER, ISSUED, PENDING_ARCHIVAL |
lei.initialRegistrationDate | int64 | Initial registration date in Unix time (epoch) seconds since 1st January 1970 |
lei.nextRenewalDate | int64 | Initial registration date in Unix time (epoch) seconds since 1st January 1970 |
lei.managingLOU | string | LEI of the managing LOU |
lei.managingLOULegalName | string | Legal name of the LOU |
ecParticipant.pic | string | Participant Identification Code (PIC) as registered with European Commission |
ecParticipant.validationStatus | string | Declared, Validated, Sleeping, Suspended, Blocked, Deprecated (see further documentation) |
ecParticipant.numberOfProjects | int32 | Number of projects where the organization has been present with the PIC |
franchisesOrLicences.linkedToName | string | The name of the licencee or company providing the franchise |
franchisesOrLicences.actingUnderName | string | The name/s under which the company is acting under |
franchisesOrLicences.linkedToCompanyId | int32 | The company id if exists for which the licence or franchise was given |
salesToPublicActors.actorName | string | The name of the public actor |
salesToPublicActors.actorType | string | The name of the public actor |
salesToPublicActors.actorCode | string | The code of the actor, e.g municipality = municipality code |
hasSalesToPublicActors | bool | Helper flag for knowing if the company has sold to public actors |
hasPhoneNumbers | bool | Helper flag for knowing if the company has phone numbers present |
hasEmailAddresses | bool | Helper flag for knowing if the company has email addresses present |
hasHyperlinks | bool | Helper flag for knowing if the company has hyperlinks present |
hasIntelligence | bool | Helper flag for knowing if the company has intelligence records present |
hasStatus | bool | Helper flag for knowing if the company has status records present |
hasBankAccounts | bool | Helper flag for knowing if the company has bank accounts present |
hasAddresses | bool | Helper flag for knowing if the company has addresses present |
hasDocuments | bool | Helper flag for knowing if the company has documents present |
hasStock | bool | Helper flag for knowing if the company has stock data present |
hasLEI | bool | Helper flag for knowing if the company has LEI information present |
parentCompanyId | int32 | The companyId of the parent company, directly above the company in its corporate group. Empty for an ultimate parent, a company in no group and a parent outside the register |
ultimateParentCompanyId | int32 | The companyId of the group's ultimate parent; the company's own companyId when it is the ultimate parent. Empty for a company in no group and an ultimate parent outside the register |
hasECParticipant | bool | Helper flag for knowing if the company has EU participant information present |
hasFranchisesOrLicences | bool | Helper flag for knowing if the company has franchises or licences present |
hasTrademarks | bool | Helper flag for knowing if the company has trademarks |
hasMostRecentDebtorSummary | bool | Helper flag for knowing if the company has summary of debts |
cNbrEmployeesInterval.categoryCode | int32 | The code for the employee interval |
cNbrEmployeesInterval.categoryCodeDescription | string | Description of the interval |
cVATInterval.categoryCode | int32 | The code representing the VAT reporting |
cVATInterval.categoryCodeDescription | string | Description of the interval |
cTurnoverInterval.categoryCode | int32 | The code for the turnover interval |
cTurnoverInterval.categoryCodeDescription | string | Description of the interval |
cPropertyTaxationInterval.categoryCode | int32 | The code for the employee interval |
cPropertyTaxationInterval.categoryCodeDescription | string | Description of the interval |
cSector.categoryCode | int32 | The code for the sector |
cSector.categoryCodeDescription | string | Description of the sector |
cTradeAfrica.categoryCode | int32 | A code (0 or 1) representing if the company is exporting/importing from the continent. |
cTradeAfrica.categoryCodeDescription | string | Description of the interval |
cTradeAsia.categoryCode | int32 | A code (0 or 1) representing if the company is exporting/importing from the continent. |
cTradeAsia.categoryCodeDescription | string | Description of the interval |
cTradeEU.categoryCode | int32 | A code (0 or 1) representing if the company is exporting/importing from the continent. |
cTradeEU.categoryCodeDescription | string | Description of the interval |
cTradeFarEast.categoryCode | int32 | A code (0 or 1) representing if the company is exporting/importing from the continent. |
cTradeFarEast.categoryCodeDescription | string | Description of the interval |
cTradeNorthCentralAmerica.categoryCode | int32 | A code (0 or 1) representing if the company is exporting/importing from the continent. |
cTradeNorthCentralAmerica.categoryCodeDescription | string | Description of the interval |
cTradeNordics.categoryCode | int32 | A code (0 or 1) representing if the company is exporting/importing from the continent. |
cTradeNordics.categoryCodeDescription | string | Description of the interval |
cTradeSouthAmerica.categoryCode | int32 | A code (0 or 1) representing if the company is exporting/importing from the continent. |
cTradeSouthAmerica.categoryCodeDescription | string | Description of the interval |
cTradeOtherEurope.categoryCode | int32 | A code (0 or 1) representing if the company is exporting/importing from the continent. |
cTradeOtherEurope.categoryCodeDescription | string | Description of the interval |
cTradeExportInterval.categoryCode | int32 | A code representing the export interval |
cTradeExportInterval.categoryCodeDescription | string | Description of the interval |
cTradeImportInterval.categoryCode | int32 | A code representing the import interval |
cTradeImportInterval.categoryCodeDescription | string | Description of the interval |
cGenderRatioFemale.categoryCode | int32 | Gender ratio females in percentage (no fraction) |
cGenderRatioFemale.categoryCodeDescription | string | Gender ratio females with percentage sign |
cPrivPubl.categoryCode | int32 | Code representing if the company is private/public/listed etc |
cPrivPubl.categoryCodeDescription | string | Description of the type of company |
cOwnership.categoryCode | int32 | Code representing the kind of ownership |
cOwnership.categoryCodeDescription | string | Description of ownership type |
European Commission participant status
ecParticipant.validationStatus can contain the following statuses:
Declared Organisation registered by self-registrant. Will remain in this status if the validation is done decentrally by the National Agency.
Validated Organisation validated centrally by REA (Research Executive Agency).
Suspended The legal entity is “frozen” because of an external reason (Bankruptcy, etc.) as a result of central validation by REA (Research Executive Agency).
Sleeping Some data was passed, but the contact person does not react on any demands from the REA (Research Executive Agency) validation team.
Deprecated When duplication is identified by REA (Research Executive Agency), the validity will be Deprecated and the master PIC will be associated. Will not be published in the search.
Blocked Blocked during the validation process by REA (Research Executive Agency).