| text | contains | {"kind":"text","col":"name","mode":"contains","value":"coffee"} | 18,766 |
| text | starts | {"kind":"text","col":"domain","mode":"starts","value":"shop"} | 140,335 |
| text | ends | {"kind":"text","col":"domain","mode":"ends","value":".shop"} | 83,831 |
| text | exact | {"kind":"text","col":"domain","mode":"exact","value":"gymshark.com"} | 1 |
| text | empty | {"kind":"text","col":"tagline","mode":"empty"} | 4,087,868 |
| text | not_empty | {"kind":"text","col":"tagline","mode":"not_empty"} | 4,832,067 |
| text | regex | {"kind":"text","col":"domain","mode":"regex","parts":[{"term":"coffee","conn":"not"},{"term":"shop"}]} | 24,284 |
| numeric | between | {"kind":"numeric","col":"products","min":10,"max":100,"op":"between"} | 1,539,598 |
| numeric | gte | {"kind":"numeric","col":"products","op":"gte","min":500} | 504,984 |
| numeric | lte | {"kind":"numeric","col":"products","op":"lte","max":5} | 816,032 |
| numeric | eq | {"kind":"numeric","col":"products","op":"eq","min":1} | 223,909 |
| numeric | neq | {"kind":"numeric","col":"products","op":"neq","min":0} | 3,696,424 |
| numeric | empty | {"kind":"numeric","col":"products","op":"empty"} | 5,030,260 |
| numeric | not_empty | {"kind":"numeric","col":"products","op":"not_empty"} | 3,889,675 |
| dropdown | values | {"kind":"dropdown","col":"country","values":["US","GB"]} | 1,645,791 |
| tags | any | {"kind":"tags","col":"categories","mode":"any","values":["Shopping"]} | 136,474 |
| tags | all | {"kind":"tags","col":"categories","mode":"all","values":["Apparel & Accessories > Clothing"]} | 273 |
| tags | none | {"kind":"tags","col":"categories","mode":"none","values":["Apparel & Accessories > Clothing > T-Shirts"]} | 8,754,419 |
| date | from | {"kind":"date","col":"registered","from":"2024-01-01"} | open-ended |
| date | to | {"kind":"date","col":"registered","to":"2024-12-31"} | inclusive |
| date | from + to | {"kind":"date","col":"registered","from":"2024-01-01","to":"2024-12-31"} | the whole year |
| numeric | includeNull | {"kind":"numeric","col":"products","op":"gte","min":50,"includeNull":true} | adds never-measured rows |
| date | from/to | {"kind":"date","col":"registered","from":"2020-01-01","to":"2024-12-31"} | 2,427,890 |