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.

starts_with(...)

starts_with(...)

Matches on text strings that start with a given substring

Works with the following datatypes:

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

starts_with(...) allows you to filter for Text values that start with a given substring. For example, to query the City of Chicago Salaries for for only CHIEFs:

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$where=starts_with(job_titles, 'CHIEF')