# Companies with the same owner

Canonical: https://staging.datapublica.dk/en/analyses/faelles-personlig-ejer
Data snapshot: 2026-10-12 · build_f8c62a311608504d7a53+property_0007813891ca041817b80461052a651a8c1c5297abbfa84e4e8f3b38ce9ec4c3
Analysis run: 2026-10-12
Matches: 0 · Showing: 0 · Page: 1

Companies in Denmark with at least 50 employees and a personal legal owner with registered stakes in at least five companies as of 12 October 2026. Portfolios include inactive companies; the owner with the largest portfolio is shown for each company.
Only active companies with entity accounts, not consolidated group accounts. The latest accounts must be in DKK. Employees means the reporting-period average, not the current headcount.
Sorted by: companies in the owner’s portfolio, largest first · ties: name, then company ID
The count includes all companies with a current registered ownership relationship, including inactive companies. Ownership does not necessarily mean control.

## Companies

| Company | Registered owner | Companies in owner portfolio | Ownership stake | Employees | City | Period end |
| --- | --- | --- | --- | --- | --- | --- |

## Evidence per company

[Create a free account to view the full list](https://staging.datapublica.dk/en/signup?redirectTo=%2Fen%2Fanalyses%2Ffaelles-personlig-ejer)

## Our AI performs advanced analyses of Danish companies for you

1. Select latest accounts: Rank entity accounts by period end and publication. Use the latest if its currency is DKK.
2. Join company data: Join the accounts with company ID, name, address and incorporation date. Keep active companies.
3. Find relevant records: Count companies per personal owner and find owners with at least five companies. Select one owner per company.
4. Filter the list: Companies in Denmark with at least 50 employees and a personal legal owner with registered stakes in at least five companies as of 12 October 2026. Portfolios include inactive companies; the owner with the largest portfolio is shown for each company. count(*) OVER() counts all matches.
5. Sort the results: Sort by companies in the owner’s portfolio, largest first · ties: name, then company ID.

One row per company.

Companies in Denmark with at least 50 employees and a personal legal owner with registered stakes in at least five companies as of 12 October 2026. Portfolios include inactive companies; the owner with the largest portfolio is shown for each company.
Sorted by: companies in the owner’s portfolio, largest first · ties: name, then company ID
## SQL

```sql
WITH ranked AS (
 SELECT *, row_number() OVER (PARTITION BY cvr_number ORDER BY reporting_period_end DESC, publication_timestamp DESC, filing_id DESC, reporting_currency) AS rn
 FROM gold.mart_company_financials_annual_scoped
 WHERE statement_scope = 'entity'
), f AS (SELECT * FROM ranked WHERE rn = 1 AND reporting_currency = 'DKK'),
base AS (
 SELECT p.cvr_number, p.company_name, p.city, p.registered_address_slug, p.registered_address_identity, p.registered_address_formatted, p.founded_at,
 f.reporting_period_start, f.reporting_period_end, f.average_employees AS employees,
 f.operating_profit, f.profit_after_tax AS profit, f.equity, f.revenue
 FROM gold.mart_company_profile p JOIN f ON p.cvr_number = f.cvr_number
 WHERE p.is_active = true
), owners AS (SELECT DISTINCT cvr_number, person_id, display_name, slug, ownership_lower_percent, ownership_upper_percent, ownership_label FROM gold.mart_person_ownership WHERE ownership_kind = 'legal_owner' AND effective_from <= TIMESTAMPTZ '2026-10-12' AND (effective_to IS NULL OR effective_to > TIMESTAMPTZ '2026-10-12')), portfolios AS (SELECT person_id, count(DISTINCT cvr_number) AS owned_companies FROM owners GROUP BY person_id HAVING count(DISTINCT cvr_number) >= 5), matches AS (SELECT owners.*, owned_companies FROM owners JOIN portfolios USING(person_id) QUALIFY row_number() OVER(PARTITION BY cvr_number ORDER BY owned_companies DESC, person_id) = 1)
SELECT base.*, display_name AS owner_name, person_id, slug AS owner_slug, ownership_label, owned_companies, count(*) OVER() AS total_matches
FROM base JOIN matches USING(cvr_number)
WHERE base.employees >= 50
ORDER BY owned_companies DESC NULLS LAST, base.company_name ASC, base.cvr_number ASC
```

## From source to answer

Official CVR data and accounts → normalized identities, ownership stakes and periods → data marts → validated SQL → this result list.

Source: datapublica.dk
[CVR / Virk](https://datacvr.virk.dk/)

## Ask your own question

- Companies in Denmark with at least 50 employees and a personal legal owner with registered stakes in at least five companies as of 12 October 2026. Portfolios include inactive companies; the owner with the largest portfolio is shown for each company.
- Companies in Denmark with at least 50 employees and a personal legal owner with registered stakes in at least five companies as of 12 October 2026. Portfolios include inactive companies; the owner with the largest portfolio is shown for each company. Restrict the list to Aarhus.
- Companies in Denmark with at least 50 employees and a personal legal owner with registered stakes in at least five companies as of 12 October 2026. Portfolios include inactive companies; the owner with the largest portfolio is shown for each company. Include company addresses.

[ChatGPT](https://datapublica.dk/agents/chatgpt) · [Claude](https://datapublica.dk/agents/claude) · [Codex](https://datapublica.dk/agents/codex)


## Companies with the same owner

Looking for companies with the same owner, owners of multiple companies or shared company ownership? We ran the analysis using Datapublica company data. The list above shows the results: 0 companies match the stated criteria.