Universal API for Tallinn city open data

Datasets are documented and published at Estonian Open Data Portal with reference to the current URL.

Instructions

Use this API to make GET requests to /data/ endpoint with following parameters:

• table: Name of the dataset
• columns: Columns to select (use '*' for all columns)
• filters: Optional filters in SQL WHERE clause format
• order_by: Optional column(s) to order by
• page: Page number of results
• per_page: Results per page

NB! Restrictions

• when parameters are omitted, then default parameters are used: columns=*&page=1&per_page=100
• 5 concurrent reqests allowed
• Max query timeout 20s

Example Query

Current URL ../data/?table=sometable&columns=age,name&filters=age>30&order_by=name&limit=10

OpenAPI (Swagger) interface

For testing in browser use current URL with ../docs