Skip to content
Datapublica
Staging · partial source data for evaluation
All analyses

Companies with foundation owners

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 10 October 2026.

The companies

Showing 0–0 of 0

Sorted by: employee count, missing last, highest first · then name and company ID

#CompanyEmployeesRegistered ownerCityPeriod endEvidence

No companies match this snapshot.

One row per company · amounts in DKKHow this list was made ↓

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.

Source data 2026-10-10Analysis run 2026-10-10
Scope and limitations

The foundation need not own a majority. Indirect foundation ownership is excluded.

Run your own company analysis in ChatGPT

  1. 1Create your free account
  2. 2Install Datapublica in your AI app
  3. 3Ask in your own words
Open in ChatGPTSet up ChatGPT
ChatGPT

Datapublica 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 10 October 2026.

Demonstration · the question can be adapted
Read and copy all prompts
  • 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 10 October 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 10 October 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 10 October 2026. Compare results by employee count.

Our AI performs advanced analyses of Danish companies for you

You don’t need to write SQL to combine data and create advanced extracts. Our AI does that for you; just ask a question. Here is how the analysis Companies with foundation owners was created using SQL and Datapublica’s database.

SQL1 / 4
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-10-10') AND (o.ownership_percent_valid_to IS NULL OR try_cast(o.ownership_percent_valid_to AS TIMESTAMPTZ) > TIMESTAMPTZ '2026-10-10')) 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-10-10') AND (o.ownership_percent_valid_to IS NULL OR try_cast(o.ownership_percent_valid_to AS TIMESTAMPTZ) > TIMESTAMPTZ '2026-10-10'))
ORDER BY employees DESC NULLS LAST, base.company_name ASC, base.cvr_number ASC

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 results are listed above: 0 companies match the stated criteria. View the first 10 here and the full list with a free account.

Sources and update

CVR records and published accounts from Virk are normalized and joined in Datapublica data marts. This list is a saved result of the SQL query above.

Extracted: 2026-10-10T09:01:51.323Z

build_a7ad137f038b0101c1bfCVR / Virk ↗