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.

like '...'

like '...'

Allows for substring searches in text strings

Works with the following datatypes:

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

The like '...' function allows you to filter for Text values that match a given pattern. Patterns can include placeholders to make fuzzy matches:

  • An underscore (_) matches a single character
  • A percent symbol (%) matches any string of zero or more characters

For example, to query the City of Chicago Salaries for “chiefs” (be careful to URL encode your % characters as %25, something most HTTP clients will help you to do):

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$where=job_titles like '%25CHIEF%25'