Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

OpenSpending Data Model

Navigation: Schema: OpenSpendingNl > Tables

transaction_views: openspending.nl Transaction Columns

Contents Previous Home Next More

Catalog: OpenSpendingNl

Schema: OpenSpendingNl

Primary Keys: id

Label: Transaction Columns

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

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

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

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

Field Selection Method: NotRequired

Table Columns

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

Name

Data Type

Label

Required

Documentation

created_at

datetime

 

 

document_byline

string

 

 

document_created_at

datetime

 

 

document_doc_type

string

 

 

document_document

string

 

 

document_government_aggregation

string

 

 

document_government_code

string

 

 

document_government_country

string

 

 

document_government_created_at

datetime

 

 

document_government_display_kind

string

 

 

document_government_id

int32

 

 

document_government_intro

string

 

 

document_government_kind

string

 

 

document_government_latitude

double

 

 

document_government_location

string

 

 

document_government_longitude

double

 

 

document_government_metrics

string

 

 

document_government_name

string

 

 

document_government_resource_uri

string

 

 

document_government_slug

string

 

 

document_government_state

string

 

 

document_government_updated_at

string

 

 

document_government_website

string

 

 

document_id

int32

 

 

document_index_name

string

 

 

document_kind

string

 

 

document_parsed_at

datetime

 

 

document_resource_uri

string

 

 

document_title

string

 

 

document_updated_at

datetime

 

 

document_year

string

 

 

id

int32

 

 

name

string

 

 

page_size

int32

 

 

paging

boolean

 

 

resource_uri

string

 

 

slug

string

 

 

updated_at

datetime

 

 

 

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