not in(...)

not in(...)

Matches values not in a given set of options

Works with the following datatypes:

This function works with 2.1 endpoint(s). What does this mean? »

The not in(...) function is used within the $where parameter exclude a set of possible values. For example, to exclude the ARSON, NARCOTICS, and RITUALISM values in the Chicago Crimes:

https://data.cityofchicago.org/resource/6zsd-86xi.json?$where=primary_type not in('ARSON', 'NARCOTICS', 'RITUALISM')