names

34 rows where case_id = 2535708

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5602606 2535708 2535708 plaintiff Mordaunt William     Mordaunt, William 0
5602607 2535708 2535708 defendant Reymes Oliver yeoman 609518 609518 Reymes, Oliver, of Fakenham, Norf, yeoman 0
5602608 2535708 2535708 defendant Hubert Alan baker 585869 585869 Hubert, Alan, of London, baker 1
5602609 2535708 2535708 defendant Oxenbrygge Godard   609299 609299 Oxenbrygge, Godard, of Echyngham, Sussex, knight 2
5602610 2535708 2535708 defendant Rootys Thomas gent 617673 617673 Rootys, Thomas, of Buksted, Sussex, gent 3
5602611 2535708 2535708 defendant Hamond John gent 819850 819850 Hamond, John, of Stokbrygge, Hants, gent 4
5602612 2535708 2535708 defendant Talbot John gent 585869 585869 Talbot, John, of London, gent 5
5602613 2535708 2535708 defendant Parett William yeoman 904821 904821 Parett, William, of Uplambourne, Berks, yeoman 6
5602614 2535708 2535708 defendant Stone Henry husbandman 615040 615040 Stone, Henry, of Henton, Oxon, husbandman 7
5602615 2535708 2535708 defendant Seyton Robert gent 585869 585869 Seyton, Robert, of London, gent 8
5602616 2535708 2535708 defendant Wheler Walter yeoman 904822 904822 Wheler, Walter, of Edelmeton, Herts, yeoman 9
5602617 2535708 2535708 defendant Hilton Thomas gent 585869 585869 Hilton, Thomas, of London, gent 10
5602618 2535708 2535708 defendant Bryerton Ralph   797485 797485 Bryerton, Ralph, of Malpace, Cheshire, knight 11
5602619 2535708 2535708 defendant Bell Thomas husbandman 904824 904824 Bell, Thomas, of Whatton, Lincs, husbandman 12
5602620 2535708 2535708 defendant Clyfton Robert esq 904825 904825 Clyfton, Robert, of Hoddeshale, Notts, esq 13
5602621 2535708 2535708 defendant Morewode William yeoman 904826 904826 Morewode, William, of Wombwall, Yorks, yeoman 14
5602622 2535708 2535708 defendant Hastynges Roger   904827 904827 Hastynges, Roger, of Ronceby, Yorks, knight 15
5602623 2535708 2535708 defendant Parker Henry yeoman 904771 904771 Parker, Henry, of Cloughton, Yorks, yeoman 16
5602624 2535708 2535708 defendant Norys William yeoman 606537 606537 Norys, William, of Newcastle under Lyme, Staffs, yeoman 17
5602625 2535708 2535708 defendant Grene John yeoman 598666 598666 Grene, John, of Newcastle under Lyme, yeoman 18
5602626 2535708 2535708 defendant Vernon Thomas yeoman 598666 598666 Vernon, Thomas, of Newcastle under Lyme, yeoman 19
5602627 2535708 2535708 defendant Patson Richard yeoman 598666 598666 Patson, Richard, of Newcastle under Lyme, yeoman 20
5602628 2535708 2535708 defendant Alford John     Alford, John 21
5602629 2535708 2535708 defendant Collelogh Richard     Collelogh, Richard 22
5602630 2535708 2535708 defendant Patson William     Patson, William 23
5602631 2535708 2535708 defendant Johnson William     Johnson, William 24
5602632 2535708 2535708 defendant Worseley John     Worseley, John 25
5602633 2535708 2535708 defendant Hyndeley James     Hyndeley, James 26
5602634 2535708 2535708 defendant Mawdeley James     Mawdeley, James 27
5602635 2535708 2535708 defendant Robyn John     Robyn, John 28
5602636 2535708 2535708 defendant Savage William     Savage, William 29
5602637 2535708 2535708 defendant Stephynson Robert     Stephynson, Robert 30
5602638 2535708 2535708 defendant Rede Katherine     Rede, Katherine 31
5602639 2535708 2535708 defendant Durraunt Thomas et al   Durraunt, Thomas, et al 32

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