# Companies with foundation owners

Canonical: https://staging.datapublica.dk/en/analyses/fondsejede-virksomheder
Data snapshot: 2026-11-06 · build_9f3417e20fe2ef07ba2a+property_520c490ac4b3fcba50b285dc7216caf1c2466da3026a6e88b58647a377efe282
Analysis run: 2026-11-06
Matches: 0 · Showing: 0 · Page: 1

Active companies in Denmark with at least one current direct legal owner with a known positive stake, registered as a foundation or commercial foundation in CVR as of 6 November 2026.
The list is selected from CVR without requiring accounts or a minimum employee count. Any financial figures come from the latest entity accounts in DKK; employees are the period average.
Sorted by: employee count, missing last, highest first · then name and company ID
The foundation need not own a majority. Indirect foundation ownership is excluded.

## Companies

| Company | Employees | Registered owner | City | Period end |
| --- | --- | --- | --- | --- |

## Evidence per company

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

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

1. Find the latest entity accounts: Select the latest entity accounts by period end, then publication date. Exclude consolidated accounts. Apply DKK after ranking so older DKK accounts cannot replace newer foreign-currency accounts.
2. Join registry and accounts: Retain companies without accounts. Show financial figures where the latest entity accounts are in DKK.
3. Select the companies: Active companies in Denmark with at least one current direct legal owner with a known positive stake, registered as a foundation or commercial foundation in CVR as of 6 November 2026.
4. Sort the list: employee count, missing last, highest first · then name and company ID

One row per company.

Active companies in Denmark with at least one current direct legal owner with a known positive stake, registered as a foundation or commercial foundation in CVR as of 6 November 2026.
Sorted by: employee count, missing last, highest first · then name and 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, p.company_status, p.company_status_valid_from,
 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 LEFT JOIN f ON f.cvr_number=p.cvr_number
 WHERE p.is_active=true
)
SELECT base.*, (SELECT string_agg(DISTINCT o.owner_name, ', ' ORDER BY o.owner_name) FROM gold.mart_company_ownership o JOIN gold.mart_company_profile op ON op.cvr_number=o.owner_cvr_number WHERE o.cvr_number=base.cvr_number AND o.ownership_kind='legal_owner' AND o.ownership_lower_percent>0 AND op.legal_form_code IN ('90','100') AND (o.ownership_percent_valid_from IS NULL OR try_cast(o.ownership_percent_valid_from AS TIMESTAMPTZ) <= TIMESTAMPTZ '2026-11-06') AND (o.ownership_percent_valid_to IS NULL OR try_cast(o.ownership_percent_valid_to AS TIMESTAMPTZ) > TIMESTAMPTZ '2026-11-06')) AS owner_name, count(*) OVER() AS total_matches
FROM base
WHERE EXISTS (SELECT 1 FROM gold.mart_company_ownership o JOIN gold.mart_company_profile op ON op.cvr_number=o.owner_cvr_number WHERE o.cvr_number=base.cvr_number AND o.ownership_kind='legal_owner' AND o.ownership_lower_percent>0 AND op.legal_form_code IN ('90','100') AND (o.ownership_percent_valid_from IS NULL OR try_cast(o.ownership_percent_valid_from AS TIMESTAMPTZ) <= TIMESTAMPTZ '2026-11-06') AND (o.ownership_percent_valid_to IS NULL OR try_cast(o.ownership_percent_valid_to AS TIMESTAMPTZ) > TIMESTAMPTZ '2026-11-06'))
ORDER BY employees 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

- Active companies in Denmark with at least one current direct legal owner with a known positive stake, registered as a foundation or commercial foundation in CVR as of 6 November 2026.
- Active companies in Denmark with at least one current direct legal owner with a known positive stake, registered as a foundation or commercial foundation in CVR as of 6 November 2026. Include registered company addresses.
- Active companies in Denmark with at least one current direct legal owner with a known positive stake, registered as a foundation or commercial foundation in CVR as of 6 November 2026. Compare results by employee count.

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


## Companies with foundation owners

Looking for companies with foundation owners, Danish company lists and company comparisons? We ran the analysis using Datapublica company data. The list above shows the results: 0 companies match the stated criteria.