Mr VELLA

Names and terms in the same records

Rule: vocabulary term (aliases OR-folded) x person printed forms (OR-folded), whole-word FTS record co-occurrence

Order: distinctive first (lift) — records * N / (deg_term * deg_person); N = total fts records; degrees = graph_term_records / graph_person_records counts; support floor 5.

On this page: Order is “distinctive first” above the reviewed floor of 5 records, then by count.

SELECT t.slug FROM graph_term_records t JOIN graph_person_records p ON p.slug = t.slug WHERE t.term = :term AND p.person = :person ORDER BY t.slug

People present at the same meetings

Rule: distinct (meeting, group_display) present pairs, grouped; see the builder Attendance is the index's capture: the College complete, staff rows sporadic — a person absent from a sitting's list may simply be unrecorded.

Stored weighting note (verbatim): tenure — served alongside, over which span; must not imply affinity discrimination. overlap coefficient: meetings / min(deg_a, deg_b); degrees = distinct meetings present.

SELECT DISTINCT a.meeting FROM attendance a JOIN attendance b ON b.meeting = a.meeting WHERE a.group_display = :person_a AND b.group_display = :person_b AND a.status = 'present' AND b.status = 'present' ORDER BY a.meeting