names

148 rows where place_id = 597328

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628142 1903658 1903658 plaintiff Busshe Thomas   597328 597328 Busshe, Thomas, of Leke 0
3628144 1903658 1903658 defendant Fyn William fisher 597328 597328 (Fyn, William, of Leke, fisher 1
3628145 1903658 1903658 defendant Hog Richard fisher 597328 597328 Hog, Richard, of Leke, fisher 2
3636519 1906215 1906215 defendant Alynson Thomas, senior fisher 597328 597328 Alynson, Thomas, senior, of Leke, fisher 0
3636523 1906216 1906216 defendant Alynson Thomas, senior fisher 597328 597328 Alynson, Thomas, senior, of Leke, fisher 1
3639652 1907211 1907211 defendant of the House William husbandman 597328 597328 of the House, William, of Leke, husbandman 0
3653088 1911296 1911296 defendant House William yeoman 597328 597328 House, William, of Leke, yeoman 0
3661688 1913932 1913932 defendant Leke Julianne widow 597328 597328 Leke, Julianne, of Leke, widow 0
3661690 1913933 1913933 defendant Leke Julianne widow 597328 597328 Leke, Julianne, of Leke, widow 0
3673081 1917587 1917587 defendant Foster John yeoman 597328 597328 Foster, John, of Leke, yeoman 1
3682134 1920521 1920521 defendant Ball John yeoman 597328 597328 Ball, John, of Leke, yeoman 4
3684755 1921368 1921368 defendant Basford Humphrey gent 597328 597328 Basford, Humphrey, of Leke, gent 3
3699990 1926231 1926231 defendant Brassyngton Richard yeoman 597328 597328 Brassyngton, Richard, of Leke, yeoman 0
3699993 1926231 1926231 defendant Basford Humphrey gent 597328 597328 Basford, Humphrey, of Leke, gent 3
3716154 1931342 1931342 defendant Wodde Edward gent 597328 597328 Wodde, Edward, of Leke, gent 0
3720055 1932547 1932547 defendant Gent Richard clerk 597328 597328 Gent, Richard, of Leke, clerk 0
3724008 1933793 1933793 defendant Emlyn William fisher 597328 597328 Emlyn, William, of Leke, fisher 3
3740802 1938980 1938980 defendant Joderell John gent 597328 597328 Joderell, John, of Leke, gent 3
3741956 1939351 1939351 defendant Feney Hugh husbandman 597328 597328 Feney, Hugh, of Leke, husbandman 0
3747582 1941159 1941159 defendant Danby William gent 597328 597328 Danby, William, of Leke, gent 0
3751736 1942459 1942459 defendant Gregby Joan widow 597328 597328 Gregby, Joan, of Leke, widow 0
3751737 1942459 1942459 defendant Johnson Elizabeth widow 597328 597328 Johnson, Elizabeth, of Leke, widow 1
3751738 1942459 1942459 defendant Howson Thomas husbandman 597328 597328 Howson, Thomas, of Leke, husbandman 2
3751739 1942459 1942459 defendant Smyth Thomas husbandman 597328 597328 Smyth, Thomas, of Leke, husbandman 3
3761809 1945704 1945704 defendant Alynson Thomas fisher 597328 597328 Alynson, Thomas, of Leke, fisher 0
3761810 1945704 1945704 defendant Bawdre Leonard husbandman 597328 597328 Bawdre, Leonard, of Leke, husbandman 1
3769806 1948211 1948211 plaintiff Jodrell or Jorderell John   597328 597328 Jodrell or Jorderell, John, of Leke 3
3769808 1948211 1948211 defendant Robyns John yeoman 597328 597328 Robyns, John, of Leke, yeoman 1
3769809 1948211 1948211 defendant Overton John yeoman 597328 597328 Overton, John, of Leke, yeoman 2
3769813 1948212 1948212 plaintiff Jordsell John   597328 597328 Jordsell, John, of Leke 3
3773121 1949296 1949296 defendant Raddysshe Margaret singlewoman 597328 597328 Raddysshe, Margaret, of Leke, singlewoman 0
3778572 1951011 1951011 plaintiff Danby William   597328 597328 Danby, William, of Leke 0
3778576 1951012 1951012 plaintiff Danby William   597328 597328 Danby, William, of Leke 0
3794879 1956266 1956266 defendant Fynny Hugh drover 597328 597328 Fynny, Hugh, of Leke, drover 1
3795612 1956512 1956512 plaintiff Danby William gent 597328 597328 Danby, William, of Leke, gent 0
3806002 1959809 1959809 defendant Underwode John husbandman 597328 597328 Underwode, John, of Leke, husbandman 2
3806034 1959815 1959815 defendant Slefurthe Hugh   597328 597328 Slefurthe, Hugh, of Leke, freemason 0
3806035 1959815 1959815 defendant Paynson John husbandman 597328 597328 Paynson, John, of Leke, husbandman 1
3816547 1963077 1963077 defendant Lawson Thomas fisher 597328 597328 Lawson, Thomas, of Leke, fisher 0
3819960 1964124 1964124 defendant Fell Thomas fisher 597328 597328 Fell, Thomas, of Leke, fisher 0
3819961 1964124 1964124 defendant Lawson Thomas fisher 597328 597328 Lawson, Thomas, of Leke, fisher 1
3819962 1964124 1964124 defendant Hudson William fisher 597328 597328 Hudson, William, of Leke, fisher 2
3820715 1964368 1964368 defendant Hymlyn Richard fisher 597328 597328 Hymlyn, Richard, of Leke, fisher 0
3820717 1964369 1964369 defendant Hymlyn Richard fisher 597328 597328 Hymlyn, Richard, of Leke, fisher 0
3821714 1964679 1964679 defendant Tofte James yeoman 597328 597328 Tofte, James, of Leke, yeoman 0
3824819 1965639 1965639 defendant Gregby Richard husbandman 597328 597328 Gregby, Richard, of Leke, husbandman 1
3842546 1971197 1971197 defendant Alynson Thomas fisher 597328 597328 Alynson, Thomas, of Leke, fisher 1
3846374 1972419 1972419 defendant Forster John yeoman 597328 597328 Forster, John, of Leke, yeoman 0
3856147 1975545 1975545 defendant Coke Robert husbandman 597328 597328 Coke, Robert, of Leke, husbandman 0
3856148 1975545 1975545 defendant Ball Nicholas husbandman 597328 597328 Ball, Nicholas, of Leke, husbandman 1
3856149 1975545 1975545 defendant Toft or Tofter John husbandman 597328 597328 Toft or Tofter, John, of Leke, husbandman 2
3857058 1975840 1975840 defendant Aleyn William husbandman 597328 597328 Aleyn, William, of Leke, husbandman 1
3868593 1979735 1979735 defendant Bawdry Leonard yeoman 597328 597328 Bawdry, Leonard, of Leke, yeoman 0
3868594 1979735 1979735 defendant Slefford Hugh   597328 597328 Slefford, Hugh, of Leke, mason 1
3868595 1979735 1979735 defendant Smyth Thomas yeoman 597328 597328 Smyth, Thomas, of Leke, yeoman 2
3868596 1979735 1979735 defendant Mason William laborer 597328 597328 Mason, William, of Leke, laborer 3
3868597 1979735 1979735 defendant Cateson Thomas husbandman 597328 597328 Cateson, Thomas, of Leke, husbandman 4
3868815 1979810 1979810 defendant Howme John laborer 597328 597328 Howme, John, of Leke, laborer 2
3869621 1980079 1980079 defendant Feyrefeld Roger miller 597328 597328 Feyrefeld, Roger, of Leke, miller 0
3869623 1980080 1980080 defendant Joderell John gent 597328 597328 Joderell, John, of Leke, gent 0
3876833 1982492 1982492 defendant Randall Alice widow 597328 597328 Randall, Alice, of Leke, widow 0
3876834 1982492 1982492 defendant Cateson Thomas husbandman 597328 597328 Cateson, Thomas, of Leke, husbandman 1
3904837 1991882 1991882 defendant Sleffurth Hugh gent 597328 597328 Sleffurth, Hugh, of Leke, gent 0
3904838 1991882 1991882 defendant Sylam John husbandman 597328 597328 Sylam, John, of Leke, husbandman 1
3933324 2001442 2001442 defendant Mawuns Simon husbandman 597328 597328 Mawuns, Simon, of Leke, husbandman 0
3946270 2005773 2005773 plaintiff Busshe Richard yeoman 597328 597328 Busshe, Richard, of Leke, yeoman 0
3948613 2006575 2006575 defendant Burgh Richard husbandman 597328 597328 Burgh, Richard, of Leke, husbandman 0
3948614 2006575 2006575 defendant Clulo Ralph carpenter 597328 597328 Clulo, Ralph, of Leke, carpenter 1
3948615 2006575 2006575 defendant Hulley James husbandman 597328 597328 Hulley, James, of Leke, husbandman 2
3948616 2006575 2006575 defendant Watson Lawrence husbandman 597328 597328 Watson, Lawrence, of Leke, husbandman 3
3968909 2013752 2013752 defendant Patricke William butcher 597328 597328 Patricke, William, of Leke, butcher 2
4037796 2038171 2038171 plaintiff Knyght Thomas yeoman 597328 597328 Knyght, Thomas, of Leke, yeoman 0
4187494 2091124 2091124 defendant Bucknall Christopher husbandman 597328 597328 Bucknall, Christopher, of Leke, or of Butterwicke, husbandman 0
4232129 2106740 2106740 defendant Boothe John gent 597328 597328 Boothe, John, of Leke, or of Aston Underlyne, Lancs, gent 0
4427059 2173284 2173284 plaintiff Pynder Henry   597328 597328 Pynder, Henry, of Leke 0
4489846 2197531 2197531 defendant Thwayte Henry de   597328 597328 Thwayte, Henry de, of Leke 0
4503253 2201583 2201583 defendant Aleyn John   597328 597328 Aleyn, John, of Leke 0
4503256 2201583 2201583 defendant Thrumpton William   597328 597328 Thrumpton, William, of Leke 3
4503259 2201584 2201584 defendant Fleccher John   597328 597328 Fleccher, John, of Leke 1
4544896 2214322 2214322 plaintiff Belle (illegible)   597328 597328 Belle, _, of Leke 0
4569311 2221989 2221989 defendant Pykeryng William   597328 597328 Pykeryng, William, of Leke 11
4637491 2242516 2242516 defendant Beke Richard   597328 597328 Beke, Richard, of Leke, vicar 0
4698580 2265029 2265029 defendant Alynson William fishmonger 597328 597328 Alynson, William, of Leke, fishmonger 0
4731544 2275062 2275062 defendant Fote John thatcher 597328 597328 Fote, John, of Leke, thatcher 1
4755517 2282105 2282105 defendant Aynesworth Adam de gent 597328 597328 Aynesworth, Adam de, of Leke, gent 0
4774479 2288002 2288002 defendant Bykyr John husbandman 597328 597328 Bykyr, John, of Leke, husbandman 0
4783174 2290754 2290754 defendant House John husbandman 597328 597328 House, John, of Leke, husbandman 0
4787597 2292193 2292193 defendant Sakirley John husbandman 597328 597328 Sakirley, John, of Leke, husbandman 3
4805018 2297776 2297776 defendant Geppeson Randolf husbandman 597328 597328 Geppeson, Randolf, of Leke, husbandman 0
4805578 2297957 2297957 defendant Leverton John yeoman 597328 597328 Leverton, John, of Leke, yeoman 0
4813941 2300471 2300471 defendant Gryffyn John herdman 597328 597328 Gryffyn, John, of Leke, herdman 0
4825562 2304033 2304033 defendant Pynchebek John laborer 597328 597328 (Pynchebek, John, of Leke, laborer 12
4825563 2304033 2304033 defendant Puttok Anne widow & formerly wife of John Puttok 597328 597328 Puttok, Anne, of Leke, widow & formerly wife of John Puttok 13
4867528 2316812 2316812 defendant Pynchebek John husbandman 597328 597328 Pynchebek, John, of Leke, husbandman 3
4869500 2317428 2317428 defendant Pynchebek John   597328 597328 Pynchebek, John, of Leke, "coser" or horse courser 3
4895172 2325151 2325151 defendant Elrode John clerk 597328 597328 Elrode, John, of Leke, clerk 2
4895173 2325151 2325151 defendant Bedemaker John yeoman 597328 597328 Bedemaker, John, of Leke, yeoman 3
4897476 2325872 2325872 defendant Colvyle Thomas chaplain 597328 597328 Colvyle, Thomas, of Leke, chaplain 0
4906985 2328761 2328761 defendant Glover William clerk 597328 597328 Glover, William, of Leke, clerk 1
4906986 2328761 2328761 defendant Balle Thomas yeoman 597328 597328 Balle, Thomas, of Leke, yeoman 2

Next page

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);