names

50 rows where place_id = 599825

✎ 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
3638420 1906839 1906839 defendant Braken Peter yeoman 599825 599825 Braken, Peter, of Kendall, yeoman 0
3638421 1906839 1906839 defendant Braken Oliver yeoman 599825 599825 Braken, Oliver, of Kendall, yeoman 1
3638422 1906839 1906839 defendant Helme Henry, junior yeoman 599825 599825 Helme, Henry, junior, of Kendall, yeoman 2
3638423 1906839 1906839 defendant Helme Henry, senior yeoman 599825 599825 Helme, Henry, senior, of Kendall, yeoman 3
3658596 1912940 1912940 defendant Johnson Christopher yeoman 599825 599825 Johnson, Christopher, of Kendall, yeoman 0
3685676 1921677 1921677 defendant Belyngham Roger   599825 599825 Belyngham, Roger, of Kendall, knight 0
3686310 1921875 1921875 defendant Precate Richard, senior yeoman 599825 599825 Precate, Richard, senior, of Kendall, yeoman 1
3686311 1921875 1921875 defendant Precate Richard, junior yeoman 599825 599825 Precate, Richard, junior, of Kendall, yeoman 2
3706687 1928376 1928376 defendant Fyrbanke Thomas clothier 599825 599825 Fyrbanke, Thomas, of Kendall, clothier 0
3730591 1935804 1935804 plaintiff Brigges Miles (legal representative) 599825 599825 Brigges, Miles, of Kendall, merchant, executors of 0
3745595 1940528 1940528 defendant Wilson Henry, junior yeoman 599825 599825 Wilson, Henry, junior, of Kendall, yeoman 0
3770483 1948451 1948451 plaintiff Smyth Henry (legal representative) 599825 599825 Smyth, Henry, of Kendall, clothman, executors of 0
3779147 1951201 1951201 defendant Slyddell Robert yeoman 599825 599825 (Slyddell, Robert, of Kendall, yeoman 2
3788259 1954125 1954125 plaintiff Smyth Henry (legal representative) 599825 599825 Smyth, Henry, of Kendall, clothmaker, executors of 0
3804601 1959379 1959379 defendant Harryson Robert chapman 599825 599825 Harryson, Robert, of Kendall, chapman 0
3804602 1959379 1959379 defendant Warton John chapman 599825 599825 Warton, John, of Kendall, chapman 1
3810409 1961146 1961146 defendant Clynche Thomas chapman 599825 599825 Clynche, Thomas, of Kendall, chapman 0
3825487 1965821 1965821 plaintiff Wylson Henry   599825 599825 Wylson, Henry, of Kendall 0
3829194 1967013 1967013 defendant Thomson Christopher mercer 599825 599825 Thomson, Christopher, of Kendall, mercer 0
3834645 1968770 1968770 defendant Fyssher Richard clothier 599825 599825 Fyssher, Richard, of Kendall, clothier 0
3834647 1968770 1968770 defendant Fyssher Joan widow 599825 599825 Fyssher, Joan, of Kendall, widow 2
3836550 1969334 1969334 defendant Hogeson Roger butcher 599825 599825 Hogeson, Roger, of Kendall, butcher 0
3865454 1978663 1978663 defendant Dawney John gent 599825 599825 Dawney, John, of Kendall, gent 0
3885170 1985291 1985291 defendant Collyng Thomas (legal representative) 599825 599825 Collyng, Thomas, of Kendall, executrix of 1
3918654 1996565 1996565 defendant Pryckard Robert clothman 599825 599825 Pryckard, Robert, of Kendall, clothman 1
3927041 1999381 1999381 plaintiff Wylson William   599825 599825 Wylson, William, of Kendall 0
3930758 2000637 2000637 defendant Barbecke Edward draper 599825 599825 Barbecke, Edward, of Kendall, draper 0
3944416 2005147 2005147 defendant More Roger chapman 599825 599825 More, Roger, of Kendall, chapman 0
3946041 2005691 2005691 plaintiff Brygg Oliver clothier 599825 599825 Brygg, Oliver, of Kendall, clothier 0
3950043 2007098 2007098 defendant Stevenson William chapman 599825 599825 Stevenson, William, of Kendall, chapman 1
3991427 2021687 2021687 defendant Wyllyamson Anthony chapman 599825 599825 Wyllyamson, Anthony, of Kendall, chapman Byndles, Peter, of Kendall, chapman 0
4056803 2044816 2044816 defendant Blacklyn Robert chapman 599825 599825 Blacklyn, Robert, of Kendall, chapman 2
4081269 2053608 2053608 defendant Helme Anthony chapman 599825 599825 Helme, Anthony, of Kendall, chapman 2
4081537 2053706 2053706 defendant Dixon Jervase chapman 599825 599825 Dixon, Jervase, of Kendall, chapman 2
4081575 2053715 2053715 defendant Smythe Thomas chapman 599825 599825 Smythe, Thomas, of Kendall, chapman 1
4081576 2053715 2053715 defendant Plomer William chapman 599825 599825 Plomer, William, of Kendall, chapman 2
4081581 2053716 2053716 defendant Kylner Nicholas chapman 599825 599825 Kylner, Nicholas, of Kendall, chapman 3
4087862 2055951 2055951 defendant Walmesley John gent 599825 599825 Walmesley, John, of Kendall, gent 2
4087863 2055951 2055951 defendant Procter Robert chapman 599825 599825 Procter, Robert, of Kendall, chapman 3
4165183 2083332 2083332 defendant Speight Richard yeoman 599825 599825 Speight, Richard, of Kendall, yeoman 1
4165184 2083332 2083332 defendant Beck John yeoman 599825 599825 Beck, John, of Kendall, yeoman 2
4165520 2083441 2083441 defendant Warrenner William hardwareman 599825 599825 Warrenner, William, of Kendall, hardwareman 0
4267367 2118722 2118722 defendant Swaynson William clothier 599825 599825 Swaynson, William, of Kendall, clothier 2
4280588 2123116 2123116 defendant Chester Thomas butcher 599825 599825 Chester, Thomas, of Kendall, butcher 0
4319372 2136882 2136882 defendant Braytwhat John vintner 599825 599825 Braytwhat, John, of Kendall, vintner 3
4459717 2188093 2188093 defendant Preston Richard de   599825 599825 Preston, Richard de, of Kendall 2
4459747 2188101 2188101 defendant Preston Richard de   599825 599825 Preston, Richard de, of Kendall 2
4574672 2223606 2223606 defendant Eldfadyr John   599825 599825 Eldfadyr, John, of Kendall 0
4659990 2248975 2248975 plaintiff de Preston John   599825 599825 de Preston, John, of Kendall 0
5599079 2534594 2534594 plaintiff Garnet John chapman 599825 599825 Garnet, John, of Kendall, chapman 0

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