names

28 rows where place_id = 626138

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3768242 1947707 1947707 defendant Parsele William yeoman 626138 626138 Parsele, William, of Hornecastell, Lincs, yeoman 1
3855268 1975283 1975283 defendant Copyldyke Margaret (legal representative) 626138 626138 Copyldyke, Margaret, of Hornecastell, Lincs, widow, executor of 2
3861639 1977351 1977351 defendant Weste James chapman 626138 626138 Weste, James, of Hornecastell, Lincs, chapman 2
3876920 1982519 1982519 defendant Stephynson Thomas yeoman 626138 626138 Stephynson, Thomas, of Hornecastell, Lincs, yeoman 1
3954709 2008711 2008711 defendant Benson John draper 626138 626138 Benson, John, of Hornecastell, Lincs, draper 0
3957485 2009682 2009682 defendant Brodelay or Bredley Oswold merchant 626138 626138 Brodelay or Bredley, Oswold, of Hornecastell, Lincs, merchant 0
3974968 2015807 2015807 defendant Burton James chapman 626138 626138 Burton, James, of Hornecastell, Lincs, chapman 2
4000405 2024913 2024913 defendant Elwyng Thomas merchant 626138 626138 Elwyng, Thomas, of Hornecastell, Lincs, merchant 1
4002835 2025781 2025781 defendant Kytson Joan widow 626138 626138 Kytson, Joan, of Hornecastell, Lincs, widow 1
4045020 2040674 2040674 defendant Pachitt Arthur yeoman 626138 626138 Pachitt, Arthur, of Hornecastell, lincs, yeoman 1
4045024 2040675 2040675 defendant Pachyt Arthur yeoman 626138 626138 Pachyt, Arthur, of Hornecastell, Lincs, yeoman 1
4063829 2047346 2047346 defendant Hamerton Gregory draper 626138 626138 Hamerton, Gregory, of Hornecastell, Lincs, draper 0
4095475 2058706 2058706 defendant Tashe Lancelot yeoman 626138 626138 Tashe, Lancelot, of Hornecastell, Lincs, yeoman 0
4095478 2058707 2058707 defendant Tashe Lancelot yeoman 626138 626138 Tashe, Lancelot, of Hornecastell, Lincs, yeoman 0
4152753 2079073 2079073 defendant Sacheverall Edward gent 626138 626138 Sacheverall, Edward, of Hornecastell, Lincs, gent 0
4229792 2105903 2105903 defendant Hunter John merchant 626138 626138 Hunter, John, of Hornecastell, Lincs, merchant 0
4229794 2105904 2105904 defendant Hunter John merchant 626138 626138 Hunter, John, of Hornecastell, Lincs, merchant 0
4246686 2111869 2111869 defendant Nayler Christopher mercer 626138 626138 Nayler, Christopher, of Hornecastell, Lincs, mercer 0
4259626 2116196 2116196 defendant Nayler Christopher mercer 626138 626138 Nayler, Christopher, of Hornecastell, Lincs, mercer 0
4304615 2131748 2131748 defendant Saule Robert chapman 626138 626138 Saule, Robert, of Hornecastell, Lincs, chapman 0
4338323 2143146 2143146 defendant Saule Robert chapman 626138 626138 Saule, Robert, of Hornecastell, Lincs, chapman 3
4811919 2299842 2299842 defendant Largar Richard chapman 626138 626138 Largar, Richard, of Hornecastell, Lincs, chapman 3
5087098 2382606 2382606 defendant White John merchant of the staple 626138 626138 White, John,of Hornecastell, Lincs, merchant of the staple 1
5087577 2382748 2382748 defendant Whyte John   626138 626138 Whyte, John, of Hornecastell, Lincs, erchant 0
5111848 2389855 2389855 defendant White John, senior merchant of the staple 626138 626138 White, John, senior, of Hornecastell, Lincs, merchant of the staple 0
5211822 2419196 2419196 defendant White John ostler 626138 626138 White, John, of Hornecastell, Lincs, ostler 2
5344986 2458593 2458593 defendant Brakynburgh William chapman 626138 626138 Brakynburgh, William, of Hornecastell, Lincs, chapman 3
5599080 2534594 2534594 defendant Ward William merchant 626138 626138 Ward, William, of Hornecastell, Lincs, merchant 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);