Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

OpenSpending Data Model

Navigation: Schema: OpenSpendingNl > Tables

governments: openspending.nl Governments

Contents Previous Home Next More

Catalog: OpenSpendingNl

Schema: OpenSpendingNl

Primary Keys: id

Label: Governments

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: /governments/?limit=1000

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

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

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

Field Selection Method: NotRequired

Table Columns

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

Name

Data Type

Label

Required

Documentation

aggregation

string

 

 

code

string

 

 

country

string

 

 

created_at

datetime

 

 

display_kind

string

 

 

id

int32

 

 

intro

string

 

 

kind

string

 

 

latitude

double

 

 

location

string

 

 

longitude

double

 

 

metrics

string

 

 

name

string

 

 

resource_uri

string

 

 

slug

string

 

 

state

string

 

 

updated_at

string

 

 

website

string

 

 

 

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