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