documents: openspending.nl Documents
read only REST
- Catalog:
OpenSpendingNl - Schema:
OpenSpendingNl - Primary Keys:
id - Label: Documents
Can only retrieve data.
API Source
- Endpoint:
/documents/?limit=1000
Table Columns
The columns of the table documents are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
calendar_ |
int32 |
itgen_osnl_calendar_year | filters on the platform, writable, year |
||
created_ |
datetime |
itgen_osnl_created_at | filters on the platform, writable | ||
document |
varchar2 |
itgen_osnl_document | filters on the platform, writable | ||
gov_ |
varchar2 |
itgen_osnl_gov_code | filters on the platform, writable | ||
gov_ |
varchar2 |
itgen_osnl_gov_type | filters on the platform, writable | ||
government_ |
varchar2 |
itgen_osnl_government_aggregation | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_code | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_country | filters on the platform, writable, government. |
||
government_ |
datetime |
itgen_osnl_government_created_at | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_display_kind | filters on the platform, writable, government. |
||
government_ |
int32 |
itgen_osnl_government_id | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_intro | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_kind | filters on the platform, writable, government. |
||
government_ |
double |
itgen_osnl_government_latitude | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_location | filters on the platform, writable, government. |
||
government_ |
double |
itgen_osnl_government_longitude | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_metrics | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_name | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_resource_uri | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_slug | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_state | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_updated_at | filters on the platform, writable, government. |
||
government_ |
varchar2 |
itgen_osnl_government_website | filters on the platform, writable, government. |
||
id |
int32 |
itgen_osnl_id | filters on the platform, writable | ||
kind |
varchar2 |
itgen_osnl_kind | filters on the platform, writable | ||
parsed_ |
datetime |
itgen_osnl_parsed_at | filters on the platform, writable | ||
period |
int32 |
itgen_osnl_period | filters on the platform, writable | ||
plan |
varchar2 |
itgen_osnl_plan | filters on the platform, writable | ||
resource_ |
varchar2 |
itgen_osnl_resource_uri | filters on the platform, writable | ||
updated_ |
datetime |
itgen_osnl_updated_at | filters on the platform, writable | ||
url |
varchar2 |
itgen_osnl_url | filters on the platform, writable |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: