names

112 rows where place_id = 600491

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641232 1907710 1907710 plaintiff Bere William   600491 600491 Bere, William, of Lyskerd 0
3680977 1920130 1920130 plaintiff Scote Thomas (legal representative) 600491 600491 Scote, Thomas, of Lyskerd, executor of 0
3680979 1920130 1920130 defendant Leen John husbandman 600491 600491 Leen, John, of Lyskerd, husbandman 0
3721018 1932871 1932871 defendant Hockyn John husbandman 600491 600491 Hockyn, John, of Lyskerd, husbandman 1
3721019 1932871 1932871 defendant Marke John husbandman 600491 600491 Marke, John, of Lyskerd, husbandman 2
3721020 1932871 1932871 defendant Roger William husbandman 600491 600491 Roger, William, of Lyskerd, husbandman 3
3736762 1937748 1937748 defendant Mongyell John yeoman 600491 600491 Mongyell, John, of Lyskerd, yeoman 1
3744191 1940079 1940079 defendant Rithe Roger tanner 600491 600491 Rithe, Roger, of Lyskerd, tanner 0
3745339 1940448 1940448 defendant Marke William yeoman 600491 600491 Marke, William, of Lyskerd, yeoman 1
3750322 1942017 1942017 defendant Quyntrell Richard yeoman 600491 600491 Quyntrell, Richard, of Lyskerd, yeoman 0
3750323 1942017 1942017 defendant Walle Thomas yeoman 600491 600491 Walle, Thomas, of Lyskerd, yeoman 1
3750325 1942018 1942018 defendant Quyntrell Richard yeoman 600491 600491 Quyntrell, Richard, of Lyskerd, yeoman 0
3750326 1942018 1942018 defendant Walle Thomas yeoman 600491 600491 Walle, Thomas, of Lyskerd, yeoman 1
3753135 1942918 1942918 defendant Braye Thomas miller 600491 600491 Braye, Thomas, of Lyskerd, miller 0
3753136 1942918 1942918 defendant Knappe John   600491 600491 Knappe, John, of Lyskerd, mason 1
3753137 1942918 1942918 defendant Symme Thomas cobbler 600491 600491 Symme, Thomas, of Lyskerd, cobbler 2
3756369 1943962 1943962 defendant Rythe Roger tanner 600491 600491 Rythe, Roger, of Lyskerd, tanner 0
3756370 1943962 1943962 defendant Conneck Richard tanner 600491 600491 Conneck, Richard, of Lyskerd, tanner 1
3757177 1944226 1944226 defendant Hydon Thomas miller 600491 600491 Hydon, Thomas, of Lyskerd, miller 0
3757182 1944227 1944227 defendant Hidon Thomas miller 600491 600491 Hidon, Thomas, of Lyskerd, miller 0
3774684 1949812 1949812 defendant Hydon Thomas miller 600491 600491 Hydon, Thomas, of Lyskerd, miller 0
3781798 1952052 1952052 defendant Colyn Thomas tanner 600491 600491 Colyn, Thomas, of Lyskerd, tanner 0
3787561 1953898 1953898 defendant Hunte John, senior tanner 600491 600491 Hunte, John, senior, of Lyskerd, tanner 0
3787562 1953898 1953898 defendant Hunte John, junior tanner 600491 600491 Hunte, John, junior, of Lyskerd, tanner 1
3788906 1954341 1954341 defendant Ryth Richard goldsmith 600491 600491 Ryth, Richard, of Lyskerd, goldsmith 0
3794663 1956207 1956207 defendant Faunte Richard husbandman 600491 600491 Faunte, Richard, of Lyskerd, husbandman 1
3803229 1958912 1958912 defendant Adame David husbandman 600491 600491 Adame, David, of Lyskerd, husbandman 3
3803230 1958912 1958912 defendant Adam Walter husbandman 600491 600491 Adam, Walter, of Lyskerd, husbandman 4
3803232 1958913 1958913 defendant Roger John, senior glover 600491 600491 Roger, John, senior, of Lyskerd, glover 0
3803233 1958913 1958913 defendant Croppe William laborer 600491 600491 Croppe, William, of Lyskerd, laborer 1
3808654 1960587 1960587 defendant Rythe Roger tanner 600491 600491 Rythe, Roger, of Lyskerd, tanner 0
3808655 1960587 1960587 defendant Commeok Richard tanner 600491 600491 Commeok, Richard, of Lyskerd, tanner 1
3817270 1963313 1963313 defendant Roger John John glover 600491 600491 Roger, John John, of Lyskerd, glover 0
3821229 1964531 1964531 defendant Hunte John, senior tanner 600491 600491 Hunte, John, senior, of Lyskerd, tanner 0
3821230 1964531 1964531 defendant Hunte John, junior tanner 600491 600491 Hunte, John, junior, of Lyskerd, tanner 1
3826780 1966229 1966229 defendant Hyckes John cordwainer 600491 600491 Hyckes, John, of Lyskerd, cordwainer 1
3826781 1966229 1966229 defendant Kympe William tailor 600491 600491 Kympe, William, of Lyskerd, tailor 2
3826782 1966229 1966229 defendant Howton Thomas cordwainer 600491 600491 Howton, Thomas, of Lyskerd, cordwainer 3
3827943 1966605 1966605 defendant Pegyns Simon butcher 600491 600491 Pegyns, Simon, of Lyskerd, butcher 0
3832986 1968235 1968235 defendant Samwell Anne widow 600491 600491 Samwell, Anne, of Lyskerd, widow 0
3832987 1968235 1968235 defendant Webbe Nicholas husbandman 600491 600491 Webbe, Nicholas, of Lyskerd, husbandman 1
3832988 1968235 1968235 defendant Hokkyn Stephen husbandman 600491 600491 Hokkyn, Stephen, of Lyskerd, husbandman 2
3832989 1968235 1968235 defendant Coffyn Thomas yeoman 600491 600491 Coffyn, Thomas,of Lyskerd, yeoman 3
3866304 1978961 1978961 plaintiff Philyps John   600491 600491 Philyps, John, of Lyskerd 0
3879506 1983399 1983399 defendant Pekyn John husbandman 600491 600491 Pekyn, John, of Lyskerd, husbandman 0
3885444 1985386 1985386 plaintiff Bealbury John merchant 600491 600491 Bealbury, John, of Lyskerd, merchant 0
3885450 1985389 1985389 plaintiff Bealbury John, senior merchant 600491 600491 Bealbury, John, senior, of Lyskerd, merchant 0
3885452 1985390 1985390 plaintiff Bealbury John, senior merchant 600491 600491 Bealbury, John, senior, of Lyskerd, merchant 0
3889712 1986795 1986795 defendant Beny John yeoman 600491 600491 Beny, John, of Lyskerd, yeoman 0
3889713 1986795 1986795 defendant Bownecke John yeoman 600491 600491 Bownecke, John, of Lyskerd, yeoman 1
3899236 1989954 1989954 plaintiff Bealbery John merchant 600491 600491 Bealbery, John, of Lyskerd, merchant 0
3899242 1989956 1989956 plaintiff Bealbury John, senior   600491 600491 Bealbury, John, senior, of Lyskerd 0
3899244 1989957 1989957 plaintiff Bealbury John, senior merchant 600491 600491 Bealbury, John, senior, of Lyskerd, merchant 0
3899246 1989958 1989958 plaintiff Bealbury John, senior merchant 600491 600491 Bealbury, John, senior, of Lyskerd, merchant 0
3905479 1992103 1992103 defendant Phelipp Thomas yeoman 600491 600491 Phelipp, Thomas, of Lyskerd, yeoman 0
3905480 1992103 1992103 defendant Gryllys John yeoman 600491 600491 Gryllys, John, of Lyskerd, yeoman 1
3932702 2001236 2001236 defendant Foster John yeoman 600491 600491 Foster, John, of Lyskerd, yeoman 1
3932705 2001237 2001237 defendant Foster John yeoman 600491 600491 Foster, John, of Lyskerd, yeoman 1
3957093 2009549 2009549 defendant Leche Henry merchant 600491 600491 Leche, Henry, of Lyskerd, merchant 1
4022914 2032920 2032920 defendant Grosse William gent 600491 600491 Grosse, William, of Lyskerd, gent 1
4022925 2032921 2032921 defendant Grosse William gent 600491 600491 Grosse, William, of Lyskerd, gent 1
4028963 2035004 2035004 plaintiff Crewes John   600491 600491 Crewes, John, of Lyskerd 0
4028966 2035005 2035005 plaintiff Crewes John   600491 600491 Crewes, John, of Lyskerd 0
4036132 2037603 2037603 defendant Grosse William gent 600491 600491 Grosse, William, of Lyskerd, or of Duble Boyes, gent 0
4036134 2037604 2037604 defendant Grosse William gent 600491 600491 Grosse, William, of Lyskerd, or of Duble Doyes, gent 0
4057501 2045060 2045060 defendant Sampson Thomas cordwainer 600491 600491 Sampson, Thomas, of Lyskerd, cordwainer 0
4059417 2045761 2045761 defendant Groce William gent 600491 600491 Groce, William, of Lyskerd, gent 1
4068728 2049103 2049103 defendant Cornewe William gent 600491 600491 Cornewe, William, of Lyskerd, or of Okehampton, Devon, gent 0
4068876 2049158 2049158 defendant Slader Mark esq 600491 600491 Slader, Mark, of Lyskerd, or of Bath, Devon , esq 0
4068877 2049158 2049158 defendant Bennett Humphrey   600491 600491 Bennett, Humphrey, of Lyskerd, or of Bath, yeoman, servant of Mark 1
4071946 2050265 2050265 defendant Grosse William gent 600491 600491 Grosse, William, of Lyskerd, gent 0
4085547 2055102 2055102 defendant Stock Adrian esq 600491 600491 Stock, Adrian, of Lyskerd, or of Belgrave, Leics, esq 0
4085561 2055108 2055108 defendant Hechyns Dorothy widow 600491 600491 Hechyns, Dorothy, of Lyskerd, widow 1
4138153 2074012 2074012 defendant Warmothe Walter husbandman 600491 600491 Warmothe, Walter, of Lyskerd, husbandman 0
4143671 2075941 2075941 defendant Collyns Thomas husbandman 600491 600491 Collyns, Thomas, of Lyskerd, husbandman 1
4145650 2076631 2076631 defendant Bonnye Robert hysbandman 600491 600491 Bonnye, Robert, of Lyskerd, hysbandman 1
4145652 2076631 2076631 defendant Bonde Walter hysbandman 600491 600491 Bonde, Walter, of Lyskerd, hysbandman 3
4145904 2076724 2076724 defendant Hawkynge William husbandman 600491 600491 Hawkynge, William, of Lyskerd, husbandman 2
4145905 2076724 2076724 defendant Kempe John husbandman 600491 600491 Kempe, John, of Lyskerd, husbandman 3
4145911 2076725 2076725 defendant Hawkynge William husbandman 600491 600491 Hawkynge, William, of Lyskerd, husbandman 2
4145912 2076725 2076725 defendant Kempe John husbandman 600491 600491 Kempe, John, of Lyskerd, husbandman 3
4149560 2077972 2077972 defendant Aslabye Ralph merchant 600491 600491 Aslabye, Ralph, of Lyskerd, or of York, merchant 0
4149561 2077972 2077972 defendant Bowth William merchant 600491 600491 Bowth, William, of Lyskerd, or of Hampton, merchant 1
4149562 2077972 2077972 defendant Shepperde or Shepharde John   600491 600491 Shepperde or Shepharde, John, of Lyskerd, or of Bristol, ship master 2
4149563 2077972 2077972 defendant Sumpter Leonard shipmaster 600491 600491 Sumpter, Leonard, of Lyskerd, shipmaster 3
4156598 2080385 2080385 defendant Grosse William yeoman 600491 600491 Grosse, William, of Lyskerd, yeoman 0
4158960 2081200 2081200 defendant Cruse John gent 600491 600491 Cruse, John, of Lyskerd, gent 0
4158961 2081200 2081200 defendant Anstys or Austys John husbandman 600491 600491 Anstys or Austys, John, of Lyskerd, husbandman 1
4158963 2081201 2081201 defendant Hunt John yeoman 600491 600491 Hunt, John, of Lyskerd, yeoman 0
4162649 2082496 2082496 defendant Warmothe Walter husbandman 600491 600491 Warmothe, Walter, of Lyskerd, husbandman 0
4168538 2084481 2084481 defendant Collyns Thomas husbandman 600491 600491 Collyns, Thomas, of Lyskerd, husbandman 2
4169340 2084781 2084781 defendant Collinge Philip husbandman 600491 600491 Collinge, Philip, of Lyskerd, husbandman 0
4172044 2085687 2085687 defendant Leight Richard gent 600491 600491 Leight, Richard, of Lyskerd, or of Ashewater, Devon, gent 0
4322107 2137811 2137811 defendant Sweper Walter clerk 600491 600491 Sweper, Walter, of Lyskerd, clerk 1
4391777 2161869 2161869 defendant Browne John yeoman 600491 600491 Browne, John, of Lyskerd, yeoman 2
4480784 2194654 2194654 defendant Hora William   600491 600491 Hora, William, of Lyskerd 8
4945293 2340504 2340504 defendant Cosyn John, junior smith 600491 600491 Cosyn, John, junior, of Lyskerd, smith 0
4945294 2340504 2340504 defendant Cosyn Thomas smith 600491 600491 Cosyn, Thomas, of Lyskerd, smith 1
4945687 2340632 2340632 defendant Mey Robert tanner 600491 600491 Mey, Robert, of Lyskerd, tanner 0
4965319 2346549 2346549 defendant Huke John mercer 600491 600491 Huke, John, of Lyskerd, mercer 0

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