Checkbox Datatype

Checkbox fields are boolean values that represent either true or false. If a value was not provided for the field, they can also be null. Example, in JSON:

[ {
  "checkbox_column": true
} ]

The following operators can be used to compare and manipulate floating_timestamp fields:

Operation Description
!= TRUE when two checkbox booleans have the same value
= TRUE when two checkbox booleans do not have the same value

For example, in combination with an aggregation, to get the count of all of the crimes in Chicago that resulted in arrest:

https://data.cityofchicago.org/resource/6zsd-86xi.json?$select=count(*)&$where=arrest=true

Since checkbox values are already booleans, you can actually leave off the =true in that expression:

https://data.cityofchicago.org/resource/6zsd-86xi.json?$select=count(*)&$where=arrest