Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

not between ... and ...

not between ... and ...

Returns TRUE for values not in a given range

Works with the following datatypes:

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

not between is used with the $where parameter to return numeric or time stamp values excluding those between two input values. For example, to get all of the individuals who make less than $40,000 or more than $150,000 at the City of Chicago:$where=annual_salary not between '40000' and '150000'

It can also be used on Floating Timestamps. For example, to get all of the crimes that occurred outside noon and 2PM on January 10th, 2015 in Chicago:$where=date not between '2015-01-10T12:00:00' and '2015-01-10T14:00:00'