Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

OpenSpending Data Model

Navigation: Schema: OpenSpendingNl > Tables

entries: openspending.nl Entries

Contents Previous Home Next More

Catalog: OpenSpendingNl

Schema: OpenSpendingNl

Primary Keys: document_id

Label: Entries

This is a read-only table. The openspending.nl API may not support changing the data or the Invantive SQL driver for openspending.nl does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the openspending.nl API.

Select openspending.nl API URL: /entries/?limit=1000

Insert openspending.nl API URL: /entries/?limit=1000

Update openspending.nl API URL: /entries/?limit=1000

Delete openspending.nl API URL: /entries/?limit=1000

Field Selection Method: NotRequired

Table Columns

The columns of the table entries are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

calendar_year

int32

 

 

code_cat

string

 

 

code_main

string

 

 

code_sub

string

 

 

direction

string

 

 

document_id

int32

 

 

gov_code

string

 

 

gov_type

string

 

 

labels

string

 

 

period

int32

 

 

plaatsing

string

 

 

resource_uri

string

 

 

type

string

 

 

value

string

 

 

 

12-12-2020 19:01 Version 20.1.301-BETA+3023