Bankruptcy search fields and examples

Max+ tier

These are the fields of the bankruptcies search collection behind /search-public/bankruptcies (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
Workplaces
Bankruptcies (you are here)
Vehicles
Properties

Bankruptcies search

With our search you can query (query_by) based on a number fields listed in the next chapter.

Examples on what you can query on:

Bankruptcies per day, week, month, year
Bankruptcies per sector, industry type per SNI code
Trustee
Status

Bankruptcy status codes

These are the status codes that could appear in bankruptcyStatusCode:

Code	Description	Property for event date
20	Bankruptcy proceedings commenced	initiatedDate
21	Bankruptcy proceedings terminated	terminatedDate
22	Bankruptcy terminated with surplus	terminatedDate
24	Bankruptcy repealed by court	repealedDate
255	Bankruptcy application filed	initiatedDate

Fields indexed

The following fields are currently indexed in memory. These can be used in the query_by and filter_by parameter.

Field	Type	Description
`companyId`	`int32`	Our global internal company identifier
`companyName`	`string`	The name in the financial report
`registrationNumber`	`string`	The local registration number
`legalEntityType`	`string`	The legal entity type as appeared locally
`localCompanyCode`	`string`	The local code for the legal entity type
`elfCode`	`string`	An ISO code for the legal entity type (ISO 20275: Entity Legal Forms Code)
`registrationDate`	`int64`	Unix epoch
`mostRecentPurpose`	`string`	The company's most recent purpose
`bankruptcyStatusCode`	`string`	A status code for the bankruptcy
`sniCodes.sni_2007Name`	`string`	SNI 2007 name
`sniCodes.sni_2007Code`	`string`	SNI 2007 code
`courtCase`	`string`	The case number at the court
`courtName`	`string`	The name of the court
`courtCode`	`string`	The code of the court
`courtEmail`	`string`	The email address to the court
`initiatedBy`	`int64`	Information and who applied to bankrupcty (from 2024 and onwards)
`initiatedDate`	`int64`	Unix epoch
`terminatedDate`	`int64`	Unix epoch when the bankruptcy was terminated
`repealedDate`	`int64`	Unix epoch of the appeal date
`hasTrustee`	`bool`	Help flag if the trustee exists
`trusteeName`	`string`	The email address to the court
`trusteeCO`	`string`	The C/O of the trustee
`trusteeAddressStreet`	`string`	The address to the trustee
`trusteeAddressPostalCode`	`string`	The postalcode to the trustee
`trusteeAdddressCity`	`string`	The city to to the trustee
`registeredOfficeMunicipality`	`string`	The municipality name of the registered office
`registeredOfficeMunicipalityCode`	`string`	The municipality code (4 characters) as specified by SCB
`registeredOfficeCounty`	`string`	The county name
`registeredOfficeCountyCode`	`string`	The county code (2 characters) as specified by SCB
`mostRecentRegisteredAddress.co`	`string`	C/O = care of address
`mostRecentRegisteredAddress.street`	`string`	Street name
`mostRecentRegisteredAddress.houseNumber`	`string`	The street number
`mostRecentRegisteredAddress.city`	`string`	City
`mostRecentRegisteredAddress.postalCode`	`string`	Postal Code
`mostRecentRegisteredAddress.location`	`geopoint`	Allows geosearch
`mostRecentRegisteredAddress.addressType`	`int32`	0 = mailAddress, 1 = visitingAddress, 2 = bothMailAndVisitingAddress
`mostRecentRegisteredAddress.countryCodeAlpha3`	`string`	Country code 3 char alpha
`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)
`applicationIfAny`	`string`	Link to the application (from january 2024 and onwards)
`isPublicSectorVendor`	`bool`	If the company exists as a vendor to the public sector
`approxInvoicedToPublicSector2022`	`decimal`	Approx value invoices by the vendor to the public sector 2022
`approxInvoicedToPublicSector2023`	`decimal`	Approx value invoices by the vendor to the public sector 2023

Examples

We have put together a few example of how you can use search in financial reports to easy find data.

Search for bankruptcies initiated from 2024-12-09 00:00:00 and forward

curl -H "x-api-key: YOUR_API_KEY" \
  "https://lens-api.tic.io/search-public/bankruptcies?q=*&query_by=registrationNumber&filter_by=initiatedDate:>=1733702400"
{
    "facet_counts": [],
    "found": 61,
    "hits": [
        {
            "document": {
                "bankruptcyStatusCode": "20",
                "bankruptcyStatusDescriptionEn": "Bankruptcy proceedings commenced",
                "bankruptcyStatusDescriptionSv": "Konkurs inledd",
                "companyId": 3367569,
                "companyName": "Mix Ranch AB",
                "courtCase": "K 1651-24",
                "courtCode": "TGO",
                "courtEmail": "gotlands.tingsratt@dom.se",
                "courtName": "Gotlands tingsrätt",
                "elfCode": "XJHM",
                "hasTrustee": true,
                "id": "299652",
                "initiatedDate": 1733702400,
                "legalEntityType": "Aktiebolag",
                "localCompanyCode": "AB",
                "mostRecentFinancialSummary": {
                    "bs_TotalAssetsK": 773,
                    "isAudited": false,
                    "km_EquityAssetsRatio": 0.123,
                    "periodEnd": 1672444800,
                    "periodStart": 1640995200,
                    "rs_NetSalesK": 0,
                    "rs_OperatingProfitOrLossK": -9,
                    "rs_OtherOperatingIncomeK": 0,
                    "rs_ProfitAfterFinancialItemsK": -35,
                    "rs_SumFinancialItemsK": -26
                },
                "mostRecentPurpose": "Bolaget verksamhet skall bestå i bedrivande av nöjesanläggning, / restaurang, säkerhetsutbildningar, personskydd, MC- och / bilverkstad samt därmed förenlig verksamhet.",
                "mostRecentRegisteredAddress": {
                    "addressType": "mailAddress",
                    "city": "Tingstäde",
                    "co": "C/O Edmarg",
                    "countryCodeAlpha3": "SWE",
                    "houseNumber": "641",
                    "location": [
                        57.7984,
                        18.54896
                    ],
                    "postalCode": "62442",
                    "street": "Stenkyrka Broungs"
                },
                "registeredOfficeCounty": "Gotlands län",
                "registeredOfficeCountyCode": "09",
                "registeredOfficeMunicipality": "Gotland",
                "registeredOfficeMunicipalityCode": "0980",
                "registrationDate": 1124064000,
                "registrationNumber": "5566845250",
                "sniCodes": [
                    {
                        "sni_2007Code": "55202",
                        "sni_2007Name": "Stugbyverksamhet m.m."
                    },
                    {
                        "sni_2007Code": "55300",
                        "sni_2007Name": "Campingplatsverksamhet"
                    },
                    {
                        "sni_2007Code": "56100",
                        "sni_2007Name": "Restaurangverksamhet"
                    },
                    {
                        "sni_2007Code": "93290",
                        "sni_2007Name": "Övrig fritids- och nöjesverksamhet"
                    }
                ],
                "trusteeAdddressCity": "STOCKHOLM",
                "trusteeAddressPostalCode": "111 22",
                "trusteeAddressStreet": "Olof Palmes gata 23",
                "trusteeCO": "c/o Merino Advokatbyrå AB",
                "trusteeName": "XXX"
            },
            "highlight": {},
            "highlights": []
        }...

Search for bankruptcies from 2024-10-09 00:00:00 and onwards with the trustee C/O Fylgia law firm

curl -H "x-api-key: YOUR_API_KEY" \
  "https://lens-api.tic.io/search-public/bankruptcies?q=*&query_by=registrationNumber&filter_by=initiatedDate:>=1733702400"
{
    "facet_counts": [],
    "found": 2,
    "hits": [
        {
            "document": {
                "bankruptcyStatusCode": "20",
                "bankruptcyStatusDescriptionEn": "Bankruptcy proceedings commenced",
                "bankruptcyStatusDescriptionSv": "Konkurs inledd",
                "companyId": 3319268,
                "companyName": "Kemze Konsult AB",
                "courtCase": "K 11798-24",
                "courtCode": "TVA",
                "courtEmail": "varbergs.tingsratt@dom.se",
                "courtName": "Varbergs tingsrätt",
                "elfCode": "XJHM",
                "hasTrustee": true,
                "id": "299600",
                "initiatedDate": 1733702400,
                "legalEntityType": "Aktiebolag",
                "localCompanyCode": "AB",
                "mostRecentFinancialSummary": {
                    "bs_TotalAssetsK": 1,
                    "isAudited": false,
                    "km_EquityAssetsRatio": 1.0,
                    "periodEnd": 1688083200,
                    "periodStart": 1656633600,
                    "rs_NetSalesK": 0,
                    "rs_OperatingProfitOrLossK": -22,
                    "rs_OtherOperatingIncomeK": 0,
                    "rs_ProfitAfterFinancialItemsK": -22,
                    "rs_SumFinancialItemsK": 0,
                    "software": "BL Bokslut"
                },
                "mostRecentPurpose": "Föremålet för bolagets verksamhet är att tillhandahålla / assistenthjälp, bedriva konsultations- och föreläsnings/ verksamhet, äga och förvalta värdepapper och därmed / förenlig verksamhet.",
                "mostRecentRegisteredAddress": {
                    "addressType": "registeredAddress",
                    "city": "Hagalund",
                    "co": "C/O Ola Kemze",
                    "countryCodeAlpha3": "SWE",
                    "houseNumber": "14",
                    "location": [
                        59.36196,
                        18.00999
                    ],
                    "postalCode": "16963",
                    "street": "Hagalundsgatan"
                },
                "registeredOfficeCounty": "Stockholms län",
                "registeredOfficeCountyCode": "01",
                "registeredOfficeMunicipality": "Solna",
                "registeredOfficeMunicipalityCode": "0184",
                "registrationDate": 1274054400,
                "registrationNumber": "5568084767",
                "sniCodes": [
                    {
                        "sni_2007Code": "88102",
                        "sni_2007Name": "Öppna sociala insatser för personer med funktionshinder"
                    },
                    {
                        "sni_2007Code": "90010",
                        "sni_2007Name": "Artistisk verksamhet"
                    }
                ],
                "trusteeAdddressCity": "STOCKHOLM",
                "trusteeAddressPostalCode": "102 04",
                "trusteeAddressStreet": "Box 55555",
                "trusteeCO": "Advokatfirman Fylgia KB",
                "trusteeName": "XXX"
            }...