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