datadotworld

datadotworld / query / 0.2.0

data.world - query

Royalty Free API Calls - 146
Execute a query on data.world
No Tags
Permissions
The Algorithm Platform License is the set of terms that are stated in the Software License section of the Algorithmia Application Developer and API License Agreement. It is intended to allow users to reserve as many rights as possible without limiting Algorithmia's ability to run it as a service. Learn More
This is necessary for algorithms that rely on external services, however it also implies that this algorithm is able to send your input data outside of the Algorithmia platform.

Run an Example

Input
Output
{
  "data": [
    {
      "Country": "Finland",
      "Overall subscore": 100
    },
    {
      "Country": "Netherlands",
      "Overall subscore": 100
    },
    {
      "Country": "Sweden",
      "Overall subscore": 100
    },
    {
      "Country": "Czech Republic",
      "Overall subscore": 95
    },
    {
      "Country": "Denmark",
      "Overall subscore": 95
    }
  ],
  "header": [
    "Country",
    "Overall subscore"
  ]
}

Install and Use

Install

Install the Algorithmia CLI client by running:

curl -sSLf https://algorithmia.com/install.sh | sh

Then authenticate by running:

algo auth
# Enter API Key: YOUR_API_KEY
CLI Install Docs

Use



algo run datadotworld/query/0.2.0 -d '{
  "dataset_key":"bryon/odin-2015-2016",
  "query":
     "SELECT Country, `Overall subscore` FROM `ODIN-2015-2016-standardized` WHERE Year=? AND Elements=? ORDER BY `Overall subscore` DESC LIMIT 5",
  "query_type": "sql",
  "parameters": ["2016", "Population & Vital Statistics"]   
}'
CLI Docs