Data dowload

Path to the orginal data: ’C:- SGHAkademicki 2015Badawcze\2025 SGH Projekty RID!_PL-SK_DataExchangFolderRID’

The data was copied here The download of the data was and serach crieteria as follows: List export
Product name Orbis
Update number 389002
Software version 389
Data update 09/05/2026 (n° 389002)
Username pstasz
Export date 12/05/2026 2:09:26 PM
Search Strategy
Search Step Step result Search result 1. Status Active, Inactive companies, Unknown situation, Bankruptcy, Dissolved (demerger), Dissolved (merger or take-over), Administratively suspended, In liquidation, Dissolved (bankruptcy), Dissolved, Dissolved (liquidation), Active companies, Inactive (no precision) 629,441,986 629,441,986 2. World region/Country/Region in country Cyprus, Czech Republic, Estonia, Hungary, Latvia, Lithuania, Malta, Poland, Slovakia, Slovenia 16,931,982 16,931,507 3. Number of employees min=51, Last available year, Last year -1, Last year -2, for all the selected periods, exclusion of companies with no recent financial data and Public authorities/States/Governments 699,449 35,854 Boolean search 1 and 2 and 3
TOTAL 35,854
Search options
Financial searches Exclude companies with no recent financial data
Exclude public authorities/states/governments
Sets of accounts The most recent accounts available
Information options
Fiscal year end 31/03
Definition of the Ultimate Owner
The minimum percentage of control in the path from a subject company to its Ultimate Owner must be: 50.01%
A company is considered to be an Ultimate Owner(UO) if it has no identified shareholders or if it’s shareholder’s percentages are not known.
Definition of the Beneficial Owner
Path of minimum 10.00% at first level, minimum 50.01% at further levels, include top level individuals with unknown percentage or with minimum 10.00% (50.01% at each level)

Data import to R

insall

# install.packages("rlang")
# install.packages("dplyr")
# install.packages("tidyr")
# install.packages("lubridate")

Basic liabaries

library(readxl)
library(dplyr)
## 
## Dołączanie pakietu: 'dplyr'
## Następujące obiekty zostały zakryte z 'package:stats':
## 
##     filter, lag
## Następujące obiekty zostały zakryte z 'package:base':
## 
##     intersect, setdiff, setequal, union
library(purrr)
library(janitor)
## 
## Dołączanie pakietu: 'janitor'
## Następujące obiekty zostały zakryte z 'package:stats':
## 
##     chisq.test, fisher.test
library(tidyr) 

Reading the data from Excel

DB <- read_excel("V1_All_10_EU.xlsx", sheet = "ForImport", col_types = "text",  na = c("n.a.", "n.s.", "NA", "N/A", "b.d.", ""))

The data in excel is in whide format including the status problematic data

DB <- DB %>%
  mutate(across(
    c(31:514, 526:536),   # tylko kolumny finansowe
    ~ as.numeric(gsub(",", ".", .))
  ))
## Warning: There were 485 warnings in `mutate()`.
## The first warning was:
## ℹ In argument: `across(c(31:514, 526:536), ~as.numeric(gsub(",", ".", .)))`.
## Caused by warning:
## ! pojawiły się wartości NA na skutek przekształcenia
## ℹ Run `dplyr::last_dplyr_warnings()` to see the 484 remaining warnings.

bez 515-525 audit sttus od C31

id_cols <- c(
  "CompanyNameLatinAlphabet",
  "BvdAccountNumber",
  "NationalId" 
)

DB2 <- DB %>%
  fill(all_of(id_cols), .direction = "down")

Convert status data into the wide panel, to be possible for the management purposes.

library(dplyr)
library(tidyr)
library(lubridate)
## 
## Dołączanie pakietu: 'lubridate'
## Następujące obiekty zostały zakryte z 'package:base':
## 
##     date, intersect, setdiff, union
# -----------------------------
# 1. columns identifying company
# -----------------------------

id_cols <- c(
  "CompanyNameLatinAlphabet",
  "BvdAccountNumber",
  "NationalId"
)

# -----------------------------
# 2. fill company info downward
# -----------------------------

DB2 <- DB %>%
  fill(all_of(id_cols), .direction = "down")

# -----------------------------
# 3. keep rows with status history
# -----------------------------



history <- DB2 %>%
  
  filter(!is.na(StatusYear)) %>%
  
  mutate(
    
    # clean text
    StatusDate = trimws(StatusDate),
    StatusDate = na_if(StatusDate, ""),
    StatusDate = na_if(StatusDate, "n.a."),
    
    # convert Excel numeric dates
    StatusDate = ifelse(
      grepl("^[0-9]+$", StatusDate),
      
      as.character(
        as.Date(
          as.numeric(StatusDate),
          origin = "1899-12-30"
        )
      ),
      
      StatusDate
    ),
    
    # final conversion to Date
    StatusDate = dmy(StatusDate)
    
  )
## Warning: There were 2 warnings in `mutate()`.
## The first warning was:
## ℹ In argument: `StatusDate = ifelse(...)`.
## Caused by warning in `as.Date()`:
## ! pojawiły się wartości NA na skutek przekształcenia
## ℹ Run `dplyr::last_dplyr_warnings()` to see the 1 remaining warning.
# -----------------------------
# 4. convert Excel numeric dates
# -----------------------------

history <- history %>%
  mutate(
    StatusDate = as.Date(
      StatusDate,
      origin = "1899-12-30"
    )
  )

# -----------------------------
# 5. keep latest status in each year
# -----------------------------

