between ... and ...

between ... and ...

Returns TRUE for values in a given range

Works with the following datatypes:

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

between is used with the $where parameter to return numeric or time stamp values between two input values. For example, to get all of the individuals who make between $40,000 and $60,000 at the City of Chicago:

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$where=annual_salary between '40000' and '60000'

It can also be used on Floating Timestamps. For example, to get all of the crimes that occurred between noon and 2PM on January 10th, 2015 in Chicago:

https://data.cityofchicago.org/resource/6zsd-86xi.json?$where=date between '2015-01-10T12:00:00' and '2015-01-10T14:00:00'