names

39 rows where place_id = 586796

✎ 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
3589644 1864404 1864404 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 0
4674282 2257565 2257565 defendant Brook Smyth John yeoman 586796 586796 Brook Smyth, John, of Halveryate, yeoman 0
4679965 2259339 2259339 defendant Borne Bartholomew ploughman 586796 586796 Borne, Bartholomew, of Halveryate, ploughman 0
4791778 2293527 2293527 defendant Hoberd John yeoman 586796 586796 Hoberd, John, of Halveryate, yeoman 3
4792805 2293840 2293840 defendant Hoberd William yeoman 586796 586796 Hoberd, William, of Halveryate, yeoman 0
4798323 2295661 2295661 defendant Jullesson John yeoman 586796 586796 (Jullesson, John, of Halveryate, yeoman 8
4798324 2295661 2295661 defendant Sexteyn John yeoman 586796 586796 Sexteyn, John, of Halveryate, yeoman 9
4944891 2340393 2340393 defendant Smyth John husbandman 586796 586796 Smyth, John, of Halveryate, husbandman 1
4949796 2341926 2341926 defendant Pepir Reginald clerk 586796 586796 Pepir, Reginald, of Halveryate, clerk 2
4955087 2343473 2343473 defendant Hubberd John husbandman 586796 586796 Hubberd, John, of Halveryate, husbandman 3
4975619 2349666 2349666 defendant Smyth John husbandman 586796 586796 Smyth, John, of Halveryate, husbandman 0
5018242 2362221 2362221 defendant Pepyr Robert husbandman 586796 586796 Pepyr, Robert, of Halveryate, husbandman 1
5035799 2367327 2367327 defendant Norgate William husbandman 586796 586796 Norgate, William, of Halveryate, husbandman 1
5072551 2378277 2378277 defendant Tenewhyth Thomas husbandman 586796 586796 Tenewhyth, Thomas, of Halveryate, husbandman 1
5222968 2422434 2422434 defendant Lampet Ralph esq 586796 586796 Lampet, Ralph, of Halveryate, esq 0
5223789 2422642 2422642 defendant Pye John husbandman 586796 586796 Pye, John, of Halveryate, husbandman 3
5226583 2423438 2423438 defendant Lampet Ralph esq 586796 586796 Lampet, Ralph, of Halveryate, esq 0
5227274 2423607 2423607 defendant Lampet Ralph esq 586796 586796 Lampet, Ralph, of Halveryate, esq 0
5243050 2428171 2428171 defendant Lampet Ralph esq 586796 586796 Lampet, Ralph, of Halveryate, esq 0
5251843 2430685 2430685 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 3
5251844 2430685 2430685 defendant Tynwhyte John laborer 586796 586796 Tynwhyte, John, of Halveryate, laborer 4
5251851 2430686 2430686 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 3
5251852 2430686 2430686 defendant Tynwhyte John laborer 586796 586796 Tynwhyte, John, of Halveryate, laborer 4
5262034 2433875 2433875 defendant Lampet Ralph esq 586796 586796 Lampet, Ralph, of Halveryate, esq 0
5269657 2436236 2436236 defendant Manne William chaplain 586796 586796 Manne, William, of Halveryate, chaplain 0
5290928 2442351 2442351 defendant Pye John husbandman 586796 586796 Pye, John, of Halveryate, husbandman 0
5406643 2476968 2476968 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 2
5406646 2476968 2476968 defendant Trynnman Edmund husbandman 586796 586796 Trynnman, Edmund, of Halveryate, husbandman 5
5419794 2480835 2480835 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 2
5424729 2482355 2482355 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 0
5438277 2486382 2486382 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 1
5438280 2486382 2486382 defendant Trynman Richard husbandman 586796 586796 Trynman, Richard, of Halveryate, husbandman 4
5438286 2486384 2486384 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 2
5438289 2486384 2486384 defendant Trymman Richard husbandman 586796 586796 Trymman, Richard, of Halveryate, husbandman 5
5443464 2487956 2487956 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 0
5456186 2491765 2491765 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 0
5479165 2498791 2498791 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 3
5506283 2506880 2506880 defendant Smyth Robert husbandman 586796 586796 Smyth, Robert, of Halveryate, husbandman 4
5527390 2513147 2513147 defendant Jullys Roger yeoman 586796 586796 Jullys, Roger, of Halveryate, yeoman 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);