Geovisualization Developer's Guide

$and

When you use this operator in a query, it filters data in the specified column in the specified dataset, returning the rows that match all the specified conditions.

For more information on using query functions and operators in a REST API request, see Queries. For an end-to-end description of how to create a query, see Creating a Query.

The codeblock example below filters the data in the earthquake dataset, whose {DATASET_ID} is 90af668484394fa782cc103409cafe39, for rows where the magnitude is greater than or equal to 3 and the depth is less than or equal to 10.

If you do not specify an $or or $and filter, $and is used.

{
  "version": 0.3,
  "dataset": "90af668484394fa782cc103409cafe39",
  "metrics": ["magnitude","depth"],
  "filters": [{
    "$and": [
      {"magnitude": {"$gte": 3}},
      {"depth": {"$lte": 10}}
    ]
  }]
}

When you submit the above request, the response includes an HTTP status code and a JSON response body.

For more information on the HTTP status codes, see HTTP Status Codes.

For more information on the elements in the JSON structure in the response body, see Query.