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.

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'