Filter query on table kern/ct

Filters: (add or remove filters in the URL)
ct_cit ct_token_freq_abs ct_type_freq_abs
n$$ 23817002 549551
e$$ 16046745 382684
en$ 15778557 433626
r$$ 13564729 177304
$$d 13511971 26106
t$$ 10447580 179843
er$ 9888289 144013
,$$ 8270276 1
$,$ 8270276 1
$$, 8270276 1

Use HTTP_ACCEPT: application/json to get JSON only.

13 columns in table /kern/ct

ColumnDescriptionData typeUser documentation
ct_cit String case-sensitive /doc/ct_cit/
ct_token_freq_abs int /doc/ct_token_freq/
ct_token_freq_nor float /doc/ct_token_freq/
ct_token_freq_abslog float /doc/ct_token_freq/
ct_token_freq_norlog float /doc/ct_token_freq/
ct_token_freq_rank float /doc/ct_token_freq/
ct_token_freq_rank123 int /doc/ct_token_freq/
ct_type_freq_abs int /doc/ct_type_freq/
ct_type_freq_nor float /doc/ct_type_freq/
ct_type_freq_abslog float /doc/ct_type_freq/
ct_type_freq_norlog float /doc/ct_type_freq/
ct_type_freq_rank float /doc/ct_type_freq/
ct_type_freq_rank123 int /doc/ct_type_freq/

Selecting columns

By default, only one or several default columns are displayed (e.g., the type). To select more columns, use the select parameter:


If using select, the default columns are discarded unless you include them manually.

The default column selection is subject to change. Don't rely on it in your application!



The default sort order is subject to change. Don't rely on it in your application!

Limit and offset




All query parameters of the form COL__OP (two underscores), where COL is a column name and OP is an operator, will be interpreted as filter conditions.

Operators are:

eqequals (for numbers or strings, case-sensitive)
eqiequals (for strings, case-insensitive)
reregular expression match (for strings, case-sensitive)
reiregular expression match (for strings, case-insensitive)
gegreater or equal (for numbers)
leless or equal (for numbers)

Multiple filters on the same field using the same operator are not allowed. One of them would be chosen randomly while the others are discarded.

Case-insensitive string fields can be queried with either the eq or the eqi operator without difference.