24ways-fts4
Data source: https://github.com/simonw/sqlite-fts4
| title | author | score | bm25 | json_object("pre", annotate_matchinfo(matchinfo(articles_fts, "pcxnalyb"), "pcxnalyb")) |
|---|---|---|---|---|
| Unobtrusively Mapping Microformats with jQuery | Simon Willison | -0.8044811949853293 | -14.359308379741142 | {
"p": {
"value": 2,
"title": "Number of matchable phrases in the query",
"idx": 0
},
"c": {
"value": 3,
"title": "Number of user defined columns in the FTS table",
"idx": 1
},
"x": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_this_column_this_row": 1,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
2,
3,
4
]
},
{
"phrase_index": 0,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
5,
6,
7
]
},
{
"phrase_index": 0,
"column_index": 2,
"hits_this_column_this_row": 39,
"hits_this_column_all_rows": 163,
"docs_with_hits": 31,
"idxs": [
8,
9,
10
]
},
{
"phrase_index": 1,
"column_index": 0,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
11,
12,
13
]
},
{
"phrase_index": 1,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
14,
15,
16
]
},
{
"phrase_index": 1,
"column_index": 2,
"hits_this_column_this_row": 6,
"hits_this_column_all_rows": 92,
"docs_with_hits": 21,
"idxs": [
17,
18,
19
]
}
],
"title": "Details for each phrase/column combination"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 5,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 2397,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 1,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 39,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 6,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
5,
4
],
"decoded": {
"phrase_0": "10100000000000000000000000000000",
"phrase_1": "00100000000000000000000000000000"
}
}
} |
| Finding Your Way with Static Maps | Drew McLellan | -0.6257001867164577 | -12.47827960073553 | {
"p": {
"value": 2,
"title": "Number of matchable phrases in the query",
"idx": 0
},
"c": {
"value": 3,
"title": "Number of user defined columns in the FTS table",
"idx": 1
},
"x": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
2,
3,
4
]
},
{
"phrase_index": 0,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
5,
6,
7
]
},
{
"phrase_index": 0,
"column_index": 2,
"hits_this_column_this_row": 1,
"hits_this_column_all_rows": 163,
"docs_with_hits": 31,
"idxs": [
8,
9,
10
]
},
{
"phrase_index": 1,
"column_index": 0,
"hits_this_column_this_row": 1,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
11,
12,
13
]
},
{
"phrase_index": 1,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
14,
15,
16
]
},
{
"phrase_index": 1,
"column_index": 2,
"hits_this_column_this_row": 11,
"hits_this_column_all_rows": 92,
"docs_with_hits": 21,
"idxs": [
17,
18,
19
]
}
],
"title": "Details for each phrase/column combination"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 6,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 1247,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 1,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 1,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 11,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
4,
5
],
"decoded": {
"phrase_0": "00100000000000000000000000000000",
"phrase_1": "10100000000000000000000000000000"
}
}
} |
| Your jQuery: Now With 67% Less Suck | Scott Kosman | -0.6383035476126967 | -12.362029552498246 | {
"p": {
"value": 2,
"title": "Number of matchable phrases in the query",
"idx": 0
},
"c": {
"value": 3,
"title": "Number of user defined columns in the FTS table",
"idx": 1
},
"x": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_this_column_this_row": 1,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
2,
3,
4
]
},
{
"phrase_index": 0,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
5,
6,
7
]
},
{
"phrase_index": 0,
"column_index": 2,
"hits_this_column_this_row": 19,
"hits_this_column_all_rows": 163,
"docs_with_hits": 31,
"idxs": [
8,
9,
10
]
},
{
"phrase_index": 1,
"column_index": 0,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
11,
12,
13
]
},
{
"phrase_index": 1,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
14,
15,
16
]
},
{
"phrase_index": 1,
"column_index": 2,
"hits_this_column_this_row": 2,
"hits_this_column_all_rows": 92,
"docs_with_hits": 21,
"idxs": [
17,
18,
19
]
}
],
"title": "Details for each phrase/column combination"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 7,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 1987,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 1,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 19,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 2,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
5,
4
],
"decoded": {
"phrase_0": "10100000000000000000000000000000",
"phrase_1": "00100000000000000000000000000000"
}
}
} |
| Front-End Code Reusability with CSS and JavaScript | Trevor Morris | -0.09675913576953854 | -7.053014942828428 | {
"p": {
"value": 2,
"title": "Number of matchable phrases in the query",
"idx": 0
},
"c": {
"value": 3,
"title": "Number of user defined columns in the FTS table",
"idx": 1
},
"x": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
2,
3,
4
]
},
{
"phrase_index": 0,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
5,
6,
7
]
},
{
"phrase_index": 0,
"column_index": 2,
"hits_this_column_this_row": 14,
"hits_this_column_all_rows": 163,
"docs_with_hits": 31,
"idxs": [
8,
9,
10
]
},
{
"phrase_index": 1,
"column_index": 0,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
11,
12,
13
]
},
{
"phrase_index": 1,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
14,
15,
16
]
},
{
"phrase_index": 1,
"column_index": 2,
"hits_this_column_this_row": 1,
"hits_this_column_all_rows": 92,
"docs_with_hits": 21,
"idxs": [
17,
18,
19
]
}
],
"title": "Details for each phrase/column combination"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 8,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 1956,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 14,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 1,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
4,
4
],
"decoded": {
"phrase_0": "00100000000000000000000000000000",
"phrase_1": "00100000000000000000000000000000"
}
}
} |
| Geotag Everywhere with Fire Eagle | Ben Ward | -0.02787409975993598 | -4.943383732340504 | {
"p": {
"value": 2,
"title": "Number of matchable phrases in the query",
"idx": 0
},
"c": {
"value": 3,
"title": "Number of user defined columns in the FTS table",
"idx": 1
},
"x": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
2,
3,
4
]
},
{
"phrase_index": 0,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
5,
6,
7
]
},
{
"phrase_index": 0,
"column_index": 2,
"hits_this_column_this_row": 1,
"hits_this_column_all_rows": 163,
"docs_with_hits": 31,
"idxs": [
8,
9,
10
]
},
{
"phrase_index": 1,
"column_index": 0,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 2,
"docs_with_hits": 2,
"idxs": [
11,
12,
13
]
},
{
"phrase_index": 1,
"column_index": 1,
"hits_this_column_this_row": 0,
"hits_this_column_all_rows": 0,
"docs_with_hits": 0,
"idxs": [
14,
15,
16
]
},
{
"phrase_index": 1,
"column_index": 2,
"hits_this_column_this_row": 2,
"hits_this_column_all_rows": 92,
"docs_with_hits": 21,
"idxs": [
17,
18,
19
]
}
],
"title": "Details for each phrase/column combination"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 5,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 2695,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 1,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 2,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
4,
4
],
"decoded": {
"phrase_0": "00100000000000000000000000000000",
"phrase_1": "00100000000000000000000000000000"
}
}
} |