Sample relationship glosses in occupation

Custom SQL query returning 50 rows (hide)

SELECT n.surname, n.forename, n.occupation, n.raw_segment, c.year
FROM names n
JOIN cases c ON c.id = n.case_id
WHERE (n.occupation LIKE '%his wife%'
   OR n.occupation LIKE '%his son%'
   OR n.occupation LIKE '%widow%')
  AND c.year IS NOT NULL
  AND c.year >= CAST(COALESCE(NULLIF(:start_year, ''), '1349') AS INTEGER)
  AND c.year <= CAST(COALESCE(NULLIF(:end_year, ''), '1596') AS INTEGER)
LIMIT 50

Query parameters

start_year

end_year

Edit SQL