data.world - query

Execute a query on data.world

(no tags)

    Algorithmia Platform License · Internet Access

    This algorithm has Internet access.

    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

    {
      "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 & Use

    Use
    
    curl -X POST -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"]   
    }' -H 'Content-Type: application/json' -H 'Authorization: Simple YOUR_API_KEY' https://api.algorithmia.com/v1/algo/datadotworld/query/0.2.0