names

82 rows where place_id = 647722

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3897826 1989476 1989476 defendant Lynsey Thomas yeoman 647722 647722 Lynsey, Thomas, of Dent, yeoman 0
3911817 1994276 1994276 defendant Smerthwhat Oliver yeoman 647722 647722 Smerthwhat, Oliver, of Dent, yeoman 1
3925465 1998829 1998829 defendant Willen George yeoman 647722 647722 Willen, George, of Dent, yeoman 0
3925466 1998829 1998829 defendant Willen Thomas yeoman 647722 647722 Willen, Thomas, of Dent, yeoman 1
3984672 2019276 2019276 defendant Mayson Roger husbandman 647722 647722 Mayson, Roger, of Dent, husbandman 0
4049798 2042367 2042367 defendant Hodgshon Ralph yeoman 647722 647722 Hodgshon, Ralph, of Dent, yeoman 2
4049799 2042367 2042367 defendant Willian Henry yeoman 647722 647722 Willian, Henry, of Dent, yeoman 3
4049805 2042368 2042368 defendant Hodgshon Ralph yeoman 647722 647722 Hodgshon, Ralph, of Dent, yeoman 2
4049806 2042368 2042368 defendant Willan Henry yeoman 647722 647722 Willan, Henry, of Dent, yeoman 3
4049840 2042377 2042377 defendant Mayson George yeoman 647722 647722 Mayson, George, of Dent, yeoman 0
4049841 2042377 2042377 defendant Mayson Michael yeoman 647722 647722 Mayson, Michael, of Dent, yeoman 1
4049842 2042377 2042377 defendant Mayson Lancelot yeoman 647722 647722 Mayson, Lancelot, of Dent, yeoman 2
4049843 2042377 2042377 defendant Mayson Edward yeoman 647722 647722 Mayson, Edward, of Dent, yeoman 3
4049851 2042379 2042379 defendant Wytton Richard yeoman 647722 647722 Wytton, Richard, of Dent, yeoman 2
4049854 2042380 2042380 defendant Mayson George yeoman 647722 647722 Mayson, George, of Dent, yeoman 0
4049855 2042380 2042380 defendant Mayson Michael yeoman 647722 647722 Mayson, Michael, of Dent, yeoman 1
4049856 2042380 2042380 defendant Mayson Lancelot yeoman 647722 647722 Mayson, Lancelot, of Dent, yeoman 2
4049857 2042380 2042380 defendant Mayson Edward yeoman 647722 647722 Mayson, Edward, of Dent, yeoman 3
4049858 2042380 2042380 defendant Mayson William yeoman 647722 647722 Mayson, William, of Dent, yeoman 4
4103632 2061580 2061580 defendant Mason Richard yeoman 647722 647722 Mason, Richard, of Dent, yeoman 0
4103634 2061581 2061581 defendant Mason Richard yeoman 647722 647722 Mason, Richard, of Dent, yeoman 0
4116283 2066113 2066113 defendant Hodshon or Hogeson Thomas yeoman 647722 647722 Hodshon or Hogeson, Thomas, of Dent, yeoman 0
4116287 2066115 2066115 defendant Mason Richard yeoman 647722 647722 Mason, Richard, of Dent, yeoman 0
4116288 2066115 2066115 defendant Hodson Thomas yeoman 647722 647722 Hodson, Thomas, of Dent, yeoman 1
4116289 2066115 2066115 defendant Cockeson George yeoman 647722 647722 Cockeson, George, of Dent, yeoman 2
4116292 2066116 2066116 defendant Mason Richard yeoman 647722 647722 Mason, Richard, of Dent, yeoman 0
4116293 2066116 2066116 defendant Hodson Thomas yeoman 647722 647722 Hodson, Thomas, of Dent, yeoman 1
4116294 2066116 2066116 defendant Cockeson George yeoman 647722 647722 Cockeson, George, of Dent, yeoman 2
4138918 2074291 2074291 defendant Sygeswicke Geoffrey husbandman 647722 647722 Sygeswicke, Geoffrey, of Dent, husbandman 0
4138919 2074291 2074291 defendant Burton George husbandman 647722 647722 Burton, George, of Dent, husbandman 1
4163603 2082791 2082791 defendant Sygeswicke Geoffrey husbandman 647722 647722 Sygeswicke, Geoffrey, of Dent, husbandman 0
4163604 2082791 2082791 defendant Burton George husbandman 647722 647722 Burton, George, of Dent, husbandman 1
4169918 2084975 2084975 defendant Hodgson John chapman 647722 647722 Hodgson, John, of Dent, chapman 0
4174668 2086609 2086609 defendant Lime or Lune John yeoman 647722 647722 Lime or Lune, John, of Dent, chapman, executors of (Pettye, John, of Dent, Yorks, yeoman 0
4183800 2089825 2089825 defendant Smorthowith George yeoman 647722 647722 Smorthowith, George, of Dent, yeoman 2
4190162 2092066 2092066 defendant Trotter Christopher yeoman 647722 647722 Trotter, Christopher, of Dent, yeoman 0
4190163 2092066 2092066 defendant Trotter Oliver yeoman 647722 647722 Trotter, Oliver, of Dent, yeoman 1
4190164 2092066 2092066 defendant Trotter Richard yeoman 647722 647722 Trotter, Richard, of Dent, yeoman 2
4231450 2106499 2106499 defendant Witton George (legal representative) 647722 647722 Witton, George, of Dent, yeoman, executors of 0
4231451 2106499 2106499 defendant Cookeson Anne widow 647722 647722 (Cookeson, Anne, of Dent, widow 1
4231452 2106499 2106499 defendant Witton Emma spinster 647722 647722 Witton, Emma, of Dent, spinster 2
4263253 2117376 2117376 defendant Lound George   647722 647722 Lound, George, of Dent, yeoman, his son 1
4264385 2117730 2117730 defendant Lund George yeoman 647722 647722 Lund, George, of Dent, yeoman 1
4273541 2120705 2120705 defendant Lpund george   647722 647722 Lpund, george, of Dent, yeoman, his son 1
4292255 2127296 2127296 defendant Baynes Thomas yeoman 647722 647722 Baynes, Thomas, of Dent, yeoman 1
4292256 2127296 2127296 defendant Cragge William yeoman 647722 647722 Cragge, William, of Dent, yeoman 2
4316186 2135773 2135773 defendant Cockston Agnes widow 647722 647722 Cockston, Agnes, of Dent, widow 3
4317944 2136387 2136387 defendant Baynes Thomas yeoman 647722 647722 Baynes, Thomas, of Dent, yeoman 0
4317962 2136394 2136394 defendant Burton Miles chapman 647722 647722 Burton, Miles, of Dent, husbandman, chapman 0
4322182 2137833 2137833 defendant Trotter John yeoman 647722 647722 Trotter, John, of Dent, yeoman 0
4322183 2137833 2137833 defendant Trotter Thomas yeoman 647722 647722 Trotter, Thomas, of Dent, yeoman 1
4345043 2145541 2145541 defendant Burton Wilfred chapman 647722 647722 Burton, Wilfred, of Dent, chapman 1
4355547 2149163 2149163 defendant Wotton James husbandman 647722 647722 Wotton, James, of Dent, husbandman 0
4384887 2159634 2159634 defendant Lancaster William butcher 647722 647722 Lancaster, William, of Dent, butcher 0
4405116 2166287 2166287 defendant Lound or Lunne George yeoman 647722 647722 Lound or Lunne, George, of Dent, yeoman 0
4405117 2166287 2166287 defendant Witton John yeoman 647722 647722 Witton, John, of Dent, yeoman 1
4405659 2166461 2166461 defendant Lancaster William husbandman 647722 647722 Lancaster, William, of Dent, husbandman 3
4406982 2166895 2166895 defendant Lounde or Lunde Richard yeoman 647722 647722 Lounde or Lunde, Richard, of Dent, yeoman 0
4406983 2166895 2166895 defendant Lounde or Lunde Miles   647722 647722 Lounde or Lunde, Miles, of Dent, yeoman, his son 1
4409665 2167833 2167833 defendant Wytton James husbandman 647722 647722 Wytton, James, of Dent, husbandman 0
4700717 2265625 2265625 defendant Dunton Robert, sen yeoman 647722 647722 Dunton, Robert, sen, of Dent, yeoman 1
4700718 2265625 2265625 defendant Leek John yeoman 647722 647722 Leek, John, of Dent, yeoman 2
4700719 2265625 2265625 defendant Smarthwayte William yeoman 647722 647722 Smarthwayte, William, of Dent, yeoman 3
4763051 2284427 2284427 defendant Holm Robert chaplain 647722 647722 Holm, Robert, of Dent, chaplain 3
4843551 2309505 2309505 defendant Syggeswyk John (legal representative) 647722 647722 Syggeswyk, John, of Dent, executors of 0
4843552 2309505 2309505 defendant Syggeswyk George yeoman 647722 647722 (Syggeswyk, George, of Dent, yeoman 1
4874627 2319008 2319008 defendant Smerthwayt Richard yeoman 647722 647722 Smerthwayt, Richard, of Dent, yeoman 1
4926687 2334764 2334764 defendant Hoggeson Jonson Robert yeoman 647722 647722 Hoggeson Jonson, Robert, of Dent, yeoman 7
4967762 2347302 2347302 defendant Grenehode Ralph yeoman 647722 647722 Grenehode, Ralph, of Dent, yeoman 0
4967763 2347302 2347302 defendant Grenehode Robert yeoman 647722 647722 Grenehode, Robert, of Dent, yeoman 1
4967764 2347302 2347302 defendant Copestak James yeoman 647722 647722 Copestak, James, of Dent, yeoman 2
4967765 2347302 2347302 defendant Trotter Robert yeoman 647722 647722 Trotter, Robert, of Dent, yeoman 3
4967769 2347304 2347304 defendant Hoggeson Roger Wilson yeoman 647722 647722 Hoggeson, Roger Wilson, of Dent, yeoman 0
4979102 2350707 2350707 defendant Willayn John yeoman 647722 647722 Willayn, John, of Dent, yeoman 0
4979103 2350707 2350707 defendant Smerthwayt John yeoman 647722 647722 Smerthwayt, John, of Dent, yeoman 1
5016174 2361616 2361616 defendant Fauxheved John yeoman 647722 647722 Fauxheved, John, of Dent, yeoman 0
5016175 2361616 2361616 defendant Pykeryng William yeoman 647722 647722 Pykeryng, William, of Dent, yeoman 1
5016176 2361616 2361616 defendant Fauxheved Geoffrey yeoman 647722 647722 Fauxheved, Geoffrey, of Dent, yeoman 2
5029862 2365606 2365606 defendant Grenhode Roand yeoman 647722 647722 Grenhode, Roand, of Dent, yeoman 10
5043266 2369608 2369608 defendant Lyndesay John, junior yeoman 647722 647722 Lyndesay, John, junior, of Dent, yeoman 0
5046851 2370678 2370678 defendant Smerthwayt George yeoman & son of Richard Smerthwayt 647722 647722 Smerthwayt, George, of Dent, yeoman & son of Richard Smerthwayt 1
5046852 2370678 2370678 defendant Smerthwayt Richard yeoman 647722 647722 Smerthwayt, Richard, of Dent, yeoman 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);