datadotworld

datadotworld / query / 0.2.0

data.world - query

Royalty Free
Execute a query on data.world
No Tags
Language
Python 3.x
Metrics
API Calls - 182 Avg call duration - N/A
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
# When prompted for api endpoint, hit enter
# When prompted for API key, enter your 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"]   
}' --timeout 300
CLI Docs