history_latest <- history %>%
  group_by(
    CompanyNameLatinAlphabet,
    StatusYear
  ) %>%
  arrange(
    desc(StatusDate),
    .by_group = TRUE
  ) %>%
  slice(1) %>%
  ungroup()

# -----------------------------
# 6. reshape to wide
# -----------------------------

status_wide <- history_latest %>%
  select(
    CompanyNameLatinAlphabet,
    StatusYear,
    Status
  ) %>%
  pivot_wider(
    names_from = StatusYear,
    values_from = Status,
    names_prefix = "Status_"
  )

# -----------------------------
# 7. keep all companies
# -----------------------------

companies <- DB2 %>%
  filter(
    !is.na(CompanyNameLatinAlphabet)
  ) %>%
  distinct(
    CompanyNameLatinAlphabet,
    .keep_all = TRUE
  )

# -----------------------------
# 8. merge back
# -----------------------------

FINAL_DB <- companies %>%
  left_join(
    status_wide,
    by = "CompanyNameLatinAlphabet"
  )

Clean up the unsed obects anymore

rm(companies,DB2, history, history_latest)

I keep status wide, just for the sake of the checking the data

Write the data to RDS file for next section namely to make form width to long panel

library(writexl)
saveRDS(FINAL_DB, "InterimData/DB_final.rds")
write_xlsx(FINAL_DB, "InterimData/DB_final.xlsx")

Check danych

