openregister

Data license: CC-By 4.0

Custom SQL query

Tables

Addresses

companyId, globalId, validFrom, fullAddress, address, zipCode, zipAndPlace, validTill, isCurrent

Many rows

Capital

companyId, globalId, validFrom, capitalAmount, capitalCurrency, validTill, isCurrent

Many rows

Companies

companyId, firstSeenDate, lastSeenDate, foundedDate, dissolutionDate

Many rows

Names

companyId, globalId, validFrom, name, validTill, isCurrent

Many rows

Objectives

companyId, globalId, validFrom, objective, validTill, isCurrent

Many rows

Positions

companyId, globalId, dateOfPublication, foundPosition, startDate, endDate, firstName, lastName, maidenName, birthDate, city

Many rows

ReferenceNumbers

companyId, stdRefNo, nativeReferenceNumber, courtName, courtCode, referenceNumberFirstSeen, validTill

Many rows

... and 12 hidden tables