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