na_summary <- sapply(DB, function(x) sum(is.na(x)))
na_summary <- sort(na_summary, decreasing = TRUE)
na_summary
##                                         Latitude 
##                                            40739 
##                                        Longitude 
##                                            40739 
##                          WomanOwnedIndicatorInUs 
##                                            40739 
##                 EthnicMinorityOwnedIndicatorInUs 
##                                            40739 
##            NetCashFromFinancingActivitiesEur2025 
##                                            40533 
##       CashCashEquivalentsAtTheEndOfPeriodEur2025 
##                                            40533 
##            NetCashFromInvestingActivitiesEur2025 
##                                            40532 
##            NetCashFromOperatingActivitiesEur2025 
##                                            40531 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2025 
##                                            40531 
##                     ExtraordinaryRevenuesEur2025 
##                                            40454 
##                                  AuditStatus2025 
##                                            40447 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2015 
##                                            40421 
##            NetCashFromFinancingActivitiesEur2015 
##                                            40419 
##       CashCashEquivalentsAtTheEndOfPeriodEur2015 
##                                            40419 
##            NetCashFromOperatingActivitiesEur2015 
##                                            40418 
##            NetCashFromInvestingActivitiesEur2015 
##                                            40418 
##       CashCashEquivalentsAtTheEndOfPeriodEur2016 
##                                            40412 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2016 
##                                            40411 
##            NetCashFromInvestingActivitiesEur2016 
##                                            40410 
##            NetCashFromFinancingActivitiesEur2016 
##                                            40410 
##            NetCashFromOperatingActivitiesEur2016 
##                                            40409 
##            NetCashFromFinancingActivitiesEur2017 
##                                            40399 
##            NetCashFromInvestingActivitiesEur2017 
##                                            40398 
##            NetCashFromOperatingActivitiesEur2017 
##                                            40396 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2017 
##                                            40396 
##       CashCashEquivalentsAtTheEndOfPeriodEur2017 
##                                            40395 
##       CashCashEquivalentsAtTheEndOfPeriodEur2018 
##                                            40385 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2018 
##                                            40383 
##            NetCashFromInvestingActivitiesEur2018 
##                                            40382 
##            NetCashFromFinancingActivitiesEur2018 
##                                            40382 
##            NetCashFromOperatingActivitiesEur2018 
##                                            40380 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2019 
##                                            40374 
##            NetCashFromInvestingActivitiesEur2019 
##                                            40370 
##            NetCashFromFinancingActivitiesEur2019 
##                                            40369 
##       CashCashEquivalentsAtTheEndOfPeriodEur2019 
##                                            40367 
##            NetCashFromOperatingActivitiesEur2019 
##                                            40365 
##            NetCashFromFinancingActivitiesEur2020 
##                                            40357 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2020 
##                                            40357 
##            NetCashFromInvestingActivitiesEur2020 
##                                            40354 
##                     ExtraordinaryExpensesEur2025 
##                                            40353 
##       CashCashEquivalentsAtTheEndOfPeriodEur2020 
##                                            40353 
##            NetCashFromOperatingActivitiesEur2020 
##                                            40352 
##       CashCashEquivalentsAtTheEndOfPeriodEur2021 
##                                            40343 
##            NetCashFromOperatingActivitiesEur2021 
##                                            40341 
##            NetCashFromFinancingActivitiesEur2021 
##                                            40341 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2021 
##                                            40341 
##            NetCashFromInvestingActivitiesEur2021 
##                                            40340 
##            NetCashFromFinancingActivitiesEur2024 
##                                            40340 
##            NetCashFromOperatingActivitiesEur2024 
##                                            40337 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2024 
##                                            40337 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2022 
##                                            40337 
##            NetCashFromInvestingActivitiesEur2024 
##                                            40336 
##       CashCashEquivalentsAtTheEndOfPeriodEur2024 
##                                            40336 
##            NetCashFromOperatingActivitiesEur2023 
##                                            40335 
##            NetCashFromInvestingActivitiesEur2022 
##                                            40335 
##            NetCashFromFinancingActivitiesEur2022 
##                                            40335 
##            NetCashFromInvestingActivitiesEur2023 
##                                            40334 
##            NetCashFromFinancingActivitiesEur2023 
##                                            40334 
## CashCashEquivalentsAtTheBeginningOfPeriodEur2023 
##                                            40334 
##       CashCashEquivalentsAtTheEndOfPeriodEur2023 
##                                            40333 
##       CashCashEquivalentsAtTheEndOfPeriodEur2022 
##                                            40333 
##            NetCashFromOperatingActivitiesEur2022 
##                                            40332 
##                                  AuditStatus2015 
##                                            40287 
##                                  AuditStatus2016 
##                                            40273 
##                                  AuditStatus2017 
##                                            40252 
##                                  AuditStatus2018 
##                                            40236 
##                                  AuditStatus2019 
##                                            40215 
##                                  AuditStatus2020 
##                                            40200 
##                                  AuditStatus2021 
##                                            40183 
##                                  AuditStatus2024 
##                                            40181 
##                                  AuditStatus2023 
##                                            40176 
##                                  AuditStatus2022 
##                                            40173 
##                                       IsinNumber 
##                                            39973 
##                                     TickerSymbol 
##                                            39971 
##          NetExtraordinaryRevenuesExpensesEur2025 
##                                            39689 
##                          FinancialRevenueEur2025 
##                                            38484 
##                          CostsOfGoodsSoldEur2025 
##                                            38474 
##                     ExtraordinaryRevenuesEur2016 
##                                            38443 
##                     ExtraordinaryRevenuesEur2017 
##                                            38403 
##               OtherOperatingExpenseIncomeEur2025 
##                                            38386 
##                               GrossProfitEur2025 
##                                            38380 
##                     ExtraordinaryRevenuesEur2018 
##                                            38314 
##                         FinancialExpensesEur2025 
##                                            38307 
##                         OfWhichProvisionsEur2025 
##                                            38248 
##                     ExtraordinaryRevenuesEur2019 
##                                            38128 
##                     ExtraordinaryExpensesEur2016 
##                                            38045 
##                              LongTermDebtEur2025 
##                                            38025 
##                OtherNonCurrentLiabilitiesEur2025 
##                                            38024 
##                  IncomeTaxExpensesBenefitEur2025 
##                                            37943 
##                     ExtraordinaryExpensesEur2017 
##                                            37900 
##                     ExtraordinaryRevenuesEur2020 
##                                            37839 
##                     ExtraordinaryRevenuesEur2021 
##                                            37819 
##                        LoansShortTermDebtEur2025 
##                                            37809 
##                     ExtraordinaryRevenuesEur2022 
##                                            37773 
##                     ExtraordinaryRevenuesEur2024 
##                                            37709 
##                     ExtraordinaryRevenuesEur2023 
##                                            37685 
##                     ExtraordinaryExpensesEur2018 
##                                            37681 
##                   OtherCurrentLiabilitiesEur2025 
##                                            37673 
##                                     StockEur2025 
##                                            37672 
##                                 CreditorsEur2025 
##                                            37671 
##                                   DebtorsEur2025 
##                                            37669 
##                          IntangibleAssetsEur2025 
##                                            37635 
##                     OtherNonCurrentAssetsEur2025 
##                                            37604 
##                 OfWhichCashCashEquivalentEur2025 
##                                            37590 
##                                     SalesEur2025 
##                                            37577 
##                     NonCurrentLiabilitiesEur2025 
##                                            37574 
##                     ProfitLossAfterTaxPatEur2025 
##                                            37556 
##                   OperatingProfitLossEbitEur2025 
##                                            37555 
##                       FinancialProfitLossEur2025 
##                                            37554 
##                                   CapitalEur2025 
##                                            37552 
##                          NonCurrentAssetsEur2025 
##                                            37548 
##                        CurrentLiabilitiesEur2025 
##                                            37548 
##                             CurrentAssetsEur2025 
##                                            37547 
##                        OtherCurrentAssetsEur2025 
##                                            37547 
##                    OtherShareholdersFundsEur2025 
##                                            37547 
##         TotalShareholdersFundsLiabilitiesEur2025 
##                                            37544 
##       TotalShareholdersFundsLiabilitiesEur2025_1 
##                                            37544 
##           ProfitLossForThePeriodNetIncomeEur2025 
##                                            37477 
##                    ProfitLossBeforeTaxPbtEur2025 
##                                            37473 
##                  OperatingRevenueTurnoverEur2025 
##                                            37465 
##                         ShareholdersFundsEur2025 
##                                            37463 
##                               TotalAssetsEur2025 
##                                            37462 
##                     ExtraordinaryExpensesEur2019 
##                                            37208 
##                     ExtraordinaryExpensesEur2024 
##                                            36964 
##                     ExtraordinaryExpensesEur2020 
##                                            36907 
##                     ExtraordinaryExpensesEur2021 
##                                            36830 
##                     ExtraordinaryExpensesEur2023 
##                                            36769 
##                     ExtraordinaryExpensesEur2022 
##                                            36764 
##                       TangibleFixedAssetsEur2025 
##                                            36705 
##                                   FiscalYear2025 
##                                            36588 
##                     ExtraordinaryRevenuesEur2015 
##                                            36389 
##                     ExtraordinaryExpensesEur2015 
##                                            36327 
##          NetExtraordinaryRevenuesExpensesEur2016 
##                                            35402 
##          NetExtraordinaryRevenuesExpensesEur2017 
##                                            35135 
##          NetExtraordinaryRevenuesExpensesEur2018 
##                                            34858 
##          NetExtraordinaryRevenuesExpensesEur2019 
##                                            34276 
##          NetExtraordinaryRevenuesExpensesEur2024 
##                                            34047 
##          NetExtraordinaryRevenuesExpensesEur2020 
##                                            33962 
##          NetExtraordinaryRevenuesExpensesEur2021 
##                                            33857 
##          NetExtraordinaryRevenuesExpensesEur2023 
##                                            33827 
##          NetExtraordinaryRevenuesExpensesEur2015 
##                                            33824 
##          NetExtraordinaryRevenuesExpensesEur2022 
##                                            33770 
##                                       StatusYear 
##                                            31957 
##                                       StatusDate 
##                                            31952 
##               OtherOperatingExpenseIncomeEur2015 
##                                            31533 
##                               GrossProfitEur2015 
##                                            31378 
##               OtherOperatingExpenseIncomeEur2016 
##                                            29342 
##                          CostsOfGoodsSoldEur2015 
##                                            29054 
##                         LeiLegalEntityIdentifier 
##                                            29007 
##                               GrossProfitEur2016 
##                                            28829 
##                         OfWhichProvisionsEur2015 
##                                            26903 
##                          CostsOfGoodsSoldEur2016 
##                                            26738 
##                          CostsOfGoodsSoldEur2017 
##                                            26217 
##                          CostsOfGoodsSoldEur2018 
##                                            26113 
##               OtherOperatingExpenseIncomeEur2017 
##                                            25866 
##               OtherOperatingExpenseIncomeEur2018 
##                                            25465 
##                               GrossProfitEur2017 
##                                            25449 
##                          CostsOfGoodsSoldEur2019 
##                                            25410 
##                               GrossProfitEur2018 
##                                            25144 
##               OtherOperatingExpenseIncomeEur2019 
##                                            24534 
##                         OfWhichProvisionsEur2016 
##                                            24491 
##                          CostsOfGoodsSoldEur2024 
##                                            24207 
##                               GrossProfitEur2019 
##                                            24181 
##                          CostsOfGoodsSoldEur2020 
##                                            24016 
##                          CostsOfGoodsSoldEur2021 
##                                            23753 
##                         OfWhichProvisionsEur2017 
##                                            23682 
##                          CostsOfGoodsSoldEur2023 
##                                            23662 
##                          CostsOfGoodsSoldEur2022 
##                                            23542 
##                         OfWhichProvisionsEur2018 
##                                            23082 
##               OtherOperatingExpenseIncomeEur2024 
##                                            22746 
##               OtherOperatingExpenseIncomeEur2020 
##                                            22698 
##                               GrossProfitEur2024 
##                                            22694 
##                               GrossProfitEur2020 
##                                            22590 
##                                EuropeanVatNumber 
##                                            22465 
##                              LongTermDebtEur2015 
##                                            22455 
##                OtherNonCurrentLiabilitiesEur2015 
##                                            22430 
##               OtherOperatingExpenseIncomeEur2021 
##                                            22316 
##                               GrossProfitEur2021 
##                                            22249 
##               OtherOperatingExpenseIncomeEur2023 
##                                            22099 
##                               GrossProfitEur2023 
##                                            22058 
##               OtherOperatingExpenseIncomeEur2022 
##                                            21997 
##                               GrossProfitEur2022 
##                                            21955 
##                         OfWhichProvisionsEur2020 
##                                            21409 
##                                     VatTaxNumber 
##                                            21085 
##                  IncomeTaxExpensesBenefitEur2015 
##                                            20843 
##                                       NationalId 
##                                            20799 
##                         OfWhichProvisionsEur2021 
##                                            20605 
##                         OfWhichProvisionsEur2024 
##                                            20480 
##                         OfWhichProvisionsEur2022 
##                                            20334 
##                          FinancialRevenueEur2015 
##                                            20236 
##                         OfWhichProvisionsEur2023 
##                                            20202 
##                              LongTermDebtEur2016 
##                                            19699 
##                OtherNonCurrentLiabilitiesEur2016 
##                                            19699 
##                              LongTermDebtEur2019 
##                                            19300 
##                OtherNonCurrentLiabilitiesEur2019 
##                                            19233 
##                         FinancialExpensesEur2015 
##                                            19093 
##                              LongTermDebtEur2017 
##                                            18781 
##                OtherNonCurrentLiabilitiesEur2017 
##                                            18756 
##                  IncomeTaxExpensesBenefitEur2016 
##                                            18519 
##                              LongTermDebtEur2018 
##                                            18288 
##                              LongTermDebtEur2020 
##                                            18283 
##                OtherNonCurrentLiabilitiesEur2018 
##                                            18258 
##                OtherNonCurrentLiabilitiesEur2020 
##                                            18220 
##                                StatisticalNumber 
##                                            18156 
##                          FinancialRevenueEur2016 
##                                            18134 
##                        LoansShortTermDebtEur2015 
##                                            17812 
##                              LongTermDebtEur2024 
##                                            17796 
##                OtherNonCurrentLiabilitiesEur2024 
##                                            17763 
##                              LongTermDebtEur2021 
##                                            17550 
##                OtherNonCurrentLiabilitiesEur2021 
##                                            17489 
##                  IncomeTaxExpensesBenefitEur2017 
##                                            17354 
##                              LongTermDebtEur2022 
##                                            17325 
##                              LongTermDebtEur2023 
##                                            17279 
##                OtherNonCurrentLiabilitiesEur2022 
##                                            17262 
##                OtherNonCurrentLiabilitiesEur2023 
##                                            17238 
##                          FinancialRevenueEur2017 
##                                            17209 
##                          FinancialRevenueEur2018 
##                                            17204 
##                         FinancialExpensesEur2016 
##                                            17113 
##                          IntangibleAssetsEur2015 
##                                            16989 
##                     OtherNonCurrentAssetsEur2015 
##                                            16971 
##                                   DebtorsEur2015 
##                                            16804 
##                          FinancialRevenueEur2021 
##                                            16726 
##                  IncomeTaxExpensesBenefitEur2018 
##                                            16690 
##                                     StockEur2015 
##                                            16685 
##                                     SalesEur2015 
##                                            16681 
##                   OtherCurrentLiabilitiesEur2015 
##                                            16604 
##                                 CreditorsEur2015 
##                                            16564 
##                     NonCurrentLiabilitiesEur2015 
##                                            16546 
##                 OfWhichCashCashEquivalentEur2015 
##                                            16491 
##                          FinancialRevenueEur2019 
##                                            16387 
##                        OtherCurrentAssetsEur2015 
##                                            16273 
##                     ProfitLossAfterTaxPatEur2015 
##                                            16230 
##                   OperatingProfitLossEbitEur2015 
##                                            16224 
##                       FinancialProfitLossEur2015 
##                                            16223 
##                             CurrentAssetsEur2015 
##                                            16153 
##                          NonCurrentAssetsEur2015 
##                                            16150 
##                        CurrentLiabilitiesEur2015 
##                                            16149 
##                                   CapitalEur2015 
##                                            16147 
##                    OtherShareholdersFundsEur2015 
##                                            16146 
##         TotalShareholdersFundsLiabilitiesEur2015 
##                                            16142 
##      TotalShareholdersFundsLiabilitiesEur2015_11 
##                                            16142 
##                    ProfitLossBeforeTaxPbtEur2015 
##                                            16091 
##           ProfitLossForThePeriodNetIncomeEur2015 
##                                            16090 
##                       TangibleFixedAssetsEur2015 
##                                            16075 
##                          FinancialRevenueEur2020 
##                                            16042 
##                               TotalAssetsEur2015 
##                                            16014 
##                         ShareholdersFundsEur2015 
##                                            16001 
##                  IncomeTaxExpensesBenefitEur2019 
##                                            15962 
##                  OperatingRevenueTurnoverEur2015 
##                                            15886 
##                         FinancialExpensesEur2017 
##                                            15784 
##                         FinancialExpensesEur2018 
##                                            15411 
##                          FinancialRevenueEur2022 
##                                            15247 
##                          FinancialRevenueEur2024 
##                                            15243 
##                  IncomeTaxExpensesBenefitEur2020 
##                                            15184 
##                                   FiscalYear2015 
##                                            15180 
##                        LoansShortTermDebtEur2016 
##                                            14875 
##                          FinancialRevenueEur2023 
##                                            14603 
##                         FinancialExpensesEur2019 
##                                            14431 
##                         FinancialExpensesEur2020 
##                                            14392 
##                       TaxIdentificationNumberTin 
##                                            14258 
##                         FinancialExpensesEur2024 
##                                            14068 
##                        LoansShortTermDebtEur2017 
##                                            13985 
##                  IncomeTaxExpensesBenefitEur2024 
##                                            13762 
##                         FinancialExpensesEur2021 
##                                            13521 
##                  IncomeTaxExpensesBenefitEur2021 
##                                            13496 
##                   OtherCurrentLiabilitiesEur2016 
##                                            13349 
##                         FinancialExpensesEur2023 
##                                            13167 
##                                 CreditorsEur2016 
##                                            13157 
##                         FinancialExpensesEur2022 
##                                            13097 
##                                     SalesEur2016 
##                                            13032 
##                        LoansShortTermDebtEur2018 
##                                            13008 
##                  IncomeTaxExpensesBenefitEur2023 
##                                            12900 
##                     ProfitLossAfterTaxPatEur2016 
##                                            12893 
##                                   DebtorsEur2016 
##                                            12877 
##           ProfitLossForThePeriodNetIncomeEur2016 
##                                            12758 
##                  IncomeTaxExpensesBenefitEur2022 
##                                            12704 
##                                   CapitalEur2016 
##                                            12409 
##                    OtherShareholdersFundsEur2016 
##                                            12407 
##                          IntangibleAssetsEur2016 
##                                            12391 
##                        OtherCurrentAssetsEur2016 
##                                            12367 
##                     OtherNonCurrentAssetsEur2016 
##                                            12362 
##                   OtherCurrentLiabilitiesEur2017 
##                                            12313 
##                                 CreditorsEur2017 
##                                            12089 
##                                     StockEur2016 
##                                            11957 
##                       FinancialProfitLossEur2016 
##                                            11936 
##                        LoansShortTermDebtEur2019 
##                                            11845 
##                     NonCurrentLiabilitiesEur2016 
##                                            11814 
##                    ProfitLossBeforeTaxPbtEur2016 
##                                            11810 
##                 OfWhichCashCashEquivalentEur2016 
##                                            11783 
##                   OperatingProfitLossEbitEur2016 
##                                            11766 
##                                     SalesEur2017 
##                                            11760 
##                       TangibleFixedAssetsEur2016 
##                                            11663 
##                        LoansShortTermDebtEur2024 
##                                            11643 
##                                   DebtorsEur2017 
##                                            11640 
##                  OperatingRevenueTurnoverEur2016 
##                                            11612 
##                     ProfitLossAfterTaxPatEur2017 
##                                            11526 
##           ProfitLossForThePeriodNetIncomeEur2017 
##                                            11434 
##                        CurrentLiabilitiesEur2016 
##                                            11389 
##                          NonCurrentAssetsEur2016 
##                                            11382 
##                        LoansShortTermDebtEur2020 
##                                            11360 
##                             CurrentAssetsEur2016 
##                                            11347 
##         TotalShareholdersFundsLiabilitiesEur2016 
##                                            11346 
##      TotalShareholdersFundsLiabilitiesEur2016_10 
##                                            11346 
##                                 CreditorsEur2018 
##                                            11340 
##                   OtherCurrentLiabilitiesEur2018 
##                                            11309 
##                          IntangibleAssetsEur2017 
##                                            11244 
##                                   CapitalEur2017 
##                                            11235 
##                    OtherShareholdersFundsEur2017 
##                                            11235 
##                               TotalAssetsEur2016 
##                                            11214 
##                         ShareholdersFundsEur2016 
##                                            11211 
##                     OtherNonCurrentAssetsEur2017 
##                                            11208 
##                        OtherCurrentAssetsEur2017 
##                                            11198 
##                                     SalesEur2018 
##                                            10868 
##                                   CapitalEur2018 
##                                            10834 
##                                     StockEur2017 
##                                            10824 
##                          IntangibleAssetsEur2018 
##                                            10766 
##                                   FiscalYear2016 
##                                            10748 
##                        LoansShortTermDebtEur2021 
##                                            10701 
##                        LoansShortTermDebtEur2023 
##                                            10676 
##                     NonCurrentLiabilitiesEur2017 
##                                            10642 
##                 OfWhichCashCashEquivalentEur2017 
##                                            10572 
##                       FinancialProfitLossEur2017 
##                                            10521 
##                     ProfitLossAfterTaxPatEur2018 
##                                            10506 
##                     OtherNonCurrentAssetsEur2018 
##                                            10500 
##                                   DebtorsEur2018 
##                                            10486 
##           ProfitLossForThePeriodNetIncomeEur2018 
##                                            10430 
##                    OtherShareholdersFundsEur2018 
##                                            10419 
##                    ProfitLossBeforeTaxPbtEur2017 
##                                            10395 
##                        OtherCurrentAssetsEur2018 
##                                            10360 
##                   OperatingProfitLossEbitEur2017 
##                                            10315 
##                                 CreditorsEur2019 
##                                            10297 
##                   OtherCurrentLiabilitiesEur2019 
##                                            10280 
##                        LoansShortTermDebtEur2022 
##                                            10193 
##                        CurrentLiabilitiesEur2017 
##                                            10190 
##                          NonCurrentAssetsEur2017 
##                                            10151 
##                                     StockEur2018 
##                                            10145 
##                             CurrentAssetsEur2017 
##                                            10128 
##         TotalShareholdersFundsLiabilitiesEur2017 
##                                            10126 
##       TotalShareholdersFundsLiabilitiesEur2017_9 
##                                            10126 
##                  OperatingRevenueTurnoverEur2017 
##                                            10093 
##                         ShareholdersFundsEur2017 
##                                             9995 
##                               TotalAssetsEur2017 
##                                             9989 
##                                 CreditorsEur2020 
##                                             9963 
##                                 CreditorsEur2024 
##                                             9961 
##                   OtherCurrentLiabilitiesEur2024 
##                                             9921 
##                   OtherCurrentLiabilitiesEur2020 
##                                             9853 
##                       FinancialProfitLossEur2018 
##                                             9849 
##                 OfWhichCashCashEquivalentEur2018 
##                                             9803 
##                     NonCurrentLiabilitiesEur2018 
##                                             9776 
##                                     SalesEur2019 
##                                             9587 
##                    ProfitLossBeforeTaxPbtEur2018 
##                                             9555 
##                   OperatingProfitLossEbitEur2018 
##                                             9474 
##                                     StockEur2019 
##                                             9472 
##                                     SalesEur2024 
##                                             9465 
##                                   DebtorsEur2019 
##                                             9441 
##                          IntangibleAssetsEur2024 
##                                             9405 
##                       TangibleFixedAssetsEur2017 
##                                             9358 
##                        CurrentLiabilitiesEur2018 
##                                             9347 
##                          NonCurrentAssetsEur2018 
##                                             9321 
##                                     StockEur2024 
##                                             9320 
##                                 CreditorsEur2021 
##                                             9318 
##                                   DebtorsEur2024 
##                                             9310 
##                     ProfitLossAfterTaxPatEur2024 
##                                             9297 
##                          IntangibleAssetsEur2019 
##                                             9296 
##                    OtherShareholdersFundsEur2024 
##                                             9281 
##                                   CapitalEur2024 
##                                             9272 
##                             CurrentAssetsEur2018 
##                                             9252 
##         TotalShareholdersFundsLiabilitiesEur2018 
##                                             9250 
##       TotalShareholdersFundsLiabilitiesEur2018_8 
##                                             9250 
##                   OtherCurrentLiabilitiesEur2021 
##                                             9211 
##           ProfitLossForThePeriodNetIncomeEur2024 
##                                             9196 
##                     ProfitLossAfterTaxPatEur2019 
##                                             9190 
##                                     SalesEur2020 
##                                             9187 
##                                     StockEur2020 
##                                             9178 
##                                   DebtorsEur2020 
##                                             9159 
##                    OtherShareholdersFundsEur2019 
##                                             9126 
##           ProfitLossForThePeriodNetIncomeEur2019 
##                                             9119 
##                                   CapitalEur2019 
##                                             9116 
##                         ShareholdersFundsEur2018 
##                                             9112 
##                               TotalAssetsEur2018 
##                                             9106 
##                  OperatingRevenueTurnoverEur2024 
##                                             9093 
##                     OtherNonCurrentAssetsEur2019 
##                                             9081 
##                        OtherCurrentAssetsEur2019 
##                                             9066 
##                          IntangibleAssetsEur2020 
##                                             8992 
##                                 CreditorsEur2023 
##                                             8952 
##                   OtherCurrentLiabilitiesEur2023 
##                                             8900 
##                     OtherNonCurrentAssetsEur2024 
##                                             8885 
##                     ProfitLossAfterTaxPatEur2020 
##                                             8856 
##                  OperatingRevenueTurnoverEur2018 
##                                             8855 
##                                   CapitalEur2020 
##                                             8795 
##                    OtherShareholdersFundsEur2020 
##                                             8795 
##           ProfitLossForThePeriodNetIncomeEur2020 
##                                             8772 
##                                 CreditorsEur2022 
##                                             8769 
##                        OtherCurrentAssetsEur2020 
##                                             8757 
##                     OtherNonCurrentAssetsEur2020 
##                                             8715 
##                   OtherCurrentLiabilitiesEur2022 
##                                             8667 
##                 OfWhichCashCashEquivalentEur2019 
##                                             8587 
##                 OfWhichCashCashEquivalentEur2024 
##                                             8577 
##                                     SalesEur2021 
##                                             8574 
##                     NonCurrentLiabilitiesEur2019 
##                                             8552 
##                                     StockEur2021 
##                                             8533 
##                                   DebtorsEur2021 
##                                             8520 
##                     NonCurrentLiabilitiesEur2024 
##                                             8495 
##                       FinancialProfitLossEur2024 
##                                             8467 
##                                     SalesEur2023 
##                                             8444 
##                       TangibleFixedAssetsEur2018 
##                                             8434 
##                       FinancialProfitLossEur2019 
##                                             8423 
##                                   FiscalYear2017 
##                                             8405 
##                          IntangibleAssetsEur2021 
##                                             8380 
##                    ProfitLossBeforeTaxPbtEur2024 
##                                             8346 
##                          IntangibleAssetsEur2023 
##                                             8338 
##                    ProfitLossBeforeTaxPbtEur2019 
##                                             8292 
##                                     StockEur2023 
##                                             8283 
##                                   DebtorsEur2023 
##                                             8271 
##                     ProfitLossAfterTaxPatEur2021 
##                                             8269 
##                    OtherShareholdersFundsEur2021 
##                                             8252 
##                                   CapitalEur2021 
##                                             8251 
##                     ProfitLossAfterTaxPatEur2023 
##                                             8251 
##                   OperatingProfitLossEbitEur2024 
##                                             8249 
##                                   CapitalEur2023 
##                                             8235 
##                    OtherShareholdersFundsEur2023 
##                                             8232 
##                 OfWhichCashCashEquivalentEur2020 
##                                             8214 
##           ProfitLossForThePeriodNetIncomeEur2021 
##                                             8205 
##                          NonCurrentAssetsEur2024 
##                                             8196 
##                        OtherCurrentAssetsEur2024 
##                                             8185 
##                        CurrentLiabilitiesEur2024 
##                                             8181 
##                             CurrentAssetsEur2024 
##                                             8162 
##         TotalShareholdersFundsLiabilitiesEur2024 
##                                             8158 
##       TotalShareholdersFundsLiabilitiesEur2024_2 
##                                             8158 
##           ProfitLossForThePeriodNetIncomeEur2023 
##                                             8153 
##                   OperatingProfitLossEbitEur2019 
##                                             8151 
##                       FinancialProfitLossEur2020 
##                                             8140 
##                        CurrentLiabilitiesEur2019 
##                                             8078 
##                     NonCurrentLiabilitiesEur2020 
##                                             8075 
##                                     SalesEur2022 
##                                             8074 
##                          NonCurrentAssetsEur2019 
##                                             8055 
##                                     StockEur2022 
##                                             8050 
##                                   DebtorsEur2022 
##                                             8037 
##                  OperatingRevenueTurnoverEur2019 
##                                             8035 
##                     OtherNonCurrentAssetsEur2021 
##                                             8021 
##                             CurrentAssetsEur2019 
##                                             8013 
##                         ShareholdersFundsEur2024 
##                                             8011 
##                               TotalAssetsEur2024 
##                                             8009 
##                          IntangibleAssetsEur2022 
##                                             8009 
##         TotalShareholdersFundsLiabilitiesEur2019 
##                                             7994 
##       TotalShareholdersFundsLiabilitiesEur2019_7 
##                                             7994 
##                    ProfitLossBeforeTaxPbtEur2020 
##                                             7975 
##                    OtherShareholdersFundsEur2022 
##                                             7856 
##                         ShareholdersFundsEur2019 
##                                             7854 
##                               TotalAssetsEur2019 
##                                             7850 
##                                   CapitalEur2022 
##                                             7847 
##                     ProfitLossAfterTaxPatEur2022 
##                                             7838 
##                     OtherNonCurrentAssetsEur2023 
##                                             7831 
##                   OperatingProfitLossEbitEur2020 
##                                             7809 
##           ProfitLossForThePeriodNetIncomeEur2022 
##                                             7776 
##                          NonCurrentAssetsEur2020 
##                                             7733 
##                        CurrentLiabilitiesEur2020 
##                                             7729 
##                  OperatingRevenueTurnoverEur2020 
##                                             7722 
##                       TangibleFixedAssetsEur2019 
##                                             7698 
##                             CurrentAssetsEur2020 
##                                             7675 
##         TotalShareholdersFundsLiabilitiesEur2020 
##                                             7672 
##       TotalShareholdersFundsLiabilitiesEur2020_6 
##                                             7672 
##                 OfWhichCashCashEquivalentEur2021 
##                                             7611 
##                                   FiscalYear2018 
##                                             7560 
##                 OfWhichCashCashEquivalentEur2023 
##                                             7556 
##                     OtherNonCurrentAssetsEur2022 
##                                             7537 
##                         ShareholdersFundsEur2020 
##                                             7535 
##                       FinancialProfitLossEur2021 
##                                             7527 
##                               TotalAssetsEur2020 
##                                             7524 
##                       TangibleFixedAssetsEur2024 
##                                             7475 
##                     NonCurrentLiabilitiesEur2023 
##                                             7455 
##                     NonCurrentLiabilitiesEur2021 
##                                             7430 
##                       FinancialProfitLossEur2023 
##                                             7427 
##                    ProfitLossBeforeTaxPbtEur2021 
##                                             7373 
##                    ProfitLossBeforeTaxPbtEur2023 
##                                             7304 
##                       TangibleFixedAssetsEur2020 
##                                             7286 
##                   OperatingProfitLossEbitEur2023 
##                                             7187 
##                 OfWhichCashCashEquivalentEur2022 
##                                             7185 
##                   OperatingProfitLossEbitEur2021 
##                                             7185 
##                          NonCurrentAssetsEur2021 
##                                             7154 
##                        OtherCurrentAssetsEur2023 
##                                             7139 
##                        CurrentLiabilitiesEur2021 
##                                             7135 
##                          NonCurrentAssetsEur2023 
##                                             7130 
##                        OtherCurrentAssetsEur2021 
##                                             7127 
##                        CurrentLiabilitiesEur2023 
##                                             7124 
##                             CurrentAssetsEur2023 
##                                             7111 
##                             CurrentAssetsEur2021 
##                                             7108 
##         TotalShareholdersFundsLiabilitiesEur2023 
##                                             7099 
##       TotalShareholdersFundsLiabilitiesEur2023_3 
##                                             7099 
##         TotalShareholdersFundsLiabilitiesEur2021 
##                                             7093 
##       TotalShareholdersFundsLiabilitiesEur2021_5 
##                                             7093 
##                     NonCurrentLiabilitiesEur2022 
##                                             7088 
##                  OperatingRevenueTurnoverEur2021 
##                                             7083 
##                       FinancialProfitLossEur2022 
##                                             7051 
##                                   FiscalYear2024 
##                                             7025 
##                  OperatingRevenueTurnoverEur2023 
##                                             7000 
##                               TotalAssetsEur2023 
##                                             6949 
##                         ShareholdersFundsEur2023 
##                                             6949 
##                               TotalAssetsEur2021 
##                                             6942 
##                         ShareholdersFundsEur2021 
##                                             6941 
##                    ProfitLossBeforeTaxPbtEur2022 
##                                             6909 
##                                   FiscalYear2019 
##                                             6870 
##                   OperatingProfitLossEbitEur2022 
##                                             6773 
##                        CurrentLiabilitiesEur2022 
##                                             6743 
##                          NonCurrentAssetsEur2022 
##                                             6742 
##                        OtherCurrentAssetsEur2022 
##                                             6739 
##                             CurrentAssetsEur2022 
##                                             6715 
##         TotalShareholdersFundsLiabilitiesEur2022 
##                                             6706 
##       TotalShareholdersFundsLiabilitiesEur2022_4 
##                                             6706 
##                  OperatingRevenueTurnoverEur2022 
##                                             6615 
##                       TangibleFixedAssetsEur2021 
##                                             6612 
##                         ShareholdersFundsEur2022 
##                                             6558 
##                               TotalAssetsEur2022 
##                                             6554 
##                              TradeRegisterNumber 
##                                             6492 
##                                   FiscalYear2020 
##                                             6475 
##                       TangibleFixedAssetsEur2023 
##                                             6431 
##                       TangibleFixedAssetsEur2022 
##                                             6087 
##                                   FiscalYear2023 
##                                             5936 
##                                   FiscalYear2021 
##                                             5867 
##                                   FiscalYear2022 
##                                             5055 
##                              NaceRev2MainSection 
##                                             4909 
##                                         CoyIndex 
##                                             4904 
##                           NumberOfAvailableYears 
##                                             4904 
##                                  NationalIdLabel 
##                                             4895 
##                         CompanyNameLatinAlphabet 
##                                             4885 
##                                          Country 
##                                             4885 
##                                   CountryIsoCode 
##                                             4885 
##                                      BvdIdNumber 
##                                             4885 
##                                 BvdAccountNumber 
##                                             4885 
##                                    OrbisIdNumber 
##                                             4885 
##                               SizeClassification 
##                                             4885 
##                                     TypeOfEntity 
##                                             4885 
##                                ConsolidationCode 
##                                             4885 
##                                       FilingType 
##                                             4885 
##                                      Source.Name 
##                                                0 
##                                           Status 
##                                                0