invantive documentation
Invantive Support ForumsLog In / Sign Up

KOOP Staatsalmanak (NL) Data Model

Staatsalmanak is a public data collection with Dutch governmental data.

Set up this platform in Invantive Cloud: https://documentation.invantive.com/2017R2/koop-staatsalmanak-data-model/webhelp/index.html

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • Invantive Cloud plans: Free for public data, Free, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Language of its user community: Dutch.

Figures

Figure Count
Tables 14
Columns 118
Tables with insert 1
Tables with update 0
Tables with delete 0
Tables documented 1

Data Model Poster

This data model declares no keys yet; the dotted relations are derived from column names.

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

KOOP Staatsalmanak (NL) data model, Sheet 1 of 1KOOP Staatsalmanak (NL) data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026Tables without relationsSheet 1 of 1 · documentation.invantive.euAreaMetadata.CodeValues.AreaMarkingLocatedInMunicipality: Domain AreaMarkingLocatedInMunicipalityAreaMarkingLocatedInMunicipalityMetadata.CodeValues.AreaMarkingLocatedInProvince: Domain AreaMarkingLocatedInProvinceAreaMarkingLocatedInProvinceAuthorityMetadata.CodeValues.Authority: Domain AuthorityAuthorityMetadata.CodeValues.AuthorityScheme: Domain AuthoritySchemeAuthoritySchemeCreatorMetadata.CodeValues.Creator: Domain CreatorCreatorMetadata.CodeValues.CreatorScheme: Domain CreatorSchemeCreatorSchemeIndexMetadata.CodeValues.Indexes: Domain IndexesIndexesOrganisationMetadata.CodeValues.OrganisationType: Domain OrganisationTypeOrganisationTypePublicationMetadata.CodeValues.PublicationName: Domain PublicationNamePublicationNamePublisherMetadata.CodeValues.Publisher: Domain PublisherPublisherSpatialMetadata.CodeValues.SpatialScheme: Domain SpatialSchemeSpatialSchemeTypeMetadata.CodeValues.TypeScheme: Domain TypeSchemeTypeSchemeNATIVEPLATFORMSCALARREQUESTSSA.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSKOOP Staatsalmanak(NL)NotesThis data model declares no keys yet; the dotted relations are derived from column names.Data dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsTables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n relations between the same tablesGenerated from the metadata of Invantive UniversalSQL 27.1.3-BETA+6294 on 01-11-2026. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/koopstaatsalmanak
The poster as text: tables per topic and their relations

Area (without relations)

AreaMarkingLocatedInMunicipality, AreaMarkingLocatedInProvince

Authority (without relations)

Authority, AuthorityScheme

Creator (without relations)

Creator, CreatorScheme

Index (without relations)

Indexes

Organisation (without relations)

OrganisationType

Publication (without relations)

PublicationName

Publisher (without relations)

Publisher

Spatial (without relations)

SpatialScheme

Type (without relations)

TypeScheme

NATIVEPLATFORMSCALARREQUESTS (without relations)

NATIVEPLATFORMSCALARREQUESTS

Tables

Metadata.CodeValues

SA.KOOP

SA.Native

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: