Filtering

Operators

The eq operator is the default when no operator is specified.

Examples

Simple equality:

Numeric range:

Multiple values (IN):

Pattern matching (LIKE):

Combining multiple filters (AND logic):

Type Coercion

Filter values are automatically coerced based on column type:

• Integer columns: "2024" becomes 2024
• Float columns: "3.14" becomes 3.14
• Boolean columns: "true", "1", "yes" become True
• String columns: no coercion

Column Validation

Filter column names are validated against the dataset schema. If you reference a column that doesn’t exist, you get a FilterError with the list of valid columns.

Gotchas

URL-encode brackets. [ is %5B, ] is %5D. Most HTTP clients and libraries handle this automatically, but raw curl needs encoding or quoting.

Case-sensitive column names. Column names are lowercase with underscores (e.g., jurisdiction_name, not Jurisdiction Name). Use the /columns endpoint to check exact names.

Bare params are not filters. ?year=2024 does nothing. You need ?filter[year]=2024. The API returns an unknown_param warning if you make this mistake.

LIKE wildcard is *, not %. The API converts * to SQL % internally. Use * in filter values.