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

NamesFts (hidden)

companyId, name, NamesFts, rank

Many rows

NamesFts_config (hidden)

k, v

Many rows

NamesFts_content (hidden)

id, c0, c1

Many rows

NamesFts_data (hidden)

id, block

Many rows

NamesFts_docsize (hidden)

id, sz

Many rows

NamesFts_idx (hidden)

segid, term, pgno

15,286 rows

ObjectivesFts (hidden)

companyId, name, ObjectivesFts, rank

Many rows

ObjectivesFts_config (hidden)

k, v

1 row

ObjectivesFts_content (hidden)

id, c0, c1

Many rows

ObjectivesFts_data (hidden)

id, block

Many rows

ObjectivesFts_docsize (hidden)

id, sz

Many rows

ObjectivesFts_idx (hidden)

segid, term, pgno

Many rows